EXPERIENCE SUMMARY:

• Data Architect/System Analyst/Data Modeler/Software Developer with 18 years of Information Technology related experience involved in the complete system life cycle including planning, analysis, design and modeling, development, testing, deployment, and transition. Responsibilities have included:
• Data Warehouse System Analyst for IBM US and IBM Offshore. Working with Agile in a distributed team Environment.
• Acting as liaison between the project management and the Information Technology vendors to ensure achievement of project priorities and goals.
• Possesses strong planning, analysis, data modeling, application design, software development, and problem solving skills.
• Worked with business users to understand the requirements and create the logical model.
• Designed and implemented N-tier systems internet, Intranet, client-server, and distributed computing applications in WINDOWS and UNIX environments.
• Performed extensive Relational modeling utilizing Erwin, Sybase PowerDesigner, and Embarcadero ERStudio.
• Performed extensive UML analysis modeling utilizing RATIONAL ROSE and object oriented analysis and design.
• Experienced in multiple industries including telecommunication, automotive, government, financial, heath care, retail, media entertainment, manufacturing, and service industries.

Skills Summary

LANGUAGES:

• JAVA
• PL/SQL
• SHELL SCRIPTS
• LISP

HARDWARE:

• SUN SOLARIS
• HP 700/800/9000
• SUN/SPARC
• PC

OPERATING SYSTEMS:

• WINDOWS
• UNIX
• LINUX RedHat
• Mac OS X 10.6.8
• MacBook Pro Darwin UNIX

SOFTWARE/TOOLS:

• IBM DOORS 9.5
• Oracle SQL Developer 1.5.5
• ORACLE 10g and 11i
• SQL SERVER, SYBASE
• INFORMIX
• UNIFACE SERVER Pages
• ERStudio 9.5
• ERWIN 9.1
• UML
• TOAD
• Aginity Workbench
• Netezza Data Warehouse
• Hadoop
• Hbase
• EDI MERCATOR

EXPERIENCE:

Confidential

Position: System Analyst

• Data Warehouse System Analyst for IBM US and IBM Offshore: Working with Agile in a distributed Team Environment. Created system requirements from functional requirements and Logical data model for OLAP systems, inbound and outbound Feeds to and from data warehouse, associated ETL jobs, and OBIEE reports and subject areas. Analyzed FRs, attended meetings with customers, designed, provided logical model for STAR schema data mart, source to target mappings and performed walk-throughs to offshore and hand over for development. Worked with QA team and customers UAT to make sure the system requirements are delivered. The system requirements were developed in IBM Rational DOORS modules. Successfully, delivered SRs and LDM for the following projects at AT T/ Cricket Communications for IBM:
• Device Trade up Promotions, Triage, Activations, Payout, and Data Mart
• LTE National Activations Feed to Sprint
• Rout Request Data Mart and Feed to SONAR
• Tax Audit Report, Data Mart and Feeds

Technical environment included: IBM Rational DOORS 9.4, Oracle 11g, SQL Developer 1.5.5, TOAD, ERStudio Data Architect 9.5, MS Visio 2010, JIRA Project Management, Window 7 Enterprise, and Lenovo ThinkPad T430.

Confidential

Position: Data Architect/Analyst

• Working with a small team on building a state of the art Data Warehouse from the ground up:
• Nanometrics are automating their business processes. They are moving from SysPro to Oracle ERP and TIBCO is used as middleware.
• Working with customers and end users to identify the Subject Areas for the Bi / BA reporting.
• Data warehouse Capacity Planning.
• Data Profiling SysPro Data using Pervasive Data Profiler.
• Classifying the existing reports based on the identified subject areas.
• Driving TO BE Conceptual Canonical model.

Technical environment included: Erwin 9.1, Window 8, MS Visio 2010, and Window 8.

Confidential

Position: Data Architect

• Supporting SCMAS SmartConnectTM Monitoring Analysis System project with:
• Mapping over a 1000 SCMAS business data elements to the corresponding data elements in semantic and core layers of SCE Teradata data warehouse SCMAS is built on SCE Teradata data warehouse . This mapping identified many data quality issues related to ETL processes.
• Identifying and verifying the Domain of Values for core SCMAS business data elements across different SCMAS related applications to make sure their values are consistent and correct.
• User Acceptance Testing UAT :
• Participating in Analyzing and designing Data Sets for SCMAS UAT.
• Testing 24 Data Marts and 45 BO reports including drill downs with system test data.
• Production Verification Testing PVT :
• Testing SCMAS UI and 24 Data Marts and 45 BO reports with drill downs with production data.
• Data Profiling in order to identify data issues such as data inconsistencies, design errors and calculation defects.
• Analyzed and measured latency response time for 45 Business Objects reports with Drill down. Identified and tuned the problem queries.
• Developing a number of ad hoc BO reports for production data verification.

Technical environment included: SAP Business Objects 3.1 and 4.0, Teradata Data Warehouse Appliances, Window Professional XP.

Confidential

Position: Data Architect/Data Modeler/Analyst

Conceptual Modeling:

• Time Warner Enterprise HR/Payroll subj ect area conceptual and logical model.
• Time Warner Enterprise HR/Payroll Master Data With Data Source and Usage Indications.
• HR/Payroll Views of Time Warner Enterprise Data Warehouse/ Workday, DB2, and Peoplesoft databases across Waves.
• Time Warner Enterprise Master Data Integration Schematic
• Interface Function Design Specification services: Gathered requirement from clients, older documents and the existing interfaces' programs and analyzed and wrote functional specifications for several interfaces to internal and external Warner Bros systems.
• Data Element Impact Analysis: The HR/Payroll Integration project involves the redesign and shift of enterprise critical master data across the enterprise. First, identified the impacts utilizing Enterprise Architecture Management System EAMS and prepared a survey that classify the potential impacts into classes based on scope of impact and size and effort categories and to prioritize implementation needs accordingly.
• Provided an inventory of the master data domains and classify each of them into categories based on Source System of Record, Target System Replication, Target System Replication With Master Data Extension, System Usages, Synchronization Requirement, Synchronization Method Manual vs. MDH vs. Interface , Master Data Management Method Manual vs. MDH , Service Level Monitoring Requirement SLH , Proactive Monitoring Requirements Dashboard Reporting , and Interrelated Master Data Dependencies.

Technical environment included: ERStudio Data Architect 8.5, Embarcadero ERStudio Business Architect, MS Visio 2007, Aginity Workbench, NETEZZA DATA WAREHOUE APPLIANCES, Workday Integration Cloud and Window Professional XP.