SUMMARY:

• Over 7 years of experience in analysis, design, development, testing and implementation of business applications using Data Warehouse/Data Mart applications.
• Good Understanding of Ralph Kimball and Bill Inmon Methodologies.
• Vibrant, result - aligned skill set in implementation of Business intelligence tools like Infomatica Power Center/Power Mart, IDQ, IBM Info Sphere Data Stage, Erwin, Business Objects, and IBM Cognos.
• Extensive experiences in designing Data Modeling methodologies like Star/Snow Flake Schema.
• Extensively involved in Software Development Life Cycle (SDLC) from Requirements gathering, preparing FSD/TDD, Development, testing & moving modules to production.
• Strong skills in requirement gathering, analysis, design and interacting with businesses users, to analyze teh requirement and business needs. Transform those requirements in to screens, business objects and document them for teh proper deliverables.
• Extensively worked with Informatica Designer tools - Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer. Also hands on experience in data profiling and cleansing by using IDQ.
• Hands on experience in working with different kinds of Sources in Source Analyzer like - Relational, XML, Flat files (both delimited and Fixed width flat files) etc.
• Experience in developing complex mappings in Mapping Designer by using Transformations like -Filter, Lookup, Expression, Aggregator, Router, Update Strategy, Rank Transformations etc,.
• Experience in creating or dealing with various heterogeneous targets like - Relational, XML, Flat files etc.
• Experience in creating/running Sessions, work flows and work lets in Workflow Manager by using Task Developer, Work Let Designer and Workflow Designer. Monitor teh jobs in Workflow Monitor.
• Extensive experience in developing mappings for Change Data Capture (CDC) and Slowly Changing Dimensions (SCD) type 1, 2 &3.
• Hands on experience in implementing Delta loads and Restartability for recovery purpose.
• Extensive experience in Parameterizing code in Mapping level, Session level and Workflow level. Also worked in creating Dynamic Parameter file generation.
• Experience in Meta data Tables configuration and control table’s configuration for code flexibility.
• Experience in Performance tuning of Sources, Targets, Mappings and Sessions.
• Experience in cleansing data by using Informatica Data Explorer or Informatica Data Quality (IDE /IDQ)
• Hands on experience with Unix Shell commands and Unix Scripting.
• Good Understanding of relational database management systems. Experience in integrating data from various data source like Oracle10g/9i, SQL Server, Flat Files, XML, Teradata, DB2, Sybase.
• Extensive hands-on experience in creating Stores Procedures, Functions, packages, and Triggers.
• Experience in Business Objects XI components such as Central Configuration Manager, Designer and Reporter (Desktop Intelligence and Infoview), and also experience in solving loops and traps while developing teh Universe.
• Experience in creating reports like Drill, Cross Tab, Charts, Dashboards and Scorecards.
• Experience in Cognos Report Net/IBM Cognos (8.x) components like - Transformer, Framework Manager, Powerplay and Access Manager. Also used studios like - Report studio, Query Studio, Event Studio for creating reports and scheduling.
• Experience in SQL server Integration Services and Reporting Services (SSIS and SSRS)
• Experience in testing teh application by using different testing methodologies like Unit, Integration, Regression Testing etc,.
• Worked with different operating systems like UNIX, Windows XP, Windows NT etc.
• Ability to work independently as well as in a team, demonstrated ability to work under challenging environment.
• Fun-Filled personality with excellent communication and interpersonal skills. Ability to quickly grasp new concepts, both technical and functional.

TECHNICAL SKILLS:

Data Warehousing

: Informatica Power Center 9.0.1/9.0/8.6/8.1.1/8.0/7.1.2/7.1.1/7.0/6.2/5.1.2/4.7, Power Mart 6.2/5.1.1/5.0/4.7.2, Informatica Power Analyzer, Informatica Power Plug, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Datamart, OLAP, OLTP, Mapplet, Transformations, Autosys, Control M, IMS Data (Xponent Plantrak, Plantrak, Rx Data), Siebel Warehouse 6.3, Siebel, SQL*Plus, SQL*Loader.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

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

BI Tools: Business Objects 6.5/6.0/5.1/5.0 (Web-Intelligence, 2.5 Designer 5.0 and Developer Suite & Set Analyzer 2.0), SQL*Loader, Pro* CToad, Discoverer, Cognos Series 7.0/6.0, Seagate Crystal Reports 8.0Microstrategy 8.0/7i, Data Reports, Developer 2000 (Forms4.5/5.0, Reports2.5/3.0), MS Access Reports.

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0 /6.0, Teradate V2R5/V2R4/V2R3, SAP R/3,SAP BW, Sybase 12.x/11.x, MS Access Erwin, Visio, Designer, SQL Navigator, TOAD, Tomcat, Rational Suite Performance and Visual SourceSafe (VSS), Control M, Connect Direct.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Visual Basic,.Net/6.0 /5.0, J2EE, HTML, DHTML, C, C++, Unix Shell Scripting, Kernel, ProgrammingPERL Programming, functions, packages, triggers, AWK, SQL Loader, DBA activities, SQA Basic, Developer/2000, Java, Swing, XML, Java Script.

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, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos, Windows 95/98/NT/2000/XP.

ETL Tools: Informatica (Power Center 9.0/8.x/7.x/6.x/5.x), IBM Info Sphere, Data Stage

Databases: SQL Server- 2000/2005/2008, ORACLE 11g/10g/9i/, Ms-Access2002/2003, DB2, MY SQL, Sybase, Teradata.

Database Tools: TOAD, SQL Developer, SQL Navigator 4.0, SQL Loader.

Data Modeling: Erwin 4.0/3.x

Reporting Tools: Business Objects(XI), Cognos(8.x)/IBM Cognos(8.x)

Web Technologies: ASP.NET, ASP Classic, HTML, DHTML.

Scripting Language: XML, CSS, Java Script, JQuery, VB Script, Servlets, JSP.

Languages: C, C++, C#, VB.NET, VB6, Java, PL/SQL, .NET.

Programming Tools: VisualStudio, Visual Basic

Operating Systems: UNIX, Windows 95/98/NT/XP/Vista

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville TX

Applications Developer

Responsibilities:

• Extensively worked in gathering Requirements, Design, Development, Testing and implementation of teh Business application.
• Extensively worked in creating Mapping Documents for new modules, and source to target mapping for existing modules for enhancements.
• Informatica TEMPhas been used to get data from different source systems like- Flat Files, Oracle, Sql Server, DB2 etc., and load data to different target systems like - Oracle Tables, XML’s, Flat Files, Sql Server Table etc.,.
• Also extensively worked with complex transformation logics by using transformations like - Transaction Control, Expression, and Aggregator etc.
• Extensively worked with XML’s as source, target. Also hands on experience in calling web services to create peregrines automatically.
• Extensively involved in designing and creating Metadata tables and application component tables, for code flexibility and efficiency.
• Extensively worked in implementing Restartability for code recovery purpose.
• Extensively worked with Unix Scripting to perform SFTP operations, kicking of workflows etc.
• Extensively worked in SQL and PL/SQL programming - Developed and Modified procedures, functions, views and triggers.
• Extensively worked in writing Unit test cases.
• Extensively worked in moving components from Dev, uat and production environments.
• By using CONTROM-M scheduled teh jobs.

Environment: Informatica Power Center9.0.1, Control-M, Oracle11g, SQL, PL/SQL, WindowsXP, XML, UNIX shell programming, TOAD, SQL Developer.

Confidential, Detroit MI

Applications Developer/BHI Operations

Responsibilities:

• Extensively involved in gathering Requirements, Design, Development, testing and implementation of teh application.
• Extensively coordinated with business user’s in-order to get uplift requirements, and also fixing teh issues.
• Informatica TEMPhas been used in-order to extract data from various sources and applied complex transformation logics and load to teh Targets.
• Extensively worked with Informatica Power Center Client tools like - Power Center Designer, Workflow Manager, and Workflow Monitor.
• Implemented transformations like - Expression, Filter, Aggregator, Router etc, for teh efficient load of data.
• By using workflow Manager created/modified Tasks, worklets and workflows.
• Monitor teh jobs by using workflow monitor.
• Extensively worked on Gap Analysis- Analyze teh existing code, finding teh issues and fixing them.
• Extensively worked on IDQ to do data profiling and cleansing, and also extensively worked on closing Issue tickets.
• Extensively involved in Infromatica upgrade from 7.1 to 8.6.
• Extensively worked in creating documents like - STM (Source to target Mapping), BIDR etc.
• Also involved in Developing/Creating Universe for reporting in Business Objects XI. Solved some of teh loops and traps while creating teh Universe.
• Used Webi and DeskI for reporting purposes, also involved in creating Dashboards.
• Extensively worked with Unix Scripting as well as PL/SQL programming like - writing /modifying stored procedures, triggers & functions.
• Extensively worked in writing Unit test cases.
• Extensively worked in moving objects from Dev, uat and production environments.
• By using Tivoli scheduled teh jobs.

Environment: Informatica Power Center 8.6/7.1.3, Business Objects XI, Tivoli, Oracle11g, SQL, PL/SQL, WindowsXP, XML, UNIX shell programming, PUTTY, Winscp, TOAD, SQL Developer.

Confidential, Dallas TX

Applications Developer

Responsibilities:

• Extensively involved in gathering requirements, design, development, testing and implementation of teh application.
• Extensively involved in BRD and Data Mapping Sessions. Based on Data mapping prepared ETL source to target mapping document.
• Informatica TEMPhas been used to extract data from various databases and flat files and applied complex Transformations logic and load to teh Targets.
• Extensively worked with Informatica Power Center Client tools like - Power center Designer, Workflow Manager, and Workflow Monitor.
• By using Mapping Designer, created/modified mappings based on teh requirements.
• Created mappings for Change Data Capture (CDC).
• Extensively worked with various source and Targets like - Relational, Flat files, XML etc.
• Worked on creating target flat file with EBCDIC supported data.
• Implemented transformations like - Expression, Filter, Aggregator, Transaction Control etc, for teh efficient load of data.
• By using workflow Manager created/modified Tasks, worklets and workflows.
• Monitor teh jobs by using workflow monitor.
• For code reusability and performance created mapplets, parameters and variable.
• Worked on Delta logic, to get data between previous to current session run.
• Involved in creating Dynamic parameter file generation.
• Extensively worked on SFTP Scripts to drop teh files in to Target Server location.
• Extensively worked with Oracle Data Base. Followed teh DRD doc for table/column naming standards.
• Extensively involved in modifying/creating stored procedures, triggers & functions.
• Extensively worked in moving Dev objects to UAT and Prod repositories/servers.
• In order to move teh objects to production created Enterprise Change Management System (ECM) along with Implementation plan. Also provided supported details like- Code review checklists doc and Migration checklist doc.
• Unit tested teh objects in UAT and also prepared unit test cases.
• Worked closely with Control-M team to schedule teh jobs.
• Provided Three weeks support to teh jobs, and also fixed few production issues.
• Prepared Process Run Book.

Environment: Informatica Power Center9.0/8.6, Control-M, Oracle11g, SQL, PL/SQL, WindowsXP, XML, UNIX shell programming, TOAD, SQL Developer.

Confidential, Tampa, FL

ETL developer

Responsibilities:

• Extensively involved in gathering requirements, analysis, development, testing and implementation of teh application.
• Preparing teh design documents based on teh Functional/requirements specification document for Subject Area’s like HRA, Product, Lab and Lab Integration by using MS Visio and getting signoff approvals from teh business users.
• Extensively interacted with users and involved in preparing various documents like Detailed Design/Mapping trackers for EDWard, Development to Production Migration plan, Integration test plan.
• Informatica TEMPhas been used to extract Historical and Incremental data from various databases and flat files and applied complex Transformations to support high speed load to teh targets such as Teradata and Flat files.
• Extensively worked with Informatica Power Center Client tools like - Powercenter Designer, Workflow Manager, and Workflow Monitor.
• By using Powercenter designer, imported data from different data source in source analyzer. Create target structure in Target designer, implemented mappings in Mapping Designer.
• Implemented transformations like Expression, Lookup, Router, Update Strategy etc, for teh fast and efficient load of data.
• For code reusability used Mapplet, Parameters and Variables.
• In Workflow Manager created various sessions, work flows and work lets by using Task developer, Worklet and Workflow designer.
• Monitor teh application jobs by using Workflow Monitor.
• Used Debugger to troubleshoot a valid mapping and gained information about data and error conditions.
• Extensively used Teradata utilities like BTEQ, Fast load, DDL and DML commands (SQL).
• Extensively interacted with Data Architect, Data base Administrators and Informatica admin for data model DDL submissions and Space estimations in multiple environments for Persistent and temporary data tables.
• Worked Extensively with WLM COA Team to Scheduled job sets of loading data used WLM tool.
• Also involved in SQL server Reporting Service (SSRS).
• Extensively worked to resolve teh defects in coding and updated teh status in Test Directory.
• Extensively worked with coding Unit Test Cases (UTC’s), Unit Testing, Integration Testing and Regression Testing thereby minimizing teh number of defects raise.
• Documented each stages of teh project and also attend status meetings every week.

Environment: Informatica Power Center 8.6/8.1/7.1.2, WLM, Oracle10g, SQL, PL/SQL, Teradata, Erwin 4.0, Windows2000, XML, Java, UNIX shell programming, TOAD

Confidential, Houston, TX

Informatica developer

Responsibilities:

• Worked closely with business users in Requirements Gathering, Analysis, Process Design, Data Design, Development, Testing and Implementation of load process and data transformation process.
• Designed teh technical specification documents by using MS Visio and maintained technical specification document throughout teh SDLC.
• Erwin is used for Forward and Reverse Engineering, followed corporate naming standards, using conformed dimensions whenever possible.
• Extracted data from different sources like Oracle, Flat files, DB2 transformed teh data and loaded in to RCL1 target data base.
• Implemented transformations like Router, Aggregator, Sequence generator, Lookup etc. To increase teh performance of teh mapping.
• Simplified teh data flow by using Router Transmission to check multiple conditions at teh same time.
• Implemented Mapplets for reusability of code.
• Tracked teh Slowly Changing Dimensions (SCD).
• Developed different work flows and work lets in Workflow Manager, monitor those in Workflow Monitor.
• Created various Stored Procedures, Functions, Triggers by using PL/SQL. Also involved in SQl Server Integration Service(SSIS)
• Involved in writing Shell Scripts to perform day to day business needs.
• Perform Unit Testing, Functional Testing and written various Test Cases to test teh application.
• Documented teh all phases of application development and attended teh status meetings.

Environment: Informatica Power Center 8.6/8.1/7.1.2, Oracle10g, SQL, PL/SQL, Teradata, Erwin 4.0, Windows2000, XML, Java, UNIX shell programming, TOAD.

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
• In-depth noledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirements, Analysis/Design, Development and Testing.
• Interact with data modeling, data support teams to get teh enterprise data for High level specs
• Maintaining teh repositories and creating teh folders and users and controlling teh users access using repository manager.
• Implemented Type2 Dimension logic in mappings using Informatica Designer.
• Extracted data from Siebel CRM tables and loaded into DB2 tables.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Extensively utilized teh Debugger utility to test teh mappings.
• Written SQL overrides in source qualifier according to teh business requirements.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode
• Created Low-level design document that includes teh detailed design of each components and data flow diagrams.

Environment: Informatica 8.1, Cognos, Oracle10g, SQL, PL/SQL, Teradata, Erwin 3.5, Windows2000, XML, C#, UNIX shell programming, TOAD, Business Objects XI.

Confidential

Informatica Developer

Responsibilities:

• Analyzed teh existing business model, and gathered current business requirements and documented teh requirement.
• Extensively worked with Power Center Designer tools- Source Analyzer, Warehouse Designer, Mapping and Mapplet Designer.
• Implemented various transformations like- Filter, Router, Aggregator etc, for smooth flow of data in to target data base.
• Created Sessions, Workflows in Workflow Manager.
• To reduce teh data flow complexity placed Filter Transformation next to teh Source Qualifier so to sort unwanted data at teh beginning stage its self.
• Organized teh data by using Sorter, Ranker transformations.
• Involved in Cognos Reporting. Used Framework Manager to convert RDBMS sources in to IQD’s, by using Report Studio and Query Studio reports were created.
• Documented teh mappings and process.

Environment: Informatica 5.1/DataStage 6.x, Cognos 8.x, Oracle 8i, PL/SQL, SQL, SQL Server 2000, Win2000