Deepali Rohe

ac4s9c@r.postjobfree.com

PL/SQL Developer

Contact No : 717-***-****

Certified Associte

Skills Summary:

Over 9 years of experience mainly in data warehouse, PL/SQL and Agile in various domains like telecom, insurance, healthcare, retail and banking.

Strong hands on data architecture and modeling of OLTP system.

Excellent skills in database logical, physical and conceptual design, monitoring and tuning, performance optimization, aggregate and index design, writing triggers, procedures and packages, partitioning, dynamic binding and role monitoring.

Through knowledge of DWH concepts and ETL methodology and DW principles, DWH architectures and SSIS

Experience in integration of various data sources with multiple relational databases like Oracle, DB2, and SQL Server.

Experience in Agile methodology and JIRA.

Good analytical, design and problem solving skills, excellent hands on data analysis, migration and validation.

HIPAA certified familiar with pharmacy terms.

Worked as a team lead for 1 year and have exposure to project management.

Completed TCS internal project management certification.

Technical Skills:

Software / Products:

Metasolv, Harvest (Version control), Perforce, Microsoft Office

Development Tools

TOAD 7.0, PL/SQL developer, Putty, SQLDBX, IBM DB2 developer, SQL developer

Databases:

Oracle 9i, 10g, 11g, DB2, SQL Server

ETL Tools:

SSIS

SDLC Methodologies

Agile, Waterfall

Educational Qualification:

Bachelor of Computer Science and Engineering (B.E.), Amravati University, India, scored 76%.

H.S.C., Amravati Board, Amravati, India, scored 82%

S.S.C., Amravati Board, Amravati, India, scored 83%

Project Experience:

Organization : Capgemini Pvt. Ltd. Nov 2014 to Aug 2017

Client : Barclays Ltd. Nov 2014 to Aug 2017

Role : Oracle PL/SQL Developer

Project : Motif

Brief: Motif is a sub ledger for Barclays accounting which is source for downstream data reporting.

Responsibilities:

Understanding business requirements and specifications.

Developing PL/SQL functions, procedures, packages and triggers as per the requirement.

Creating DB design document for the proposed requirements.

Perform unit testing of programs and creating unit test case document.

Coordinate with business analyst and front end developers for proposed requirements.

File upload, environment set up and day roll using orchestration UI.

Maintain project documentation like iQA, eQA and PMR report.

Organization : Future Focus Infotech Pvt. Ltd. Jun 2014 to Oct 2014

Client : Credit Suisse Jun 2014 to Oct 2014

Role : Oracle PL/SQL Developer

Project : IT Internal

Brief: This project is an internal IT application of Credit Suisse to maintain the IT Expenses.

Responsibilities:

Understanding business requirements and specifications.

Creating technical specification and DB design document.

Developing PL/SQL functions, procedures, packages and triggers as per the requirement.

Developing UNIX shell scripts as per the requirements.

Perform unit testing of programs and creating unit test case document.

Organization : Mindteck Inc. Dec 2012 to Sep 2013

Client : Highmark Inc. Dec 2012 to Sep 2013

Environment : Oracle, Unix

Role : Oracle PL/SQL Developer

Project : ICIS Development

Brief: ICIS (Integrated Customer Information System) is repository for customer information. Used to track Highmark sales representative activity, store prospective account information and maintain client, group rating and benefit information.

Responsibilities:

Understanding business requirements and specifications.

Developing PL/SQL functions, procedures, packages and triggers as per the requirement.

Developing UNIX shell scripts as per the requirements.

Perform mass updates on database based on data analysis and requirements.

Creating DB design document for the proposed requirements.

Perform unit testing of programs and creating unit test case document.

Coordinate with business analyst and front end developers for proposed requirements.

Organization : Tata Consultancy Services Jan 2007 to May 2012

Client : Rite Aid Corporation Aug 2009 to Feb 2012

Environment : DB2, Unix, SQL Server, SSIS

Role : ETL Developer, Team lead

Project : DW Loyalty

Brief: This application is a Loyalty program (wellness+) which emphasizes on Pharmacy and Front-End sales.

Responsibilities:

Understanding business requirements and specifications.

Creating requirement documents using techniques- send questionnaires, conduct brain-storming sessions, co-ordinate with support teams, demonstrate prototype to client.

Analyze client requirements and existing system to come up with analysis document to determine need of proposed change.

Developing the Data warehouse system (ETL part) as per the requirements.

Develop UNIX scripts to extract and load data to staging tables.

Develop SSIS packages to load data into SQL server tables.

Data set up and planning of end to end testing of complete ETL system which includes unit testing, module testing, regression testing and system testing.

Analysis of business rules for customer segmentation and rewards management.

Implementation for customer segmentation, rewards management and targeting as per the business rules.

Integration, load and system testing of rewards management and targeting.

Logging and resolving defects and analyzing the causes using iQMS.

Participate in Project Management Report (PMR) and audit.

Organization : Tata Consultancy Services Jan 2007 to May 2012

Client : Tata AIG Life Insurance Feb 2009 to Jul 2009

Environment : Oracle, DB2

Role : ETL Developer

Project : i-TALIC

Brief: The purpose of the application was to collect and analyze the sales and agent performance.

Responsibilities:

Understanding business requirements and specifications for insurance system.

Creating and debugging SQL queries and procedures to support front-end application database interface.

Develop PL/SQL functions, triggers and packages as per business requirements.

Developing the ETL to fetch the data created by the application and put it into DW tables.

Develop UNIX scripts to extract and load data to staging tables.

Creating reports based on the data which represents agent performance and sales analysis and help under writers for their business analysis.

End to end testing of complete ETL system and application procedures.

Logging and resolving defects and analyzing the causes using iQMS.

Provide ad hoc reports to underwriters for analysis and planning for future insurance services.

Create daily reports of collection management system using crystal reports.

Organization : Tata Consultancy Services Jan 2007 to May 2012

Client : Tata teleservices limited Mar 2007 to Jan 2009

Environment : ASP, Oracle, UNIX

Role : PL/SQL Developer

Project : Provisioning Knowledge System

Brief: The purpose of the application was to track and analyze sales, revenue and errors and resolve the frequent errors in POS and Billing area.

Responsibilities:

Understanding business requirements and specifications.

Creating and debugging SQL queries and procedures to support front-end application database interface.

Creating PL/SQL functions, triggers and packages as per business requirements.

Developing the ETL to fetch the error data from POS and billing system and put it into DW tables.

Developing UNIX scripts to send data to client and load data in to staging area.

Develop front end application in ASP.

Write procedures and shell scripts to resolve error automatically from the system which does not need manual interaction.

Documenting test cases and test results, User Manuals.

Integration, load and system testing of application and reports.

Logging defects and analyzing the causes using iQMS.

Provide ad hoc reports to management which helps them in analysis.

Organization : Tata Consultancy Services Jan 2007 to May 2012

Title : TCS Initial Learning Program Jan 2007 to Feb 2007

Location : Trivandrum, India

Objective of ILP training program is to groom an individual as perfect software professional. TCS honed my technical and intra personal skills. I have been trained on SDLC, mainframes, software testing, data warehouse, ETL methodologies and SQL in these 2 months. Training was a perfect introduction to the world of software industry and how it works.

Contact this candidate