SUMMARY:

• Data Enterprise Solution Architect/Data Modeler/Data Integration/Big Data Enterprise Data Warehouse/Integration & Development/ ETL/BI/Business & Data Analyst/Data Governance Lead - consultant expert with over 23 years of experience directing teh implementation of critical application integration, master data project management and enterprise reporting projects with an outstanding record of delivering projects on time and within budget.
• Provided direct leadership and is teh main contact point for IT project prioritization and execution.
• Hands on experience in coding, analysis, data modeling design, development, deployment, testing, enhancement and maintenance of operational systems.
• Projects include data integration, data migration from legacy systems and across cross platforms Oracle, MySQL, SQL Server, PostgreSQL Informix, metadata management, MDM Customer Domain Expertise with tool selection and Functional capability to run workshop and requirement gathering Sessions, data architecture and data quality, data lineage, data mapping, data synchronization.
• Implemented large and complex enterprise data warehouses using star and snowflake schemas creating data access layer, data translation layer, operational data stores and data marts. Full system development life cycle included project planning, organization, management, implementation, infrastructure architecture and budgeting. Experience working in medium to large organizations with enterprise systems, enterprise information repositories, and enterprise databases with possible several lines of business.
• Designed and reverse engineered enterprise systems using multi-dimensional (Ralph Kimball’ and Bill Inmon’ approach), OLTP and OLAP systems, metadata modeling.
• Architected water fall model for data warehouse archive/replication at a point in time for data retention and faster querying for historical data.
• Designed and Architected a Data Synch Product (DB Synch) for CRM Systems using C language and Database Oracle, Sybase and Informix for backend.
• Domain expertise with FCC regulations (Telecom), FDA regulations (Healthcare) and FAA regulations (NASA Ames) including SOX compliance.
• Handled large volume data warehouse to teh tune of 18+ terabytes on NAS storage systems with total volume of 40+ terabytes growing monthly to teh tune of 1+ terabyte.
• Experienced in performance tuning at database level, design changes, adding SQL hints, using PL/SQL Hierarchical Profiler, splitting source data into multiple threads, parallel target loading, bit mapped indexes, database parameter changes and modifying SQL.
• Demonstrated ability to support multiple concurrent projects or initiatives and to deal with conflicting priorities. Managed Operational Systems working 24/7.
• Build a team aligned on vision, strategy, goals and individual roles dat is focused on achieving desired results. Foster relationships with key Sr. stakeholders both business and IT. Played a Strategic Role at NASA, Confidential (AT&T) and Confidential . Infrastructure architecture and software setup for different environments in data centers.
• Lead cross-functional dialogue through collaborative and inclusive approaches to define overall vision, strategies, goals and tactics for Information within teh client. Presentations to senior management on architecture, team members on projects/technical training and business units on systems.
• Conducted in-house and client training on software applications and tools/software used. Mentoring experience in a lead capacity. Excellent customer facing capabilities for requirement gathering, model reviews, presentations and senior management interaction.
• Designed/Re-architected projects amounting to company savings to tune of 1+ Million dollars/year.
• Provided recommendations and/or best practices on design and development of teh MDM sub-system, including hub design, and API services and data synchronization with non-MDM data stores.
• Continually regulate and validate Analytics and KPI as business climate and expectations evolve.
• Establishes and maintains teh request policies and controls to protect data and ensure compliance on privacy regulations and legal reporting requirements on a global basis.
• Designed and coded an ETL framework from scratch using bash with MySQL database for metadata.
• Worked on State and Federal Projects with security clearance at NASA project.
• Conduct Corporate Computer Training/Course for Companies on different computer Programming Languages. Teaching sophomore and high/middle school students Math, Science including AP on weekends. Teaching Snap, Scratch, and Java at a Computer Institute Part time. Excellent Presentation and Teaching skills.
• Evaluated and configured Products for companies launching new Integration products/tools in AWS Cloud Environment.

SKILLS PROFILE:

Languages: HIVE HQL, PL/SQL, JAVA using Eclipse, XML, XSL, Pro* C, C, ESQL/C, dblib, Visual Basic, SQL*Plus, Documentum Content Management 4i - Doc basic, Perl, bash, shell scripting, SAS Enterprise, Python with Pygame, Snap, Scratch

Data Modeling: CA Erwin Data Modeler, Power Designer, TOAD

Operating Systems: HP-UX, Sun Solaris, UNIX, Linux, Windows, VAX/VMS, Mac OSX

Tools: TOAD, SQL Developer, SQL Navigator, Test Director, Visio, Power Point, Oracle Enterprise Manager, Informix ACE Report Writer, SQL*Loader, Explain Plan, Import/Export, MS Project, MS-Office, Crystal Report Writer, BRIO Portal, PVCS- Dimensions, NIKU, PGP, SAS adapter for IBM Data Stage, SharePoint, JIRA, Confidential Data Trek, Bodhi, Code Search, VMware, TOAD Data Point 3.7 for Data Compares.

Methodology: Velocity - Informatica 9.0, SDLC, Waterfall, Agile.

ETL/MDM Tools: Informatica Power Center, Information Analyzer, Informatica Data Quality & Profiler, IBM Data Stage, Meta Stage, Quality Stage and Data Profiler, bash, PL/SQL, IBM Information Server-MDM, SAS Enterprise 5.0, Python

Confidential /Medicaid Data Architect/Application Developer/Mapper

Consultant Business and Technical - CA

• Responsibilities included working on teh Staging Data Model for Medicare System for teh State of Delaware and migration of 10 years of Data from Legacy to Oracle.

Environment: Oracle, Erwin Data Modeling, Toad Data Point, Informatica 9.2, UNIX Shell Scripting

Confidential - Solutions Architect 

Risk Analytics - Minneapolis, MN, Charlotte, NC, and SF, CA

• Responsibilities included working on teh Meta Data Model for Anti Money Laundering Actimize and SAS System.
• Worked with Anti Money Laundering Products and Programs for Data Lineage and Reports for Federal Compliance (FCP).

Environment: Oracle 11g, SAS Enterprise 5.0, Actimize, DB2, Ab initio, Metadata Exchange, Informatica, Erwin Data Modeling, UNIX Shell Scripting .

Confidential - Menlo Park, CA

Data Engineer/Pipeline Application Developer

• Responsibilities included working on maintenance of Existing Data Pipelines for online and in store ad campaigns allowing for real time bids.
• Worked on Sales Force Data Pipeline for BI Analytics.
• Worked on Meta Data Pipeline for extracting meta data for poor performing Data Pipelines.

Environment: Oracle 11g, Hadoop HDFS, Hive Query Language (HQL), MySQL, fbetl ( Confidential ETL) Python based framework, Chronos (Scheduler).

Confidential - San Jose, CA

Data Enterprise Architect /Data Scientist/Data Migration/Modeler

• Responsibilities included Modeling History Services Model for Payments from existing OLTP to OLAP model using Ralph Kimball Approach.
• Worked on Mapping History Services mappings with onshore offshore model and training people with teh process of Mapping Source to Target.
• Worked on Merchant Reporting System for new Model changes requirements governed by federal regulations for monthly statements.

Environment: Oracle 11g, MS SQL Server 2008, Power Designer, SharePoint, Power Point, Visio, Confidential Home Grown Tools include Data Trek, Code Search, Bodhi, Informatica Power Center 9.0, Golden Gate, HDFS, HIVE, Map Reduce using Python, CDC

Confidential - San Leandro, CA

Project Lead / Data Migration Architect

• Project Lead for 50 onshore and 70 onshore developers and QA for Migration efforts of data from Wachovia (SQL Server) to Confidential (Oracle).
• Worked on BRD’s, CR’s, Code Review and Performance Tuning of Code for releases.
• Created Reports for business users published by SSRS by release.

Environment: Oracle 10g, Informatica Power Center, Autosys, Erwin, SharePoint, Power Point, Visio, UNIX shell Scripting, Microsoft SQL Server, SSRS, SSIS, Informatica 9.0

Confidential - Moffet Field, CA

Data Architect / Data Modeler/Project Lead/DBA Infrastructure/Application Developer

• Air Traffic Management Project lead (to reduce taxing times) with a team size of 20 includes intern developers, UNIX and database administrators, and research scientists.
• Responsibilities included leading NASA’s Air Traffic Management System for all commercial flights from all airports from design (Data Modeling, Volumetric, Partitioning, Encryption and Hashing) to support from PostgreSQL to Oracle using Java front end product SODAA (Surface Operations Data Analysis and Adaptation) - Bill Inmon Approach.
• Created Bash Frame Work for scratch understanding NASA’s requirements and working with researchers and senior management.
• Installed and maintained databases and created MySQL metadata model for storing technical metadata for tracking process workflows.
• Responsible for Migrating initial and incremental data and worked with Infrastructure teams for recommendations for NAS Servers.
• Air Traffic Management System NextGen - Ralph Kimball Approach Near Real time weather data warehouse from different sources and streams in landing zone to data marts.
• Storing unstructured binary weather data in blobs and using Web Services through API for parsing and analyzing data. Large initial data volumes to teh tune of 18+ terabytes volume are loaded in separate data marts with monthly volumes of 1+ terabyte.
• Using bash Framework for renaming archive data and storing on landing zone to insert in Data Marts.
• Linux sources files from airports are synchronized on Ames Servers using rsync and landing zone files in Ames data center are also synchronized to DFW servers using rsync.

Environment: Oracle 11g, Bash, Perl, PostgreSQL, SharePoint, Power Point, Visio, MySQL, PL/SQL, Oracle Data Guard, UNIX Shell Scripting

Confidential, Novato, CA

• Worked as Product Design Specialist for Enterprise Wide Tool Selection, Configuration on different platforms and POC’s.
• Maintained Claims Data Warehouse using IBM Data Stage Tools and connectors for Meta Data.
• Used Informatica Tools for Data Cleansing and Matching for Customer and Product hierarchy for MDM hub data closely working with data governance teams.

Environment: DB2, SAS, IBM InfoSphere Data Stage 7.1.3, Quality Stage 5.0, Meta Stage 5.0, Data Profiler, All Fusion Erwin Data Modeling 7.2, Informatica Power Center, Informatica Scheduler, Informatica Data Quality, MS Project, IBM Web Sphere- Information Server-MDM - Customer and Product (PIM)

Confidential, La Jolla, CA

• Architected Informatica Tools on Different servers (Dev, UAT, SIT, Prod) using versioning in production servers.
• Responsible for migrating large initial of experimental data into fact tables using performance tuning like source and target partitioning, changing parameters, and splitting mappings.

Environment: Oracle 9i, Toad, HP - UX, Sun Solaris, Informatica Power Center Advanced Edition (AE) 7.1.x, Power Analyzer, Informatica Data Profiler, Informatica Scheduler, Erwin Data Modeling

Confidential, San Francisco, CO

Project Engineer/Developer

• Responsibilities include integration of RETEK Merchandising System (RMS) and RETEK Customer Order Management (RCOM), migration of data for RCOM module from AS400 to Oracle 9i for Confidential ’s nine brands and creating reference and foundation base data for teh HE (Hold Everything) concept including business functionality testing of teh module, batch processing, publish and subscribe messages over teh RIB, using Pro*C, SQL and shell scripting.
• Involved in Production Support for RCOM and RMS and customer monthly loads to RCOM. Worked with offshore team for business requirements.

Environment: Oracle 9i, PL/SQL packages, UNIX scripting, Toad, Pro*C, XML, See Beyond, PVCS- Dimensions, NIKU, Sun Solaris

Confidential, Birmingham, AL

ETL/Solutions Architect/Project Lead Engineer/Application Developer

• Project lead with a team size of 25 includes Developers, QA team, run team, Business team, Reporting Team and UNIX and database administrators.
• Responsible for Redesign of Data Warehouse and Data Marts for SQL Reporting for measuring Confidential ’s performance compared to CLEC using Consolidated Data Marts.
• Created Raw Data validation Scripts for validating source and target validation for pre-ordering, ordering, maintenance and repair subject areas.

Environment: Oracle 9i, Erwin Data Modeling, IBM InfoSphere Data stage, PL/SQL packages, UNIX scripting and cron, Visio, Toad, MS Access 2000, Oracle Workflow 2.5, Test Director, Sun Solaris, Windows XP.