BI Manager

Resume

Objective:

Detail and results oriented Project Manager with experience and proven

track record in managing technology and operations teams. MBA in project

and technology management with 10 years of hands on experience with

technical proficiency and management skills to work effectively in a team

and across cross functional groups. Background in technical areas including

proficiency in Oracle, SQL, .Net along with BI and project management

skills will provide effective and proactive leadership for organization.

Technical Skills:

Programming Visual Basic 6.0, C, C++, Java, C#, ASP, ASP.Net

Languages:

Web HTML, ASP, VBScript, Microsoft Front Page 2000, Macromedia

Technologies/Systems: Flash 5.0

Database Technologies ODBC, Oracle 8i to 11GR2, Access 2000, Microsoft SQL Server

/ Systems: 2000 to 2012, PL-SQL, SSRS, SSAS, SSIS, Data Warehousing,

Data Mart, Business Intelligence

Operating Systems: Windows 9x/NT/2000-2012, UNIX

Other: MS Performance Point, SharePoint (2010, 2012), MS Project

server, Crystal Report, Dash-boarding with Proclarity and MS

BI, Cognos, Oracle Hyperion

Certification Oracle (9i and 10g) DBA, MCITP(SQL Server 2000 & 2005 DBA

and Developer), PMP(In progress)

Experiences:

. ENI Petroleum (August 2008 to Present)

BI Project Manager

Lead the project to support the data warehousing and business

intelligence need for the company. Provide support to security and

disaster recovery process for organization. Create project plan and

implementation process from development to production with the plan

and documentations. Implement the best practice of user access and

support for the database project system. Responsible to Plan,

organize, and drive project throughout the project life cycle.

. Define project scope time to time, goals and deliverables

that support business goals in collaboration with senior

management and stakeholders.

. Prepared requirements analysis for the product in order to

create reporting tool and created System analysis and

technical design document for the new reporting tool.

. Worked with business stakeholders to define business key

performance indicators (KPIs) and develop semantic layers in

the BI tool to support these KPIs; advised power users of the

reporting tool on best practices for the BI tool and best use

of semantic layers; managed end-user access to semantic

layers of the BI tool.

. Provide project deployment and life cycle support for DB and

software system.

. Work in co-ordination with the consulting team to analyze the

existing flaws in the administration modules validation

procedure and created solution by implementing new validation

modules.

. Provided management support to the offshore/onsite End-to-End

integration/ Regression Test Team.

. Managed the reporting and analytics platforms to ensure that

scheduled jobs were successfully run and analytics data met

timeliness/completeness requirements

. Maintain work flow and budget requirement for project and

system.

. Support corporate planning of IT strategies and policies.

Skill Set: OBIEE, SSRS, MSSQL BI(2012), MS Projects, Visio.

. Spectra Energy (April 2007 to August, 2008)

BI / IT Project Manager

Lead the Data team through requirements, design and development

for a complete overhaul of the Business Intelligence system at an Oil

and gas company. Responsibilities throughout the full life cycle

included data architecture design, logical and physical data model

creation, requirements gathering and analysis for reporting and

operational capabilities. Provided support to implementing Data

Warehouse / Business Intelligence solutions and utilizing an extensive

portfolio of experience and best practices. Responsibilities included

conducting technical needs of reporting architecture, data

warehousing, Data transfer, and serving as a subject matter expert in

business intelligence concepts. Created and maintained company wide

Business intelligence environment including SSIS, SSAS, SSRS, and SQL

server 2005.

. Established cross-functional relationships and directed all

requirements gathering, data analysis and documentation for

enterprise projects to centralize data into one multi function data

ware house system with advance reporting processes.

. Assisted in developing business intelligence strategies in

coordination with data architect.

. Managed project management with scope of work, cost estimate,

budget, work force, resource management, and deliverance.

. Managed full life cycle development of business intelligence

systems for company.

. Provided support for Reporting services such as Analysis Cube

Processing, Reporting services Pro-Clarity.

. Coordinated with users and developers for all data models

techniques.

. Applied Improved team production and efficiency with cross training

along with best practice of project and team management process.

Environment Used: UML, OBIEE, Hyperion, SQL 2005 and 2008, .Net.

. The Planet (May 2006 to Jan 2009)

DBA Manager / BI Manager

Lead the Data team through requirements, design and development

for a complete overhaul of the Business Intelligence system at

company. Lead the team of DBA and Developer to provide maintenance

support and installed more than 20 instances SQL servers. Supported

migration from 2000 to 2005 SQL server environments. Performed all

aspects of database administrator, Database Mirroring, including data

modeling, backup, recovery, Disaster Recovery, OLAP processing for

Analysis services, and replication. Also provided support to design

and implementations of company wide disaster system for database

system, which includes Replication, Database mirroring, Log shipping

and Cluster environment. Provided support on CRM system for

implementation and maintenance. Create BI environment and provide

support to developers and users requirements. Help testing SQL server

2008 for future migration process and define process and document for

reference during transformation from 2005 to 2008.

. Work closely with application developers and business users to

design databases

. Create and maintain BI environment for groups and departments in

company.

. Helped group to configure Replication, Log Shipping, and Failover

clustering to meet customer needs for production environment to

development environment.

. Managed project management with scope of work, cost estimate,

budget, work force, resource management, and deliverance.

. Established cross-functional relationships and directed all

requirements gathering, data analysis and documentation for

enterprise projects to centralize data into one multi function data

ware house.

. Supported multi dimensional data modeling for data warehouse

system.

. Provided support to create better database architecture to support

business intelligence.

. Managed full life cycle development of business intelligence

systems for company.

. Schedule and Deploy schema changes, data conversion, data fixes and

packages throughout many different environments including

Development, System Test, UAT, Production, Training and several

others

. Lead a team of database developers in the extraction,

transformation, and load process from of a different file base

system to SQL base such as Access, Oracle, Excel, and flat files.

. Convert customer requirements into logical and physical database

designs and models.

. Created migration process from one SQL version to next.

. Create, modify, and maintain written documentation and modify

existing stored procedures, triggers, and views.

Environment: SQL Server 2000,2005 and 2008, Oracle 8i, 9i, & 10g,

SSRS,SSIS,SSAS.

. Home123(New Century Financial Corp) (September 2005 to May 2006)

Sr. Database Administrator / Developer

Database Administration experience as a Production and

Development DBA. Data Analysis: Architecting corporate data migrating

through transaction systems, OLTP and OLAP systems, Data Warehouse

systems into archival systems. Database Design: Data Modeling and

design. Database Design for referential integrity and performance.

Development of Business rules implemented as Constraints, Triggers and

or Stored Procedures. Experienced with EDI and markup languages.

Routine DBA activities: Backup and Data recovery, Data security, Data

Migration, Performance Tuning, Capacity Planning, DBMS monitoring,

Data Integrity analysis, User Management, and Log Analysis.

. Work closely with application developers and business users to

design databases

. Design databases using Visio and Erwin at the ORM, logical and

physical level.

. Implementation Batch processing Performance monitoring and tuning

SQL Trace / SQL Tuning Oracle Logminer Process automation.

. Oracle Fail Safe (High Availability) implementation and support

Database replication Data cleansing, extraction and monitoring SQL

Programming PL/SQL Programming Backup plans.

. Supporting Oracle 9i database system and optimizing the requirement

of the system.

. Storage re-arrangement and savings Oracle database security and

patching Oracle database capacity analysis and planning Archived

records Oracle database (data warehouse) implementation.

. Participate in the definition, documentation and application of our

Coding and Naming Standards.

. Provide support to developers/testers to resolve technical problems

with data and/or databases.

. Lead a team of database developers in the extraction,

transformation, and load process from of a different file base

system to SQL base such as Access, Oracle, Excel, and flat files.

. Convert customer requirements into logical and physical database

designs and models.

. Perform database maintenance and modifications to ensure databases

are operational, as well as diagnose and correct any database

environment problems; monitor database usage, and report on

database performance and system availability.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP,

ASP.Net, .Net

. Gyrodata Inc., (November 2002 to September 2005)

Database Administrator / Developer

Installed new MS SQL Server 2000 and maintained 10 to 15 servers.

Performed all aspect of database administrator, including data

modeling, backup, recovery, and replication. Additionally designed and

implemented disaster recovery system. Designed and executing Database

Transformation Services(DTS). Wrote Stored procedure and T-SQL code,

as well as VB and ASP codes. Also helped develop application and

coding in C# environment.

. Monitor MS SQL servers for errors and performance degradation.

. Creating Stored Procedure in T-SQL, Cursor, and Triggers for

database functionalities.

. Upgrade existing MS SQL Server software to newer versions and/or

Service Pack Levels.

. Set up alerts, operators, SQL Mail, SQL Agent Mail, and

notifications.

. Set up and schedule jobs that perform backups and database

structure checks.

. Develop reports for different department using SQL Server Reporting

Services.

. Created OLAP cubes for SQL Analysis Services.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP,

ASP.Net, .Net,C#, C++, COM

. Aramark Food Services, (July 2002 to November 2002)

Application Developer

Responsible for Team co-ordination for the project and delivery of the

project. Built web-based applications in ASP, which involved a Search

application, Report builder using Crystal Report 8.5 utilities. Wrote

Stored procedure and triggers in SQL 2000 for better performance of

large query in application. Also created web based reporting

application using java, Crystal Report, ASP, and SQL 2000.

Educational Background:

. University of Phoenix

MBA in Project and Technology Management (TM & PM) (December, 2010,

GPA 3.69)

. BS in Computer Science (December, 2001) from University of Houston

Personal Strengths:

. Highly organized and dedicated, with positive attitude.

. Able to handle multiple assignments under high pressure and

consistently meet tight deadlines.

. Thrive on working in a challenging environment.

. Able to work in team and individual.

Contact this candidate