SUMMARY:

• A Lead BI consultant has around 12+ years of experience in all facets of Enterprise Business Intelligence applications, information integration, systems and technology development, distributed computing, performance tuning, data validation and root cause analysis including assistance and direction to business intelligence users and helping them to set IT strategy, Vision and Objectives.
• Leads a team of engineers, focusing on emerging Tableau, SAP Business Objects, SAP HANA & BW, BO Mobile Application, SAP Lumira, Design Studio, WebI Reports, Crystal Reports, Oracle, Teradata, DB2, SQL server, Denodo (Data Virtualization Tool), Netezza, SAS Programing, and Microsoft’s technologies in Business Process Management, Business Intelligence, Data warehousing, Architecture, reporting Strategy, Migration planning, and SAP BO products like BO universe designers(IDT/UDT), Business view Manager, Web Intelligence, Desktop Intelligence, Crystal Reports, Xcelsius, Live office, Voyager, Dash Board Manager, Performance Manager, Import Wizard, SAP integrations with BO, IBM portal integration, and BO SDK with java and .net, SSAS, and SSRS, and Power BI.
• Capable of successfully managing/leading Projects on multiple priorities, provide root cause determination for enterprise - wide issues, able to work well under pressure and time constraints, and can adjust to a constantly changing fast paced environment.
• Liaison between various cross functional departments, stake holders and business end users for the reports, dashboards clarifications, development, usage of reports and end user Tableau reports training
• Demonstrated strong knowledge of cross-functional business processes including; marketing, sales, service, finance, supply chain and manufacturing.
• Developed and managed working relationships with the different stakeholders at the client site and within the organization.
• Designed and implemented a financial dashboard to track company's performance against annual budget enabling the management to make better, faster and more informed business decisions.
• Expert in building Lumira Visualization and storybook using SAP BW and non-SAP data source.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs
• Understanding and translation of the current existing reporting system SSRS reports or BO reports to convert them as Tableau reports and dashboards.
• Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool.
• Building the customized and interactive dashboards using multiple data sources.
• Created complex universe on Netezza database for MetroPCS (Score Card & Confidential universes)
• Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication
• Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Organized a methodology that offered cleared metrics for measuring performance qualification for incentives like meaningful use, accountable care, regulatory compliance, financial performance, operational efficiency.
• Involved in Design/Development/Release of several Business Objects Universes in both UDT and IDT using various data sources like SQL Server, Teradata, SAP HANA, and SAP BW.
• Developed SOX compliance procedures for data cleanup, removal and encrypting as well as comprehensive data security and privacy protocols.
• Successfully upgraded BOE environments from 4.0 to 4.1
• Development of Star / Snowflake Schemas to provide enterprise solution with high performance
• Worked on cross functional relationships to drive strategic discussions and continuous improvement
• Implemented mobile application for C level management with various analytics/forecasts .
• Worked closely with executives at client firms to understand requirements and suggest solutions and technology for BI reporting and analytics.
• Introduced more systematic approaches to business intelligence project management and development through the use of executive presentations for project planning and monitoring, and standard templates for analysis, design, and consistent project status reporting.
• Troubleshoot existing data load and presentation, perform necessary repairs and improve performance.
• Involved with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Architected and lead planning, development, implementation and support of a global on-demand BI- analytics solution off an enterprise data warehouse on Teradata for global procurement, fulfillment and logistics business processes to track supply chain velocity, calculate and optimize cycle times during different stages of manufacturing and track other key supply chain metrics like Lead time and Ship To Commit.
• Designed and implemented global mobile broadband wireless devices sale, activation and tacking business intelligence solution. Project also included analyzing clickstream data and integrating them to the global data warehouse to actively track mobile activations and periodic follow up with carriers like AT&T, Verizon and Confidential .
• Design actionable interactive dynamic dashboard in SAP Crystal Dashboard Designer (Xcelsius), for upper management and executives across different departments.
• Designed and developed Denodo (Data Virtualization Tool) solution in order to integrate enterprise databases like Hadoop, Teradata, Oracle, SQL server and SAP HANA. This allows users to browse all systems data from any analytical tools like Business Objects and Tableau.
• Develop and support multiple Business Object reporting projects comprising over 500 reports and 25 universes
• Excellent communication skills allowing for close project coordination with clients and coworkers
• Good written communication abilities and strong technical manual documentation

TECHNICAL SKILLS:

OLAP/Reporting: Tableau, Lumira, Business Objects XI R2/3.0/3.1 and BO 4.0/4.1 and SSAS & SSRS, MS Power BI, and R

ERP: SAP BW and ECC 6.0

Development/Productivity Tools: Crystal Reports 8.5, 9, XI, 2008, & 2011 and Xcelsius 2008, Live Office, Dashboards, Mobile Application, Lumira, and Tableau

Database: Oracle, SQL server, DB2, Sybase, Teradata, and SAP BW, SAP HANA, Denodo (Data Virtualization Tool), and Netezza

Functional Areas: Product Management, Sales & Marketing, Supply Chain, Accounting, Solutions Management, Health Care, Finance and Telecom

Programming Languages: C#, C++, Microsoft Visual Basic, VB.NET, Java and J2EE, WebLogic SAS programming, and PL SQL etc

OS: UNIX Sun Solaris/ LINUX/AIX, Windows NT/2000/2003/XP

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. BI Reporting & Data Analyst

Responsibilities:

• Involved in various FinCo monitoring projects where understand the business questions and business requirements to actual and final dashboard technical requirements.
• Understanding and translation of the existing database which located in various sources such as IDW/FADS/Samson etc and produce datasets through SAS system to generate Tableau reports and other BI dashboards.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Understanding and translation of the existing database which located in various sources such as SSIS cubes and SSRS reports and produce datasets through HANA system to generate Tableau & BO reports and other BI dashboards.
• Migrating existing 800 SSRS report into BOBJ reports, designing calculation views in place of SQL Procedure and building BOBJ report on top of HANA calculation view.
• Design/Development/Release of several data sets or data marts using various data sources like SQL Server, Teradata, Oracle, Test files, and Excel files.
• Data validation, Root Cause Analysis, Data Compliance between different systems like TD/SQL/SAP/Oracle.
• Provide subject matter expertise on Finance Company systems and processes
• Worked with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Worked closely with executives at client firms to understand requirements and suggest solutions and technology for BI reporting and analytics.
• Translated requirements into database, universe and report design
• Worked in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment as per BIDS Methodology.
• Analyzed Reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Created SAS programs and automated to run daily for monitoring projects.
• Designed Report templates as per organization standards and created Canned Reports for Finance users.

Environment: Tableau, SAS, SAP Business Objects 4.1, Crystal Reports 2011, SAP HANA, BW, SQL Server, Oracle 11, Teradata, Denodo, Netezza, UNIX, and Windows XP

Confidential, Bellevue, WA

Sr. BI Lead

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.
• Design/Development/Release of several Business Objects Universes in both UDT and IDT using various data sources like SQL Server, Teradata, Oracle, SAP HANA and BW.
• Data validation, Root Cause Analysis, Data Compliance between different systems like TD/SQL/SAP/Oracle.
• Used Star Schema and Normalization data modeling techniques for warehousing of data
• Strong familiarity with scripting languages
• Sound knowledge with Netezza SQL. Expert-level design and coding abilities
• Assessed the Netezza environment for implementation of the ETL solutions.
• Created complex universe on Netezza database for MetroPCS (Score Card & Confidential universes)
• Worked with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Worked closely with executives at client firms to understand requirements and suggest solutions and technology for BI reporting and analytics.
• Translated requirements into database, universe and report design
• Worked in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment as per BIDS Methodology.
• Lead the team for develop, test and deliver the SAP BO application on time.
• Created UNX universes on SAP HANA and created WebI reports for Mobile applications
• Designed new Universes, enhanced the existing Universes and production support.
• Documented the changes of the universe and reports functionality...
• Extensively used multiple data providers for building complex WebI reports
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill, slice and dice, alerts Master/Detail, Cross Tab, and Charts for creating Business Objects Reports
• Use of Designer Module to implement Universe, Joining the Tables, Create Prompts and Conditional Filters, apply Contexts and Alias Tables to remove cyclic dependencies
• Designed reports in SAP BO using complex SQL queries & materialized views.
• Analyzed Reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Generated the Business Objects Reports using the universe as the main Data providers and writing complex queries including Sub queries, Unions, Intersect and Aliases.
• Created Dashboards for corporate which has Text analytic description purposes along with the metrics specifies the key financial ratios.
• Created various analytic models using Xcelsius 2008.
• Designed Report templates as per organization standards and created Canned Reports for Finance users.
• Trained users on various analytical tools like DeskI, WebI & Crystal reports with ad-hoc query functionalities

Environment: Tableau, SAP Business Objects 4.1, Lumira, Crystal Reports 2011, SAP BW, SQL Server, Oracle 11, Teradata, Denodo, Netezza, UNIX, and Windows XP

Confidential, PA

Sr. BO Lead/Analyst

Responsibilities:

• Interacted with customers to determine requirements, document and get approval.
• Translated requirements into database, universe and report design
• Maintained documentation on universe, reports and others
• Involving in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment as per BIDS Methodology.
• Lead the team for develop, test and deliver the SAP BO application on time.
• Designed new Universes, enhanced the existing Universes and production support.
• Migrated Universes and Reports from development to test and test to production environments using tools like publishing wizard & Import wizard with BIAR files, sometimes direct migration between environments.
• Documented the changes of the universe and reports functionality...
• Extensively used multiple data providers for building complex WebI reports
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill, slice and dice, alerts Master/Detail, Cross Tab, and Charts for creating Business Objects Reports
• Use of Designer Module to implement Universe, Joining the Tables, Create Prompts and Conditional Filters, apply Contexts and Alias Tables to remove cyclic dependencies
• Developed complex WebI reports with multiple data providers pointing to different universe
• Tuned the queries to improve the Performance of the existing Reports for various functional areas. Developed reports in SAP BO using complex SQL queries & materialized views.
• Analyzed Reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail.
• Created the Reports from Excel files using Business Objects through Personal data files.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Generated the Business Objects Reports using the universe as the main Data providers and writing complex queries including Sub queries, Unions, Intersect and Aliases.
• Scheduled and distributed the reports from InfoView and also by InfoBurst third party tool.
• Created Dashboards for corporate which has Text analytic description purposes along with the metrics specifies the key financial ratios.
• Designed Report templates as per organization standards and created Canned Reports for Finance users.
• Trained users on DeskI, WebI & Crystal reports with ad-hoc query functionalities

Environment: SAP Business Objects XI R2/3.0/3.1 & BO 4.1,BODS, Crystal Reports 2008 & 2011 Bex, Oracle 11, SQL Server, Teradata, UNIX, and Windows XP

Confidential, Bridgewater, NJ

S r. BI Developer /BO Admin

Responsibilities:

• Interacted with customers to determine requirements, document and get approval.
• Translated requirements into database, universe and report design
• Maintained documentation on universe, reports and others
• Involving in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment as per BIDS Methodology. Lead the team for develop, test and deliver the SAP BO application on time.
• Designed new Universes, enhanced the existing Universes and production support.
• Migrated Universes and Reports from development to test and test to production environments using tools like publishing wizard & Import wizard with BIAR files, sometimes direct migration between environments.
• Documented the changes of the universe and reports functionality...
• Extensively used multiple data providers for building complex WebI reports
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill, slice and dice, alerts Master/Detail, Cross Tab, and Charts for creating Business Objects Reports
• Use of Designer Module to implement Universe, Joining the Tables, Create Prompts and Conditional Filters, apply Contexts and Alias Tables to remove cyclic dependencies
• Developed complex WebI reports with multiple data providers pointing to different universe
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Developed reports in SAP BO using complex SQL queries & materialized views.
• Analyzed Reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail.
• Created the Reports from Excel files using Business Objects through Personal data files.
• Implemented row level security in Universe using @VARIABL feature
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Generated the Business Objects Reports using the universe as the main Data providers and writing complex queries including Sub queries, Unions, Intersect and Aliases.
• Scheduled and distributed the reports from InfoView and also by InfoBurst third party tool.
• Created Dashboards for corporate which has Text analytic description purposes along with the metrics specifies the key financial ratios.
• Created various analytic models using Xcelsius 2008.

Environment: SAP Business Objects XI R2/3.0/3.1, Oracle 9i/10, UNIX, and Windows XP

Confidential

BO Admin and Developer

Responsibilities:

• Interacted with customers to determine requirements and document.
• Maintain documentation on universe and related environments
• Defined ‘best practices’ for performance and re-usability for productivity
• Created repository, domains, users, groups, and profiles and implemented the security and authentications for BOE application.
• Designed Universes for Financial Billing system and Order processing
• Defined User Accounts, groups & set up administrator privileges
• Migrated Objects from development to test to production environments using tools like Publishing wizard & Import wizard for migration of reports, universes with BIAR files.
• Involved in documenting the changes to the universe and reports functionality...
• Extensively used multiple data providers for building reports
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Customized reports with graphical representation of Line and Bar Charts as per end user requirement.
• Created Dashboards for corporate which has Text analytic description purposes along with the metrics specifies the key financial ratios.
• Defined business objects standard can reports & ad-hoc reports.
• Tuned SQL & universes for trouble shooting of reports for data accuracy.
• Worked on Universes and Connection management process.
• Expertise in production support and providing the solutions on priority.
• Created alerts and rules for the entire corporate dash board through performance Manger application in EPM.
• Designed Report templates for standard reports.Designed & created Canned Reports for Finance users.

Environment: Business Objects XI R2, Oracle 9i/10, Teradata, UNIX, and Windows XP

Confidential

BO Admin/Developer

Responsibilities:

• Involved in system analysis and design of the BO application.
• Defined and implemented security to access BO repository and BO application.
• Created functional and technical design documents.
• Implemented very complex WebI reports with complicated formulas and formats.
• Developed Complex Security set up for end users with CMC.
• Installed and configured BO patches on cluster environment.
• Played a BO Admin role to manages servers and monitor servers performance
• Monitored the team to deliver reports on time with organizational standards.
• Designed Universes for Financial Billing system and Order processing.
• Worked on Linked Universes by kernel approach.
• Created Universe and reports against Teradata.
• Exported data to Excel sheets & validated reports.
• Designed Universe for Ad-hoc reporting and implemented report bursting feature.
• Maintenance of Development & Production environments.
• Developed Full client reports and webi reports and scheduled
• Development, Testing (SIT/UAT) & QA for all reports.
• Customization of application with BO SDK.

Environment: Business Objects XI R2, Dashboards, Teradata, UNIX, Windows XP

Confidential

Sr. Consultant /BO Admin

Responsibilities:

• Lead the team for develop, test and deliver the BO application on time.
• Designed new Universes, enhanced the existing Universes and production support.
• Supported Server Management with Central Management Console (CMC) and Central Configuration Manager (CCM) and monitoring other BO servers.
• Played as BO Admin to define and create Users and User Groups & set up various rights on BO content as per user requirements and managing various BOE servers.
• Migrated Universes and Reports from development to test and test to production environments using tools like publishing wizard & Import wizard with BIAR files, sometimes direct migration between environments.
• Documented the changes of the universe and reports functionality...
• Extensively used multiple data providers for building complex WebI reports
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill, slice and dice, alerts Master/Detail, Cross Tab, and Charts for creating Business Objects Reports
• Use of Designer Module to implement Universe, Joining the Tables, Create Prompts and Conditional Filters, apply Contexts and Alias Tables to remove cyclic dependencies
• Developed complex WebI reports with multiple data providers pointing to different universe
• Used Store Procedure as Data provider to retrieve data from scheduled tables and complex queries. Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Developed reports in Business Objects using complex SQL queries & materialized views.
• Analyzed Reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail.
• Created the Reports from Excel files using Business Objects through Personal data files.
• Implemented row level security in Universe using @VARIABL feature
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Generated the Business Objects Reports using the universe as the main Data providers

Environment: Business Objects XI R2/3.0/3.1, Oracle 9i/10, Teradata, UNIX, and Windows XP

Confidential

Business Objects and Crystal Reports Developer

Responsibilities:

• Used Crystal Reports 9.0/XI for designing of reports and multi grouping of data at report level as per client requirement
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports
• Deployed reports in Crystal Enterprise and setup of Scheduling, Publishing is done
• Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal Enterprise.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports
• Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise
• Extensively involved in SQL coding creating complex queries, Views, Stored procedures, Stored Functions to give better results at Crystal Reports
• Creation of packages, procedures, functions and triggers to boost the application performance.
• Created stored functions to manipulate table values before fetching it to the reports using queries.
• Used SQL*loader to load data into tables. Involved in creating indexes and views
• Used Excel for manipulating data for crystal reports and wrote queries to use in Excel.
• Installation of IIS server and setup of Web component server is done.
• Involved in coding of HTML, DHTML files, and ASP pages, Report Viewers for Crystal Reports.
• Involved in using Crystal Analysis for data analyzing and in reports

Environment: Business Objects XI R2, Crystal Reports 8.5/9/XI, Oracle 9i, Windows XP

Confidential

Software Engineer

Responsibilities:

• Analyzed application prototypes and suggested solutions, saving company significant costs in potential redesign and manufacturing efforts.
• Developed applications in C#, ASP.Net with .Net framework for sales, marketing, accounting, and inventory management departments. Collaborated with department heads to create functionality specs and user interface.
• Instrumental in ecommerce Website redesign, including registration and shopping cart applications, within 8-month time period. Project was completed on time and under budget.
• Used Dot Net to create interface to Microsoft SQL database, enhancing access and GUI design.
• Used Excel for manipulating data for crystal reports and wrote queries to use in Excel.
• Installation of IIS server and setup of Web component server is done.
• Involved in coding of HTML, DHTML files, and ASP pages, Report Viewers for Crystal Reports.
• Involved in using Crystal Analysis for data analyzing and in reports
• Involved in Testing of various modules and entire application

Environment: C#, ASP. Net, ADO.NET, SQL Server 2000, Crystal Reports 9, & Windows 2003

Confidential

Project Engineer

Responsibilities:

• Developed applications in ASP.Net with .Net framework for online medical services like appointments, doctor medical reports, lab reports and inventory management departments.
• Instrumental in ecommerce Website redesign, including registration and shopping cart applications, within 8-month period. Project was completed on time and under budget.
• Used Dot Net to create interface to Microsoft SQL database, enhancing access and GUI design.
• Used Excel for manipulating data for crystal reports and wrote queries to use in Excel.
• Installation of IIS server and setup of Web component server is done.
• Involved in coding of HTML, DHTML files, and ASP pages, Report Viewers for Crystal Reports.
• Involved in using Crystal Analysis for data analyzing and in reports
• Involved in Testing of various modules and entire application

Environment: C#, ASP. Net, ADO.NET, SQL Server 2000, Crystal Reports 8.5, & Windows 2000