SUMMARY

• Over 10 years of IT experience in Analysis, Design, Development, Testing, and Implementation of business application systems for various Financial (Investing Banking, Retail and Oil & Energy based clients in UNIX and Windows environments.
• Extensive experience of more than 9 years in data extraction, transformation and loading data using Informatica PowerCenter 9.x, 8.x, 7.x, 6.x, 5.x (Designer, Workflow Manager, Workflow Monitor), and Data Warehousing.
• Knowledge on Informatica Master Data Management (MDM).
• Strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Startling experience in RDBMS databases like Sybase, Oracle, and MS SQL Server.
• Very strong in PERL and Unix Shell scripting.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Outstanding experience in using SQL/PLSQL, TSQL, Indexes, Functions, Procedures, Triggers and Cursors.
• Tuning of SQL Queries, Database leading to significant improvement in system response time and efficiency using Execution and Query plans.
• Experienced in installing, configuring and implementing various applications in development, QA, and production environments.
• Emphasized on Performance of Mapping Optimizations in Informatica.
• Worked in brokerage, financial, retail and insurance industries.
• Worked in different phases of software development lifecycle across various projects.
• Experienced in client - server architecture based applications.
• Mastered in using third party tools like AutoSys for scheduling jobs and workflows for automation.
• Years of experience in using Sybase, Oracle, MS SQL Server, KSH and Perl.
• Years of exposure to Object Oriented application development.
• Exposure to HTML and JavaScript Scripts.
• Good knowledge in Core Java and exposure to other java related concepts.
• Exposure to modifying the access setup in development, QA and production environments in accordance with SOX compliance and Audit requirements (Migration Integrity).
• Well versed in generating reports using SQR, and Flat files.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Strong Team spirit, excellent interpersonal and management skills.
• Ability to work independently and deliver on time.

TECHNICAL SKILLS

Languages: Perl, JavaScript, Html, Shell, ANSI-SQL, TSQL, Java

Operating System: Sun Solaris 2.x, HP UNIX, Linux, Windows NT, 2000

Databases: Sybase (11.x, 12.x), Oracle(9i,/10g/11g), MS SQL Server

Technology & Tools: Informatica PowerCenter, OOP, OOA/OOD, UML, DBI/DBD, CGI, Cron Tab, CVS, Aquadata, ERWin, Visio, SQL Advantage, RCS, Perforce, Install shield, Tivoli, Altiris, PowerBuilder

Web Servers: Apache Web Server, iPlanet Internet server

Protocols: TCP/IP, FIX, SWIFT

Reports: SQR Reporting tool, Flat files, Salesforce.com Cloud

Data Pulls & Data processing (ETL): Informatica Power Center, Informatica Power Exchange, Infomatica MDM

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

ETL Informatica Lead

Responsibilities:

• Led a ETL development team for the Salesforce Data Integration project.
• Conducted various peer reviews and code reviews during the build period for the project.
• Gathered requirements and data elements crucial for decision making for approach and analysis.
• Analyzed the data that was to be processed as part of the ETL process that was being built.
• Developed mappings for performing Matching and Cleansing of data.
• Developed various mappings and workflows using various transformations like Sorter transformation, Aggregator transformation, Normalizer transformation and Joiner transformation to meet the requisites.
• Developed various mappings that talk to the Salesforce Cloud.
• Designed new database tables (Staging) to facilitate the interim ACE and CHUBB data.
• Involved in discussions on occasional structural changes to the Informatica workflows based on the data and expectations addressed by the client.
• Made changes to code and logic to catch and handle new error scenarios as and when they showed up.
• Wrote ad-hoc queries on the fly to come up validation scripts to spot check data.
• Was involved in various phases of the development life cycle of this project like BRD, project High Level design, development and testing.

ENVIRONMENT: Informatica 9.5 (PowerCenter), Informatica MDM, Oracle 11g, DB2, Salesforce.com Cloud, Flat files, UNIX.

Confidential, Houston, TX

Informatica Lead Developer

Responsibilities:

• Developed various Informatica mappings using various transformations like Sorter transformation, Aggregator transformation, Normalizer transformation and Joiner transformation.
• Created various database objects like Views, Indexes, functions and stored procedures in the database.
• Involved in discussions on occasional structural changes to the Informatica workflows based on the data and expectations addressed by the client.
• Made changes to code and logic to catch and handle new error scenarios as and when they showed up.
• Wrote ad-hoc queries frequently.
• Was involved in various phases of the development life cycle of this project like requirement gathering, project design documentation, development and unit testing.

ENVIRONMENT: Informatica 9.5 (PowerCenter, Power Exchange), Oracle 11g, MS SQL Server, Flat files, Web Services, Windows 7, UNIX.

Confidential, New York, NY

Informatica Lead Developer

Responsibilities:

• Led a team of Informatica developers and gave them directions as per the requirements and desired approach.
• Developed various Informatica mappings using various transformations like Sorter transformation, Aggregator transformation, Normalizer transformation, Joiner transformation and Union transformation.
• Created various database objects like Views, Indexes, functions and stored procedures.
• Involved in discussions on occasional structural changes to the Informatica workflows based on the data and expectations addressed by the client.
• Made changes to code and logic to catch and handle new error scenarios as and when they showed up.
• Worked with the Business Analysts, technical analysts, DBAs and the business users to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets.
• Wrote ad-hoc queries occasionally to satisfy some on the fly user requests.
• Created deployment groups and exported the checked in workflows to XML files for migration to the Test and production environments.
• Was involved in various phases of the development life cycle of this project like requirement gathering, project design documentation, development and unit testing.

ENVIRONMENT: Informatica 9.1/9.5, Oracle 11g, MS SQL Server, Windows 7, Linux.

Confidential, King of Prussia, PA

Sr. Informatica Developer

Responsibilities:

• Developed various Informatica mappings using various transformations like Sorter transformation, Aggregator transformation, Normalizer transformation, Joiner transformation and Union transformation.
• Involved in Performance tuning of the ETL processes.
• Created various database objects like Tables, Views, Indexes, functions, stored procedures and packages.
• Wrote new stored procedures and functions for new data upload setups.
• Modified existing database objects for catching new evolving error scenarios.
• Worked on creating constraints and indices based on the requirements.
• Worked with the Business Analysts, technical analysts and the business users to understand the data, the expected formats, data hierarchies and the functional hierarchies of various datasets.
• Wrote ad-hoc queries occasionally to satisfy some on the fly user requests.
• Wrote Perl modules for database connectivity.
• Created deployment groups and exported the checked in workflows to XML files for migration to the Test and production environments.
• Was involved in various phases of the development life cycle of this project like requirement gathering, project design documentation, development and unit testing.

ENVIRONMENT: Informatica 8.6, Oracle 11g, MS SQL Server, Flat Files, Perl, Win XP, Linux.

Confidential, Stamford, CT/ Manhattan, NY

Sr. Informatica Developer

Responsibilities:

• Developed various Informatica mappings using various transformations like Sorter transformation, Aggregator transformation, Normalizer transformation, Joiner transformation and Union transformation.
• Developed various design documents to design various Informatica mappings to suffice the project requirements.
• Created various connection objects in Informatica.
• Wrote various functions and stored procedures to implement business logic on financial data.
• Wrote various SQL queries to satisfy some user’s ad-hoc requests.
• Did performance tuning on various existing database objects by using Explain plan, Indexing and Hints.
• Modified code for various database objects whenever business need demanded changes.
• Used other features like PL/SQL Wrapper, Hints and Materialized Views
• Conducted various meetings between Business and development teams for discussing various requirements and process flows.
• Worked closely with developers to meet the deadlines set for various requirements
• Wrote some Perl and Shell Scripts occasionally to parse data
• Did performance tuning on various Informatica Mappings to make them faster.

ENVIRONMENT: INFORMATICA 8.6/9.1 (Power Center, Power Exchange), PERL, KSH, TSQL, CRONTAB, Oracle 11g, Sybase 12.x, LINUX, Windows XP

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Developed various Informatica mappings using various transformations like Sorter transformation, Aggregator transformation, Normalizer transformation, HTTP transformation, XML parser transformation, Joiner transformation, Union transformation.
• Created deployment groups and exported the checked in workflows to XML files for migration to the Test and production environments.
• Created various database objects like functions and stored procedures.
• Created appropriate indices in the databases to facilitate better performance.
• Created various Tables, Views and Triggers.
• Wrote various ad-hoc queries to satisfy frequent instant user data report requests.
• Developed various design documents to design various Informatica mappings to suffice the project requirements.
• Worked closely with the Business Analysts, technical analysts and the business users to understand the data, the expected formats, data hierarchies and the functional hierarchies of various retail stores ( Confidential retail stores).
• Was involved in various phases of the development life cycle of this project like requirement gathering, project design documentation, development and unit testing.
• Was involved in writing test cases based on the business requirements for various Informatica workflows developed.
• Documented the functionalities of various Informatica workflows that were developed for this project, for the Tier 1 level support teams.

ENVIRONMENT: Informatica, Oracle 7/8/9i/10g, MS SQL Server, Win XP.

Confidential, Irvine, CA

Informatica Developer

Responsibilities:

• Involved in implementing various data modeling concepts.
• Created mappings with parameter files and transformations (such as Source qualifier, Aggregators, Filters, Router, Joiners, Sequence, Lookup’s, Update Strategy),tasks( such as sessions, command, Event wait, Event raise, Decision) to build business rules .
• Created various connection objects in Informatica.
• Worked with the Business analyst and developed various entity relationship diagrams.
• Involved in Designing Logical and Physical Data model using Erwin Tool.
• Developed various database objects using T-SQL and PL/SQL in Sybase and Oracle databases.
• Created various dimensional and facts tables to implement Star and snow flakes schemas.
• Worked with Unix team to created NFS mounts between the Unix servers
• Created new workflows and mappings based on the logic implemented in the DDS software (in house) for data pulls.
• Created shell scripts to perform data validations during unit testing and system testing
• Documented the changes and implementations related to the project

ENVIRONMENT: Oracle 10g, Sybase 12.X, Unix Shell Scripting, Perl, Informatica, SQR Reporting tool, Java, HTML, Internet Server: IPlanet, PowerBuilder, Install shield, Perforce, AutoSys

Confidential, Stamford, CT

Programmer Analyst

Responsibilities:

• Created many Stored procedures and tables
• Worked in modifying existing Stored Procedures and queries
• Participated in Sybase performance tuning
• Took part in EOD ETL activities
• Created many Sybase object definition scripts and checked them in clear case
• Developed Perl scripts for modifying the grant statements in SQL scripts of Clear case
• Provided support to the Masterfiles application by running extracts and performing data uploads through BCP
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data
• Wrote UNIX shell scripts to transfer and manage data within the database
• Involved in debugging, Tuning and Unit Testing of the T-SQL code
• Provided support for Bulk Updates by running scripts on the TPOS servers, by setting the TPOS links, enabling TPOS routers

ENVIRONMENT: PERL, KSH, TSQL, CRONTAB, Sybase 12.x, Solaris 2.5, Windows XP