Profile:

• Over 12+ years of experience in IT as follows:
• Over 5+ years of experience in ETL tool using info Informatica 8.x/7.x (PowerCenter Designer, Repository Manager, workflow Manager, workflow Monitor).
• 4+ years of experience working as a software developer / analyst developing several client - server business applications.
• Strong experience in ETL using Ralph Kimball methodologies.
• Extensive database programming experience using Oracle 10G/9i/ MS SQL Server 2000/7.0/6.5 , T- SQL, PL/SQL, Stored Procedures, views, Packages, Database Triggers
• Excellent skills in understanding business needs and converting them into technical solutions.
• Excellent problem solving skills with a strong technical background.
• Result oriented team player with excellent communication and interpersonal skills.

Technical Skills:

ETL Tools: Informatica PowerCenter 8.x/7.x, SQL Server DTS

RDBMS: Oracle 10G/9i, MS-SQL Server 2K/7.0/6.5 and DB2

DB Tools and Technologies: Toad 8.x, SQuirrel, DB Artisan, SQL, PL/SQL, ADO and ODBC

Programming Languages: VB 6.0, ASP 2.0, UNIX Shell Scripting, PERL 5.6, and Java Script

Reporting Tools: Crystal Reports

Source Control Tools: VSS

Data Modeling Tools: Erwin 4.1, MS-Visio

Professional Experience:

Confidential, Toronto

Informatica ETL Analyst Support and Development (Enterprise Data Warehouse)

Roles & responsibilities:

• To provide 24x7 production support for the banks EDW environment.
• To co-ordinate with the developers and the end users regarding and issue related to the production environment.
• Promoted, Implemented and Tested Informatica objects from Development to UAT to Production environments.
• Maintained and developed various mappings / mapplets to load the data from various sources and loading into target, using different transformations like SQ, Expression, Sorter, Lookup (Connected/Unconnected), Aggregator, Update Strategy, Joiner, Filterand Router Transformations.
• Extensively used the debugger to debug the mapping and to find out the data discrepancy coming from the source or arising from the business rules being incorrectly applied.
• Used session log files and the technical specification docs to find out the reason of the workflow failure or incorrect data reported by the end users.
• Implemented efficient and effective performance tuning measures by using sql overrides in SQ, used sorted i/p in aggregator, used unconnected lookup there by minimizing the usage of numbers of lookups, used static / persistent lookup cache etc.
• Used the parameter files and defined mapping parameters and connection information in the file.
• Identified the bottlenecks at source level and used the sql override to improve the query performance.
• Used session logs to debug sessions.
• Frequently required to do root cause analysis of production failures.
• Developed several unix shell scripts to resolve production failures.

Environment: Informatica 8.6.1, DB2, AIX, Tivoli Work Scheduler, SAS, Cognos, BO

Confidential, Markham

ETL Development and Support

The purpose of the Financials-EDW was to perform complex financial calculations on the data sourced from Mainframes, Flat-Files and RDBMS tables and to provide reports to various financial applications users / controllers. The ETL team was responsible to develop the ETL solutions and resolve any eventual issues that can hinder the smooth operations in production environment.

Roles & responsibilities:

• Supported mappings in Informatica PowerCenter Designer 7.1 to load the data from various sources such as DB, Flat Files and Sybase database and loading into target, using different transformations like SQ, Expression, Joiner, Sorter, Lookup (Connected/Unconnected), Aggregator, Update Strategy, Filter and Router Transformations.
• Developed Type 1 and Type 2 SCD's.
• Identified the bottlenecks at source level and used the sql override to improve the query performance.
• Created Sessions in Workflow Manager and scheduled the workflows to run at a specified frequency.
• Used session logs to debug sessions.
• Developed UNIX shell scripts to execute pmcmd utility to start the workflows.
• Used Autosys to automate and execute the shell script having pmcmd command.
• Responded to the user tickets in an efficient and timely manner.
• Identified root cause of the workflow failure and resolved the issue.

Environment: Informatica 7.1, Oracle 10g, Sun Solaris, Erwin 4.1, DB Artizan, Autosys, Business Objects

Confidential, Toronto

Data Analyst

Providing data analysis / reporting services to internal IT clients. Clients also would request customized report to analyze various business parameters for decision making.

Roles & responsibilities:

• To respond to customers tickets in a timely and efficient manner.
• Provided efficient data analysis services to the clients by properly understanding the business process.
• Provided customized reporting to the clients, which enabled them to formulate successful improvement measures in terms of client satisfaction and revenue.
• Provided effective reporting solutions which enabled the managers of the call - center teams to improve their team performance and thus overall client satisfaction survey.

Environment: VB, VBA, ASP, Oracle9i, Crystal Reports 8.5

Confidential, Brampton

Roles & responsibilities:

• Worked in computer department as a Customer Support Representative.
• Supported customers by providing technical and functional support for desktops, laptops and computer peripherals by being courteous and showing eagerness to help the customers and suggesting them the right product suiting their life-styles keeping the everyday sales goals in mind.
• My achievement at Best Buy is that I was hired as a seasonal employee but due to my performance I was hired as a full time employee.

Confidential, India

ETL Developer

Pharma-DW project to provide a comprehensive reporting about the various parameters such as Sales National/ Regional, distributor's performance, vendor information, purchase cost analysis, inventory and product information

Roles & responsibilities:

• Coordinated with the end users and gathered the requirements.
• Helped the BA to develop source to target matrix.
• Created mappings using Source qualifier, expression, lookup, aggregator, filter, joiner transformations.
• Used various optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Designed mappings and scheduled workflows to Load data into dimension and Fact tables.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed Informatica parameter files to filter the daily data from the source system.
• Used debugger to debug the mappings.
• Created Stored Procedure to implement complex business logic for good performance.
• Scheduling the workflow based on the nightly load.
• Supported MS-SQL server databases running mission critical 24*7 systems.

Environment: Informatica 7.1, Oracle 9i, Windows 2000 Advanced Server, Crystal Reports 8.5

Confidential

Sr. Analyst Programmer / Team Lead

1)Project:Supply Chain Mgmt. System.

Client: Confidential

Description: This is a Supply chain mgmt. project based on franchisee model. It consists of following modules: System Admin b) Purchase Order c) Order Receive d) Inventory and Stock Management e) Sales g) Data Transfer

Roles & responsibilities:

• Involved in development of the system and worked on Purchase, Receive, Sales and Data Transfer modules.
• Extensively used crystal reports in visual basic code to provide customized reports as requested by the client.
• Developed more than 30 simple and complex MIS reports as requested by the client.
• Effectively lowered down the inventory cost due to the correct reporting involving complex queries.
• Extensively used Active-x Data Objects for back-end connectivity and used command object to refer the stored procedure in visual basic code to enhance the system performance and also used all MS-SQL SERVER objects such as Triggers, views, Stored Procedures, functions to make a robust system. Also used DTS to transfer the data to and from MS-SQL SERVER to various data formats such as text files, excel sheets, ms-access for various purposes.

Environment: WinNT, VB, MS SQL-SERVER, Crystal Reports

2) Project: Customer Loyalty Program

Description: This is the module integrated with the above s/w providing all the features of a CLP. CLP is the module used to track the customer loyalty by the way of points allotted against the purchase made and the customer can redeem the same as per the policy.

Role: Sr. Analyst Programmer / Testing / Implementation.

Roles & responsibilities:

• Developing the application as per the system requirement specifications, ensuring the integrity of the data being stored in the database enforcing the business logic and rules using triggers, stored procedure, views, and functions.
• Provided Periodic demonstration of the modules to the clients to gain client confidence.
• My achievement here is that the project was executed by a team of two people one being a DBA and myself. I developed the front-end and he took care of the back-end.

Environment: WinNT, VB, MS SQL-SERVER, Crystal Reports

Confidential, India

Web Developer

Project: Astrology/Numerology/Palmistry based web portal.

Roles & responsibilities:

• Developed web based astrology portal where in I worked on Horoscope module. It also includes the predictions based on the horoscope depending upon the planetary positions at the time of birth of an individual.
• My achievement is that I simplified the development process by using third party Active-X components viz. Dimac File-Upload for uploading the photographs for match making module and J-mail components for the mail.

Environment: WinNT, ASP, MS SQL-SERVER, VB, VB-Script

Confidential, India

IT Consultant

Project: SISTRAC (Shop floor Information for Tracking, Recording and Control)

Role: System Analysis and Design, Developing, Testing and Implementing

Roles & responsibilities:

Established the communication sequence in which the Allen-Bradley\'s PLC Automation circuit takes the data from the plant and sends it to Visual Basic through an Active-x component (RS-VIEW 32). This data is stored into the MS SQL-SERVER database for MIS reporting.

Environment: WinNT 4.0, VB 5.0, MS SQL-SERVER 7.0 and Crystal Reports 4.6

Confidential, India

Worked as a Trainee Programmer Analyst and developed several customized desktop application using Visual Basic 5.0 and MS-ACCESS