Summary:

Senior Consultant/Lead with about over 8 years of IT experience in Retail, Insurance, HealthCare, Utility business domains - analyzing requirements, application design, development, testing and production support of database applications. Out of which 7 years expertise in Pro*C, C, C++, ORACLE RDBMS Technology, ORACLE Development Tools, UNIX utilities and other Client/Server development tools like TOAD, SQL Developer.

Expertise:

• Worked with HCL, Walgreens, Abercrombie Fitch, Michaels, EDS, HCA, Preserver Group, First energy corporation group and PVAK soft.
• Worked for SATYAM and State project for Medicaid.
• Extensive experience and good knowledge both Functionally and Technically on RETEK.
• Extensive experience in complete ReSa implementation in Retek-13 according to business needs.
• Good Expertise in end-end implementation of ReSa, WMS.
• Extensive experience in RMS, RPM, POS, WMS, RPAS, Stock ledger, Allocations and Transfers.
• Extensive experience in Data modeling and Designing.
• Extensive experience in writing SQL Queries, PL/SQL Stored Procedures, Packages, Functions, and Database Triggers, fine tuning SQL Queries using Explain Plan, SQL Trace, and TK-Prof.
• Extensive experience in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TOAD
• Expertise using Oracle 10g/9i/8i/8.0, Oracle Forms 10g/6i/6.0 and Report10g/6i/6.0, SQL, PL/SQL, SQL*Loader, Stored Procedures, DBMS Packages, TOAD, SQL DEVELOPER, Ref Cursors, Constraints, Partitions, Triggers, Indexes: Indexes-B-tree Index, Bitmap Index, Views: Inline Views, Materialized Views, Database Links, Export/Import Utilities. Tuned SQL, PL/SQL, analyzed tables, used Hints.
• Extensive experience in decision support system (DSS), Dimensional Data Modeling, data warehouse requirement analysis and Implementation.
• Expertise in C/C++, Pro*C using Pointer, Structures, Macros, Functions
• Expertise in creating new C/C++, Pro*C Batch Programs with embedded SQL’s, Pl/Sql Procedure calls, Arrays and Dynamic SQL..
• Exposure to Retail domain and gained Retek Business Knowledge
• Five years of strong Data Warehousing experience using SQL scripts and Informatica Power Center Designer: Source analyzer, Warehouse designer, Mapping designer,Target analyser. Workflow Manager: Task Developer, Worklet, Workflow Monitor, Repository Manager, Star Schema Modeling, OLTP, OLAP
• Expertise in Unix Shell Scripting, scheduling and automating.
• Expertise in Unix Shell Scripting for ftp, sftp process.
• Expertise in writing Unix Shell Scripts for ETL process.
• Experience in Mercury Quality Center
• Experience in Multithreaded programming, Data Structures, Algorithms and Object Oriented concepts.
• Actively involved in Performance Tuning and support on Informatica, Oracle for faster database access and better query performance.
• Good Experience in BEA TUXEDO 8.0 services
• Result oriented with good interpersonal and excellent analytical and problem solving skills
• Good Understanding and proficient knowledge in Seibel, Sybase, Teradata, TIBCO BW.
• Good Understanding and proficient knowledge in IPC/Socket

Technical Skills

Operating Systems HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS, Windows XP/NT/2000.
Languages C/C++, Pro*C, Java, COBOL, PL/SQL,XML, HTML, UNIX shell Scripting, Perl
Office Applications MS Office 2003/XP/2000
Databases Oracle 10g/9i/8i, SQL Server, MS Access 2003/2000
ETL Tool Informatica Power Center
OLAP/DSS Impromptu 7.1/7.0/6.0, Impromptu Web Reports 7.0/6.0, Powerplay, Cognos ReportNet
Other Tools SQL*Loader, TOAD, SQL Developer, SQL Navigator, Teradata
Web applications JAVA, JSP, PHP

Professional Experience

Confidential, Sep - 10 to till date
Chicago, IL

Oracle/Pro*C /Senior Consultant /

Oracle Retail Sales Audit (ReSa).

Confidential,is one of the luxury clothing retailer merchant in Brazil. They are implementing revitalization project which aims to clean up RMS (RMS, RPM, ReSa, Item, Allocations) data since the client has never configured to purge.

Responsibilities:

• As a Sr Developer involved in business meetings and gathered requirements at the client location(Brazil), developed the functional and technical design doc and to-be process map, taking into account best practices
• Have involved actively in the implementation of ReSa, RMS, RPM , ITEM(Retail Sales Audit).
• Have involved in data modeling and designing of RMS, ReSa, custom tables.
• Coding and reviewing of enhancements done in the Interface side during implementation.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Developed custom batch programs in Pro*C and developed custom Functions, Procedures and Packages Scripts for RETEK -12 implementation.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql for RETEK-12.
• Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load to purge RMS data.
• Developed Triggers to trace the performance of batch programs
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms 10g
• Preparing unit test cases and performing unit testing
• Followed the SDLC lifecycle methodology during the implementing stage of the project.
• Performed optimization of SQL queries (Used SQL Trace, Analyze, Explain Plan Utilities, TK-prof and Hints to tune SQL Queries.)
• Involved in production support for resolving end-users issues
• Created test cases to Unit test for SQL scripts before UAT release

Environment: IBM AIX 5.3, C/C++,Pro*C, Oracle 10g, SQL, PL/SQL, Forms, Reports, SQL Navigator, UNIX Shell, SVN Version Control, Windows XP.

Confidential, Oct-09 to Sept-10
Deerfield, IL
Oracle/Pro*C /Senior Consultant
Retail Mail Pharmacy Management (RMPS)

Confidential, is the largest drugstore and retailer in the United States. The company operates about 7,034 drugstores across all 50 states. Walgreens has developed its own custom application InterCom Plus(IC+) for Retail pharmacy management and implemented different releases to upgrade the system. Walgreens is implementing PPM3655-Patient Drug Monograph Font Control. PPM3655 functionality supports the state regulations to print the patient’s drug monograph in a specific font size as per the state rules and regulations.

Responsibilities:

• Actively involved in business meeting and gathered requirements to developed the functional and technical design doc and to-be process map, taking into account best practices.
• Developed design documents for new TUXEDO service according to business needs for development.
• Coding and reviewing of enhancements done in the Interface side during upgrade.
• Have developed new TUXEDO services using .gen, .pv, Pro*C, .arr files.
• Developed Server side programs in Pro*C.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts ,Pro*C, and C++.
• Have involved in data modeling and designing of custom tables.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql.
• Developed C, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load.
• Preparing unit test cases and performing unit testing.
• Followed the SDLC lifecycle methodology during the implementing stage of the project.
• Performed optimization of SQL queries (Used SQL Trace, Analyze, Explain Plan Utilities, TK-prof and Hints to tune SQL Queries.).
• Involved in production support for resolving end-users issues.
• Created test cases to Unit test for SQL scripts before UAT release.

Environment: IBM AIX 5.3, Pro*C, Oracle 10g, SQL, PL/SQL, BEA TUXEDO 8.0, SQL Navigator, UNIX Shell, RCS, PCL Print Language, Windows XP, Mercury Quality Center.

Confidential, Oct-08 to Oct -09
Columbus, OH

Oracle/Pro*C /Senior Consultant / Lead

Oracle Retail Sales Audit (ReSa).

Confidential,is an American luxury clothing retailer merchant encompassing five brands: The namesake flagship Abercrombie & Fitch, Abercrombie kids, Hollister Co., RUEHL No. 925, and Gilly Hicks. Stores currently operate in the United States, Canada, and the UK. A&F is implemented RETEK v-13(RMS, ReSa, SIM, RPM, WMS, RPAS, Stock ledger, Inventory, POS, Allocations, PO, WMS) in three phases. There are some Custom Applications (batches) implemented in ReSa, SIM, WMS like Credit Card settlement application (Customer Billing) which is implemented in ReSa module. The Credit Card settlement application is extremely important as it communicates to the banks for initiation of payments to merchant (A&F) for their Credit Card sales and to bill customers for their purchases.

Responsibilities:

• As a Lead involved in business meeting and gathered requirements to developed the functional and technical design doc and to-be process map, taking into account best practices
• Have involved actively in the implementation of ReSa, RMS (Retail Sales Audit).
• Created technical design documents for new custom Batch programs according to business needs for development team.
• Have involved in data modeling and designing of RMS, ReSa, custom tables.
• Migrated the Credit Card Settlement application from COBOL to Pro*C, with enhancements to the application.
• Using Packages, Functions, Pro*C Developed a massive custom batch program for Credit Card settlement for transactional data.
• Coding and reviewing of enhancements done in the Interface side during implementation.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Developed custom batch programs in Pro*C and developed custom Functions, Procedures and Packages Scripts for RETEK -13 implementation.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql for RETEK-13.
• Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load.
• Developed Triggers to trace the performance of batch programs
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms 10g
• Preparing unit test cases and performing unit testing
• Followed the SDLC lifecycle methodology during the implementing stage of the project.
• Performed optimization of SQL queries (Used SQL Trace, Analyze, Explain Plan Utilities, TK-prof and Hints to tune SQL Queries.)
• Involved in production support for resolving end-users issues
• Created test cases to Unit test for SQL scripts before UAT release
• Executed the application testing in Mercury Quality Center for Smoke testing, System testing, Integration testing.

Environment: IBM AIX 5.3, C/C++,Pro*C, Oracle 10g, SQL, PL/SQL, Forms, Reports, SQL Navigator, UNIX Shell, SVN Version Control, Windows XP, Mercury Quality Center, COBOL.

Confidential, Nov-07 to Sep - 08
Irving, TX

Sr.Oracle/Pro*C Consultant

Oracle Retek Merchandising System (RMS) Upgrade

Confidential,implemented Oracle Retail Merchandising System (RMS) V12, Oracle Retail Price Management (RPM) V12 and Oracle Retail Predictive Application Server (RPAS) using an ultra-light approach. The Ultra Light approach will move foundation data to RMS 12, while maintaining transactional data in the existing Retek 6.6 system. The approach is called "Ultra-Light" since it focuses on functionality that supports the corporate strategic initiatives such as Pricing and Strategic Sourcing. The Promotions functionality will remain in Retek 6.6. The remaining functionalities were planned to be deployed during future phases. This approach is expected to provide an effective foundation for integration of other applications into the Merchandising applications.

Responsibilities:

• Prepared the technical design and to-be process map, taking into account best practices
• Coding and reviewing of enhancements done in the Interface side during upgrade.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts and Pro*C.
• Have involved in data modeling and designing of custom tables.
• Developed batch programs in C/C++,Pro*C using Multithreading Programming and wrote Scripts for RETEK 6.6 upgrade.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql for RETEK 6.6 upgrade
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms 10g
• Preparing unit test cases and performing unit testing
• Followed the SDLC lifecycle methodology during the implementing stage of the project.
• Performed optimization of SQL queries (Used SQL Trace, Analyze, Explain Plan Utilities, TK-prof and Hints to tune SQL Queries.)
• Involved in production support for resolving end-users issues
• Created test cases to Unit test for SQL scripts before UAT release

Environment: IBM AIX 5.3, C/C++,Pro*C, Oracle 10g, SQL, PL/SQL, Forms, Reports, SQL Navigator, CVS Version control, UNIX Shell, Windows XP.

Confidential,Madison, WI Oct’06 – Nov’07 REOMB Reports (Recipient Explanation of Medical Benefit) Sr.Oracle/Pro*C /ETL Consultant Confidential,is a federal/state program that pays health care providers to deliver essential health care and long-term care services to frail elderly, people with disabilities and low-income families with dependent children, and certain other children and pregnant women. Objective of the project is migrating the data from Model Office Interchange to DSS (Design Sub System), developed one of the main module REOMB(Recipient Explanation of Medical Benefits). Aim of the module is to generate physical reports for the claims data provided by the providers. These physical reports contain recipient claims and medical benefits information. To prevent fraud, these physical reports are sent to the recipients for their review.

Responsibilities:

• Involved in analysis, design, development phases of the project
• Involved in walkthrough sessions with business users during Analysis and Designing phase
• Developed PL/SQL scripts, packages, procedures and functions used for migrating data from interchange to present DSS (Design Sub system).
• Optimized SQL and PL/SQL performance using Oracle utilities like hints, Explain Plan, SQL-Trace and TK-Prof
• Developed Major physical reports (text files) Using Pro*C, C/C++ from existing warehouse system (DSS) (Pointers, Structures, functions, Macros).
• Generated Unicode, UTF-16 files using File Descriptor in Pro*C for the foreign language.
• Involved with the Medicaid Data Warehouse project and involved in part of Data analysis, Dimensional data modeling the schema and generation of star schema model.
• Developed UNIX shell scripts to automate the REOMB batch process and ftp’d the out put files from Pro*C programs to remote printer to generate the static physical reports.
• Created test cases to Unit test for SQL scripts before UAT release
• Tested the applications with production data.
• Enhanced and developed the existing Tuxedo services
• Have good knowledge and understanding rules of HIPAA

Environment: AIX 5.3, Pro*C, C/C++, Oracle 10g, SQL, PL/SQL, SQL Developer, BEA Tuxedo, SQL Server , Data Modeling, UNIX Korn Shell, Windows XP.

Confidential,Nashville, TN May’05 – Oct’06 Consolidated Reporting Project Oracle/ETL Consultant Confidential,provides health care services primarily in the United States. It operates general, acute care, psychiatric and rehabilitation hospitals. The objective of this project was to build a data mart for the Customer Service department. Customer transactional data is provided in flat-files which is pulled into Oracle staging tables, transformed and then used to design the data mart.

Responsibilities:

• Involved in scoping requirements, preparing technical specification documents by interacting with Business Analysts and end-users
• Developed naming conventions and coding standards
• Involved in migrating legacy data from existing system using SQL*Loader and Informatica
• Developed PL/SQL Packages, Procedures, Functions, SQL Scripts, Database Triggers to populate the historic data in the tables applying business logic
• Wrote database triggers for enforcing complex business rules
• SQL Tuned queries by creation of Indexes, Rebuilding Indexes
• Developed PL/SQL stored procedures to automate processes like Email Sending (UTL_SMTP). This was used for both on-demand basis and pre-defined schedules
• Used Oracle Job Scheduler and Crontab to schedule execution of jobs
• Worked with Pro*C scripts for interface modules.
• Developed numerous forms, reports using Oracle forms 6i
• Involved with the Medicaid Data Warehouse project and involved in part of Data analysis, Dimensional data modeling the schema and generation of star schema model.
• Wrote test plan, test cases and test scripts and prepared documentation
• Responsible for UAT, bug fixes, build migration releases
• Involved in Supporting the client in day to day activities like refreshing of test database from production, creation additional role, users, indexes helping developers in code optimizations
• Created Catalogs & Reports using Cognos Impromptu 7.1
• Published Impromptu reports to Upfront application through Cognos Server Administration

Environment: AIX 5.3, Solaris 8, Oracle 9i, Forms 6i, Reports 6i SQL, PL/SQL, Seibel, C/C++, Pro*C, SQL*Loader, Informatica 7.1.1, XML, TOAD 6.3, Data Modeling, Windows XP, Korn shell

Confidential,Newark, NJ Jul’04 – Apr’05

Decision Engine Data Warehouse
ETL Developer

Confidential,provides a wide variety of property/casualty insurance products specifically tailored to meet the needs of the small and mid-sized commercial markets in the Middle Atlantic and New England regions. The objective of this project is to provide the foundation, tools and capabilities to insurance agents to identify and deliver cross-sell and up-sell diverse insurance products to business customers.

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Writing PL/SQL Stored Procedures, Functions, Packages to meet the business requirements
• Writing SQL reports and scheduling these reports from UNIX scripts using crontab
• Scripting and tuning adhoc queries for the business people
• Worked on performance issues and used EXPLAIN PLAN for tuning the queries
• Worked with SQL*Loader for bulk load processing
• Worked with Pro*C to migrate the data into warehouse tables.
• Developed numerous forms, reports using Oracle forms 6i
• Developed reporting applications, which provide users with parametrized and open Queries to produce customized reports Using Oracle Reports
• Involved in code walk through and review sessions with the development team
• Involved in production support for resolving performance, data related end-users issues
• Involved in walk through with QA team and reviewing their test cases and recommending changes

Environment: Oracle 8i, PL/SQL, Pro*C, C/C++, Forms 6i, Reports 6i, UNIX shell scripting, SQL Navigator, UNIX, TOAD

Confidential,Akron, OH Oct’03 - Jul’04
Order Processing System Customization

Oracle/Pro*C Developer Confidential,is 4th largest investor-owned utility company headquartered in Akron, Ohio This project required customizing number of Oracle apps delivered functionality to suit First Energy corp’s supply chain business processes.

Responsibilities:

• Involved in discussions with the Business Analysts and End-Users. Designed data models and created data objects like tables, views, synonyms etc
• Developed Complex SQL Queries to update and maintain the database
• Developed Stored Procedures using PL/SQL to validate and insert data into Application tables
• Support the existing system to resolve any performance tuning issues with Explain Plan, SQL Trace, TK-Prof and PL/SQL Optimization techniques
• Developed Database triggers using PL/SQL for storing the important transactions in the history tables and to audit some master tables
• Developed number of adhoc reports using SQL*PLUS to validate migrated data
• Developed Unix Shell Scripts for scheduling application tables data load
• Developed C/C++, Pro*C scripts using Multithreading programming for interface tables.
• Involved in Functional, Regression and Integration testing of applications in various instances
• Involved in production support for resolving performance, data related end-users issues
• Provided production support to end users on Order management reports, data and UI issues

Environment: Solaris 2.6, Oracle 7.x/8 , Oracle Apps 11i, Forms 6i, Reports 6i, TOAD, Perl 5, SQL, Pro*C, C/C++, Unix Shell Programming

Confidential,Cyprus May’02 - Aug’03 Chris Cash & Carry, Nicosia, Cyprus Sales and Marketing Datawarehouse ETL Developer Confidential,is the largest publicly listed food, beverage and packaging company in Cyprus. Its food and agribusiness units make animal feed, coconut oil, dairy and meat products. This project was to capture the Sales and products marketing processes and data warehouse to maintain client’s history and current data. Data from Source System was extracted, transformed and loaded into data warehouse.

Responsibilities:

Worked in all phases of this project from analysis to implementation

• Involved in preparing technical specification documents, preparing test cases and test scripts to review and sign-off with users

Used ETL tool Informatica, for Extraction, Transformation and loading data into various staging tables

• Responsible for creating Oracle DDL, DML SQL Scripts to configure application development environment
• Created number of PL/SQL named blocks – Procedures, Functions, Packages to incorporate business process logic like invoices, and to calculate sold and unsold products etc.,
• Utilized Oracle utilities like Explain Plan, SQL-Trace, TK-Prof to fine tune queries and optimize PL/SQL subprogram runs
• Created flat files as reports and migrated into remote server using Pro*C scripts
• Successfully resolved number of High-to-low priority production tickets and provided knowledge transfer to client’s employees

Environment: Informatica Power Center 5.1, Pro*C Oracle 8i, SQL, PL/SQL, SQL*Loader, Pro*C, C/C++, Developer/2000, Windows NT

Confidential,Cyprus Apr’01-May’02 JAVA Developer Confidential,is a software development based in Cyprus part of their project development team worked as a java developer Responsibilities: Developed the presentation layer and GUI framework that were written using HTML and client-side validations were done using JavaScript Designed and involved in coding of JSP pages accessing java beans and JavaScript validations Developed Servlets to process the requests on the server and to transform the processed data to database Written stored procedures using PL/SQL to upload the student information into DB

Environment: Java, JSP, SQL, PL/SQL, Pro*C, C/C++, Oracle 8i, SQL*Loader

Education:

Bachelor of Computer Applications