SUMMARY:

• 10+ Years of total experience in Information Technology Industry with expertise in developing Business Intelligence and Data Warehousing solutions.
• Extensive hands - on & managerial experience in the design, construction & deployment of data warehouse systems.
• Strong experience in designing complex ETL processes for data integration and data warehouse batch loads using Informatica Power Center Designer.
• Proficient in Informatica Power Center and expert skills in designer to create Mappings, Mapplets, Transformations and reusable transformations. Expert skills in Repository Manager and Workflow Manager to Create Workflows and Workflow Monitor to monitor workflows
• Experience in Data Mart, Star Schema, Snowflake Schema, Design, Development and Implementation of Business Applications.
• Real-world production experience in development and SQL tuning on Oracle data bases.
• BI reporting experience using Business Objects XI/6.5/5.0, Designer, WEBI,Infoview, Crystal reports.
• Experience in the Blended (Onsite-Offshore) Delivery Model - Coordination, Client Communications, Status tracking and Issue resolutions
• Provided extensive programming support in COBOL, IMS DB/DC, IDMS, CICS, JCL, Easytrieve, VSAM, MQ messaging and implemented many complex projects.
• Possess good exposure in Insurance, Investment, Retirement Plan Service & Marketing Domain sector.
• Self-starter with excellent communication skills and problem solving skills.
• Team player with strong communication, presentation and ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Operating System: WIN XP/2000/NT, WIN 2000/2003 Server, UNIX, Linux

Databases: Oracle 11g/10g/9i/8i

Languages: TSQL, PL/SQL

ETL Tools: Informatica PowerCenter 7.1, 8.1, 8.6, 9.1 (Designer, Repository Manager, Workflow Manager and Workflow Monitor), Informatica Power Exchange, Metadata Manager

BI Reporting Tools: Business Objects XI R3/R 2/6.5/6.0/5.1 , Infoview, Business Objects SDK, Web Intelligence 2.5/2.6, BCA, ZABO, Designer, Developer, Supervisor, OBIEE, Crystal Reporting, Actuate

Other Tools: SQL Advantage, SQL Developer, SQL Plus, HP Quality Center, Autosys, DB  Visualizer, TOAD, MS project, MS Office, MS Visio, MS Access, SQL Navigator

Mainframe Based:

Operating System: MVS, z/OS

Database: IMS DB, DB2

Languages: TSQL, PL/SQL

Environment: TSO

Utilities/ Tools: ISPF, VSAM, CICS, Xpeditor, Intertest,, File-Aid, UC panel, Eazytrieve, MQ manager, IDCALMS, CA7, Sungaurd OmniPlus

PROFESSIONAL EXPERIENCE:

Confidential, Norwalk CT

BI/ETL Developer

Role & Responsibilities:

• Establish and maintain comprehensive ETL architecture including process flow diagrams, source to target matrix, high level (HLD) & low level (LLD) Informatica transformations design, ensuring high data quality, better performance and error recovery/handling.
• Work with the business group to understand business requirements and coordinate technical specifications for Informatica (ETL) design.
• Design ETL processes for the data transfer between ODS to data warehouse and corresponding data marts.
• Perform System and Integration Testing. Support UAT, assist business with test cases & develop strategies with Quality Assurance group to implement them to ensure quality standards.
• Design and develop BI components for the delivery of dashboards, ad hoc queries and canned reports using Micro Strategy and Dundas.
• Troubleshoot issues, provide timely restoration of service, conduct root cause analysis, and make recommendations for long-term solutions.
• Creating migration documents and migrating the code to the production environment. Analyzing the dependencies between the jobs and scheduling them accordingly using workflow scheduler.

Confidential, Wilton CT

Informatica/DW Developer

Role & Responsibilities:

• Working with Business Analysts on gathering requirement and framing it into Technical Design Specifications based on business requirement.
• Performing ETL into oracle data warehouse using Informatica Mappings using different transformations.
• Creating reusable transformations, mapplets, worklets and used them in various mappings/workflows.
• Creating Informatica parallel workflows and sessions for extracting and loading data using various sources like Oracle, Flat File etc.
• Extensively working on performance tuning of programs, ETL processes. Also used debugger to troubleshoot logical errors.
• Using PL/SQL for creating views, packages, procedures, functions, indexes etc.
• Preparing unit as well as system test plans for each component, performing Unit testing, functional testing & system testing.
• Coordinating with QA/BA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Working on production tickets in case of production bug. Also initiated extensive documentations for the production support process improvements.

Confidential, New York City

ETL/Data Analyst

Role & Responsibilities:

• Created data lineage from the systems of record to the consumer of the data for a data repository tool for the ECM and Liquidity Risk programs.
• Converted data lineage diagrams into data mapping documents and loading these data mapping Information into portal for future reference.
• Performed all data analysis within calculator workstream (Retail, Wholesale, Traded Products, and Market Risk) within the bank.
• Developed components of the client information strategy for GMB&GCB, partnering with LOB, Risk and Operations representatives.
• System analysis and documentation for a Basel-related, regulatory initiative.
• Coordinated with offshore team and trained other team members.

Confidential, Stamford CT

ETL/BI Developer

Role & Responsibilities:

• Gather reporting requirements from the Operation and regulatory team, Investment Banking Management team, legal & compliance team, middle office, risk and derivatives groups
• ETL design of the data load process into ODS considering restart ability and exception handling
• ETL design for the data transfer between ODS to the corresponding data marts
• Documenting the integration logic to be implemented for data consolidation.
• Co-ordinate with the reporting team to build the corresponding universes on the data marts.
• Co-ordinate with the onsite and offshore development team for ETL development
• Preparing unit as well as system test plans for each component to be developed
• Develop new Universe and created new classes and User Objects in the existing universes.
• Project tracking and status reporting.
• Effectively and efficiently plan and prioritize all deliverables and resources working across project(s) based on scope of work and project goals. Proactively manage changes in project scope, identify potential crises, and devise contingency plans.
• Executed multiple projects simultaneously and successfully ensuring the co-ordination between onsite & offshore teams as an onsite coordinator.

Confidential, MD

Sr. Data Warehouse Consultant

Role & Responsibilities:

• Design and develop scalable ETL routines using Informatica for the warehouse load
• Implement nightly batch jobs for day and monthly close process
• Implement the ETL mappings for conforming the data at ODS level and flowing it through the data marts.
• Create metadata reports for the ETL batch jobs to analyze the nightly batch jobs and take preventive action over any anomalies tracked.
• Derive lineage between the source and target table structures using Informatica Meta data manager.
• Impact analysis for the changes scheduled in the release using Informatica meta data Manger.
• Analyze and modify the existing DB structures to enhance the load timings of the ETL batch jobs.
• Optimize ETL processions by session partitioning, pre sql or post sql ways etc.
• Participate in user meetings and technical discussion related to our project.
• Provide production support for various different defects in the code and provide production implementation plan for any new code changes movement to production.
• Update COBOL\DB2 program for OMNIPlus related changes.

Confidential, Richmond, VA

DW / BI Consultant

Role & Responsibilities:

• Involved in full SDLC of various Change Requests of LTC Data Warehouse (GRDW).
• Gathering and analyzing business requirements and provide system architecture consulting with regards to data warehouse.
• Develop full project plans to implement ETL solution and identify resource requirements. 
• Data analysis and data profiling of the various asset class data from various systems to verify integration requirements.
• Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture. Identify, recommend and implement ETL process and architecture improvements
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture. 
• Creating and integrating multiple programs and objects to address business requirements and present and defend technical recommendations.  . 
• Coordinate with onsite and offshore team. Co-ordination with all stake holders of the project.
• Participate in user meetings and preparing documentation. Prepare unit as well as system test plans for each component to be developed. Creating change control documentation, Project tracking and status reporting, managing issue tracker.
• Analyze inputs and devise strategy based on best practices and future supportability; Assist my team members in troubleshooting, diagnosing and resolving complex Business Object problems to ensure high performance and minimal disruption of critical systems.
• Providing Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation on the login process for New Business Entry system and underwriting system.
• Constructed universe & related star schema database, with focus on user-friendly configuration of classes.
• Led report development effort, including creation of many Desktop Intelligence, Web Intelligence & ad-hoc reports.
• Design, Development, Testing, improvement, and documentation of reports and related universe based upon data generated by enterprise transaction, financial, and customer information systems, including standardization and applying best practices.