Sql Server Project Management

Pravin Kumar

Phone:+1-858-***-****

Email: *************@*****.***

Database modeler/designer/PLSQL expert with 14+ years of Oracle/PostgreSQL/SQL Server/Amazon Aurora database modeling/designing/development on premise or on cloud including 5+ years of Technical Project Management and Business Analysis experience in full life cycle of projects from inception to post-implementation.

Extensive international exposure having worked on projects in USA (5 years), Germany, Canada.

Professional Summary:

Lead Data Modeler/Analyst/Designer/Senior PLSQL Developer

Excellent experience in RDBMS such as ORACLE/PostgreSQL/SQL Server

Working on Database Migration Project from Oracle to Open Source PostgreSQL/Amazon Arora

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 2007,2016

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 as well as Agile Methodology, 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.

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

Other Skills

Highly energetic, proactive, result oriented professional possessing strong leadership, decision making, problem solving, 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

POS, Telecom, Supply Chain and Insurance

Microsoft Operating systems/Applications:

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

Operating System UNIX

HP-UX, Sun Solaris, AIX

LDAP

Oracle Internet Directory

Methodologies

SSAD, OOAD, Agile (JIRA)

Database Systems

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

Case Tools

Oracle Designer 2000, CA Erwin, Sybase Power Designer

Database Development Tools

Toad, SQL Developer, PLSQL Developer.

Function- and Script-oriented Programming

Visual Basic(Basic), C(Basic), MS Transact-SQL Programming

Database Administration

Database Administration General, Database SW Installation

Web-based Programming

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

Office - Applications

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

Software Analysis and Design

UML

Version/Configuration Management

SVN, MS TFS, PVS Version Manager V8.2

Middleware & Application Server

ORACLE 9iAS, Tomcat, Jboss, Apache Web server

Professional Experience:

Infogain Corporation – USA Apr 2015 to Till Date

Team Lead

Working on migrating databases from Oracle to PostgreSQL/Amazon Aurora to minimize the cost and implementing on cloud. Working as Project Manager to manage the whole migration process including choosing tools (ORA2PG, AWS SCT etc.) to minimize the migration cost.

Working for Client Mitchell International as senior Database Consultant for their various products developed for various Insurance Companies to support their claim processing as well as guiding them in estimation and total loss. Mitchell has many products used by many customers related to estimation, repair, and claim processing along with integration with Guidewire Claim Management System.

Involved in designing Data Migration/Flow to Elastic Search

Involved in Data Statistics and Data Collection for Machine Learning Model Creation

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.

Support the code from development to deployment to production support

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, Java, .Net, TFS

Infogain India Pvt. Ltd India May 2012 – April 2015

Assistant Consultant

Worked on various Insurance products i.e. Total Loss, User Management, Repair Center, and Compliance for different clients.

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; Java, .Net, JBOSS, Agile Methodology, Microsoft TFS Version 12.0.x

Tech Mahindra Ltd – India Apr 2010 to Mar 2012

Senior Technical Associate

Worked on multitude of projects for Telecom Product Rating, Billing & customer care for T-Mobile Germany.

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 Sybase Power Designer

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,Sybase Power Sesigner and Unix shell scripting, Toad, PLSQL Developer

Eclipse Systems Pvt. Ltd. – India May 2006 to April 2010

Data Designer/Modeler/DBA/Lead Database Developer

The company has developed a product Warehouse Management System for Client Maidenform Inc. USA. The product is responsible for receiving the items to warehouse to shipping to customer based on orders. It involves restocking, picking, boxing and location mapping to guide picker to pick an item. Product was fully automatic and supporting scanner and mobile scanners.

Responsible in defining and managing all DB related design, development and support.

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.

Responsible for discussing requirement with client and design the High Level Design

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

Environment: MS Project, MS-Excel, MS Visio, Oracle 9.x, Oracle 10.x, VC++, .Net

Divergent Technologies Dec 2004 to May 2006

Software Engineer

Divergent Technologies was Product based company mainly has developed for telecom companies. I was part of development and support for a product Point of Sale (POS), which implemented at 50 locations. This product developed using Visual Basic 6.0 and Ms Access and SQL Server 7.0

Development of application (front end) built using VB 6.0.

SQL Server database programming, development of program Units for the business logic of application.

Responsible for handling customer complaints and fixing codes issues

Environment: Sql Server 7.0, Visual Basic 6.0, Ms Access

PROFESSIONAL QUALIFICATIONS

Master’s Degree in Computer Application (MCA), IGNOU Delhi

Bachelor’s Degree in Computer Application (BCA), IGNOU Delhi

Oracle Certified Professional (OCP), Oracle University

Contact this candidate