SUMMARY:

• Over 8 years of IT experience with expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle, MS SQL server, Netezza, DB2, Sybase and Teradata databases on windows and UNIX platforms.
• Expert level experience in Data Integration and Data Warehousing using ETL toolINFORMATICA PowerCenter/PowerMart5.x/6.x/7.x/8.x/9.x,IDQ,(SourceAnalyzer,WarehouseDesigner, Mapping/Mapplet Designer, Sessions/tasks, Worklets /Workflow Manager). Knowledge of Informatica tools Power Exchange, Power Analyser, Power Connect, Data Mart, OLAP and OLTP.
• Good Knowledge in working with Informatica B2B Data Transformation to handle the mainframe data, XML and Flat Files
• Experience in Informatica B2B Data Exchange using Unstructured, Structured Data sets.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions). Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Good knowledge of Data Profiling guidelines and best practices using IDQ.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, TeraData, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER.
• Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications, COBOL Sources, Mainframes and Teradata.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experience in Performance Tuning of targets, mappings and sessions.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation.
• Expertise in logical and physical database design and Data Modeling using data modeling tools like Erwin.
• Experienced in using Microstrategy, Crystal Reports to build user defined queries and reports to enable drill-down and slice and dice analysis on multiple databases.
• Thorough knowledge of Software Development Life Cycle including Planning, Analysis, Design, Implementation, and Maintenance.
• Experience in Task Automation using UNIX Shell Scripts, Job scheduling (ESP) and Communicating with Server using pmcmd.
• Domain Data warehousing experience including Insurance,Investment banking, Credit card, and Pharmaceutical. Proven ability to implement technology based solutions for business problems.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Databases: Oracle 7.x/8.x/9x/10g/11g, SQL Server 2008/2005/2003/2000, DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access. Editors ( SQL Navigator, Toad),Netezza,Teradata, Hadoop 2.X

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x/6.x/5.x, Power Connect, Power Exchange, Informatica IDQ 9.6, Oracle Warehouse Builder, Microsoft DTS.

Data Modeling: ERWIN, Visio

Analysis/ Reporting Tools: Microstartegy, Business Objects, Microsoft Analysis Services, MS SQL server 7.0 OLAP services, Oracle OLAP, Oracle Reports, Crystal Reports 10 and Informatica Power Analyzer.

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, JAVA (Eclipse IDE and Net Beans IDE), HTML,COBOL, JAVA Script, J2EE, CSS.

Environment: Sun Solaris, UNIX, HP-UX, IBM-AIX, WINDOWS XP/NT/ 2000/98/95, Mainframe, AS/400.

PROFESSIONAL EXPERIENCE:

Confidential,Richmond,VA

Senior Informatica developer

• Involved in loading the business data from various relational sources or Flat files using Informatica and Teradata load tools.
• Developed Teradata database objects or written the SQL Scripts according to business rules.
• Development of ETL jobs through development and change requests.
• Used Structured and Unstructured Data like PDF files, spreadsheets, Word documents, legacy formats, and print streams option to get normalized data using B2B Data Exchange of Informatica.
• Performance tuning of existing ETL jobs.
• Knowledge in FINANCE, TAX and LEGAL arena and good understanding of System Designs, Reporting Requirements, Data Quality Management,etc.
• Used various transformations in IDQ to cleanse and enrich data using Standardizer, Decision, Exception and Consolidator.
• B2B Data transformation supports transformation and mapping.
• Implemented Monthly audit process for the HRA(HEALTH RISK ASSESSMENT ) subject area to ensure Data warehouse is matching with the source systems .
• Developing TWS jobs (like Teradata, Informatica jobs) and scheduling them which in turn call UNIX scripts and Informatica Workflows to give desired results.
• Unit Testing and planning of developed code including preparation of Unit Test case documents.
• Participate in activities which include Code Review and Peer Code Review.
• Involved in the Confidential run books preparation which are used for production support.
• Used Informatica Designer Tool to develop mappings for Extraction, Transforming and Loading required data into the OLTP System and then OLTP data into the Data Warehousing.
• Involved in Tier 3 production support activities like code fixes and performance tuning.
• Actively participated in weekly Iterative status meetings to track the progress for each iterative cycle and figure out the issues.

Environment: Teradata DW 14.10, Informatica IDQ 9.6, Informatica B2B Data Exchange, Teradata utilities and Teradata Viewpoint, Informatica 9.6.1, TWS scheduler, UNIX.

Confidential,St. Louis,Missouri

Senior Informatica developer

Responsibilities:

• Involved in loading the business data from various relational sources or Flat files using Informatica and Teradata load tools.
• Developed Teradata database objects or written the SQL Scripts according to business rules.
• Used Informatica B2B Data Exchange to Structured data like XML.
• Development of ETL jobs through development and change requests.
• Performance tuning of existing ETL jobs.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Developing TWS jobs (like Teradata, Informatica jobs) and scheduling them which in turn call UNIX scripts and Informatica Workflows to give desired results.
• Unit Testing and planning of developed code including preparation of Unit Test case documents.
• Participate in activities which include Code Review and Peer Code Review.
• Involved in the Confidential run books preparation which are used for production support.
• Involved in Tier 3 production support activities like code fixes and performance tuning.

Environment: Teradata DW 14.10, Teradata utilities and Teradata Viewpoint, Informatica B2B Data Exchange, Informatica 9.1, TWS scheduler, UNIX.

Confidential,Louisville,KY

Senior InformaticaDeveloper

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules & made recommendations for innovative IT solution
• Involved in analyzing scope of application, defining relationship within & between groups of data, star schema, etc.
• Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema.
• Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Created pre-session and post-session shell scripts and mail-notifications.
• Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
• Used TOAD to develop oracle PL/SQL Stored Procedures.
• Assigned Broadcast Agent to various groups using Web I Admin Console.
• Extensively worked on the Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Employed performance tuning to improve the performance of the entire system.
• Performed Pipeline partitioning to speed up mapping execution time.
• Creating the design and technical specifications for the ETL process of the Confidential .
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Involved in interactions with the batch scheduling team and the Autosys team, who scheduled most of the processes on the Remote UNIX Box.
• Extensively used Business Objects for report generation.
• Created test cases and run the cases using Mercury Quality Center

Environment: Informatica Power Center/Power Mart 8.1/7.1.2, Power Center Designer, workflow manager, workflow monitor, Oracle10g/9i, PL/SQL Developer, SQL Server 2000, Business Objects, Netezza, Mercury tools (QTP, Quality Center), UNIX, Windows XP, TOAD8.0.

Confidential,Phoenix, Arizona

Senior Informatica Developer

• Participated in build of the Data Warehouse which includes the Design of Data mart using Star Schema
• Created Dimension Tables and Fact Tables based on the warehouse design
• Involved in Extraction, Transformation and Loading (ETL) Process
• Extensively worked on Informatica to extract data from flat files and Oracle, and to load the data into the target database.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Aggregator) inside a Mapplet and created new mappings using Designer module of Informatica.
• Extensively worked on the performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions
• Drilled out each of the data flow on a page to plan which tables to work on, and for sequencing the transformations within each data set
• Created Stored Procedures for data transformation purpose
• Created Work lets to run several sessions sequentially and concurrently
• Developed schedules to automate the updated processes and Informatica Sessions/Work lets
• Extensively used Sorter, Aggregator transformations to improve the performance at mapping level.
• Created and used the Normalizer Transformation to normalize the flat files in the source data.
• Extensively used the Slowly Changing Dimensions-Type II in various mappings.
• Used debugger to test the data flow and fix the mappings.
• Created the Source and Target Definitions in Informatica Power Center Designer
• Created Reusable Transformations to use in Multiple Mappings
• Created Sessions using Work Flow Manager and Monitored the performance of the session through Gantt chart, Task View in Work Flow Monitor.
• Wrote Stored Procedures using PL / SQL for Incremental updates
• Integrated various sources in to the Staging area in Data warehouse to Integrating and Cleansing data.
• Used AutoSys Scheduler to schedule the sessions.
• Maintained mapping versions using PVCS.
• Performed Unit Testing.
• Assisted & Collaborated in generation of a complete set of reports using Business Objects to target different user segments.
• Sending the updated status report to the client/vertical manager on weekly basis.
• Discuss the issues and projects status in status call on weekly basis.

Environment: Informatica PowerCenter/PowerMart 7.0, XML, DB2, Workflow Manager, Informatica Power Connect, Workflow Monitor, ERWIN, windows 2000, Oracle 9i, PL/SQL Developer, Toad, Win Runner, UNIX, SQL LOADER, Microsoft Excel.

Confidential,Columbus,OH

Informatica developer

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. As a tech leadInvolved in the complete life cycle of the Confidential .
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Extensively used Oracle,Netezza,Flat file,XML file,DB2 dataas source and target
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Trouble shooting of long running sessions and fixing the issues.
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Developed shell scripts for Daily and weekly Loads and scheduled using ESP.
• Involved in writing SQL scripts, stored procedures and functions and debugging them.
• Studied very complex Pl/SQL procedures and converted them in to informatica mappings
• Worked with DBA’S and participated in query tuning
• Participated in Oracle 11g migration Confidential
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of Confidential from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with the business users directly and created the required reports using Microstartegy reporting tool.
• Used IBM I series tool to extract the data from DB2.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Because of using Agile Methodology we have Face to face communication and continuous inputs from other team member leaves no space for guesswork
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Involved in many small projects where only PL/SQl or Informatica required working with Hadoop as it has the capability to run applications on multiple nodes involving thousands of terabytes of data

Environment: oracle 11g/10g,Informatica PowerCenter 9.1.0,PowerExchange, Netezza,ESP,Unix Shell Script, Erwin, Micro strategy, Putty, DB2, Mainframe COBOL, Toad 10, SQL PLUS,SQL-Loader, IBM I series, Hadoop 2.5.0,Agile Methodology

Confidential

ETL Developer

• Involved in design, development and maintenance of database for Data warehouse Confidential .
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.X.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 7 transformations.
• Working on SQL, PL/SQL, Proficiency in developing SQL with various relational databases like Oracle, SQL developer, MYSQL, TOAD.
• UNIX Shell Scripting
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.

Environment: Informatica 8 x, Oracle, Flat Files, UNIX, Winscp, Putty, Remedy SM.