Data Warehousing Professional
OBJECTIVE
To obtain an IT position that utilizes my experience as an ETL Sr. Designer / Developer / Lead / Data Analyst having responsibility for all aspects of IT including Analysis, Modeling, Design, Development, Support and Testing

PROFESSIONAL SUMMARY

• 12+ years of strong Data Warehousing experience using InformaticaPowerCenter 9.x/8.x//7.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 7x/6x, Power Connect, Power Exchange
• An effective Leader with rich experience in the domain areas of Credit Card System, Fleet Cards, Insurance, Wholesale & Retail Banking and Wealth Management & Investment Banking
• Extensive experience in designing, data profiling, data migration from various legacy sources to OLAP/OLTP target applications
• Strong Designing and Data Modeling experience and designed ER diagrams, Dimensional/Hierarchical data models, Star and Snowflake schema data models using Erwin
• Major Job responsibilities are to design and develop Physical and logical Data models to data extraction from source to target
• Proficiency in data warehousing design techniques for data cleansing, slowly Changing Dimensions, Surrogate key assignment, indexes, change data capture
• Source to Target ETL table level mapping design and document reviews
• Adhoc querying and Performance Analysis and SQL query tuning
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL
• Designing of architectural design of tables for new applications interacting multiple interfaces
• Provided estimations and inputs to Build & Acquire phase responses based on scope of the project and work involved for each stage
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more
• Experience with shell scripting, understanding of approaches for business intelligence, data marts\\data warehouse
• Experience in Writing and testing Unit Test cases in Test Director/Quality Center
• Designing the specs and mockup of reports in COGNOS and SQR
• Experience in ETL Testing, Debugging and setting up jobs in Control-M
• Extensive knowledge and experience in Analysis, Development,Production Support and Test Management in Legacy applications
• Expertise in designing, development, requirements gathering, system analysis, technical documentation & flow charts, team management, test & data management, client relationship and product delivery
• Strong Technical expertise in the complete SDLC and the Production Support functions and environment by handling key responsibilities as the Module Lead, Team Lead, Tech/ Project Lead over the years
• Knowledge and experience in SOA, CMM, Six Sigma, agile and waterfall methodologies
• Experienced in coordinating, communicating with outside vendors and off-shore resources in support of time line and IT project deliverables

TECHNICAL SKILLS
ETL Technology : Informatica Power Center 9.1/8.6/8.1/7.x/6.x
Data Warehouse : Multidimensional Model Design, Star Schema Development
Data Modeling : Star-Schema Modeling, Snowflake Modeling, Erwin, Ralph-Kimball Methodology
OLTP : CICS
CRM : Siebel
File Systems : VSAM, QSAM, GSAM, MQ Series, ROMA
Operating System : MVS OS/390, UNIX, Windows, LINUX, UNIX, SOLARIS
Environment : TSO/ISPF/PDF
Databases : IMS-DB, DB2, SQLServer 2000/2005, Oracle 10g/9i/8i/7.x,
Tools : File-Aid, JobTrac, JHS, CAV, QMF, QA HIPERSTATION, EZY-EDIT, Panvalet,
Data Dictionary, COGNOS, SMORE, Control-M, Autosys, Ultra edit
Languages : COBOL 370, JCL, REXX, SQLS, SAS, C, PASCAL, FORTRAN 77, KSH, JSC, SQR
SQL, PL/SQL, HTML, UNIX Scripting, TOAD
Design : AutoCAD
Configuration : CHGMAN, ENDEVOR
Problem Management : INFOMAN, Peregrine, Heat
Testing & Debugging : XPED, INTERTEST, VIASOFT, BOBS, SQS
Project Management : IPMS, Project Plan, VISIO, MS Project, Rationale

Education

CERTIFICATIONS
DB2 Family Fundamentals Certification
Certification in Investment Banking from FTC
ITIL Foundation v.3

PROFESSIONAL EXPERIENCE
Confidential, Portland, ME Apr 2011 - Till Date
Analyst/Sr. Designer/Lead
Environment: Informatica Power Center 8.6, 9.1, SQL Server, DB2, Oracle, Toad, UNIX Shell Scripting, Flat Files, Mercury Quality Center, MS OFFICE, MS Project, Project Plan, VISIO, Outlook, Siebel, PeopleSoft, Heat, Ultra edit, Unix, SQR, Control-M
Project Description: Integrating fuel cards data from different source systems data for Customers and Merchants and reporting
Responsibilities:

• Interact with business users / Business Analysts to gather requirements and understand the timelines
• Review the high level Business Requirement Document (BRD) and prepare design documents & source to target mapping (STM) documents
• Participate in Data modeling discussions, exchange thoughts to come up with a best model to efficiently serve both ETL teams and reporting teams
• Enterprise design using SOA models
• Involved in preparing HLD, LLD, Mapping & Test case documents
• Maintenance and enhancement of MDM that was used across multiple interfaces reducing redundancy and enhancing quality of data
• Designed complex Informatica mappings, mapplets and re-usable transformations to facilitate initial and incremental data loads and parameterize to source from multiple systems
• Detailed data analysis and data requirements definition and documentation for ETL and reporting in SQR, Crystal reports and Perl
• Involved in merger activities with CoreCard
• Involved in SQR upgrade and Power center upgrade to from 8.6 to 9.1
• Mapping of new table layout with Core Card ( new interface to support business process) and data migration
• Spec and mock screen preparations for new reports besides enhancements
• Lead and guide the team and report to senior management

Confidential, Jersey City, NJ Aug 2008 - March 2011
Sr Designer/Lead
Environment: Informatica Power Center 8.6, SQL Server, DB2, Oracle, Toad, UNIX Shell Scripting, Flat Files, Mercury Quality Center, CVS, MS OFFICE, MS Project, Project Plan, VISIO, Outlook, SAS, COGNOS, Tivoli JSC, Scripts, Peregrine
Project Description: Profitability And Customer Service Evaluations is originally vendor developed integrated personal trust system. The application will Map, Load and cleanse batch file data feeds received from ODS and external business partners for business analysis with key functional areas of

• Trust account processing, Cash processing, Asset processing, Lot processing, Corporate Actions, Trade processing (SMAC), Tax and Lots processing with wash sales, Client reporting, Mutual funds processing

Responsibilities:

• Interact with business users / Business Analysts to gather requirements and understand the timelines
• Review the high level Business Requirement Document (BRD) and prepare design documents & source to target mapping (STM) documents
• Participate in Data modeling discussions, exchange thoughts to come up with a best model to efficiently serve both ETL teams and BI teams
• Involved in preparing HLD, LLD & Test case documents
• Involved in developing both data processing PL/SQL modules and analytical SQL queries for reports
• Reviewed Informatica code and test documents
• Designed complex Informatica mappings, mapplets and re-usable transformations to facilitate initial and incremental data loads
• Prepare reusable mappings by using mapping parameters and parameter files. Develop Unix shell scripts to build the parameter files before the Informatica session starts
• Create various types of tasks such as session, email, command and decision in Workflow Manager to control the ETL process flow
• Tune Informatica mappings and sessions by following several techniques like session partitioning, incremental aggregation, persistent lookup caches and pre-sorting for aggregation
• Involved in SIT and UAT tests
• Involved in creating production release documents and migrating code
• Prepare Control-M JILs (Job Interpretation Language) to create jobs in Control-M

Confidential, Frankfurt, Germany Oct 2006 - Jul 2008
Informatica Designer / Developer / Onsite Coordinator
Environment: Informatica Power Center 7.1.1, Actuate 7 suit, AI2, Tivoli monitoring tool, DB2, SQL, SFTP file server, Oracle 8.1.1, Sun Solaris 5.8, Windows 2000 Terminal client, MS OFFICE, MS Project, Project Plan, VISIO
Project Description: Confidential, is one of the world's leading international financial service providers, turnover around EURO 500 billion, across 74 countries. Providing Banking Services As a lean, dynamic, focused universal bank, Deutsche Bank ranks among the global leaders in Corporate Banking and Securities, Transaction Banking, Asset Management & Private Wealth Management, and has a significant Retail Banking franchise in Germany and other selected countries in Continental Europe.
DBFeeds project engaged with the Deutsche Bank to provide innovative business solutions. Informatica will be leveraged as the ETL tool to transform input data from different source system such as LS2 (Loan Organization system), Sparky (Loan Pipeline system), McCracken (Loan Servicing system) and loading into True Comp Data mart.
Responsibilities

• Analyzes the functional design document and prepare the Technical design document
• Designing mapping and workflow for collector interface
• Unit testing, Integration and System Testing and creating error report
• Creating the table in the local database for the staging area
• Designed and developed complex mapping using different transformation like Lookup, Router, Expression, Filter, SQL, Update strategy, etc.,
• Checking the validation object and validate all the mapping and session through shell script
• Optimizing Mapping and production support
• Writing shell script to schedule, run, resume workflow through PMCMD utility
• Onsite/offshore coordination

Confidential, New York, USA Dec 2002 - Sep 2006
Project: TMS/OneStop
ETL Developer/Team Lead
Environment: Informatica Power Center 7.1, SQL Server, DB2, Oracle, Toad, UNIX Shell Scripting, MVS OS/390, MS OFFICE, Informatica Power Center 7.1.1, MS Project, Project Plan, VISIO, DB2, CICS,VSAM, QSAM, GSAM, MQ Series, ROMA, COBOL 370, JCL, REXX, SAS, File-Aid, JobTrac, JHS, QMF, QA HIPERSTATION, EZY-EDIT, ENDEVOR, EZYTRIEVE, Test Director, JAVA, Web Sphere, CORBA, XML, Test Director
Project Description: OneStop is a "Single Sign on" application providing central connectivity to a large variety of diverse banking systems. TMS (The Middleware Solutions) is a middleware architecture that unites Web, client-server, and legacy resources to deliver real business values. The project end users include, back-office facilities, service lines and help desks, Teller, ATM, Online banking, VRU and branch office platform personnel
Responsibilities

• Design and development of subsystem components
• Interacting with ODS to send the load files for ETL processing
• Involved in acquiring the knowledge. Production support, Maintenance , Development , Analysis , Preparing various documents which are essential in Software Development Life Cycle
• Delivered the new ARGO system in Agile methodology
• Creating the table in the local database for the staging area
• Creating reports for client analysis on adhoc basis
• Coordinate with TMS applications and ARGO systems
• Involved in merger activities with BANKONE
• Lead for Production Support
• Actively involved in conversion of credit card interface from First Data Resources(FDR) to Total Systems(TSYS)

Confidential, UK Oct 2002 - Nov 2002
Project: AMP
Maintenance Process of Production Support Training
Environment: Visio, MS XCEL, MS Word, MS Power Point
Project Description: AMP is the largest and biggest Insurance provider in the UK. Worked on process of Maintenance activities
Responsibilities

• Undergone Project Related Training in Insurance Domain
• Production support

Confidential, Melbourne, Australia Apr 2001 - Sep 2002
Project: Package Processor/SPRAT/COBOLMVS Conversion
Senior Designer/Developer & Analyst
Environment: MVS OS/390, MS OFFICE, MS Project, VISIO, UNIX, IMS-DB, DB2, CICS, SAS, VSAM, QSAM, GSAM, COBOL 370, JCL, REXX, File-Aid, JobTrac, QMF, EZY-EDIT, Data Dictionary, DOCU/TEXT(Diversified Software Systems), ENDEVOR, VIASOFT, BOBS, Test Director
Project 1: Conversion of Common Use Modules and Programs from COBOL to COBOLMVS and COBOL2 to COBOLMVS and unit testing them.
Project 2: The Package Fee Processor System provides and manages an automated link between a Package and all accounts/services that form the Package, enabling the automatic charging of the Package fee by removing many of the manual processes.
Responsibilities

• Analysis, Design, Development, Technical support and System & Stress testing, Post implementation support and Bug Fixing
• Develop and unit test subsystems to handle Single sign-on using SAML
• Online Screen Flow Design interfacing with BOBS
• Technical specifications for Online and Batch Modules
• Complete batch flow design and System testing setup for batch process
• Writing the test cases in the Test Director
• Co-ordination activities - between the Business and the development team

Confidential, Miramar, FL Feb 2000 - Mar 2001
Project: CPS - SBS for American Express
Designer/Developer
Environment: MVS OS/390, MS OFFICE, MS Project, Project Plan, VISIO, UNIX, IMS-DB, DB2, CICS, VSAM, QSAM, GSAM, COBOL 370, JCL, REXX, CHGMAN
Project Description: The project is a development/enhancement project for the Credit Card system of the American Express TRS for the Latin American Region. This project aims at providing a parameterized platform for launch of new products along with the launch of 4 new products on the aforesaid platform
Responsibilities

• Requirements gathering for new credit product
• Unit and integration testing
• Conduct code review meetings with peers
• Project monitoring and status reporting
• Analysis, Design and Development, Technical support and User testing