Lakshmikanth N Krishnachar

San Francisco, CA

C: +1-484-***-**** addg3k@r.postjobfree.com

Experience Summary

●Progressive Technology Leadership & Experience: Business analytics & Insights, Information Management, Data Warehouse, Data Architecture & Modeling, Data Integration, Data Quality, Data Migration, ILM, MDM, Data Visualization, operational reporting, Enterprise Performance Management and Mobile BI

●Worked closely with End Users (customers) and Project stake holders in collecting BI requirements, designing the reports and ensuring successful implementation and exceeding customer expectations. I have worked with variety of customers that involved various State/Local IT systems, large commercial organizations IT systems.

●10+ years of experience in Business Objects building Universes, Web Intelligence reports, Dashboards, BO Administration, BO Migration and Upgrade, Server Sizing, Content and Security Management and Performance Tuning.

●8+ End to End BO Implementation with Architecture & Administration expertise.

●2 years of experience working at Birst Inc.(An Infor Company)

●1+ years of experience working with Python scripts

●4+ years of BIRST (Cloud BI) tool Support and Services experience for Global customers providing solutions towards BIRST Implementation and Reports development.

●Strong Data Modeling experience using ER diagram, Dimensional data modeling and was Instrumental in Data Warehouse Architecting and multiple end to end BI Implementations

●Strong ETL experience using Oracle Warehouse Builder, Informatica, Data Stage, BODS and Oracle PL/SQL

●Solution Architect for Business Intelligence Centre of Excellence and managed multiple projects

●Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.

●Strong Unix, SQL and Database Skills on multiple databases with excellent Performance Tuning Skills

●Excellent Domain Experience in Manufacturing, Health & Public Sector, Taxation, Oil & Gas, Finance, Banking, Products, Transport, Media and Pharma.

●Performed roles as SAP BO BI Architect, BI Manager, BI Lead, BO Administrator, Data Modeler/ Data Architect, Business Analyst, Principal BI Support Lead, Birst Architect

TECHNOLOGY PROFICIENCY

Data Modeling

ERwin, Sybase Power Designer 11.0, and MS Visio 2003

ETL

Oracle Warehouse Builder, IBM Data Stage, Informatica, BODS

Web

Java, JSP, ASP, XML, Java Script, VB Script

Cloud Connectors

Salesforce, Google Analytics, Marketo, Jason, Netsuite, Omniture, REST, Jira, SAP BAPI, XMLA, SFTP

Operating System

Windows NT/2000, Linux 9.0, Unix, Solaris, AIX

Database

Oracle, SYBASE, SQL Server, DB2, SAP HANA, SAP BW, NoSQL, RedShift, MongoDB

Big Data

Aster Data, Big Data Concepts

Data Analytics

BIRST, SAP Business Objects 4.2, Python, Tableau, SAP Crystal Reports,, Qlikview, Tibco Spotfire, IBM Cognos

PROFESSIONAL EXPERIENCE

Current Employer: Rudra Technologies, CA Duration: Feb-2020 to Present

Employer: GHG Systems Inc. CA

Stellar Labs CA, Birst BI Engineer Duration: May-2018 to Jan-2020

●Analyzing existing Cloud Business Intelligence (BI) architecture and propose recommendation for

Birst BI Appliance server installation and configuration.

●Designing data models and building data warehouses for Next Generation Flight Operations System

(FOS) Java Web application using Amazon S3, Amazon Web Services (AWS), Redshift, and MySQL.

●Designing and developing BI reports and dashboards using Agile Scrum Methodology, defining user

stories and tasks in Pivotal Tracker.

●Planning Sprint activities which include daily standup, kickoff, BI product demos, and collaborating

with Product, Engineering and Marketing teams for BI strategy and implementation

●Gathering multiple customer business requirements for BI semantic layer, BI reports, analytics and

dashboards. Building business and technical specification documents.

●Designing complex solutions, developing new product features, enhancements, fix defects, root

cause analysis and deployment of BI analytics across multiple environments.

●Consulting and training end users on the usage of Birst BI tool set and enabling customers to build

their own custom BI reports and dashboards

●Conducting performance monitoring and tuning of BI servers, reports and dashboards; and

managing Birst BI content by establishing data and user security

●Developed Python scripts to use Birst API’s for Process Automation and perform QA testing to

reconcile data between source systems and Birst reports

Environment: BIRST 7.3, Birst Modeling, PostgreSQL, MySQL, Amazon Redshift, Python 3.0, Windows, Linux

Employer: GHG Systems Inc. CA

Zurich North America Insurance IL, SAP BO Consultant Duration: Jan-2018 to April 2018

●Analyze and validate existing BO design specifications built on SAP HANA

●Build Webi Reports on Olap cube

●Convert existing BO reports on S/4 HANA environment

Environment: SAP BO 4.2, S/4 HANA

Employer: GHG Systems Inc. CA

Quantum Heath Inc, OH, Birst Architect/Lead Duration: May-2017 to Jan-2018

●Install & configure Birst Appliance and recommend best practices for install, configure, upgrade and migration

●Coordinate with IT team, DBAs and Project Managers in building necessary Infrastructure for Birst solution

●Build Birst Data models for Claims and Year Over Year reporting

●Developed proof of concept on Birst capabilities and conversion of 28 SSRS reports into Birst Designer reports

●Develop ETL scripts using Birst Query Language (BQL) to extract, transform and load data from SQL Server into Birst Data Warehouse

●Developed Python scripts to use Birst API’s for Process Automation

●Build Year Over Year Dashboard and claims reports using Visualizer, Designer & Dashboard tools

●Analyzing Birst product configuration, troubleshooting issues with deep analysis of data architecture, modeling, reporting and dashboards.

●Train business users and provide guidance in core areas of Security, Birst Connect, Designing Data Models,

Space processing, Scheduling, BQL Scripts, Visualizer, Designer, Dashboards and Birst Appliance Maintenance

Environment: BIRST 5.28, Birst Modeling, SQL SERVER, Python, Windows

Birst Inc., CA, Principal BI Lead Duration: Oct-2015 to April 2017

●Support and Service Customers on Birst Cloud Implementation and ensure Customer meet their Go-Live Dates

●Train Customers and provide guidance in core areas of Birst Connect, Application Connectors, Designing Data Models, Space processing & Scheduling, BQL Scripts, Python Scripts, Tableau connectors, Visualizer, Designer and Dashboards

● Rebuild customer reports, scenarios incase of product bugs/enhancements/features, provide indepth analysis, logs to engineering team for fixes

●Provide Technical Support in resolving performance issues in Reports and ETL scripts

●Manage Support Team, Assign and Monitor Customer Cases, Handling Customer Escalations and Manage Key Support Metrics

●Analyzing customer’s Business Intelligence product configuration & troubleshooting issues with deep analysis of data architecture, modeling, reporting and dashboards.

●Troubleshooting Star schema and Snowflake design models with a deep understanding of Data Warehousing concepts.

●Troubleshooting application and database event logs, system Backup & Recovery, application Load

Balancing/clustering

Environment: BIRST 5.25, Birst Modeling, SQL SERVER, ORACLE, SAP HANA, AWS, Tableau, Python Windows, Unix

Employer: Accenture Duration: April-2011 to Oct-2015

Client: Franchise Tax Board, State Project- CA, SAP BO/BI Lead Duration: June-2014 to Oct-2015

●Responsible for gathering Business Requirements and building data marts for Personal and Corporate Income Taxes. Enabled State employees to build self BI reports on Adhoc BI data mart

●Handled Data Modeling role and maintained Data model for 3 data marts

●Develop, maintain and support universes and reports using Business Objects.

●Perform performance monitoring and tuning of universes and reports during application testing and production operations.

●Document benchmarks and procedures needed to optimize performance. Ensure that all guidelines are followed.

●Establish and implement best practices to ensure data quality and report performance

●Collaborate with DBAs, architects, and developers in the implementation of BI solution.

●Manage team’s workload and deadlines – proactively communicate status to leadership.

●Provide technical direction on the use of best practices for Business Objects tools to members of the data team and other project teams.

Environment: SAP Business Objects 4.1, IBM Data Stage, Sybase Power Designer, Tableau, Qlikview, IBM DB2, Windows, AIX

Client: Department of Revenue, State Project-PA, SAP BO Architect Duration: July-2013 to May-2014

●Responsible for executing BI Strategy by gathering Business Requirements for 10 canned BI Reports and 1 Enterprise Dashboard covering Returns Processing and Collections areas

●Preparation of Functional Description Document for all BI Components

●Project Plan and Estimation

●Execution of project from offshore and onsite

●Installation and Configuration of SAP BO BI 4.x

●Development of Web Intelligence Reports and Dashboard

●Enabling team in building SAP BW Data warehouse

●Conducting training sessions for business users

Environment: SAP Business Objects 4.1, Windows, SAP Dashboards, Web Intelligence, SAP BW

Client: Whirlpool-MI, BO Architect Duration: July-2012 to June-2013

●Plan and Analyze SAP Business Objects(BO) upgrade

●Project Plan and Estimates

●Server Sizing and Best practices

●Installation and Configuration of SAP BI 4.0 SP5 on AIX platform and Windows

●Configure All SAP Server and Client Tools with SAP BW

●SAP BI Administration Activities

●Knowledge Transfer on new Tools and Features

Environment: SAP Business Objects 4.0 SP5, AIX, Windows, SAP Dashboards, Web Intelligence, SAP BW

Client: Shell Inc.TX, SAP BO Lead Duration: April-2011 to June-2012

●Responsible for resolving Release 1 SAP BO Reporting performance issues

●Optimization of existing universes for Performance issues

●Developed Proof of Concept for SAP BO Live Office Solutions

●Involved in creation of Xcelsius dashboards for key functional areas

●Involved in building software assets(accelerators) for Shell Blueprint and Accenture

●Conducted many SAP BO trainings

●Provided Subject Matter Expert (SME) services for Shell PMM project

●Initiated and ramped-up Shell ePass project from offshore and successfully delivered Shell ePass Reporting project (20 webi reports)

Environment: SAP Business Objects 3.x, Windows, BODS,SAP Dashboards, Web Intelligence, ASTER Data

Employer: Wipro Technologies, Solution Architect, Data Modeler Duration: Dec-2002 to April-2011

Client: Wipro Customers Duration: Feb-2009 to April-2011

●As a consultant and as solution architect, involved with existing critical projects providing solutions at various project phases.

●Involved in designing Data Warehouse architect Level Programs and Competency building Activities for our practice.

●Designed latest version Data warehouse tools courses like Business Objects 3.x, Data Stage 8.x etc for our practice

●Involved in Centre of Excellence – Business Intelligence for setting up Data warehouse Lab

●As a data modeler built multiple data marts

Environment: SAP Business Objects XI, IBM Data Stage, Oracle 10i, ERWIN

Client: Arjowiggins Pluto –UK, SAP BO Consultant Duration: Dec-2008 to Feb-2009

●As a consultant was involved with existing team providing critical support in resolving all their remedy ticket issue on daily basis

Environment: SAP Business Objects 6.5, Oracle 10i

Client:Sony –USA, Oracle PL/SQL Consultant Duration: June-2008 to Oct-2009

●Preparation Unit Test Plan and Unit Test Case• Development of PLSQL modules for Assets & Metadata ETL Process • Testing of Modules

Environment: Oracle PL/SQL, Windows 2000

Client: Dun&Bradstreet-USA, BO Technical Lead Duration: Jul-2006 to Mar-2008

●Understanding existing business system and ensuring the new system can provide required Target Reports

● Provided the Java/Jasper Team with SQL queries required to generate region/office/Division/Specialist/Sales Specialist set of reports

● Provided Technical guidance to team and Share best practices to and from team.

● Co-ordination with onsite team and clients

● Developed BO Universe to assist business users in generating ad-hoc reports based on new Data Model

● Supported Oracle Advanced Collections Application

● Provided Technical guidance to team members in handling tickets of various BO applications

● Handled eCube (Project Management) Activities

● Creation, Migration and maintenance of business objects universe & reports.

● BO Server maintenance and Security Management

● Co-ordination with onsite and offshore team in implementing Webi Reports

● Documentation of Functional Specification and Design Document

Environment: SAP Business Objects XI, Informatica, Oracle 10i, Java, Jasper Reports, Sybase IQ

Client: GSK NC-USA, BO Consultant Duration: May-2004 to Jul-2006

●Lead Business Objects Center of Excellence team, catered BI reporting needs of business users from Clinical Trial Management Systems offering Studies, Compliance Audit Management Systems and Bio Medical Data Sciences

●Understand and execute business requirements from departmental users and built 4 datamarts

●Provide onsite/offshore business objects support to multiple business applications.

●Creation and maintenance of business objects universe & reports.

●Co-ordination with business objects center of excellence team onsite for global support and enhancements.

●Documentation & unit testing of universe(s) and report(s).

Environment: Business Objects 5.1.6 & 6.5 (Supervisor, Designer, Reporter, WebI), Windows XP.

Client: OTIS USA, BO Consultant Duration: Oct-2003 to Jan-2004

●Installed and configured the BO 6.0 Suite and Web Intelligence 6.0 Server environment.

● Analyze and creation of Universe and Reports.

● Co-ordination with On-site for report implementation.

● Documentation and Testing.

● Share best practices to and from team

● Escalate with BO US Tech Support for any concerns/features/issues with the tool.

Environment: Business Objects 6.0 (Supervisor, Designer, Report Writer, WebI), BCA, Windows 2000.

Client: -Fisher Scientific Inc. USA, ETL Consultant Duration: Aug-2003 to Oct-2003

●Requirements analysis

●Mapping Estimation

●Preparation of ETL specification, Unit Test Plan & Unit Test Case

●Document and Code Reviews & Testing

●Mappings Development

●Co-ordination with onsite team for Testing and Implementation

Environment: Oracle Warehouse Builder, Oracle 9i, PL/SQL, Unix Shell scripts, Sales & Marketing, Harvest.

Client: Monsanto Inc.-USA, BO Consultant Duration: Apr-2003 to Aug-2003

●Solely responsible for providing total Business Objects solutions to the Customer with version 6.0

●Create Universes on Operational Data Store

●Replicate Legacy System reports using Business Objects on Operational Data Store

●Web Intelligence customization using WEBi SDK

●Preparation Unit Test Case and Testing

●Develop user manual for novice and power users

Environment: Business Objects 6.0, Oracle, SQL*Plus, Apache web server, JSP, Tomcat Web Server, Accounts, Manufacturing, Oracle 8i, Windows 2000

Employer: Patni Computer Systems – Mumbai-India, Module Leader Duration: Oct 2001 to Dec 2002

Client: General Electric Inc.-USA, Module Leader Duration: Oct 2001 to Dec 2002

●Task Estimations· Preparation Unit Test Plan and Unit Test Case

●Code implementation (Writing PLSQL / SQL Loader scripts)

●Writing Program Documentation and Code Review

●Testing of Modules as per the GE-Supply standards

●Automation of Load Process for Enterprise data warehouse and Data marts Using UNIX Shell Scripts

●Performance tuning of Oracle database.

●Create reports in Business Objects and Web intelligence

●Worked as Configuration Manager handling Software Configuration Management

●Responsible for Quality Assurance related activities such as preparation and analysis of monthly metrics, defect prevention and Six Sigma green belt project Initiatives.

Environment: Oracle 8i,AWK,PL/SQL, Unix Shell scripts, Maintenance, Purchase, Sales & Marketing, Technical Documentation, MS Visual SourceSafe, Manufacturing, Business Objects 5.0, Solaris

Qualification:

Bachelors in Computers Engineering - The Institution of Engineer(s) India (Kolkata)

Three Year Diploma in Computer Engineering - MEI Polytechnic (Government of Karnataka-India)

Contact this candidate