EXECUTIVE SUMMARY:

• Over 20 years of experience with increasing levels of responsibility in Leading, architecting and implementing Data - Warehouse solutions.
• Proven record of leading development teams to deliver successful, complete IT initiatives. Demonstrated both strategic & tactical thinking capabilities.
• Hands-on experience using Informatica, Sybase and developing ETL methodologies for integrating applications across platforms and experience designing Operational Data Store type applications.
• Impressive, clear oral and written communication skills. Committed, goal-oriented team player.
• Passionate Hobbies include - Fitness, Yoga, Golf, Movies and Music

SPECIALTIES:

• Operating large Datawarehouses using cutting-edge ETL methodologies for Financial Services Industry.
• Office of Finance
• Risk Management
• PrimeBrokerage
• Private Banking
• Financial Services
• Insurance
• Data Warehousing
• ETL Methodologies
• Business Intelligence
• Data Modeling
• Change Data Capture
• Workload Management

KEY SOFTWARE & TECHNOLOGIES:

• Informatica 9.1/9.5
• Oracle, Sybase, MS SQL Server
• Unix Shell / Perl scripting
• Mercury QC/ JIRA Bug tracking
• Autosys / Control-M / TNG Enterprise Workload Manager
• Business Objects
• Sync-sort

PROFESSIONAL EXPERIENCE:

Confidential

IT Lead

Responsibilities:

• Credit Limits and Facilities are then determined based on the Internal Rating and Application process follows.
• Confidential transmits the Americas related data to the US-based DWH which is then used for extensive Reporting by Credit strategy and other business teams.
• The application was re-vamped completely and the data layouts expanded significantly as part of this program.
• I managed a team of 5 to deliver successfully the data transformation solution part of this project.
• Was engaged actively with the Tokyo Systems Division to co-ordinate activities from Planning stages, Business Requirements, all the way to Confidential .
• As the DWH IT Lead, led several other initiatives within the Risk, Regulatory and Finance Vertical to deliver timely solutions to business users.

Technology Framework:

• Informatica for ETL
• IBM DB2
• Business Objects

Confidential

Director, Data Analytics & Info Management.

Responsibilities:

• Finance Transformation (FT) is a strategic initiative within MMC to standardize/consolidate the data across the office of Finance.
• Data from various Oracle suite of applications - EBS, HFM, Planning and Peoplesoft need to be consolidated into new chart of accounts and published from a centralized data store.
• As part of a fifteen member team from Confidential, managed a team of four resources to deliver the data management/integration solution.
• As part of the leadership team, performed various roles from Requirement gathering, Design, hands-on development, Testing and Documentation.
• Designed a comprehensive solution to on-board Master Reference data using Oracle’s MDM into the Finance DW.
• The FDW solution included GL
• Transactional data along with Master data presented via Essbase for analytics and OBIEE for reporting.

Technology Framework:

• Informatica v9.5 for ETL
• Oracle 11G for Database

Confidential

ETL Lead

Responsibilities:

• Role has been to take the lead on designing load frameworks for CORE data, coming from various sources in the Investment Bank Division, that contribute to assessing risk. Functional responsibilities include
• Design, Documentation of specifications, Development, Integrated testing and Deployment procedures.
• Was primarily responsible for all Reference Data feeds that include
• Books, Instruments, Issuer info, Ratings and Enterprise Master Data like Employee info.
• Created a scalable, meta-data driven batch framework to load reference data feeds.
• Created an automated Release process to deploy Autosys, Unix scripts and ETL code to various environments.
• Liaised with Business Analysts to conduct extensive data-profiling that helped create true test-cases for QA teams.

Technology Framework:

• Informatica v9.1 for ETL
• Oracle 11G for Database
• Autosys Scheduler for Workflow management
• Extensive K-shell scripting
• Developed a flexible / widely scalable Batch frame-work to load daily feeds.
• Improved performance throughput on ETL components.

Confidential

ETL Lead/ BAU Support

Responsibilities:

• Re-joined the team that I was once part of, to assist in co-ordination of ETL development and releases in conjunction with developers in Singapore and India.
• Had re-used a large part of the framework that I had put in place earlier.
• Was primarily responsible for support of the data layer of the application, including bug-fixes, performance enhancements, strategic projects and release management.
• Helped design and create a batch metrics sub-system that was of immense value to the Global Support team to better understand volumes and peak loads in the batch cycle, to identify problem areas in ETL layer performance.
• Improved the release management process by integrating the ETL source code with SCM toolkit.

Technology Framework:

• Informatica v 6.1 & 7.14 for ETL.
• Sybase 12.5 ASE for Database.
• Control-M for Scheduling
• Extensive K-shell scripting

Confidential

Data Architect /Lead ETL & Database Engineer

Responsibilities:

• The fund is a $2.0B single-strategy Confidential that aspires to automate the Research process that originates a stock idea to taking a position eventually.
• Am responsible for supporting the database components of ongoing delivery/maintenance of Portfolio data for the Confidential, as well as help build the new Research Lifecycle platform.
• One of the primary functions includes building a Confidential Reconciliation tool for CFO to report differences between internal system and Morgan Stanley reports.
• Extensive work on stored procedures / triggers.

Technology Framework:

• Microsoft SQL Server
• SQL Server Integration Services

Confidential

Data Architect

Responsibilities:

• Am responsible for supporting the conversion of Legacy Claims data to a Global platform called Phoenix.
• Perform data analysis, produce Functional, Data-matrix, Design and Technical specifications for ETL developers and a comprehensive Test-plans for QA teams to test.
• Work with various teams to on-board Reference data to support the conversion.

Technology Framework:

• Informatica v 7.14 for ETL.
• Oracle for Database.

Lead ETL Architect

Confidential

Responsibilities:

• As an ETL architect helped implement a process architecture for using Informatica as a strategic ETL tool.
• Primary objective was to create a Account-Relationship Master within the Enterprise Account Master realm.
• These relationships will be largely used by various desks as an effective Firm-wide Entitlements Provisioning tool.
• Developed and Implemented reference data viz., Firm-wide BPM and Account structures.
• Various Account streams were integrated into the Acct Master for completeness.
• Helped put in place, best practices for ETL methodologies, such as, exception handling, streamlining log files and escalation procedures to better prepare for support.

Confidential

Responsibilities:

• Created a Scorecard application to bring in various segments of Trader performance like Revenue, Budget, Performance Review comments, Rankings etc into a single interface in order to simplify the Review process overall for Senior Mgmt.
• The application was designed, developed deployed within three weeks in an extremely intense, accelerated mode, just in time for annual review process.
• Created the Compensation-Hierarchy model, cleaned / scrubbed data from various Desk managers given in Excel and loaded data into the model and created Sybase API for access from the front-end.

Technology Framework:

• Autosys for scheduling / Perl, Ant and K-sh scripting.
• Informatica PowerCenter 7.1 for ETL.
• Business Objects for BI reporting.
• UDB 8.02 / Sybase 12.5 ASE.

Principal ETL Architect

Confidential

Responsibilities:

• Helped architect and implement a new ETL framework for the Data-Mart using Informatica for platform known as Confidential, a web-based Client Service application, which replaces an existing Java-based ETL framework. Under the new framework, the extensive business logic will be encapsulated in Informatica, thereby enabling the loaders to be portable, scalable for future initiatives such as Sybase to Oracle migration.
• The performance differences sometimes exceeded 90%, thereby tremendously improving Confidential SLAs to clients on their reports & extracts
• Process architecture, Business Rule translations
• Coding in Informatica and Korn-shell scripts
• Setup the Informatica infra-structure for Dev, UAT & Production
• Direct and Educate the team on ETL best practices
• Support the Production environment.

Technology Framework:

• Informatica PowerCenter 6.1 for ETL.
• Sybase 12.5 ASE
• Control-M for Scheduling
• Extensive K-shell scripting