Hyderabad, Telangana, India
Self-motivated, organized, and efficient data engineer and analyst with relevant technology experience and data processing skills. Data-driven and analytical innovator with excellent problem-solving skills, business acumen, and passion for contributing to large-scale data ingestion and research initiatives. • 13+ years of overall IT experience into Data warehouse development building pipelines from various data sources like Flat Files, Snowflake, Teradata, Oracle & SAP Hana. • 1 year of working experience with Tableau reporting. • Through Knowledge on the Data science, Predictive Analytics, Machine Learning, Deep learning. o Data Wrangling: Well versed in data cleansing, pre-processing, blending, pivoting, reshaping and scaling through various Python libraries such as Pandas, NumPy, Scikit learn etc. to build data frames. o Machine Learning Models: Profound understanding of all the machine learning algorithms such as linear, logistic regression, Random Forest, Naïve Bayes, K-Means.
• Analyzing the Business Needs and identifying its impact to the Key Recurring Revenue KPI’s. • Responsible for the progression and regression validations to the IACV/Recurring Revenue KPI’s. • Supporting the Finance/Sales Business Operation Teams. • Worked on POC’s using Production data to identify the % Change to the critical IACV/Recurring Revenue KPI’s before going live. • Profound Knowledge of the key functional areas. ATR, IACV Bookings/Legal Bookings, QRR.
Responsibilities: • Analyzing the Business Need & Identifying the KPI’s. • Creating the model. • Developing the Snowflake pipelines to load the entities enabled as part of the model. • Creating Tableau worksheets and the dashboards for Summary & Detailed Reports. • Created Univariate & Multi Variate Linear Regression Models for the Business Operations teams to identify the patterns, to serve the partners efficiently.
Responsibilities: • Visualized & Designed the Model in Data Lab. • Analyzed the Cisco Install Base to extract the Service/CX ATR Data & Renewal Booking to ATR Lineage. • Created pipelines to extract ATR data & booking to ATR lineage into the Teradata. • Created pipelines to extract Service Bookings and Associate the same to the respective ATR. • Enabled the Key Recurring Revenue /IACV Metrics. o Dollar Renew o UPSELL o NEW • Created the aggregated reports to support finance teams on goal sheet generation. • Created the aggregated reports to support sales teams for compensating the Renewal Manager for Renewal Business and Account Manager for new business.
Contribution: • Source System Analysis: Understanding the scope of the Project and technical modeling, Analyzing the specifications and requirements provided by the clients, Analyzing new or additional requirements or business functionality that needs to be implemented and how, when and where these can be implemented. • Involvement in the preparation of the Specifications by performing competitive analysis as per High level design methodology. • Design and Development of Dataflow using MetaLoad using the Sqoop and Hive QL. Reviewing the Code to make sure it is developed according to the Specifications provided by the Client. • Supporting the UAT, BAT and helping the testing teams in testing the application against the test cases. • Bug Fixing. • Preparing the code deployment plan and supporting the deployment activities. • Documenting the High level design, low level design, technical design documents. • Documenting the test plan and deployment plan. • Worked on End to End migration of SBP/OPL application from Hadoop to Snowflake and ensuring the jobs are meeting the SLA's defined in the system so as to give minimum impact to the Business Users.
Contribution: • Prepared ETL Mapping Document for Dimension, Fact and Aggregate tables. • Coded Queries for Dimension, Fact and Aggregate population. • Developed ETL mappings for Dimensions and Facts and Aggregates and Performed Unit Testing. • Ensuring Data Quality in the newly Build Ware house Aggregate tables. • Giving solution for the Data discrepancies in Fact and Aggregate tables. • Identifying the root cause for the defect and suggest necessary changes. • Testing and recording test results with strict adherence to Quality Procedure.
Contribution: • Preparation of SSA on the basis of the SDR provided by LDM Team. • Validation of SSA with the LDM. • Developed ETL mappings for getting the data from Source-WebEx Databases to Target Cisco Enterprise Data Warehouse (EDW) and performed Unit Testing. • Coded Queries for Work (Intermediate) Table population. • Creation of BTEQ’s for History Loads of 3NF Table’s. • Tracking and ensuring timely deliveries as per schedules committed to the client. • Ensure quality of the deliverables as per SLA and maintenance standards agreed upon.
Contribution: • Analysis of Existing system. • Prepared ETL Mapping Document and Technical Design Document (TDD). • Coded Queries for Dimension, Fact and Aggregate population. • Developed ETL mappings for Dimensions and Facts and Aggregates and Performed Unit Testing. • Interaction between team members, Onsite coordinator. • Ensuring timely and defect free delivery.