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 Architect/Data Modeler

• 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 SmartConnect TM 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

Supporting the HR/Payroll Integration project to Workday Integration Cloud with:

Conceptual Modeling:

• 5Time Warner Enterprise Master Data Integration Schematic
• HR/Payroll Views of Time Warner Enterprise Data Warehouse/ Workday, DB2, and Peoplesoft databases across Waves.
• Time Warner Enterprise HR/Payroll Master Data With Data Source and Usage Indications.
• Time Warner Enterprise HR/Payroll subject area conceptual and logical model.
• 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.

Confidential

• Learned Hadoop and Hbase database. Installed and configured Hadoop and Hbase. Wrote a Java program to create, inserts, update tables in Hbase Database.
• Installed Mysql on a LINUX node as server database. Implemented multi-processing by inserting to a table in Mysql database on the server node from four other nodes at the same time. Used a UNIX daemon and a PERL process. The Unix daemon could execute the Perl process every minute. The Perl process could insert rows from four nodes to a table in Mysql database on server node at the same time.

Technical environment included: Hadoop-0.20.2, Hbase-0.90.3, JAVA 1.6.0 26 , Mac OS X 10.6.8 , Mysql 5.5.15 , Mac BookPro, INTEL XEON X5660 LINUX

Confidential

Position: Data Analyst/Modeler

• Worked as DA to support the database and data changes for four different ongoing OLAP applications with Cubes and Data Marts in multi data warehouses layers and environments.
• Analyzed the impact of the databases changes to the OLAP Data Marts.
• Helped OLAP application teams with implementing the queries that were needed for the BI Reporting of the OLAP Cube. Theses queries were used to calculate the measures used by the OLAP Cubes. The measures were about analyzing Profitability and Customer Insight in different dimensions levels.
• Coordinated implementing the OLAP Application databases changes and Data Refreshes for three layers data warehouse on Netezza and Oracle QA and PRD servers.
• Reverse engineered different Data Marts and OLAP application data models using Sybase PowerDesigner.
• Helped OLAP application teams with the naming convention of database changes.
• Created metadata document for the database changes.

Technical environment included: ORACLE 11g, Oracle 10g, SQL PLUS, Sybase PowerDesigner, TOAD 10.6, Aginity Workbench, NETEZZA DATA WAREHOUE APPLIANCES, ProChain, AR REMEDY SYSTEM, WINDOW XP, SOLARIS LINX/UNIX.

Confidential

Position: Data Modeler/Analyst/Developer

• Assisted in Data Modeling and Data management of different large-scale apps and ETL processes for a data warehouse.
• Worked with business users to understand the Requirements and create the logical model using data Normalization Process.
• Assisted in data conversion of different large-scale apps. Involved in planning, design and development of SQL script and coordinating tasks for data conversion.
• Designed and developed many PL/SQL packages. Tuned many SQL queries in different reports and applications by using Bulk PL/SQL programming.
• Helped tuning existing application and adding new features to different part of application.
• Converted many existing Reports to PL/SQL packages to resolve performance issues used Bulk PL/SQL programming.
• Designed and developed many database packages, triggers and stored procedures for the application.

Technical environment included: ORACLE 9i, ORACLE 10g, PL/SQL, SQL PLUS, ORACLE DESIGNER, ERWIN 7.3, WINDOW XP, VISTA, NT 4.0, and SPARC SOLARIS 9. NT 4.0, PC, HP

Confidential

Position: LEAD Developer

A J2EE application for General Motors provided an easy to use clients for accessing mainframe application Confidential Product Description System which was used to enter, structure, manage, maintain, and communicate product-engineering data to GM employees and suppliers. The GPDS-Create project was heavily tied to the SDP-21 process, as well as GM architecture and IS S processes and standards. The target environment was a thin client that included a number of current technologies, products, and standards, including J2EE-compliant WebLogic server, security services using Tivoli Policy Director 3.8, and significant use of XML and EJBs.

Responsibilities included:

• Participated in system design and modeling
• Participated in preparing UML based visual data and process requirements models.
• Created various UML diagrams such as Use Case models, activity diagrams, sequence diagrams, and class diagrams.
• Developed JSP and XML pages for the application.
• Led a team of 5 developers to develop JSP and XML pages for the application.

Technical environment included: JSP, Servlets, EJB, JNDI, JAXB, JAXP, XML, JavaScript, Web Services, WebLogic 6.1, IBM MQSeries, iPlanet Web Server, iPlanet LDAP Server, Visual Source Safe 6.0, Jbuilder 5.0, DreamWeaver 4.0, WebSeal Security Server, ER Model, UML, RUP, RATIONAL TOOLS/RATIONAL ROSE 2001, Oracle 9i

Confidential

Position: SOFTWARE DEVELOPER

• Design and development a distributed enterprise and real-time auto part tracking application with XML user interface using C and BEA messaging Q.
• Learned existing Part tracking application, in order to model and develop the new system functions.
• Met with users and gathered the new requirements. Wrote system requirement documents.
• Designed and developed many PL/SQL packages with Native Dynamic SQL to add new features to the application.
• Designed and developed many database views and stored procedures for the system.
• Designed and developed many XML pages for application user interface and ORACL FORMS for user support tools which resulted in more timely and effective tracking parts in Ford plants.

Technical environment included: MS Visual Studio 6.0, ORACLE 8I, SQL PLUS, XML 1.0, XSL 1.0, TOAD, PL/SQL, BEA MESSAGING Q, CRYSTAL REPORTS, MS SourceSafe, ORACLE FORMS, DESIGNER, WINDOW NT 4.0, PC, UNIX, HP 700/800, and UX 10.20.

Confidential

Position: SOFTWARE DEVELOPER

• Design and development of a staff order fulfillment application.
• Met with users and gathered requirements. Wrote system requirement documents.
• Designed and developed stateless UNIFACE screens using input and output services.
• Designed and developed many PL/SQL packages with Native Dynamic SQL to add new features to the application.
• Designed and developed many database views and stored procedures for the system. This project resulted in more timely and effective hiring and placing temporary staff for customer.

Technical environment included: UNIFACE JTI 7.2.6, ORACLE 8i, HARVEST 4.0, DESIGNER 2000, WINDOW NT 4.0, PC, UNIX, and SUN SOLARIS.

Confidential

Position: BUSINESS ANALYST/SOFTWARE DEVELOPER

• Learned existing Part Budget/Forecast application in order to redesign the system.
• Met with users and gathered the new requirements.
• Wrote system requirement documents.
• Data modeling Translate conceptual business ideas into logical data architecture design and further into physical database systems. .
• Design and development of a C Budget/Forecast application.
• Designed and developed many PL/SQL packages with Native Dynamic SQL to add new features to the application.
• Designed and developed Shell Scripts to drive the application batch processes with online documentation for day-to-day operations which resulted in a more accurate and timely flow of forecasting budget.

Technical environment included: C , ORACLE 8I, PL/SQL, CRYSTAL REPORTS, VIGNETTE , KORN SHELL. DESIGNER 2000, WINDOWS, PC, UNIX, and HP 700/800 UX 10.20.

Confidential

Position: DATA MODELER/WEB DEVELOPER

• Design and development of a project funnel input tracking application.
• Met with users and gathered requirements.
• Wrote functional requirement documents.
• Designed and developed UNIFACE WEB SERVER PAGES for an ENTRANET E-commerce application.
• Designed, developed and tested the web application security system. Project resulted in a more accurate and timely management of the company projects.
• Design and development an ENTRANET part price tracking application.
• Met with users gathered and wrote system requirements.
• Estimated the design/development time of UNIFACE Server Pages.
• Designed and developed UNIFACE WEB SERVER PAGES for an ENTRANET E-commerce application.
• Designed and developed the cookie used by the WEB application.
• Designed, developed and tested the web application security system. Project resulted in a more accurate and timely management of the company projects.

Technical environment included: UNIFACE 7.2.6, DREAMWEAVER, ORACLE 8I, PL/SQL, CRYSTAL REPORTS, VIGNETTE, and KORN SHELL. DESIGNER 2000, WINDOWS, PC, UNIX, SUN SOLARIS, and HP 700/800 UX 10.20.

Confidential

Position: DATA MODELER

• Designed logical data model for budgeting and invoicing applications.
• Met with users and gathered requirements.
• Prepared UML based visual data and process requirement models.
• Drew Object Class, Sequence Diagrams from user specifications.
• Wrote use cases for budgeting and invoicing.

Technical environment included: RATIONAL ROSE, UNIFIED MODELING OBJECT LANGUAGE UML SOLID, and WINDOWS NT.

Confidential

Position: SOFTWARE DEVELOPER

• Design and development of a medical support Enforcement application for government.
• Met with users and gathered requirements. Wrote system functional requirement documents.
• Designed and developed many UNIFACE screens.
• Designed and developed PL/SQL and C batch programs.
• Designed and developed EDI batch interfaces using Mercator mapping software.
• Designed and developed KORN Shell Scripts to drive the batch processes.
• Designed a Mail Box system to facilitate electronic exchange of transactional data between Third Judicial Court System and external clients insurance companies .
• Converted a number of UNIFACE 6.xx forms to UNIFACE 7.2.3 and programmed the new database and specification changes.
• Resolved performance problem of UNIFACE screens and reports and improved the application response time. Project resulted in a more timely collecting medical support for single parent children.

Technical environment included: UNIFACE 7.2.3, Oracle,

Confidential

Position: SOFTWARE DEVELOPER

• Design and development of an Automobile design and production tracking system.
• Met with users and gathered requirements.
• Wrote system requirements.
• Designed and developed many UNIFACE screens.
• Designed, developed, and maintained Help system, by writing a Bridge from Designer 2000 to UNIFACE.
• Designed and developed application last accessed data
• Designed and developed Error handling system.
• Presented designed forms to the customers for approval.
• Worked in different teams at the same time.
• Worked as QA and wrote test plans for many difficult screens. Project resulted in a very shorter time needed to build different cars because of sharing information and car designs.

Technical environment included: UNIFACE 7.2.3, Oracle, DESIGNER 2000, WINDOWS, PC, UNIX, and SUN SOLARIS.

Confidential

Position: DATA MODELER

• Designed logical data model of a customer call tracking application.
• Created standard for the physical data model.
• Created an Entity Relation Diagram and the data dictionary.

Technical environment included: ERWIN, SQL SERVER, and WINDOWS.

Confidential

Position: SOFTWARE DEVELOPER

• Worked as technical support for UNIFACE.
• Supported UNIFACE application model.
• Supported UNIFACE database drivers Informix, Oracle, Sybase .
• Helped the customer in redesigning, troubleshooting and debugging their applications.

Technical environment included: UNIFACE, INFORMIX, ORACLE, SYBASE, WINDOWS, PC, UNIX, and SUN SOLARIS.

Confidential

Position: SOFTWARE DEVELOPER

• Design and development of a variety of store system application.
• Met with users and gathered requirements.
• Identified and defined the retail business processes.
• Wrote system requirements.
• Designed and developed INFORMIX application.
• Wrote test plans.
• For a store wide monitoring project, act as liaison between Kmart project management and the IT vender Unisys project managers to ensure project priorities and goals are achieved.
• Performed system analysis and coordinated the participants to ensure communication among different application interfaces in Kmart store system.
• Functioned as part time DBA. Designed and developed many database views and store procedures for the system.
• Designed and developed a tool for impact analysis of database changes. This tool resulted in more accurate detecting changes to existing applications in Kmart store system.

Technical environment included: INFORMIX 5.0, PROJECT WORKBENCH, UNIX, HP 9000, RS 6000, UNISYS U6000/65, and PC NCR 3300.