SUMMARY

• Over 6+ years of experience in the industry with expertise in SAP Business Objects XIR2/3.x/4.x, SAP HANA modeling, Data Warehousing, and strong analytical skills in SAP BW, SAP ECC. He has provided professional services to different industries. His experience comprises of complete project life cycle development, applying efficient software methodologies and quality assurance.
• Confidential is an outstanding problem solver, solution provider and is able to work in a fast - paced and complex environment as a Business Objects developer and BI Analyst. Over 3 years of experience in applying Agile software development methodologies to effectively capture changing requirement, reduce defects, engaging project stakeholders in feedback loops and consistently delivering business value (ROI). In addition, he has acquired excellent professional consulting skills including building client’s expectations, working with troubled accounts, helping the client in understanding the technology/solution, applying pragmatic perspective towards innovation, mentoring the staff and creating statement of work for the team members based on project plan/letter of engagement.
• Confidential has expert level hands-on experience with SAP HANA, Data Modeling, SAP Business Objects (Webi, IDT, Universe Designer, Lumira, BO Explorer, Dashboard & Design Studio, SAP BW connectivity with BO using BICS and OLAP Universes). In addition, he has implemented BI Strategy at several clients, which encompasses Information Delivery methodology, Selecting right BO tool for right analysis, BO health-check, Rationalization of reports, Defining user training, User access level, Tool adoption and Providing enhanced user experience.

TECHNICAL SKILLS:

SAP Business Intelligence: SAP HANA 1.0 SPS7 SAP BW Analyst

ECC Analyst: SAP Business Objects XI R2/3.x/4.x Business Intelligence Suites

Development tool sets: Business Objects 4.0, 3.0 and 3.1, Oracle Business Intelligence Enterprise Edition 10g, Hyperion Database Warehousing

and OLAP Technologies: DB2, Oracle, 9.0 / 10g, Teradata, Microsoft SQL Server, MS Access

Data Modeling (ETL): Data Stage, Informatica, Business Objects Data Integrator

Programming Languages: Visual Basic Macro / Scripts, HTML, C++, Java

Applications: MS Office Suite, MS Visio, MS Project, SQL Navigator, TOAD, Mercury Load Runner

Professional Experience: American International group, Jersey city, nj SEP 2013 - present

PROFESSIONAL EXPERIENCE

Confidential

HANA Consultant

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support. Participating in the blueprint and design sessions, reviewing options and providing recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders.
• Involved in several projects to translate business KPIs into HANA models.
• Designed complex data models in HANA that assimilate data from multiple sources system (SAP and non-SAP) to effectively and efficiently solve business requirements.
• Performed HANA modeling and developed Analytical views for the transactional data, Attribute views for the master data, Calculation views and ANSI SQL / SQL Scripts.
• Performed HANA modeling by following SAP best practices against BigData. Created several models against >400 million rows transitional tables with 25% YoY growth factor; by maintaining the SLA of under 10 sec query response time.
• Used pre-defined HANA Business Library functions and Predictive Analytics Library (PAL).
• Implemented SLT replication from ECC to HANA System to achieve real-time analytics.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Created several Webi reports, Universes, Dashboards, Advanced Analysis, as part of several analytical implementations at AIG.
• Created universes (using IDT) on HANA views to expose the data in BO 4.0/4.1 Webi.
• Optimized the SAP HANA view for Ad-hoc reporting using Webi and BO Explorer.
• Created dashboards with functionality and features such as What-if analysis, Alerts, Drill Down, Filtered Rows and Dynamic visibility.
• Leveraged aggregate aware in the ad-hoc universes to dynamically select appropriate aggregate layer (fact table) based on the dimensions selected by the business users.
• Implemented functionalities like Drill filters, Breaks, Sections, Hyperlink, @variable, @prompt
• Scheduled Webi reports to users using BI Launch pad.
• Involved in performance tuning and optimization on Business objects reports and Universes.

Environment: SAP HANA 1.0, Business Objects 4.0/4.1 Webi (OLAP & Relational), Lumira, OLAP Analysis for Web/Excel - OLAP, Dashboards 4.0

Confidential, Memphis

Consultant

Responsibilities:

• Led the Confidential Business Intelligence infrastructure assessment and Operational reporting project for Confidential SAP logistics and SAP Source to Pay.
• Developed and monitored project plan to ensure timely delivery and maintained an overall resource assessments; and ensured accurate requirements are gathered that meet current needs and provide flexibility for future growth.
• Worked with the client’s management to perform Proof of Concept to demonstrate the enhanced dashboard capabilities of Business Objects 4.x and documented the proposal and resource assessment, resource capacity planning for client to initiate the project.
• Effectively facilitated meetings, communicated objectives and prepared project status reports and kept Business Objects management, Confidential sponsors, and others informed of project status and related issues on a recurring basis.
• Performed hand-on development of BO Webi / Crystal Reports, Dashboards, and Universes to meet the Logistics OpR reporting project.
• Supported the Business Objects server and implemented the server sizing based on server utilization and performance. In addition, reviewed the reporting database performance by running database explain plan on the Business Objects WebI report’s queries and recommended BO universes and reporting databases best practices to improve the performance.
• Hand-on experience with writing advance custom SQL and conducting through data validation of reporting layer by reverse-engineering the business transformation logics and going against the data sources
• Reviewed the Business Objects Enterprise Security requirements and gave recommendations to create a robust, low maintenance and highly secured security model and setup the Business Objects Enterprise audit database, universes and reports.
• Created detailed recommendations and best practices document for reports, universes, BO 3.x Security recommendation and reporting projects complete life cycle development steps.

Confidential, JERSEY CITY, NJ

SAP Business Objects Analyst

Responsibilities:

• Worked on Business objects reports, Webi reports, Universes, dashboards.
• Interacted with business users and business analysts for understanding requirements to build universes/ reports for users.
• Created WEBI reports, Advanced OLAP analysis for Webi reports.
• Involved in Project planning, maintaining different phases of the projects.
• Extensively worked on end-user requirements, business data requirements, analysis and study and efficient in testing SQL queries and stored procedures.
• Developed Canned, Standard Interactive Analysis reports, Webi reports.
• Created, maintained, and updated several universes using Universe Design tool.
• Analyzed existing stored procedures to create simple queries to create crystal reports.
• Involved in performance tuning and optimization on Business objects reports.
• Created universe to access non-SAP Data.
• Scheduled Business object Reports to users using BI Launch pad.
• Designed and Documented Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Provided training to end users about basic functionalities of using reports, such as ‘opening reports, using prompts, saving reports in different formats, scheduling reports, etc.

Environment: Business Objects 3.x Webi reports, Xcelsius 2008, SQL Server 2008.