SUMMARY

• 7+ years of experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using InformaticaPowerCenter (7.4, 8.6 and 9.0.1).
• Strong working experience with IBM Cognos 10/8 BI, IBM Cognos Reportnet and IBM Cognos Series 7.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Worked on different phases of data warehouse development lifecycle, from gathering requirements to testing and implementation.
• Thorough knowledge in dimensional modeling concepts like Star and Snow Flake Schemas.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level and target level.
• Excellent knowledge and experience of Project Planning, Architecture and Development.
• Supported Production environment and configured new utilities and helped tuning workflows and mapping in order to tune the environment for better performance.
• Strong working experience with IBM Cognos 10/8 BI, IBM Cognos Reportnet and IBM Cognos Series 7.
• Extensive experience in flat relational and multidimensional modeling using framework manager and transformer modeling tools.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Experience with Oracle, DB2 and SQL Serverrelational databases. Good programming experience in SQL, PL/SQL, T - SQL, Stored Procedures, Functions, DB Triggers, Stored Procedures, Functions and Packages.
• Excellentinterpersonal andcommunication skills,technically competent and strong problem solving skills.
• Worked in all the phases of a BI project life cycle starting from requirements gathering and development to testing and implementation of services.

TECHNICAL SKILLS

Data Warehousing Tools: InformaticaPowerCenter 7.x, 8.x and 9.x, Information Lifecycle Management, ProActive Monitoring

BI Tools: Cognos 10/8 BI, Cognos ReportNet, Cognos 7 series, Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio

Databases: Oracle 9i, 10g, 11g, SQL Server 2000/2005/2008

Database Languages: SQL, PL/SQL

Programing Languages: Java

Scripting Languages: Java Script and VB Script

Web Technologies: HTML and XML

MS-Suite: MS Excel, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

Informatica Developer/Report Developer

Responsibilities:

• Analyzing the specification document anddeveloping Mappings to load data in warehouse.
• Created mappings using transformation logics like Source Qualifier, Expression, Aggregator, Joiner, Lookup, Filter, Router and Update Strategy.
• Developed mappings and sessions using Informatica power center for data loading.
• Optimized test data management, handled data growth and safely retired legacy systems to optimize data management.
• Identified potential opportunities or threats through Informatica Proactive Monitoring and sent alerts to the appropriate people for quick action or resolution.
• Used prebuilt alerting rules and templates to modify rules to monitor PowerCenter Workflow and sessions.
• Extensively worked with slowly changing dimensions.
• Used Informatica Workflow Manager and Workflow Monitor to Create, Schedule and monitor the session. Involved in unit testing and performance tuning of Mappings.
• Prepared User Manual, Technical Support Manual and Test Plans for various modules.
• Designed and developed complex mappings using various transformations in Designer to load data from Flat Files, SFDC, Oracle10g, DB2 into the target Data warehouse and Analytics Datamart.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Environment: Informatica 9.0, Informatica Proactive monitoring, Cognos 10.2.1, Teradata.

Confidential, Boston

ETL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Developed and maintained data standards and corresponding documentation. Implemented process improvements to enhance data quality and enhancements to systems and reports to support department goals.
• Created data mining architectures, reporting and data analysis methodologies; developed system training material and documentation for customers and ensured that materials are up-to-date.
• Worked closely with business managers to improve understanding of applications, including reporting and query functions; prepared monthly, quarterly and annual reports.
• Designed the ETL processes using Informatica tool to load data from Oracle 10g, Flat Files into the target oracle 10g/Teradata Data warehouse.
• Wrote stored procedures for cleaning up data and providing underlying structure for reporting using SQL.
• Prepared ER Diagram to get DB Governance Approvals from DBAs to create new set of DB Structures and relations.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Created mapplets for reusing transformation logic in multiple mappings.

Environment: Informatica Power Center 8.6, Oracle 10g,Oracle PeopleSoft (Finance), BuyWays (Finance), FAIR reporting application, MS Excel

Confidential, New Jersey

ETL Designer/Informatica Developer

Responsibilities:

• Actively involved in development, testing and performance tuning of the ETL code
• Created Informatica Mappings using Mapping Designer to load the data from various sources using different transformations like SQL, Normalizer, Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Implemented Slowly Changing Dimensions.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Involved in Design and code reviews.
• Created Index, Partitioning, Analyzed Tables and improved performance.
• Used Tidal as Job Scheduling tool to schedule Informatica jobs.
• Involved in Unit Testing, Integration Testing and Performance Testing of ETL.
• Building Data Mart to suffice the business requirements.

Environment: Informatica 9.0, Oracle 11g, WinSQL,Putty, PL/SQL, OBIEE reports,Autosys

Confidential

Oracle Developer

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
• Modified existing forms, reports, and graphs as per the enhancement.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Developed SQL scripts and complex queries with quality assurance and testing.
• Created numerous simple to complex queries involving self-joins, correlated sub queries and XML techniques for diverse business requirements.
• Planned, designed, and implement application database code objects by understanding business requirements.
• Coordinate between project management and development teams.

Environment: Oracle 9, PL/SQL, Windows XP