SUMMARY:

• A highly accomplished Programmer/Developer with more than 12 years Information Services experience focused on all aspects of computing services with extensive experience in Financial Reporting and migration in SAP BOBJ. Worked in SAP BW and deep Data modeling and SQL experience. Focused on results with a passion for taking on new challenges. Finished multiple projects in SAP BI, SAP BO and Oracle programming. Trained in SAP BODS, Lumira. Client - focused, Committed, Creative, Deadline-oriented, Dependable, Disciplined, Focused, Hardworking, highly motivated, High-performing, Mature, Multi-task-oriented, Organized, Reliable, Well-qualified and Analytical. Experienced Analyst with diverse industry in Healthcare, Pharmaceutical and Oil and Gas.
• Interacted business stakeholders in enterprise and Worked with Business Analysts and User Groups
• Web Intelligence: Designed complex Advance multiple Report
• Designed chart, visualizing data range using parameters, Series, interactive model.
• Extracted data from SAP BI and Oracle. Created Aliases and Contexts to fix loops.
• Transport Reports and IDT between Dev, QA and Prod. Created Version Management.
• Designed Complex Crystal Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic Grouping, formulae, Parameters, Selection criteria. Wrote several SQL queries.
• Created Users, Groups, privileges to End users, migrating universe and reports between Prod & QA and Dev.
• Designed Visualized charts, Dashboards, Interactive charts
• SLT, Informatica, SAP BI 7.0, Got BODS and Informatica tool training and working exposure.
• More than 8 years experience in Oracle RDBMS, PL/SQL, and Modeling .
• Created Tables, Views, DataSource and Functional Modules.
• Exposure to Predictive Analysis Library.

TECHNICAL SKILLS:

• HANA HANA 4+
• Tableau Tableau 10.1 2
• SAP BO 4.1 & 3.1 SAP BusinessObjects 2+
• SAP BW 7. 0 SAP BI7.0 1+
• Oracle Programming PL/SQL, Reports, Forms 8
• ABAP SAP ECC 6.0 Deep exposure
• Increased revenues by R&D on duplicate Insurance claims reducing cost in healthcare.
• Lead migration of data from Microsoft Access into Oracle. Designed reports and forms.
• Migrated Schema tables from Microsoft Access into Oracle 9i self in healthcare.
• Designed Document for migration from SAP BO 3.1 into BO 4.1
• Planned Actual time to be devoted on projects against time that was budgeted for the project.
• Designed B. Ex, BO and Dashboard Labs for junior consultants.
• Trained end users and online training.
• Designed Integrated dashboards for demo to clients.

WORK EXPERIENCE:

Confidential

Senior SAP Architect

Application: SAP HANA Release SPS12

Database: Oracle

ETL: SAP BODS

Responsibilities:

• Plan the Project: considered the scope of the project, the time available according to the deliverable dates, the resources, the length of services downtime, the training and the backups and Involved in information gather phase
• Implemented full cycle of project on SAP HANA
• Involved in business and Architecture discussions.
• Worked closely with SAP Technical team on implementing the Health and safety project on HANA.
• Used Oracle as source DB and HANA as target with SAP Business Objects Data Services as ETL.
• Managing Attribute Mapping and Creation of Constant columns.
• Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges.
• Designed Schema and Store Procedures. Created, Cleaned and inserted data in tables using functions, DDL and DML SQL script. Have extensive experience of Modeling, independent and team player.
• Created Schemas as part of HANA Security and Development.
• Create cardinality and modeling in relational database applying normalized rules.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View and Calculation View applying star schema joining fact tables and dimensions.
• Applied Restricted and Calculated measures, input parameters and filters.
• Developed complex Graphics and SQL and CESQL Scripting in Calculation views applying Unions and Joins.
• Exposed to ETL using SAP Data Services 4.0 and connected Oracle to HANA in BO 4.1 Confidential .
• Designed Information Design Tool creating relational connection, Data Foundation and Business Layer Universe for HANA reporting.
• Developed Web Intelligence Reports and supported Dashboard creation.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report.
• Training: Provided training to End users
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’
• Participated in the complete development lifecycle: analysis, design, build and test reports.
• Transport Contents: Migrated Hana contents Schema and Packages between Dev, QA and production through Life Cycle Management, Delivery Unit. Worked on Authoring and Physical Schema mapping.
• Integrating HANA views with Reporting tools BOBJ

Confidential

Application: SAP Hana 2.0

Database: SAP

ETL: SLT

Responsibilities:

• Interacted with Business stake holders to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains.
• Designing Views (Attribute View, Analytic View, Calculation View). Applied Restricted and Calculated measures, input parameters, filters, Hierarchy, Variables and Currency conversion. Designed Calculation views with graphic and g SQL Script. Worked on Decision tables
• Extracted data from Legacy system ECC 6.0 applying SLT and creating RFC.
• Bringing Data from ECC and Flat files.
• Created Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges
• HANA content from Dev environment to Production environment using delivery units.
• Troubleshooting the Performance Issues
• Client Testing Step by Step Business Review with the Client and IT Team.
• Evaluation and Decision Detailed Presentation to compare As-is and proposed HANA Scenario

Confidential

Application: Tableau 10.1 Visualization

Responsibilities:

• Involved in creating database objects tables, Materialized views, procedures, triggers, and functions in Oracle.
• Tested, Cleaned, and Standardized Data to meet the business standards.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Creat ed action filters, parameters and calculated sets for preparing dashboards.
• Restricted data for users using row level security.
• Provided 24/7-production support for Tableau users.
• Administer user, user groups and scheduled instances for reports.

Confidential

Application: SAP BI/BO 4.1 - Design IDT (Universe) and Webi.

Methodology: Applied Agile Methodology

BO Solution Architect

Responsibilities:

• The complexity of the Architectural Design is quite high. The target is to simplify the IDT of 10 Fact and 180-dimension tables and move the new landscape over Webi reports.
• I worked for the initial design documents for the client to give them a complete picture and high-level proposals, universe modeling and Webi report designing.
• Training: Provided training to End users

Confidential

Sr. Business Objects Developer/Administrator

Application: SAP BO 4.1

Responsibilities:

• Responsible for providing support to servers. Providing support to End Users for Confidential .
• Confidential - Creating Roles and Users migrating reports and universes between DEV, QA & Prod. and daily support
• Monitoring live charts to ensure correct information displayed.

Confidential

Senior Integrated Consultant

Responsibilities:

• Continue relationships with client management to handle expectations of service, together with work products, timing and deliverables.
• Worked on data warehouse project, which comprises of providing data for reporting purposes. It includes understanding of the business requirements, catering to those requirements by providing a solution.
• Involved in monitoring the performance of the system and reporting which includes performing Aggregates, Indexes, Archiving the non-cumulative info cubes and Partitioning.
• Worked with the implementation team in SAP BI/BW 7.0 and BOBJ XI 3.1

Confidential

Application: SAP BI - Implementation and Development. Includes advance

BI Reporting tools: BI- BO- Web Intelligence.

Responsibilities:

• Continue relationships with client management to handle expectations of service, together with work products.
• Timing and deliverables. Worked on data warehouse project, which comprises of providing data for reporting purposes. It includes understanding of the business requirements, catering to those requirements by providing a solution. Involved in monitoring the performance of the system and reporting which includes performing Aggregates, Indexes, Archiving the non-cumulative info cubes and Partitioning. Worked with the implementation team in SAP BI/BW 7.0.
• Created InfoCubes, DSO objects and MultiProviders InfoObjects and SAP Business content objects using Customer namespace in SAP BI/BW 7.0
• Worked with Business Analysts and User Groups to gather the analytics requirements from different user groups and involved in providing the approach for the solution
• Worked with BOBJ business users, Project Managers, Architects and involved in requirement gathering, analysis and creation of best practice architecture
• Universe Design: Universe planning building and implementation
• Web Intelligence: Created Advance multiple Ad hoc query reports
• Xcelsius: Chart with visualizing data range using parameters, Series, Interactive model, Query as a Web Service

Confidential, Southfield, Michigan

Senior Programmer

Responsibilities:

• Involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency & customer service and standardize documentation process
• Delivery of OBI development and maintaining OBI Best Practices
• Reviewed the deliverables and ensure that the deliverables meet client requirements
• Accomplished Peer-a-Med project using Oracle roll ups and scripts.
• Oracle PL/SQL, SQL, SQL*PLUS and TOAD: Created Procedures, Functions, Triggers, tables, Views and fixed inconsistent data receiving monthly
• SQL*LOADER: Loaded and fixed date, created control files, loaded with Store Functions and applied business rules to remove duplicates. Converted MS Access data and reports into Oracle.
• Oracle Designer: Created data modeling and Schema, applied business rules and Cardinality
• Developer 2000: Created User Interfaces for direct input of data as per user requirements using Oracle Forms and Financial Reports using lot of parameters
• Visual Cactus: Mapped data and loaded back in Oracle 9i
• Discoverer: Created and customized Oracle Discoverer Administrator data for client facility
• Interacted with business users, stakeholders, and IT staff to help define business requirements
• Crystal Reports: Provided report generation solution to the clients using Crystal Reports.
• Provided support in Oracle 10g PL/SQL in modeling, designing schema and writing complex queries.