PROFILE

• Senior Data Architect with over 14 years of professional IT experience specializing in data modeling, data migration, integration, extraction, loading, maintaining decision support and reporting systems, database design, administration and development of complex databases for multi-tiered web applications and systems.
• Over 8 years of experience working with Federal and State environments in Georgia, Alabama and Mississippi.
• Experience managing team of application developers, devising technical solutions and monitoring application development, data conversion, testing and deployment.
• Extensive experience in data modeling creating multiple logical entity relational, dimensional and physical data models. BI configuration, metadata development and designing reports using OBIEE and Oracle Answers.
• Data integration and migration specialist with over 5 years of extensive experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases.
• Strong experience as Application DBA designing, building and managing various scalable databases.
• Experience in requirement gathering, data analysis, database engineering and configuration management.
• Strong knowledge of OEM, RAC, ASM, Data warehousing, BI, OBIEE, Oracle Answers, Business Objects, Informatica, database security and auditing, Oracle PL/SQL, SQL and shell scripting.
• Strong exposure to providing data architecture support, physical database design, replication and data integration.
• Ability to analyze, evaluate and recommend new tools and technologies to management to enhance the business components.
• Self-motivated team player with great problem solving, presentation and analytical skills.

SKILLS

Databases Oracle 8i/9i/10g/11g, DB2, SQL Server, MS Access
ETL OBIEE 10.x, Informatica, Business Objects
Data Warehousing Requirements definition, ETL design, ETL development
Data Modeling Erwin, TOAD Data Modeler, Oracle Designer, Relational and Dimensional Modeling
Web TechnologiesWeb Services, Oracle Application Server, XML, HTML, Java, JDBC, PL/SQL Web toolkit
Operating Systems Windows, UNIX
Others Oracle database security SOX, Database vault, ASM, Flashback, Streams
Utilities Oracle Data pump, Export, Import, RMAN, SQL*Loader
Scripting Languages Oracle PL/SQL C, Oracle pre*compiler, Pro*C, JavaScript, UNIX Shell Scripting
SQL Tools SQL Developer, TOAD
Tools Oracle Enterprise Manager, Grid Control, SQL*Plus, Oracle Warehouse Builder, Visio, Job Scheduler (Autosys), Source Control (CVS/VSS), MS Office, MS Excel, MS Project, MS Access, Power point, Lotus Notes
Industry Telecom Data Billing, Retail Banking, Water Quality Monitoring and Management Information Systems including Finance, Payroll and Human Resources

PROJECTS

Project: Historical Rivers and Streams Data Migration Feb 2010 –Till Date
Client: Confidential,Montgomery, AL - Consultant

• Worked with program managers and business users to capture and analyze business requirements.
• Conducted gap analysis and developed data migration and integration plans for conversion of Historical Rivers and Streams water quality data from 1988 into a centralized Oracle Surface water monitoring repository.
• Provided technical leadership in conceptual and logical data modeling, data definition, mappings and data management.
• Integration of data systems and define what data flows across the repository.
• Pre-Migration testing and validation of all data elements been converted.

Project: enSPIRE Jun 2009 – Feb 2010
Client: Confidential,Jackson, MS - Consultant

• Participated in detailed sessions with technical and business stakeholders to determine data and interoperability requirements.
• Identified and analyzed the various gaps in the primary data collection and management database system for water quality data, developed for Alabama, and customized the database to support the sample collections and analysis model followed by MDEQ.
• Generation of Data Assessment statistical scorecards based on complex data requirements and Federal compliance regulations using OBIEE and Oracle Answers.
• Organization and management of water quality information to support multiple states.
• Developed conceptual and logical representations of data and physical data models.
• Managed multiple databases accessed via web applications through browsers and handheld tablet PCs.
• Maintenance of various infrastructure and application databases using OEM and monitoring of databases to support the application development, system testing and UAT.

Project: Parolee Case Management System Conversion Jun 2006 – June 2009
Client: Confidential,Atlanta, GA - Consultant

• Formulated a comprehensive data migration plan with different conversion strategies, detailed object and field mappings including its transformations and business rules for converting legacy parolee data from Lotus Notes into Oracle.
• Database design of the Parolee Case Management System oracle database with over 250 tables.
• Developed multiple logical and physical data models for the parolee database and the staging environments to support migration.
• Implementation of database security procedures, maintenance of Oracle databases using OEM, ASM configuration and movement of data across databases using data pump export/import utilities.
• Led the design and development of complex data conversion routines and data cleaning techniques for converting and migrating Lotus notes data into the new oracle database using various packages, stored procedures and functions.
• Performed initial data migration, subsequent delta migrations and validated the data been converted.
• Devised the archiving and audit processes for critical tables.
• Developed system wide database standards, guidelines and naming conventions.
• Provided training and turnover to PAP Staff.

Project: Surface Water Quality Database Data Migration Oct 2005 - Jun 2006
Client: Confidential,Montgomery, AL - Consultant
Roles and Responsibilities:

• Partnered with business users to understand and document business processes, reporting requirements and designed enterprise data warehouse solutions. Developed a detailed work flow and proposed solutions to facilitate the data conversion of the Water Quality monitoring database.
• Analyzed the requirements and framed the business logic for the ETL process. Identified and designed process flows to transform data and populate the target databases.
• Led the data conversion effort.
• Extracted data from different data sources - Oracle, Access databases and Excel spreadsheets, transformed and mapped non-standard data to standard codes for data integrity and loaded the target Oracle warehouse database.
• Scheduled and monitored nightly batch jobs using UNIX shell scripts.

Project: STORET Data Conversion Oct 2004 - Sep 2005
Client: Confidential,Atlanta, GA - Consultant

• Installed and configured the latest Federal EPA’s STORET database and SIM application.
• Defined a plan to convert 30 years legacy water samples data and migrate into Central data warehouse.
• Performed Data integrity, validation and testing on the data migrated into the data warehouse.

Project: Laboratory Certification Jan 2004 - Oct 2004
Client: Confidential,Atlanta, GA - Consultant
Roles and Responsibilities:

• Solely responsible for gathering the business requirements for the Laboratory Certification project.
• Migration of existing data attributes from MS Access into Oracle.

Project: Central Data Repository Aug 2003 - Jan 2004
Client: Confidential,Atlanta, GA - Consultant
Roles and Responsibilities:

• Involved in the feasibility study and thorough analysis of the proposed Central data repository for state of Georgia to make data from various sources such as the databases of drinking water, surface water, air and radiation programs available in one central location.
• Involved in extensive and exhaustive documentation of the Repository analysis phase including the data manager’s interviews, source database analysis, repository design, XML schema and database size estimates.
• Calling and publishing database web services from Oracle 9i database.

Projects: SDWIS EDI and Regional Reports Jul 2002 - Aug 2003
Client: Confidential,Atlanta, GA - Consultant

• Solely responsible for delivering the design specifications for the multiple projects at DNR based on complex business requirements and several data gathering and review sessions with the DNR business experts and management.
• Formulated solution based upon business and design requirements.
• Developed desired process flows and designed database schema using Erwin.

Project: Contract Fees System Sep 2001– Jul 2002
Client: Confidential,State of Georgia , Atlanta, GA - Consultant

• Designed and developed several data capture screens to gather the water system, contract, contact, and penalty information in the client server environment using Oracle Forms Crystal Reports.
• Designed and Model the contract fees system database using Erwin.

Project: VISTA Re-engineering Aug 2001 – Sep 2001
Client: Confidential,Hartford, CT - Consultant

• Involved in a detailed code analysis of VISTA, a real time Mutual funds application, developed in Oracle Developer 2000.
• Identified major performance problems in the existing Oracle Forms 6i application, recommended changes and documented the potential gains in migrating from client-server architecture to thin-client forms server architecture.

Project: ORION Feb 1999 – Aug 2001
Client: Confidential,San Jose, CA - Systems Analyst
Concert is a joint venture of AT&T and BT. Data billing is capable of processing and distribution of billing information coming from products & services for Concert’s distributors, inter-company billing and settlements.

• Involved in design and development of Packet Service traffic validation and Service Items extract subsystems of ORION, an Order Entry & Provisioning system for customer service and infrastructure.
• Identified, analyzed and reviewed user requirements. Designed logical/physical system flows.
• Produced High and Low level design documents for five consecutive releases with an emphasis on data modeling, process design and impact analysis on current systems. Conducted design reviews.

Project: Total Concept Banking System (TC/4) Jun 1995 – Jan 1999

Confidential,India - Technical Lead

BRI Inc, USA developed the Total Concept financial application system to computerize the retail banking operations of domestic and international banks.

• Led a team of six people developing and deploying TC/4 subsystems.
• Involved in Development, Testing and Integration of all the online transactions and batch jobs for Deposits, Penalties and Fixed Term Interest Rates sub systems using Oracle PL/SQL and Pro*COBOL and database design using CASE tools.
• Preparation of test plans, module and integration testing.

Project: Management Information Systems (MIS) May 1993 – Jun 1995
Confidential,India - Oracle Developer

• Worked on the initial design, development, integration, implementation and support of the financial system including Customer billing, Staff Reimbursements, Vendor payments, General finance and Operational Reports and Analysis (OPERA) sub systems in a distributed database environment. Implementation of HR and Payroll systems.
• Provided support to the online MIS system, database administration at all the regions and coordinated the month and year-end processing.

EDUCATION
Bachelors in Electronics and Communication Engineering

PROFESSIONAL TRAININGS

• Oracle Business Intelligence Enterprise Edition (OBIEE) Development & Admin
• Informatica Powercenter
• Business Objects