SUMMARY

*+ years of IT Experience as an Oracle PL/SQL Developer, Data Analyst, and Data Modeler in Data Warehousing.

Experience as a Business Analyst for data warehousing with a good knowledge and expertise in all phases of SDLC methodology including analysis, design, development, testing and maintenance.

Extensive experience working with SQL & PL/SQL in creating stored procedures, packages, views, triggers, cursors, exception handling. Extensively used Quest tools like TOAD.

Proficient in Data Analysis, design using ER modeling and implementing RDBMS specific features.

Experience in Telecommunication, Retail, and Pharmaceutical Domains maintaining Databases.

Well versed in Normalization to 3NF/DE normalization techniques for optimum performance in relational and dimensional database environments.

Can effectively use CASE tools like Erwin.

Experience in Data Migration, Data Conversion, Data Extraction, Transformation and Loading (ETL) using Informatica and PL\SQL Scripts.

Experience with both DDL and DML including Joins, Functions, Indexes, Constraints, Primary Keys and Foreign Keys

Experience in Performance Tuning in Oracle and SQL Optimizing. During the tuning process developed various indexes and partitions as needed.

Developed Data Warehouse designs, working with staging, star schemas and dimensional reporting.

Experience in dealing with different data sources ranging from flat files, Excel, Oracle and SQL Server.

Experience in design reviewing and validation of final data models.

Extensively worked on Informatica Power Center Components – Power Center Designer, Workflow Manager to create workflows and sessions, Workflow Monitor and Repository Manager.

Good knowledge of Core Java concepts: Encapsulation, Inheritance, Polymorphism, Design patterns, Overloading and Overriding methods, using Abstract classes and Interfaces.

Scheduled jobs on Autosys tool.

Quick learner, self-motivating and enthusiastic to work with new technologies. Good team player and have strong ability to work under high stress environments.

Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

Written Unix Shell scripts.

Skills and Abilities:

Databases: Oracle 10g/11g, MySQL, SQLite

Operating Systems: Microsoft Windows Servers & Clients – 2003, 2000, XP and Unix

Languages: PL/SQL, SQL, Java, Unix Shell Scripting, HTML/CSS, PHP, Jquery, Javascript, Python.

Tools: Autosys, Control M.

DB Tools: PL/SQL Developer, Toad, SQL Loader, Erwin.

Data Formats: XML, CSV.

Professional Experience

Capgemini: Consultant 2013-2014

Client: Sanofi Aventis, Paris, France.

Role: Data Modeler/ Developer.

Domain: Health Care

Sanofi is a French multinational pharmaceutical company, the world's fifth largest by prescription sales. The purpose of this project was to keep an inventory of the drugs supplied across France. The users would be allowed to generate reports from the database.

Responsibilities:

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

Full ownership: specification/implementation/testing/support.

New interfaces between Ravel and Tipsa (Databases) with other components in Supply Chain network using PLSQL packages/procedures and SQL Loader (Oracle Utility)

PLSQL codes to logically find a relation between data received by different components and providing it to the end users in their required format

Maintaining and scheduling new jobs in Autosys.

Deployments on different environments and doing pre and post deployment tests.

Daily Business Object reports to verify the data loaded in the database.

Mentoring junior engineers.

Capgemini – Consultant 2012-2013

Client: Coca Cola, Atlanta, USA.

Role: Data Modeler/Data Analyst

Domain: Retail

VMP, Vendor Management Protocol is a tool to help clients like Wal-Mart and Sam’s Club to place large orders of Coca Cola products. The Database maintained information regarding various bottlers, packing styles and code numbers.

Responsibilities:

Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks.

Responsible for data mapping, metadata maintenance and enhancing existing Conceptual and Physical data models.

Conducted sessions with architects, business and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.

Maintained and updated Metadata repository based on the change requests.

Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.

Conducted walkthroughs with the DBA to convey the changes made to the data models.

Utilized Rational Clear Quest to track change requests throughout the process.

Implemented SQL Scripts to modify the data to resolve assigned defects.

Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.

Analyzed and synthesized the requirements gathered from multiple sources and documented the business process flow for the system.

Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, Analysis and Design.

Created Entity relationships diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.

Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfill requirement.

Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.

Developed source to target mapping documents to support ETL design.

Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated sql scripts for physical implementation.

Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.

Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.

Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.

Developed data mapping documents between Legacy, Production, and User Interface Systems.

Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.

Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Tech Mahindra: Technical Associate 2009-2012

Client: British Telecommunications, London, UK.

Role: PL/SQL Developer

Domain: Telecommunication

NRS, Network Record System is a DMP [Domain Management Platform] system. It’s a key

System for 20C Voice platform and development continues to build support for 21C Voice. The purpose of the project was to provide assignment/view of BT Network at interface of switching & transmission domains & view of network.

Responsibilities:

Involved in the entire life cycle of the project starting from requirements gathering to end of system integration.

Interacted with the client for business requirements gathering.

Identified the Entities, attributes and designed a relational database system.

Built the application according to the requirements (wrote PL/SQL functions, database triggers, created some forms and reports) and Created views and index views.

Developed the batch program in PL/SQL for the OLTP processing and used Unix Shell scripts to run in corn tab.

Interacted with DBA to discuss database design and modeling, index creations and SQL tuning issues.

Used SQL*Loader to load the database from flat files.

Converted Data stored in flat files into Oracle tables.

Qualifications

Open University courses in Computer Science at San Francisco State University, USA 2015

1) Software Development. (Android Application)

Implemented an Android application SFParkPal for finding parking spots in San Francisco. A user can view different parking spots and select one according to the timings, price and availibitly.

Features like Parking History and Reminder were also included in the app.

Used Google Maps and SF Park API to efficiently display relevant parking information to the user.

Used SQLite databases to store the user information.

Used GIT to maintain our codes.

2) Software Engineering. (Website)

Designed and developed a Website for adoption of Pets called PetPal. (http://sfsuswe.com/~s15g13/)

The website allows the user to search for a pet (dog/cat) and even put up a pet for adoption.

Used HTML/CSS, PHP, Javascript, Jquery and Bootstrap to develop the website.

Used SVN repository to maintain our codes.

Bachelor of Electronics Engineering, Mumbai University, Mumbai, India 2009

Contact this candidate