SUMMARY

• Accomplished Business Intelligence Professional with over 13 plus years’ experience in leading large complex programs, matrix manage cross - functional resources, driving process efficiency, implementing systems and key initiatives.
• Defining and implementing strategy for enterprise level data integration architecture, business intelligence, enterprise reference data, and data quality solutions across all divisions.
• Experience includes the assessment of existing platform architecture frameworks, evaluate and select software and hardware technologies, process definition, re-engineering and implementation of data strategy.
• Envision and create solutions that meet requirements of data integration; model the pieces of an infrastructure and their points of integration; prove the feasibility of a architecture design; create the data flow design artifacts that are required to deliver and to maintain the infrastructure; guide a solution through to its completion; and ultimately can be implemented and supported in production.
• Demonstrated experience managing demands of complex projects, developing innovative systems, providing technical support, and performing business systems analysis.
• Offers strong combination of business and technical expertise, ensuring steadfast project management from development of initial concept through design and implementation of solutions.
• Utilized broad technical skills encompassing concrete knowledge of key technologies to streamline design, development, and implementation functions. Skilled project leader; able to provide quality technical support and leverage available and emerging technologies in order to create innovative business solutions.
• Experience and exposure to various business domains like Manufacturing, Services, Banking, Finance, Investments, Risk Management.
• Experienced delivering high-impact solutions in the areas of enterprise planning, business intelligence and Data Integration Data Warehouse. Supported both new development / project and production support, as the highest-level technology domain expert.
• Executed data warehousing / OLTP database projects through the full software life-cycle from requirements gathering, data profile, data modeling and technical specifications to design, development and implementation.
• Hands-on ER and Dimensional Data Modeling experienced in designing OLTP database / Star Schema/ Snowflake Schema methodologies in Erwin r7.3. In depth exposure and understanding of DWH Concepts and ETL process using Informatica.
• Strong working experience in Informatica PowerCenter 9.6 9.1 8.6X, IDQ/IDE, Informatica Metadata Manager 9.6, Informatica Developer, Informatica Analyst, Power Exchange CDC, Data Transformation Developer, MDM Hierarchy Manager, Transform and Load the data.
• Expert knowledge of big data technologies(Hadoop/Python/Hive/HBase) with extensive hands on experience. Led design & implementation of big data projects in the banking domain.

TECHNICAL SKILLS

DW-BI Tools: Informatica 8.6/9.1/9.5, Informatica IDQ, Informatica Developer, Informatica Analyst, Data Analyzer, Informatica Metadata Manager 9.6, Crystal Report 6, Tableau, Teradata,14.0, Greenplum 4.0, PostgreSQL

Bigdata Tools: Hadoop 2.0, Pig, Hive, Informatica Big-data edition, Greenplum, Python, Talend

O/S: Unix (Solaris), Linux, Windows 95/98/NT

RBDMS: Oracle 11i/10g/9i/8x, PL/SQL, SQL, SQL*Loader, Export & Import, MSSQL, T-SQL

GUI: Erwin, Toad, PL/SQL Developer, Rapid SQL, SQL Assistance

Scripting: Java Script, VB Script, Shell Script, Perl Script, Python Script

Scheduler: Unix Cron Job, Control-m 6/8

Software: Teradata v2R5 / v2R6, FLOAD, MLOAD, TPUMP, XML, XSD, Data Flow Diagrams, Data Cleansing, Share Point.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

DW Team Lead /Onsite Coordinator

Responsibilities:

• Collaborated with Project Managers, System Integrators, Database, Infrastructure, and QA teams as well as business users to design and develop IT solutions that adhere to sound integration architecture and the overall enterprise integration strategy and deliver within an agile development framework.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records based on business needs.
• Implemented ETL Process of populating Landing / Staging / Base Tables for customer Data Set into Informatica MDM from various source systems.
• Implemented delta load, full load strategy for large/small and complex volume of data.
• Served as the technical expert responsible for design, development, implementation, and support of trade finance applications on the SOA platform at an enterprise level.
• Responsible for all code reviews, technical reviews, and first level quality check before data analysis.
• Designed and developed Data Flow and Interface Architecture Diagrams to depict involvement of all upstream and downstream systems in order to deliver technical solution of data requirements.
• Developed test cases and test plans. Conduct unit and system test for new and/or modified interfaces. Support QA team in regression and end to end testing scenarios.
• Performed code reviews with in-house and contracted development teams to ensure proper integration architecture is implemented and standards are followed.
• Responsible for the solution design and development of Informatica Development Efforts to build ETL process for loading Trade Financial data from T360 system to Core Banking Hub database.
• Responsible for managing the on-shore and off-shore teams to ensure the soundest solution is implemented.
• Designed ETL Process using informatica to load data from heterogeneous sources to Integration and semantic layer (Data Mart).
• Involved in conversion of Abinitio to Informatica Mappings and Workflows.
• Involved in creating functional and technical mapping document.
• Implemented Best Practices, done Performance tuning.
• Achieved project goal of conversion of entire code from Abinitio to Informatica with in time period, conversion of code to ICDW standards, Performance Tuning etc.
• Implemented Informatica Full PDO Technique to use MPP database power
• Implemented Validation Framework
• Implemented Hadoop ingestion using Python Hadoopy library.
• Implemented data ingestion using Hive SQL, HBase bigdata technology.

Environment: Informatica 9.5, Control-M 6/8, Unix, Teradata 14.0, Perl/Shell Scripts, Hive, Talend

Confidential, New York, NY

ETL Architecture, DW Team Lead

Responsibilities:

• Designed architecture solutions for Investment’ BI reporting data requirements using data warehousing concepts.
• Designed Asset Class & Business Unit Hierarchical Data Model using Erwin 7.1 tool.
• Involved in complete SDLC phase in collecting and documenting requirements. Wrote TSD documents for developers easily to understand and code.
• As an Onsite / Offshore model, helped team to understand scope of the project and also assisted and developed Informatica code.
• Prepared Key metrics and dimensions document. In this process, analyzed the System Requirement document and identified areas which were missed by Business and IT team.
• Identified the data sources and computational logic of rolling up metrics across various dimensions by analyzing all the various systems that source data into the warehouse.
• Generated sample data based on the data model design and loaded the data into the database using UNIX shell scripts, which was used both for data analysis and also unit testing purposes.
• Formulated and implemented Historical load strategy from multiple data sources into the data warehouse.
• Data concurrency, Prioritization, comprehensiveness, completeness and minimal impact to existing users are taken as key attributes for Historical data load strategy.
• Involved in ETL process design, DB design.
• Connected with end users to understand sales data, designed models, integrated SQL Server, Flat file, Oracle data in NBA DB.
• Involved in end to end design of Project Framework, design of ETL framework, design of database, design of analytical scripts in python/pig, coding, testing and on-boarding of system.

Environment: Informatica 9.5, Control-M 6/8, Unix, Greenplum 4.4,Postgress DB, Perl/Shell Script, Hadoop 2.0, Python, Pig.

Confidential, New Jersey, NJ

ETL Architecture, DW Team Lead

Responsibilities:

• Working on building new data warehouse for customer data information.
• Experienced working with team leads, Interfaced with business analysts and end users.
• Interacted with Business Analyst to gather requirements and translated them into ETL technical specifications.
• Worked with data modelers to understand financial data model and provide suggestions to the logical and physical data model.
• Involved in data quality profiling, design, development, unit testing and deployments of ETL Informatica components.
• Document unit test cases and provide QA support to make testers understand the business rules and code implemented in Informatica.
• Extracted data from various sources like XML files, flat files, RDBMS loaded into target data warehouse Oracle.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Implemented error handling for invalid and rejected rows by loading them into error tables.
• Involved in Performance Tuning of ETL code by addressing various issues during extraction, transformation and loading of data.
• Analyzed the source fields and wrote SQL queries for field to field validation by referring source to target mapping document.
• Involved in writing SQL queries to validate the data on the target database according to source to target mapping document.
• Worked with Support team to migrate the ETL code to Production servers from development servers by creating a mapping document and Request for Change (RFC) of the process.
• Involved in Knowledge Transfer sessions to Support team after completion of UAT signoff.
• Handled Production issues and monitored Informatica workflows in production.
• Extensively worked on batch frame work to run all Informatica job scheduling.

Environment: Informatica 8.6/9.5, Control-M 6/8, Unix, Oracle 11i, Rapid SQL, PL/SQL, SVN, Perl/Shell Script.

Confidential, Houston, TX

ETL & DB Architecture

Responsibilities:

• Developed technical specifications of the ETL process flow.
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server and Oracle.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, tablespaces, tables using Datapump(10g) as well as traditional export/import (until 9i).
• Knowledge of Cold/Hot backups and RMAN backups.
• Scheduled various daily and monthly ETL loads using Control-M.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process.
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica 8.6, Cron Job, Unix, Oracle 10g/9i,PL-SQL Developer, PL/SQL, VSS, Shell Script.

Confidential

Database Engineer

Responsibilities:

• Designed logical and physical data models, developed PL/SQL stored procedures.
• Provided new functionality and backward compatibility for multiple applications using the same database structures.
• Utilized advances programming Oracle techniques for best efficiency and performance.
• Installed, configured, and maintained multiple database instances in Development environment.
• Monitored and tuned application and database performance using Oracle Enterprise Manager and other tools.
• Developed PL/SQL stored procedures for One Page applications.

Environment: Oracle 9i, SQL Server 2000, PL-SQL, T-SQL

Confidential

Oracle DB Lead

Responsibilities:

• Involved in performance tuning and SQL tuning effort. Expert in making use of explain plan, TKProf, AWR reports, OEM and Toad.
• Tuned several environments and improved the results to many folds. Re-wrote several stored procedures and packages in PL/SQL for developers.
• Managed Oracle Grid Control.
• Responsible for day to day trouble shooting, and maintenance.
• Responsible for automating database monitoring using OEM and shell scripts.
• Implemented backup and recovery strategy.
• Heavily involved in performance tuning and SQL tuning effort. Helped developers to code efficiently in PL/SQL.
• Expert in making use of explain plan, TKProf, AWR reports, OEM and Toad. Tuned several environments and improved the results to many folds.
• Responsible for migration / upgrade design for databases.
• Designed / tested and implemented backup and recovery methods and procedures including full, incremental and FRA image backups, using RMAN and Net backup.
• Responsible for day to day trouble shooting, and maintenance. Responsible for automating database monitoring using OEM and shell scripts.

Environment: Oracle 9i, PL-SQL

Confidential

DB Developer

Responsibilities:

• Responsible for administering and supporting production and development Oracle 9i databases.
• Installation of Oracle on Linux.
• Performed installations of Oracle 8i, 9i and SQL Server 2000 & 2005 databases.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Instance cloning done to create test and training environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Partitioned large tables to increase the performance.
• Monitoring of database for growth and performance.
• Monitoring Database for fragmentation and correcting them.
• Customization and development of Unix shell scripts and Perl Scripts.

Environment: Oracle 9i, SQL Server 2000, T-SQL, SQL Loader

Confidential

ASP & MSSQL Developer

Responsibilities:

• Design, Coding, Testing, Production Support & defect resolving.

Environment: ASP, ASP.NET, SQL Server 2000

Confidential

VB & Oracle Developer

Responsibilities:

• Module Design, Coding, Testing, Production Support & defect resolving etc.

Environment: VB, COM, Crystal Report 6.0, Oracle8i, SQL Server 2000