OBJECTIVE:

• To lead and participate in an organization’s visionary, progressive and organic growth; Foster it in becoming a thought leader and competitive with strategic and innovative ideas with Business Intelligence and Analytical expertise.

SUMMARY:

• An Engineering Graduate with over 20 Years of information technology and industry experience having skills in the areas of Strategy, Project Management, Administration, Architecture, Consultation and Implementation of Business Intelligence, Enterprise Data Warehouse and Customer Relationship Management solutions.
• Having a strong knowledge of business processes, applications and technical architecture of large scale Business Intelligence, Data Warehouse and CRM systems in Telecom, Media, Entertainment, Manufacturing, Banking, Financial, Services, Processing, Logistics; expert in managerial and problem solving skills with excellent written and verbal communication skills.
• Collaborate with business unit executives, Business Intelligence (BI) and Customer Relationship Management (CRM) leaders to define and set strategic direction in the enterprise
• Assist the IT leaders in setting directions and processes to define BI solutions and develop strategic and tactical implementation plans
• Assist in identification of BI and CRM opportunities and the development of strategies for the management customer data. Develop roadmaps, solution architecture and define financials estimates. Provide support for the realization and execution of the defined strategies
• Assist the Operational leaders in setting up required tools and processes and to use data for improvement and that help decision making
• Assist program managers to communicate with end user customers on strategic goals and risks and issues on constraints
• 2. Program and Project Management
• Program management and coordination of the Customer centric Business Intelligence & Data Warehouse solutions using onsite - offshore delivery model
• Project planning and implementation following SLAs and deadlines, drive system development and implementing project work, defining and verifying business requirements, help develop system solutions to meet the business needs across various business units
• Requirement and resource planning, resources allocation and efforts calculation for the team to accomplish the meet the project scope, budget and timeline
• Hiring right individuals, evaluate performance and mentoring direct reports
• Execution, monitoring and managing customer projects; Define project tasks and works scheduling; Deliver management and reporting statuses of project deliverables and project plan
• Conduct QA programs to ensures high quality of the deliverables with continuous improvement process with the collected performance data
• Participate in the development of the organization's organic growth, developing required solution and help executing plans for the implemented applications

TECHNICAL SKILLS:

Industries/Verticals: Telecom, Media and Entertainment, Manufacturing, Process, Banking

Functional Area: Customer Relationship Management, Master Data Management, Supply Chain, Order Management, Purchase, Ad-monetization, Audience Measurement

Business Intelligence: BI Strategy, Roadmap, Gap Analysis, Business Case, Value Proposition

BI & DW Technologies: Information Management, Data Architecture, Data management, Cognos, Oracle OBIEE (Siebel Analytics), Business Objects, Informatica, Dimensional and 3NF data modeling, Oracle, Teradata, MS SQL Server, RedShift, AWS

Applications: Financials, Siebel CRM, SAP-BW, Salesforce

Project Management: Program and Project Management, MS Project, Primavera, Six Sigma

Advanced Technology: Big Data/Hadoop, Attribution Modeling, Cloud, Social and Mobile Engineering

PROFESSIONAL EXPERIENCE:

Advanced Technology and Information Management Director

Confidential

Responsibilities:

• Define data strategy to capture subscriber, location & demographics data from mobile usage to develop a scalable and flexible data architecture for multiple product development for external users (advertisers & marketers) and for internal usage (marketing and operations)
• Develop data and solution architecture for mobile usage
• Manage data management team for development, analysis in an onsite/offshore delivery model

Business Intelligence & Data Warehouse Strategy Program Lead

Confidential

Responsibilities:

• Identify business metrics for analytical reports
• Develop future blue print and solution architecture
• Assist in developing road map, effort plan & cost estimation
• Managing deliverables of approx USD 1M

Confidential

Project Lead - Strategy and Release 1 Delivery

Responsibilities:

• Develop a data architecture approach and recommendation
• Develop solution architecture
• Develop road map, effort plan & cost estimation
• Assisted in closure of sales approx USD 3M
• Manage onsite/offshore team for development of ETL, Report for the project
• Create project plan, resource allocation, cost & effort estimation
• Conduct client review sessions and weekly progress meetings
• Conduct quality checks on the project delivery and conduct health check on the delivered tasks

Confidential

Project Manager - BI and Data Architecture

Responsibilities:

• Responsible to manage the project plan for implementation of the BI reporting tool and Data warehouse team of 6~8 resources for about 3500 workdays, managing budget of approx USD 2M
• General project management activity - time, resource and effort management
• Own and manage the project work-plan, team work plan with activities and milestones
• Formulating high quality deliverables including guidelines for quality specified project deliverables and review process
• Keeping the key stakeholders involved and informed. Conducting review sessions with Business Architects, Sr. Execs and client team
• To manage project timeline, resource and client expectation in order to deliver high quality work product as deliverables.
• Update program team on the progress, risks, s and next steps
• Lead team to develop functional design document for 200+ on-demand reports including 60+ analytical / metrics reports
• Assisted client’s SME and project business analyst team to understand the usage and capability of the reports by conducting demonstration to various range of audiences and internal working sessions
• Lead team in creating the enterprise reporting architecture for more than 5 environments
• Lead team in Functional Report Design, Technical Report Design, Reports delivery
• Conduct Weekly Status to supervisor including hill climbing chart, significant completions, significant issues and risks, significant planned completions in upcoming weeks, and estimated completion percentages for reports, and estimated time to complete (effort and dates)

Environment: Cognos, Oracle, Data Architecture, Project Management

Confidential

BI Strategy and DW Architect

Responsibilities:

• Conducting assessment / analysis of current state for Information management environment
• Supporting senior executives in planning, facilitating workshops
• Developing future state BI / Information management environment blueprint
• Supporting the development of BI roadmap
• Defining and recommending BI Framework, Technical Architecture, Data Warehouse Architecture, Master Data Management, Metadata Management, Data Governance, BI Methodology and roadmap development In the implementation phase, the tasks accomplished are
• Developed and implemented the overall technical architecture of the data warehouse, from the backend hardware/software to front end tactical, reporting and analytical needs configuration.
• Assumed a leadership role in the design, structure and efficiency of the infrastructure, both current and future, supporting the enterprise data warehouse and business intelligence system, as well as to meet the operational requirements and business needs.
• Represented BI department towards project teams producing design, architecture, and set up of the infrastructure.
• Created a technical architecture review process and implement the process for the BI projects that needs to be governed by the ITAO.
• Assisted in planning and implementation of this infrastructure for development software (ETL, data warehouse architecture, presentation layer) plans and decisions regarding interoperability, performance, support, and any risk or opportunity that will impact organizational effectiveness.
• Reviewed all current environments for consistency of deployment and provide recommendations and a deployment plan that ensures infrastructure best practices implementation, leveraging best practices methodology, metrics to be developed and deployed from Dev through Production environment, which will result in capacity planning information for all development, testing, pre-production and production environments to ensure the technical environment is in sync with enterprise requirements.
• Provided proper knowledge transfer to impacted organizations of proposed change, and additionally provide highest internal level support to the all the related IS groups over operational maintenance including administration, patching, tuning.
• Reviewed, analyze and enhance the current infrastructure data warehouse strategy
• Defined and designed the technical architecture components that needs to be delivered to support development, execution and operational environment for manufacturing, sales, marketing, finance etc
• Defined, designed and assisted in conceptual, logical and physical data warehouse architecture for integrated Enterprise Data Warehouse
• Defined and implemented technical data and other development standards, naming convention, data security etc
• Developed methodology for infrastructure analysis, design and deployment support

Environment: Oracle, Cognos

Confidential

Onsite Lead and Program Manager

Responsibilities:

• Project management, planning, implementation and coordination of integrated banking and brokerage data warehouse development using onsite-offshore delivery model
• Responsible to deliver two Business Intelligence and Data Warehouse projects
• Set scope, timeline, cost and efforts for the projects for 5 resources onsite and 70 resources offshore with budgets $ ~1-2 MM
• Lead creation of project deliverables using project resources and work closely with the delivery team to ensure progress from initiation phase to support phase though follow up, setting expectation and status meeting
• Complete project definition, including key deliverable, project charter, problem statement & opportunity, communication plan, status reporting, financial plan and tracking, risks and issues, and roadmap for project plan (key milestones)
• Review development plans, testing & system integration plans, implementation plans, support plans and deployment plans to prepare successful deployment
• Plan and lead team meetings, including business stakeholders; Communicate status and escalate issues to executive sponsors, update and review project and program risk matrixes
• Review and approve project plans, budget forecasts to optimize budget and productivity
• Conduct project quality audit reviews and oversee quality of deliverables to ensure high quality results are achieved
• Maintain positive executive client relationships to maintain client support and funding

Environment: Teradata, Oracle, Informatica

Confidential

Data Warehouse Architect

Responsibilities:

• Assisted in conducting BI readiness assessments, creating management procedures, BI Standards, planning, and implementing the Data Warehouse design and infrastructure as a part of Data Architecture team.
• Conducting discussions, requirement and source systems analysis with key business analysts, client service managers and end users to identify requirements and data sources.
• Creating the high-level subject area diagram, the logical data model and physical data warehouse model, sizing estimates, defining ETL standard and strategy.
• Point-to-point data integrity test, data collection rates, volumes, storage volumes and growth rate of the warehouse.
• Project design review and production roll-out following the Six Sigma process. Project implementation following strict SLA's using onsite-offshore delivery model.

Environment: Cognos, Teradata, Oracle

Confidential

BI Architect

Responsibilities:

• Requirement analysis, design and development of OLAP, drill-down, rollup and static reports for financial reporting system
• Administration of reporting environment and publishing cubes and reports on web using Cognos BI tool.

Environment: Cognos, Teradata, Windows & Unix.

American Standard Reports

Data warehouse Architect

Responsibilities:

• Design, architecture and development of logical and physical financial data warehouse system.
• Defining strategy and assisting in transferring legacy data from different sources to the data warehouse using Erwin, Informatica, and Cognos.

Environment: Cognos, SQL Server, Informatica, ERWin, Windows

Confidential

BI Architect

Responsibilities:

• Develop reporting catalogs, user reports and cubes, report administration
• Publishing developed reports and cubes in the web in the production.
• Developing and maintenance of the reporting portal using Cognos web and integrating it with the company portal.

Environment: Cognos, Oracle, Informatica

Confidential

BI Architect

Responsibilities:

• Design and development of the logical and the physical data warehouse.
• Assist analytical reporting business analysis and development of Cognos Powerplay Web & IWR BI application components.
• Develop strategy and technical deployment approach for linking Powerplay Web components into the client's Portal.
• Assist administrative support of Cognos Powerplay Web and Impromptu Server components. Security management using Cognos administration.

Environment: Cognos, Oracle, Informix, DataStage, ERWin

Confidential

EAI Consultant

Responsibilities:

• Consultation on the EAI subsystem to meet the requirements of the web and internet based logistics system for the e-commerce solution.
• Mapping and integrating existing logistics system with the EAI Subsystem. Configuration of the EAI Subsystem using Mercator.

Environment: Mercator, Oracle

Confidential

Financial and Business Intelligence Report Consultant

Responsibilities:

• Analyzing requirements, evaluating the 'AS IS' and 'TO BE' scenario, determining the gap analysis.
• Designing and evaluating the Chart of Accounts for Financial Accounting, AR, AP, GL, Fixed Assets and Budgets module.
• Implementation, consultation, customization of the CODA-Financials for specific business process requirements.
• Assistance in transfer of legacy data to the implemented CODA-Financial. designing and evaluating the Data Warehouse and Data Marts for Financial Accounting, AR, AP, GL, Fixed Assets and Budgets module and designing the process model for reporting and ETL using Cognos and Oracle.

Environment: ERP - CODA Financial Accounting System, Oracle, Cognos

Confidential

ERP, Financial Software Consultant

Responsibilities:

• Analyzing requirements and evaluating the ‘AS IS’ and 'TO BE' scenario, determining the gap analysis.
• Designing and evaluating the Chart of Accounts for Financial Accounting, AR, AP, GL, Fixed Assets and Budgets module. Implementation, consultation and customization of the CODA-Financials.
• Setting up Chart of Accounts, Posting Documents, Accounts Receivable, Accounts Payable, General Ledger, Pay Process, Credit Management system, Intercompany Transactions, Fixed Assets and Budget modules.
• Assistance in transfer of legacy data to the implemented CODA-Financial. Design and development of financial reports.
• Consolidation of the CODA-Financial databases from 11 group companies into corporate of Confidential Group across different location/sites and infrastructural environment.

Environment: CODA - Open Accounting System, Oracle, Sybase, Platinum Inforeports

Confidential

MRP-II Software Developer

Responsibilities:

• Developed Confidential comprising of GL, Inventory for finished goods and raw materials, Order processing, BOM, Invoicing, AP & AR

Environment: Visual Foxpro

Confidential

MRP-II Software Developer

Responsibilities:

• Developed and implemented an integrated material requirement planning system for PO requisition, purchase order, procurement, production planning and quality assurance modules.

Environment: C, C++, Btrieve