SUMMARY

• 15+ years of strong Data Warehousing experience using Informatica PowerCenter 9.x/8.x//7.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Mart, Power Connect, Power Exchange
• An effective Leader with rich experience in the domain areas of Specialty Insurance(disability), Credit Card System, Fleet Cards, Insurance, Wholesale & Retail Banking and Wealth Management & Investment Banking
• Expert in Master Data Management for Production and Test environments
• Experience in Linux DB2 environments
• 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
• 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
• 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
• 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.5/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: MQ Series, ROMA, VSAM, QSAM, GSAM

Operating System: MVS OS/390, UNIX, Windows, LINUX, UNIX, SOLARIS

Environment: TSO/ISPF/PDF

Databases: DB2, SQLServer 2000/2008, Oracle 10g/9i/8i/7.x, Teradata, IMS-DB, Greenplum,GemFire

Tools: Control-M, Autosys, Ultra edit, OBIEE, Data Studio, DVO,File-Aid, JobTrac, JHS, CAV, QMF, QA HIPERSTATION, EZY-EDIT, Panvalet,Data Dictionary, COGNOS, SMORE, Active Batch, Squirrel SQL Client

Languages: SQR, SQL, PL/SQL, HTML, UNIX Scripting, TOAD, COBOL 370, JCL, REXX,SQLS, SAS, C, PASCAL, FORTRAN 77, KSH, JSC

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

PROFESSIONAL EXPERIENCE

Confidential, Scranton, PA

ETL/Data Analyst/Lead

Environment: Informatica Power Center 9.5, SQL Server, GemFire, Greenplum, Post GRE, UNIX Shell Scripting, Flat Files, Mercury Quality Center, MS OFFICE, MS Project, Project Plan, VISIO, Outlook, Unix, Active Batch, ER Studio, PL/SQL

Responsibilities:

• Lead, manage and guide team members and distribute assignments and monitor progress and report to senior management
• Review the high level Business Requirement Document (BRD) and prepare design documents & source to target mapping (STM) documents
• Data modeling for billing to efficiently serve both ETL teams and reporting teams
• Lead and guide the team and report to senior management
• Production support lead and Active Batch setup
• ETL deployment and administration
• ALM defect maintenance and bug fixing
• Metadata management of ETL

Confidential, Portland, ME

ETL/Data Analyst/Lead

Environment: Informatica Power Center 9.5, Power Exchange, SQL Server, DB2, Teradata, Teradata SQL Assistant, UNIX Shell Scripting, Flat Files, Mercury Quality Center, MS OFFICE, MS Project, Project Plan, VISIO, Outlook, Unix, Control-M, COGNOS, CA - Erwin, Data Studio, MVS OS/390, JHS, QMF, DVO, Putty

Responsibilities:

• Near real-time information - current decisions based on current data
• Improved quality, timeliness and consistency - uniform user interface across all functionality of the solution
• Insight via dashboards - an intuitive point-and-click interface that is easy to use
• Ease of future product integration and maintenance - contemporary, flexible and scalable architecture
• Test and Data management using Data Studio
• Linux for DB2 managements
• Lead, manage and guide team members and distribute assignments and monitor progress and report to senior management
• 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
• Designed complex Informatica mappings, mapplets and re-usable transformations to facilitate Initial, Incremental and CDC data loads and parameterize to source from multiple systems
• Lead and guide the team and report to senior management
• Production support lead and control-M setup
• ETL migration and administration

Confidential, Portland, ME

ETL Developer/Data 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

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
• 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

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

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
• Experience in Oracle Business Intelligence Enterprise Edition (OBIEE)
• Involved in developing both data processing PL/SQL modules and analytical SQL queries for reports
• Review, Tune Informatica mappings and sessions by following several techniques like session partitioning, incremental aggregation, persistent lookup caches and pre-sorting for aggregation
• Involved in creating production release documents and migrating code
• Prepare Control-M JILs (Job Interpretation Language) to create jobs in Control-M
• 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
• 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

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

Responsibilities

• 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 reports for client analysis on adhoc basis
• Coordinate with TMS applications and ARGO systems
• Involved in merger activities with BANKONE
• Actively involved in conversion of credit card interface from First Data Resources(FDR) to Total Systems(TSYS)
• Undergone Project Related Training in Insurance Domain
• Production support

Confidential

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

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

Confidential, Miramar, FL

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

Responsibilities

• Requirements gathering for new credit product
• Unit and integration testing
• Conduct code review meetings with peers