BIBHUTI MISHRA

Email - acpapk@r.postjobfree.com M- 703-***-****

. Experience in Design, Analysis, Testing, Data Modelling, Data

Extraction, Data Migration and Administration.

. Involved in development, enhancement, implementation, maintenance and

support of applications developed under ORACLE (11g/10g/9i/8i/8.0).

. Experience in Data Modeling (Entity Relationship), Schema Design using

ERWIN.

. Experience in Data Warehousing (Star Schema), ETL and Business

Intelligence using Ab Initio (GDE and Co>Operating System), Crystal

Reports, Oracle, Developer 2000/ 6i, SQL Server 2000.

. Excellent project management, scoping, development life cycle and

implementation experience

. Strong experience in Database Development, Administration, Enhancement

and Implementation. Strong in Database Design and Development of

Relational Schemas databases.

. Experience in Data Warehousing (Star Schema), ETL Development, and

Business Intelligence using Ab Initio (GDE and Co>Operating System),

Crystal Reports, Oracle, Developer 2000/ 6i, SQL Server 2000, IIS,

ASP.NET, VB.NET, ADO.NET.

. Maintained the logical and physical organization of the database, like

organization of database into different table spaces.

. Experience in implementing different options in Oracle like Parallel

Query, Partitioning etc.

. Experience with handling very large data files using export & import

and SQL*Loader.

. Experience in using OEM, TOAD, SQL Navigator, SQL Developer, Oracle

APEX etc.

. Expertise in writing/ debugging of Stored Procedures and Database

Triggers.

. Experience in SOLARIS/ LINUX/ HP UX & Shell Programming, crontab. Used

vi editor.

. Exposure to high-level design and building efficient databases.

Interacted directly with developers and end clients for translating,

customizing and enhancing application for achieving maximum database

throughput.

. Strong Analytical, Organizational, Inter-personal and Communication

Skills.

. Qualified Lead Assessor in ISO 9000:2000 Quality Management System,

. Good Domain Knowledge on Inventory Management and other Manufacturing

concepts, Quality Audit, Statistical Quality Control, CMM, Continuous

Improvement Methodology.

TECHNICAL SKILLS:

RDBMS: Oracle 10g/ 9i/ 8i/ 7.3, my SQL, SQL Server

2000, Sybase 12, Foxpro, Foxplus2.1.2,

MS-Access

ORACLE OEM, Data Guard, Oracle Streams, RMAN, SQL*NET,

UTILITIES/TOOLS: IMPORT/ EXPORT, SQL*Loader, tkprof, Toad, SQL

navigator, SQL Developer,, Oracle APEX

DESIGN TOOL: Erwin 3.5.2/ 4.0, MS Visio2003, MS Project2003

ETL Tools: Ab Initio (GDE 1.13.1/1.11.15 Co>Operating

System 2.13/2.11.8)

Development Tool Developer 6i/ 2000, IIS, ASP.NET, VB.NET,

ADO.NET, TIBCO, Documentum

BI Tools: Crystal Reports 8.0/8.5/9.0/10.0, Discoverer

OPERATING SYSTEMS: Solaris 2.x, LINUX, IBM AIX 5.3/ 4.3, UNIX

SVR4, Windows NT 2003/ 2000/ 4.0

LANGUAGE: SQL Plus, PL/SQL, T-SQL, UNIX Shell Scripts

AIX Servers, Sun Enterprise Series Servers, HP

HARDWARE: Servers, Compaq Servers, DEC Alpha, NEC-S1000

EDUCATIONAL QUALIFICATIONS & TRAINING:

. Post Graduate Diploma in Industrial Engineering

. B.S. (Electrical Engineering)

Training

. Attended Oracle Certified Professional Database Administrator

Course

. Production Management Information System, Conducted by Association

of Overseas Technical Scholarship at Tokyo, Japan.

. IT Outsourcing Strategies at Taipei conducted by China Productivity

Center, Taipei

PROFESSIONAL EXPERIENCE:

SEI, Oaks, PA Jul 2013 till date

Oracle ETL Developer cum Data Architect

Responsibilities:

. Worked in Global Wealth Platform.

. Worked on both SEI Desktop and Advisor Desktop modules

. Worked as Data Architect, Database Development and Database Admin

support to the Development and QA groups.

. Created and modified ETL batch jobs for migrating data to DW. Used

Informatica ETL tool for ETL migration.

. Developed PL/SQL modules for both Cash and Advisory modules using

analytic functions.

. Fine Tuned procedures for the maximum efficiency in various schemas

across databases using Oracle Hints, Explain plans. Used OEM for

monitoring

. Generated and maintained Keys, Constraints and Relationships between

the tables for OLTP & OLAP instances. Used ER studio.

. Responsible for Data Validation extracted from various source systems.

. Created Detailed Design Documents for the transformations.

Environment: Oracle 11g, AIX, Windows NT 2008 Server, HTML, SQL*Plus,

PL/SQL, SQL*Loader, Toad, Informatica, ER Studio, MS SQL Server 2000, UNIX

Shell Scripts, Control M

Barclayscard, Wilmington, DE Feb 2012 till Jun 2013

Oracle ETL Developer

Responsibilities:

. Involved in the development of Card Data Warehouse in support of Data

Warehousing efforts.

. Created and modified ETL batch jobs for migrating data to CDW.

. Developed SQL Queries to fetch complex data from different tables from

different databases using database links.

. Fine Tuned procedures for the maximum efficiency in various schemas

across databases using Oracle Hints, Explain plans.

. Generated and maintained Keys, Constraints and Relationships between

the tables for OLTP & OLAP instances.

. Responsible for Data Validation extracted from various source systems.

. Created Detailed Design Documents for the transformations.

. Used Datastage ETL tool

Environment: Oracle 10g/11g, Solaris 2.8, Windows NT 2000/2003 Server,

HTML, SQL*Plus, PL/SQL, SQL*Loader, Toad, Datastage, MS SQL Server 2000,

UNIX Shell Scripts, Control M

Shire, Chesterbrook, PA Aug 2011 - Jan 2012

Oracle PL/SQL Developer

. Worked for creating various data interfaces for Siebel SalesPro

application.

. Created interfaces for sample data, state license data and group

practice data.

. Created high level and detailed design documents.

. Created source to target mappings.

. Tuning existing SQL and Stored Procedures

Environment: Windows 2003/2008 servers, Oracle 11g, OEM, SQL Scripting,

exp/ imp, SQL Loader, Toad, Informatica, UC4, Siebel Tools

Vanguard, Malvern, PA Sep 2008 - Aug 2011

Oracle PL/SQL Developer

. Worked in the 3 major software development teams i.e. VPAS, TORO and

Kanban.

. Created the full data model for TORO. It has 12 modules and app. 220

tables and 34 packages and has more than 100k lines of PL/SQL code. I

have developed app 60% of the code. Migrated data from one database

to other. Refreshed development & testing databases with production

data periodically.

. Created tools for the Purge and Archive tool for selective delete,

backup and restore of client data for development and QA teams.

VPAS Database Re-architecture Project:

. Re-engineered the VPAS Application schemas. Created Prototype for the

project. Created 2 secondary schemas i.e. client_54_sec &

common_54_sec. with selected objects. Implemented synonym switching

between primary and secondary schemas. Configured and used RMAN backup

and restore for testing. Configured OEM for the test database.

VPAS has more than 1000 tables, 500 views and app. 150 packages and

more than 1 million lines of PL/SQL code.

. Tuned SQL, PL/SQL scripts using SQL Trace and Explain Plan.

. Refreshed VPAS client data for VPAS QA & DEV databases.

. Created and Modified database triggers, packages, procedures,

functions for application development while working for Automation and

VPAS Product Teams.

. Worked on SQL tuning, code elevation and other issues.

. Used External Tables, SQL Loader, exp/ imp, datapump, SQL copy utility

for data refresh.

. Worked on the TORO project database architecture. The database is

Oracle and the UI is in JAVA. The job involves physical and logical

design, development and guidance to other developers. Interaction with

the user groups for the design. Worked on the utl_mail, utl_smtp,

dbms_scheduler, utl_file, database link, rman. Created the data model

in Erwin.

Environment: Sun Enterprise servers, x86 servers, Oracle (10.2), OEM, Unix

Shell Scripting, SQL Scripting, exp/ imp, External Tables, Datapump, Toad,

SQL Developer, RMAN, Oracle APEX

Ibasis, Burlington, MA

Oracle Devlopment DBA cum PL/SQL Developer Jul 2007 - Sep

2008

Responsibilities:

. Understanding of Functional Requirement, Create the Design Document

and Coding.

. Setting up the Oracle Streaming environment for Data Replication.

. Also used materialized views for Data Replication.

. Database administration for Development & Testing servers.

. Creation of new schemas (including Data Modelling), Refreshing old

schemas and Data Migration. Used oracle data pump (expdp / impdp).

. Granting privileges to users.

. Installation of Oracle Binaries.

. Oracle backup and recovery through RMAN utlilities.

. Used oracle flashback and OEM.

. Reverse engineered the old oracle schema.

. Used SQL Loader, External Tables, Materialized Views and DB link

Environment: Oracle 10.2, Solaris, Linux, Windows XP, SQL*Plus, PL/SQL,

SQL*Loader, SQL Developer, Shell Scripts, Remedy, Perforce, Java, C++, OEM,

Oracle Streams, Erwin, Advanced Queues

Ahold USA, Greenville, SC

Oracle Developer Nov 2006 - Jun 2007

Responsibilities:

. Interact with business users and receive Function Requirement

Documents from them. Created Detailed Design Documents including test

cases as per the requirement, Detailed Project Estimate and got it

approved from the business users.

. Created new schema for the application including DDL for of new

database objects like tables, views, sequences, functions, synonyms,

indexes, triggers, packages, stored procedures, roles and granting

privileges.

. Reverse engineered the old oracle schema with Erwin.

. Generated server side PL/SQL scripts for data manipulation and

validation.

. Produced data extraction and data loading scripts for various schema.

. Changed the old linear scripts and converted them modular scripts with

stored procedures, functions and packages. Pushed the code to

Dimension version control system.

. Refreshed Test environment with Production database image using full

database Clone.

. Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data

conversions.

. Developed SQL Queries to fetch complex data from different tables from

different databases using database links and formatted the results

into reports and kept logs.

. Worked on ordergen script used by Stop & Shop and Giant.

Environment: Oracle 9.2, AIX 5.3/ 4.3, Windows 2000/XP, HTML, SQL*Plus,

PL/SQL, SQL*Loader, SQL Navigator, Shell Scripts, Perl, Autosys, Remedy,

Perl, Dimension, VB, Developer 6i, ERWIN, OEM

Fannie Mae, Herndon, VA

Oct 2005 - Nov 2006

Oracle PL/SQL-cum-ETL Developer

Responsibilities:

. Worked in the $1.2 billion Restatement Project.

. Generated DDL for creation of new database objects like tables, views,

sequences, functions, synonyms, indexes, triggers, packages, stored

procedures, roles and granting privileges.

. Generated server side PL/SQL scripts for data manipulation and

validation and created various snapshots and materialized views.

. Produced SQL reports, data extraction and data loading scripts for

various schemas.

. Refreshed Test environment with Production database image using full

database Clone.

. Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data

conversions.

. Developed SQL Queries to fetch complex data from different tables from

different databases using database links and formatted the results

into reports and kept logs.

. Fine Tuned procedures for the maximum efficiency in various schemas

across databases using Oracle Hints, Explain plans and Trace sessions

for Cost based optimization.

. Generated and maintained Keys, Constraints and Relationships between

the tables for OLTP & OLAP instances.

. Involved in the development of Enterprise Data Warehouse using Ab

Initio in support of Data Warehousing efforts.

. Optimized critical queries to eliminate Full Table scans reduce Disk

I/O and Sorts.

. Developed Ab Initio Graphs based on business requirements.

. Responsible for Data Validation extracted from various source systems

. Developed Ab Initio XFRs to derive new fields and solve various

business requirements.

. Implemented Lookups, Joins and rollups to improve the graph's

performance

. Worked with Departition Components like Gather, Interleave in order to

departition and repartition the data from Multi File accordingly

. Implemented Data Parallelism through graphs, which deal with divided

data into segments and work on each segment simultaneously through the

Ab Initio partition components.

. Used air commands and EME Web Interface.

. Developed an scheduling application using ASP.NET, VB.NET & ADO.NET

with oracle 10.2 on solaris 2.8 at the back end.

Environment: Oracle 10g/9i, Sybase 12,Solaris 2.8, Windows NT

2000/2003 Server, Windows 2000/XP, HTML, SQL*Plus, PL/SQL, SQL*Loader,

Toad, Ab Initio Co>Operating system 2.13, GDE 1.13.4, MS SQL Server 2000,

UNIX Shell Scripts, Perl, Autosys, Remedy, IIS, ASP.NET, VB.NET, ADO.NET

Client: CS Integrated, NJ

Jan 2005 - Sep 2005

Role: Oracle Developer

Responsibilities:

. Analyzed all business functionality and developed a Star Schema model

for the OLAP Database.

. Analyzed and created Dimension and Fact Tables, for the Data Mart,

according to the Business Rules.

. Developed technical specifications for various back end modules from

Business Principles. Specifications are made according to standard

specification formats.

. Developed various Oracle sub functions like Stored Procedures,

Functions, and Packages using PL/SQL as per the Design Documents.

. Developed reports based on an Oracle views using running totals, sub

totals, grand totals and conditional formatting.

. Involved in loading data into Warehouse tables from staging area using

SQL* Loader.

. Worked with DBA in making enhancements to DB schema.

. Coordinated with DBA in creating and managing table, indexes, table

spaces, triggers, db links and privileges.

. Analyzed and designed tables based on small and large database

transactions.

. Developed back end interfaces using PL/SQL stored packages, procedures,

functions, triggers, K-Shell scripts

. Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.

. Utilized SQL*Loader to load flat files database tables.

. Utilized PL/SQL developer tool in developing all back end database

interfaces.

. Developed automated shell scripts to schedule the load of flat files on

daily, weekly and monthly basis.

. Developed an application using ASP.NET, VB.NET & ADO.NET

. Responsible for performing code reviews.

Environment: Oracle 9i, SQL Server 2000, Erwin 3.5, SQL *Loader,

SQL*Plus, C, PL/SQL, Linux and Windows 2003 Server, ASP.NET, VB.NET,

Crystal Reports, TOAD, Crystal Reports

Client: National Thermal Power Corporation, New Delhi, India

Feb 2003 - Dec 2004

Role: Programmer Analyst

Responsibilities:

. Created ERD (Entity Relationship Diagram).

. Designed and revised the data model using tools like Erwin and MS Visio

. Designing Tables, Constraints, Views, and Indexes etc. in coordination

with the application development team.

. Created stored sub programs with Dynamic SQL at both client and Server

side.

. Involved in table redesigning with implementation of Partitions Table

and Partition Indexes to make database faster and easier to maintain.

. Reverse Engineer database into Erwin repository.

. Designed and developed backend PL/SQL packages in the database layer,

stored procedures, functions and triggers.

. Created Forms & Reports using Developer 6i.

. Wrote ad-hoc SQL for data analysis.

. Tuning of stored procedures & developed business logic in database layer

using PL/SQL.

. Worked on PL/SQL Packages, Procedures, Objects, Functions and Cursors .

. Worked extensively on the on the shell scripts.

Environment: Oracle 8.1.7, PL/SQL, Erwin, SQL*Plus, SQL*Loader, SQL

Navigator, Unix Shell Scripts, Telnet, FTP, Windows 2000/XP, Solaris

Client: Assam State Electricity Board, Guwahati, India

Oct 2001 - Jan 2003

Role: Programmer Analyst

Responsibilities:

. Project management liaison with client and development team.

. Defined the user requirements, reviewing clients' business processes

. Developed and maintained consistent best practices for system

implementation and support.

. Identified the business applications technology strategy and managed

components.

. Developed Documentation for User Training, Acceptance Testing, and

System Requirements

. Involved in the Logical design of the Database.

. Installation of Oracle Software.

. Design and implemented the physical database

Installed and configured Oracle8i, application tools, Oracle client on

Windows.

. Allocated the system storage and planned for the future storage

requirements.

. Created the primary database storage structures (Tablespaces).

. Created Forms & Reports using Developer 2000.

. Created the primary objects (tables, views, clusters, and indexes) as

per the user need .

. Managing tablespaces, rollback segments, temporary segments and

indexes of the applications.

. Used Export & Import utilities for Logical Backup, creating copy

tables and for database cloning

. Defined application users working environment by creating user

profiles.

. Responsible for capacity planning, space management and user

administration.

Environment: Windows 2000 Server, Oracle 8i, Developer 2000, SQL*Plus,

PL/SQL, SQL Loader, SQL*Net

Contact this candidate