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
Work with the business analyst and end user for requirement gathering
Create datasets from EPIC clarity database based on the requirement provided
Perform unit testing of the prepared SQLs and VQLs and ensure they meet the business requirement
Create Tableau visuals using the virtualization layer of Denodo
Develop, design, and maintain Tableau dashboards and analytics
Collect, refine, and prepare data for analytics and visualization
Manage and utilize the Tableau platform to extract meaningful insights from it
Define new KPIs and consistently measure in the datasets
Drill-down data and prepare reports with utmost accuracy
Creating wireframes and beta dashboards with a focus on user experience, correctness, and visibility
Monitoring reports and dashboards and make necessary changes
Solving any data or performance issues related to workbooks and data sources
Actively manage the performance and usability of Tableau to get the desired result
Developed user stories on subject areas like Workforce management and Health equity
Create adequate backlog which can be consumed by the developers over the next two sprints
Present to the management team the team utilization report
Onsite Project Manager
Handled a team of 80 people from onsite
Was the sole point of contact for the client for all technical queries, resourcing and deliverables
Helped the account grow from 25 resources to 60 resources
Played a dual role of project manager and Scrum Master on the project
Involved with Data Profiling activities for new sources before creating new subject areas in warehouse
Implemented the agile methodologies for all the projects in the account
Conducted a daily standup with the team leads for 19 projects that were underway
Conducted scrum ceremonies like sprint planning, daily scrum, sprint review, backlog refinement and show n tell
Create the product backlog
Performed unit testing for the features developed
Offshore delivery lead/Project manager
Handled multiple DaVita projects handling a team of 60 people
Presided over the weekly and monthly dashboards calling out the risks and development in the project
Responsible for the optimum resource utilization and ensuring a good gross profit margin on the project
Responsible for the delivery of the project
Played the role of a Data Analyst & Business Analyst throughout the product implementation lifecycle
Analyzed the source data and accordingly created the source to target mapping specifications
Worked closely with business to understand the reporting requirements and create the wireframe design
Create the Frame Work Manager to enable the reporting needs
Performed extensive data cleansing, data manipulations and date transforms and data auditing
Created Cognos reports in the Reporting Manager based on the wireframe
Responsible for debugging the ETL job cycle errors
Made Informatica enhancements
Performed Unit testing for the ETL changes and Reporting changes
Worked closely with the QA team to overcome the issues reported by them
ETL developer
Worked as a Data Modeler and was responsible for creating the model for different subject areas of FLEET
Presided over the Data Architecture review calls to ensure the design was given a sign off for further development
Created DDL scripts for implementing Data Modeling changes
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
Created the database design structure and ETL mapping specifications
Responsible for determining the load strategy based on the source data analysis
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
Was the direct point of contact for the QA team (external vendor) for all subject area related queries and observations
Worked with the reporting team to create the reporting wireframes
To assist the business in making better decisions, develop and analyze essential reports
Created bteqs to load the data from the EDW to AWS layer for reporting
Application and Database developer
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
Participate in meetings to come up with new performance test scenarios
Involved in creating test strategies, writing test plans, estimating test efforts, managing test efforts
Fixing issues related to SQL, PI/SQL, SAP BW and escalating the code and data issues to functional teams
Create Requirements using Quality center and generate traceability Matrices to ensure that all the requirements are covered by test cases
Application developer
Created the Technical requirement document for OPAL application
Responsible for making Informatica, database, Unix and Mainframe changes for existing OPAL correspondence jobs or adding new correspondence to the existing OPAL application
Tested the ETL process for both before data validation and after data validation process
Tested the messages published by ETL tool and data loaded into various database
Added new messages to the application by creating SQL scripts
Primary point of contact for any job failures for the application
Business Objects report writer
Analyzed and translated Functional Specifications and Change Requests into Technical Specifications for report creation
Ran SQL queries for data validation and performed quality analysis on data extracts to ensure data quality and integrity across various database systems
Responsible for defining the naming standards for data warehouse
Involved in Data mapping specifications to create and execute detailed system test plans
Responsible for creating new FlexCube reports and making changes to the existing one
Responsible for making changes to the Business Objects universe design
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