SUMMARY:

• Around 8 years of IT experience in analysis, design, development and implementation of Data warehouses, Decision Support Systems (DSS) and Reporting Tools.
• Around 3 years of experience in Regulatory Reporting using Axiom Control View (Axiom CV).
• Strong experience in Axiom Control View development and enhancements.
• Complete experience of implementation of Form PF (Private Fund), CTA PR and CPO PQR through Axiom
• Control View.
• Experience in creating Project Hierarchy, Projects and Branches with Project Dependencies in Axiom CV.
• Worked on Axiom Components like Data load, Data models, Aggregation, Portfolios, Tabular Reports, Free from reports etc.
• Experience in Streamline and automate reporting process through workflows.
• Experience in migration of Axiom Components from one environment to another.
• Experience in creating Custom Reports as Business requirements.
• Experience in Analysis Edit Checks, Variance and Drilldown Reports, fixing failed Edit Checks.
• Performing Unit testing, Supporting SIT and UAT Cycles, Xml Submission testing with Mirror site (FINRA).
• Experience in creating ownership and assisting in Sign - off to End user for submissions through axiom.
• Working Experience in Production Support application Team.
• Knowledge on CCAR (Comprehensive Capital Analysis and Review) model From 9c, Form 14A/Q
• Over 4 years of experience in Data warehouse and BI reporting using Informatica Power center, Store procedures and OBIEE.
• Strong knowledge of data warehouse methodologies like ODS, Star and Snowflake Schemas and SDLC process.
• Hands on experience in different databases SQL Server, Oracle and Teradata.
• Experience with writing daily batch jobs using UNIX shell scripts, and developing complex UNIX Shell Scripts for automation.
• Expert in Unit Testing, Integration testing and Performance Testing.
• Worked with different SDLC Environments Agile, Iterative, Water Fall Methodologies.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

TECHNICAL SKILLS:

ETL Tools: Axiom Control View 9.3.1, 9.7.2, Informatica Power Center 8.6, 9.1

Business Intelligence: Axiom Control View(CV), OBIEE 10G Programming Languages SQL, PL/SQL, VBA, UNIX Scripting. Operating Systems Windows, Sun Solaris, UNIX, LINUX Software Packages MS-Office, PowerPoint, Word, Excel, Outlook

WORK EXPERIENCE:

Axiom Developer

Confidential - New York, NY

Responsibilities:

• Worked on Axiom Control View (CV) development and enhancements.
• Involved in Business model, DATA Mapping and environment Setup for Form PF through Axiom.
• Implemented and Developed Form PF for several Business through Axiom CV.
• Developed and enhance existing code change with new logic ass requirements in CV.
• Worked Complete Cycle of implementation of Form PF (Private Fund), CTA PR and CPO PQR through
• Axiom Control View.
• Created Macros for templates generation to capture static data of Funds.
• Worked with Axiom SL for updated Forms by SEC, NFA (National Futures Assoc).
• Supported and Resolved Production Support issues.
• Created Project Hierarchy, Projects and Branches with Project Dependencies in Axiom CV.
• Worked on several Axiom Components like Data load, Data models, Aggregation, Portfolios etc and automation through creating Workflows.
• Developed Unix Scripts to ftp of files from others business environment to local Axiom Environment Server.
• Worked in migration of Axiom Components between DEV, UAT and Production environments.
• Experience in creating Custom Reports as Business requirements.
• Worked with Business users to resolve Edit Checks, Variance and Drilldown Reports, fixing failed Edit
• Checks.
• Performing Unit testing, Supporting SIT and UAT Cycles, Xml Submission testing with Mirror site (FINRA).
• Established ownership and Sign - off for each funds.
• Assisted End Users in submission of XML to SEC through Axiom CV.
• Working Experience in Production Support application Team.
• Knowledge on CCAR (Comprehensive Capital Analysis and Review) model From 9c, Form 14A/Q

Environment: Axiom CV 9.3.1, 9.7.2, Informatica Power Center 9.1.0, MS SQL server R12, Oracle 11g, SQL Developer, Toad Data Analyzer, Unix, Control-M.

Informatica Developer

Confidential, NY

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server, DB2, Teradata & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event
• Wait, E - mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges using Informatica Repository Manager.
• Was responsible for the version control and up-gradation.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers and Stored Procedures in the server side.
• Involved in creation of Classes, Objects and Universes for reporting purpose using Business Objects
• Designer.
• Wrote UNIX Shell Scripts and pmcmd command line utility for automating Batches and Sessions using ESP Workload manager.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 9.0.1/Informatica Power Center 8.6.1, Erwin 7.1, MS SQL server 2005/2008, Oracle 10g/9i, DB2, SAP R/3 databases, XML, SQL, PL/SQL, Shell Scripts, Windows XP, Unix, Espresso (ESP) Workload Manager, Business Objects.

Informatica Developer

Confidential

Responsibilities:

• Involved in development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Used Data validation Test, SQL views using Informatica DVO Utility for Business analysts to perform UAT n source database upgrade for Well Dimensional Team data, source database.
• Designed and developed Meta Data structure to capture the source and target tables count and created test data from legacy existing system through SP for testing purpose.
• Developed store procedures for loading Dimensional Tables to improve performance.
• Created column level mapping from existing legacy system application to new developed system.
• Developed Test plans for testing purpose to cover each and every scenario with Business logic for UT.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server, & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event
• Wait, E - mail notifications, Decision and to Schedule jobs.
• Used Toad Data point for testing source and staging tables.
• Developed Store procedures to load Dimensional tables with in same DB.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Environment: Informatica Power Center 9.1.0, MS SQL server 2000/2008, Oracle 11g, SQL Developer, Pyton

Informatica and Data Warehouse Developer

Confidential - Chicago, IL

Responsibilities:

• Managed the entire "ETL process" involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, Teradata, and Sybase into the Oracle target database.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Involved in quality assurance of data, automation of processes.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Identified and tracked the slowly changing dimensions Type 1 and Type 2 (for change data capture), heterogeneous Sources and determined the hierarchies in dimensions.
• Used Task developer in the Workflow manager to define sessions.
• Created application - specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Performed Repository Administration tasks like Creating repositories, users, assigning groups and their privileges, creating backups and recovery using Informatica Repository Manager.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Connection management and scheduling of jobs to be run in the batch process
• Generated detailed reports from the data marts using Business Objects.

Environment: Informatica Power Center 8.1.1, Business Objects, Oracle 9i, DB2, SQL/PLSQL, dynamic SQL, UNIX Shell Programming, Erwin 4.0, UNIX (IBM - AIX), and Windows NT.