SUMMARY

• Software professional with hands on experience in Business Intelligence and Client Server technologies for over 12+ years with a track record of successful solution implementation in development, enhancement and support engagements.
• Expertise in complete Business Intelligence lifecycle including requirements gathering, design, development, testing, deploying, maintaining and providing end user support.
• Expertise in design and develop comprehensive Business Intelligence solutions using BI tools, reports and dashboards.
• Demonstrated analytical skills with a solid understanding of BI development.
• Well known for very strong troubleshooting skills.
• Extensive experience in SAP Business Objects environment including report /universe development, administration, migration, upgrade and implementing best practices.
• Proficiency in Crystal reports development and proficient in SQL and PL SQL procedures.
• Having strong knowledge in data modeling, star schema and data warehouse concepts.
• Thorough Experience in IIS web server, Tomcat and Apache web server.
• Extensive Experience in Microsoft Visual basic 6.0 and Active Server Pages.
• Thorough Experience in HTML, DHTML, VB script, Java Script.
• Proficiency in MS Excel and Macro using Visual Basic for Applications.
• Proficiency in preparing project related documentation (functional design, technical design, test scripts, quick reference guides) during the different stages of a project.
• Cross training for team members and training for power users.
• Hands on experience in creating and executing Test plans and test cases for Unit Test, System Test and Integration Test.
• Review processes, review records, defect tracker and experience in Software configuration management tools.

TECHNICAL SKILLS

• SAP Business Objects 4.1 4.2 XI 3.1 R1/R2 6.5.x
• Crystal Report 9/10/ XI/ 2008
• Xcelcius 4.5/2008
• Info view
• CMC
• CCM
• CMS
• Desktop Intelligence XI
• Rich Client
• Web Intelligence
• Business View Manager and Live Office.
• Informatica
• Microsoft SQL Server DTS
• SAP HANA
• Oracle
• SQL Server and Teradata
• Microsoft Azure.
• Microsoft Visual Basic 6.0
• ASP
• IIS
• HTML
• VB Script
• Java Script

PROFESSIONAL EXPERIENCE

Confidential, Nashville, Tennessee

Tech Lead

Responsibilities:

• Universe design using Universe Design Tool and Information Design Tool with advanced functionalities such as multi data sources, hierarchies, and aggregate awareness, derived tables, and row /object level security, custom LOVs and contexts.
• Enhancements in EPIC's Professional Billing and Meaningful Use universes and set up Meaningful use dashboard per user needs.
• Complex ad - hoc and standard reports, dashboards in Web intelligence and Desktop Intelligence and Crystal reports, Live Office and QAAWS. Advanced functionalities used were Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi-Dimensional Analysis, Variables, alerts and Sub Queries.
• SQL/PLSQL queries for free hand SQL reports and for troubleshooting and resolving data related questions/ reporting issues.
• Business Objects in XIR3 and SAP BI4.1 and 4.2 implementation, installation, migration, upgrade, patching, configuration, maintenance, technical support and troubleshooting.
• CMS Clustering, Kerberos AD Authentication, SSO, BI server creation/configuration, managing access levels, Groups, Users, Folders, universes using the tools such as Central Configuration Manager (CCM), Central Management Server (CMS) and Administrator’s Cockpit.
• Created SDK program objects manage jobs/publications.
• Implemented object package with Excel Macro to mimic similar Desktop Intelligence’s SDK formatting in Web intelligence excel output as part Deski to Webi conversion.
• Content analysis using audit database to troubleshoot error patterns / root cause analysis.
• Conversion of desktop intelligence reports from XIR3 to 4.1 Web intelligence using report conversion tool as well as manual conversion process.
• Perform testing of Business Objects support packages and patches and implement best practices such as regular audits, automated server failure alerts, job failure alerts using, SDK, Splunk and monitoring data.
• Address end user problems/issues in Business Objects area and provide technical solutions.
• Monitor, maintain and optimize production systems. Investigate and resolve incidents reported by users. Identify opportunities to automate, consolidate and simplify platform.
• Created Test plan and Test cases for Business Objects 4.2 upgrade project, to test functionalities between current (SAPBI 4.1) and proposed Business Objects (SAPBI 4.2.) versions.
• Created and executed test cases for EPIC, Patient Financial and Internal Audit Business Objects Universe enhancement validations in QA environment and the results were shared with respective stake holders for further actions if any.
• Created and executed test cases and SQL queries to validate data in Business Objects reports, i.e., compare aggregated results in Business Objects reports with the results of SQL queries.
• Prepared test data to validate reporting requirements in test environment.
• The defects identified in QA environment, such as difference in data, report formatting, data formatting, naming conventions in universe objects, report fields, database table/field mapping in Business Objects universe, database connections in Business Objects Universe, data restrictions and Business Objects access issues and content security were fixed and tracked to closure.
• Support for User Acceptance Testing (UAT) and fix issues identified and ensure timely UAT sign off.

Environment: SAP Business Objects 4.1, 4.2 and XIR3, Teradata, MS SQL Server, DB2, Windows Server.

Confidential

Project Lead

Responsibilities:

• XIR2 to XIR3 upgrade:
• Conducted survey with end user community to find out the required reports/universes that are to be migrated.
• Created inventory to eliminate unused objects/reports/universes/users from repository.
• Migrated Business Objects environment from Business Objects XIR2 to Business Objects XIR3
• Windows 8 server setup which includes required software installations such as ODBC drivers, Sybase client, oracle client, Tomcat, IIS and Apache HTTP servers and created service accounts with required principles.
• Business Objects server software installation in the Windows8 servers and configuration of various services /servers.
• Co-ordinated with networking and LDAP team for opening required Ports, Firewall setup and Service Account setup
• Implemented Kerberos Authentication for Windows AD authentication
• XIR3 CMS Clustering for CMS Load Balancing and Fail Over
• BIG IP set up for webserver Load Balancing and Fail Over.
• Apache HTTP server configurations and Tomcat setup and configuration for Infoview portal.
• Web.xml modifications/configurations for CMS clustering and load balancing and Home page set up such as authentication list box visibility etc.
• Implemented LCM (subversion) for version control of universes and reports.
• Test cases has been created to test the requirements defined for report conversions, universe and report migrations.
• Extensive testing done to ensure data correctness for personal data file reports. (excel, text files, issues were mostly on the object qualifications such as Measures turned to Dimensions and vice versa)
• Reports were tested to meet Cosmetic requirements between the environments after migration.
• To achieve 100% data correctness, data from the reports has been exported to Excel files and compared with SQL result sets using Excel Formula, Pivot Tables etc...
• Test results were documented and shared with stake holders for further actions and closure of issues if any.
• BO Universe and Reports for Oracle EBS:
• Requirement gathering for the reports and universes and created requirement, design documents.
• Designed a data mart from Oracle EBS standard report SQL queries.
• Created Business Objects Universes and Implemented data security using Row level access restriction and Object level security.
• Implemented Folder level access restriction on top of Row level and Object level restrictions.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulas.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Used Global Filters, Block level filters, Ranking, Alerts and Conditions to achieve report functionality.
• Migrated reports from Development to QA and from QA to Production Environment.
• Created and executed test cases to validate results of Oracle EBS queries.
• Testing has been done to validate data between Oracle EBS reports and Business Objects reports.
• Test cases has been executed against the data mart to validate data quality.

Environment: SAP Business Objects XIR2, XIR3, Oracle EBS, Sybase, Teradata, MS SQL Server, Windows Server.

Confidential

System Analyst

Responsibilities:

• Requirement analysis on the functional requirement and convert them to technical design.
• Identification of the source systems with the help of Business Analysts.
• Performed Data Analysis and identifying the logical relationships between tables and data quality for design.
• Created various documents such as requirements, design, analysis, report functionality, data provider. Designing and Building of Universes, Classes and objects
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Development of reports using Business Objects Deski and WEBI to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Migrated reports from Development to QA and from QA to Production Environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Used Filters and Conditions to achieve report functionality.
• The major task in BOL project was moving data and the Business objects reports, Universes and repository which were being used in the business to the corporate servers.
• The issues identified at the time of migration in BOL for both in business objects and data warehouse were fixed, tested and made the system stable, up and running.
• Conversion of BO SQLs to use in MVP Cockpit Java application.
• Testing of BO reports and User Training in Business objects functionalities.
• Published and scheduled Business Objects Reports to users using Scheduler.

Environment: SAP Business Objects XIR2, Oracle, MS SQL Server, Windows Server, Java, JSP.

Confidential

System Consultant

Responsibilities:

• Design, coding and implementation of CBR application in Microsoft Visual Basic 6.0
• Data modeling for the required tables, table creation, stored procedures.
• DTS packages for data transformation from excel files to MS SQL Server.
• Universes have been created for each of the applications and security has been set up using Supervisor module.
• The required reports for CBR application are being developed in Business Objects. A tabular report which talks about the number of queries downloaded per type, a line graph for Aging report, A crosstab report to find out the performance of the agents- based on aging, i.e. number of total open items on each age and the total of all the open items are the few reports to name.
• The reports for JAD application were created in Desktop Intelligence which talks about various stages of an item like, open, reconciled, reviewed and rejected.
• Reconciliation template report for JAD is a master detail report which talks about the source item with the details and the status based on the corporate criteria assigned to them like reconciled / not reconciled etc., reconciler performance graph, reviewer performance graph, overall team performance - actual items assigned, closed, open on a given day
• Reports for Scoping and RPN were created in Desktop Intelligence using Universe, Excel and PLSQL data providers.

Environment: SAP Business Objects 5.1, Oracle, MS SQL Server, Windows Server, Visual Basic 6.0, Excel and Microsoft Access database.

Confidential

Developer

Responsibilities:

• Prepare reports like Order Status Report, Bank transaction Statement, Agent Commission Report using in Crystal Reports 8.5 for Confidential module.
• The report module for Sub-Contract Management is used to ensure the Goods availability, Job Pending and Issue list.
• Developed Confidential modules in Visual Basic 6.0
• Module and Application integration testing.

Environment: Visual Basic 6.0, Crystal Reports 8.5, MS SQL Server, Windows Server, Excel

Confidential

Developer

Responsibilities:

• Developed ASP modules including coding, documentation, version control and code review.
• Module and Application integration testing.
• Created reports in Crystal Reports

Environment: ASP, Visual Basic 6.0, Crystal Reports, MS Access, Excel and Windows Server.