SUMMARY

• Over 10+ years of IT experience as specialist in performing Analysis, Design, Development, Testing, Deployment, and Maintenance for various software applications
• Extensive experienced on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments.
• Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange,Informatica Data Quality, Informatica Data Explorer, Cognos, etc.
• Worked with various source systems such as Relational Sources, Flat Files, XML Files, Mainframe COBOL and VSAM files and Web Services etc.
• Experience in Informatica Data Quality (IDQ).
• Profiled the data from disparate source systems using Informatica Data Explorer (IDE)
• Extensive experience in Unix & Perl Scripting
• Extensive experience in tuning the Complex ETL Mappings
• Extensive experience as Informatica Integration Architect - Created Complex Integration Solution Framework
• Extensive experience in Performance SQL Tuning
• Strong Oracle database development skills - SQL and PL/SQL.
• Extensive Experience in OLTP Modelling (2NF, 3NF)
• Extensive Knowledge in OLAP Dimensional Modeling like Star & Snowflake.
• Extensive experience in Slowly changing dimensional modelling
• Extensive knowledge in Data Acquisition & Financial Instruments Data
• Extensively Involved in Designing the Credit Processing & Distribution Data Model (XSD).
• Designed Complex Informatica development using XML source/parser, Web-Service, Message Queue source (native MQ and JMS), Real time processes.
• Understand Bloomberg data well. Also, experience in Reuters, VDF market data.
• Understand Rating Data from Moody's, S&P, Fitch, DBRS
• Provided Informatica Training and setting up lab for Informatica training
• Proficient in analyzing and translating business requirements to technical requirements
• Experience to Drive the design, develop,testing and rollout of complex enterprise applications to completion
• Having experience as Lead Position and handling projects in onsite, offsite or onsite-offshore models.
• Extensively worked on SWIFTs format & strong experience in trading Reconciliation Project Tracking progress for assigned tasks, status reporting and personal ownership and accountability in delivering the deliverables within the established schedule
• Informatica Certified Developer - PowerCenter 8.6
• Extensive Knowledge in Informatica MDM Hub
• Extensive Knowledge in Informatica B2B Exchange & Transformation
• Certification in IBM DB2 UDB V8.1 Family Fundamentals- Exam 700 IBM
• Certification in Finance Module
• Extensively working & worked with Agile and Waterfall model
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player
• Self learning Data Science and analytics. Participating in data science competition.

TECHNICAL SKILLS

ETL & Reporting Tools: Informatica Power Center 9.1/8.x/7.x Informatica Data Quality 9.1 Informatica MDM 9.1 Power Exchange 9.1 Cognos 8

DataBase: Oracle 10g/9i/11g DB2 Sybase OLTP Modelling (2NF, 3NF) OLAP Dimensional modelling (Star and Snowflake)

Scripting skills & Languages: Shell and Perl scripting SQL & PL/SQL Python JAVA COBOL C

Operating System: Sun Solaris Unix LINUX Windows 7/Professional/2000/NT/98/95 MainFrame Z/OS

Other Tools: AUTOSYS SVN ECLIPSE ERWIN TOAD SQL Loader SQL PLUS XML APPWATCH JMS API IBM MQ Queue EMS Queue WSDL FILEAID VSAM

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. ETL Informatica Architect/Developer

Responsibilities:

• Played a vital role in Master Reference Data Management Solution Framework.
• Informatica Architect and Developer.
• Worked on Developing ETL with different sources and targets like XML, Real Time Message Queue, Flat File, RDBMS (Oracle and Sybase) and Web Service Consumer.
• Worked on Advanced transformations like Transaction Control, Normaliser and Java Transformations, Data Transformations.
• Designed Credit Data Processing & Distribution Model (XSD or Business Object )
• Designed the strategic Managed Asset Portfolio based Data distribution ETL framework for all the Internal reference data applications
• Worked on complex business rules using Informatica Data Quality(IDQ) tool to cleanse data
• Worked on Informatica Data Explorer(IDE) for Data Coverage Analysis
• Worked on Creating PowerCenter Repository, Integration Unicode Services
• Worked on Creating Model Repository & Data Integration Services for IDQ
• Worked on Web Service HUB (Provider) services
• Worked on creating Complex Reusable transformations & Mapplets
• Worked with UNIX shell scripts extensively for job execution and automation
• Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing) with user community
• Worked on 2 Major Initiative projects - Fixed Income, Bond Coverage.
• Designed and Developed common Name value & Pair data processing framework for Bloomberg Per Security using FTP method and Bloomberg Web Service Call
• Implemented change data capture (CDC) using Informatica power exchange to load data from transaction DataBase to Data Mart DB
• Worked on Upgradation of Informatica 8.1 to 8.6 and then from 8.6 to 9.1.
• Interacted with business community and gathered requirements based on changing needs
• Designed technical documents with layout considering standardization, reusability, and scope to improve if needed.
• Documented the purpose of Data Warehouse (including transformations, mapplets, mappings, sessions, and batches) so as to facilitate the personnel to understand the process and in corporate the changes as when necessary.
• Design and Development of new feeds to source data from new vendors and to deliver it to new clients.
• Design reusable components to assure quality of data and performance of ETL.
• Maintenance and enhancement of many existing ETL feeds for Equity, Mortgage and Derivatives.
• Development and Maintenance of UNIX shell scripts and Perl scripts (heavy file processing scripts).
• Design and Development of Autosys Schedules
• Design Reconciliation Reports for DQ
• Prepared Technical specification documents and Unit -Test cases
• Worked on Informatica Linux/Server upgrade from shared to dedicated.
• Automated the ETL Deployment using Deployment Group & PMREP commands
• Operationally Resolved the productions Issues with Support member
• Release coordinator & Release Management.
• Scrum/Agile SDLC project
• Assign and Review tasks for Offshore.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams
• Extensively worked on Informatica to extract data from Flat files, VSAM File and Oracle Server database to load the data into the target database (Sybase Server)
• Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings
• Used Informatica transformations such as the Source Qualifier, Expression, Filter, Aggregators, and Connected & Unconnected lookups, Sequence Generator and Stored Proc. Etc
• Extensively worked on performance tuning of the created mappings, to identify bottlenecks at Target, Source, Mapping, Session and System levels and its Optimization
• Designed and developed the sessions for the relevant mapping(s) or Informatica jobs and organized as sequential / concurrent batches.
• Worked closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Worked with business analysts to identify the appropriate data elements for required capabilities
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• As part of a data conversion project improved the ETL process by Analyzed usage and cached vs. non-cached lookups and made changes as needed.
• Cleaned up mappings to not create lengthy log files by turning off verbose logging and getting rid of warning messages.
• Broke up complicated slow mapping into multiple mapping that ran much faster and could be run in parallel.
• Replaced lookups in mappings with join conditions.
• Creating High Level Design and Detailed Design in the Design phase.
• Designed and developed common modules for error checking (e.g. to check if the reject records output file is empty and to check if there are duplicate natural keys in a given table.)
• Performed the tuning at source, Target and informatica mappings
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager

Environment: Powercenter 7.1.3,8.1, Unix, Putty,DB Artesian, Sybase, COBOL, JCL

Confidential

Responsibilities:

• Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Modifying existing COBOL Program
• Creating JCL Jobs using existing COBOL Programs.
• Migrated VSAM data into DB2 tables
• Resolving Production Issues
• Answering Client Queries

Confidential

Support Member

Responsibilities:

• Monitoring the Jobs & System performance
• Running Batch Cycles & Support.
• Managed users & roles for database security, Maintained system security, control and monitor user access to database
• Incident Management & Tracking and Resolving Application issues.
• Resolving Clients queries.