SUMMARY:

• 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. 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.
• 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.
• 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.

TECHNICAL SKILLS:

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 Scriptoriented Programming: Visual Basic(Basic), C(Basic), MS Transact-SQL Programming, ESQL, Power Builder 5.0

Database Administration: Database Administration General, Database SW Installation

Datawarehouse: Exposure to Oracle Discoverer and Oracle Warehouse builder, Informatica

Webbased 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:

Confidential

Senior Oracle Database Consultant

Responsibilities:

• 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

Confidential

Lead Oracle Consultant

Responsibilities:

• 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

Confidential

Senior Oracle Database Consultant

Responsibilities:

• 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

Confidential

Data Designer/Modeler/DBA/Lead Database Developer

Responsibilities:

• 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

Confidential

Project Manager/Lead Data Modeler/ETL Designer/Analyst

Responsibilities:

• 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

Confidential

Lead Data Modeler/Designer/Analyst

Responsibilities:

• 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

Confidential

Data warehouse/ETL Designer

Responsibilities:

• 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