Sarika Gupta

Email: ac0flj@r.postjobfree.com

Cell: 732-***-****

Database modeler/designer/PLSQL expert with 15+ years of Oracle database modeling/designing/development and 5 years of Technical Project Management (ex-PMP) and Business Analysis experience in full life cycle of projects from inception to post-implementation.

Extensive international exposure having worked on projects in USA (10yrs), Brussels, Luxemburg, UK, Singapore, Netherlands, Germany and South Africa.

Professional Summary:

Lead Data Modeler/Analyst/Designer/Senior PLSQL Developer

Excellent experience in RDBMS such as ORACLE

Expertise in of Entity Relational Models including conceptual, logical and physical data designs.

Worked extensively on normalization, de-normalization while addressing issues of data integrity

Played a primary Data Modeler and Designer role on several projects with proficiency in all phases of systems development life cycle, including requirements analysis, systems design, development, testing, deployment and support.

Expertise in using Erwin and Oracle Designer Data Modeling tool.

Exposure to MS SQL Server 2000

Experience in application and database tuning.

Experience with Dimensional modeling and Data Warehouse Development Methodology.

Experience in executing end-to-end data migration projects.

Extensive experience in design, development and maintenance of Oracle database objects, SQL, broad experience in PL/SQL programming, including effective use of Oracle packages, stored procedures, database triggers and tools like SQL*Plus, Data Factory and TOAD.

Comprehensive knowledge of data-warehousing and performance enhancing tools in Oracle like SQL Trace, TKPROF, Explain Plan, TRCSESS, different types of optimizer hints, indexes, table partitions and sub-partitions, materialized views, global temporary tables, autonomous transactions and bulk binds.

Experience with file loading using SQL Loader, file manipulation and emailing capabilities of Oracle using in-built packages.

Hands-on-experience in implementing ETL Extract, Transform and Load process.

Project Manager/Business Analyst

Hands-on experience in IT Project management with expertise in organizing, planning, and executing large scale Projects from vision through implementation

Strong foundation in iterative System Development Life Cycle (SDLC) methodologies, in implementing both Client-Server database applications and web applications

Expertise in identifying and analyzing the business needs of the end users, documenting functional requirements and building a project plan, that translates the functional requirements into technical tasks, and guides the development through the execution phase of the project.

Managed all kinds of projects that include end to end development Project and Maintenance Projects.

Experienced in risk management including risk assessment, prioritization and control throughout the project life cycle.

Managed, led and mentored large groups of software professionals with variety of experience and skill levels, inspiring them to work together and meet aggressive targets on-time and in-budget.

Worked closely with QA/QC teams for Process Improvement, issue management, change management, configurations management and release management.

Good SLA Management skills which have been effectively used in Maintenance Projects.

Other Skills

Highly energetic, proactive, result oriented professional possessing strong leadership, decision making, problem solving, influencing, negotiation, conflict management, issue management, communications and interpersonal skills.

Ability to handle major development assignments with minimum or no supervision.

Strong analytical skills with experience in writing functional/technical specifications.

Excellent oral and verbal communication along with stakeholder management skills.

Excellent analytical skills, the ability to integrate information from multiple sources to execute effectively and efficiently in a dynamic environment, and the ability to interact with customers independently, along with the ability to route/escalate decisions/questions to the appropriate owner.

Systems Experience:

Domain Areas

Energy, Transportation/Ticketing, Claims Management, Oil and Gas

Microsoft Operating systems/Applications:

MS Windows 2000 (Server), MS Windows 2000 (Workstation), MS Windows 2003 (Server), MS Windows Adv. Server 2000/2003, MS Windows XP

Operating System UNIX

HP-UX, Sun Solaris, AIX

Messaging

IBM MQ Series

LDAP

Oracle Internet Directory

Methodologies

SSAD, OOAD, Agile (JIRA)

Database Systems

Transact-SQL Programming, ANSI-SQL, Database Sizing, Oracle SQL Loader, Oracle V8.x,Oracle V9.x,Oracle V10.x, Oracle V11g, Oracle 12c, Oracle SQL-Programming, Oracle PL/SQL,MS SQL Server, Data Modeling, JDBC, RDBMS Design

Case Tools

Oracle Designer 2000, CA Erwin

Database Development Tools

Oracle Developer 2000 Suite, Data Factory, Toad, SQL Navigator, SQL Developer, PLSQL Developer.

Function- and Script-oriented Programming

Visual Basic(Basic), C(Basic), MS Transact-SQL Programming, ESQL, Power Builder 5.0

Database Administration

Database Administration General, Database SW Installation

Data-warehouse

Exposure to Oracle Discoverer and Oracle Warehouse builder, Informatica

Web-based Programming

Exposure to HTML, XML, XSLT, XML Schema, Web Services

Development and Runtime Systems

Bugzilla, MKS Source Integrity

Office - Applications

MS Office, MS FrontPage, MS Outlook, Acrobat, MS Excel Macros, MS Power Point, Designer / Visio

Software Analysis and Design

Function Point Analysis, Rational Rose(Basic)

Version/Configuration Management

SVN, MS Visual SourceSafe, MKS, ClearCASE, PVS Version Manager V8.2

Middleware & Application Server

ORACLE 9iAS, Tomcat, Jboss, Apache Web server

Address Standardization Tool Trillium

Defect management HP Application Lifecycle Management (HP ALM)

Professional Experience:

NRG Energy – USA Jun 2014 to Till Date

Senior Oracle Database Consultant

RAMP (Retail Campaign management platform): This project creates a framework that delivers consistency across different processes and business units in NRG’s campaign process. I designed, modeled and developed one of the core processes that create different tiers based on user defined configuration. The tiers are a collection of common attributes that defines a type of customer, based on which different offers and products are offered to these customers.

NRG SVT: Involved in generation of data repository for customer related data which can be used for reporting or as a source for other applications. SAP applications are the primary source of data. This system is used for Customer retention reporting, Ad Hoc reporting for operational issues etc.

NEWS(North East Warehouse System): This system was built for enrollment, billing, invoicing, price change, renewal, drop, and re-instatement of the Dominion portfolio of customers acquired by NRG in early 2014. I worked on correspondence module which based on customer transaction, sends out correspondences to them.

Implemented Oracle table partitions and sub-partitions, materialized views, global temporary tables, autonomous transactions, pre-process external tables, collections and bulk binds

Performing data modeling, logical and physical database design based on modeling tools available on the project, and business functions of the system.

Write detailed technical and functional specification documents.

Designing, developing, testing, and support of PL/SQL packages, stored procedures, functions, pipelined functions, bulk operations, objects and other database objects to solve complex business problems.

Involved in performance tuning of any stored procedure, function, view, or query by utilizing all means necessary (indexes, partitioning, database hints, etc).

Always proactive in thinking of ways to improve performance on the database as well as the design of the system

Involved in complete life cycle of the project starting from gathering of system requirements, designing, modeling, development, performance tuning, testing and finally user acceptance.

Involved in Prioritizing requirements, specifying timelines, reporting and interacting with clients and end users.

Worked on all the assignments with no supervision

Have always thought, worked and contributed beyond defined responsibilities.

Environment: Oracle 11.2/12c, PLSQL, CA Erwin and Unix shell scripting, Toad, SQL Developer, Data Modeler, JIRA, HP ALM

Nabors Inc, USA Feb 2014 – June 2014

Lead Oracle Consultant

Gathering the functional requirements from users and converting them into Technical requirements

Working with product managers to give work estimates and advise on design.

Troubleshooting fixing and implementation of bug fixes and enhancements within tight deadlines.

Designing logical and physical data model using Erwin

Designed, developed, tested, and supported PL/SQL packages, stored procedures, functions, pipelined functions, bulk operations, objects, collections and other database objects to solve complex business problems.

Involved in performance tuning of any stored procedure, function, view, or query by utilizing all means necessary (indexes, partitioning, database hints, etc).

Developed, tested, and implemented Row-Level Security (VPD) in Oracle database

Environment: PL/SQL; SQL; SQL*Plus; Oracle 10g and Oracle 11g; Windows 7 Enterprise; TOAD; PVCS Version Manager, Agile Methodology, Microsoft TFS Version 12.0.x

Reliant Energy – USA Oct 2009 to Jan 2014

Senior Oracle Database Consultant

Worked on multitude of projects for Retail Energy both business and residential customers.

Involved in re-engineering the existing systems, migrating the legacy data, data mapping, data integration with different vendors, address standardization using Trillium and standardization of data, generation of waterfall reports and statistics.

Performed data modeling, logical and physical database design based on modeling tools available on the project, and business functions of the system.

Wrote detailed technical and functional specification documents.

Designed, developed, tested, and supported PL/SQL packages, stored procedures, functions, pipelined functions, bulk operations, objects and other database objects to solve complex business problems.

Performed Reverse Engineering of the legacy application using DDL scripts in Erwin

Utilized SQL*Loader to load flat files database tables.

Designed and implemented complex shell scripts using Korn shell.

Involved in performance tuning of any stored procedure, function, view, or query by utilizing all means necessary (indexes, partitioning, database hints, etc).

Troubleshooting performance issues: performance monitoring, fine tuning stored procedures and SQL and application performance optimization.

Involved in complete life cycle of the project starting from gathering of system requirements, designing, modeling, development, performance tuning, testing and finally user acceptance.

Environment: MS Oracle 10.x/11, PLSQL, CA Erwin and Unix shell scripting, Toad, PLSQL Developer

CEVA Logistics – USA April 2008 to Sept 2009

Data Designer/Modeler/DBA/Lead Database Developer

The company has data flowing from diverse systems which have their own sources of data. The main problem is standarization of the data for the company. I was part of this group that was involved in making a central repository of standarization.

Involved in defining and managing enterprise-wide data semantics

Involved in transforming inconsistent data into one common product representation

Troubleshooting performance issues: performance monitoring, fine tuning stored procedures and SQL and application performance optimization.

Performed data modeling, logical and physical database design based on modeling tools available on the project, and business functions of the system.

Single Handedly scripted the migration of voluminous data from current production to new re-engineered database

Involved in defining and developing the ETL process flow from the OLTP to the reporting database using SQL*Loader, External tables, pipelined table functions and partitioning.

Involved in data profiling of the legacy and the re-engineered database.

Environment: MS Project, MS-Excel, MS Visio, JCAPS, Oracle 9.x, Oracle 10.x, CA Erwin, Informatica 8.1

SIEMENS (CMM-5 & CMMi) Sept 1998 to Feb 2008

Project Manager/Lead Data Modeler/ETL Designer/Analyst/

Clients

European Union – Brussels, Luxembourg

Department of Labor, South Africa

Department of Work and Pension, UK

Medscheme, South Africa

Office of National Statistics, UK

Netherland Railways, Holland

Verkehrsverbund Rhein-Sieg (VRS) – Germany

Siemens VT27 - Switzerland

Project Manager

Managed/Lead a team spanning from 4 to 20 people, placed both offshore and onsite.

Estimating projects using Function point or Use Case estimation models

Creating the Project Plan in MS Project and tracking the project till its closure

Resource planning after scope finalization after consultation with the stake holders

Active management of Onsite-offshore communications

Served as a liaison between the business users and the technical team

Monitoring and reporting the performance of the project

Tracking and controlling the project activities against the established project metrics to make sure all the project activities are in synch with the plan.

Interacting and managing communications with the Business owners, Team members and other stakeholders of the project.

Calculating the Risk in the project and planning mitigation strategies.

SLA Management in the maintenance projects.

Scope Management for the project dealing with change requests.

Providing Quality Assurance to the Business users by closely working with the testing team during the QA process.

Management of development and support activities in parallel by effective resource allocation.

Configuration Management of the various releases of the code using Rational Clear case.

Environment: MS Project, Rational Clear case, MS-Excel, MS Visio, J2EE, Oracle, SQL Server, Weblogic, Oracle 9iAS, JBoss, Apache, Microsoft Visual Source Safe

Lead Data Modeler/Designer/Analyst

Contributed to the overall software development lifecycle including requirements gathering/analysis, design, information modeling techniques and methodologies, development technologies, release/version control, testing, and deployment.

Developed the Enterprise Data Model for Department of Labor and extending it through all of its projects as needed

Performed data modeling, logical and physical database design based on modeling tools available on the project, and business functions of the system.

Utilized several different industry standard case tools such as Oracle Designer and Erwin.

Involved in database design for both online transaction 3rd normal form and dimensional models, Data Warehousing, Data Migration, Data Staging, Applications Design and Business Process Re-engineering.

Used function based indexes to implement selective uniqueness.

Used Normalization as well as De-normalization techniques to process the records depending on the data record structure of the source and target tables.

Performed Reverse Engineering of the legacy application using DDL scripts in Oracle Designer

Maintained versions of Oracle Designer objects by using Oracle Software Configuration Manager (SCM)

Troubleshooting performance issues: performance monitoring, fine tuning stored procedures and SQL and application performance optimization.

Performed tuning and optimization on SQL queries using SQL_TRACE, Analyze, Explain Plan, TKPROF, runstats, TRCSESS utility and optimizer hints.

Development of backend and front end components using Pro*C, Oracle Developer Suite, Oracle Portal, Oracle Internet Directory

Designed and developed complex interfaces with external systems using Oracle PL/SQL

Developed Oracle external procedures that called routines written in C language to carry out file operations like copy, purge and rename a file.

Designed and developed the complex back end claim processing module using Oracle PL/SQL advanced features like table functions, ref cursors, bulk processing, packages etc.

Prepared test plans and test data and performed unit testing as well as integration testing of the system with full load

Environment: Oracle Database - 8.x/9.x/10.x, Oracle Designer, CA Erwin, Case Studio 2, Quest Toad, Quest Data Factory, Oracle 9i Developer Suite, Oracle 9iAs, Oracle Internet Directory, Oracle Portal

Data warehouse/ETL Designer

Participating in the development of Data Warehouse, star schema dimensional models.

Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.

Conducted Design discussions and meetings to come out with the appropriate Data Mart

Developed detailed ETL Plan for loading the staging area from the Oracle database and then from Staging area to the Data Mart.

Participated in developing and implementing Data Staging/ETL strategies to migrate data from legacy data stores. Such strategies included the analysis and documentation of data quality issues and the development of extraction and transformation techniques.

ETL plan included populating the dimension and fact tables, sequencing the loads to maintain referential integrity and data cleansing.

As an ETL Architect, designed the ETL process for data validation, transformation and data flow into the data warehouse

Prepared the technical design document for the complete ETL process and provided the same to the development team to work on.

Identified and included the reusable components in the ETL design and devised the standards and naming conventions

Created and used Stored Procedures in the mappings for dropping and re-creating indexes on the target tables while inserting records and for truncating staging tables.

Involved in implementing the ETL process using PL/SQL and participated in discussions on the data requirements for business

Used oracle analytical functions to compute running totals, cumulative totals, TOP N queries.

Environment: Oracle Database - 9.x, Oracle Designer, CA Erwin, Oracle Warehouse Builder and Oracle

NIIT LTD (CMM-5) Nov’1995 to Sept 1998

Oracle Data Modeler and Lead Oracle Programmer

Clients

Sony System Design International (SSDI) – Singapore

Ministry of Defense-Singapore

PROFESSIONAL QUALIFICATIONS

Bachelor of Sciences (Honors), Delhi University

Post Graduate Diploma in Computer Applications, Delhi

Ex-Certified PMP from PMI, USA (Expired in 2012)

TRAININGS

PERT/CPM Concepts

MS Project 2000

Project Management Training

Software Architecture Using UML

CMM-I

Fundamentals of RUP

Java/J2EE

Executive Development Program

Visual Basic 6.0

Power Builder 6.0

SSAD and OOAD

Contact this candidate