SUMMARY:

• Over 10 years 11 months of experience in the IT industry .Main area of expertise is in Informatica and Business objects.
• Experienced in analysis of different systems for system study and data warehouse implementations.
• Experienced in Data Analysis, Data modeling, ETL, Data Warehousing, Reporting, Development, Maintenance, Testing and Documentation.
• Possess good understanding of Conceptual, Logical and Physical designs and familiar with ER diagrams.
• Extensive experience in implementation of Informatica Power Center components like Source Analyzer, Target Designer, Mapping/Mapplet/ Transformation Designer, Workflow Manager/ Workflow Monitor.
• Experienced in data extraction, transformation and test loading the data coming from different heterogeneous source systems like flat files, XML Files and Oracle.
• Developed Mappings using transformations like Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy, Sequence Generator and Source Qualifier.
• Implemented type1/type2/type3, Incremental and CDC Confidential according to the Business requirements
• Experienced in Business Objects XI R2/XI R3.1.1 and SAPBI 4.0 (BO Reporter, Designer, Scheduler, Info View, Desktop Intelligence and Web Intelligence).
• Experience with Web Intelligence and creating Ad - hoc reports and archiving the reports.
• Good Knowledge in Designing/Developing the User-Interface (Universe), CMC/CMS and scheduling the reports using Scheduler.
• Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.
• Maintain/document business rules, Provide communication and planning for implementing customers as necessary.
• Strong experience in understanding business application, business data flow and data relations.
• Worked on RDBMS like oracle, Sql server and DB2.
• Exposure to BI Tools OBIEE and Cognos Report Net.
• Excellent Client handling ability with good presentation skills.
• Good communication, analytical skills and flexible to learn advancements in the IT industry.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6.1/ 9.0.1/9.5.1 /9.6.1, Informatica BDE, SSIS.

OLAP Tools: OBIEE, Business Objects XI R2/XI R3.1.1/4.0, SSRS.

Databases: Oracle9i/10g/11g, Sql Server and IBMDB2.

Data Modeler Tool: Erwin 3.5/4.0/4.5.

Scheduling Tools: Zena, Control-M and DAC

Domain Knowledge: Banking, Finance, Insurance, Telecom, Energy & Retail

Telecom Related Skills: SMS-MO, SMS-MT, GPRS and WAP.

Operating Systems: Windows 98/XP/2000/NT/7/8, UNIX and AIX.

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

DW-BI Technology Lead / Architect.

• To study and understand business and technical requirements of the system.
• Coordinated and provide the proper inputs to Confidential Informatca Admin for Informtica environment setup and UNIX admin for directories and paths for Confidential Energy FRE Project.
• Coordinated the onshore teams for Data mapping Gap analysis, Logical and physical Data model gaps using Erwin 4.5.
• Created the design documents SDS (System Delivery Specification-ETL) and TSD (Technical System Design Document-ETL) Confidential Energy FRE Project.
• Prepared the Impact analysis documents for each work requests from the business.
• Estimations done on each release based on the work requests.
• Shared the work requests to each team members and assigned the work to each team member.
• Created the design and test plan documents for the each work requests.
• Uploaded the designing documents to share point (FRE) for Onsite Team Approval.
• Developed Mappings using source Qualifier, Joiner, lookups, Expression aggregator, filter, router, update strategy, transformations.
• Created sessions and workflows using Informatica 9.6.1.
• Involved in performance tuning at various levels including target, source mappings and session for large data files.
• Executed Unit Testing and data validations for each work request.
• Prepared the consolidated promote checklists for the QA in testing environment.
• Migrated the mappings from Dev to QA using Informatica repository manager.
• Compared the mappings from Dev to QA before QA run and created the deployments groups
• Implemented the shell scripts, pram files and scheduling the jobs using cron in UNIX to invoke Informatica workflows.
• Conducted regression testing using Informatica (DVO) Data Validation Option tool.
• Prepared the consolidated promote checklists for production environment.
• Prepared the ETL process flow documents for UAT.

Environment: Informatica 9.6.1, Oracle11g, Erwin 4.5, Toad & UNIX.

Confidential,Charlotte,NC

DW-BI Project Lead / Architect

• Understand the Business requirements and convert into functional and technical specifications and developed maps for Extraction Transformation, Cleansing and Loading process of DW to make the deliverables at appropriate time.
• Did POC for the unstructured data loading like (PDF, Social Media Twitter, weblogs, HTML) into HDFS & Hive environments using Informatica Developer Client & Informatica Big Data Edition (BDE) tools.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams. Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• His Contribution includes Requirements gathering, design, development, implementation and Client co-ordination.
• Developing Informatica mappings and enhancing the current functionality of the mappings.
• Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.
• Performing system testing and support in fixing the defects raised in phases of all SIT (System Integration Testing).
• Managing a team of developers to achieve the project specific goals.

Environment: Informatica 9.6.1, Informatica BDE, Erwin 4.5, Oracle11g, Toad & UNIX.

Confidential,Charlotte, NC

DW-BI Project Lead/Architect.

• Responsibilities include Requirements gathering, design, development, implementation and Client co-ordination.
• Understand the Business requirements and convert into technical specifications and developed maps for Extraction Transformation, Cleansing and Loading process of DW to make the deliverables at appropriate time.
• Prepared Design documents, Requirement specifications according to client requirement
• Developed mappings, Sessions and workflows using Informatica 9.5.1.
• Involved in performance tuning at various levels including target, source mappings and session for large data files
• Performing system testing and support in fixing the defects raised in phases of all SIT (System Integration Testing).
• Involved in analyzing business requirements and data specifications for Business Objects Universes and Reports.
• Created the Universes using Business Objects XI R3.1.1
• Created Reports using thin client reports using Web I.
• Scheduling Reports using the scheduler.
• Linked Universes based on the requirements.
• Publishing and scheduling the documents.
• Created the reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, and Master Detail.
• Used Drill Up/Down operations done for different aspects of client business.
• Managing a team of developers to achieve the project specific goals.

Environment: Informatica 9.5.1, Business objects XI R3.1.1, Oracle11g, DB2, and Toad & UNIX.

Confidential,Branchville,NJ

DW-BI Senior Application Developer

• To study and understand business and technical requirements of the existing Dragon, ODS, ODS Claims, ODS-Reporting, Stone creek and E&S systems.
• Prepared the Impact analysis documents for each work requests from the business.
• Shared the work requests to each team members and assigned the work to each team member.
• Created the design and test plan documents for the each work requests.
• Uploaded documents in share point and shared path for signoffs from Application owners.
• Changed the DDL, DMLS, Mappings, Sessions, workflows, Parmfiles and batch files according to the design documents using Informatica 9.0.1/9.5.1 in Development Environment.
• Executed Unit Testing and data validations for each work request.
• Prepared the consolidated promote checklists for the QA in testing environment.
• Migrated the mappings from Dev to QA using Informatica repository manager.
• Compared the mappings from Dev to QA before QA run and created the deployments groups
• Created the bat scripts and run the Jobs using Zena Third party scheduling tool.
• Conducted regression testing using Informatica (DVO) Data Validation Option tool.
• Prepared the consolidated Production promote checklist for production environment.
• Worked on production fixes and provided the solutions.
• Estimations done on each release based on the work requests.
• Trained on MSBI SSIS and SSRS tools and worked the existing packages, report modifications for the Selective users.
• Modified the Store procedures for music reports and tested the reports in development and test environments.
• Supported the production support activates.

Environment: Informatica 9.0.1/9.5.1, SSIS, Zena, Sql Server and SSRS.

Confidential,New York,NY

DW-BI Senior Application Developer

• To study and understand business and technical requirements of the RPM, RRDW, CMP systems.
• Created the design documents as per the new Requirements.
• Developed Mappings using source Qualifier, Joiner, lookups, Expression aggregator, filter, router, update strategy, transformations.
• Implemented the different mapping and Mapplet Confidential according to the Business requirements from Analytical Certification Stake Holder.
• Created sessions and workflows using Informatica 8.6.1
• Involved in performance tuning at various levels including target, source mappings and session for large data files.

Environment: Informatica 8.6.1, BOXIR3.1.1, Erwin 3.5, UNIX and Oracle11g.

Confidential,Austin, TX

DW-BI Senior Application Developer

• To study and understand business and technical requirements of the Q- Confidential systems.
• Created the design documents as per the new Requirements.
• Developed Mappings using source Qualifier, Joiner, lookups, Expression aggregator, filter, router, update strategy, transformations.
• Implemented the CDC Confidential according to the Business requirements from Q- Confidential stake holder.
• Creating sessions and workflows using Informatica 8.6.1.
• Involved in performance tuning at various levels including target, source mappings and session for large data files.
• Prepared the bat scripts, parm files and run the scripts using windows scheduler to invoke Informatica Workflows.
• Executed Unit Testing and data validations for each job.
• Migrated and compared the mappings and workflows from Development to UAT and Production using Repository manager.
• Coordinating the onshore team to resolve the issues.

Environment: Informatica 8.6.1, UNIX and Oracle10g.

Confidential,San Mateo,CA

DW-BI Application Developer

• Involved in analyzing business requirements and data mapping iASAP Tax basis specifications for ETL Mappings and Business objects reports.
• Coordinated and provide the proper inputs to FTT Informatca Admin for informtica environment setup, BO Admin for business objects setup and UNIX admin for directories and paths for iASAP tax basis Project.
• Coordinated the onshore teams (GDG, IMG, and Ad Teams) for Data mapping Gap analysis, Logical and physical Data model gaps.
• Created the design documents SDS (System Delivery Specification-ETL) and TSD (Technical System Design Document-ETL) for iASAP tax basis Project.
• Uploaded the designing documents to share point (FTT) for Onsite Team Approval.
• Developed Mappings using source Qualifier, Joiner, lookups, Expression aggregator, filter, router, update strategy, transformations.
• Created sessions and workflows using Informatica 8.1.1.
• Executed Unit Testing.
• Implemented the shell scripts, parameter files and control-M Scheduling to invoke Informatica workflows.
• Prepared the test cases, test data, and test results for iASAP tax basis project.
• Migrated and compared the Mappings and workflows from Development to Test environment using Repository manager.
• Created the ETL process flow document for UAT.
• Created the universe for iASAP Tax Basis reports-10/31 Excise date, FYE using Business Objects XI R2.
• Created the reports (open-1256 futures, options and forwards, Non-open-1256 futures, options and forwards) using Web I.
• Scheduling the reports using the scheduler.

Environment: Informatica 8.1.1, Erwin3.5, Business objects XI R2, Oracle10g, UNIX, Control-M and Sql server.

Confidential,Plano,TX

DW-BI Application Developer

• To study and understand business and technical requirements of the existing GECARS, Non-GECARS, ERAM, GD, CRMS, EDW and CDW systems.
• Coordinated with GAMS team for existing Informatica environment setup, UNIX directories and paths and oracle database setup for CDW Project.
• Prepared the Impact analysis documents for each work requests from the business.
• Created the design and test plan documents for the each work requests.
• Uploaded documents in Confidential share point and shared path for signoffs from Application owners.
• Changed the DDL, DMLS, Mappings, Sessions, workflows, Parmfiles and batch files according to the design documents using Informatica 8.6.1 in Development Environment.
• Involved in performance tuning at various levels including target, source mappings and sessions for large data.
• Applied the performance techniques at Informatica level and fine tuned the SQL Queries at database end to complete the jobs within SLA time.
• Executed Unit Testing and data validations for each Job.
• Migrated the mapping from Dev to QA and QA to production environments.
• Involved in analyzing business requirements and data specifications for Business Objects Universes and Reports.
• Creating Reports using Desktop Intelligence and thin client reports using Web I.
• Scheduling Reports using the scheduler.
• Linked Universes based on the requirements.
• Publishing and scheduling the documents.
• Created the reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, and Master Detail.
• Used Drill Up/Down operations done for different aspects of client business.

Environment: Informatica 7.1, Business objects XI R2, Oracle 9i, DB2, and UNIX.