SUMMARY

• 12 years’ experience in Analysis, Design, development, testing, implementation and support of various Applications, with good experience in design and development of Client - server applications.
• 8 years of experience with ETL tool using Informatica and writing database extracts using PL/SQL stored procedures.
• As a part of the project assignments, performed roles of Programmer/Developer, Database Systems Analyst and Programmer Analyst using Oracle 9i,/10g/11g and SQL Server 2008.
• Experience in both Waterfall and Agile methodology.
• Having substantial experience in financial services and Insurance and auto dealership industry.
• Extensive experience in Oracle back end objects like Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Strong experience in Logical and Physical Database Design.
• Familiar with Stats Packs and explain plans
• Experience in estimation and optimization of Data Storage.
• SQL loader, DB links, Materialized view creation, index creation and fine-tune queries.
• Played an active role in quality-related activities leading the projects to CMMI-Level 5 and ISO-9001 quality standards.
• Strong writing and documentation skills for the management and development.
• Extensively worked on Onsite-Offshore models. Participated in Requirements gathering onsite and transferred the knowledge to offshore.
• Experience in implementing both Ralph Kimball and Bill Inmon’s Data Warehouse methodology.
• Good Understanding of SDLC Methodology.
• 24/7 production support.
• Possesses the ability to work in self-managed and team environments.
• Have excellent analytical and problem solving skills in large environments.
• Strong understanding of business processes & interface with IT.
• Excellent interpersonal and communication (written and verbal) skills

TECHNICAL SKILLS

Tools: Toad, SQL Developer, DB Artisan, Crystal Reports, Oracle Forms6i and Reports6i, SVN, CVS, Peregrine, Remedy, Informatica 8.x/9.x, IDQ, ILM, DVO, SCOOP, HIVE, PIG

Programming/scripting Languages: SQL, PL/SQL, Java, JSP, C, C++, Perl, Shell Scripting, Python

Markup Languages: HTML, DHTML, XML

Database: Oracle 9i/10g/11g, SQL Server 2005, DB2, MySQL, Sybase, Big data, Erwin, ER/Studio, Oracle data modeler

Operating Systems: Unix, Linux, AIX, Windows 98/XP/Vista

ETL Tools: Informatica Power Center 8.6.x

ERP Tools: Oracle Apps( AR, AP, GL)

Job Schedulers: ControlM, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

DWH Architect/Consultant

Responsibilities:

• Analyze the existing systems and the business user requirements for tactical and strategic needs.
• Define the Architecture and the various phases to create the data warehouse.
• Create multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing needs.
• Create the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation
• Interact with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
• Created the Data Warehouse Data Model to store atomic level data and the summarized data
• Created the Design for Extraction process from legacy systems using combined techniques of Data Replication and Change Data Capture.
• Designed a three tier based Data Warehouse architecture.
• Nightly batch refactoring.
• Analyze and provide performance improvement solutions.
• Performance tuning informatica mappings and implementing best practices.
• Working closely with third party vendors to implement DWH improvements.
• Design and develop ETL workflows in Informatica
• Setting up Autosys jobs for nightly Batch loads.
• Develop packages, function and procedure for reporting needs.
• Proactively identify performance degradation and tuning queries/mappings.
• Monitoring data volumes and following database optimizations techniques.

Confidential, New York, NY

Data Management/ETL Consultant

Responsibilities:

• Involved in requirement gathering, scope definition and mapping specification documentation.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL
• Writing SQL functions, procedures and snapshots in SQL Server Management studio 2008.
• Good understanding of implementing projects in agile/water fall methodology.
• Writing SQL queries to verify and compare source and targets.
• Monitoring and scheduling Autosys jobs.
• Working with business SMEs on developing the business rules for cleansing.
• Used XML generator and XML parser transformations to generate hierarchical XSD’s to target data consumers.
• Consume XSD sources and creating XML views in editor as necessary.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Presenting Data Cleansing Results and IDQ plans results to Operations by generating score cards.
• Develop IDQ plans to identify possible data issues.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Actively contribute in exploring data security / data privacy (data masking).
• Creating/Configuring data masking rules.
• Automating data masking across environments.
• Using ILM to populate data subset and masking across environments.
• Created Entities, Groups and templates and used them in application plan to generate mappings in ILM.
• Created single and table pair test runs in DVO to validate data.
• Generate DVO reports to maintain audit tails.
• Creating jil to schedule Autosys jobs.
• Ad-hoc SQL server procedures for data cleanups.
• Designing and develop SCD mappings.
• Developed data model and created ER diagram for dimensional data model.
• Creating Data model using ERWin and generating DDL’s.
• Data migration from Oracle to SQL Server.
• Written shell scripts to parse logs.
• Writing PL/SQL stored procedures, functions and packages.
• SQL tuning to improve batch performance.
• Used bulk copy for bcpin and bcpout on large data volumes.
• Tuning Informatica mappings to improve performance.
• Creating both Informatica and database partitions to improve session through put.
• Creating, update and close tasks in JIRA.
• Working closely with business and implement sprint cycles
• Creating deployment scripts and run books.
• Providing inputs/suggestions to meet SLA’s.
• Involved in prioritizing and implementing MQC’s is each sprint.
• Working closely with QA’s to understand and sign off test cases.

Environment: s: Informatica 9.1.4, SQL Server 2008, Oracle 11g, Unix Shell scripting, Autosys, TOAD, SVN, DVO, IDQ, ILM, SVN

Confidential, New York, NY

Informatica/Oracle developer

Responsibilities:

• Develop and implement the coding of Informatica Mapping for the different stages of ETL.
• Experience inInformaticamapping specification documentation, tuning mappings to increase performance.
• Proficient in create and scheduling/Creating jobs with dependencies in Autosys.
• Strong skills in requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation.
• Involved in gathering requirements and created design documents and mapping documents.
• Created metadata queries which would help in restart and to find out any missing link conditions or disabled tasks in a workflow
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Involved in the Unit testing and System testing.
• Worked on bug fixes on existingInformaticaMappings to produce correct output.
• Design and development of UNIX Shell Scripts to handle pre and post session processes
• Extracted data from legacy systems and uploaded into Oracle Datawarehouse
• Creating views to pivot data from multiple tables.
• Writing PL/SQL procedures, functions and packages.
• Understanding High Level ETL Requirement specifications to develop LLD for type-I, SCD Type-II and Type III mappings and done rigorous testing for various test cases.
• Developed and support the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems usingInformaticaand provide technical support and hands-on mentoring in the use ofInformatica
• Debug theInformaticamappings and validate the data in the target tables once it was loaded with mappings.
• Created reusable sessions and mapplet’s.
• Used mapplet’s and different transformations to meet the complex logic.
• Used XML generator and XML parser transformations to generate hierarchical XSD’s to target data consumers.
• Debug the sessions by utilizing the session/workflow logs.
• Done writing meta-data information to audit tables at session and workflow level.
• Fixing invalid mapping’s andtroubleshootthe technical problems of the database.
• Generating data models using Erwin.
• Performance tuning on Oracle database queries.
• Activity involve in database design.
• Writing shell scripts to archive data and log files with timestamp.
• Include email notification at session level and workflow level to track workflow status.
• Using pmcmd command to execute workflows from UNIX scripts.
• Monitor and trouble shoot nightly jobs and generate job status report on daily basis.

Environment: s: Informatica Power Center 8.6.1, SQL, PL/SQL, Oracle11g, UNIX Shell scripting, TOAD, Visio, Autosys, SVN

Confidential, NYC

Solution Engineer

Responsibilities:

• Responsibilities include designing the documents which is based on the requirement specifications.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Perform unit testing at various levels of the ETL.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Lead engineer for multiple data ware house projects.
• Developed complex ETL workflows for fetching data from various data providers like Bloomberg, Pershing and Advent.
• Used Informatica webservices.
• Setting up batch jobs, scheduling and monitoring.
• To be part of a global, client-focused team that supports a wide range of business initiatives and processes for Private Banking USA.
• The development services will range from regional specific deliverables to collaborative delivery of global projects and will require strong problem-solving skills.
• Analyze business requirements and create project specifications.
• Write SQL queries and PL/SQL Packages, Exception Handlers, Ref Cursors, Database Objects.
• Writing and implementing PL/SQL scripts for summarizing data from the history table and loading into separate tables for analysis.
• Done the data loading (Migration) process from flat files XML files into the new database respective tables using SQLLDR by writing scripts.
• Involved in System Analysis and Design, Quality Analysis, Quality Control, Quality Process and methodology implementation for Software Applications and Product development.
• Created several PL/SQL stored procedures and functions for the data warehouse.
• Assisted the team of Developers in SQL statement tuning and use of ANALYZE command, Events trace to track the execution plan of statements.
• Involved in Code Reviews and preparing unit test cases
• Developed new reports, stored procedures and enhanced the existing reports to improve speed and accuracy.
• Created test plans and test cases for testing procedures, functions and triggers.
• Wrote database triggers to improve the system security.
• Writing SQL Queries for data validation, extraction and loading.
• Tuning SQL queries used in the applications to improve performance.
• Worked in Installation, configuration of oracle 9i database with FTP concepts.
• Coded, tested, debugged, documented, and maintained programs.
• Worked in creation of Tables using storage parameters and clusters.
• Worked in writing Sub Queries, PL/SQL code tuning procedures and Database triggers.
• Providing level 2 production support.
• Responsible for writing the database programming to Store/Retrieve the information from the database.
• Experience with transactions involving Extraction, Transforming data, Bulk Loads and Data Transformation.
• Well-versed with different stages of Software Development Life Cycle (SDLC)
• Worked with Implementation team and closely moved with end users.

Environment: s: SQL, PL/SQL, UNIX Shell scripting, Oracle 10g/11i, SQL Server 2005, TOAD, Informatica Power center 8.6.1, SQL developer, FTP, Windows 9x/ NT/ 2000/XP/2000, ControlM

Confidential, Atlanta, GA

Sr. Oracle/DWH Developer

Responsibilities:

• Writing complex PL/SQL scripts for data conversion and migration.
• Investigate for possible reasons for errors by reverse engineering the back end code and scripting as need to resolve issues.
• Converting data from legacy system to Oracle 10g.
• Using Export/Import utilities for back up and transferring data from one database to another.
• Building complete schemas and migrating data between different database and schemas.
• Ran batch jobs for loading database tables from flat files using SQL *Loader.
• Data De-Duplication and Clean-up’s.
• Involved in data design and development.
• Familiar with SSIS and SSAS.
• Responsible for creating complex views for dealer, composite and comparison reports.
• Developing Drill down, sub reports using Crystal reports 11.
• Involved in developing PL/SQL function for report computation.
• Working in close with business user and gathering report requirements.
• Extracted data from SQL Server Staging area, transformed the data and loaded into Data Mart.
• Developing Shell scripts to automate the migration process.
• Developing PL/SQL procedures, functions, packages, exception handlers, and database objects.
• Performed some tuning techniques to increase report performance.
• Developing verification scripts for post migration.
• Involved in complete SDLC.
• Creating test plan and develop test cases.
• Documenting all developments and enhancements to application modules.
• Developing complex queries for monthly Metric reports.
• Performed unit testing and providing test cases data for QA to validate functionality.

Environment: SQL, PL/SQL, Informatica 8.6.0, UNIX Shell scripting, Oracle 10g/11i, .net, SQL Server 2005, TOAD, Crystal reports 11, SQL developer, Oracle Forms, FTP, Windows 9x/ NT/ 2000/XP/2000

Confidential, Nashville, TN

Sr. Programmer Analyst - eBusiness

Responsibilities:

• Writing PL/SQL Packages, Functions, Stored Procedures and Triggers
• Created Oracle tables, Oracle Partition, views, Stored Procedures, Functions to be used in various maps.
• Worked on Shell Programming to invoke and schedule the PL-SQL Packages.
• Created the database schema/user in ORACLE and performed simple database administration tasks like importing and exporting schemas between development and production environment, etc
• Used CLOB and BLOB data type for storing bureau images.
• Used SQL Loader to import data (Data Migration) from External files (Excel, Comma Separated, Text) to the database.
• Familiar with Oracle collections.
• Perform unit testing at various levels of the ETL
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Translation of Business processes into jobs for building Data marts
• Having experience in real time transactions using OLTP process.
• Designed and developed SQL query scripts to generate special reports.
• Developed data model and created ER diagram for the back-end component of the application.
• Database performance tuning.
• Developed dealer activity reports using Oracle Reports 6i
• Involved in database migration from Oracle 9i to 10g.
• Coordinated software QA and release schedules.
• Involved in design, development, testing phases various Business and Matrix Reports
• Monitoring the Nightly Deltas and Scoring Jobs.
• 24/7 Production support.
• Expertise in SOX standards.
• QA and Integration of various applications both in production and UAT environments.
• Involved in writing clean up scripts, roll up scripts for Fixed Rate, Collateral Value, Floating Rates, Model Load, Residual Load, Prescribed Rates etc
• Configuration of Appscope, Production Control and Sitescope servers.
• Writing Java scripts for monitoring, Performance analysis and credit scoring report.
• Involved in developing nightly extract scripts from legacy systems (Infolease).
• Architectural designing and development for RUMS (Residual Upload Management System).
• Involved in setting up credit rules in BLAZE.
• Building WAS server on both Windows and UNIX servers.
• Building CQS ( Confidential Quoting Software) servers.
• Applying service packs and deploying new dll’s
• Data Discrepancy, Data De-Duplication and Clean-up’s.
• Use efficient techniques to Parse, manipulate and transform data between table.
• Designed and implemented error checking and correction protocols and programs
• Maintaining and administrating Iplanet instances.

Environment: Informatica 8.x, SQL, PL/SQL, PERL, UNIX Shell scripting, Oracle 9i/10g/11i, Java, TOAD, SQL developer, FTP, SQL*PLUS, Weblogic 9.1, WebSphere 6.0, Oracle Forms 6i, Windows 9x/ NT/ 2000/XP/2000

Confidential, San Mateo, CA

Migration/Solution Engineer

Responsibilities:

• Studied the Logical Data model to understand the business process and prepare the Physical Data Model and Source to Target Mapping documents.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL Loader.
• Involved in design, development, testing phases of Data Warehouse.
• Implementation of multiple Schema creation and Migration.
• Developing the Querying and Reporting process and data extraction.
• Writing Shell Scripting to invoke and schedule the PL-SQL Packages.
• Used SQL Loader (Oracle tool for loading data from a file into Oracle database).
• Creation of Bitmap indexes & Partitioned indexes for partitioned tables to maximize performance.
• Hands on knowledge with collection and BULK operation.
• Performing normalization and de-normalization on database schemas to increase the performance.
• Provided support, Trouble shooting bug fixing for different platforms, different applications Production and testing environments.
• Developed new reports, stored procedures and enhanced the existing reports to improve speed and accuracy.
• Trouble shooting the Data Discrepancy, Data De-Duplication and FTP setup.
• Analyzing requirement of client, generating and designing reports.
• Monitoring the Nightly extracts.
• Developing PERL and Shell Scripts for Auto Work Flow and Auto Imports.
• Written Control Files for Loading ASCII/Flat files onto the Oracle database using SQL Loader.
• Performing Sanity Testing.
• Monitoring, scheduling and triggering the nightly deltas for data sink.
• Created database objects through development, testing, and production environments.
• Working closely with the importing and acceptance testing Teams.
• Developed event Collector and Targeting tool for monitoring the targeting jobs.
• Worked development and maintenance of Campaign Manager.
• Developed Procedure and Packages for the Targeting criteria implementation.
• Launching the test campaigns and generating the report.
• Maintain version Control on the Program Units that were developed using Win-CVS (version control management software).
• Resolving and accelerating the Remedy Tickets.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.

Environment: Oracle11i/10g, SQL, PL/SQL, Java, PERL, UNIX Shell scripting, TOAD, FTP, SQL*PLUS

Confidential, San Francisco, CA

Oracle Developer

Responsibilities:

• Developed database objects -tables, views, indexes, and sequences.
• Customized Shipping Reports namely pick slip, Packing List, Invoice and Open Purchase Order.
• Developed custom Reports using Reports 6i.
• Wrote PL/SQL Packages, Functions, Stored Procedures and Triggers Use efficient techniques to Parse, manipulate and transform data between tables and documents
• Involved in calculating salary, bonus, PF statement, and loans for divisions, reports based on salary register, employee master, and loan information.
• Coordinated software QA and release schedules
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications
• Helped design custom data models that integrated with Oracle Applications.
• Gathered application requirements and provided design recommendations.
• Created reports according to organizational requirements.
• Writing UNIX Shell scripts for database for installation, job scheduling and monitoring of production databases.
• Used SQL Loader to load data into table from incoming flat file.

Environments: Oracle Application, SQL, PL/SQL, Developer 2000, SQL Loader Oracle 8.0.4, Windows 2000/NT