SUMMARY:

• Enterprise Architecture, System and software analysis, design, development and implementation with emphasis on Database Applications, Data Migration, Data Interface, Data Warehousing, Web design, System Testing, Integration and Deployment.
• Effective combination of systems design, technical expertise with managerial and communication skills.
• Ability to work in a team environment, emphasizing team goals over personal goals.
• Strong initiative and drive with the ability to absorb technical Information/knowledge quickly.

TECHNICAL SKILLS:

OS: MS - DOS, Windows (XP, Vista), UNIX (Solaris), LINUX

Databases: Oracle 12, PostgreSQL (pgAdmin III), MS-Access, DB2, SQL Microsoft Server 2012

GUI Tools: Oracle Developer Suite (Forms, Reports, Crystal Report, Business Object

Languages: PL/SQL, JAVA (EJB, JDBC, RMI, JNDI), Advanced SQL, HTML, VI Script, Shell Script,BASIC, UML.

Java Technologies: EJB, JSP, RMI, JDBC, JNDI, JNI, JTA, JMS, Servlets, Eclipse 3.2, Apache Ant 1.6.5

Other Tools: BEA Weblogic Application Server, Cold Fusion 4.5, Symantec Visual Caf, Oracle DesignerErwin, ETL Tool Informatica and Power Center, Oracle OBIEE

Applications: SAP R/3 (Fico) Release 4.7, Rational Clear Quest, Clear Case, PVCS Version Manager,SQL*Loader, SQL Navigator, TOAD, MS Visual Source Safe, Visio, Remedy.

PROFESSIONAL EXPERIENCE:

Confidential

Database Specialist Snr. ETL Developer (Informatica)

Responsibilities:

• Support and Troubleshoot of mappings and workflows using Informatica Power Center 9.6.1 HotFix 3(Designer, Repository Manager, Workflow Manager, Workflow Monitor and Admin console).
• Maintain and support daily load of production data and quickly resolve any issues in production environment.
• Developed numerous mappings, sessions and workflows to support RRP project.
• Team leader: overseeing developers in new developments and initiatives (common objects), new projects design and unit testing of new developments.
• Administer admin functionalities such workflow migration to other environments, repository manager.
• Develop ETL transaction for loading data into multiple projects using Informatica Designer and Workflow Manager.
• Extraction of data from multiples sources (Cobol, database, xml, flat file etc) into various data warehouses and data

Confidential

Snr. ETL Developer (Informatica)

Responsibilities:

• Developed numerous mappings, sessions and workflows to support new and existing business requirement of the agency.
• Structured data processed in NIC environment are transmitted to other Federal Reserve System and external agencies.
• Developed baseline and incremental processing to migrate data in XMl format to other agencies using Connect: Directand Secure FTP.
• Support and Troubleshoot of mappings and workflows using Informatica Power Center 9.5.1 HotFix 3(Designer, Repository Manager, Workflow Manager, Workflow Monitor and Admin console).
• Migration of mappings, sessions and workflows from development into testing and production environments.
• Resolve workflow failure or any other issues in Informatica environments.
• Wrote and converted SAS programing logic using Informatica powercenter 9.5.1 using SQL Server 2012 version 11.0.
• Maintained other existing codes in Informatica and SQL Server such as FBO, TICBanking etc.

Confidential

Snr. ETL Developer (Informatica)

Responsibilities:

• Support KC Daily load project in the Development, Testing and Production environments.
• Admin tasks and configuration of Informatica repository, domain and note; Installations, user configurations and trouble shooting.
• Developed numerous mappings, sessions and workflows to support new and existing business requirement of the department.
• Support and Troubleshoot of mappings and workflows using Informatica Power Center 9.5.1
• Migration of mappings, sessions and workflows into both testing and production environments.
• Develop ETL transaction for loading data into multiple projects using Informatica Designer and Workflow Manager.
• Identify and resolve workflow failure in all three Informatica environments.
• Re-wrote and converted many Oracle SQLs logic into Informatica in supporting business requirements.

Confidential

Database Specialist

Responsibilities:

• Member of EIP team responsible for providing 24x7 on call support in the Testing, Development
• Member of ETL Design and Development - EIP team of CADE2, IPM, EFDS and other projects.
• Support and Troubleshooting of mappings and workflows in the EIP using Informatica Power Center 9.0.1/ 9.0.5 and 9.5.1
• Develop ETL transaction for loading data into multiple projects using Informatica Designer and Workflow Manager.
• Member of the service restoration team and Support Infomatica problem Management meetings.
• Support troubleshooting, optimization and performance issues on the EIP;
• Identify and resolve workflow failure in all Informatica platforms
• Standardize process for the Informatica platform across projects (i.e. transmittal, procedures, upgrades and etc) and
• Member of the Solution Engineering team responsible for Data Architecture, Data Modeling, Data Transformation rules and Data Requirement, Data Mapping, documentation, Data Modeling of IMF/CADE2 and CADE2/IPM using IBM InfoSphere.
• Member of ETL Design and Development of EIP team of CADE
• Table and column naming standardization, column mapping of XML schema, created business rules and other supporting document used for Data transformation in ETL - Informatica mapping.
• Table and column of schema comparison, used SQL Loader to load schema into oracle database for comparison, review of IPM report queries for performance optimization.
• Member of the Enterprise Informatica Platform (EIP) responsible for providing an enterprise ETL environment data access to Systems, Storage and performance monitoring of Jobs, session, CPU, storage and processes to increase productivity.
• Member of Data migration strategy team and participated in the redesigning of DB2 to Oracle database, Business and Data Transformation rules.
• Documentation of data mapping from IMF - CADE2 system and from CADE2 to IPM and captured the changes between system changes.

Confidential

Database Specialist

Responsibilities:

• Supporting and maintaining existing platform of EABM and WebIDENT software.
• Modifying of database schemas, Oracle Forms and Reports in support of SCRs/enhancements.
• Review of current systems and provided recommendations for system performance improvements.
• Revise database scripts and maintain all versions under change control
• Perform ad-hoc queries and/or reports; document newly constructed queries and reports to allow future reuse.
• Support and troubleshooting, optimization and performance of database.

Confidential

SME Data Analyst /Architect

Responsibilities:

• Member of the Data Architecture team, responsible for implementing data requirement, data mapping, Interface documentation, data modeling and data flow diagram using Erwin Data Modeler and AllFusion Model Manager.
• Maintaining, supporting and reviewing existing PL/SQL codes that support DCAM (DMLSS Customer Assistance Module) and loading Master Catalog from UDR (Universal Data Repository).
• Participated in the EDTF (enterprise data task force) responsible for developing Enterprise Data Strategy which includes data governance, data architecture and management, metadata and all other data and management initiatives for the DML - Confidential .
• Participated in evaluating and testing of Informatica Power center 8.x in the Enterprise Environment.
• Participated in the data requirements and capturing of business rules of JMLFDC SAMS Working Group meeting, JMLFDC DMLSS-R WAWF Interface, DMLSS to DMLSS process and data requirement.
• User Requirement gathering and developed NIRDS (New Item Request Data Standards) and EDD (enterprise data dictionary) requirements and taxonomy.
• Standardization of physical and logical data elements names in the enterprise data structure.
• Participated in the NIRDS business review, business rules and management process.
• Designed a user interface screen to support New Item request requirements.
• Gap analysis between TEWLS data elements and the NIR data elements.
• Developed and Supported DML data community of interest (COI) collaboration tool in AKO to support data stewardship and EDTF.
• Developed XML schema to support the NIRDS.

Confidential

Senior Consultant

Responsibilities:

• Prepared data for Restatement/Catch up from to the production environment in Oracle 10g release 2and Solaris 6.5.
• Executed and updated Shell scripts for loading data in the test environment.
• Extracted, transformed and loaded data using PL/SQL, SQL* Loader, and other Oracle objects as Partitioning and Bulk Collectfor optimal performance.
• Developed numerous User Acceptance Test (UAT) cases before migration into the production environment.
• Mapped table structure of the ADW (Accounting Data Warehousing) environment.
• Used TOAD for writing SQL Scripts, functions, procedures, packages and for debugging.
• Data analysis of Enterprise Architectural Model of Confidential business processes.
• Design and developed Conceptual and Logical data mapping as it relate from the enterprise model.
• Created CRUD matrices from enterprise business process at the Conceptual and Logical level in relations to data usage.
• Develop and validate subject area models and events models.
• Interactive JAD session with client to define and develop a data management methodology.
• Critical Data Mapping and Elements (CDM & CDE) of data structure of the enterprise data model to numerous physical data base structure.
• Created and mapped Entities and Attributes at the Conceptual and Logical level as it relate to the Tables and Columns in the physical data base.

Confidential

Senior Consultant

Responsibilities:

• Extracted and Maintained data refresh process, using Eclipse 3.2, Apache 1.6.5 in the data warehouse environmentfor FRS project.
• Data cleansing and loading of submitted extract and refresh data from both States and National through Enviro-FactSystems.
• Developed advance mapping and transformation using Informatica 7.x for loading both full and incremental refresh data.
• Supported mapping and workflow in the FRS environment using Informatica Power Center 7.0.2 (Designer, Repository
• Trouble shooting and testing of submitted data before implementing in the data warehouse.
• Used SQL*Loader utility for loading data, importing and exporting data into staging and production tables.
• Extraction Transformation Load using Informatica for loading data into the data warehouse environment.
• Used TOAD for running scripts, functions, procedures, packages and triggers to load data into the FRS Systems.

Confidential

Senior Consultant

Responsibilities:

• Developed advance mapping and transformation using Informatica 6.1, 6.2, 7.3.
• Support and Troubleshooting of mappings and workflows in the VETSNET environment using Informatica Power Center 7.3
• Informatica Workflow manager and session scheduling of data load from source to target.
• Requirement gathering, functional and technical specification, Data Cleansing, Data Design, Data Modeling,
• Application support, Documentation and testing.
• Designed and Developed Business Intelligent Report using Oracle Discoverer 10g.
• Created customer folders and business areas for various project for the users in Oracle Discoverer 10g.
• Developed and tested various mappings involved in the ETL process.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Expression and Sequence Generator.
• Involved in testing of Informatica mappings and Identifying of data mapping for Reports generation.
• Created and managed mapping design and workflows, workflow manager and workflow monitor.
• Developed and designed OLAP data modeling using dimensional and facts modeling concepts ( star, snow flake andmulti star schema).
• Wrote numerous PL/SQL fuctions, procedures and packages in implementing extract-transform-load (ETL) processes using Informatica .

Confidential

Senior Consultant

Responsibilities:

• Developed and designed system architecture, and data modeling of the data requirements using dimensional modeling concepts (Star, snow flake and multi star schema).
• Developed Data objects using Erwin 4.1.4, for data modeling and data ware housing.
• Developed used cases, used cases diagram and business flows diagram of the System.
• Analyzed data from legacy VSAM file of existing Systems.
• Data requirement, gathering and analysis of the SSA ticket to work program.

Confidential

Senior Consultant

Responsibilities:

• Conversion and deployment of UA Systems from Oracle 4.5 and Report 2.5 to Oracle 9i, 9 IAS, Designer 6i, Forms 6i, Reports 6i and J-initiator .
• Maintenance of existing UA Systems, bug fixes and implementation of new functional requirement.
• Database Management of existing Systems.
• Used SQL Navigator & TOAD for writing of scripts, functions, procedures, packages and triggers.
• Developed Forms and Reports used to implement UA Systems.
• Developed Oracle data objects using Oracle Designer 6i, Forms 6, Reports 6 and Oracle 9i on Solaris UNIX.
• Wrote numerous procedures, functions, packages, triggers and REF Cursor in SQL*PLUS, Forms 6i and Reports 6i.

Confidential

Senior Consultant

Responsibilities:

• Developed mapping and transformation using Informatica 5.x.
• Developed data mapping for Reports generation, data cleansing, developed detailed ETL specifications based on business requirements and test the ETL application following all ETL standards and architecture.
• Created and managed mapping design and workflows, workflow manager and workflow monitor.
• Developed and designed OLAP data modeling using dimensional modeling concepts ( star, snow flake and multi star schema).
• Developed an Oracle web based Application Systems for the state of Michigan using Oracle 9i, 9 IAS, Designer 6i, Forms 6i, Reports 6i and J-initiator.
• Maintenance of MiCSES 2.2 System, bug fixes and implementation of new functional requirement.
• Developed Oracle data objects using Oracle Designer 6i, Forms 6, Reports 6 and Oracle 8i on Solaris UNIX.
• Used TOAD for writing of scripts, functions, procedures, packages and triggers.
• Developed Forms and Reports used to implement Michigan State Child Support Enforcement System MiCSES.
• Wrote numerous procedures, functions, packages, triggers and REF Cursor in SQL*PLUS, Forms 6i and Reports 6i.
• Implemented business rules and logic used in the MiCSES Systems.

Confidential

Quality Assurance Engineer

Responsibilities:

• Responsible for coordinating the System Test of the QA projects.
• Developed System test plan and execution strategy documentation for the MiCSES 2.2 application.
• QA Test environment was UNIX V5.1 Compaq Tru64, Oracle 8I,Developer 6I and Designer 6I, J-Initiator (Java plug-in), VAX/VMS, IE5x web browser, QA Center Enterprise Edition (QARun 4.7.4, QADirector 4.4.2) .
• Responsible for decision trees for all test cases used in the process, which described the test procedures and ranking of metrics used for quality assurance.
• Developed test cases for the security testing and security execution plan for the MiCSES S 2.2 application, using unified methodology.
• Helped in the Installation and simulation of production like test environment and tested all the functions of the systems that was used on the UNIX environment.
• Developed milestone and deliverables for the team and generated test data used for testing.
• Wrote numerous test result reports, defect reports and test summary reports using Remedy 4.0.
• Developed and executed test cases used in the Integration testing of functional modules such as Finance, Enforcement, Interface,
• Manual testing were used for executing test cases and Automated testing were used for Load testing and Stress testing using QARun and QALoad by Compuware.

Confidential

Senior Consultant

Responsibilities:

• Developed Oracle data object using Oracle Designer 2000 6i, Developer 2000 and Oracle 8I on HP/Unix environment.
• Developed Numerous Reports using Crystal Reports and Supported developers in implementing business rules.
• Wrote numerous procedures, functions, packages and triggers in SQL*PLUS, Forms 5.0 and Reports 3.0
• Retrieved and stored from documents and catalog, this was stored on the database, also worked with MQ-Series.
• Testing and maintaining of Oracle objects, Functions, Packages, Procedures and Triggers.
• Maintained, debugged and customized existing COTS project to support Wolverine.

Confidential

Senior Consultant

Responsibilities:

• Developed an Oracle base electronic Resource Management Systems for the United States Postal Service and deploying over the Internet.
• Deployment and Conversion of existing Oracle Forms and Reports on UNIX into the web.
• Developed Oracle data objects using Oracle Designer 6i, Forms 6, Reports 6 and Oracle 8i on Solaris UNIX.
• Developed Korn Shell Script to automate various routine for migration and compilation.
• Deployment of eRMS Forms and Reports over the Internet Using Oracle J-Initiator 1.1.7.27, Web DB and Oracle 9i Application Server.
• Used SQL Navigator tool for writing of scripts, functions, procedures, packages and triggers.
• Generated numerous Reports with varying degrees of complexity in pdf format and deployed them over the web.
• Wrote numerous procedures, functions, packages, triggers and REF Cursor in SQL*PLUS, Forms 6i and Reports 6i.
• Implemented business rules and logic used in the eRMS Systems.
• Used SQL*Loader utility for importing legacy data into staging tables.
• Participated in the Unit testing of the Systems over the Internet. Tested and fixed bugs found in the System.

Confidential

Senior Consultant

Responsibilities:

• Developed Oracle data object using Oracle Designer 2000, Developer 2000 and Oracle 8I on HP/Unix environment.
• Data migration and data conversion of legacy data into GCSS-Army database using SMARTDB scripts and performing numerous business rules during data transformation.
• Migrated data and business logic from COBOL to the new GCSS-Army Application.
• Involved in obtaining CMM-3 on the GCSS-Army Project.
• Used SQL*Loader utility for importing legacy data into staging tables.
• Generated physical tables and table API using Designer 2000.
• Wrote numerous procedures, functions, packages and triggers in SQL*PLUS, Forms 5.0 and Reports 3.0
• Conversion of Forms Applications from Forms 4.5 and Reports 2.5 to Oracle Forms 6i and Report 6i.
• Generated updateable views with Designer 2000 for implementing business rules.
• Developed numerous forms for automated data conversion by end user.
• Wrote test scripts and documentation for the data conversion process.
• Participated in the performance tuning of the system.
• Implemented the full life cycle of the PCS project.
• Requirements gathering and data modeling using Designer 2000.
• Created the ER, functional hierarchy and server module diagrams.
• Generated the physical database from logical objects in Designer 2000 and performing DBA roles such as, creating, altering, modifying and dropping tables, constraints and indexes granting and revoking user privileges and rights,
• Forms and reports generation of PCS Application from Designer 2000.
• Post generation changes to forms and reports using Developer 2000 (Forms 5 and Reports 3)
• Design captured forms, reports, functions, procedures and packages back into the Designer 2000 repository.
• Wrote procedures, functions, packages and triggers in SQL*PLUS, Forms 5.0 and Reports 3.0

Confidential

Consultant

Responsibilities:

• Worked at Cable and Wireless to develop a data warehouse project for the Consumer Internet Marketing Systems (CIMS)
• Environment: Oracle 8 running on a HP-Unix, OLTP environment and Shell Scripting.
• Wrote PL/SQL code (functions and procedures, packages and database triggers) for capturing and implementing business rules.
• Data conversion from a legacy system onto Oracle 8 database using SQL*Loader.
• Performed DBA roles such as granting and revoking user privileges and rights, creating views and synonyms to the public, creating, altering, modifying and dropping tables.

Confidential

Consultant

Responsibilities:

• Worked at LTV Steel to develop and maintain the FDA/MES (Finishing Data Acquisition/Manufacturing Execution System).
• Primary support for Developer 2000 Architecture and secondary support for Reporting and Printing Architecture as well as keeping Template up-to-date.
• Environment: Oracle 7.3, Developer 2000, SAP (manufacturing), HP-UNIX and Korn Shell Script.
• Developed and maintained code in PL/SQL Libraries, Procedures and Packages and Developer 2000 Objects, Property Classes and Visual Attributes.
• Performed DBA roles such as granting and revoking user privileges and rights, creating views and synonyms to the public, creating, altering, modifying and dropping tables.
• Supported Clients and junior to mid-level developers in using Forms Architecture for Development.
• Supported message handling and logging.

Confidential

Senior Oracle Developer

Responsibilities:

• Worked on a team to design and develop a Fleet Logistics System (FLS Partition 1) for US Coast Guard.
• Environment: Oracle 7.3, Developer 2000, Designer 2000, NT-Workstation running on a HP-UNIX.
• Was part of the CMM level 3 team, on the US Coast Guard.
• Used Designer 2000 to gather user requirements and customer detail specifications to create complex forms.
• Lead Developer for the Maintenance Subsystem, with over 350 tables including tables.
• Generated E-R and dataflow diagrams also generated Data Modules diagrammer for creating Forms and used Repository Object Navigator (RON) diagrammer toolsets available on Designer 2000.
• Generated Forms using standard template and common libraries in Designer 2000.
• Developed and supported high-level forms with multiple calling forms, libraries, menus, procedures, functions, while passing both local and global parameters using Developer 2000.
• Responsible for checking in and checking out applications using PVCS Version Manager.

Confidential

Senior Oracle Developer (Consultant)

Responsibilities:

• Worked on a team to design and develop a Field s and Compliance Tracking System (FACTS) for the FDA (Food and Drug Administration).
• Environment: Oracle 7.1, Developer 2000, Designer 2000, Open VMX Alpha 1000.
• Used customer detail specifications to create complex forms using Developer 2000 (Forms 4.5).
• Generated E-R and Dataflow Diagrams with the E-R diagrammer and the Data Flow diagrammer toolsets available on Designer 2000.
• Created and supported libraries for the FACTS project.
• Developed and supported high-level forms with multiple calling forms, libraries, menus, procedures, functions while passing both local and global parameters.

Confidential, BALTIMORE, MD

Programmer/Oracle Developer (Consultant)

Responsibilities:

• Created a Relational Database Management System using Oracle 7.3 on a Windows NT 4.0 platform with over thirty tables that support nationwide workers' compensation injury report.
• Storage and Retrieval of numerous electronic fax documents, scanned images on the workers' compensation database.
• Migrated existing MS Access database to Oracle. Developer 2000 (Forms 4.5 and Reports 2.5) was on the front-end, while Oracle 7.3 was used on the back-end.
• Performed DBA roles such as granting and revoking user privileges and rights, creating views and synonyms to the public, creating, altering, modifying and dropping tables.
• Designed logical and physical data modeling (E-R Diagrams) using Full Life-Cycle Development.
• Worked with large amounts of documents, scanned images, EDI and Storage of images on the database.
• Designed a GUI application for Rapid Response Injury Claim System for workers' Compensation using Developer 2000.
• Created various server side objects like tables, views, indexes, sequences, stored procedures, functions, database triggers and packages using SQL and PL/SQL in SQL*Plus.

Confidential, ALPHARETTA, GA

Programmer/Oracle Developer

Responsibilities:

• Designed and developed a database system to provide a work-order management system for a building maintenance and repair company.
• Conversion from Oracle Forms 4.5 and Report 2.5 character based to GUI based.
• Environment: Oracle 7.x, Developer 2000, PowerBuilder 5, Windows NT 4.0
• Designed a logical model (E-R model) and created the physical database with various server side objects like tables, views, indexes, sequences, procedures, functions, database triggers and packages.
• Developed the application using Developer 2000 (Forms 4.5, Reports 2.5 and Graphics 2.5) as a front-end tool and SQL*Plus on the server side.
• Designed and developed a student database record system using Oracle as the back-end. Used stored procedures and database triggers extensively to generate screens for interactive data retrieval using PowerBuilder 5 as the front-end.