SUMMARY

• Over 8+ years of experience in Analysis, Design, Development and Testing of Business/Application software in Client/Server Architectures.
• Strong analytical and conceptual knowledge in database design and development using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, Developer/2000 and Unix Shell Scripting.
• Expert in the development of PL/SQL Stored Procedures, Functions, Triggers, materialized views and Packages to implement business logic and to generate customized Forms and Reports.
• Excellent proficiency in Performance Tuning of Legacy Systems thereby assisting the organizations in greatly reducing their maintenance costs over the Business Systems.
• Involved in project planning and scheduling, system design, functional specification, design specification, coding and system test plan.
• Excellent background in implementation of business applications and in using RDBMS and OOPS concepts.
• Have in - depth knowledge in Data analysis, Data warehousing and ETL (Extract Transform and Load) techniques and TOAD.
• Ability to communicate & present design or support ideas in a team-related environment
• Expert in Export, Import and SQL*Loader utilities and acquired extensive experience in Data Transformations, Loading and Database Modeling.
• Experience with Star Schema modeling and Snowflake Dimensional modeling.
• Participated in the entire life cycle of the projects and gained sound knowledge in SDLC (Software Development Life Cycle)
• Ability to communicate & present design or support ideas in a team-related environment
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Expertise in Cursors, Cursor Variables, Collections (PL/SQL Tables and V- arrays), Triggers, Native Dynamic SQL.
• Extensive experience in development of Stored Procedures, Functions, Packages and Triggers.
• Loading data from flat files into database tables using SQL*Loader.
• Performed data modeling and design with ERWIN tool and MS Visio.
• Experience in Performance Tuning and Query Optimization using various types of Hints, Partitioning, and Indexes.
• Involved in the design and development of user interfaces and customization of Forms and Reports based on the user requirements using Oracle Forms and Reports 6i/9i.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console,
• Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows
• Experience with Unix Shell Scripting (KSH - Korn Shell Scripting).
• Have good work experience in Sun Solaris, and Windows 95/98/NT/XP/2000.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions. proficiency in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter (8.x/7.x/6.x/5.x).
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Experience in identifying and resolve ETL production root cause issues.
• Experience in maintenance, enhancements, performance tuning of ETL code. proficiency in working with Teradata utilities like (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMON, Visual Explain).
• Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Strong analytical and problem solving skills.
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 8x, 7x/6.1, 5.1, DataStage, Ab initio

Data modeling: Erwin, Visio, System architecture Informatica Power Center 8x, 7x/6.1, 5.1, Data Stage, Ab initio Data modeling Erwin,Visio, System architecture

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2000/2005, IBM DB2, MS Access, Teradata V2R6.

Operating Systems: Windows (NT, 2000/03/XP/Vista/7), Mac (10.4/10.5/10.6 ), Linux (Red Hat), UNIX (Solaris).

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, C, C++, JavaScript, HTML, J2EE

OLAP Tools: Crystal Reports 8.0, Oracle Reports 6i/9i/10g.

Data Modeling: ERWin Data Modeler (ERD), MS Visio.

ETL Tools: Informatica PowerCenter 8.x/7.1/6.2.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Powercenter for extracting, transforming and loading data from relational sources and non-relational source.
• Interact with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Design, Develop and Test ETL processes in order to meet project requirements
• Performs testing and validation activities for ETL mappings, workflows, and data domain validation in ODS and Mart targets
• Created sessions, database connections and batches using Informatica Workflow Manager.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Developed Slowly Changing Dimension for Types 1 SCD, Type 2 SCD with Change Data Capture(CDC)
• Written SQL Queries to apply and maintain the Business Rules.
• Created mappings using pushdown optimization to achieve good performance in loading data into Netezza.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Source data was extracted from Oracle, SQL Server, flat files, COBOL sources and XML sources.
• Worked as individual contributor to the team.
• Involvement in all SDLC phases till deployment and work with the team to ensure timely and quality delivery as per release plan.
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.
• Gather and prepare analysis based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Created various UNIX shellscripts for Job automation of data loads.
• Extensively involved in the analysis and tuning of the application code (SQL). Developed various command tasks to automate the Pre session jobs. Did performance tuning to improve the load. Wrote complexSQL Queriesinvolving multiple tables with joins
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.

Environment: Informatica PowerCenter 9.1, Oracle, shell scripting, SQL Developer,COBOL, UNIX, Netezza, Autosys job scheduler, Erwin, TOAD, SQL*Plus, SQL*Loader, Autosys

Confidential, New Jersey

Sr. Informatica developer

Responsibilities:

• Responsible for Installing and Troubleshooting Oracle 11g backend database.
• Studied the software requirements specifications and gathered the business requirements, analyzed them from functional perspective.
• Actively participated in sessions to review and document business processes and to produce high-quality deliverables.
• Assisted data modeler in designing Conceptual, Logical and Physical data models making use of ERwin for relational OLTP systems.
• Developed Stored Procedures to meet the requirements specifications provided for OLTP and OLAP applications also performing Exception Handling.
• Created, maintained, and analyzed detailed credit spreads, which include calculating adjusted
• Extensive experience in understanding of Functional and Technical Banking domain to validate the data obtained from various source systems.
• Team oriented role focused on supporting the buy-side capital markets group’s clients wherever necessary
• Programmed PL/SQL code to implement business rule through Procedures, Triggers, Functions and Packages using SQL*PLUS and Toad editors.
• Converted old data from Flat files to Oracle database making use of SQL*Loader.
• Extensively used Cursors, Exceptions and Anonymous blocks for generating reports and created Views, Indexes, Joins and Sub-queries.
• Speak directly with customers about their trading strategy, potential market impact, live market color, counterparty feedback and execution guidance
• Work closely with the broader global capital markets & strategy team to leverage resources.
• Expertise in Change Data Capture (CDC) using Informatica Power Exchange.
• Used bulk processing for better performance and easy retrieval of data as a part of tuning the Procedures and Packages.
• Designed data base objects using Collection construct, Varrays using FOR ALL and BULK COLLECT in order to perform bulk data processing.
• Help manage relationships and maintain protocol with our sell side capital markets sales partners
• Developed complex Informatica mappings to implement Change Data Capture mechanism by using Type-2 effective date and time logic to perform Upsert operations at database level.
• Wrote complex SQL scripts and Stored Procedures in Oracle for extracting as well as writing data.
• Worked on BTEQ and multiload scripts to load Teradata tables.
• Worked extensively with Teradata utilities (MLOAD, TPUMP and FAST LOAD) to load data.
• Created Integrity constraints and database triggers for complex data validations and coordinated with the DBA in creating and managing tables, indexes and privileges.
• Re-coded many Functions to correctly use the index for fast scan and recommended some of the heavily used transaction tables for De-normalization.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Analyzed the requirements and framed the business logic for theETLProcess using Talend 5.3 andPentaho4.5.
• Developed and provide support onPentahoKettleETLjobs and also migrate thePentahoKettle jobs to Talend..
• Used different components inPentaholike Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequenc
• Developed/modified the PL/SQL Procedures and Functions to enhance the reusability of the code to be used later in various applications.
• Created Packages, Stored Procedures and Functions to be called by Java modules.
• Used Informatica PowerCenter tools to extract data from SFDC sources.
• Used different components inPentaholike Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence
• Worked on Informatica PowerCenter tools-Designer (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets & Transformations),Repository Manager,Workflow Manager & Workflow Monitor.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Used Indexes and Views for query optimization.
• Extensively used advanced technologies like Collections for optimal performance.
• Improved the performance using Global Temporary Tables, Ref Cursors, Dynamic SQL such as EXECUTE IMMEDIATE for data load and updates.
• Written shell scripts to run SQL jobs on background and integrate data from flat files.
• Converted ETL code in Perl to PL/SQL
• Provided effective support in delivering process and product change improvement solutions.
• Ensured acceptable performance of the data warehouse processes by monitoring, researching and identifying the root causes of bottlenecks.
• Responsible for creating, testing and deploying multipleESP (External Scheduling processor) schedulesin development, testing and productionmainframe boxes.
• Acted as a liaison between the application testing team and development team in order to make timely fixes.

Environment: Oracle 11g/10g, PL/SQL, SQL*PLUS, Informatica PowerCenter 8.6, MS Access, SQL*Loader, Forms 9i, Reports 9i, MS Visio, Toad 9.5 for Oracle, Teradata, Erwin, UNIX shell scripting.

Confidential, Texas

Sr. Inforamtica developer

Responsibilities:

• Involved in analyzing and designing database using Normalization techniques.
• Developed Forms, Menus, Object Libraries, and the PL/SQL Library using Oracle Form Builder 10g/9i.
• Created and maintained development environment, resolved Production and validated Environment problems.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Implemented exception handling using autonomous transactions, Pragma Init, Locks, used save points, commits & rollbacks to maintain transactional consistency & database integrity.
• Developed Front end user interface using Forms 10g.
• Maintained and Updated existing applications of Oracle Forms 10g and Reports 10g based on regular basis.
• Developed custom libraries for the existing applications, used canvases, blocks, and visual attributes in developing front end using forms 10g.
• Developed and deployed the Reports using Oracle Reports 9i.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
• Used Teradata utilities fastload, multiload, tpump to load data from various source systems.
• Involved in Code Review, Code Walk Through, and Unit Testing.
• Involved in Planning, Implementation, Testing, and Documentation.
• Expertise to follow Agile process in application development.
• Mapped the source and target databases by studying the specifications and analyzed the required transforms.
• Designed new Informatica mappings which extract data from PDM system and load into DSS systems.
• Creatednumerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created export import scripts for data migaration on UNIX shell scripting.
• Made changes in existing Oracle PL/SQL Functions, Procedures, and Packages and also wrote new code as per the requirements and handled exceptions.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc..
• Improved the query response time through making use of concepts like Indexes, Collections and Dynamic SQL.
• Used PL/SQL Records, Collections (Nested Tables and Varrays) in complex backend packages.
• Wrote Packages to fetch complex data from different remote database tables using Joins, Sub queries, Correlated Sub queries and reported the data making use of Oracle Reports.
• Successfully managed in setting up the data and configured the components needed by Hierarchy Manager
• Successfully created and debugged many PL/SQL procedures, functions and Packages for the application.

Environment: Oracle 9i/10g, Teradata, SQL, SQL*Plus, PL/SQL, SQL*Loader, Informatica Power Center 8.6/8.1, Export/Import, Unix Server, Oracle Web Application Server, Forms and Reports 9i, Toad.

Confidential, Bethpage, NY

ETL Developer

Responsibilities:

• Worked as part of the development team, along with the Systems Analysts/Business Analysts to design the CDM data model, and the architecture of the system
• Created multiple Type 2 mappings in the CDM for Dimensions as well as Fact tables, implementing both date based and flag based versioning logic.
• Set up Batches and sessions to schedule the loads at required frequency using Power CenterWorkflow manager. Generated completion messages and status reports using Workflow Manager/Workflow Monitor.
• Developed mappings for Customer, Product, Premise and Campaign dimensions, implementing the ETL logic provided as part of the Technical Specifications.
• Created mappings to load the fact tables, used by the COGNOS reports, providing the Customer Service history, Campaign responders data, Prospective customers etc.
• Handled the 2 Terabytes of data warehouse database
• Performance tuning on sources, targets, mappings and SQL queries in the transformations. Worked on flat files as sources, targets and lookups.
• Created sessions and workflows to help schedule nightly loads and process data from source tables for 21 different divisions.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manage
• Maintained multiple PLSQL scripts that extract and load data into the CDM.
• Worked on modification and performance improvements for multiple Source Extract mappings on the CSG and ICOMS billing systems.
• Created and Implemented an aggregation layer to help improve COGNOS reporting performance

Environment: Informatica 6.2, COGNOS 7.0, Oracle 9i, DB2, AS400, PL/SQL, UNIX shell scripts, UNIX, TOAD 7.6/9.0

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in Gathering requirements by holding meetings with users.
• Identify entities and relationships in a business environment using an event-oriented focus.
• Modeled the business process in the enterprise wide scenario.
• Constructed context diagrams and data-flow diagrams based on a description of a business process. Analyzing the data model and identification of heterogeneous data sources.
• Constructed an extended entity relationship diagram based on a narrative description of a business scenario.
• Performed testing and QA role: developed Test Plan, Test Scenarios and wrote SQL Plus Test Scripts for execution on converted data to ensure consistency.
• Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies.
• Worked on Tuning database server, application logic, database objects.
• Worked on tuning SQL statements using Sybase query plan analyzer
• Managed the database objects Indexes, Triggers, procedures, functions, packages, cursors.
• Involved in Maintenance of database, monitoring logs.

Environment: Informatica PowerMart (Designer 5x, Repository Manager 5x, Server Manager 5x), SQL Server 2000, Oracle 8i, UNIX/AIX