SUMMARY

• Six years (6) of Total IT Experience in Analysis, Design, Development, Implementation, Testing and maintenance of Business Application Systems
• Five Plus (5+) years of Data warehousing and ETL experience using Informatica PowerCenter 8.6.x/8.1.x/7.1.x/6.2/6.1, Informatica PowerMart 6.2/5.1, PowerConnect, PowerAnalyzer, Superglue, Metadata Manager, Warehouse Designer, Source Analyzer, mapping Designer, Transformation Developer, Mapplet Designer, OLAP, OLTP, Appworx, DataQuality Workbench, Informatica Data Explorer
• Mapping development using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup, Aggregator
• Four Plus (4+) years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Logical & Physical data modeling, ERStudio 7.1/6.1
• Two Plus (2+) Years of Metadata Integration using Metadata Manager aka Superglue with various Xconnects such as ER Studio Xconnect, PowerCenter Xconnect, Business Objects Xconnect, Oracle and SQL Server Xconnects, Custom Xconnect
• One Plus (1+) Years of experience in Informatica Data Profiling and Data Quality Workbench.
• Experience in handling XML technologies (DTD, XSD) and worked with XML sources and targets
• Four Plus (4+) Years of Business Intelligence experience using Business Objects XI/6.5/5.0, Designer, Supervisor, BO, WEBI, Infoview,BCA, ZABO

BUSINESS AREAS

Asset Management
Insurance & Investments

Certifications

Informatica Certified Developer (Version 8.x)
Six-Sigma Green Belt

TECHNICAL SUMMARY

Data Warehousing

Informatica PowerCenter 8.6.1/8.1.1/7.1.x/6.2/6.1 (Repository Manager, Source Analyzer, Designer, Server manager, Work Flow Monitor, Warehouse Designer, Mapplet Designer, Mapping Designer, Work Flow Manager), Superglue 2.1, Metadata Manager 8.x, OLAP, OLTP, Appworx 6.1.4, Control M, SQL * Plus, SQL * Loader, Informatica Data Explorer, Informatica DataQuality Work Bench, Informatica Data Profiler

BI & Reporting

Business Objects XI R3/6.5/6.0/5.1, Infoview,Business Objects SDK, Web Intelligence 2.5/2.6, BCA, ZABO, Designer, Developer, Supervisor

Data Modeling

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERStudio 7.1/6.1

Databases

Oracle 10g/9i/8i, MS SQL Server 2005/2000/7.0, IBM DB2 8.x,9.x,Sybase 12.5,15.x, PL/SQL, SQL*Loader,

Programming

SQL, PL/SQL, Embedded SQL, Unix Shell Scripting, VB, C language

Job Scheduling

Appworx 6.1.4/6.1.3

Environment

UNIX (Redhat Linux 5.x/4.x/3.x, Solaris), Windows 2003/2000/XP/98,

Other Tools

TOAD, RapidSQL, SQL Plus, CYGWIN (X-Windows Server), Winscp, Putty, Solarwinds, WS-FTP, CuteFTP,

PROFESSIONAL SUMMARY

Client: Confidential, Richmond,VA
Employer : TCS Feb 08- Current
SR. DW Architect

Confidential, Operations and Analytics System encompass the operational data store, Data Marts and Reporting Marts that are being built for Genworth Financial - Investments business. Goal of OASys is to provide clean and consistent data to the investment community by

Gathering and integrating data from multiple sources.
Cleansing and validating the data.
Provide business intelligence through reporting marts.

Data OASys is also the enterprise data store for the investment community, which sources data to all the downstream applications used by Genworth investments

Responsibilities:

• Requirements gathering and Business Analysis in support of Data Warehousing efforts.
• Development of Business Requirements Design documents
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user's privileges.
• Designed and customized data models for data warehouse supporting data from multiple sources.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Used Informatica Designer to import, edit the metadata of sources and targets. Used Repository Manager for creating folders and managing the user privileges.
• Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings. Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects by creating shortcuts.
• Creating equal partitions to ensure the smooth flow of data concurrently for better performance.
• Created Schema objects like Indexes, Views, and Sequences.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Mapping creation using various delimiter files, XML files
• Co-ordination with Upstream and Downstream systems
• Project review meetings, Status Reporting, Issue tracking.
• Design and implement error Handling Strategy
• Performance Monitoring and Tuning
• Business Induction to new team Members
• Interacting with Informatica Technical Support on various SR's
• Co-ordination with Appworx team in scheduling all ETL jobs
• Creation of metadata reports for daily status of ETL jobs
• Data Reconciliation
• Used the Slowly Changing Dimensions - Type II in various mappings.
• Used debugger to test the data flow and fix the mappings.
• Validated all the applications and run the workflow using Workflow Manager.
• Created events and tasks in the workflows using work flow manager.
• Performed tunings of mappings, sessions for optimum performance.
• Performed Unit Testing and Integrated testing for the mappings created.
• Assisting Reporting team in designing Monthly and Daily Universes
• Experience in backup and restoring of Repository.
• Data Profiler setup, Installation and Configuration
• Developed BO Universes using Designer and Business Objects for the reporting solution for Operational reporting System.
• Designing audit universe for attestation reporting.
• Modeling marts design for effective and quick reporting in BO.
• Building CAN and adhoc reports for meeting business requiremnts.
• Created Calculations, Drill down, Slice and Dice reports in Business Objects.
• Created an Operations Job Document (OJD) which is used by Production Support team

Environment: Informatica PowerCenter 7.1.4 & 8.6.1, BO XI R3, Infoview, Pl / Sql, Oracle 10g, ER Studio 7.1, Appworx 6.1.4, TOAD, Data Profiler, winscp, Visio.

Client: Confidential, Stamford, CT
Employer: TCS Mar 07-Jan 08
SR. DW INFORMATICA Architect

BRS Aladdin Implementation: BRS Aladdin is a third party vendor tool used as an trading platform for all the Genworth investments needs. Aladdin combines sophisticated risk analytics with portfolio management, trading and operations tools to support true straight-through processing. This project aimed at replacing the legacy trading platform like TIPS and LZ with a new platform which is BRS Aladdin.

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Studying the entire application management process, procedures, identifying areas for improvements and implementing the same
• Develop logical and physical data models that capture current state/future state data elements and data flows
• Improved time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the enterprise architecture.
• Analyzing the source data and working with business users and developers to develop the Model.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Using Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and to load the data incrementally.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier, and data flow management into multiple targets using Router transformations.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Developed reusable transformations, mapplets to implement the business calculations.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union to develop robust mappings using the Informatica Designer.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used PowerCenter Workflow manager for session management, database connection management and scheduling of jobs to be run.
• Monitor, troubleshoot workflows and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Improved Performance by tuning SQL Queries, tuning mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 7.1.4 & 8.6.1, Oracle 10g, ER Studio 7.1, Appworx 6.1.4, TOAD, Data Profiler, winscp, Visio.

Client: Confidential, Stamford, CT
Employer: TCS Aug 06- Feb 07
SR. DW INFORMATICA Architect/Administrator

Informatica announced the end of support for 7.1.x. So, Genworth Investments decided to upgrade the current power center version 7.x to 8.x to utilize the new functionalities that were introduced with PowerCenter 8.5.1. Genworth plans to implement the High Availability for Production Servers. It also plans to roll out DataQuality WorkBench which enables business users to perform data investigation easily.

Responsibilities:

• Complete responsibility of upgradation process, design and implementation
• New Architecture Planning
• Compatibility Analysis
• Risk Analysis, Design and Project Planning
• Impact Analysis
• Proof of Concept implementation
• Co-ordination and communication with various project teams
• Planning freeze periods, outage periods with minimal impact to projects for upgrade
• Binary Installation, Configuration, Repository Cloning
• Creation of Domain, Node, Repository Service, Integration Service
• Repository Upgradation, Testing
• Issues Resolution
• New Features training to developers of various projects
• Security implementation, Repository User migration, Groups migration
• Performance Monitoring
• Troubleshooting
• Debugging core dump issues using pmstack utility
• Interact with Informatica technical support on all Service requests
• Oracle 10g client installation on Redhat Linux 5.x
• PowerCenter 8.5.1 Client Installation deployment on Citrix Servers
• Setting up DataQuality WorkBench, Data Explorer
• Complete Documentation, Managing Issue tracker.
• Co-ordination with all stake holders

Environment: PowerCenter 8.5.1, 7.1.4, Oracle 10g, SQL Server 2005, ODBC 520, Red hat Linux 3.x, 5.x, Cygwin, MS-Project, MS-VSS, Visio, Shell Scripting, Appworx 6.1.4, TOAD, Citrix, CA Unicenter, Solarwinds, EFT Server, Informatica Data Explorer, Informatica DataQuality workbench, HP Proliant DL 580.

DW INFORMATICA DEVELOPER

Green Package: Green Package is a Blackrock Solutions' comprehensive suite of portfolio risk management and compliance reporting. Green package takes positions, securities and other financial data which are not traded in Aladdin, from Genworth and their custodians to generate reports which are internally being used by business users, mostly portfolio managers.

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations, Union, Custom in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

Environment: ER Studio 7.1, Informatica PowerCenter 7.1.4, Oracle 10g, SQL Server 2000, TOAD, Business Objects 6.5, Redhat Linux 3.x, Winscp

Client: Confidential, Stamford, CT
Employer: TCS Apr 05-Dec 05
DW INFORMATICA DEVELOPER

Genworth Financial took over Insurance part of GE Asset Management. This project is about transition of corresponding applications from GEAM to Genworth. Genworth setup the new hardware and bought software. All Applications were transitioned from GE to Genworth.

Responsibilities:

• Risk Analysis
• Compatibility Analysis
• Memory, Processor and db sizing requirements
• Disk volume estimates
• Power Center Server setup, Configuration and Administration of dev, stage and Prod environments.
• Performance Monitoring and improvements.
• Repositories migration from GE to Genworth.
• Testing of all informatica components.
• Design of Change Control Process
• Server monitoring using Solarwinds
• Server Healthchecks
• Helpdesk Process design.

Environment:Informatica Power Center 6.1,714 (Designer, Repository Manager, Server Manager), Business Objects (Supervisor, Designer, BO Reporter, WEBI), Oracle 9i, SQL Server 2000, MS Access.

Client: Confidential, Nasik, India
(Internship) June 04-Mar 05
Application Developer

Load Monitoring System: Load Monitoring System was an application developed for Asian Electronics, Nasik which was primarily used for street light auto function. The application would take care of automatic on-off of street lights based on particular schedule set or by sensing the climatic conditions, thus saving 30% of energy.

Responsibilities:

• System Analysis
• Requirements gathering and project design
• Co-ordination with all stake holders
• Preparation of high and low level design specs.
• Development and testing C++ and VB code
• System and integration testing
• Performance Monitoring and improvements.
• Troubleshooting and debugging.

Environment:C++, Visual Basic6, Oracle 9i, TOAD,MS-Project, Visio