Objective

Seeking a position as a Data Modeler and/or Data Architect or a Data Modeler and/or Developer.

Experience Summary

• Ability to design and implement data migration projects utilizing SDLC experience gained migrating four projects successfully.
• Successfully created and maintained Enterprise Logical Data Models for three projects.
• Lead small to medium sized teams successfully on four projects starting at conceptual phase through development, and, deployment.
• Able to juggle multiple roles on small/medium sized projects from leading the team, data modeling/DBA, and/or development.
• Designed data architecture for one project with cloud computing environment using Amazon Web Services AWS for hosting the databases.
• Developed and documented a Data Strategy Plan, comprising identification of core data, database consolidation plan and data migration plan for EA.
• Contributed to the Data Architecture part of a Statement of Work SOW bid.
• Ability to communicate effectively with both technical and non-technical audiences utilizing good written and verbal skills.
• Fast learner and adapts to client environment gaining business knowledge and technical skills quickly.
• Self-starter with initiative.
• 18 years hands-on IT experience.

Primary skills

• Enterprise Logical Data Modeling ELDM and Project level Logical Data Modeling LDM and Physical Data Modeling PDM .
• Developing Data Models for OLTP databases Online Transactional Processing and DWH Data warehouse .
• Designing Staging, Star/Snowflake Schemas Dimensional Modeling for Data warehouses DWH , mapping source and target data elements and designing transformations.
• Forward and reverse engineering, Mapping and creating data elements for Use Cases and data analysis using SQL.
• Able to design effective Data and BI Business Intelligence solutions utilizing development experience with ETL Tools and BI Tools.

primary technical skills

• Well versed in using ER/Studio Data Architect and ERWin with effective usage of VBA macros.
• Proficient with IBM Infosphere Data Architect IDA and BIRT metadata reports.
• Extensive experience with ETL tools such as Informatica and SSIS.
• Database development experience with Oracle PL/SQL and MS SQL Server.
• Ability to design and develop BI solutions with OBIEE.
• DBA Development Installing and creating databases, setting up backups, Sizing and growth calculations.
• Performance Tuning of queries including looking at hardware, OS, database, tables and queries.

tools

SECURITY ClearanceS

Professional Experience

Confidential

ETL Developer

Project: Create and maintain the ELDM that documents the data needs of FMCSA and several applications such as Portal, Sentri and URS.

Confidential

• The model is built in phases and instantiated in Releases in EDB Enterprise Database . Tested and Delivered the DDL to the DBA.
• Analyzed requirements from Use Cases to map to either existing entities/attributes or created new entities/attributes and mapped to them.
• Refined and validated the data models with the functional teams.
• Supported Development Teams with information and analysis.
• Developed and applied data standards for both LDM and PDM.
• Identified Reference data from authoritative sources and loaded into the Model using VBA macros.
• Built pseudo reference data files for loading into the PREF tables.
• Published the ELDM Data Dictionary periodically in HTML and PDF formats for distribution.
• Mentored other Data Modelers, provided LOE level of effort .
• Created and maintained the ER Studio repository.

Technical Environment: Oracle 11gR2, Oracle SQL Developer, SQL Plus, IBM InfoSphere Data Architect, Toad, MS SQL Server, MySQL, ER Studio/Data Architect 10, ER Studio Repository 6.0, Firebird, FirePass, StarTeam, UNIX, Informatica, Altova XMLSpy

Confidential

• Provided LOE estimates, status reports, work allocation and managed the work.
• Designed data architecture with cloud computing environment using Amazon Web Services AWS for hosting the databases.
• Gathered data requirements from analysis of source system databases and source system documentation.
• Analyzed source databases Oracle 11gR2 and MS SQL Server R2008 , identified data quality issues, compatibility issues, and, developed mappings between source and target data elements.

Technical Environment: Cloud Computing Environment, Amazon Web Services AWS , Oracle 11gR2, Oracle SQL Developer, MS SQL Server 2012 and 2008, ERWin 8.x, Informatica 9.x, OBIEE 11.1.1, JIRA Issue Project Tracking System , VisualStudio 2010 2012, TFS Team Foundation Server

Consultant: Data Architect/Data Modeler

Project: The project involves automating the exchange of information between the US patent System and the European System for certain types of patents.

My Contribution: Client was convinced of my capability and extended the contract 6 weeks originally which fetched additional revenue to my company.

• Developed a Logical Data Model LDM and the Data Dictionary.
• Technical Environment: IBM Infosphere Data Architect, Oracle 11g, Toad 11, Informatica, OBIEE, MySQL WorkBench, BIRT Reports, RationalRequisitePro, Altova XMLSpy

Confidential

Consultant: Data Architect

Project: Confidential is a Data warehouse that holds soldier's Officer, Enlisted, Reserve and National Guard professional and personal data. It is one of the essential databases of the Army Human Resources Command AHRC .

My Contribution: Designed and developed a solution without any additional cost and is currently in production.

• Designed the architecture - reads data from Mainframe backup files, loads the data into staging tables, transforms the data and loads the target tables.
• Developed the dimensional model with ERWin. Developed the ETL process uses SSIS that reads the source tables and loads the target tables.
• Developed a custom BI solution for delivering data to a customer that uses Oracle stored procedures, shell scripts, ESB and automated it with a cron job.

Technical Environment: Oracle 11g, Informatica 8.x, OBIEE 10.2.3.x, MS SQL Server 2008/2005, HP-UX, Solaris, SAN, ERWin 7.2, Toad 10, PL/SQL, TSQL, Shell Scripts, SQLLoader, IBM MainFrame/CA DataCom, SharePoint, WS FTP, IBM DataStage

Consultant: Data Architect

Project: Confidential in planning and implementation of the migration of the Data Center from Alexandria to Ft. Knox

• Developed and documented a Data Strategy Plan, comprising identification of core data, database consolidation plan and data migration plan.

Technical Environment: ERWin 7.2, IBM Rational System Architect, Oracle 11g, HP-UX, Solaris, NetApps SAN, Toad 10, PL/SQL, TSQL, Shell Scripts, SharePoint, IBM MainFrame/CA DataCom, SAS Enterprise Guide, Oracle BI

Confidential

Consultant: Data Modeler

Project: Worked as a Data Modeler for Automated Commercial Environment ACE and Defense Finance and Accounting Service DFAS applications.

Technical Environment: ERWin 7.2, Informatica 8.1, Oracle 10g

Confidential

Consultant: Team Lead/Data/BI Architect/ETL Developer

Project: The project goal of adding the HR Human Resources volume to the existing EDSL Educational Decision Support Library- Student Volume data warehouse was achieved successfully and is in production.

• Provided LOE estimates, status reports, work allocation and managed the work.

• Documented Business Rules, and, developed source and target data mapping of data elements
• Developed Dimensional Model for the HR volume.
• Designed and developed the architecture Transactional data from Lawson/Oracle was loaded into staging tables using Oracle stored procedures, Informatica and PL/SQL for the ETL, APEX and CrystalReports for BI reports, Discoverer for end user Adhoc reports, and, Oracle Designer Pages for the menu system and automation
• Completed the development of Informatica mappings after the Informatica Developer quit.
• Generated DDL and developed the execution scripts.
• Loaded the data into Dimensions.
• Developed a few APEX and CrystalReports until I hired a Reports Developer.

Technical Environment: Oracle 10g, 9i, Informatica 6.1, Crystal Reports 9, APEX, ERWin 3.5.1, Discoverer, Lawson

Confidential

Consultant: Data Modeler/ DBA/ Performance Engineer/SME

Project: Worked on three projects - Custodial Accounting Project CAP , Issue Management System IMS , IRFOF Internet Refund Fact of Filing .

My Contribution: Aligned LDM to EA and migrated from CoolGen to Oracle Designer in a short time. Client was happy and provided a good reference.

• SME on IRFOF.
• Data Modeler/DBA for IMS.
• DBA Performance Engineer on CAP - capacity planning, sizing, growth estimation and performance tuning - at Oracle database level, UNIX level, Informatica level, and, BusinessObjects reports.

Technical Environment: Oracle 9i and 8i, Informatica 5.1, 6.1, Business Objects 5.1, ERWin, DB2, VSAM , Sun Solaris, z/OS, Websphere, Strobe, TMON, TSO/ISPF, SPUFI, UNIX Performance Tools, MS Access, CMMI, Cool:Gen, Oracle Designer 9i, Oracle Lite, TOAD, CVS, ClearCase, Telnet, Visio, Tomcat, Web-to-go, Sun Solaris, SQLQuery, ClearQuest, Rational Rose, Netegrity SiteMinder, E-Trust Directory Services, LDAP, Java, Websphere, IIS, Confidential

Consultant: Team Lead/Data Modeler/DBA/Database Developer

My Contribution: As a Team Lead developed and deployed a web J2EE application on the Intranet successfully and within schedule.

• Maintained data models and kept data model and database in synchronization using ERWin at Cable Wireless.
• Team Lead managing the Developers in the team plus Data Modeling/DBA at WinStar. Also administered WebLogic and VSS.
• DBA at USPS.
• Provided LOE estimates, status reports, work allocation and managed the work.
• Database SME at Snyder.
• Database Developer at MCI.
• Technical Environment: Oracle 8i, Solaris 2.x, ERWin 3.5.1, Informatica 5.1, SQL Navigator, SQL Plus, PL/SQL, J2EE, WebLogic, Java, Windows NT, ClearCase, VSS, MS SQL Server 2000, SAN, HP-UX 10.20, MS Access, Wang, Windows NT, Objectel

Confidential

Consultant: Database Developer

My Contribution: Client liked the expertise that I gained in a short time on SiteLinking project and commended me.

• Provided production support for several applications/databases
• Coded and maintained CrystalReports and MS Excel Reports
• Loaded data from MainFrame to Oracle SQLLDR and MS SQL Server BulkCopy databases
• Technical Environment: ERWin 2.x, DB2, Oracle 7.x, MS SQL Server 4.2, 6.5, SPUFI, QMF, JCL, WinQuery, PVCS, MVS, TSQL, Windows NT, VisualBasic, VBA, COBOL, MS Access, Crystal Reports, Endevor, Hoover