Developer Project
Resume:
Deepali Rohe
**************@*****.***
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