Highly organized and self-motivated professional with 12+ years of experience in project management, team development and process improvement. Skilled in developing and implementing strategies to increase efficiency and performance. Passionate about driving business growth and creating positive work environment.
Hands on experience of implementing data management solutions covering data security, data privacy, metadata management, multi-tenancy and mixed workload management across Hadoop and NoSQL platforms, spanning on-premise and Cloud based deployments.
Excellent understanding of data modeling & traditional DWH concepts.
Proven experience of assisting senior leadership in managing all aspects of project & account management.
Good exposure of creating techno-functional presentations,response to proposals & leading client discussions.
Overview
13
13
years of professional experience
Work History
Associate Director
PwC India
07.2017 - Current
Defined, designed and implemented data access patterns for multiple analytical and operational workloads, across on-premise and Cloud based platforms.
Evaluated new age big data tools, executed proof-of-concepts , recommended and adopted tools based on project needs.
Automated metadata driven configuration based high speed ETL / ELT solutions.
5+ successful project deliveries in BFSI sector.
Good functional understanding of onboarding , management , servicing , regulatory reporting & collection journey's in BFSI domain.
Led 20+ cross-functional team to architect and deliver enterprise-level platform solutions for the data and analytic use case.
Analyst I - Apps Prog
BA Continuum India Private Limited
12.2015 - 07.2017
Developed & designed a centralized data store and reporting platform using hadoop ecosystem to serve regulatory reporting needs for Basel ,CCAR,CECL,IFRS9.
Designed, delivered end to end data sourcing, reporting ETL’s & various vap jobs. Migrated the SAS analytic code to Hadoop.
Major contributor in Data Quality Framework and SLA dashboard.
Senior Technology Analyst
ZS Associates
08.2014 - 12.2015
Demonstrated ability to translate business strategy to information technology strategy and tactical plans.
Managed project teams to deliver solutions with members from United States, India, and Europe offices.
Led business requirements gathering and design of analytical dashboards, reports, and visualizations which offer fast insights from multiple data sets.
Lead developer for one of the product which recommends suggestions to MR’s so that they can have a quality meeting with the physicians.
Associate Consultant
Capgemini
02.2013 - 07.2014
Actively involved in the data modelling and design of the data warehouse with Data Architect,
Architected and developed TPT, FLoad, MLoad, Fast Export, BTEQ and Datamover scripts, developed macros and stored procedures.
Migrated Oracle procedure and objects Triggers, Functions, views Procedures to Teradata equivalent objects/code to get the same Functionality as oracle.
Used Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
Using explain plan, view point, Teradata manager (td 12) analyzed and modified indexes and modified queries with volatile or temporary tables to improve the performance.
Software Engineer
Wipro Infotech
08.2010 - 02.2013
Extensively worked on Teradata & Netezza.
Orchestrated Workflows using Unix shell scripting.
Developed End to End ETL/ELT pipelines for reporting requirements.
Developed a 2 way recon process to validate the data between switch & EDW.
Education
Bachelor of Engineering - Computer Science
Chandigarh College Of Engg. & Tech. - PU
Chandigarh
06.2010
High School - Non Medical
GMSSS 46 D
Chandigarh
03.2006
Secondary School - General
Shishu Niketan Senior Secondary School
Chandigarh
03.2004
Skills
Functional Skills
Project planning and cost estimations
Client Coordination
Analyzing and gathering requirements
Project documentation like Plans , BRD , HLD , LLD , Release Plan etc
Project Management
Technical Skills
Databases: Teradata, Netezza, Vertica, Oracle Data Modelling: Erwin Basics, Visio