SUMMARY

• Confidential is an IT professional with more than 14 years of experience in Information Technology focused in Data Warehousing.
• He is a results - oriented person and a decisive leader with proven success in management and implementation of different data warehousing solutions for top companies.
• Skilled in Data Warehousing Solution Architecture, project and delivery management including scope planning, schedule development, budget/cost control, change control and with strong communication, presentation and coordination skills.
• Equipped with 20+ data warehousing project implementation delivered in the last four years.
• Strong technical lead, capable of leading, implementing and designing end to end data warehousing solution.
• Solid ETL development experience using Confidential Tools and Utilities, Stored Procedures, Unix Scripting and other ETL tool like Confidential .
• With years of experience in database design and development in Confidential and Oracle.
• Experienced in various roles in different levels of the organization such as Associate Practice Lead, Delivery Lead, ETL Lead, Technical Lead and Senior Technical Consultant.
• Successfully managed and mentored 30-40+ data integration resources, overseeing daily activities, regular performance reviews, project staffing and practice development to ensure continuous growth in skills and utilization.
• Has worked in different industries including Telecommunications, Manufacturing, Banking and Insurance.

TECHNICAL SKILLS

• ETL Design and Development
• Application DBA
• Performance Tuning
• Project Management
• Delivery Management
• Practice Managemen
• Business Analysis
• Data Modeling
• Quality Assurance
• Production Support
• ETL/Database Architect
• Business Intelligence
• Teradata (SQL, BTEQ, Stored Procedure, TPT,FastLoad, MultiLoad, FastExport, TPump, DBQL, Visual Explain), Viewpoint
• Oracle (SQL, PLSQL, TOAD, SQL* Plus, Stored Porcedure, Data Pump, SQL Loader, Export/Import)
• Unix/Linux, Shell Scripting
• Microsoft Project and other project management related tools
• JIRA
• SQL Server Database
• Oracle Business Intelligence
• Enterprise Edition (OBIEE)
• Confidential
• Confidential Unity
• Trained
• ERWin
• Trained
• Hadoop 2.0
• Trained
• TD Aster Data 6.0
• Trained
• Project Manager

:PROFESSIONAL EXPERIENCE

Semantic Database Development and Tableau

Confidential

Responsibilities:

• Define the scope of the project in collaboration with client and senior management
• Create a detailed work plan which identifies and sequences the activities needed to successfully complete the project Determine the resources required to complete the project Develop a schedule for project completion that effectively allocates the resources to the activities Review the project schedule with senior management and all other staff that will be affected by the project activities; revise the schedule as required
• Determine the objectives and measures upon which the project will be evaluated Confidential its completion in relation to the statement of work (SOW).
• Responsible for the end to end project implementation
• Execute the project according to the project plan Set up files to ensure that all project information is appropriately documented and secured Monitor the progress of the project and make adjustments as necessary to ensure the successful completion of the project Establish a communication schedule to update stakeholders including appropriate staff in the organization on the progress of the project
• Review the quality of the work completed with the project team on a regular basis to ensure that it meets the project standards
• Implement project governance and control
• Create project status reports to be presented to the client and internal stakeholders on a regular basis.
• Monitor hours projections and report actual hours and variance to senior management on a regular basis (monthly/bimonthly)
• Manage all project funds according to established accounting policies and procedures Ensure that all financial records for the project are up to date Ensure that the project deliverables are on time, within budget and Confidential the required level of quality Evaluate the outcomes of the project as established during the planning phase

Project Manager

Confidential

Responsibilities:

• Provide oversight to risk modeling activities including data gathering, model review and recalibration.
• Ensure projects are completed on-time, within budget, and within client expectations for quality and functionality.
• Manage client acceptance of the solution and client expectations in line with the agreed statement of work.
• Manage day-to-day relationship with client stakeholders and resolution of all issues.
• Maintain and communicate project status to all stakeholders in reports and status meetings.
• Ensure proper set up of the engagement in the time keeping system, ensuring consultants and contractors are always current with their reported time.
• Produces project financial and status reports from PSA and EDW systems.
• Ensure monthly billings and timely collection of revenue.

Delivery Manager

Confidential

Responsibilities:

• Responsible for the design and implementation of various Data Warehousing solutions, specifically in the area of: o Technical Leadership
• Database design and development
• Physical Design and Implementation
• Logical Data Modeling
• Performance Optimization
• ETL Architecture and Development
• Confidential Tools and Utilities (BTEQ, TPT, Fastload, Multiload, Fast Export)
• Confidential Stored Procedure
• Confidential Project Delivery
• Team management
• Customer/PS communication & management Issues Management Risk Management Change / Rework Control Stakeholder Satisfaction Configuration and Release Management (if and as required in project)
• Testing and Defect Management
• Offsite Project Planning with regard to Schedule, Effort and WBS
• PSA administration Coordination
• Accomplishes project objectives by communicating team deliverables; monitoring project progress; managing team and individual contributions; conducting implementation reviews; preparing and completing action plans; tracking action items; examining, researching, and resolving or escalating issues; implementing production, productivity, quality, and customer-service standards; analyzing and resolving budget issues.
• Responsible for ensuring implementation of Project standards, processes, practices & templates
• Preparation of Project Documentation:
• Project Kick-off, Review of CTD, Estimate worksheet, Resource Plan, Risk Assessment
• Responsible for Project Close Out: Lessons Learned, Team Performance Appraisal
• Responsible for scheduling and conducting Weekly Project Status Meetings (with PS/Customer), Monthly Project Governance Meeting (with ADC Program Manager and QA, IS Manager), Steering Committee (SC) Meetings

Technical Lead Flextronics

Confidential

Responsibilities:

• Lead the team of 20+ ETL consultants.
• Ensures daily project execution, task distribution, issue management and delivery
• Participate in overall migration strategy together with the onsite counterpart and client.
• Provide technical guidance and assistance to the team.
• Provide assistance to onsite Project/Program Manager in creating project plan, schedule and estimates.
• Work closely with the client to overcome challenges, facilitate daily meetings and overall coordination.

Technical Lead/ETL Developer

Confidential

Responsibilities:

• Lead a team of four ETL Consultant.
• Manage overall communication with onsite team to discuss project status, issues, deliverables and timelines.
• Development and testing of TD SQL and Stored Procedure.

Confidential

Tools Involved: Teradata (SQL, BTEQ, TPT, Stored Procedure), Confidential Administrator, Unix

Responsibilities:

• Lead the team of two offshore DBA responsible for all database related task.
• Communicates directly to onshore counterpart to ensure project deliverables, issues, requirements and timelines.
• Conversion of SQL and UNIX scripts from Oracle to Teradata.
• Creation and maintenance of database objects (tables, views, index, etc.)
• Data migration from Oracle to Teradata.
• Performance tuning of SQL scripts and database objects.
• Provide assistance to Confidential developers for all database rela concerns.

Confidential

Tools Involved: Teradata (SQL, BTEQ, TPT, Stored Procedure), Confidential Administrator, Unix

Responsibilities:

• Design and development of database logical and physical structure to be used by the MicroStrategy (Semantic Layer) reporting.
• Develop and maintain BTEQ and UNIX script that loads data to the main fact tables.
• Work closely with the US counterparts/client to meet the design and development timelines and objectives.