Steve Sam

Mobile: +1-508-***-****

Email: acs3zd@r.postjobfree.com

IT Experience Summary

Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Experienced in Insurance, Banking & Financial Services, Manufacturing and Retail Domain.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL Developer

Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed and customized front end Oracle’s Development tools : Oracle Forms 6i and Reports 6i(D2k)

Proficient in tuning queries used in the application.

Strong leadership, interpersonal, analytical, communication and organizational skills with the ability to work independently or in a group.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Project Summary

Project : Workout Prospector

Organization: Freddie Mac, Tampa, Florida

Duration : June 2015 – Till Date

Project Description :

Workout Prospector® is an application which helps in confidently analyze and structure foreclosure alternatives for Freddie Mac loans so that one can reduce costs and often help borrowers become long-term homeowners. By entering a Freddie Mac loan number and other data, Workout Prospector will evaluate eligible borrowers for a modification under the Home Affordable Modification program (HAMP) as well as for Freddie Mac Standard Modifications, Freddie Mac Streamlined Modifications, and court mandated modifications. If a borrower is ineligible for, or unwilling to accept, a modification, Workout Prospector helps one determine which liquidation option, such as a short sale or deed-in-lieu of foreclosure, is the optimal solution for the borrower.

Roles and Responsibilities :

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.

Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Involved in the continuous enhancements and fixing of production problems.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Project : Mortgage Insurance Access

Organization: Freddie Mac, McLean, Virginia

Duration : January 2015 – June 2015

Roles and Responsibilities :

Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.

Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.

Designed and developed Oracle forms & reports generating up to 60 reports.

Performed modifications on existing form as per change request and maintained it.

Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.

Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.

Project : AccelRx

Organization: Cigna Healthspring, Nashville, Tennessee

Duration : May 2014 – December 2015

Project Description :

AccelRx is a data Integration project involving the products belonging to CIGNA and Healthspring. The entire data of products like PDP, MAPD PDP, EGWP PDP of CIGNA are integrated to their counterparts HS PDP, HS MAPD and HS EGWP PDP.

Roles and Responsibilities :

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.

Involved in Logical & Physical Database Layout Design.

Set-up and Design of Backup and Recovery Strategy for various databases.

Performance tuning of Oracle Databases and User applications.

Used SQL*Loader as an ETL tool to load data into the staging tables.

Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.

Provided user training and production support.

Improved the performance of the application by rewriting the SQL queries.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Project : Oracle Hyperion Planning

Organization: TJX, Marlborough, Massachusetts

Duration : July 2013 – April 2014

Project Description :

Oracle Hyperion Planning is a centralized, Microsoft Office and Web-based planning, budgeting and forecasting solution that integrates financial and operational planning processes and improves business predictability. TJX Companies was using Microsoft Excel for its Planning purposes and wanted to implement Hyperrion Planning which is an Oracle product for Planning, budgeting and forecasting.

The data required for Planning is sourced from various systems like Enterprise Datawarehousing (EDW), Oracle EBS and Oracle DRM. The past and current data is sent to the Planning cubes via Enterprise Performance Management System which is the gateway to the cubes. The data in the cubes are analysed by modifying various factors affecting the business and the output based on the modifications are generated via reports.

Roles and Responsibilities :

Involved in discussions with business users to derive requirements. Held design sessions and created functional and technical design documents using Microsoft Visio and Power Point.

Involved in design and development of ASO and BSO cubes to support Planning, Forecasting and Reporting.

Key involvement in editing Calc Scripts, developing MaxL scripts for automation, MDX for advanced queries. Worked extensively on data loads, load rules, Calc scripts and UDAs.

Responsible for the design, development, enhancement, and maintenance of the various BSO cubes used for forecasting and strategic decision-making.

Involved in development, performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations and changing buffer size.

Troubles shooting critical issues in timely manner to- ensure the SLAs (Service level agreement) are met.

Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.

Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them.

Project : Merch System

Organization: Walgreens, Chennai

Duration : July 2012- July 2013

Project Description :

Merchandising System is an data application used in Drugstore, acquired by Walgreens, which automates all operations from product creation to its purchase order. The application has the data of the entire SKUs and new SKUs were created and modified on a regular basis. The Testing of adding and modifying the SKUs were done manually. Hence the client required the process to be automated and it was done successfully using PL/SQL since Oracle was the underlying database.

Roles and Responsibilities :

Gathered requirements for Testing the system and based on the requirements designed and developed PL/SQL packages to automate the Testing processes

Worked with Testing Team to ensure the Automated testing covered all the Testing processes which were earlier done manually

Worked with the client in creating user interfaces and thereby executing the test cases through the UI.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Designed Data Modeling, Design Specifications and to analyze Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Project : ADP Taxware

Organization: ADP, Chennai

Duration : October 2011- July 2012

Project Description :

Tax ware Enterprise combines market tax research with the latest technology. Tax ware Enterprise automatically calculates taxes for sales, purchases and rentals .It is a fully automated system that includes built in functionality to support audit defense, eliminate obsolete data and comply with changing tax US and Canadian laws.ADP (Automated Data Processing Inc.)Plans to roll out service packs for the 7.1 version of the Taxware Enterprise and simultaneously hosted a version of the Taxware Enterprise to attract more customers.

Roles and Responsibilities :

Sole responsibility of all Database related activities like Allocating Tablespaces, Using Export/Import utilities, Access control to users, Tuning SQL queries

Responsible for sending the daily test reports to development team

Testing the product’s Unit Test PL/SQL on various Operating Systems like UNIX, Windows, Solaris

Project : Global Relationship Online

Organization: Dell International Services, Bangalore

Duration : July 2010- August 2011

Project Description :

Global Relationship Online is a reporting tool which enables the top management make crucial decisions driving Online Sales based on the key metrics in the report.

The user gets data from shared point services. These files are refreshed from OLAP cubes which reside on an OLAP server. OLAP cubes are populated with data for every week. The SQL Server Integration Services is used for ETLs. Some data files are generated from Teradata queries which are used in the process. The whole process runs on a SQL Server.

Roles and Responsibilities:

Involved in building queries for new reports and customizing the existing queries to suit the changing business needs.

Configured batch jobs on SQL Server to meet the business requirement

Created and executed SQL Server IntegrationService packages to populate data from the various data sources, created packages for different data loading operations for many applications.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLsetc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Responsible for ETL operations using SQL Server Integration Services (SSIS) and have experience in incremental data loading.

Designed and developed SQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLserver for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Derived Column, Conditional Split, Bulk Insert, Merge and Union all.

Review and understand client business strategies and requirements to incorporate the changes to meet those requirements.

Project : PepsiCo R7

Organization: PepsiCo

Duration : February 2010- June 2010

Project Description :

PepsiCo R7 ETMS takes care of the Transportation module of all PepsiCo Products. From Order Creation till the delivery of the product to the customer is handled in this project. Applications like SAP, Transportation Manager are used to create and process orders from customers.

Roles and Responsibilities:

Developing packages, procedures, functions, and triggers for the application.

Using UNIX environment for performing the testing

Performing the tests on the newly coded procedures and documenting the same.

Writing technical documents using the functional specifications.

Writing PL/SQL code using the technical and functional specifications.

Creating Oracle objects like tables, types, packages, procedures and functions.

Project : Takaful Iklas Sdn Berhad

Organization: TISB, Chennai

Duration : July 2007 – February 2010

Project Description :

The project involves the development and customization of new and existing features to PREMIA, an Insurance product which takes care of the end to end Insurance processes right from Underwriting to Claims.

Roles and Responsibilites :

Involved in SDLC gathering requirements from end users.

Developed views to facilitate easy interface implementation and enforce security on critical customer

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Written Stored Procedures using PL/SQL and functions and procedure for common utilities.

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.

Project : Syarikat Takaful Malaysia

Organization: Syarikat Takaful Malaysia

Duration : July 2007 – February 2010

Project Description :

The project involves the development and customization of new and existing features to PREMIA, an Insurance product which takes care of the end to end Insurance processes right from Underwriting to Claims.

Roles and Responsibilites:

Involved in SDLC gathering requirements from end users.

Developed views to facilitate easy interface implementation and enforce security on critical customer

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Written Stored Procedures using PL/SQL and functions and procedure for common utilities.

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.

Employment History

Name of the Company

Designation

From

To

Duration

(Months)

Cognizant Technology Solutions

Associate – Projects

31-Oct-2011

Till date

40

Dell International Services, Bangalore

Software Development Analyst

06-Jul-2010

24-Aug-2011

14

Cognizant Technology Solutions, Chennai

Programmer Analyst

22-Feb-2010

24-Jun-2010

4

3i Infotech, Chennai

Software Engineer

09-Jul-2007

19-Feb-2010

32

Covenant Consultants, Chennai

IT Recruitment- Assistant Manager

09-Jun-2005

04-Jun-2007

24

Education

Bachelor of Engineering [B.E.] – [Mechanical Engineering] Rajarajeswari Engineering College, (affiliated to the University of Madras) 2000-2004

Contact this candidate