SUMMARY:

• Over 10 years of experience in IT working with top Enterprise data analytics tools such as Business Objects, Crystal Reports, Cognos, Informatica, ER Studio.
• Over 9 years of Experience in Business Objects 4.x/3.x/ XIR2 (Designer, Infoview, Launchpad DeskI/WebI, Scheduler, Publishing, CMC, CCM).
• Over 9 years of strong experience in developing, designing and Modifying Business Objects. Universes and Reports and other Data solutions from end - to-end.
• 9 Years of experience in Oracle 11g/10g/9i, SQL Server 2000/2005/ 2008/2012 R2
• 2 Years in Architecture of to help define the Enterprise-wide BI reporting and analytics platform
• 3 Years in SAP HANA Modeling, Administration and Architecture.
• Over 2 Years in Hadoop (e.g. HDFS, Spark, Zepplein, Hive, Hbase, Pig, Scoop, Ambari)
• US Citizen
• Providing Data Architecture for End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Expert in data analysis, designing, developing, modifying, updating, maintaining and distributing an entire Data warehousing project; end-to-end expertise.
• Expert at various Business Objects Modules and Tools: Designer, Deski/Desktop Intelligence, Webi/Web Intelligence, Dashboards, Import wizard, Report conversion tool, Central Management Console (CMC), Central Configuration Manager (CCM).
• Detailed understanding of Data Warehousing & RDBMS concepts (Kimball/Inmon/Codd).
• Good experience with ETL tools such as SAP Data Services & Informatica 9.1 (Designer, Workflow Manager, Monitor)
• Good working knowledge of HTML, CSS, JavaScript.
• Good working knowledge of Java and Python.
• Experienced in Networks, and Intrusion detection tools (Snort).
• Diversified experience in implementation of report management within Finance, Pharmaceuticals, banking, Sales, Marketing and Supply Chain Management sectors.
• An enthusiastic, project-oriented team player with leadership skills and with an ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Tools: Business Objects (4.x/ Xi 3.x/Xir2/6.5), Designer, Deski/Webi, CMC, CCM, LCM, Report Conversion Tool, Translation Manager, Import Wizard, Explorer 2.0, Crystal Reports 2008, Crystal Xcelsius 2008, Dashboard Design, SAP Design Studio, SAP HANA, QlikView, ableau, Cognos, Microstrategy, Toad 9.1, Hadoop (HDFS, Spark, MapReduce, Hive, Hbase, Pig, Scoop, Ambari), SAP HANA (HANA Studio, Work Bench, Modeler, SLT, XSJS, XSDS, XSODATA, UI5)

Internet Technologies: Web Intelligence (thin client), InfoView, LaunchPad, InfoBurst, Report Studio,SAPUI5, SAP Cloud Strategies

Reporting Functionalities: Master/Detail, Slice and Dice, Drill up/down, Conditions, Filters, Charts, Alerts, LOV, Context, Aliases, Universes, Reports, MDX, SQL, Formulas, Scheduling, Cross tab, Joins.

Database: MS Access, MS SQL Server 2000/2005/2008, 2012 R2, MS Access, Oracle 11g/10g/ 9i/ 8i

Languages: SQL, HTML, JavaScript, Java, Python, R

Operating Systems: Windows 95/98/2000/XP/Vista/Windows 7, Unix, MS DOS

Utilities: MS Word, MS PowerPoint, MS Excel (Advanced)

PROFESSIONAL EXPERIENCE:

Confidential, AZ

Sr. Lead Architect

Responsibilities:

• Created technical specifications and visual mock - ups of Hadoop Ecosystem, new generations DB vs. traditional RDBMS to educate the client about the rapid market changes.
• Worked with the existing staff to understanding their data requirements and the direction they intend to go with Predictive Analytics to and the goals that they hope to accomplish.
• Effectively meet with business representatives and engage with business leaders to understand critical business requirements and identify ways that the data infrastructure can be best supported to optimize business growth.
• Work with client Infrastructure and Server teams to install, configure, and deploy special case Web and App Servers to meet project needs.
• Creating a Data warehouse and a new reporting platform using Microsoft stack (SSIS, SSRS, Visual Studio, SSMS).
• Testing out multiple different cloud DB environment deployments (Amazon vs MS Azure) to see which would fir the customers needs.
• Installation & Configuration of HortonWork s Hadoop Sandbox Platform (Configuration of Amabri, Atlas, Ranger, Zepplein, Falcon)
• Testing out Spark RDD sets with SAP HANA Vora and its Data Modeler on Apache Zeppelin to test the compatibility between the two open-source software.
• Testing Hadoop Hive DB capabilities to plug into SAP Lumira 1.31 and Tableau 10 to do a comparison to see which tool is optimized to work with Hadoop ecosystem.
• Gave power user training on SAP BO Lumira, and use case analysis of Lumira vs. Design Studio.

Environment: SAP HANA sp11, Hortonworks Hadoop (Ambari, Pig, Hive, Tez, NiFi, Spark), HTML, JavaScript, Business Objects 4.1 sp7, SAP BO Lumira 1.31

Sr. Data Warehouse Developer

Responsibilities:

• Big Data Use Case: Being the biggest Missile Company in the world meant dealing with complex, ever growing missile data, and to help various engineers make sense of what it is that goes wrong during flight, tests etc. Our pilot project used Hadoop (Spark, Python, Pig, Sqoop, Ambari, Hive) to crunch petabytes of data collected by sensors during the flight of a certain branch of missiles. Based upon the data collected during certain tests, that data, once sifted thru Spark RDD, and cleansed (via Pig & Sqoop) is channeled up into the predictive logarithm capabilities of Hadoop (tested via Python predictive library) as well as we tested it thru SAP HANA’s predictive library (PAL) for comparison sake, to help identify key data markers for future malfunctioning areas even before they occur. For that final stage of Data Visualization, we created the real-time dashboards on SAP Lumira.
• Worked with a team of developers to Install, Configure, and deploy a multi-clustered Hadoop Sandbox.
• Developed POC predictive analytics using engineering dept. sensors that collect data (IOT technologies) and using Hortonworks Hadoop platform (Spark) as the front-end solution.
• Help guide the Architecture of standardizing ETL (Informatica) best practices in the BI Department.
• Tested predictive algorithms libraries of R Studio vs. HANA PAL, vs. Python Predictive APIs to compare and contrast which would best fit our scenarios.
• Experienced in SAP HANA installation, configuration, Modeling Views, Creating Triggers, Exception Handling, Debugging, ODATA Services, XSJS Services, and Job Scheduling.
• Created basic SAPUI5 application for Finance dept over SAP HANA infrastructure.
• Created Data Models for enterprise wide data analytics solutions, from which the various HANA Views and BO Universes were developed.
• Developed POC predictive analytics projects; from creating data models and views to creation of mini HR application on SAP HANA (using its native PAL library).
• Tested the new composite DSO in BW 7.4 over SAP HANA and other new functionalities.
• Analyzed the legacy systems and developed a plan for conversion of Oracle reports, Cold Fusion and Cognos environment into Business Objects environment.
• Educated and familiarized the current staff regarding key Business Objects tools; i.e. Deski, Webi, Designer, Dashboard Design/Xcelsius, Crystal Reports
• Assisted in migration from SAP BusinessObjects 3.x to 4.x platform, providing guidance on sizing, load balance, systematic deployment and scale-up options.
• Spent extensive amount of time understanding data requirement of various business departments (Supply Chain, HR, and Finance etc.) and then devising solutions to meet their goals.
• An End-to-end professional; from meeting with Business Customers to understand their Data requirements, to working with the Modelers, to ETL, to Report/Dashboard application, to hand-off to a sustaining team.
• Installed a department wide best practices and solutions peer review infrastructure to help streamline the development all Data Warehouse artifacts.
• Worked extensively with the complex BO functionalities like Row-Level Security, Merge Dimensions, Query-on-Query, Combined Query, Custom (LOV), and Cascading Prompts.
• Created Dashboards that passes various parameters to other Dashboards via OpenDoc functionalities and then enabling those Dashboards to pass parameters to Webi reports.
• Created Developer friendly templates for Webi, Crystal Reports, Xcelsius/Dashboards, & Design Studio so developers are able to utilize them and save time during development.
• Created Complex Design Studio Dashboards POCs using various components (i.e. Charts, MAPS, List Boxes, Input Fields, Panels, Containers, and Filters etc.).
• Created Design Studio Dashboards using SAP BW and Universes as backend sources.
• Designing complex personalized Scheduling and Distribution of reports and dashboards using Infoburst and Infoview/Launchpad.
• Worked closely with all facets of the BI team from Business Users, Modelers, Business Analysts, Administrators, Architects, and Report developers to ensure the delivery of projects in a timely and orderly manner.
• Worked closely with Architects on overall BI Data Architecture, including Modeling, ETL, ODS, EDW, Data Marts, Data Lakes, Reporting, and sustaining. Helping continually define the existing and the evolving roadmap for an Enterprise-wide BI reporting and analytics platform.

Environment: SAP HANA sp9, Hortonworks Hadoop (Spark, Python, Pig, Sqoop, Ambari, Hive) HTML, JavaScript, Business Objects 4.x/3.x (Webi, UDT, IDT, Infoview/ LaunchPad, CMC, Report Conversion Tool, Import Wizard, LifeCycle Manager, Explorer 2.0), Crystal Reports 2008, 2012 Crystal Xcelsius 2008, Dashboard Design 4.x (w/QaaWS, Live Office, InfoSol’s XDS, BI Web Services), SAP BO Design Studio 1.5-1.6.

BusinessObjects Developer

Responsibilities:

• Configured, troubleshot, tested, upgraded, and maintain computer hardware, software, Internet and network connections for the entire department.
• Involved in many enterprise Business Intelligence projects in entire SDLC from project initiation to implementation.
• Participated in business requirements solicitation and analysis of BI initiatives.
• Prepared technical design specifications based on functional requirements and analysis documents.
• Worked alongside with Enterprise Data Architect in defining BOBJ Universe physical layer and dimensional model for analytical reporting.
• Interviewed business and technical reporting analysts and defined BOBJ Universe Business Layer/Symantec Layer with data dictionaries.
• Design and build of complex multi context universes (Billing and Meter, Customer and Field Service, Finance and Credit Collection and Rates) for ad-hoc reporting and standard reporting.
• Designed, developed and implemented many complex Webi reports on multiple data providers using features like report element linking, hyperlinks, drill-down, ranking, breaks, alerter and hide blocks.
• Provided technical solutions and fine-tuned long running queries to improve query performance.
• Assisted/guided end users to efficiently use the universes in building the simple and complex reports.
• Involved in UAT and solved the issues raised by users before migrating to Production.
• Involved in migration of repots to different environments
• Interacted with Business Users and Business Analysts to gather and document Requirements and translated them into Technical specifications for Designing Reports.
• Created several Crystal Reports using SQL Server as backend database.
• Created User specific reports for various internal departments.
• Involved in testing and deploying Business Objects Universes once ready for usage.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.

Environment: Business Objects 3.1 Sp2 (Webi, Designer), and Crystal Reports 2008 and Xcelsius 2008. SQL Server 2005

Report Developer

Responsibilities:

• Met with department chairs to determine requirements and performed analysis. Worked closely with functional system users to document business processes and define system functionality.
• Received Crystal Reports training from authorized partners
• Assisted the BO Admin in XIR2 to 3.1 migration using Import Wizard.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Developed various Crystal Reports using cascading-drill-down reports.
• Assisted the CMC personnel in migration of the reports.
• Assisted the business power users on report development.

Environment: Business Objects XIR2/3.1 Sp1 (Deski, Webi), Crystal Reports 11, SQL Server 2005