PROFESSIONAL SUMMARY:

• Around 12 years of experience in Software design, development, implementation and maintenance using Business Intelligence (BI) tools and database with the emphasis on BI Development using SAP Business Objects Universe design and reporting, Tableau, SAP Business Objects Crystal Reports XI, SAP HANA, SAP BW reporting using Business Explorer query designer (BEX), data warehouse, Database development using Oracle, MS SQL.
• Experience in various domains like finance, insurance, claims management, manufacturing.
• Worked as SAP Business objects developer with extensive experience in SAP Business Intelligence Tools - SAP BusinessObjects XI R2/XI 3.1/4.1/4.2 Information design tool, Universe Designer, Report development (Desk I/Web I), Info View, Import Wizard. Knowledge on SAP Business Explorer 4.1 based on universe.
• Strong experience in Tableau design and development of visualizations with knowledge on dimensions, measures, data source connectors, folder, calculated fields, parameters, sorting, filtering, hierarchies, publishing dashboards to Tableau server, scheduling reports using Tableau Server etc.
• Developed SAP Business objects Crystal Reports XI - Adhoc Reports, ~~~~ Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab and Graphical
• Expertise in SAP HANA Data modeling- Attributes Views, Analytical Views, Calculation Views, advanced modeling using restricted calculated column, variable, input parameter, constant filters, currency conversion. Acquired knowledge on SLT, SDA and other replication techniques to get data in SAP HANA. Created decision table and used it in the calculated view. Created user, privileges
• Experience in SAP BW reporting using Business Explorer, Analysis for office using RKF, CKF, free characteristics, filters, conditions with understanding of infocubes, multiproviders concepts of SAP BW.
• Extensive experience and solid understanding of Data Warehousing, Star, Snow Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts
• Experience in Oracle 11g, MSSQL 2014 with working knowledge of SQL and PL/SQL. Involved in creating tables, views, indexes, packages, stored procedures
• Received a Technical Excellence Award from Confidential Technology Solutions Lab Private Limited, Bangalore (A CMMi Level 5 Company), in recognition for outstanding technical achievements in Core Processing Tools Development
• Received a Team Excellence Award from Confidential Technology Solutions Lab Private Limited, Bangalore for Excellent Contributions made towards successful completion of Initial release of CorePT Ready Project having huge and Complex effort and work involved which included Requirement Capture, Design and implementation responsibilities.
• Strong technical skills and consistently delivered high quality results within aggressive time constraints
• Committed and ready to learn
• Strong Analytical Skills

PREVIOUS EXPERIENCE:

Confidential, Memphis, TN

Software: SAP HANA 1.0 SPS12, Business Explorer Designer, Business Objects BI platform 4.2,SAP BW 7.4

Responsibilities:

• Involved in requirement gathering
• Designed and implemented SAP HANA data modeling using Calculation View based on requirement documents
• Created calculated measures, restricted measures, input parameters and constant filters to satisfy reporting requirements
• Worked with Admin team to setup SLT for real time replication for ECC tables
• Using Information design tool (IDT), created relational connection, data foundation, business layer based on the information models
• Created WEBI reports based on the universe
• Created BEX queries based on the requirements and created webi reports based on BEX queries
• Involved in transporting the queries from one environment to other environments
• Acquired knowledge on SAP BW concepts like infocubes, multiproviders, DSOs

Confidential, Memphis, TN

Software: SAP Business Objects BI platform 4.2,Oracle 11g SQL, Oracle Hyperion reporting tool, Tableau 10

Responsibilities:

• Responsible to analyze and understand report implementation in Oracle Hyperion reporting tool and replicate the requirements in SAP Business Objects 4.1 to develop webi reports
• Created 40+ Webi reports single handedly based on requirements when the timelines were stringent
• Made required changes in the universe by adding required columns, list of values, filters in the universe
• Developed dashboard to give the summary and detailed view of the business based on the requirements using Tableau.
• Published dashboard on Tableau Server

Confidential

Software: Tableau 9, SQL Server 2014

Tech Lead

Responsibilities:

• Designing Tableau visualization as per Business Requirements Specification document
• Developed Tableau visualization and dashboards using Tableau Desktop
• Created sets, Calculated fields, parameters for preparing dashboards and worksheets
• Published Dashboard on Tableau server. Experience in scheduling reports

Confidential

Software: SAP HANA, Information Design Tool, SAP Business Objects BI platform 4

Responsibilities:

• Involved in defining the scope of the POC and requirement gathering process
• Created attribute view, analytic view, calculation view using database tables based on the requirement
• Understanding of creating calculation views using SQL and CE functions
• Created decision tables and used decision tables in creating calculated view
• Created users, Roles, privileges, Packages, schema as part of HANA security and development.
• Created universes using information design tools based on the SAP HANA calculation view
• Create webi reports based on universes
• Acquired knowledge on data replication methods like SLT, BODS, SDA

Confidential

Software: Business Object XI Release 3 Infoview and Universe Designer, Desktop Intelligence, Oracle 10g SQL

Tech Lead

Responsibilities:

• Designing universes as per Business Requirements Specification document
• Earlier customer was using Deski tool of Business objects which is older version. Convinced customer for using Webi (latest version) over deski by creating POCs
• Worked as a project manager for FARR project
• Involved in activities like identifying project delivery milestone, scheduling, preparing project plan and resource planning
• Represented team in Monthly Review meetings conducted by stakeholders
• Team management activities, conducted status meetings
• Worked closely with Business Analysis’s to understand the business requirements and was part of requirement gathering and design process

Confidential

Software: Oracle 10g SQL, SAP Business Objects BI platform 4

Technical leader

Responsibilities:

• Create universe using Information design tool for multiple data sources
• Upgrade existing universes and reports to display information as per the client request
• Review of requirement document, technical design document and test documents based on the requirements/ guidelines
• Writing SQL queries to perform unit testing of the reports

Confidential

Software: Oracle 10g, Business Object XI Release 2 Infoview and Universe Designer, Informatica

Technical leader

Responsibilities:

• As a technical leader headed the team of Business Object XIR2 developers, developed BOXIR2 reports and worked with the team to release the reports on time
• Designing universes as per Business Requirements Specification document
• Creation of WebI reports based on the universe created
• Design and develop new custom reports using Crystal Reports
• Responsible to support the issues with the report on the Business Object Enterprise environment like FRT, UAT and production
• Planning and scheduling project activities
• Resolution of conflicts between project and cross-functional teams
• Management of day-to-day activities of project and project status reporting
• Preparation and maintenance of project documents
• Managed activities of Continuous Improvement Council (CIC)
• Responsible for technical review of deliverables prepared by team before submitting to client for correctness, completeness and to check if deliverables adhere to project specified format

Confidential

Software: Oracle 10g, SQL, Business Object Crystal Report XISAP BusinessObjects XIR2

Responsibilities:

• Development of WebI reports based on the universe
• Upgrade reports to display information as per the client request and bug tracking
• Modification of universes as per client requests
• Design and develop new custom reports using Crystal Reports
• Involved in review of mapping document for requirements/ guidelines
• Worked on transformation queries
• Analysis and verification of transformation process output against mapping document
• Production support reporting

Confidential

Software: Oracle 8i, Developer-2000 Forms - 6.0

Project Development

Responsibilities:

• Preparation of project plan
• Worked as Quality co-coordinator for the team
• Conducted Root cause analysis
• Requirement Collection for Validation and Verification module, Data Utility, Selection Utility and Selection Tool module from Confidential INC specification document, Customer requirements for CorePT IT.
• Preparation of Software Requirement Documents (SRD) based on the collected requirements. These documents are referred for preparation of test cases.
• Involved in development of Data Utility, Selection Utility and Validation and Verification module
• Involved in identifying and documenting testing methods for all the modules
• In maintenance phase worked on updating modules based on the Software Change Request (SCR)
• Created procedures, function based on the requirement using Oracle 8i
• Involved in writing and executing test cases based on SCR

Confidential

Software: Oracle 8i, Developer-2000 Forms - 4.5, Report- 2.5

Responsibilities:

• Involved in Designing of database tables
• Involved in Coding for the GUI entry forms along with validations. Along with customization of the modules for different companies
• Involved in Testing of the modules
• Involved in Designing, coding and testing of reports