EXPERIENCE SUMMARY:

• Highly skilled, self - motivated IT professional with 12 years of Data Architecture and Molding for Data Warehousing application. Experienced in complex large scale projects with full systems lifecycle development from requirements gathering through implementation of various functional architecture solutions.
• Self-starter and proactive. Ability to work independently with minimal supervision
• Experience in CMMI Level 3 process, PMP, Agile, ITIL Methodologies.
• Focus on customer satisfaction improvement.
• Achieve aggressive schedules.
• Solid SQL and technical skills.
• Multi-tasking and complex problem solving.
• Continuous process improvements.
• Quick adaptability in terms of tools and new work place.
• Managing offshore resource.
• Multiple Data Warehouse project implementations
• Architecture Logical and Physical data models using Embarcadero, ERwin Tools
• Solid Understanding of Big Data concepts
• Data Governance, Data Quality, Data Accuracy and Meta Data
• Data Warehouse, MDM, Data Mining Design
• ETL Tools: Informatica, Data Stage
• Reporting Analytics / BI Architecture Cristal Reports

TECHNICAL SKILLS:

Data Modeling: Embarcadero, ER/Studio, ER Win, Power Designer, VISIO, Rational Rose

Data Base: Oracle 10g, DB2, Natezza, TeraData, SQLServ, MS Access, MySQL, SQL Workbench

BI Tools: MicroStrategy, Cognos, Business Objects

ETL: Informatica PowerCenter, Data Stage, OLAP, OLTP, MS-Office tools, BMC

Reporting: Cristal Reports, Remedy, BMC Atrium, Service Now

Prog. Lang: COBOL, JCL, FILE-AID, ENDEVOR, Java, Unix scripts

WORK EXPERIENCE:

Confidential, Boca Raton, FL

Data Warehousing - Data Architect

• Confidential provides security protection for homes and business buildings. It is rapidly growing by expanding the business in many states and buying and merging small business units. Extract and populate data for new business units for integrated reports and analytics.
• Work with multi-technology and cross functional teams, gather requirements
• Create technical designs for Conceptual, Logical and Physical data models
• Create dimensional data warehouse, data mart models Inmon top down approach
• Develop and maintain architecture standards, principles and guidelines
• Generate and execute DDL scripts and static data
• Develop specs for source to target data mapping for ETL processes
• SQL query performance tuning, Indexing, Partitioning and database performance
• Database Development and support activities - DDL, DCL, and DML on database objects, create or modify - views, triggers, procedures, functions, packages creation
• Develop and maintain a customer-focused relationship with business stakeholders by exhibiting a high level of collaboration, timely communication and responsiveness

Environment: & Tools: Embarcadero, Informatica Power Center, Oracle, Informatica DQ, SQL Workbench, Unix, Visio, VSAM, DB2, Business Objects, MS word, Excel, Outlook, Power Point

Confidential, Bentonville, AR

Data Warehousing - Consumer Knowledge Platform - Data Architect

• The Consumer Knowledge Platform (CKP) project is initiated to collect consumer details which are stored in various data repositories into a central customer master data repository. Customer information will be gathered from various data sources and 3rd party data. The CKP is to provide a single view of customer information for OMNI channels and for Business Analytics, Business Intelligence, and Customer Experience Management.
• Analyze Business functional requirements and work with technical team to come up with a design approach to provision data.
• Create technical designs, data models and data migration strategies
• Create dimensional data models, data marts using
• Develop source to target data mapping document for ETL processes
• Design and build maintain logical and physical databases, dimensional data models, ETL layer design and data integration strategies
• Facilitate sessions with business and technology stakeholders to define and implement actionable metrics, key performance indicators (KPIs) and data visualizations to support the reporting needs.
• Lead technical design and implementation of role-specific dashboards and ad-hoc reporting capabilities using rapid business intelligence tools such as Tableau

Environment: & Tools: ER Win, Visio, Oracle, DB2, VSAM, Hbase, Hadoop, Netezza, MongoDB, Data Stage, JAVA, MySql, Hive, Clear Case, Power Point, Business Objects

Confidential, Phoenix, AZ

Data Warehouse Enhancement - Data Architect

• Analyze existing system and perform reverse engineering of physical data models from databases and DB2 scripts
• Evaluate data models and physical databases for variances and discrepancies
• Validate business data objects for accuracy and completeness
• Create technical designs, data models and data migration strategies
• Produce prototypes to demonstrate workflow, logical processes, systems interfaces, and algorithms
• Implement data quality, data integrity, and data standardization efforts across key products and databases
• Developing data mapping, data dictionaries and metadata documentation

Environment: & Tools: ER Win, Visio, Informatica, MicroStrategy, Oracle, VSAM, DB2, Teradata, MySql, Hive, MS word, Excel, Clear Case, Outlook, Power Point

Confidential, Phoenix, AZ

Configuration Management Data Base - Project Lead

• Defining CMDB policies, procedures and processes
• Define Asset & Configuration Management scope
• Gather Enterprise CMDB requirements by arranging various meetings with cross department system owners
• Define CIs for discovery tool: TADDM and validate data
• Work closely with IBM cCMDB team in validation and installation
• Integrate hardware CIs such as Servers, Printers, Work Stations etc., and map with applications
• Populate CMDB with critical application CIs and map with their dependency CIs
• Create Audit plans and procedures and executed on monthly basis
• Conducted numerous training sessions to all stakeholders
• Validate servers and eliminate or reuse

Confidential, Detroit, MI

CMDB - Configuration Management Data Base - Project Lead

• Define Configuration Management scope
• Gathered Enterprise CMDB Configuration Items (CIs)
• Analyzed CMDB tool: BMC Atrium and make recommendations
• Created CMDB logical and physical data models using ER Win
• Created CM Process, Procedures and work instructions
• Created Audit plans, generate reports and conduct meetings on timely basis
• Created Asset Management requirements
• Gather initial assets and load into Remedy RAM
• Created physical asset audit plans and conduct the audits
• Validated Software Licenses reusability and expiration dates to avoid penalties

Confidential, Detroit, MI

GM Service Parts and Operations Transition - Project Coordinator

• This project is for transition of Service Parts and Operations DBA day-to-day activities from EDS to IBM/ACS. The DBA transition includes both mainframe and midrange databases, which are DB2, IMS, Oracle and Sybase.
• Established DBA team.
• Developed an effective Project Plan and project schedule.
• Identified project risks and created mitigation plans.
• Facilitated knowledge transfer meetings.
• Communicated project status to Executives.
• Ensured teams duties and responsibilities are understood by everyone.

Confidential, Detroit, MI

Production Support Lead

• GM Billing system consists of five sub-systems which are Billing Cycle, Pricing, General Ledger, Incentive Cycle and Tie-In systems. Responsible for maintain and enhance as needed.
• Managed team of 12 senior people by assigning on-call duties and customer adhoc request.
• Report nightly-cycle status to the GM Executives on daily basis.
• Conduct Defect Prevention meetings and issue service request (SR) to service delivery team.
• Prepare on call team to proactively respond on production issues.
• Exceeded Service Level Agreement (SLA) on On-Line availability batch cycle completion.
• Involved in hiring, annual reviews, recognition and firing processes.
• Created production support manual with detailed description.
• Reduced abend rate from 20 per week to 3.
• All adhoc projects were delivered on time & within budget with 100% QA audit rating.

Confidential, Detroit, MI

Master Data Management - Data Architect

• This project is to have a centralized, consolidated repository that serves as the authoritative source of master data. Data in this repository is consolidated from multiple sources, cleansed, and de-duplicated. Business rules and logic to transform data is applied. My responsibilities were:
• Analyze source systems and document business needs to develop Use Case models
• Design program specs and workflows by having numerous meetings with customers
• Design business rules and write program specifications
• Extract data and apply business rules to validate data
• Data validation and Governance before loading data
• Provide technical assistance to the team members
• Create solid documentation for maintenance procedures
• Continue supporting the system after implementation