SUMMARY

** ***** ** ********** ** Information Management, developing end-to-end Data Warehousing Applications, Business Intelligence, Data Integration & Migration Systems. 9 years of experience as an OBIEE Architect providing BI solutions to reputed clients.

Good Experience in designing and implementing a Data Warehouse System.

Good experience in Business Analysis, preparing functional and technical design documents and Data Modeling using Designer 2000, Erwin and Rational Rose.

Experienced in ETL process and OBIEE reports.

Good experience in Developing PL/SQL programs, Performance Tuning, Monitoring and Supporting Production environments.

Specialized in Database Concepts and Oracle Products. (Oracle 7.x, 8i, 9i, 10g, 11g and 12c Architecture)

Extensive experience in performing Oracle Database Administration activities.

Extensive experience dealing with Order Entry, Manufacturing, Enterprise Asset Management, Insurance, Financial systems and Data Migration Projects.

Very strong in developing Unix shell scripts using AWK and SED for data handling and writing batch programs.

TECHNICAL SKILLS

Database : ORACLE (11g, 10g, 9i, 8i, 7.x, 6.x) - SQL *PLUS, PL/SQL (8.x, 2.x), SQLJ, C, PRO *C (ver. 2.x, 1.x), Oracle Applications 10.7/R12, DB2, Teradata

Database Utilities : SQL *Loader, SQL *Net (version 8, 2.x, 1.x), Export/Import, DbDebugger, Toad, Sql Navigator, Oracle Discoverer, Server Manager, SQL *DBA, Sql Tuning using Sql Trace, Hints, TKPROF and Explain Plan.

DWH Tools : Informatica v4.5 to 9.x, Datastage 7.x/8.x, Hyperion MDM 9.x, Talend MDM 5.x, Informatica MDM, OWB 9g/10g/11g, SSIS

BI Tools : OBIEE 10g/11g, Microstrategy 9.x, Cognos 7.x/8.x, SSRS

Operating Systems : UNIX (Solaris, Sun OS, SCO Open Server, AT&T, AIX)

WINDOWS Server 2008 / 2012 and WINDOWS 7 /8.1

Languages : C, C++, Java, MF COBOL, Perl

Front End Tools : Developer 2000(Forms 5.0, 4.5, Reports (3.0, 2.5)

Networking : TCP/IP, ODBC, JDBC, TELNET, and FTP

Scripts : Unix Shell (Bourne, Korn) – Shell scripts using AWK and

SED

Web Platform : Oracle Web Server, HTML, XML, Java Servlets, EJB,

JSP, ASP, .NET, JDBC, Wiki, Share Point

Data modeling Tools : ER-win, Silverun, Designer 2000

Test Tools : Silk, Load Runner, Win Runner, Data Quality Centre

Version Control Tools : MKS, PVCS, Clear case, Serena ChangeMan Dimensions.

EDUCATION & CERTIFICATIONS

Bachelor of Engineering (Electronics & Communication Engg)

from Institute of Engineers (India), Calcutta in 1990

Trained in IBM Mainframes, IBM Clear Case (Version Control), BPM

Certified in Oracle SQL & PL/SQL Programming

Certified in Informatica MDM

PROFESSIONAL EXPERIENCE

Richmond Entrepreneurs Assistance Program (Data Architect) / Virginia– (Jun 2016 – Current)

Created Data Models and Data Design/Architecture documents.

Development of PLSQL programs to implement ETLs onto a centralized Datawarehouse.

Maintenance and support for all databases in the organization’s network.

Analyzed data to provide key insight on performance of each customer by creating ad-hoc reports.

Configuration and support for conducting online transactions through different web platforms.

Performance tuning of the databases to improve the performance of the databases.

Implementation of debugging, backup and recovery process.

Social Security Administration (SSA) Senior Data Architect / Baltimore, MD– (Jan 2016 – May 2016)

Develop PLSQL programs/ scripts for migration of data from legacy to new reporting system.

Developed packages, produces, functions and triggers to implement the business rules.

Support the existing SSA system and also help with the phased Production moves.

Loaded Oracle E-Business Suite data into the Financial Data Warehouse for OBIEE.

Performed data validation on the E-business data loaded into the Data warehouse.

Coordinated the development of the OBIEE reporting system with different teams.

Development of ETL process in PLSQL and Informatica to move source data into target reporting systems.

Archived changes to the historical databases, Data warehouses.

Archiving of changes for Synchronization of distributed external databases.

US Patent Trademark Office (USPTO) / BI architect / Virginia– (Sep 2015 – Nov 2015)

Performed Migration of Data from legacy to New System and automated scripts to check the successful migration of data.

Creation of materialized views to synchronize data between the legacy and new systems using Golden Gate.

Testing the Golden Gate Synchronization process between the source and target system.

Development of data encryption packages using DBMS_CRYPTO utility for Encryption and Decryption of PII Data.

Performance Tuning for badly performing SQLs and PLSQLs.

Creation of Informatica ETLs to transfer feeds into APC data systems (Pair Bulk Data)

Run DDL scripts to create new objects and apply changes for existing objects in the Dev and QA databases before every Sprint.

Created Database connections and managed Database connectivity and the semantic layer for OBIEE.

Design and implementation of debugging and Audit control features

Richmond Entrepreneurs Assistance Program (Data Architect) / Virginia– (Oct 2014 – Aug 2015)

Maintenance and support for all customer’s databases used by the organization’s network.

Configuration and support for conducting online Auctions through different web platforms.

Created ETLs in Talend to move data across DWBI systems.

Designed and implemented distributed file replication systems to enhance fault tolerance capabilities.

Designed and presented system architecture design for implementation to key stake holders.

Implementation of debugging, backup and recovery process.

Manage Database connectivity across all applications.

Genworth (Data Architect) / Virginia– (May 2014 – Sep 2014)

Production Support and maintenance of the existing Financial Data Store (FDS) which stores the Policy and GL information for Genworth.

Monitoring the load process for BI Reporting and Recon Process and fixing errors as necessary.

Database administration Tasks using tools such as Enterprise Manager, SQL Loader, Data pump, Oracle Performance Monitoring.

Designed and implemented a new Enterprise-Scale Business Intelligence infrastructure.

Created enterprise system implementation design for Oracle Business Intelligence Enterprise Edition (OBIEE) version 11g for Enterprise wide application.

Installing and configuration of OBIEE for multi life cycle environments against different business entities.

Designed and implemented system monitoring techniques using Oracle Performance monitoring utilities.

Designing databases for OLTP and DW systems and defining application processes.

Development of PLSQL programs to process statistical data.

Designed and implemented backup and recovery process for different database environments.

Fine Tuning of the databases for optimal performance.

Environment: UNIX, Windows 7, Oracle Apps 11i, R12, Oracle 11g, PL SQL, SQL Loader, SQL Developer, Visio, Erwin.

Amazon Inc., - (Oracle Consultant) / Seattle, WA - (Jul 2013 – Mar 2014)

Involved in analyzing the PIR (Project Initiation Report) and preparing Technical Project Spec for 5 business intelligence projects:

Created and presented systems architect design for implementing the BI solution to key stakeholders.

PYOP(Payment only Product) for subsidiaries - new reporting request for Month end closing balance based on Subsidiaries launching Amazon Payment was designed and implemented as the first platform for Amazon Payment system.

Prepared development and QA databases for the new projects.

Creation of partition and fine tuning of the sql for good performance.

Design and implementation of backup process.

Installed and configured OBIEE and OBIA and configured Informatica ETL for OBIA.

Created Database connections and managed Database connectivity and the semantic layer for OBIEE.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, SQL Developer, Teradata OBIEE 10g, 11g, Visio, HP Unix 11, Datanet.

Cross Country Home Services, ( Data Architect ) / Sunrise, FL - (Apr 2013 - Jun 2013)

•PLSQL programs for Migration of historical data from EBS R11 to R12, Warranty and Claims.

•Created source views for implementing ETLs.

• Coordinated the analysis, design and long term build-out of complex enterprise information architectures.

• Assisted in developing system requirements, analyzes transactions and data volumes, and designs & develops complex databases and applications

• Participated in large-scale development initiatives including product selection and implementation. Researches and recommends optimal design criteria and best utilization of resources.

• Lead reviews and participated in development of quality entity relationship diagrams, data flow diagrams, database normalization schemas, logical to physical database mapping, data table parameters, etc.

•Conversion of the Historical Data to bring in R12 data for Warranty and Claims.

•Designing the report framework for creating Dashboard and BI Publisher Reports.

•Build Analytical Model for Vendor and Customer Rating using PLSQL.

•Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

•Assists with impact analysis of any changes made to the database objects.

•Troubleshoots with problems regarding the databases, applications and development tools.

Environment: UNIX, Windows 7, Oracle Apps 11i, R12, Oracle 11g, PL SQL, SQL Loader, Toad, Visio, HP Unix 11.

Osmose Holdings Inc., (Data Architect) / Buffalo, NY – (June 2012 – Mar 2013)

• Developed and maintained a backup and recovery strategy for all databases. Performs regular random drills to test disaster recovery scenarios.

• Provided daily Oracle Applications 11i / Oracle 10g DBA technical administration and support, including change management requests, monitoring, performance tuning, backup and recovery.

• Provided 11i applications / 10g database DBA implementation, support.

• Provided performance assessment and tuning as related to the operating system, the database, and disk subsystem.

•Building Operational and Analytical Dashboards for the different Manufacturing units and Service units.

•Integration of different business units into the Data warehousing system.

•Coordinating the offshore resources on new development and maintenance.

•Conversion of Oracle and Discoverer Reports to BI Publisher Reports.

•Building Reports Framework using SQLs and PLSQLs based on client’s requirements.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, Toad, Informatica,, OBIEE, Visio, HP Unix 11, Oracle Discoverer and Autosys.

Axiom Semantics (DW Consultant) / Offshore-Onsite – Oct 2011 – May 2012

•Designing and populating tables using PLSQL for OBIEE and BI Publisher Reports.

•Designing the data process flow for populating analytical schema for OBIEE Reports.

•Administration tasks, Creating and Maintaining the Metadata Repository.

•Data migration Strategies using Oracle tools and Utilities.

•Implementation of Golden Gate for data migration.

Environment: UNIX, Windows 7, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, Toad, Datastage, Informatica, Essbase, OBIEE, Visio, HP Unix 11, Oracle Discoverer, SSRS and Autosys.

State Street Corporation, Boston, MA ( Oracle Consultant ) thru’ Syntel - Mar 2010 – Sep 2011

Maintenance / Support of Financial Datawarehouse (FDW) Application:

•Maintenance and support of the Financial Data Warehouse application.

•Identify and resolve any problems relating to the application.

FDW Support:

Responsibilities:

To keep all the FDW QA environments in Sync. Create & Manage ETL process across all QA environments. Assist in testing and maintain Scheduling across all environments.

Installation and configuration of OBIEE and Spend Analytics.

Involved in Oracle 11g upgrade of FDW Database.

Create and Maintain the FDW Knowledge Repository in SharePoint.

Environment: UNIX, Windows XP, Oracle Apps 11i, Oracle 11g, PL SQL, SQL Loader, Toad, Datastage, Informatica, Essbase, OBIEE, Visio, HP Unix 11, Oracle Discoverer and Autosys.

State Street Corporation, Boston, MA (DWBI Lead Consultant) thru’ Wipro - Oct 2008 – Feb 2010

•Provide Resolutions to Problems identified by the Wipro Technologies Offshore Production Support Team supporting the CSO-IT applications namely EBS R12, FDW, Finapps, OFA, OFSA, GEER, GHR(Peoplesoft), P2P, MDM, BPM, BI Reports (Essbase, Discoverer, Oracle and Actuate) and any other new application developed by State Street.

•Resolving Problem tickets by analyzing Cube data and PL/SQL codes used in the programs.

•Maintain SOPs for all jobs created to support the CSO applications.

State Street Corporation, Boston, MA (Oracle Consultant) Direct – May 2007 – Jun 2008)

•Development and implementation of ETL processes using and PL/SQL to move data from different sources to FDW.

•Development, Deployment of requests for Downstream Reports using OBIEE.

•Production Support and Wiki Administration to maintain knowledge Repository.

State Street Corporation, Boston, MA (Oracle Consultant) thro’ Maxima Consulting Inc.,

- Jul 2006 – Apr 2007

•Analysis and Design of the different Recon Process based on the Business Specs.

•Development of the GL Recon process to validate Essbase Cubes Data against the Financial Data warehouse.

•Installation and configuration of OBIEE in multiple life cycle environments.

•Data Modeling, Database Design, Process Design of Packages relating to the process.

•Development of complex Packages and Stored Procedures using latest 10g features of bulk insert and parallel updates.

•User Acceptance Testing support for NAGL (North America GL) Project.

Environment: UNIX, Windows XP, Vista, Server 2003, Oracle 9iAs, 10g, PL SQL, SQL Loader, Toad, Report writer 10g, Datastage, Essbase, Visio, Golden Gate, Oracle Discoverer, Erwin and Hyperion MDM.

Credit Acceptance Corporation, MI (Oracle Consultant) - Apr 2005 - Jun 2006

Responsibilities:

Preparing Technical Design Documents using Visio, Data modeling of the system using Oracle Designer and resolving Maintenance / Support tickets.

Development of PL/SQL Packages, Procedures, functions and Triggers for enhancing the Data warehouse.

Development / Enhancement of Reports using SQR, Oracle Discoverer and Oracle Reports.

Performance tuning of the Data warehouse system wherever necessary.

Lead a Migration Project from 9i to 10g Oracle Warehouse Builder.

Production Support - Monitor and execute monthly and daily process runs. Solving Prod. Support tickets and maintaining the integrity of the Data warehouse System.

Environment: UNIX, Windows NT/2000, Oracle 8i, 9iAs, 10g, PL SQL, SQL Loader, Toad, Report writer 3, SQR, Visio, Oracle Warehouse Builder 10g, Oracle Discoverer and Oracle Designer.

Supplier Warranty Reporting, Ford, Dearborn, MI (Oracle Technical Lead) - Oct 2002 - Mar 2005

Developed for Ford Motor Company to track the Suppliers responsible for Warranty Claims.

Responsibilities:

Preparing Functional and Technical Design Documents using Visio and Data modeling of the system using Oracle Designer.

Development of Service to Engineering mapping process using PL/SQL Packages using Hierarchical queries, which forms the core part of the application.

Development of Java program to interface Oracle and Teradata through JDBC / ODBC.

Publishing of Supplier Performance Reports to the Suppliers using Single Sign On Web Security.

Analysis, Design and Creation of a Data warehouse system to house the data collected for reporting, using OWB.

Production Support - Monitor and execute monthly process runs / Monitor Daily runs.

Environment: UNIX, Windows 2003, Windows XP Oracle 8i, 9iAs, 10g, PL SQL, SQL Loader, Toad, Forms 6.0, Report writer 3, Java, JDBC, Visio and Oracle Designer, Oracle Warehouse Builder.

Contact this candidate