SUMMARY

• Experienced professional with exposure to complete software development life cycle (SDLC).
• Experience includes Retail, Telecom, Financial, Insurance, State Government, Health Care, Supply Chain Solutions, Human Resources, Hospitality and Banking Projects.
• Experienced in Analysis, Design, Development, Administration, Deployment, Change Management of BI suite with exceptional abilities in leading implementation, support & maintenance teams.
• Experience in creating POC’s for clients in comparing and implementing feasible and advanced BI tools & methodologies.
• Experienced in Architectural improvements, Design Solutions and proposed technical feasibility solutions for new functional BI designs and suggested options for BI Analytics and performance improvements.
• Experienced in conducting user workshops and user trainings on BI Dashboards/reports across the organizations.
• Excellent technical, logical, code debugging and problem - solving capabilities.
• Good Knowledge in various databases like SAP HANA, ECC, SQL Server, Oracle, MS Access.
• Experienced in leading onsite/off-shore BI teams.
• Experienced in Agile and Waterfall methodologies of project implementations.
• Excellent communication, interpersonal skills and a team-worker with good customer interaction experience.

TECHNICAL SKILLS

Business Intelligence: SAP BI 4.2,4.1, BO 4.2/3.2, Tableau Server10.x, Tableau Desktop10.x, SSRS, Power BI, SAP BODS, SAP Design Studio, Web Intelligence, UDT/IDT Designer, SAP HANA, Crystal Reports 2016/2013/X1, Xcelsius, QAAWS, Report Conversion Tool and Services, Board cast agent(BCA), Scheduler, SAP Business Explorer.

Databases: Oracle 7.x/8.0,9i,10g,11g,12c, HANA, Netezza, SAP ECC, MS SQL SERVER 2012/R2, Teradata and MS Access

Environment: Windows, Windows NT, UNIX (Sun Solaris, LINUX)

Languages: SQL*plus, SQL, PL/SQL, JAVA Script

GUI, Data Modeling Methods & Other: HANA Studio, SQL Developer, TOAD, Star Schema, Snowflake Schema, ER modeling, MS Visio, QTP, HP Quality Center, Clarity, Remedy, Clarity Incident Tracker etc.

Web Server: Apache TOMCAT, Microsoft IIS 4.0/5.0/6.0

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

BI LEAD

Responsibilities:

• As a part of SAP POSDTA implementation, involved in end to end implementation of sap BI 4.2.
• Worked on gathering the client requirements and creating Functional Requirements document and Technical requirement Documents for Data Models and Reporting Environments.
• Worked on setup and administration of SAP BI 4.2 environment.
• Responsible for Tableau Server Administrative functions, upgrades, installations, license management, backup of servers and load balancing techniques.
• Migrated Tableau Dashboards and BO reports across environments.
• Created multiple Tableau Dashboards and BO reports as per client requirements.
• ­­ Designed and deployed dashboards, reports with drill down, drill through and dropdown menu options.
• Created Sales Transactions Audit BO Universe for TSC reporting and Analytics.
• Worked on regression testing the environment for any data/table environment mismatches.
• Worked on performance testing of the Tableau and SAP BO Reporting environments against SAP HANA/POSDTA Applications.
• Involved in support of the Reporting environments and worked on incidents logged in the JIRA Incident management system.
• Responsible for leading Project Scrum meetings and weekly prioritization meetings.
• Oversee BI Projects across all phases of development and monitor workflow and time lines.
• Implement and maintain development best practices.
• Mentor/Assist offshore development team in reporting deliverables.
• As part of TSC/PTS Merger, Involved in end-end implementation of BI and Reporting environments merger.
• Involved in client/stake holders’ meetings in understanding existing reporting environments.
• Involved in requirements gathering for the merger of reports and users accessing single source for all their reporting needs.
• Created POC’s for clients to analyze and choose between different BI Tools like Tableau/Power BI/Design studio for the analytical reporting.
• Created TSC Financial Inquiry dashboard for the users to analyze the latest developments/trends across the organization.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created Tableau dashboards with advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending etc.
• Worked on user training and support for both TSC/PTS reporting user groups.

Environment: SAP BI 4.2, Crystal Reports2016, Tableau 10.2, WebI, PowerBI, SAP HANA, SAP ECC, SQL Server, Netezza, SAP HANA Studio, JIRA, TOAD.

Confidential

BI Lead

Responsibilities:

• Independently worked on conducting studies of new or existing systems and recommends changes based on the results.
• Worked as BO Admin, Managed CMC, CMS, Servers, User Permissions, Promotion Management, Report Schedules and Auditing Databases.
• Create server groups and add instances of processing servers as required to handle the load efficiently.
• As part of ATT Wifi Pioneers project worked on Power BI Analytics and creating POC’s for Client.
• Created/Modified existing ATT Wifi Universes and BO Audit Universe as per requirements.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• 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.
• 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 as a Tableau Administrator.
• 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).
• Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
• Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
• Worked extensively with Tableau Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau's Advanced Capabilities.
• Worked on performance testing of the Reporting environment against HANA and SQL Server DW environments.
• Involved in support of the BI environments and worked on incidents logged in the JIRA Incident management system.
• Responsible for leading Project Scrum meetings and weekly prioritization meetings.
• Oversee BI Projects across all phases of development and monitor workflow and timelines.
• Implement and maintain development best practices.

Environment: SAP BI 4.2, BOE3.1, IDT, Tableau 8.3(Server/Desktop) Crystal Reports 2016, WebI, BO Dashboards, SQL Server, SAP HANA Studio, Informatica, JIRA, TOAD, Unix, Apache Tomcat 7.0.

Confidential, Alpharetta, GA

BO Developer

Responsibilities:

• Implemented full life cycle SAP BI application which involves Installation, Security setup, Universe Development, Testing, Documentation, Requirement analysis, Reporting, End user documentation and User Training and Support.
• Worked on setting up BO Production, UAT and Development Servers Maintaining and applying patches to Development, UAT and Production Servers and keeping them in sync.
• Administered BO Production, UAT, Dev servers.
• Administering multiple CMS, WCS, Job server, Page and Cache server, File input and output servers in clustered environment and troubleshooting them when required.
• Performed BO3.1 SP5 Tired Installations/Uninstall on multiple test environments based on clarity application upgrades and enhancements.
• Performed Lower and Production BO and Tomcat startup and shutdown on Linux through putty.
• Integrated Business Objects reporting environment with CA Clarity environment, customized the logon process to use the custom SSO framework.
• Worked on Data Extraction, Transforming and Loading (ETL) using Business Objects Data-services xi3.2, 4.2(BODS)
• Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.
• Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers
• Worked on Data Services to make correct data models for Confidential dashboards.
• Tested data flows and scripts against sample data and real data.
• Created projects, batch jobs, Real time jobs, work flows and data flows.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Worked on Universe development, created Classes, objects, resolved loops using Aliases and Contexts etc.
• Used row level security to secure the data, based on user access. Applied object, folder level security within the CMC. Created new groups, users using Central Management Console and set restrictions, assign privileges based on their profiles.
• Worked on Tuning Universes and Reports for better performance.
• Created Project management Xcelsius Dashboard and integrated them with the CA Clarity Application as well as in Business Objects.
• Created and presented Proof of Concept in implementing SAP HANA as a Data source for the existing reporting environment.
• Created Tableau Dashboards connecting to multiple data sources.
• Worked as a part of team in creating Reporting Replication Database in sync with the existing Oracle 10g database.
• Involved in testing the Reporting Environments pointed to Report replication DB, Clarity Prod, UAT and Development Databases.
• Created test cases for testing the clarity and reporting environments periodically after software upgrades or patches on BO or Clarity Environments
• Converted Multiple BO reports to Jasper Soft Reports.
• Logged the defects in Clarity Incident tracker and worked with Clarity teams in resolving the report environment or data issues.
• Involved in support of the BO environments and worked on prioritizing the incidents logged in the system.

Environment: SAP BI 4.1, BODS4.2, BOE3.1, CMC, Designer, SAP BI 7.0, Tableau8.3, JasperSoft Reportig, WebI, BO Dashboard Designer, SAP HANA, Oracle EBS 11i/12, MS Access, MS Excel, Oracle 10g, SQL,PL/SQL, Clarity, Clarity Incident Tracker, Toad, SQL Developer, Tomcat, UNIX, MS Sharepoint, Putty.

Confidential, Tampa, FL

BI Developer

Responsibilities:

• Managed Business Intelligence onsite/off-shore team.
• Involved in gathering requirements from Business users, Analyzing, documenting and creating Functional and Technical design documents for new and existing BI users.
• Interacting with the business users and project manager in understanding the report specifications and requirements.
• Analyzed User requirements compare between the old and the new requirements, document the results, and communicate gaps and possible issues to the relevant groups.
• Analyzed the data for policy and planning - Data Analysis
• Creating tables, indexes and designing constraints.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Responsible for identifying and defining Data Source and Data Source views.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
• Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided.
• Documentation support on SSRS 2012 as assigned.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008r2/2012.
• Created Logins, Scheduling Jobs, Created indexes, Constraints and rules on database objects.
• Transformed the complex business logic and calculations into coding
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database
• Lead the team in internal BI environment upgrades and testing by keeping Production, UAT and Development environments in sync.
• Lead the BI team in supporting the BI environment in tracking/resolving the support assignments.

Environment: SQL server 2008/2012, Windows 2008r2/2012 Standard Edition, SSIS, SSAS, SSRS, SQL Diagnostic Manager, Teradata, MS Excel, SQL, PL/SQL, Toad, Data stage, HP Quality Center, Windows 2008 server

Confidential

BO Developer

Responsibilities:

• Responsible for the Architectural Design, Development, Testing of Business Objects universe and reports for the project.
• Build new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Worked on creating test cases and review documents for testing procedures for Business Objects environment and Report testing.
• Created Universe Classes, Objects, Details and Pre-defined conditions.
• Extensively used Crystal Xcelsius 2008 in creating dashboards using Query as a Web Service (Qaaws), Live Office.
• The reports were generated using Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Prompts and Formulas.
• Extensively used Calculations, Variables, Breaks, Sorters and Alerter for creating Business Objects reports.
• Created multiple crystal reports involving complex queries, sub queries, Unions and Intersection.
• Created various analytics like Speedometers and Interactive Metric Trends (IMT)
• Responsible for creating Metrics, Rules, Alerts using Dashboard Manager (EPM) XIR2 for user analysis based on user requirements.
• Created Interactive Metric Trend (IMT) analytics for credits and deposits metrics to compare trends in Daily and Monthly values.
• Developed Knowledge Portal dashboard and linked to Web Intelligence Canned and Drill documents
• Developed universe user documentation guide for the end users reference.
• Provided support to the user groups and maintaining Universes and reports.

Environment: Business Objects XI/R3, Crystal Reports 2008,Crystal Xcelsius 2008, Teradata, TOAD, SQL, PL/SQL, Windows 2003 Server, Remedy.