SUMMARY

• Extensive experience in enterprise Datawarehouse Design using different datawarehouse design methodologies
• Good project management skills
• Expertise in migration of SQL Server to Oracle
• Expertise in ORACLE Database Administration,Data Migration and PL/SQL development.
• Acted as Datawarehousing Architect/DBA/ETL Tech Lead/Data Migration Lead
• Professional Highlights A total of 17 yrs of experience in Application Software Development.
• Experienced in all phases of the Project Life Cycle.
• Extensive experience Scope Management,providing the estimation,Prepared estimation templates for DW/BI. Data Quality Management, Data Profiling, Data Assessment, Data Cleansing, Data Repository.

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

Sr ETL Consultant

Responsibilities:

• Analyzed the current manual process and identifying the sources
• Design ETL process from various SAP sources having very high volume of data
• Created mapping document in consultation with business
• Analyzed different strategies to get huge volumes of data from SAP
• Created Informatica mapping for integrating SAP COPA,SAP FICO
• Designed and developed error handling process to check against MDM data
• Assisted in developing MDM strategies by analyzing data sources and data acquisition process
• Created Informatica mapping for extracting data from SAP and transforming and loading to SAP and other targets.

Environment: Windows 7 Server,Toad,MS Project, Visio,Oracle 11g, VB .Net, 11g,SAP Business Objects 12.0,Informatica 9.1,Informatica PowerExchange,SQLerver 2008/2012,SAP FICO,SAP COPA

Confidential

Data Migration Lead/Sr Consultant

Responsibilities:

• Worked on Data Migration from EPS system to PRISM
• Created the Data Migration Strategy
• Created the Data Migration Requirements and Data Migration Design documents
• Designed and Developed the ETL Process
• Migrated the Contract and Requisition Modules from EPS system built by DSI systems to PRISM product
• Did the analysis of the source EPS system both by analyzing the data and the EPS front end
• Designed the schema for the Data Migration
• Installed and configured Oracle 11g on DOL server as part of the data migration requirement
• Installed and configured Oracle SOA Suite
• Involved in the design and support of Middleware integration
• Converted SQL Server to Oracle as part of creation of staging area
• Created verious reports as part of data analysis which were presented to the client for their feedback
• Created reconciliation reports for key attributes

Environment: Windows 7 Server,Toad,MS Project, Visio, SQL Developer, Oracle 11g, VB .Net,PRISM 7.2,Oracle SOA Suite 11g,SAP Business Objects 12.0,Full Convert,SQLerver 2005,DOORS, XML,XQuery, XPath, XSLT

Confidential

Data Architect

Responsibilities:

• Worked on Data Migration from legacy systems to Oracle
• Created Data Model for different applications
• Designed and implemented the database system for the new applications
• Created and maintained database schemas for different environments
• Developed Oracle stored procedures ,packages for various modules
• Tuned the performance of the system as and when required
• Involved in production support of the applications
• Analyzed auditing requirements, audit trail sizing, and retention criteria and implemented auditing to meet NIST and FIPS140 compliance standards for federal agencies.
• Managed oracle database security using available options
• Automated ETL process, server monitoring processes with Power shell scripting
• Migrated data from Tririga to Facility Management System Application
• Analyzed source and target systems and designed and developed the the ETL mapping

Environment: Windows 7 Server,Toad,MS Project, Visio, Test Director, QTP, OEM, SQL Developer, PL/SQL Developer,Cold Fusion 7,Oracle 10g/11g, JAVA JDK 1.5.0,Erwin,Tririga,SSIS,SSRS, XML,XQuery, XPath, XSLT,

Informatica Power Center 8.1

Confidential

Senior ETL Developer

Responsibilities:

• Designed and developed an interface between Capital Markets Data Store and Capital Markets BI
• Worked with with multi-terabyte data sets
• Designed,implemented,automated,and managed configuration management processes and associated documentation.
• Provided guidance on quality issue resolutions and production issues

Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, Sybase 12.5,Oracle 9i/10g, Windows NT/2000, Sun Solaris, Toad, Netezza,Unix Shell Scripts, Autosys, MS Project, Visio,Microstrategy, Test Director, QTP, OEM

Confidential

Data Architect

Responsibilities:

• Created logical data models and translate into physical database structures that integrate with existing or proposed database structures for OLTP
• Cleaned and maintained the database by removing and deleting old data.
• Worked independently to examine processes, data, and the environment to suggest solutions.
• Worked with IT Analysts to reflect complete set of data entities.
• Created and maintained database schemas for different environments
• Involved in the Data Migration from Legacy to OIS
• Created and maintained Data Dictionary
• Addressed data problems using conceptual, logical, and physical data models.
• Offered supervision on data management, migration
• Created Dimensional Model for Reporting
• Created OLAP Cubes

Environment:Oracle 10g, Windows NT/2000, Sun Solaris, Toad, Unix Shell Scripts, MS Project, Visio, Erwin, Test Director, QTP, OEM, SQL Developer, PL/SQL Developer, SQL, JAVA JDK 1.5.0

Confidential

Database Architect

Responsibilities:

• Created and modified batch jobs for Debt Termination,SSA Verification ,NDNH.
• Planned , developed and implemented SQL Server to Oracle migration.
• Developed Oracle stored procedures for various modules.
• Designed , developed, and implemented Data migration to different environments.
• Analyzed source and target systems and designed and developed the to ETL process.
• Tuned the performance of the system using various tuning techniques.
• Setup database environment for migration from SQL Server to Oracle.
• Created Dimensional Model for Reporting Application
• Analyzed data element mapping between source and target systems and translated it to ETL mappings.

Environment:Informatica Power Center 8.1, IBM AIX 5.0, Sybase 12.5, Oracle 9i/10g, Windows NT/2000, Sun Solaris, Toad, Unix Shell Scripts, Autosys, MS Project, Visio, Erwin, Test Director, QTP, OEM, SQL Developer, PL/SQL Developer, SQL Server 2000/2005, JAVA JDK 1.5.0

Confidential

Datawarehousing Architect

Responsibilities:

• Collected the business requirement for integrating different new sources for Equity,Bond and designed the process flow depending on business logic.

• Did the deployment of Abinitio and non abinitio components from the lower environments to Production and prepared the task list for the Production Deployment by coordinating with different teams involved in the release.
• Overseeing the Entire engagement which includes Business Development Requirement Gathering.
• Established processes for governing the identification,collection,and use of corporate metadata take steps to assure metadata accuracy and validity.
• Oversaw the mapping of data sources, data movement,interfaces,and analytics,with the goal of ensuring data quality.
• Managed virtual, cross-functional teams, including defining requirements
• Communicated at different levels within the organization about the advantages and disadvantages of using various technologies and standards
• Managed multiple project tasks, resources meeting the deadline
• Created logical data models and translate into physical database structures that integrate with existing or proposed database structures.
• Addressed a variety of database integration issues including migration between disparate databases, integration,maintenance.
• Maintained development, test and production RDBMS environments.
• Leading the development of Data Warehouse Project and tracking of Project Plans.
• Monitored and maintained database security.
• Monitored and managed database backups, logs.
• Installed, maintained, and upgraded database software.
• Reviewed overall physical database structures for data integrity,performance quality, recoverability,maintenance, and space requirement considerations.
• Wrote Unixl Scripts for Job Scheduling/Monitoring,Data Massaging and Developed Oracle Stored Procedures packages using PL/SQL depending on the business requirement.
• Wrote Perl scripts for scrubbing source data
• Developed and implemented key components as needed to create testing criteriain order to guarantee the the accuracy and performance of data architecture.
• Developed Abinitio graphs as per the business specifications.
• Establishment and maintaining the Project/Program communications.
• Provided guidance on quality issue resolutions.
• Managed the configuration,compilation of the IDB project.
• Used IBM Rational ClearCase,CVS tools to perform regular version and configuration management duties such as checking out, labeling,branching large codebases.
• Designed,implemented,automated,and managed configuration management processes and associated documentation.
• Worked on the migration of one acquisition/servicing system to another acquisition/servicing system.
• Tracked and managed release management process through bug tracking system.
• Determined the criteria and methods needed to ensure that both operation and control of processes are effective.
• Provided technical leadership and guidance to developers and QA working on development project teams.
• Managed the SOX- related issues to make sure the application is SOX compliant.
• Coordinated and managed the infrastructure changes by recommending alternatives and planning the implementation steps to minimize the application impact.
• Worked with different teams to understand the process and suggested improvements to operating policies and procedure.
• Designed/developed/audited the Universe/Reports and documenting the entire life cycle.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created Business Objects Repository while building Business Objects solution.
• Designed data models from business requirements .
• Coordinated the deployment of new changes into production by ensuring the deliverables are delivered in time.
• Created reports using Desktop Intelligence and Web Intelligence in BO XI r2 environment.
• Created Dimensional Model for Reporting
• Managed different environments like Development,Test,Acceptance for parallel development and multiple releases.
• Did the design for Enhancement projects and new source integration projects and acted as a lead by doing the code reviews and monitoring and mentoring the Developers and creating the Design documents.

Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, Sybase 12.5, Oracle 9i/10g, Windows NT/2000, Sun Solaris, Toad, Unix Shell Scripts, Autosys, MS Project, Visio, Business Objects XI-R1/R2,6.5,5x, Web Intelligence 6.5/XI,Erwin, Test Director, QTP, OEM, XML,XQuery, XPath, XSLT,Perl

Confidential

Technical Lead

Responsibilities:

• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Analyzed the current process and recommended steps leading to Performance enhancement and streamlining of the processes and created the Design documents,Production readiness douments.
• Evaluated number of Ab Initio Graphs and suggested performance tuning tips based on business requirements.

Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, UDB DB2, Oracle 9i, Windows NT/2000, OS/390, IBM ES-3090, Sun Solaris, Toad, Unix Shell Scripts