SUMMARY

• 7 years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Pharmaceutical, Insurance and Telecom Industries.
• Informatica: 6 years of Data Warehousing experience using Informatica Power Center 8.6.1/8.1.1/7.1.1/7.0/6.1 , PowerMart5.1.1/5.x,WarehouseDesigner,Power Exchange, OLAP, OLTP, Autosys, Control M, Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Data Analysis strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Data Modeling experience on Data modeling, ERwin 7.1/4.5/4.0/3.5.5/3.5.2 , Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Data Cleansing experience using Trillium 7.6/6.5 (Converter, Parser, Converter & Geocoder), Firstlogic 4.2/3.6, UNIX Shell Scripting and SQL coding.
• Business Intelligence experience using OBIEE10.1, Cognos Series 8.3/7.0, Business Objects XI R2/6.5/5.1, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), SQL Server Integration Server (SSIS), MS Access Reports.
• Methodologies: Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Databases using Extract data Oracle 11g, Oracle 10g/9i/8i/7.0, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, MS Access 7.0/2000.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6.1/8.1.1/7.1.2/7.1.1/7.0/6.1 , Power Mart5.1.1/5.x, Informatica Power Connect, Informatica Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP,Mapplet, Transformations, Autosys, Control M, SQL*Plus, SQL*Loader, Netezza 6.0

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.1/4.5/4.0/3.5/3.2

BI Tools: OBIEE10.1, Cognos Series 8.3/7.0

Databases: Netezza 6.0, Oracle Exadata 11g, Oracle 10g/9i/8i/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/ 2000/7.0/6.0 , Teradata V2R6/V2R5 MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, PERL Programming

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

PROFESSIONAL EXPERIENCE

Confidential

ETL /SQL Developer

Responsibilities:

• Experience with implementing ETL processes and Data Warehousing methods and technologies.
• Used Informatica client toolsSource Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository ManagerandInformatica Workflow Managerand OBI Tools.
• Create mappings with shared objects/Reusable Transformations/Mappletsusing Mapping/Mapplet/Parameters/Variables.
• Cleansing and processing data from stage toData martsusing Informatica transformations.
• DesignedSCD Type 1andType 2mappings.
• Extensively used transformations like lookup, Router, Aggregator, sequence generator, filter, update strategy, joiner.
• Using Incremental method strategy for all Informatica mappings.
• Used SQL to query the database and involved in SQL optimization of existing queries.
• Extensively worked in the performance tuning of programs,ETL proceduresand processes.
• UsedDebuggerto test thedata flowandfix the mappings.
• Used to load data and analyze data.
• Develop high level and detailed level technical and functional documents and data modeling document. Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, mask the data needed and Load it into data marts.
• Bulk load the database tables from flat files usingOracle SQL Loader.
• Provide test data inQA/UATfor the downstream application testing.
• Created SSIS Packages to migrate slowly changing dimensions.
• Used JIRA for raising and locking defects and also used for tracking defects.
• Performed Data ware house testing for the data loaded through bulk and incremental.
• Performed report testing for various kinds of reports through SQL server.
• Performed performance testing for reports in all the environments.
• Experience in writing Business System Design Documents (BSD).
• Worked on usingSSIStools like Import and Export Wizard, Package Installation.
• Integrated various sources into the Staging area in Data warehouse
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica8.6/& 9.1Integration servers.
• Experience in writing Business System Design Documents (BSD).
• Designed a process using GPG commands and Informatica command prompt to encrypt and decrypt the files.

Confidential, MD

ETL Developer

Responsibilities:

• WrotePL/SQLprocedures which are called fromStored Proceduretransformation to perform database actions such as truncate the target before load delete records based on a condition and rename the tables.
• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter,Normalizer,SQL Transformation,Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Scheduled ETL packages to run on Daily, Weekly and monthly using SQL server Agent.
• Used data miner to process raw data from flat files
• Proficient in implementing all transformations available on the SSIS toolbox.
• Working on change requests to the existing processes in production.
• Created SSIS Packages to migrate slowly changing dimensions.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• UsedEvent wait Task, Control Task, Email Tasks, Command Tasks, Link conditionsin workflows.
• Used JIRA for raising and locking defects and also used for tracking defects.
• Performed Data ware house testing for the data loaded through bulk and incremental.
• Performed report testing for various kinds of reports through SQL server.
• Performed performance testing for reports in all the environments.
• Experience in writing Business System Design Documents (BSD).
• Provide test data inQA/UATfor the downstream application testing.
• Worked on setting up column level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, mask the data needed and Load it into data marts.
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica8.6/& 9.1Integration servers.
• UsedDTS/SSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data marts and performed action in XML.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs
• Understanding ofSSAS, OLAP cube and Architecture.
• Building and testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Environment: Informatica Power Center 9.1, Netezza, Oracle11g/10g, OBIEE, SQL, PL/SQL, SQL*Loader, Toad, UNIX Shell Script, Win XP, Business ObjectsXiR2.

Confidential, Richmond, VA

ETL/Informatica Developer

Responsibilities:

• Wrote unix scripts to call the files from Landing zone and process the files.
• Created PRE ETL scripts to validate the files and file format which we receive from the Source system.
• Extracted data from flat files applied business logic to load them in the staging database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.1.
• Wrote Oracle packages and functions to implement business rules and transformations after staging is done.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Imported data using SSIS packages and using custom SQL server stored procedures.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
• Have Knowledge on IBM Curam management tool.
• Used SSIS packages to load date from spreadsheet into the database and also used packages to move data between databases (oracle, flat-files) on different servers.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Worked on different data sources such as Oracle, Teradata, Flat files etc.
• Created complex mappings in Power Center Designer using Normalizer, Aggregator, Router, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner.
• Developed Jil files for scheduling the informatica configuration in Autosys.
• Created Informatica Mappings to populate the data into dimensions and fact tables using Oracle BI Apps.
• Working knowledge on DataWareHouse Admin Console (DAC) to schedule jobs for Fact and Dimension tables.
• Wrote Oracle packages and functions to validate the Pre and Post Exceptions in the process of sending Exception files and Response files to Source System.
• Extensively used Java and CLOB files to Extract the files in the process of sending files to Source System.
• Involved inboth front end and back end testing.
• Extensively used HPALM 11.0 for executing test cases and raising and tracking defects.
• Involved in coordination onshore/offshore teams.
• Involved in collecting the test data for System andEnd to Endtest.
• Worked with others through mentoring to ensure all given tasks are completed on time.
• Created Load Status Report, Load Status Report - Detail, Load Distribution Report, Load Performance Report to find the status of jobs across all verticals using OBIEE.
• Responsible for validated System Integration Testing for the code developed.
• Used HP Quality Center 9.2, prepared test case documents, test plans and validated the test cases in HP Quality Center 9.2
• Prepared Technical design documents, High Level Design documents and Low Level Design Documents.

Environment: Informatica Power Center/ Power Mart 8.6.1, Oracle Exadata 11g, Teradata, OBIEE, Oracle BI DAC, SSIS, Erwin, Toad, HP Quality Center 9.2, Autosys, Team Foundation Server (TFS), WinSCP, Filezella, Windows 2003, UNIX, LINUX, Microsoft Visio.

Confidential

ETL Developer

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 7.1.4/8.6.0.
• Knowledge in upgrading from Informatica version 7.1.4 to 8.6.0.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.0./7.1.4 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center/ Power Mart 8.6.1/7.1.4 , Oracle 10g/9i, Erwin, UDB DB2 8.1, Windows 2003, UNIX,PL/SQL

Confidential

Software Test Engineer

Responsibilities:

• Understanding the Scenarios based on Joint Requirement Document.
• Involved in Daily status calls held with Onshore Business Team, SME and off shore Development Team.
• Actively involved in Preparing Scenarios, Preparing and executing Test Cases, Defect Tracking.
• Responsible for Sanity Testing, Regression testing and Functional Testing, Browser Compatibility Testing, Accessibility Testing.
• Preparing Daily Status Reports.
• Coordinating with different teams like development, testing teams of different integrated applications and also the data team, as many teams are involved in it.
• Helping other teams of project like Progression and Regression in planning and execution phase.
• Analysis of the specifications provided by the clients and coordinating with onsite coordinator for the same.
• Performed Sanity testing, Ad-Hoc testing of the application builds,
• Involved in defects tracking and Defect Verification activities for the web based application.
• Involved in adding the requirements in Requirements tab and done the requirement mapping for the planned test cases in QC.

Environment: Java, Oracle, HP ALM (Testing tool)