SUMMARY:

• Over 10 years of professional experience in Information Technology with a strong background in Data Analysis.
• 5 years of Oracle ERP functional BA experience including Inventory, Manufacturing, Order Management, Supply Chain Planning, Procurement and Financials.
• 8 years of experience in Data Warehousing/Data Migration using Informatica PowerCenter 5.x/6.x/7.x/8.x/9.x.
• 6 Years of experience in Data Migration using ETL tools.
• 7 years of strong database development and design skills.
• 2 Years of experience in Big Data.
• Involved in end to end Oracle ERP implementations.
• Good Database development, programming and maintenance skills.
• Extensive experience in Documentation of Data Assessment, Data Mapping, Code Review, Test plan and operations.
• Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Experience in production support and product maintenance.
• Oracle development experience designing, modeling, PL/SQL, loading data, testing and tuning queries.
• Offshore and Onshore team management.
• Expertise with T - SQL usage and syntax to build high-quality Stored Procedures, Triggers, Views, Cursors and Indexes.
• Understanding of SQL best-practices to ensure data integrity and fastest data acquisition.
• Experience in UNIX Confidential scripting, job scheduling on UNIX environment.
• Excellent Project Management skills.
• Experienced in setup and working with the offshore team.
• Ability to create ad hoc reports from variety of sources.
• Experience with version control tools like CVS/PVCS.
• Knowledge of Software Testing and Quality Assurance.
• Possess extensive experience in architecture design and modeling using UML/Rational Rose and OOA/OOD methodologies.
• Working knowledge of financial products like Bonds, Repos and Options.
• Strong educational background - MS in Information Systems.
• Good understanding and working knowledge on Power Exchange (Change data capture)

TECHNICAL SKILLS:

ERP: Oracle Inventory, Manufacturing, Order Management, Supply Chain PlanningProcurement and Financials, BI Informatica, Cognos, Business Objects

Languages: Java, C, C++, Perl, XML, SQL, PHP, ASP, JavaScript, PL /SQL.

Version Control: PVCS, CVS

Operating Systems: UNIX, LINUX, SOLARIS, Windows

DBMS: Oracle 11g, 10g, 9i, 8i, 6x, MS Access

Testing: Quality Center, Clear Quest

WORK EXPERIENCE:

Confidential, Houston, TX

Business Analyst/ Technical Lead

Responsibilities:

• Worked as an Oracle Business Analyst to facilitate functional setups and data validations for Oracle modules Inventory, Manufacturing, Order Management, Supply Chain Planning, Procurement and Financials.
• Analysis of source systems for validation of business rules, data Integrity and data cleansing requirements particularly with respect to vendor and Material master data.
• Integrated state-of-the-art Big Data technologies into the overall architecture.
• High Level ETL process design - Design of Interface between Oracle Apps and the legacy applications.
• Designed an overall Oracle EBS implementation solution including analyzing data, preparation of high level, detailed design documents, test plans and deployment strategy.
• Understand the existing subject areas, source systems, target system, operational data, jobs, deployment processes and Production Support activities.
• Design special X-ref for a mapping between the legacy and Oracle ERP application in order to have cross system references during parallel run and maximize code reusability.
• Discover the source data that causes the problems downstream.
• Proactively resolved open defects for Manufacturing and Inventory modules.
• Supported daily nightly productions jobs on rotation basis.
• Design and developed ETL process to load and extract data for legacy applications.
• Design and built Oracle databases and stored procedures to in corporate into ETL process.
• Build UNIX Confidential scripts to manage dynamic file names, file counts for validation and FTP.
• Build/Test Cognos reports.
• Manage and mentor team of 4.

Environment: Oracle EBS 12.2, Oracle 11g, Teradata, LINUX, Informatica 9.1.0, Windows 7, Cognos 10

Confidential, Houston, TX

ETL Technical Lead

Responsibilities:

• Design standard ETL mapping templates to facilitate one standard build process for easy code maintenance and support.
• Design detail ETL ERROR handling process.
• Planning and documentation of unit test cases for informatica mappings built.
• Worked with architecture team to help Ctrl-M team understand Informatica working.
• Interact with ENDUR (Trading and Risk management tool) to debug trade data issues.
• Assign tasks and manage the ETL team
• Help with migration: Exporting objects, Validating Objects, Cleaning folders and Sequence of date movement (SVN check in and checkout).
• Used my prior trading knowledge to enhance team understanding of Endure and its working.
• Explain /enhance team knowledge on Error handling and help build error logic into the Informatica mappings.
• Coordinate and assign tasks to offshore team, and optimize the use of resources.
• Knowledge transfer, documentation and educate users with the ETL process.
• Set up and work coordination with offshore team.
• Coordinate ETL code migration from DEV to SIT to UAT.
• Monitor daily runs, support and fix code bugs in ETL code.

Environment: Informatica 8.2, Oracle 10g, Teradata, LINUX, Windows Vista, Business Objects XI R2.

Confidential, Houston, TX

Senior ETL Developer/ Informatica Administrator

Responsibilities:

• Plan, design and built datamart for Murex EMMI application.
• Strategic planning to build staging tables to access data from MUREX.
• Analyzed the functional specs provided by the plan team and created technical specs documents for all the mappings.
• Designed and developed Informatica Mappings to generate downstream reports for Front and Middle office.
• Analyzed and designed common business to create Mapplet and used them in different Mappings.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Lookup and Router transformations for populating target table in efficient manner.
• Maintain Development, Integration and UAT Informatica Repositories and manage migration for one instance to other, also used Repository Manager to maintain the metadata, Security and User Management.
• Wrote PL/SQL programs for reconciling volatility data for securities.
• Detailed analysis of Informatica mappings to identify bottlenecks and tune mappings for effective and efficient data loads.
• Performance Tuning for Informatica mappings, identifying the barrier between filtering the data at Source Qualifier level versus filtering in Informatica.
• Fine tuning of SQL queries for improved performance, adding indexes and/or hints to improve performance.
• Developed Confidential scripts to manage (FTP and cleaning) files generated by Informatica.
• Supported and enhanced applications in production for Securities (Bonds, Options and Repos).
• Supported PnL, Volatility, Liquidity and Risk reports for trades.

Environment: Informatica 8.2, Oracle 9i, 10g, Sun Solaris, Windows Vista.

Confidential, Houston, TX

BI Analyst and Support Specialist

Responsibilities:

• Owning and maintaining company's data mart for Invoice and ticketing.
• Support Data warehouse application and other Informatica based applications.
• Defined, developed, and managed a series of data marts.
• Handle Informatica administrator tasks of monitoring Informatica performance on UNIX server; manage folders, repositories, users and user level permissions.
• Designing Mapplets for applications.
• Handling Informatica developer tasks of creating mappings, which involved using all the transformations like Lookup, Filter, Router, Update, Expression etc.
• Scheduling jobs at Informatica level and UNIX level (crontab).
• Performed programming and unit testing against detailed technical design documents.
• Responsible for developing several complex mappings for data processing and re-defined existing process to accommodate new business process.
• Developed several applications using SQL Server 2000.
• Developed several oracle stored procedures and SQL server 2000 DTS.
• Helped in migration from SQL Server 2000 to SQL Server 2005.
• Developed several Confidential scripts including scripts to start Informatica workflow, check for file availability, server availability and email notification processes.
• Generated several CRM and fleet management reports.
• Support and maintain COGNOS reports.
• Writing project proposals of any possible applications that help in improving business process.
• Working with clients, understand business process and develop applications based on business requirements.

Environment: Informatica 7.2, IBM AIX, SQL server 2000/2005, DTS, Oracle, Oracle Applications, COGNOS 8, Windows XP.

Confidential, NYC, NY

ETL Lead Developer

Responsibilities:

• Manage a team of two.
• Responsible for the entire project, including planning, design, development and testing.
• Involved in development of mappings and transforming source data into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Normalizer, Update strategy & stored procedure transformation.
• Responsible for identifying reusable logic to build several Mapplets, utilizing shared folders to in corporate them as shortcuts, which would be used in several mappings.
• Responsible for developing several complex mappings for processing the feeds, re-defined existing process to accommodate batch schedule-using Worklets and developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Scheduled several jobs using autosys tool, creation of autosys jils, changing job definition & handling scheduling issues.
• Worked on Informatica Power Center 7.1.3 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Developed source to target business specification documents.
• Troubleshooting data interrogation issues in development, test, and production environments .
• Involved in extensive Performance Tuning by determining bottlenecks in sources, targets, mappings and sessions.
• Documented the mappings used in ETL processes.
• Designing and implementing test plans for ETL sessions and maps
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Extensively used maplets and reusable transformations .
• Indulged extensively in testing the mappings
• Responsible for developing several complex mappings for processing the feeds, re-defined existing process to accommodate batch schedule-using Worklets and developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Teamed together with client resources to design the to-be processes, applying standards and facilitating the industry best practices.
• Involved in developing migration strategies, maintenance of Informatica Versions, developed change requests procedure & Instance strategy design for moving code to different instances.
• Scheduled several jobs using autosys tool, creation of autosys jils, changing job definition & handling scheduling issues

Environment: Informatica PowerCenter 7.1.3, SQL Server 8.0, Sybase, IBM AIX 5L, Windows NT.

Confidential, Hopewell, NJ

Middleware Designer/ Developer/ Support Specialist

Responsibilities:

• Implemented a middleware (ETL) design used in migration of legacy source specific data to a standard common predefined format.
• Designed an optimum process by balancing Informatica mappings v/s Oracle SQL.
• Coordinated with customer in finding the sources and targets for data conversion.
• Responsible for the Design, Analysis & implementation of the Interface Gateway for a global gateway process to handle multiple feeds from several different regions of Confidential Europe, Asia-Pac rim, Australia & North America
• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
• Worked extensively with mappings using expressions, aggregators, filters, lookup and stored procedures transformations.
• Prepared user requirement documentation for mapping and additional functionality.
• Created Repository, Users and Groups. Analyze and import the Source definitions. Created target definitions, logical and physical designing of target tables.
• Responsible for application production support with 24/7 on the call support.
• Scheduling Informatica jobs using Autosys(Scheduling tool).
• Execution of Test plan, Implementation Plans & identified areas for process improvement of workflows, mappings in Informatica.
• Responsible for the support of Informatica, Autosys and Oracle Applications.
• Support financial application for US, EMEA and ASIAPAC.
• Incident Management of Production Support issues related to Financial applications.
• Debug and resolve production support issues also providing time estimates for corrective action, in order to meet the customer service level agreement.
• Work with the development team when necessary to facilitate resolution of problems and other IT Teams to resolve infrastructure related (Network, Database) issues.
• Manage the Support documentation verifying and keeping documentation up to date and available to the IT Support Organization.
• Responsible for the promotion of code/configuration changes to the production environment after Quality Control and User Acceptance sign-off.
• Responsible for integration and user acceptance testing.

Environment: Informatica PowerCenter 6.2, Oracle 9i, Autosys, SQL, PL/SQL, Unix Confidential Scripting, WindowsXP