SUMMARY:

• ETL Professional with over 8 years of experience in analysis, design, development and implementation of applications on client server environment.
• Hands on experience in Data Warehousing and business Intelligence.
• Efficient in Interacting with Business Users, Managers for extracting to know their views in developing and modifying Analyzing and Preparing ETL Strategies.
• Extensive experience in Star - Schema, Snowflake Schema, Fact Table, Dimension Tables and Dimensional modeling using Erwin tool.
• Proficient in Sybase TSQL, query optimization and performance tuning.
• Expertise in design and development of SQL, PL/SQL, Stored Procedures and Triggers in Sybase.
• Experience working with stakeholders, getting authorization for resource allocation (charter), negotiating the use of subject matter experts towards creating project deliverables.
• Experience in Installing Informatica 8.x/9.x.
• Experience in Developing Training Programs for Informatica, Oracle, SQL Server.
• Extensive experience in documenting the ETL components.
• Experience in creating Technical Design Documents/Low Level Design Documents/Run Book.
• Experienced in working in Oracle, SQL Server, Sybase, DB2 Databases.
• Experience working with OBIEE, Data stage, QLikView.
• Efficient in writing and Unix Shell Scripting.
• Experience in creating Autosys, cronjobs for scheduling the jobs.
• Database Performance Tuning and extensive experience in SQL * Loader, Imports/Exports.
• Collaborative team player with excellent communication skills.
• Self-motivated and innovative with team leader qualities.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer/Architect

Responsibilities:

• Designing the Data Model based on the Basel II Functional Requirement.
• Implementing the Physical and Logical Data Model for Different Schemas using Erwin
• Designed and Implemented the Model for Effective Dated Tables i.e. Trade, Instrument, Instrument Indicative
• Designed/Enhanced the Entire ETL Architecture for Basel II.
• Gate authoring and versioning of Business Event Group (BEG) documents - Definition, Scope, Description, Requirement tracing to Functional & Technical Specifications.
• Responsible for ETL resources in Basel Project. Defining the Scope of Work based on the requirements and time lines.
• Responsible for On Shore and Off Shore resources and planning for Basel Projects
• Analyzing/Setting the timelines for the ETL and DB work.
• Analysis of the End user requirements and involved in Modeling the ETL Schema.
• Detailed Analysis of the Data provided by the respective source systems and filling in the gaps in the mapping specs.
• Identifying and short-listing stakeholders, identifying in-scope and out-of-scope requirements for Basel.
• Creating & updating Business Process flows using Microsoft Visio continually based on corrections, updates and remediation from each working session
• Training Full Time resources on Informatica.
• Implemented the Course Curriculum for Training Informatica
• Created Training Documents for Informatica.
• Working with users for Budgeting the resources and defining scope of requirements
• Implementing the standards of creating ETL Workflows/Mappings.
• Creating ETL Workflows/Mappings for Basel Project
• Analysis of SSIS Code for Informatica Conversion.
• Converted SQL Server SSIS Code to Informatica Mapping.
• Implemented standards for naming Conventions, Mapping Documents, Technical Documents, Migration form
• Created Defect Management flows for Factory (Pre-production) and Production issues.
• Designed roadmap review and approval process that would assess additional functionality requests and if approved would go through service requests, change requests, release and infrastructure management.

Environment: Oracle 9i/10g, Informatica 8.6.1, SSIS,SQL Server, Sybase, Solaris, Windows XP, HP Quality Center, Autosys 4.0

Confidential

ETL Architect/Lead

• Implementing the standards of creating Informatica Workflows.
• Implemented standards for naming Conventions, Mapping Documents, Technical Documents, Migration form
• Performed Code Review with the team members
• Extensive experience with End Users for understanding/analyzing the requirements.
• Detailed Analysis of the Data and Cleaning the Data
• Modeling the Schema. Analysis of the End user requirements for creating the Model
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used ETL to extract and load data from Oracle, and flat files to Oracle.
• Scheduling the jobs using Autosys

Environment: SQL Server, Oracle 9i/10g, Informatica (Power Center 7.1), UNIX Scripting (Ksh), Autosys

Confidential, New York, NY

ETL Developer / Sybase IQ

• Sybase servers from Sybase IQ based data warehouse and among multiple Sybase servers.
• Worked with End users to understand Security Lending Requirements
• Enhancing the SecLending Data Model to accommodate Multiple Source Systems and large volumes of data.
• Implemented Informatica CRC hashing algorithm for loading all Sec Tables.
• Created Complex Informatica/data base Code for Swaps project.
• Responsible for On Shore and Off Shore resources and planning for development effort of Sec Projects
• Performance improvement of existing credit process for making margin calls.
• Implemented Staging Area loads and monitored them actively for performance
• Implemented Informatica Mappings and Workflows for Loading Trade and Valuation Tables.
• Performed Code and Design Review with the team members.
• Upgraded Informatica 7.x to 8.6 on Solaris Environments.
• Implemented UNIX and Autosys Scripts for End to End loading.
• Created Technical, Low level Design Documents for Development teams and run book for support teams.

Environment: Oracle 9i/10g, Informatica 7.x/8.6.1, SQL Server, Sybase, Sybase IQ, Solaris, Windows XP, HP Quality Center, Autosys 4.0

Confidential, Santa Clara, CA

Transition and Implementation and Net Changes Project Leader

Responsibilities:

• Created and Supported the conversion extracts on Daily basis from the Compass (internal HR system) where all the US employees records, and feeds to Payroll System.
• Developed Reconciliation Scripts and extracts for the conversion and bug fixes to match up with the source.
• Interacted with users, business owners, DBA’s and working under high pressure for resolving production issues quickly and efficiently.
• Developed and support Oracle HRMS (GEMS) for history cleanup and reconciliation of 5 years of historical data, converted from Sybase-based legacy application.
• Reconciled incorrect converted data for active employees by creating Compass temp tables.
• Developed UNIX shell scripting for batch jobs running on a schedule to keep the HR application in sync with its backend Sybase database.
• Migrated compass and GEMS production data into “temp table” and compare data and identify discrepancies.
• Developed Reconciliation Scripts and extracts for the conversion and bug fixes to match up with the source.
• Collaborated with users, business owners and DBA’s to quickly and effectively resolve production issues.
• Utilized Sybase ASE 12.5, Korn Shell, Solaris, Oracle 8.1.7, Toad, Lotus Notes.

Environment: Sybase ASE 12.5, Korn Shell, Solaris, CronTab, C/C++

Confidential, New York, NY

Compliance Database System Analyst

Responsibilities:

• Developed Stored procedures for reporting.
• Designed and developed Korn shell scripts for automating the data load process into Sybase ASE and Sybase IQ.
• Created Perl scripts to convert the data feeds to mainframe compatible formats.
• Created Autosys JIL scripts to automate various jobs.
• Involved in troubleshooting of the application for bugs and production issues.
• Provided support & maintenance.

Environment: Sybase ASE 12.5, Sybase IQ 12.6, Korn Shell, Solaris, Perl 5, Autosys, C/C++, SCCS.

Confidential, Dallas, TX

System Team Lead Developer

Responsibilities:

• Developed of Stored Procedures and Triggers.
• Designed and developed many PERL modules for data handling including data validation, extraction and modification.
• Optimized T-SQL queries and stored procedures.
• Designed and developed of Korn shell scripts to perform data export, import, reconciliation and validation while transferring data from one system to another using BCP.
• Tested Unit and System of various database objects in Sybase.
• Worked with existing procedures and scripts for enhancement in their functionalities.
• Designed and developed of Korn shell scripts to automate data distribution to different Sybase servers from DB2 based data warehouse and among multiple Sybase servers.
• Involved in troubleshooting of the application for bugs and production issues and provided support & maintenance.
• SSO was implemented with the application using Container Based Single Sign-on.

Environment: Sybase ASE 11.9/12.x, Java, Perl, KSH, DB2 UDB 8, HP UX 10.2, AIX, Rapid SQL, WRQ Reflection, PVCS

Confidential

System Team Lead Developer

Responsibilities:

• Designed of DB2 tables for data storage.
• Designed and development of PERL scripts for validation and modification of the incoming feeds.
• Designed and development of different reports module.

Environment: DB2 UDB 8, Perl, KSH, AIX, PVCS

Confidential, Somerset, NJ

Sybase Developer

Responsibilities:

• Created Perl packages and modules for data handling and manipulation. Scheduled and maintained batches using CRON TAB.
• Used DBI/DBD for data base connection and SQL from PERL programs.
• Wrote new modules in PERL and Shell to support the reporting system.
• Designed and developed the Sybase tables for the new reporting system.
• Created many stored procedures and triggers on Sybase tables.
• Used indexes to optimize the queries on large tables with millions of rows.
• Worked in unit, system and integrated testing.
• Troubleshoot the application for the bugs and production issues.

Environment: Sybase ASE 11.x, Perl, KSH, DBI/DBD, CGI, Solaris

Confidential, New York, NY

Sybase Developer

Responsibilities:

• Responsible for identifying various database and platform specific changes while doing the port and debug the scripts to run in the new environment.
• Created CRON jobs as per requirement, maintaining and administrating the CRON entries.
• Coordinated with other teams involved in fail over testing to enable high availability for website.
• Created numerous SQL queries, TSQL Stored Procedures and Triggers for batch work.
• Created a filter utility to allow developers to identify and eliminate any hard coded URLs in various text files.
• Created CGI scripts for protecting certain scripts and html pages, accessible only for employees.
• Created CGI/ PERL scripts for administrating the activated direct clients.
• Wrote scripts to poll status calculation of different servers involved.
• Worked on bug fixing and supporting the production team.

Environment: Sybase ASE 11.x, Perl, KSH, DBI/DBD, CGI, Solaris, AIX, DB2 UDB

Confidential

Responsibilities:

• Involved in design and implementation of data flow.
• Developed stored procedures for searches and as backend interface for other applications to use.
• Developed many T-SQL programs, created and bug fixed SQL queries.
• Developed Perl APIs for other application to interface.
• Worked on enhancing the glossary mass update utility using C++, KSH, DB Library and Sybase.

Environment: Sybase ASE, Perl, KSH, C/C++, DB Library, DBI/DBD, Solaris

Confidential

Sybase Developer

Responsibilities:

• Wrote SQL batches for interaction and data management in Sybase tables.
• Participated in performance analysis and tuning.
• Created many C/C++ programs for the application.
• Worked with existing C code for enhancement.
• Wrote many CGI routines for reporting, data extraction.
• Generated test data and test scripts for testing.
• Took part in user meetings for requirement analysis.

Environment: Sybase, Perl, KSH, C/C++, DB Library