SUMMARY

• 10+ years of IT experience with excellent experience in all phases of Software Development Life Cycle that includes Requirements analysis, Functional analysis, Design, Development, Testing, Implementation and support.
• Excellent understanding and experience in Data warehouse development life cycle, requirement analysis, Data modeling(Dimensional & Relational)and developed Star - Schema, Snowflake Schema - Fact and Dimension tables
• Hands experience using ETL tools like and Informatica PowerCenter 9.6.1/9.5.1 , Informatica IDQ 9.X Business Objects Data Integrator and Business Objects reporting tool.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Extensively used Transformations like Source Qualifier, Expression, Lookup, Router, Aggregator, Joiner, Sequence generator, Normalizer and Procedure.
• Performed the data analysis and profiling making use ofInformatica Data Quality (IDQ) mapplets.
• Solid experience in working with SAP Business Objects XI3.1 suite tools like Webi, Designer, Infoview, CMC, Live Office and Xcelsius Dashboards.
• Extensive experience interacting with business users, business owners for requirement gathering, analyzing business process, making the necessary changes to schema objects to fulfill reporting needs.
• Using Universe & Webi Reports as a Data source of Xcelsius to build the Xcelsius Dashboards thru Use live office to getting the live data. Scheduling Webi reports to users destination as users Inbox & and to FTP Server.
• Hands on experience in various technologies like Oracle 10&11g, UNIX and XML and scheduling tools.
• Experienced in writing simple & complex SQL in Oracle for data validation and creating unit test cases.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Worked extensively on Informatica partitioning when dealing with large volumes of data and also partitioned the tables in Oracle for optimal performance.
• Good knowledge on Hadoop and big data and POC done to create reports for the BI team using Sqoop to export data into HDFS and Hive.
• Good knowledge on Informatica cloud flat and MDM development.
• Analyzed and implemented different projects for different clients. Started by gathering the requirements, writing the design documents and conducting all required development, including the UNIT testing and QA.
• Involved in UAT and Production support, proficient in handling production incidents (critical issues) and production related issues involving multiple stakeholders/vendors.
• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.
• Good hands on experience in Investment Banking domain (Expertise in Expense management system) and CCAR (Comprehensive Capital Analysis and Review) implementation
• Worked with various banks like Confidential, Confidential and Confidential .
• Excellent analytical, problem solving, communication, trouble-shooting skills and interpersonal skills, with ability to interact with individuals/teams at all levels.
• Management skills include Team Management, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS

Operating Systems: Windows 2010/NT/XP, HP UNIX

Reporting Tools: Informatica Power Center 9.6.1/9.5.1 /8.6/8.5.1/, SAP Business Objects XI/R3x, Xcelsius 2008, Excel, QAAWS & Live Office, Tableau, Tableau server

Databases: Oracle 9i, 10g & 11g, SQL server 2000

Tools: SQL*PLUS, EQM, HP ALM Quality Center, Control M and ServiceNow

ETL Tools: Informatica Power Center 9.1.1/9.1/8.6/8.5.1/.0 , Business Objects Data Integrator (BODI) and Informatica(IDQ)Data Quality, Informatica MDM

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

ETL/BI Technical Lead/Architect

Responsibilities:

• Responsible for gathering business requirements, interacted with the IT team, business analysts and the End Users.
• Lead the CCAR application technical solution design of the Informatica application. Lead the requirements gathering and design discussion with business. Responsible for system design and solution using Informatica tool set.
• Coordinated with the 3-4 member teams to handle day to day development activities and Release wise production implementation.
• Worked on critical CCAR schedules like CORP, CRE, First Lien and Home Equities for different sources. Responsible for CCAR submission process - 14A,M’s & Q’s
• Played key role in designing MRT (Master Reference Table) enable enhanced reconciliation controls and data management efficiency which helpedthe Bank’s CCAR submission on-time to Federal government.
• Extensively worked with Informatica Designer and workflow manager. Designed and developed various mappings and mapplets in mapping designer sessions and workflows in workflow manager to extract data from various sources and load into Oracle database tables.
• Developed SQL join queries in Source Qualifier along with various transformations like expression, filter, joiner, aggregator, lookup, rank, sequence generator, sorter, etc.
• Developed several complex mappings in Informatica and a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets Parameter files in Mapping Designer
• Performed the data analysis and profiling making use ofInformatica Data Quality (IDQ) mapplets.
• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS and creating required table indexes.
• Preparation of Impact analysis and technical design documents. Support Integration testing and User acceptance testing and HP QC is used for defect life cycle management.

Confidential, NY, NY

ETL/BI Lead (Business Object & Informatica)

Responsibilities:

• Gathered business requirements, interacted with the IT team, business analysts and the end Users.
• Worked with the IT Team to create underlying Database Views for Business Objects Enterprise reports.
• Extensively worked in Informatica Designer and workflow manager. Designed and developed various mappings and mapplets in mapping designer and sessions and workflows in workflow manager.
• Developed SQL join queries in Source Qualifier. Authored SQL Scripts for reporting requirements to meet the Unit Test Requirements.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Used PL/SQL to create Packages, Functions, and Procedure for data migration from staging to data mart.
• Extensively used ETL to load data from Flat files for both fixed width as well as Delimited files and also from the relational database (Oracle 9i/10g).
• Worked with the IT Team to bring the required data into Business Objects Universe to make canned reports available.
• Designed and created WEBI reports using Web Intelligence Rich Client and InfoView. Created complex Webi reports BO functionalities like Creating variables, conditions, filters & breaks for report layout and formatting. Scheduling Webi reports to user’s destination as users Inbox and to FTP Server.
• Performed unit testing and user acceptances test (UAT) for Universe Reports.
• Managed entire project lifecycle; requirements gathering through implementation including preparing the scope, mapping documents and high level and low-level design specification documents.
• Involved release process i.e. Business objects and Informatica components migration to UAT & Production
• Involved daily call with Business to get the requirements and provide details of work status.

Confidential, NY, NY

Technical Lead (Informatica & Business Objects)

Responsibilities:

• Lead a seven-member team to develop this application. Gathered business requirements, interacted with business analysts and the End Users.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Used Designer as a part of universe development for defining the parameters of Universe, Inserting the table, Making Joins, Resolving Loop's, Creating Classes and Objects.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and Checked the Integrity of the Universes.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Exported the Universes to the Repository to make resources available to the users For ad-hoc report needs. Generated Reports using the Universe as the main Data provider.
• Created Webi reports using Universe and Desktop reports using both Universe & Free hand SQL as Data providers. Worked on Webi reports, Prompts and Report Layout and re-formatting.
• Reports are made user friendly by implementing user prompts, conditions and filters.
• Scheduled and maintained the reports to various users across the world using CMC and Control M.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (Oracle DB, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Lookup and Stored Procedure.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Performed unit testing, system testing and user acceptances test (UAT) for Universe Reports.
• Involved release process i.e. Universe and Reports migration to production.
• Involved weekly call with Business to get the requirements and provide details of work status.

Confidential

Sr. Developer and Support Lead

Responsibilities:

• Involved in gathering the requirements from the Business.
• Involved in the complete development. (Req. Gathering - Moving into Production)
• Developed Reports in Business Objects webi. Performed Universe Design and provide user support for Adhoc reporting. Created and monitored BODI jobs to load the in daily basis
• Scheduled user’s reports. Performed unit testing

Confidential

Sr. Developer

Responsibilities:

• Involved in gathering the requirements from the Business.
• Involved in the complete development. (Req. Gathering - Moving into Production)
• Performed Universe Design. Developed Reports in Business Objects.
• Used multiple Data Providers, Slice and Dice panel to achieve a master Detail report.
• Created Various Views to have an aggregation table.
• Used PL/SQL to create Packages, Functions, and Procedure for data migration from staging to data mart.
• Extensively used ETL to load data from Flat files for both fixed width as well as Delimited files and also from the relational database
• Involved in writing the technical document and unit test cases for both Universe and reports.
• Authored VB script and scheduled reports via BCA. Performed unit testing

Confidential

Responsibilities:

• Production supports for NL Business Objects user.
• Scheduling reports via BCA and monitoring scheduled reports.
• Reporting to the business about schedule runs.
• Used PL/SQL to create Packages, Functions, and Procedure for data migration from staging to data mart.
• Extensively used ETL to load data from Flat files for both fixed width as well as Delimited files and also from the relational database
• Involved in migration of reports from BO5.1 to BO6.5. Handling DW tickets.

Confidential

Developer

Responsibilities:

• Involved in gathering the requirements from the Business.
• Involved in the complete development. (Req. Gathering - Moving into Production)
• Used PL/SQL to create Packages, Functions, and Procedure for data migration from staging to data mart.
• Extensively used ETL to load data from Flat files for both fixed width as well as Delimited files and also from the relational database
• Performed Universe Design. Developed Reports in Business Objects.
• Used multiple Data Providers, Slice and Dice panel to achieve a master Detail report.
• Created Various Views to have an aggregation table. Involved in writing the technical document and unit test cases for both Universe and reports. Performed unit testing.