About Me
Around 20 years of experience as a ETL and BI architect and manager having worked on various Etl and BI reporting tools
Responsible for successful implementation of the SDLC and delivery of the final product
Managed a t…
Around 20 years of experience as a ETL and BI architect and manager having worked on various Etl and BI reporting tools
Responsible for successful implementation of the SDLC and delivery of the final product
Managed a team of 60 people from offshore and was the sole point of contact for the customer
Using agile methodology values, principles, and practices to plan, manage, and deliver solutions.
Training, mentoring, and supporting scrum teams to follow agile values, principles, and practices.
Led a cross-functional team of developers and designers in delivering a complex software project, exceeding project goals and delivering the product 2 months ahead of schedule. Utilized Scrum methodology and consistently facilitated effective sprint planning and retrospective meetings to drive progress.
Implemented a continuous improvement program, resulting in a 25% increase in team productivity and a 50% reduction in rework.
Successfully coached and mentored team members, resulting in a 50% increase in employee engagement and satisfaction.
Managed the delivery of a high-visibility, enterprise-level project, successfully delivering it within budget and on time.
Successfully negotiated and managed project dependencies, resulting in a 20% reduction in project risk.
Implemented an agile metrics program to measure and improve team performance, resulting in a 15% increase in team efficiency.
Managing the cloud migration for various clients including cloud technologies like GCP and Azure
Experience
Data Engineer
- Develop pipelines to move data from on premise to cloud
- Develop pipelines to move data from on premise to cloud
-Create the database structure in cloud and then unit test the data post load
-Create the database structure in cloud and then unit test the data post load
Project Manager/ Scrum Master
<p>Work with the business analyst and end user for requirement gathering<br>
Create datasets from EPIC clarity database based on the requirement provided<br>
Perform unit testing of the prepared SQLs and VQLs and ensure they meet the business requirement<br>
Create Tableau visuals using the virtualization layer of Denodo<br>
Develop, design, and maintain Tableau dashboards and analytics<br>
Collect, refine, and prepare data for analytics and visualization<br>
Manage and utilize the Tableau platform to extract meaningful insights from it<br>
Define new KPIs and consistently measure in the datasets<br>
Drill-down data and prepare reports with utmost accuracy<br>
Creating wireframes and beta dashboards with a focus on user experience, correctness, and visibility<br>
Monitoring reports and dashboards and make necessary changes<br>
Solving any data or performance issues related to workbooks and data sources<br>
Actively manage the performance and usability of Tableau to get the desired result<br>
Developed user stories on subject areas like Workforce management and Health equity<br>
Create adequate backlog which can be consumed by the developers over the next two sprints<br>
Present to the management team the team utilization report</p>
Onsite Project Manager
<p>Handled a team of 80 people from onsite<br>
Was the sole point of contact for the client for all technical queries, resourcing and deliverables<br>
Helped the account grow from 25 resources to 60 resources<br>
Played a dual role of project manager and Scrum Master on the project<br>
Involved with Data Profiling activities for new sources before creating new subject areas in warehouse<br>
Implemented the agile methodologies for all the projects in the account<br>
Conducted a daily standup with the team leads for 19 projects that were underway<br>
Conducted scrum ceremonies like sprint planning, daily scrum, sprint review, backlog refinement and show n tell<br>
Create the product backlog<br>
Performed unit testing for the features developed</p>
Offshore delivery lead/Project manager
<p>Handled multiple DaVita projects handling a team of 60 people<br>
Presided over the weekly and monthly dashboards calling out the risks and development in the project<br>
Responsible for the optimum resource utilization and ensuring a good gross profit margin on the project<br>
Responsible for the delivery of the project<br>
Played the role of a Data Analyst & Business Analyst throughout the product implementation lifecycle<br>
Analyzed the source data and accordingly created the source to target mapping specifications<br>
Worked closely with business to understand the reporting requirements and create the wireframe design<br>
Create the Frame Work Manager to enable the reporting needs<br>
Performed extensive data cleansing, data manipulations and date transforms and data auditing<br>
Created Cognos reports in the Reporting Manager based on the wireframe<br>
Responsible for debugging the ETL job cycle errors<br>
Made Informatica enhancements<br>
Performed Unit testing for the ETL changes and Reporting changes<br>
Worked closely with the QA team to overcome the issues reported by them</p>
ETL developer
<p>Worked as a Data Modeler and was responsible for creating the model for different subject areas of FLEET<br>
Presided over the Data Architecture review calls to ensure the design was given a sign off for further development<br>
Created DDL scripts for implementing Data Modeling changes<br>
Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle<br>
Created the database design structure and ETL mapping specifications<br>
Responsible for determining the load strategy based on the source data analysis<br>
Worked closely with a team of ETL developers to ensure that the design and loading strategies were developed as per the requirement and design specifications<br>
Was the direct point of contact for the QA team (external vendor) for all subject area related queries and observations<br>
Worked with the reporting team to create the reporting wireframes<br>
To assist the business in making better decisions, develop and analyze essential reports<br>
Created bteqs to load the data from the EDW to AWS layer for reporting</p>
Application and Database developer
<p>Analyzed the Business and Technical requirements by interacting with business users and developed test plan and test strategy for functional and performance testing of each phase of code modifications<br>
Participate in meetings to come up with new performance test scenarios<br>
Involved in creating test strategies, writing test plans, estimating test efforts, managing test efforts<br>
Fixing issues related to SQL, PI/SQL, SAP BW and escalating the code and data issues to functional teams<br>
Create Requirements using Quality center and generate traceability Matrices to ensure that all the requirements are covered by test cases</p>
Application developer
<p>Created the Technical requirement document for OPAL application<br>
Responsible for making Informatica, database, Unix and Mainframe changes for existing OPAL correspondence jobs or adding new correspondence to the existing OPAL application<br>
Tested the ETL process for both before data validation and after data validation process<br>
Tested the messages published by ETL tool and data loaded into various database<br>
Added new messages to the application by creating SQL scripts<br>
Primary point of contact for any job failures for the application</p>
Business Objects report writer
<p>Analyzed and translated Functional Specifications and Change Requests into Technical Specifications for report creation<br>
Ran SQL queries for data validation and performed quality analysis on data extracts to ensure data quality and integrity across various database systems<br>
Responsible for defining the naming standards for data warehouse<br>
Involved in Data mapping specifications to create and execute detailed system test plans<br>
Responsible for creating new FlexCube reports and making changes to the existing one<br>
Responsible for making changes to the Business Objects universe design<br>
Involved in SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved based on using defect reports for any existing/new report</p>