· Served as a primary point of contact for multiple concurrent projects for multiple clients who hail from wide variety of industries/domains.
· Provided technical leadership and conducted brainstorming sessions with design and architecture teams.
· Mentored Project Managers and helped in accomplishing the project related goals.
· Facilitate working group meetings with key stakeholders and be a lead spokesperson in status meeting with senior management.
· Sales team enablement by educating sales team on DW/BI capabilities, solution offerings and opportunities to look for to make inroads into new accounts or mine existing accounts
· Spearheaded strategic project which included implementation of Test Automation Framework, Real time Data streaming & Data engineering projects.
· Articulate risks, issues, budgeting challenges and upcoming project planning summary in a clear and concise manner via weekly biweekly, and/or monthly reports to stakeholder/executives at all levels.
· Solution architecture design reviews and data model architectural design reviews
· Demonstrate results orientation, collaboration, flexibility, and adaptability to provide direction, coaching, and support to team members enhancing current job skills, developing leaders, and preparing staff for next level career opportunities.
· Collaborated with clients through the decision-making process and gained consensus to reach sign off.
· Initiation and planning for entire project across different releases.
· Managed various projects like Data Platform Modernization, Data Migration, BI Migration, ETL Migration, Quality Assurance and projects involving latest Data engineering practices.
· End to end project plans to track milestones & delivery timelines to further track and escalate project risks, issues, dependencies, control gaps.
· Manage program project benefits, ensure consistent delivery of benefits throughout project lifecycle through vigilantly monitoring and controlling change management.
· Performed independent verification and validation and advising to ensure project adheres to best practices and promoting acceptance of global department-wide BI solutions.
· Design, Development and Testing of the ETL’s.
· Technical Guidance and mentoring to the Offshore team members.
· On time completion of tasks and project per quality goals
· Project management
o Planning resources required effort estimates and scheduling.
o Task allocation and tracking to completion.
o Reviewing of weekly status consolidation of status, escalation of issues and any replanning
o Identify risks, prioritize the risk, and plan mitigations.
· User/stakeholder interaction
o Working with clients on requirement based on their business needs.
o Interact with stakeholders for the various deployment projects understand their expectations plan timelines and allocate resources to development and delivery.
o Communicate deliverable status to user stakeholder’s client and drive periodic review meetings
· Designed and developed of software components related to all aspects of data sourcing transformation data quality and reporting using standard ETL, EDW and BI technologies.
· Collaborated with production support team and software engineering resources to deliver high quality deployments that met department and customer expectations for quality and scheduling.
· Developed complex retail queries testing the retail flows database tuning and data modeling.
· Responsible for creating and maintaining ODS, EDW staging and EDW tables and mappings to populate table.
· Design and develop different RDBMS systems and BI interfaces to perform ETL operations on a wide variety of data sources.
· Development of Abinitio graphs and plans, Writing shell scripts.
· Updating checklist, review logs, defect logs and unit test cases
· review and analyze the graphs to improve performance.
· Prepare knowledge transition documents.
Customer Management
Strategic Planning & Thinking
Risk Management
Annual Budgeting
Project Planning
Decision-Making
Data Platform Modernization
Data/BI migration
Business intelligence
Quality Assurance
Domain: Financial Services, Health Care Insurance, Life Science/Pharmaceuticals, Retail, E-Commerce
Cros Functional Areas: Data Warehouse & Big Data, Consolidation and Migrations, Application Migrations, Data Migration, BI Migration, Cloud Migration, Quality Assurance and Best Practices.
Databases: Teradata, Oracle, MySQL, MSSQL Server, AWS S3, Redshift, Snowflake, Postgres
Cloud: AWS, Azure, GCP
ETL : ADF, Databricks, Ab Initio, Talend Open Studio, Informatica PowerCenter, Fivetran, AWS Glue, Cloudera
BI Reporting Tools: Tableau, Amazon Quicksight, Power BI, Sisense, Cognos, MicroStrategy, QlikSense
Languages: C, C++, SQL
(Finance)
Teradata to AWS Migration, End-to-End Business Intelligence Solution for HR , Consumer Lending and Banking, Card member financial reporting, Decision Data Sourcing,
Environment/Tools: Abinitio, Teradata, Hadoop, AWS S3, AWS Redshift, ER Studio, Tableau, Python, Crontab, Autosys
(Healthcare)
Data Platform Modernization,
Environment/Tools: FiveTran, dbt SQL, Azure Data Lake, Databricks, Snowflake, Azure
(Retail)
Data Quality Framework, Application migration, Test Automation Framework
Environment/Tools: Informatica IDQ, Informatica, CA DevTest, Selenium,
(E-Commerce)
BI Tool migration
Environment/Tools: Amazon Quicksight, Amazon Redshift, Datanet, Tableau
(Healthcare)
Data Migration and Analytics
Environment/Tools: Databricks, Snowflake, Python, PySpark, Redshift, AWS S3, EMR, Glue, AirFlow