SUMMARY:

Technical Project Manager with over 17 years of extensive experience in Datawarehouse, ETL architecture and Data Architecture. Proven track record of leading, delivering and implementing many datawarehouse and ETL solutions of various complexities, especially for Financial Services - Investment Management domain. Passionate about providing value added solutions to the customer and inquisitive about trying new approaches to a solution. Adept at liaising with customer and demonstrated ability of managing, designing and developing Business Intelligence projects and programs, data analysis, managing and addressing difficult situations and complex technical issues. A quick learner, always willing to help, my motto is “succeed together”.

AREAS OF PRIMARY EXPERTISE:

• Datawarehouse Architecture and Dimension modelling
• Data analysis and profiling
• Project Management
• ETL/Data Integration
• Performance Tuning
• Very Hands-on expertise with

TECHNICAL SKILLS:

ETL Tools: Informatica, Talend

Database: Oracle, Exadata, Netezza

BI Tools: Tibco Spotfire, Tableau, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

ETL Architect

Responsibilities:

• Helping the customer draw scope for the current project phase and customizing the data model according to client’s specific needs.
• Design and customize Data transformation rules to align with the quality of the data flowing into the client’s domain and provide quick turnaround for data procurement.
• It is a developing project with the current initial phase focusing on Proof of Concept and identifying and registering specifications for the actual implementation.

Technology used: Informatica 10.1.1, SQL Server, Informatica Healthcare Analytics Accelerator (IHAA)

Confidential, Canton, MA

Principal Data Architect

Responsibilities:

• Principal Data Architect in the Information Management service line, serving a Major retail client to design and develop data models, draw technical specifications for data acquisition and transformation, design and develop ETL interfaces for data ingestion.
• Performed data analysis and identified data quality gaps.
• Created models and Transformation interfaces to improve data consistency and accuracy.
• Created and implemented design to reduce operational efforts for daily ETL job runs and data maintenance.
• Worked closely with business users and improved data traceability and auditing measures by defining rules, threshold for exceptions and data re-processing criteria.
• Helped increase performance of report queries and data visualization interfaces.
• Liaised closely with client management and vendor teams.
• Designed and developed ETLs to perform legacy data conversion to align and conform with future data formats, grains and standards.
• Performed Team management and project tracking.

Technology used: Informatica 9.x, Oracle Exadata, Unix

Confidential, Brentwood, TN

Data Integration Architect

Responsibilities:

• Data Integration Architect serving a Retail client with designing and developing data transformation and transfer interfaces for the implementation of a CRM system and connecting downstream systems.
• Role involved data analysis, legacy data conversion and design for the implementation of ETL architecture, designed and developed ETL for data transformations.
• Performed interface tuning, established standards for development and implementation of ETL interfaces.
• Assisted with QA and other testing standards as laid out in the enterprise standards. Advised teams and guided them to solution.
• Performed the roles of data analyst, Data architect, ETL architect, Team Lead and ETL Developer

Technology used: Talend, Netezza, Oracle, Jira, Confluence

Confidentialm Boston, MA

Manager (Analytics and Information Management)

Responsibilities:

• Manager in the Analytics and Information Management service line serving technology clients with emphasis on Data platform transformations including data architecture, data migration, data integration and project management.
• Advise client managers and executives regarding current state architecture and guide towards a futuristic vision of data requirements.
• Provide recommendations and strategy for data migration, data quality, data integration and data services.
• Provide inputs on current and future state of data especially taking the qualitative and retention needs into consideration.
• Advised and strategized processes for an insurance company for a data platform migration project.
• Guided the client towards appraising current data quality standards and evaluating future state of data.
• Provided idea for the creation of a data lake or data warehouse from a futuristic stand point to support analytical reporting requirements and data retention for any regulatory requirements.
• Suggested the creation of a data retention policy to have traceability and mitigation of overheads.
• Devised POC mappings using Informatica for data transformations and stress testing.
• Managed, as part of the PMO team, a data transformation and transmission project for a bank being acquired by another company.
• Led the client into discussions regarding project statuses and drew appropriate attention to matters critical for project’s successful completion.
• Prepared various metrics to show current and immediate future status of tasks outlined in the plan.
• Helped an Asset management company to gather requirements for an Enterprise data service platform transition.
• Gathered requirements towards desired end result and documented the needs of the project.
• Worked with teams to define timelines and generate reports and metrics for status reporting.
• Studied and documented existing data transformation rules and data dependencies as designed and prevalent in Informatica mappings and workflows.
• Performed the roles of Manager, Data Architect, Data Integration architect and data analyst

Technology Used: Informatica, Oracle, Tableau

Confidential, Stamford, CT

ETL Program Manager/Data Architect

Responsibilities:

• Led, Managed, Delivered, Designed, Developed and implemented various complex Data warehouse projects, specifically in the Investment Management business line.
• Created and enhanced Data warehouse models, ETL architecture and instituted standards for change control and impact analysis.
• Provided expertise in data profiling, data quality analysis, Data warehouse design, datamart design, metadata capture and data services.
• Performed performance tuning of ETL system resulting in ~70% improvement in enterprise load cycle.
• Developed strategy for mitigating data warehouse storage consumption, implementation of which reduced storage utilization by ~40%.
• Managed and led teams involved in Master data management and data visualization areas of business intelligence in addition to data integration and transformation (ETL) team.
• Liaised with customer to gather requirements, schedule projects, architect the design and managed the projects.
• Implemented creative, innovative and reusable solutions for processing heavy XML data, re-architecting ETL system, mitigate data growth rate, processing of JMS messages into the datawarehouse, processing real-time data into datawarehouse, providing solutions and inputs towards data governance requirements and integrating data stewardship activity to ETL interfaces.
• Worked and liaised with global teams based on different geographies and different support teams.
• Possess keen customer-centric focus to provide best solution in the lowest turn-around time to achieve the most business benefits.
• Managed and implemented various concurrent short-term discretionary projects in addition to high volume, big budget projects.
• Adept at using new features of available technology to provide optimal and robust solutions. Possess excellent documentation skills and prepared enterprise artefacts viz.
• Metadata dictionary, dimensional matrix, Design documents, data flow diagrams and as-is system documentation. Hands-on experience with Informatica Power Center, Oracle and Exadata. Familiar with Tibco Spotfire, Business Objects and Tableau.
• Managed, led and delivered the implementation of a simplification project. Helped customer articulate the vision and define requirements.
• Prepared the inventory of enterprise-wide data interfaces and flagged interfaces and applications for demise and/or commissioning, in line with the business goal of simplification
• Redesigned the whole ETL architecture to cater to changed data feeds, data model, data content and database design.
• Created a radically new design for the processing of XML data into the datawarehouse which substantially reduced the risk of schedule overrun.
• Discussed and negotiated with external vendors on timing, content and design of the incoming and outgoing feeds. Controlled the project attributes and Fast-tracked the project to bring the delivery to planned duration. Managed a large team of BI, MDM and ETL team. Architected the enhanced model of the datawarehouse and the ETL interfaces.
• Performed various data analysis from Security master to investment data and devised design for their accommodation into the datawarehouse. Implemented standardization rules, quality rules for data entering the enterprise. Designed and developed data transformation (ETL) interfaces to implement the rules of standardization and capture out of threshold data elements as exceptions for further research and/or vendor corrections. Designed and developed ETLs for exception re-processing into the system.
• Created POC for writing SQLs out of Datawarehouse to enable data representation on the web. Performed deep-dive SQL performance tuning to present data on the web. Implemented Oracle’s security feature Virtual Private Database (VPD) to add an additional layer of security to the data. Managed team of SQL developers and guided them to write SQLs efficiently. Liaised with business users closely to gather requirements and to highlight the data aspects needed for data presentation.
• Designed and Re-wrote Informatica mappings for Exadata platforming of the datawarehouse. Performed re-write of ~80% Informatica mappings, workflows and corresponding SQLs to enable utilization of Exadata features during ETL loads. Performed the entire transition of datawarehouse from traditional Oracle platform to Exadata platform in record time of 2 months. Worked closely with other support teams viz. DBA, Operations and monitoring and BI team.
• Performed project management, architecture, analysis, design, development and support for various discretionary and Ready to Serve projects and streamlined processes of project execution and reporting alongwith successful delivery of project results.
• Performed Re-architecture of ETL interfaces to tune the Load cycle and successfully managed to bring down load SLAs by ~70%
• Helped customer with technology assessment and performing quick POCs and underlining customer’s needs with respect to the tool capabilities. Performed POCs of Informatica Data Services, Informatica Metadata Manager
• Performed the roles of Program Manager, Project manager, Data Integration architect, Data architect, Data analyst, Business analyst, ETL and BI developer

Technology Used: Informatica Power Center, Oracle 11g, Exadata, Business Objects, Tibco Spotfire, SQL, SQL Server, Golden source, Sybase, TOAD, Embarcadero DBArtisan, HP Quality Center