SUMMARY:

• Eight plus 8 yrs of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial, Telecom and Timeshare Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong experience with Ralph Kimball and Inmon data modelling methodologies.
• Strong experience working with ETL tools Informatica/SSIS.
• Strong Data Warehousing ETL experience of using Informatica 9.5/9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Experience working on Dataquality tools Informatica IDQ 9.1, Informatica MDM 9.1
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with various sources such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0,Teradata,flat files,XML,COBOL,Mainframe.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.
• Utilized AUTOTRACE and EXPLAIN PLAN for monitoring the SQL query performance.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Created pre-session, post session, pre-sql, post sql commands in Informatica.
• Worked with different Informatica transformations like Aggregator,Lookup,Joiner,Filter,Router,Update strategy,Transaction Control,Union,Normaliser,SQL in ETL development.
• Worked with Event wait and event raise tasks,mapplets,reusable transformations.
• Worked with Parameter file for ease of use in connections across Dev/QA/Prod environments.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys, Tidal,Control-M,Tivoli Maestro scripts.
• Experience working with Powerexchange.
• Worked extensively with slowly changing dimensions SCD Type1 and Type2.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.5/9.0/8.6/8.5/8.1.1/7.1.2/6.1, SSIS 2008 R2,Informatica IDQ

Data Modeling: Erwin, Toad

Reporting Tools: Business Objects XI 3.1/r2, r1/6.x/5.x, Desktop Intelligence, SSRS

Database: Teradata v 13/v12/v2r5.,SQL server 2008 R2, 2012,Oracle 11g

Database GUI: Teradata SQL assistant

Languages: SQL,T-SQL,PL/SQL, Unix Shell Script, Visual C#.

Operating Systems: Windows 2007/2005/2003/ XP/NT Server and Windows NT, UNIX.

Versioning: Team Foundation Server TFS, Visual Source Safe VSS

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

Senior Informatica Teradata Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Created tables, Shell Views for the Staging, Current Load and IDS Layers
• Created Views on top on the final EDW tables in order to generate reports
• Worked on dimensions to the build the structures and to process data
• Created a BTEQ script for pre-population of the work tables prior to the main load process
• Involved heavily in writing complex SQL Queries based on the given requirements.
• Used Fast Load for loading into the empty tables.
• Created reports using BTEQ scripts reporting functionalities and FastExport for the end user.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Responsible for loading data into warehouse from different sources using Multiload and Fastload to load millions of records.
• Developed MLOAD scripts to load Ready Files to Teradata Warehouse.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Worked in a roster manner for Level-2 support to solve the SDE tickets and job failures as per the protocol.
• Created and Imported/Exported various sources, targets, and Transformations using Informatica Powercenter 9.6.
• Implemented the concept of Slowly Changing Dimensions(SCD) Type1 and Type2.
• Used Active Batch to schedule the jobs from TeraData and informatica using Windows Task Scheduler.

Environment: Teradata V13/V14, Teradata SQL Assistant, Informatica Powercenter 9.6, SQL Server.

Confidential, Albany, NY

Senior Informatica Developer/Senior Business Objects Developer

Responsibilities:

• Involved in Business Users Meetings, JAD sessions to understand client requirements.
• Transform the Business requirements into Technical requirements.
• Have prepared Project Plans, Estimates based on the Work effort and the Complexities.
• Develop Optimum Design and Conduct Design Review meetings with Architects for the Technical requirements and obtain their Design approval
• Transform the Design into Flow Charts, Workflows and Explain that to the Developers.
• Worked on Heterogeneous Source and Target Systems for Movement of Data
• Worked with FTP Teams and Vendor to establish the connectivity and the Transmission Protocols.
• Peer reviewed each Design and given suggestion for an Optimum design and Code based on Performance and Coding standards.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica
• Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored
• Procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source
• Qualifiers and data flow management into multiple targets using Routers were extensively done.
• Worked on profiling the Data, Analyzing the Join conditions, Development of Mappings and write the Informatica code & UNIX scripts.
• Worked on code merge between two different development teams.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Wrote codes in Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process. Also wrote codes in FTP scripts and Post Process Scripts for Data Validation.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Coded BTEQ Teradata scripts to extract Data and Send it to the Vendor.
• Created and scheduled Sessions for different Job setups like on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Extensively worked with Scheduling Teams to setup the Job flows and Processes.
• Performed Unit, Integration, System testing of Informatica mappings and Workflows.
• Created Test plans and Test cases and discussed with the Stakeholders for the things in scope and documented them in the rational tools.
• Tested the Informatica and UNIX components based on the Test plan and prepared Test evaluation summary reports for Stakeholders sign-off.
• Communicate activities/progress to project managers, business development, and clients.
• Performed User acceptance testing for different modules and Supported Vendor for the Data.
• Developed Error and Validation reports as per the User requirements
• Created Universes and generated reports in Business Objects using Star Schema.
• Maintained Quality Procedure for the code and continuously monitor and audit to ensure code meets quality goals.
• Have created User Manuals and Development guide for best practices and presented it across the Team and Clients.

Environment: Informatica Power Center 9.5 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, Teradata V 13.0, Fast load, Multiload, TPT Teradata SQL Assistant, PL/SQL, UNIX.

Confidential, Dover, NH

Informatica Developer

• Collaborated with Business analysts for requirements gathering, business analysis and designing of Enterprise Data warehouse.
• Involved in ETL design and development for extracting data from the heterogeneous source systems Like DB2, UDB, MS SQL Server, Oracle, flat files, XML files and loading into Staging and Teradata Data Ware House
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Developed the logic for handling slowly changing dimension (Type1 and Type 2) table’s load by Flagging the record using update strategy for populating the desired. Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Design and Development of ETL routines within the Informatica Mappings, usage of Lookups, Aggregator, XML, Ranking, Mapplets, connected and unconnected lookup’s, stored Procedures / functions
• Configured workflows with Email Task, which would send mail with session, log for Failure of a Sessions and for Target Failed Rows.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Build tables, views, UPI, NUPI, USI and NUSI.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling.
• Provided Production Support.

Environment: Informatica Power Center, Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, Teradata, Fast load, Multiload, Teradata SQL Assistant, PL/SQL, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos 8.

Confidential

Application Repackager

Responsibilities:

• Evaluating the requests, Sound knowledge about the technical review of the vendor applications
• Repackaging of the legacy application to a windows installer application (MSI), Merge Modules (.MSM) and Patches (.MSP) using Install Shield Admin Studio 8.0
• MSI resolution using tools like FileMon and RegMon
• Created MSI's in a locked down environment and set permissions on files and registry keys for user access.
• Created App-V(Softgrid) enabled virtualized application packages using Microsoft\'s Softgrid Sequencer 4.1/4.5 and created MNT/VFS installation by sequencing the application using the 3 phases of the sequencer namely the Package Configuration phase, the Installation(Monitoring) phase and the Launch Application Phase.
• Published the package which contains the virtual application source files such as the .ICO, .OSD, .SFT and .SPRJ files to the content share on the Softgrid Virtual Application Server (SGVAS) to enable streaming, testing and local caching of virtualized application bubbles/packages on desktops and laptops which have the Softgrid client installed locally.
• Used Picture Taker for Imaging
• Provided support for distribution of packaged applications

Environment: Install shield Adminstudio 10.0, Application Virtualization Client (App-V) 4.6, Windows 7, SCCM 2007, Hyper-V, Orca, Filemon, Regmon, Group Policy, SMS, ODBC, SQL, Microsoft Office, Microsoft Outlook.