Makarand Jog Los Angeles, CA, USA Work Visa Type: E-3

Skype ID: makarand.jog ~ Cell: 323-***-**** ~ E-Mail: acvs71@r.postjobfree.com

A Professional Business Intelligence Architect/Lead (Consulting) with more than 12 years of experience particularly in data analysis, data modelling and ETL project delivery. Consulted for Global MNC’s, Fortune 500 companies and Government organisations.

Achievements include leading projects related with advanced analytics, decision support, analytical and performance reporting, operations and customer relationship. Insightful knowledge of business process analysis and design, re-engineering, process rationalisation, cost control, capacity planning, performance measurement and quality. Used data analytics to capture customer insights and drive benefits from customer segmentation

Aggressive, self-starter, ability to quickly adapt to client’s requirements and always focused on customer satisfaction. Looking for a leadership role with a focus on Business Intelligence and Data Analytics to achieve business benefits.

CAREER SUMMARY

2015 till now (1y 7m) Capgemini (United States) Technical Architect

2011 – 2014 (4y) Capgemini (Australia) Project Lead

2007 – 2010 (3y 9m) Capgemini (Australia) Technical Specialist

2004 – 2007 (2y 6m) Capgemini (India) Expert Programmer

SKILL SET

BI Technical and Managerial

-Project Management -Strategy Implementation -Business Analytics

-Contingency Planning -Budgeting -Resource Administration

-Delivery Management -Business Development -Risk Management

IT SKILL SET

BI Reporting : SAP Business Objects 5.6, 6.x, BO XI R2/R3, Brio 6.0, Cognos 6.1, 7.2, Crystal Reporter, BO Live Office, Crystal Reports 2008.2011,4.0, Web Intelligence 3.0, BOBJ 4.1, Information steward 4.0,Information Design tool

Bulk Data Integration : BO Data Integrator, BO Data Services, Informatica, Rapid Marts,

Databases : Oracle, Exadata appliance, Mainframes, DB2, MS SQL Server, Teradata and MySQL.

Modelling : Erwin, MS Visio with 3NF, Start, Snowflake

Programming Languages: PL/SQL

Operating Systems : Windows, UNIX.

CASE Tools : VSS, IBM Document Manager

Methodology : Scrum Methodology

Other BI Tools : Tableau, QlikView

Capgemini, USA BI Architect/Lead Jan-2015 Till Now

With more than 180,000 people in over 40 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2015 global revenues of EUR 11.9 billion.

Clients worked: Union Bank part of MUFG, Philip Morris part of Altria

Excellent experience with enterprise application integration in large complex corporate environments

Interacted with business analysts, end users, functional experts, process teams, SME’s, Finance controllers, senior managers, executives and COE to identify the requirements

Experienced in all phases of Software Development Life Cycle (SDLC), quality management systems and project life cycle processes. Skilled as a Business Analyst, worked on requirements gathering and solution design

Key Responsibilities and Achievements

Role is to define and map project scope and provide direction to team to align technology solutions with project requirements. Also administrator Business Objects environments including production

Manage the solution implementation with Enhanced Prudence Standard (EPS) methodology.

Managing the project which has very tight timelines inclusive of two project releases going parallel.

Managed BO reporting servers for software patches, security upgrades and other maintenance activities.

Created users and user groups, restricted access of the users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports using Central Management Console

Capgemini, Australia Project Lead Jan-2011 To Dec-2014

Major Clients worked: Sydney Water, Railcorp

Excellent experience in managing the projects, teams and successfully managed a team of 8

Expertise of various data design models - Entity Relationship (ER), 3NF, Multi-Dimensional/Star Schema and Extended Star Schema models.

Experience with working on Master Data Management project. Work with data stewards, data owners and stakeholders to ensure understanding and alignment of end–to-end Data Governance processes

Extensive experience in Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management, Reporting, troubleshoot issues with data integrity and User & Security administration

Key Responsibilities and Achievements

Role was to define and map project scope and provide direction to team to align technology solutions with project requirements. Also manage the support for existing two applications and provide BI services customers. Coordinate and manage communication across locations.

Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects with Databases like Oracle, SQL Server, Teradata etc.

Expertise in gathering business requirements, systems analysis, systems design & solution architecture, developing solutions for complex business applications through all phases of the system development life cycle including analysis, design, configuration, development, testing, implementation, production support/maintenance functions, end-user training, developing functional design, technical design, business process and implementation plan documents

Managed a BI portfolio of over $1 million delivering analytical services to customers with major data issues, co-ordinating consulting, Dev, Support and Customer Care.

Requirement gathering, risk assessment, work request dimensioning and effort estimation and architecting the solution. Represent BI group in stakeholder meetings and customers’ technical architecture practice

Resource administration and capability building. Coordinate and manage with offshore team.

Design Common Information Model (CIM) for new applications, review normalised and dimensional model designed for existing application

Capgemini, Australia Technical Specialist Apr-2007 To Dec-2010

Major Clients worked: Sydney Water, Telstra

In-depth knowledge of data warehousing and data management, and database design. Expertise in performance tuning using various indexing strategies as well as Aggregates, Rollup, collapse, Partition, Compression and query cache maintenance.

Developed architecture of analytic solution, imparted training to business users and organised technical Induction of internal BI team.

Key Responsibilities and Achievements

Role was to lead projects delivering BI solution that includes technical and non-technical components. Role also included technology consulting for different customers on data ware house and analytics solutions.

Consultation, architecture, analysis and design services in SDLC

Manage data analytics projects end-to-end using a variety of methodologies and technologies

Lead & mentor the team in analytical reporting, workflow distribution, operational analysis & data discovery

Successfully lead 8 projects in allocated time with the help of floating 4-6 resources. Overall size of delivered projects was $1.6 million in 2 years. Imparted training to business users and organised technical induction of internal BI team.

Developed process-based governance and a systems to improve performance/efficiency

Capgemini, India Expert Programmer Oct-2004 To Mar-2007

Major Clients worked: Xchanging for Loyd’s Insurance Market, ABN AMRO, GE

Expertise in developing SAP BO Universes, Web Intelligence, Crystal Reports, Dashboard.

Expertise in Universe designing/developing and generating reports with complex, business views, ad-hoc reports, dashboards.

Key Responsibilities and Achievements

Role was to analyse, design BI solutions that includes ETL scripts, Reports and executive dashboard components. Role also included technology consulting for different customers on data ware house solutions.

Analyse the business requirements, design data model, build and test the solution

Participate in data management practices and build technical capability within customers to adopt of BI solutions. Conduct reviews and ensure the quality of deliverables

Set up BI infrastructure including design and installation of SAP BI products

Provide consultation, analysis and design services to customers and engage with stakeholders to develop relevant reporting

Architect, analyse, design, implement, unit test and performance tune the solution to meet reporting requirements

EDUCATION

AGSM MBA (Executive) from Australian School of Business, UNSW in Dec-12.

B. Tech in Electronics & Telecommunications Engineering from Dr B. A. Technological University (with Distinction) in 2003.

ADDITIONAL INFORMATION

Achieved Aqua Award, Valuable Contribution Award, Dream Team Awards in Professional career from customer and employer

Won the Chess Gold Medal at the University in year 2000-2001

Participated in White papers and poster presentation at National Levels in University

Led in professional leadership program and team building workshops at Australian School of Business

DATE OF BIRTH: 30th December 1981

Contact this candidate