SUMMARY

A dedicated and experienced SR Technical Professional with over 12+ years of experience in Data warehouse environment that coves full SDLC. Experience in Business Analysis, Application Design, Data Modeling, Development, Implementation and Testing Data warehouse and Database applications for Investment Banking/Insurance/Pharmaceutical/Financial/Petroleum/Government and Technology Industries

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Cloud/MDM/IDQ/B2B 9.6/9.1.4/8.6.1/8.1.1/7.1.4/7.1.3/6.2/5.1.1 , Informatica Metadata manager, web services, SOAP/JASON API.

Scripts/Languages: SQL, PL/SQL, C, Pro*C, Shell Scripting, AWK and Pearl.

RDBMS: Oracle 11g/10g/9i/8/7.3, MS SQL Server 2000/2005/2008 , Confidential DB2 7.1/8.2, Sybase, Teradata, BTEQ and MS - Access.

Database Query tools: Toad 7.6/7.2/8.6.1 , PL/SQL Developer, Advanced Query Tool (AQT) 7.1.7 and SQuirreL SQL Client.

Big Data: Hadoop/HDFS/MapReduce/Hive, Cloudera.

ERP: SAP R/3 4.6, BW 3.5.

Data Modelling: Dimensional Data modeling, Star Schema modeling, Fact & Dimension tables, Physical & logical data modeling, ERWIN 4.1/3.5, TOAD 7.6/8.6.1.

Wabtec: Java, Java Script, HTML, XML, JDBC, Servlets, Web sphere and IIS 4.

Schedulers: Autosys, Control M Workload Automation 8.

Reporting: Tableau, Business Objects XI, Cognos 7.1, Report Net 1.1.

OS: Windows NT/2000/XP/Windows 7, Solaris7/8/9/10, Unix4.0, AIX 5.2 and Linux.

Version Control: CVS, P4.

Agile Software development: Scrum and experience working with global teams.

Finance Business Skills: Good understanding of capital markets, Front and back office activities, Regulatory, FINRA, Disclosure, Compliance, AML/KYC, Trade life cycle, Settlement, Fails, corporate actions, Derivatives, Liquidity risk, general ledger and P&L.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr Informatica Developer Lead

Responsibilities:

• Worked as Informatica Power center developer, Technical lead and SME for the (NCDI) Nomura Centralized Data Infrastructure project.
• Implemented and supported Informatica data feeds for Regulatory, FAS157, Stock Record, Allocation, FINRA, Disclosures and AML/KYC.
• Improved operational efficiency by 10-20% by re-designing business processes with in Informatica and database.
• Involved in developing packages, functions, procedures, object types, Materialized views, Unix shell scripts as needed.
• Hands on experience on data warehouse Achieve process along with partitioning and tuning the database queries.
• Modified existing code as the business evolve for (Positions Trade, Settlements, Cusip netting, Trade Fails, CAX, Transfer pricing)
• Involved in Level 3 Support and actively involved in recruiting and training the team members.
• Configure and execute Informatica mappings in Hadoop cluster using Developer tool.
• Hands on experience with Informatica/Siperion MDM hub configurations - Data mappings for (Landing, Staging), data validation, Tokenization, Match/merge rules, customizing and configuring Data Director (IDD) and SIF API.

Environment: Informatica Power center 9.6/Cloud, MDM/IDQ/B2B, Autosys, Oracle 11g, SQL, PL/SQL, Solaris, Linux.

Confidential, New York Plaza, NY

Sr Informatica Developer

Responsibilities:

• Worked as senior Informatica Power Center 9.5 and data warehouse developer for liquidity risk infrastructure project.
• Followed Scrum Agile methodologies to develop, test and migrate the code to higher environments.
• Handled very large volumes of data, tuned SQL code and Informatica workflows to improve the performance.
• Created and updated shell scripts as per requirements.
• Used Control-M Workload Automation 8 for Planning, scheduling and monitoring jobs and scripts.
• Created and altered PL/SQL procedures in Oracle 11g environment.

Environment: Informatica Power Center 9.5, Oracle 11g, Control-M Workload Automation 8, SQL Server 2008, Sybase, SQuirreL SQL Client 3.5.3, Solaris 10, Toad, and Windows 7 Professional Systems.

Confidential, Brooklyn, NY

Lead Informatica Developer

Responsibilities:

• Worked as Lead/Architect Informatica Power Center developer for Transparency Application that allows public to view consistent view of data related to dealings of private sector organizations and individuals.
• Involved in Development of Informatica mappings, Workflows, stored Procedures and Modeling and Migration.
• Implemented reusable user defined functions where ever needed and followed best practices to optimize the performance.
• Implemented Informatica MDM and Data quality strategies along with parsing unstructured data using Informatica B2B.
• Implemented/modified shell scripts that cleanse and handle files.
• Updated existing Er diagrams to accommodate Business changes.
• Created and modified existing Oracle packages as per the business rules.
• Worked with complex data structures to parse and load into files and tables.

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQL Server 2008, Linux, Toad, Talend 4.0.2 and XP Professional Systems.

Confidential, Park Ave, NY City

Informatica Developer

Responsibilities:

• Worked as Informatica Power Center Developer for Wealth Risk Finance Data Warehouse to meet dynamic Regulatory Reporting Requirements.
• Good understanding of Source systems involved for reporting purposes.
• Responsible for Developing Reference data load process for various source systems.
• Implemented audit trail mechanism for recording data loads and record level history.
• Implemented data validation and exception handling for all ETL processes.
• Enriched the Source data with reference data to be used in reporting purposes.
• Used Informatica B2B Data Transformation for parsing excel files and unstructured data.
• Worked on Metadata manager for Business glossary and impact analysis and to generate lineage diagrams for users and IT teams.
• Implemented shell scripts for file validation and process logging.
• Worked with testing teams to resolve QC items while System integration testing and UAT.
• Used Perforce for maintaining Versions of source code.
• Good understanding of financial products such as derivatives, fixed income, securitization and CDO, AML/KYC.

Environment: Informatica Power Center 8.6.1,B2B, Webservices, JASON API, Informatica metadata manager, Oracle 11g, Teradata, Linux, Toad, Autosys and XP Professional Systems.

Confidential, Wall St, NY, NY

Informatica Architect/ Lead developer

Responsibilities:

• Implemented Global Business Services Data warehouse at DB Americas.
• Led the team of Informatica developers to accomplish the task in given timeframe.
• Designed and developed Informatica Mappings, Sessions, Worklets and Workflows to transform data from multiple sources like Financial systems, Cognos Enterprise Planning (Cognos EP), HR, Project, Excel files and various other financial data sources including informatica web services.
• Deep understanding of Operational cost of an Investment Banking.
• Built Reference Data, Facts and Dimensions based on Planning, Forecasting and Actuals financial data.
• Created Mappings to generate Cognos EP load files which followed strict formatting rules.
• Optimized Facts and Dimensions to be utilized in Cognos Power Play (OLAP)
• Cleaned Transformed and Merged Trade data which includes Trade counts, Settlement rate Confirmation rate and Failure rate. Calculated KPI for the above as columns in the fact.
• Followed best practices of DB Feeds (DB Enterprise ETL system)
• Involved in developing packages, functions, procedures, triggers, object types, Materialized views where ever needed.
• Designed, developed, and implemented UNIX shell scripts for Pre, Post Sessions and Command tasks for database updates, file handling, zipping and emailing.
• Embedded the metadata into all Sessions and Workflows for reporting and alerting purposes.
• Responsible for migrating the XML code including Scripts, SrcFiles and Parameter files to UAT and Production

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2005, Sun Solaris 9, Cognos Analysis Studio, Toad 8.6.1 and XP Professional Systems

Confidential, Parsippany, NJ

Sr Informatica Developer

Responsibilities:

• Involved in the development and enhancement of Informatica code related to Sales Force, Marketing, Hr, Finance, and Business Intelligence.
• Worked with IMS and NDC data.
• Developed/Modified mappings according to Best Practices and guidelines.
• Updated the Technical Design documents, test procedures based on the enhancement requirement.
• Coordinated with all team members in order to accomplish the task in a given time frame.

Environment: Informatica PowerCenter 8.6.1, SQL Server 2005, Oracle 9i, SAP R/3, SAP BW, and Windows XP professional Systems.

Confidential, Police Plaza, New York

Informatica Admin/Developer

Responsibilities:

• Involved setting Informatica Environment.
• Involved in Analyze, Architect, Design, Build, Test, Deploy and Management of the environment.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures. Developed end-to-end ETL process documents.
• Responsible for the Repository Admin activities like repository backup, database connections, FTP Connections, analyzing the repository tables and migrated metadata in development, UAT and production systems.
• Implemented Best Practices in all phases of the Project Life cycle.
• Developed and executed OLCS, Crime data warehouse, Shooting Homicide, Summons, COMPSTAT, Audit, Arrest, Complaints and warrants data warehouse

Environment: Informatica PowerCenter 7.1.4, DB2 8.2, AQT 7.1.7, AIX 5.2 and XP Professional Systems.

Confidential, Wood Lands, Houston, TX

Developer/ Analyst

Responsibilities:

• Responsible for development of various mappings for Extraction, Conversion, Integration for the SAP ERP and simplify business process across organization via single platform.
• Established modular development strategies to expedite development and simplify maintenance.
• Build common exception handling process to enable verification and validation capabilities and provide necessary audit functionality.
• Read data form SAP application layer using ABAP, BAPI, ALE-IDOC and BCI.
• Extracted, Converted data from Peoplesoft, Legacy systems and migrated to SAP ERP system.
• Created Technical Design Document (TDD) for IDD for each mapping.
• Participated in Technical, and Code review meetings as the mappings are developed and tested

Environment: Informatica PowerCenter 7.1.3, Power Connect for SAP R/3, Power Connect for People soft, Oracle 9i, Toad 7.6, Autosys, SAP R/3 4.6, Sun Solaris 8 and Windows XP professional systems.

Confidential, Basking Ridge, NJ.

Data Warehouse Developer.

Responsibilities:

• Created Mappings to extract data from SAP sources and load into Oracle ODS tables using Power Connect for SAP R/3.
• Involved in setting up the FTP and Source connections which are specific to SAP.
• Involved in trouble shooting the mapping and follow up with the SAP basis and the Informatica Tech Support if necessary.
• Responsible for Creating/raising the PPR (Production Problem Report) which is reviewed during the weekly meetings and move the ABAP code to production.
• Responsible for the production support as primary contact.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functional requirements into ETL procedures. Developed end-to-end ETL process documents. Tuned ETL processes and STAR schemas to optimize the load and query Performance.
• Developed and implemented Error Handling Strategies for ETL mechanism.
• Developed and implemented Migration Strategies for deployment of ETL code.
• Developed Mappings for Slowly Changing Dimensions.
• Developed Mappings for Summary Tables using SQL and Informaticas Aggregator Transformation.
• Documented program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 7.1.3, Power connect for SAP R/3, Oracle 9i, Toad 7.2, Cognos 7.1, SQL server 2000, Windows XP Professional, AIX, Autosys and SAP R/3 4.6 systems.

Confidential, Williamsville, NY

Data Warehouse Developer

Responsibilities:

• Extensively involved in importing the data from different operational sources involving AS/400 flat files, XML files and DB2 UDB Database tables into Oracle target.
• Providing Effective ETL solutions to the functional requirements.
• Created Workflow tasks and Worklets using Workflow Manager.
• Design, Develop, Unit test and System test mappings that have been worked for various projects.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications.
• Conduct walkthroughs to present design decision & implementation in a clear, understandable fashion.
• Migration on the newly developed code to Test and Production environments.

Environment: Informatica PowerCenter 6.2/7.1, Designer, Repository Manager, Repository Server, Workflow Manager, Workflow Monitor, Erwin 4.0, Shell Scripts, SQL, PL/SQL, Oracle 9i, Confidential DB2 7.1, Business Objects 5.1 AIX, Windows 2000 and AS/400.

Confidential, Houston, TX

Data Warehouse Developer

Responsibilities:

• Involved in Relational modeling with data analysis and normalization. Preparing application design documents based on business specifications. Constructing Logical and Physical data models, Forward & Reverse Engineering and Data Warehouse/Data Mart Dimensional Data modeling with Dimensions & Fact Tables using Star Schema.
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files (Fixed Width) and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Performed data cleansing, data manipulations using various Informatica Transformations. Worked on Informatica PowerCenter 6.2 tools - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager. Workflow Monitor, Repository Manager and Repository Server.
• Created complex mappings and maplets using various transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc. Involved in resolving performance bottlenecks for load process at various levels such as targets, sources, mappings, sessions, and Systems.
• Created indexes on Reporting tables and tuned the SQL Queries for better lead times of Reports. PL/SQL Stored procedures to access data from Oracle, MS SQL Server. Developed Unix shell scripts to automate the data load processes to target Data warehouse.
• 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.
• Developed Universes, Classes, and Objects for reporting purpose using Business Objects Designer. Created cardinalities, contexts joins, and aliases for resolving loop and checked the integrity of the Universe. Created, modified, maintained the complex business reports using Business Objects reporting tool

Environment: Oracle 8.0.4, Informatica Power Center 6.2, Business Objects 5.1, Erwin 4.1, SQL*Loader, Autosys, PL/SQL, MS SQL Server2000, Sun Solaris 2.7, Shell Scripts and Windows NT/2000.

Confidential, Atlanta, GA

Data Warehouse Developer

Responsibilities:

• Developed mappings and maplets using Informatica Designer to load data into ODS from various transactional source systems such as Mainframe Credit Card Processing System (EBCDIC Files), various modules of Oracle Financial System, Legacy FoxPro applications, etc.
• Used Informatica Designer to import the sources, targets, create various transformations, mappings for extracting, transforming and loading operational data into the EDW from ODS. Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on target table.
• Used the Informatica Server Manager to register and monitor the server, create and run the sessions/batches for loading the data using the earlier created mappings. Created maplets and reusable transformations.
• Created Stored procedures, Functions and Packages in Oracle, Used PL/SQL and SQL. Used SQL*loader to load data from MS-EXCEL sheets. Fine Tuned the SQL script.

Environment: Informatica PowerCenter 5.1.1,Repository Manager, Designer, Server Manager Oracle 8.0.4, PL/SQL, Erwin 4.0, SQL, Shell Script, SUN Solaris 2.7, Win 2000/NT.

Confidential

Programmer

Responsibilities:

• Worked for Individual safe keeping account Department in a team size of 12 people supporting and maintaining code.
• The various modules in ISA are Initial Entry, Account Opening, Dematerialization, Rematerialization, Trades, Pledge and Billing.
• Again Trades Module consists of Off Market Trades and Trades, which involve two tire checking using Maker and Checker utilities.
• The GUI is developed using Developer 2000 on Windows98 and Oracle Database on Unix.
• Responsible for Front-End design of various screens and writing Stored Procedures, functions, packages and Database Triggers using PL/SQL to maintain data Integrity and improve performance by reducing network traffic and delays.
• Also migrated code at all branches and facilitation Centers located in different cities.

Environment: NT Client, Oracle7.3/8.0.4, Solaris 7, PL/SQL, SQL, Developer 2000, Visual Basic 5/6 and Shell Scripts.