Senior Data Solutions Architect

• Aug 2021 - Present

• Own the end to end desing and development for all client reports/extracts • Desing data warehouse/mart for all the BI need by integrating and normalizing the data from various sources • Work with C level stakeholders to understand the strategic initiatives and define data solution path to meet their goals • Partnered with client to understand their data requirements for their analysis and reporting need • Provide guidance to data engineers on client data ingestion need • Client data SME for the reporting and analytics • Define the data flow and format for all the external data exchange with clients and vendor • Closely work with various stakeholders/teams to meet their data requirements - like Marketing/Client Partners • Perform analysis on the data to respond to various queries from the client or leadship • Design and develop ELT/ETL models for the data warehouse/mart usign DBT scripts • Manage the Github for all the reporting marts and deployment workflows • Establish data life-cycle process to archive/purge the data from Bigquery/cloud storage • Manage the data encrytion and data retation policies as defined • Create and maintain billing engine to create billing file/extracts • Design and develop dashboards for C level stakeholders Show less

Sr. Architect and Delivery Lead

• Nov 2014 - Aug 2021

Data Architect • Responsible for designing and maintaining an data architecture for all the data integration projects for sharing the data with external vendors. • Developing and implementing data architecture strategies, frameworks, and standards to align with the organization's goals and objectives. • Analyzing data needs/requirements, and designing data models (data warehouse and data marts), data flows, and data storage solutions. • Ensuring building reusable and scalable data solutions to onboard new clients/vendors • Review and create ETL and Dataflow designs and code • Implementing data governance processes and procedures to ensure data quality and accuracy. • Ensuring data architecture supports data analytics, business intelligence and other canned reporting requirements • Build reusable error reporing and analysis framework to help data governance team to fix the data issues • Staying current with new technologies and industry trends related to data architecture and making recommendations for updates and improvements • Mentoring and coaching junior data architects and providing technical guidance to the wider organization • Communicating data architecture designs, standards and best practices to the stakeholders and implement them Delivery Lead/Manager • Developing project plans and schedules, including resources, time and budget estimates • Managing data/software engineers and analyst, including assigning tasks and monitoring progress • Defining project scope, deliverables, change requests for the SoW/amendment • Ensuring project quality and ensuring that deliverables meet customer requirements • Communicating project status, risks and issues to stakeholders and collaborating with them to find solutions • Work with various stakeholders in the organization to put up the risk mitigation plan • Ensuring that project processes are followed, and continuously seeking ways to improve them • Managing budgets, expenses and budget Show less

Senior Delivery Lead and Architect

• 2014 - Aug 2021

Responsible for managing the delivery for multiple small and medium programs. Also working as ETL/Data architect for few critical programs. Responsible for managing the delivery for multiple small and medium programs. Also working as ETL/Data architect for few critical programs.

Senior Architect

• 2013 - 2014

• Design data models to enable BI team build dashboard for various client stakeholders • Provide technical consultations to draft the new proposals or respond to the RFP queries • Lead a team of data engineers and manage the delivery of Data Integration/Migration projects • Design data models to enable BI team build dashboard for various client stakeholders • Provide technical consultations to draft the new proposals or respond to the RFP queries • Lead a team of data engineers and manage the delivery of Data Integration/Migration projects

Sr. Technical Architect and Delivery Manager

• Jun 2010 - Dec 2013

• Design and Develop Data Integration Solutions • Dimensional data modeling for implementation of various data warehouse and data marts solutions for various clients • Lead Informatica center of excellence to establish Informatica best practices across projects and train junior resources • Propose solutions data integration, data migration, platform migration to responds to various RFPs • Manages End to End delivery of Data Integration and Data Migration programs for multiple clients • Managing finance (invoicing and resource forecasting) for all of my programs • Evaluate the change request for cost and schedule impact • Prepare program metric and status to present to senior leadership and client stakeholders Show less

Technical Manager

• Nov 2007 - Jun 2010

Senior ETL Analyst

• 2009 - 2010

ETL Sr. Analyst

• Jun 2007 - Nov 2007

Data Integration Engineer

• Nov 2006 - Jun 2007

Programmer Analyst

• May 2000 - Nov 2006