SUMMARY:

• 12 years of experience in the IT industry with multiple technologies
• Excellent communication skills, strong decision making skills, organizational skills, ability to work in a team or individually and ability to pick up new skills quickly
• Experience in product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation
• Sound understanding of Data warehousing project life cycle, Dimensiona l Modeling, ETL Development and Business Intelligence.
• Expertise in developing scalable enterprise applications to the user needs which serves for Insurance, Oil & Gas, Banking, BioTechnology, Distribution.
• Experience in Data Mining, Data Profiling and analyzing the data to identify the Business Logic and also to determine facts and Dimensions
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Designed and developed a series of complex Business Intelligence solutions using Pentaho Report Desginer
• Strong experience in Design, Development, Deployment, and testing of Universes using Business Objects Designer against SAP Business Objects and Relational databases (Oracle, MS SQL Server, DB2 sources)
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Implemented complex business rules by creating re - usable transformations, and robust mappings.
• Create a test case scenarios based on the BRD.
• Good working knowledge on SAP BI/BW 7.0 with exposure on BEx queries, BEx Analyser, Info cubes
• Acted as a link between business and developers to identify and report bug.
• Good understanding of the QA life cycle from test plan, test execution to Defect tracking & Test Metrics reporting.
• Also, Implemented Update strategies, Incremental loads and Slowly changing dimensions
• Performed performance tuning
• Involved in creating web service mappings/Real time Mappings using Informatica Power Center to provide real time data services.

TECHNICAL SKILLS:

ETL/Data Modeling Tools: Informatica Power Center 9.5/9.1/8.6/8.1.1/7. x/6.x(Designer, Work flow Manager &Work Flow Monitor) Power Mart 6.2/5.1/4.7 Power Connect and Power Exchange, Ascential Data Stage, ER win r8.x/r7.x/4.x Dimensional Data Modeling(Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables)

BI/OLAP Tools: Business Objects XI/6.5,Cognos8 BI, ReportNet1.1/1.0 (Report studio, Query studio, Analysis studio, Framework Manager), Cognos EPSeries5.2/6.0/7.x(Impromptu,Powerplay,PowerPlay Transformer), Pentaho

Databases: Oracle 11i/10g/9i/8i,MS SQL Server 2008/2005/2000 , Teradata, DB2, and MS Access 2003, ANSI SQL,Transact SQL

Languages: C, C++,SQL,PL/SQL,T-SQL, UNIX, Shell Programming, XML

OS: Windows 2010/2007/2003/2 K/XP/NT//98, IBM AIX 5.1, HP Unix

Packages/ Other: Toad 11.6/12.0/8.6.1/8.5.3 SQL * Loader, Teradata SQL Assistant, SQL Query Analyzer, Enterprise Manager, MS Office, lotus 123,EXCEL CNTRL M, Autosys, Tivoli & TFS, SQL developer

PROFESSIONAL EXPERIENCE:

Confidential, Rockford, IL

Sr. ETL Informatica Developer

Responsibilities:

• Define data requirements, gather and validate information
• ETL design documentation using Confluence
• Create and implement configuration management guidelines and standards; maintained configuration control for concept project start-up for wide range of products, including drawing repositories, technical and process documentation
• Responsible for gatekeeping code promotions from Development environments to higher environment (Prod) making sure none of the code is overwritten by multiple developers
• Maintain control over the quality of deployments and code; developers project briefs for business teams
• Performed ETL & DB code migrations across environments
• Designed, coded, tested, and documented complete customized application solutions for Data Quality integration.
• Development, improvement, optimized and maintained of ETL process using Informatica Power Center 5.1 and Oracle.
• Follow established processes and manage change requests; compose discrepancy reports, action items and change proposals for CCB (Change Control Board)
• Structure SharePoint Site (CMDB) to manage repository of 1600+ artifacts; facilitate deliverable tracking and retrieval
• Responsible for designing and development of reports and dashboards from SAP BI/BW and the relational data sources from the warehouse
• Experience in creating cubes by using Pentaho Schema Workbench.
• Used Pentaho Data Integration Designer to create ETL transformations
• Initiated SQL DB queries and XML server requests to extract data.
• Pentaho schema workbench to design analysis and dashboards, and designing interactive reports with Petaho report designer
• Responsible for designing and development of reports and dashboards from SAP BI/BW and the relational data sources from the warehouse
• Strong experience in Design, Development, Deployment, and testing of Universes using Business Objects Designer against SAP Business Objects and Relational databases (Oracle, MS SQL Server, DB2 sources)
• Extensive experience using Sales force Administration (SFA), Profiles, Creating Roles, Page Layouts, Org-Wide default, Sharing rules, Work Flows, ApprovalWorkflow, Reports/Graphs and Dashboards.
• Worked with the user group for requirement gathering throughout the planning and implementation
• Worked with various salesforce.com Standard objects like Accounts, Contacts, Leads, Cases, Campaigns, Reports, and Dashboards.
• Created Reports and Dashboards to track Opportunity pipeline/Stages for Management visibility.
• Interacted with the SalesForce.com premium tech support team on a regular basis.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Functional and Technical Specification documents creation and gathering approval from leadership
• Built mappings to load data from Siebel to Salesforce objects
• Designed data models to do one-time full load into salesforce and bridge the delta data from salesforce back to Siebel
• Performed detailed data qualify analysis by comparing record count and column values
• Agile Scrum/Sprint environment
• Configured email delivery system when records fail to get updated or inserted into salesforce as part of exception handling
• Modified mappings to go through cipher cloud encryption and extensive testing of encrypted data on cloud
• Data extraction and transformation from salesforce to data warehouse system
• Fixed various connection issues those raised during the development phase
• Troubleshooting and solutions for production issues.
• Designed and implemented customized multi-national Address Standardization process using IBM Web Sphere Quality Stage v 7.5 for PCCM Migration and Integration process for the MDM.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Expertise with JIRA, Bugzilla
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Maintained and monitored software and hardware configurations for classified networks.
• Maintained and updated configuration control item inventory.
• Established QA practices thereby improving test planning, test coverage and quality of unit tests
• Prepared and reviewed configuration item state documentation.
• Lead offshore and onshore QA team - total of 4 people and acted as Customer facing QA Lead Onsite.
• Design the ETL flow to load the data into hive tables.
• Performing ETL & DB code migrations across environments
• Verified controlled item configuration through periodic audits.
• Used ETL methodologies and best practices to create ETL jobs
• Supervised change request and implementation processes for select controlled items as required.
• Designed developed and implemented configuration management and change control programs.
• Managed and reviewed all process policy statements training manuals and relevant supporting documentation.
• Good Communication and interaction skills with onsite/onshore, offshore and multiple vendors
• Handled change order processing for systems hardware software and related equipment

Environment: Informatica Power Centre 9.5, Enterprise edition v6 Oracle 11g, Erwin, SQL developer, Unix Shell Scripting,, Putty, SQL, PL/SQL,, Windows 8., Control-M, Toad-DB2, service now, clear Quest, WinSCP, Note pad++, Sharepoint 2013, Xenapp Citrix, Medmeasures, Pentaho BI.5.0.1,

Confidential, Berkeley, CA

Sr. ETL/Informatica Developer

Responsibilities:

• Interacted with business representatives, source system developers in correlating business specifications, identifying data sources, Development strategies and for defining Data Extraction Methodologies.
• Analyzed the functional specifications/mapping exercise document provided by the Data Architect, Data Modelers and created technical specification documents, Detail design documents, source to target mapping specifications and Lineage doc for all the mappings.
• Implemented and Managed ETL Operations team, initiated best practices to create a knowledge base and all the Operations related reports
• Designed, coded, and tested the Information Server components for MDM integration.
• Worked as on call Production support for ETL Operations
• Designed and developed Complex Mappings &Workflows for implementing customer information
• Implemented Type1 and Type 2 & Incremental aggregation complex scenarios using Informatica 9.5.1
• Created mappings by using various transformations like Filter, Expression, SQL transformation, Dynamic Lookup Cache, Sequence Generator, Update Strategy, Joiner, and Router to transform the source data from multiple source systems.
• Performed tuning of mappings, sessions, workflows including partitioning, memory tuning, and cache management.
• Written complex SQL’s and edited Informatica SQL override & look up override to improve the performance.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations
• Involved in unit testing, system testing & integration testing to check the consistency and accuracy of the data in target with respect to different source systems using Quality Center.
• Monitored and troubleshoot workflows, sessions for daily and Monthly extracts from multiple disparate sources across all platforms to the target data warehouse.
• Created UNIX scripts for file validations and back ups
• Worked on SAP BW 7.0 analyzing the existing BW modeling, created BEx reports on top of info cube
• Worked on planning, designing, developing, distributing and maintaining Universes with SAP BI/BW BEx queries as a data source
• Played crucial role in adding value to the project by completing the project within budget and time so that maintained the trust of the business users.
• Primary on-site technical lead during the analysis, planning, design, development, and implementation stages of data quality projects using Integrity Scheduled the Workflow jobs and performed On call support responsibilities during go live and warranty period

Environment: Informatica 9.5.1, Oracle 11i, Control-M, UNIX, Toad, Erwin, Flat files, Excel files, Quality Center.

Confidential, SFO, CA

ETL/Informatica Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Designed, coded, and tested the Information Server components for MDM integration.
• Extracted sources from flat-files and load them into Oracle. Used Data Stage for repository submission, file management and access to the end users.
• Worked with Query Manager Tool in Teradata for testing purpose.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations.
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data warehousing designer, Mapping Designer, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Extensively used Informatica to load data from Flat Files, mainframes to Oracle
• Worked on CRM systems for marketing to help the enterprise identify and target potential clients and sales team
• Created reusable transformations and Mapplets and used them in mappings.
• Created Reports using latest version of OBIEE. Worked with oracle data warehouse architecture console.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Used Informatica Power center work flow manager to create sessions, work flows and work-lets to run with the logic embedded in the mappings.
• Fine-tuned Transformations and mappings for better performance.
• Involved in the process in documentation of source-to-target documentation, design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.
• Created complex mappings and transformations.
• Performed Unit Testing and tuned for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Created dimensions and facts in the physical data model.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.

Environment: Informatica 9.1, SQL Server 2008, XML, COBOL, Control-M, UNIX, Toad, Erwin, Flat files, Excel files, XML, Windows 7/XP.

Confidential, Burbank, CA

ETL Developer

Responsibilities:

• Extracted data from source systems and loading into the staging tables and then into Data mart & ODS based on the business rules.
• Implemented Informatics CDCmappings using Oracle log miner & Power exchange
• Handled huge marketing data while populating data warehouse type 2 mappings
• Applied file checks, Audit Balance Control (ABC) checks, pre-ABC checks, and Statistical Process Control (SPC) checks on the data and sending the results to concerned business people for decision making on loading the data into the data warehouse.
• Designed, coded, tested, and documented Integrity (now known as Quality Stage) name and address data quality products for the United States, Canada, Great Britain, Germany, France, Spain, Italy, and Australia.
• Developed, Designed, Lead, Installed, Upgraded, Administered, Best Practices and hands on training, and perform Performance Tuning
• User Informatics designer to create and manipulate source, target definitions, mappings, transformation, and mapplets.
• Used various transformations like Normalizer, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, and Joiner.
• Performed Activities in UNIX environment, writing UNIX shell scripts for Informatica pre & post session operations
• Created reusable sessions and workflows using the workflow manager.
• Tuned Informatica mappings and sessions for better performance using various strategies based upon the analysis performed.
• Worked on planning, designing, developing, distributing and maintaining Universes with SAP BI/BW and relational databases (IBM DB2) as the data sources
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Developed UNIX scripts and SQL scripts to configure the database tables to perform different kinds of checks.
• Designed and formatted crystal reports that have SAP BW as data sources using BW query driver.
• Developed documentation for the ETL processes.
• Performed duties of a production support personnel such as identifying the cause of failure, rectify the problem or notify appropriate personnel

Environment: Informatica 9.0.1, Oracle 11g, Teradata 13, Control-M, Unix, Toad, Erwin, Flat files, Excel files, XML,Windows 7/XP.

Confidential, Coopersberg, PA

Informatica Developer / Tester

Responsibilities:

• Involved in design, development and maintenance of the Application
• Gathered business requirements and created design documents
• Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Created and maintained a several Database objects including tables, Indexes, stored procedures
• Created Views from extracting data from various tables for Report Generation
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Manual execution of Test cases.
• Modified PL/SQL code in the forms to adhere the syntax change
• Developed forms screens to enter customer information
• Created new stored procedures and modifying the existing ones
• Tested the ETL mappings from Source to Target tables.
• Worked on improving the Query performances
• Prepared the different test scenarios and tested the SQL queries and stored procedures
• Conducted the Weekly Status meetings to Review/generate reports on the development of the software

Environment: SQL, PL/SQL, Oracle Forms, Oracle 8i, MS Access, Windows NT, UNIX

Confidential, West Chester, PA

Informatica Developer/ Tester

Responsibilities:

• Designed ETL mapping document to map source data elements to the target based in Star-Schema dimensional model
• Performed Client Regression testing with help of Test Cases, Requirement documents and Wireframes.
• Involved in designing of star schema based data model with dimensions and facts
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Designed and developed complex mappings using various transformations in Designer to extract the data from relational sources like Oracle, SQL Server, and non-relational source like flat files to perform mappings based on company requirements and load into Oracle tables
• Worked extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement
• Performed end to end system Integration testing.
• Preparation of Test checklist for deployment testing.
• Worked on Informatica repository manager for creating users, groups, assigning Read, write, execute privileges for Users by assigning users to groups, creating folders
• Worked on Power Exchange CDC option to distill updates from unchanged background data and to deliver them to multiple targets without intermediate queues or staging tables
• Used different tasks (Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
• Created pre-session and post-session shell scripts and mail-notifications
• Worked with tools like TOAD to write queries and generate the result

Environment: Informatica Power Center 8.1.1 (Designer, Workflow Manager, and Workflow Monitor), Solaris, Oracle 9i, Informatica Power Exchange, SQL Server 2005, PL/SQL, Flat files, XML Files, ERwin, TOAD