SUMMARY:

• Over 18+ years of extensive IT experience in design, development, testing, maintenance and documentation of Enterprise Data Warehouse and BI applications using various technologies with diverse set of client’s analyzing complex business requirements and mapping them to the system specifications.
• An expert level data architect with extensive database system analysis, design, and implementation experience.
• Extensive experience in requirements gathering and business rules analysis, conceptual/logical/physical database, model validation/business rules traceability analysis.
• Been an integral part of every phase (analysis, design, testing, implementation) of database projects using every common type of data store - transactional (OLTP), ODS, data warehouse (Kimball/Inmon), and Data Mart (OLAP).
• Hands on database system construction experience to include stored procedure construction and testing, extraction/transformation/loading (ETL) design and implementation, report development, database system troubleshooting and performance tuning, database configuration and administration.
• Focus on bridging the “business-technology gap” that seems to appear in many organizations by simultaneously acting as a liaison between the two “worlds”, demonstrating/facilitating more formalized business functionality requests, building trust, focusing on delivering business value as quickly as possible, and developing/mentoring technical teams such that they are more aware of business needs and, often, the more advanced analysis/design/development techniques needed to meet those needs.
• Working knowledge of Big Data Eco System.
• Strong skills on project planning and management, monitoring, control and team building, strong leadership qualities. Ensure the appropriate metrics, resource planning and program management methodologies are applied to drive success
• Drive the usage of SDLC, Agile, and other key measures to significantly improve project delivery.
• Providing operational management overview and drive productivity improvement initiatives.
• Proven ability in leading complex data loads and huge volumes of data (TB to PB in Teradata, Oracle Exadata,Ver tica and Netezza)
• Proven ability in Designing, Optimal Performance and Scheduling of Report Packages in a Reporting Environment . Migration of Reports from Legacy Platforms and also migration between Reporting Tech stacks
• Professional in creating prototypes (Static & dynamic UI with HTML 4), Mock-up wireframes , POC’s (Proof of concept - Third Party Software’s/Technology packages) and story boarding for risk minimization.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Vice President

Responsibilities:

• Involved in the technical design discussions to develop the application in the team environment.
• Single point of contact for Business & Business Analysts, as far as the queries related to the requirements and designs.
• Logical and Physical Modeling using Canonical Models to fit the needs of the requirements
• Implemented the end to end ETL / BI Design Standardization across different teams
• Rollout of Vertica Analytical Data Store for Transactional data from ~250 Application Source Systems and Processed data (US BASEL III Results, US Call Reports, EMEA Liquidity Reporting etc)
• Implemented Standardization of Verica data loads according to Volumes (MB to Terabytes) of Data.
• Setup Best Practices of usage of Vertica and Pentaho ETL tools
• Managed the AxiomSL Vendor Relationship and executed 1M SOW which comprised of initial setup of Servers and Rollout of the CCAR 14A/14Q & 14M Reg Reports
• Build Canned Reports/Dashboards using AngularJS & Rest API’s.
• Rollout of Self-Service Reporting capabilities using Open source JasperSoft Reporting toolset for Operational Reporting Needs
• Provide effort & cost estimations for the requirements and build the project plan (including the resource wise timeframe for prototype development, unit testing, UAT, performance testing)
• Managed a 4 Member Onshore and 6 Offshore development team comprised of ETL, UI and BA’s

Confidential

Consultant - BI Architect

Responsibilities:

• Involved in the technical design discussions and design/develop the Data Marts/Operational Data Stores in the team environment.
• Logical and Physical Modeling of the Data Marts/Operational Data Stores to fit the needs of the requirements
• Rollout of Vendor Scorecard/Dashboard of all the Sirius XM Call Centers (Inbound, Outbound & Care )
• Prototyping of the Software AG’s OneData Application to implement the Reference Data implementation for Reporting/Marketing team needs.
• Design of the Party Model to manage all the Customer information and Mastering the data working with Agility vendor partners.
• Support the canonical layer for Campaign Management Tool
• Rollout of Vertica Analytical Data Store/Lake for Customer 360 Reporting . Data Ingestion Framework to source all data from different EDW/ODS (Teradata)

Confidential

Vice President

Responsibilities:

• Involved in the technical design discussions to develop the application in the team environment.
• Single point of contact for Business & Business Analysts, as far as the queries related to the requirements and designs.
• Logical and Physical Modeling extending the IBM BDW Model to fit the needs of the requirements
• Coordinated the data mapping, cleansing rules and data migration capabilities in support of Customer MDM initiatives.
• Implemented the end to end ETL Design Standardization across different teams
• Implemented Standardization of Teradata (TPT Streams) according to Volumes (MB to Terabytes) of Data.
• Setup Best Practices of usage of Teradata and Informatica using PDO’s
• Provide effort & cost estimations for the requirements and build the project plan (including the resource wise timeframe for prototype development, unit testing, UAT, performance testing)
• Offshore Co-ordination of the Development Work
• Application Development Management of the ~40 FTE ETL/Reporting FTE Team plus 45 member Vendor Resources

Confidential

Assistant Vice President

Responsibilities:

• Logical and Physical Modeling Data Modeling of the Data Mart
• End to End Solution Architecting /ETL Designer
• Single point of contact for Business & Business Analysts, as far as the queries related to the requirements and designs are concerned.
• Coordinated the data mapping, cleansing and data migration capabilities in support of Customer MDM initiatives.
• Provide effort & cost estimations for the requirements and build the project plan (including the resource wise timeframe for prototype development, unit testing, UAT, performance testing) in MPP
• Headed Architecture/Design Review Panels across different projects
• Offshore Co-ordination of the Development Work
• Managed and Executed RFP’s working with Vendor groups to setup a team from bottom-up
• Managed 24/7 Application Support team supporting 35 BI/DW Application/Outbound teams
• Application Development Management of the 18 ETL/Reporting FTE Team plus 45 member Vendor Resources

Confidential

Senior Architect - Technical Delivery Assurance - DW BI Practice

Responsibilities:

• Delivery management - Process, Quality & track CDI ( Customer Delight Index)
• Headed Review Panels ( Data Modeling, Design and Code) across projects
• Setup Technical Domain Based training curriculums for the entire Practice
• Pre- Sales support

Confidential

ETL Designer/Architect

Responsibilities:

• Logical and Physical Modeling Data Modeling of the Data Mart
• End to End Solution Architecting /ETL Designer
• Offshore Co-ordination of the Development Work
• Performance Tuning of Informatica Mapping

Confidential

BI Data Architect

Responsibilities:

• Building Infrastructure for the Reporting Platform
• Design and Develop ETL’s / Reports & Dashboards
• Extensively designed the ETL’s using SSIS for the integration of the different data sources
• Extensively designed the Business Objects XI & SSRS 2005 Reporting Platforms
• Integrated Report Delivery with Microsoft Share Point Document Management as well
• Created Processes and Escalation Procedures around the DW Operations

Confidential

Senior ETL Consultant - Open Systems

Responsibilities:

• Involved in Re-architecturing the current ETL’s and performance tuning the current processes
• Extensively designed the ETL’s using Informatica for the integration of the different data sources
• Created Processes and Escalation Procedures around the DW Operations
• Involved in Performance Tuning the Models by adding respective Indexes etc.
• Involved in Architecturing the process and prepared the relevant Technical Specs for the entire Project implementation.
• Co-ordinated the effort of putting in WSDL’s for the Outbound process and providing it as a Web Service using Informatica 8.1.0 Webservices Hub.

Confidential

ETL Designer/Architect

Responsibilities:

• Data Modeling /Architecting the DW/Data Marts
• Change Control/ Production Support Management
• Production Migration of Informatica and Oracle Objects
• Created Processes and Escalation Procedures around the DW Operations
• Admin to the Informatica Repository and maintenance of Informatica product
• Offshore Co-ordination of the Development Work
• Supported Daily Operations(Production Support) with the team of 12 people
• Performance Tuning

Confidential

AVP - ETL Designer/Architect

Responsibilities:

• Actively participated with Business for the initial design phases.
• Built Advanced Logical and physical DM around Star Schema models from the requirements.
• Maintained the Models in Erwin 4.1.4 Data Modeler /Model Manager
• Co-ordinated and lead the ETL development Team with the help of Offshore/Onshore teams
• Extensively used Informatica for the integration of the different data sources
• Upgraded Informatica 6.x to 7.x version
• Admin to the Informatica Product within the group
• Created Processes and Escalation Procedures around the DW Operations
• Supported Daily Operations(Production Support) with the team of 5 people

Confidential

Project Leader / Onshore Co-ordinator

Confidential

Systems Analyst

• Responsible for Module leader of the Marketing system, Involved in design of various functional units, design of the User Interface using Visual Basic 5.0