SUMMARY

• Experienced professional with exposure to complete software development life cycle SDLC including system requirements gathering, analysis, data modeling and system design.
• Experience includes Telecom, Financial, Insurance, State Government, Health Care, Supply Chain Solutions, Human Resources, Hospitality and Banking Projects.
• Experienced in leading onsite/off-shore BI teams.
• Extensive Knowledge in BI Tools, SAP BI 4.1,BOE3.1/XI R3/R2,SAP BW, SAP Business Explorer, SAP HANA, Crystal Reports 2008/XI, Web Intelligence, explorer view sets, Information Spaces, Dashboard Manager, Xcelsius, Lumira 1.2, Tableau 8.3, BODS, BODI, SSRS SSIS.
• Skills include Analysis, Design, Administration, Deployment, Change Management of SAP BI/BOBJ Suite with exceptional abilities in leading support and maintenance teams.
• Excellent technical, logical, code debugging and problem solving capabilities.
• Good Knowledge in various databases like SQL Server, DB2, Oracle, Informix, MS Access.
• Excellent communication, interpersonal skills and a team-worker with good customer interaction experience.

Professional Experience

Confidential

ROLE: BI Developer

Responsibilities:

• Upgraded SAP BI 3.1 environment to BI 4.1 SP5.
• Worked as BO Admin, Managed CMC, CMS, Servers, User Permissions, Promotion Management, Report Schedules and Auditing Databases.
• As part of ATT Wifi Pioneers project worked on multiple BI tools in implementing and creating POC's and comparing between multiple BI Tools.
• Created/Modified existing ATT Wifi Universes and BO Audit Universe as per requirements.
• Created Multiple Lumira, Tableau and BO Dashboards as per client requirements.
• Created multiple WebiReports, Exploration View sets, Information Spaces as per business requirements.
• Responsible for leading Project Scrum meetings and weekly prioritization meetings.
• Created BI reporting and Dashboard tools to connect to HANA.
• Worked on performance testing of the Reporting environment against HANA and Oracle/SQL Server DW environments.
• Involved in support of the BO environments and worked on incidents logged in the JIRA Incident management system.

Environment: SAP BI 4.1, BOE3.1, IDT, Lumira 1.2, Explorer,Tableau 8.3, WebI 4.1,BO Dashboards 4.1 , Oracle 12c, Oracle 11g, SAP HANA Studio,JIRA,TOAD,Unix,Apache Tomcat 7.0.

Confidential

ROLE: BO Developer

Responsibilities:

• Worked as a part of team in creating Reporting Replication Database in sync with the existing Oracle 10g database.
• Created multiple Tableau Dashboards connecting to multiple databases.
• Created and presented Proof of Concept in implementing SAP HANA as a Data source for the existing reporting environment.
• Created Project management Xcelsius Dashboard reports and integrated them with the CA Clarity Application as well as in Business Objects.
• Worked on Tuning Universes and Reports for better performance.
• 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 Universe development, created Classes, objects, resolved loops using Aliases and Contexts etc.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Created projects, batch jobs, Real time jobs, work flows and data flows.
• Tested data flows and scripts against sample data and real data.
• Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.
• Worked on Data Extraction, Transforming and Loading ETL using Business ObjectsData-services xi3.2, 4.2 BODS
• Performed Lower and Production BO and Tomcat startup and shutdown on Linux through putty.
• Performed BO3.1 SP5 Tired Installations/Uninstall on multiple test environments based on clarity application upgrades and enhancements.
• Administering multiple CMS, WCS, Job server, Page and Cache server, File input and output servers in clustered environment and troubleshooting them when required.
• 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.
• Integrated Business Objects reporting environment with CA Clarity environment, customized the logon process to use the custom SSO framework.
• 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 Verizon Wireless dashboards.
• 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
• 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,Tableau Dashboards, 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

ROLE: lEAD BI aDMIN/ 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.
• Migrated Database from SQL Server 2008r2/2012 to 2008 by using side by side migration.
• 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,VSS, SQL Diagnostic Manager, MS Access, MS Excel, SQL, PL/SQL, Toad, Data stage, HP Quality Center, Windows 2008 server

Confidential

ROLE: 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.
• Generated the Business Objects 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 usingDashboard 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 Xcelsius 2008, Oracle 10g, SQL Server 2000, TOAD, SQL, PL/SQL, Windows 2003 Server, Remedy.

Confidential

ROLE: Bi Developer

Responsibilities

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Developed Physical data models and created DML scripts to create database schema and database objects
• Employed Server Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Performed Debugging on the Stored procedures for the requirement to handle the errors
• Employed Transparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.
• Development of custom scripts and stored procedures for data import and manipulation
• Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Migrated data from Heterogeneous Data Sources and legacy system DB2, Access, Excel to SQL Server databases using SQL Server Integration Services SSIS to overcome transformation constraints.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services SSRS
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 2005
• Interacting with the Database Administrator to maintain the database used DBCC Statements to perform maintenance tasks before backing up the databases.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Documented and maintained database system specifications, diagrams, and connectivity charts.

Environment:SQL Server 2000/2005/2008, Integration Services SSIS , Reporting Services SSRS , Analysis Services SSAS , DTS, C , .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS visual Studio, BIDS.

Confidential

ROLE: bo Developer

Responsibilities

• Involved in development of full life cycle Business Objects reporting applications.
• As a part of migration
• Built the Server and installed BO XI R3 on Production, UAT and Development server.
• Implemented dynamic prompts and cascading prompts
• Upgraded database drivers to connect to new data sources available in BOXI like Universe, XML etc.
• Imported report objects, users, groups, user rights, recurring schedules from crystal enterprise 10 to BOXI using Import wizard and BIAR files.
• Implement Unicode packs on BOXI to make BOXI environment UTF8 compatible.
• Extensively worked on Central Management Console
• Created 15 Universes for the report development.
• Involved in creating multiple Crystal 2008/XI, Crystal Xcelsius2008, Webi reports as per user requirements.
• Created multiple Crystal Reports 2008 that are using SAP ECC infosets as the data source.
• Used SAP FICO as data source Accounts Payable, Accounts Receivable sub modules to build financial reports for Georgia Department of Transportation.
• Customized info view.
• Created GDOT Dash Board using Dashboard Manager.
• Worked on Multiple projects for DOT as CMIS Contract Management , Pre-Construction, CARS Crash Analysis , State Aid, RRMS Rail Road Management etc.
• Involved in designing the Data mart and worked with database team to design the staging tables that would help make ETL process for bringing in the data and getting into data mart efficiently.
• Worked on Administration of BOXIR2 and BOXI CMC Security setup.
• Involved in Creating Repository, Creating Users and User Groups.
• Created Classes, Objects, cardinalities, Strategies, resolved loops using Aliases and contexts and checked the Integrity of the Universes.
• Used various Functions like Prompt for user defined queries , Where For creating conditional filters and Select.
• Involved in Creating Repository, Creating Users and User Groups.
• Development and Deployment of Complex Reports. Used multiple data providers, Union, Sub Queries and Stored Procedures.
• Worked on Performance metrics, created multiple reports using Crystal Xcelsius.
• Created Multiple KPI Key Performance Indicator reports for Crash Analysis and H.E.R.O projects.
• Created multiple SSRS reports as a part of CARS project.
• Converted existing Webi Reports to SSRS Reports
• Created and managed SSIS jobs to populate data to the staging and database tables.
• Worked with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Trained GDOT external as well as internal users in using info view and accessing reports.
• Worked on Remedy to track user requests and the developed work were well documented.

Environment: BOE3.0 R3/R2, Web I 11.5, Crystal Reports2008/XI,Crystal Xcelsius2008, Dashboard Manager, Data Integrator, Info View, Universe Designer, SSRS,SSIS,SQL Server2005, Microsoft Share point, Windows Server2003

Confidential

ROLE: BODeveloper

Responsibilities

• Business Object Universe, Business Objects repository were extensively used.
• Created Universe level objects and measures using the business rules provided.
• Created views to overcome loops and contexts in BO Universes
• Derived Tables, Aggregate awareness are used in BO Universes.
• Deployed, Scheduled published the developed and tested reports on BOXI R2 Production Servers.
• Maintained user security on the BO Universes.
• Web I Reports are created and deployed through Info View and Customized Web I Front end.
• Complex Crystal XI Summary as well as Detail reports are created based on business request.
• Created Auditor reports and tracked user access of reports and Universes.
• Performed data validation and analyzed test results.
• Maintained and Applied patches to Development, UAT and Production Servers to keep them in sync.
• Worked with Business Users to develop system requirements, analyze data Elements and continuous end-user support.
• Created different categories to simplify it to the users to locate the reports.

Environment:Business Objects XI R2, Web I 11.5, Crystal Reports XI/10, Crystal Xcelsius, Data Integrator 11.2,Info View, Universe Designer, SQL Server2005, Microsoft Share point, Windows Server2003

Confidential

ROLE: data analyst

Responsibilities

• Developing new reports based on BRC Business Requirement Documents for Oracle Applications on Inventory Maintenance reports, Order tracking, PO, ASN etc.
• Deploy the new reports on development server and Production Servers fixing issues raised by UAT.
• Designed various crucial reports on Inventory Transactions and Movements, Order status etc.
• Developed various Reports with sub-reports, parameters, summarizing data, on-demand sub- reports, LOV and drill-down.
• Developed Complete reports are unit Tested and successfully Deployed in Production Servers
• Interacted with Co Developers, Business users in gathering requirements for the Report Requests
• Migrated schedules from Crystal Enterprise 10.0 to BO XI R2 using import wizard.
• Developed reports depending on different time zones present for locations all over World.
• Designed various crucial reports on Billing Analysis and Accounting report, Inventory Inbound, Transaction Moves, Cycle Counts, Order status, On hand Quantity report and Adjustments and outage extract report to get the snap shot of database when there is system outage.
• Integrated all reports on BO XI and tested reports from info view.
• Involved in Creating Repository, Creating Users and User Groups.
• Re-mapping of Database Fields while migrating reports.
• Resolved data mismatches coming from different systems.
• Calling DB procedures from crystal reports using ref cursors.
• Used different data sources like ODBC, JDBC, Java Bean, Flat files depending on report requirement.

Environment:Business Objects XIR2, Web Intelligence, Crystal Reports XI, Crystal Enterprise 10/8.5, Crystal Reports 10/8.5, Oracle Apps 11i, Vantive 8.5, Oracle 10G, Oracle 9i,TOAD, PVCS VM, PVCS Version Control, Windows Server 2003