SUMMARY:

• Over 25 years of experience in Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle.
• Expertise in Confidential WebSphere DataStage/QualityStage 9.1 and Informatica 9.6 releases.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements.
• MDM data analysis of data dictionaries and elements
• Have created database Indexes and Aggregate tables for data warehouse performance tuning.
• Data Processing experience in architecting, designing and implementing Data Mart applications, mainly transformation processes.
• Designing and developing jobs using ( Confidential ) DataStage Designer, Informatica PowerCenter.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Use of Confidential Business Glossary, and data governance principles.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, and DB2, Sybase, XML and Flat files into the staging area.
• Proven track record in addressing production issues like performance tuning and enhancement.
• Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models.
• Experience in dimensional and relational database design.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Excellent with PL/SQL, Stored Procedures, Database Triggers and SQL * Loader.
• Experience in UNIX Shell Scripting.
• Excellent knowledge of operating systems Windows, UNIX, and databases including Oracle, SQL Server, and DB2.
• Experience in implementing Quality Processes.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT, Windows 2000/XP7/10, UNIX, Solaris, HP - UX, AIX, LINUX, Confidential Mainframe, Amdahl, Teredata DBC, AT&T 3B, Quantel

Development Tools: SQL/Plus, T-SQL, Erwin Data Modeler 7.3, 8.1, Informatica 5.1,6.1,6.2,7.1.1, 7.2, 8.6.1, 9.1.0,9.5.1 w/PowerCenter-PowerMart, Data Analyzer, PowerExchange 9.1.0 Informatica Security Administration, DVO, MDM, BrioQuery 6.x, Informix SQL, TOAD 10.6, Data Mining w/SQL Server 2000, UNIX w/shell programming C & K, COBOL, FORTRAN IV & 77, PL/1, TSO, REXX, EXEC & EXEC2,, JCL, TestDirector 8.0, JAVA 1.2 (training only), SAS, Tableau, HTML, QBAL, SuperStructure, C, Trillium, SSIS(limited), Data Stage & Quality 9.1, Talend Open Studio 5.3

Databases: Oracle 8i,9i, 10g,11g, Teredata 13, SQL Server w/Enterprise 2005/2008, DB2, Informix 4GL, Informix, System 2000, SAP, ACCESS, FOCUS

Ancillary Skills: Microsoft Office (Word, Excel, PowerPoint), Data Mapping, Microsoft Project, Visio, Crystal Reports, Windows Script

Methodologies: Velocity, Agile, Object Oriented (OOP & OOD), CDM, SDM, PRIDE, ISPP, CMM, UML, Data Governance

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

Data Specialist

Responsibilities:

• Provided day-to-day data integrity in all relevant information systems to internal program staff and Executive Management Team.
• Experienced in Statistics, Business, Data Analyst or Research Analyst and similar functions
• Working in Private, Commercial and Government Sectors.
• Using Microsoft Office Suite, Database development, queries, and data analysis for reporting and Quality improvement purposes.
• Using Organizational Skills and ability to develop processes to improve workflow.
• Using skill to problem solve, attention to details and multi-task effectively, and meet deadlines in a fast-paced environment. Excellent written and verbal communication skills, ability to establish rapport.
• Ability to motivate others towards achieving goals.
• Ability to work independently with strong sense of focus, task-oriented, nonjudgmental, open personal qualities, clear sense of boundaries.
• A strong sense of and respect for confidentiality involving both clients and fellow employees. Ability to work in a variety of settings with culturally-diverse families and communities with the ability to be culturally sensitive and appropriate.
• Ability to legally operate a motor vehicle and provide own transportation.
• Communicate effectively both verbally and written.
• Adhere to agency policy, procedures and the professional code of ethics.

Confidential, United States, Nashville, TN

Data Specialist

• Mapping data fields into new data warehouse.
• Was liaison between Business and Systems Analysts, Developers and project/development groups.
• Had to ensure that the deliverables align with business requirements with measurable results.
• Data evaluation of EDI 837 Health Care Claim foreign feeds.
• Assisted Quality Assurance Team in defects and quality specifications.
• Using Tableau as data validation. Helped business users in defining User Acceptance Testing, test cases and plans. Agile/Scrum development used.

Confidential, San Jose, CA

• Responsible for modeling and mapping data fields from legacy systems to target systems. Working with the legacy teams and the business in helping define and develop business rules, value maps, Source to Target Data Mapping documents and assisting ETL Development Team in development activities. Using Informatica’s tool set of PowerCenter and Quality tools.
• Specializing in Customer Care (Retail, Business, and CLEC). Knowledge of Financial Products, Services & Equipment. Experience with Data Profiling using SQL and other methods. Solid understand of data analysis techniques or processes. DB2, Oracle, UNIX, knowledge Informatica, Talend or other ETL tool experience. Experienced level SQL programmer. DB2 experience and Work on OracleSQL Queries, Stored Procedure, and Oracle Data dumps.
• Responsible to analyze, verify, and validate artifacts and deliverables, procedures, and processes; regularly providing risk assessment and other feedback to management to mitigate risks, identify and address gaps, and recommend improvements throughout the Software Development Lifecycle (SDLC) ensuring a consistent optimal level of quality for all deliverables. Verifies the quality of the source code, via inspection, manual testing, automated testing, using tools, creating test files, creating test cases and inspecting test results.

Confidential, US

• Solution/Architect for a new ETL framework for the DMDC. Then designed and developed the code which will be the backbone of the personal data integration. Using Confidential ’s tool set of Business Glossary and Datastage. This project was located in Seaside, CA.
• Part of the LOGSA develop team to provide timely and integrated life-cycle logistics information, knowledge and expertise in support of Warfighters globally to meet full spectrum operational requirements.
• Concentration on design/development of a Data Vault. Which is designed to provide long-term historical storage of data coming in from multiple operational systems. It is also a method of looking at historical data that, apart from the modeling aspect, deals with issues such as auditing, tracing of data, loading speed and resilience to change.