SUMMARY

• 8+ years of IT experience in software analysis, design and development for various software applications in client - server environment.
• Experience in (ETL) INFORMATICA (Power Center, Power Exchange 9.0/8.x/7.x/6.x).
• Extensive experience on SQL, PL/SQL in creating Views, functions, Triggers and Stored Procedures in Data Warehouse environments that employ Relational databases like Oracle, DB2 and SQL server.
• Experience in integration of various data sources with Relational Databases like Oracle, SQL Server, XML Files and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in Informatica performance tuning methods and Data Quality.
• Extensive Experience in loading the data from Flat file, XML, Oracle, DB2 to SQL Server, Oracle as the Target with Informatica.
• Proficient in Data Modeling using Erwin tool for creating physical and logical data models. Managed ODBC connections in almost all the projects.
• Expertise in writing/debugging/enhancing UNIX Shell Scripts.
• Expertise in creating Financial Reports using Informatica.
• Good work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Designed develop and organized complex Informatica mappings, sessions and workflows.
• Developed technical design documents and mapping specifications to build Informatica mappings to load data into target tables adhering to the business rules.
• Analyzed source data for potential data quality issues and address these issues in ETL procedures.
• Actively participated in design and analysis sessions with Architects to ensured solid designs.
• Worked closely with the platform leads to apply standards and evolve process to ensure solutions abide by best practice principles.
• Conducted code reviews and quality control for all deliverables.
• Translated ETL logic into test plans and scenarios.
• Contributed to testing, dynamic debugging and performance tuning of any ETL bottlenecks.
• Excellent interpersonal and analytical skills with strong ability to communicate effectively.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center (9.1, 8.6/8.5, Power Exchange 9.1, Informatica Power Analyzer)

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling.

Data Bases: Oracle9i/10g, MS SQL Server 2008, DB2.

Tools: Reflection FTP Client, TortoiseSVN, IBM Mainframes.

Languages: Mercury Quality Center.

Operating Systems: SQL, PL/SQL, XML, Unix Shell Scripting. MS Windows95/98/NT/2000/XP, Linux, IBM Mainframes.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. ETL/Informatica Developer

Responsibilities:

• Responsible to attend the meetings with the business team to discuss about the requirement and developed the STM and POC as per the details provided.
• Understanding requirements and preparation/review of High level, Low level design documents and technical specification documents.
• Implemented business plan based on required technical and business needs.
• Developed ETL processes to extract the source data and load it into the Operational Data Store after cleansing, transforming and integrating.
• Developed and designed jobs using Informatica Designer based on mapping specifications using appropriate stages.
• Extensively used Informatica Designer to design, develop ETL jobs for extracting, transforming and loading the data.
• Developed common routine mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Used XML files as source tables and developed mappings to load the data from XML files to Flat files and relational tables.
• Implemented the design to generate reports for the financial and business team using Informatica.
• Created the Scripts and used command task in the workflow to archive the files.
• Worked with Mapping parameters and Variables, Pre SQL/Post SQL, Pre session and post session emails, decision tasks, command tasks in Mappings and Sessions.
• Exported the objects from the repository into the SVN Folder, created tags using TortoiseSVN and created Work assignments to migrate the code from Dev environment to Test or Production environments.
• Created the JCL to run the jobs in test or production environments using CA7 scheduler.
• Created source to target mapping documents, system design documents and production support documents.
• Used XML files as source tables and developed mappings to load the data from XML files to Flat files and relational tables.
• Implemented the design to generate reports for the financial and business team using Informatica.
• Created the Scripts and used command task in the workflow to archive the files.
• Wrote several SQL queries to extensively test the ETL process.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Co-ordinated with the Testing team in validating the test results with their Query results.
• Scheduled code review meetings and Production Support document Handoff meetings with the Infa team and Production support team before migrating to PRD environment.
• Involved in conference calls with Center for Medicare and Medicaid Services(CMS) while working on Health Information Exchange(HIX) Project.
• Involved in Deployment to Production Environment.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL, Mainframes, Flat files, UNIX Shell Scripts, CA7 Scheduler, Reflection Client, HP Quality Center.

Confidential, Miami, FL

Sr ETL/Informatica Developer

Responsibilities:

• Responsible for designing and development of Brokerage Data Warehouse (loan data mart).
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Coordinate and develop all documents related to ETL design and development.
• Involved in designing the Data Mart models with Erwin using Star schema methodology.
• Used repository manager to create repository, users groups and managed users by setting up privileges and profile.
• Used debugger to debug the mapping and correct them.
• Performed Database tasks such as creating database objects (tables, views, procedures, functions).
• Responsible for debugging and performance tuning of targets, sources, mappings and sessions.
• Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Implemented and documented all the best practices used for the data warehouse.
• Improving the performance of the ETL by indexing and caching.
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Code walks through with team members.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Created UNIX shell scripting for automation of ETL processes.

Environment: Informatica Power Center 9.1, oracle 10g, DB2 9.1, Erwin 7.0, UNIX, Windows XP, Business objects.

Confidential, Evanston, IL

Sr.Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used Informatica Power Center 8.1.1 to extract data from various sources and load in to staging database.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Used Power Exchange interface to get the data from mainframe files.
• Performed source data analysis .Primary data sources were from Oracle & SQL server 2005.
• Used batch process CDC (change data capture) mechanism in Power Exchange to get the recent data.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 8.1.1
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Participated in all facets of the software development cycle including providing input on requirement specifications, high level design documents, and user’s guides.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Controlled version documents using CVS.
• Implemented Slowly Changing Dimension methodology for accessing the full history.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in Unit testing and documentation.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, SQL Server 2005, Windows NT.

Confidential, KY

Informatica Developer

Responsibilities:

• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Integrated data into CDW by sourcing it from different sources like SQL, Flat Files and Mainframes (DB2 and VSAM) using Power Exchange.
• Extensively worked on integrating data from Mainframes to Informatica Power Exchange.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and Mapplets to load data from external flat files and RDBMS.
• Used output xml files, to remove empty delta files and to FTP the output xml files to different server.
• Used MDM to extract the file and for address standardization.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Created Audit tables, Control Tables, Chain of Trust to maintain the statistics of data.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, XML Transformations and Update Strategy & Sequence Generator.
• Used XML transformation to load the data XML file.
• Used XML Generator transformation accepts data from multiple ports and writes XML through a single output port.
• Used SQL, PL/SQL to validate the Data going in to the Data Ware House.
• Worked on Informatica Schedulers to schedule the workflows.
• Extensively worked with Target XSD’s in order to generate the output xml files.
• Used Message broker as translate messages between the interfaces.
• Created mappings to read parameterized data from tables to create parameter files.
• Good Experience in Co-Coordinating with Offshore.

Environment: Informatica Power Center 8.6.1, Power Exchange 8.6.1, Windows, IBM DB2 8.x, Mainframes, COBOL, SQL Server 2008, Erwin, BTEQ, Enterprise Architect, Meta data Manager, ER studio.

Confidential, Milwaukee, WI

Data warehouse Developer

Responsibilities:

• Developed Mappings for loading the data into database using Power Mart Designer
• Created transformations according to the business requirement
• Created Shortcuts for Sources and Targets
• Created workflows for the different tasks using Workflow Manager.
• Developed Event Wait Tasks for the workflow
• Developed Reusable Sessions
• Involved in Scheduling the workflows
• Created flat file targets
• FTP the Flat File target to Remote Server
• Creating Users, Folders, Assigning access Permissions to repository Users
• Developed Stored Procedures according to the requirement
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions
• Followed Star Schema & snowflake Schema for methodology to organize the data into database by using ERWIN tool.
• Created Global Repository, Groups, Users assigned privileges using repository manager.

Environment: Informatica 6.2, Oracle 9i, Peoplesoft8, DB2, Windows 2000, Toad, ASPPL/SQL, SAS.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Informatica Repository.
• Developed Mappings between source systems and Warehouse components.
• Developed Mapplets, Mappings and configured sessions.
• Extensively used almost all the transformations
• Created reusable transformations and Mapplets to use in multiple Mappings.
• Used debugger to test the data flow and fix the mappings.
• Designed the Data Model using Erwin 3.5 and integrating E - R models with the Oracle Database.
• Analyzed newly converted data to establish a baseline measurement for data quality in Data Warehouse.
• Performed Data Manipulation using basic functions and Informatica Transformation.
• Developed Mappings/Transformation/Mapplets by using Mapping Designer, Transformation Developer and Mapplet Designer in Informatica PowerCenter6.x.
• Developed Universes and reports using Business Objects Designer.
• Created, modified, maintained the business complex reports using Business Objects reporting module.