Description
SUMMARY: 14 Years of strong experience as a Software Professional with hands-on experience in DB Maintenance, Backup and Recovery. 10 Yr's of good hands-on experience in Architect, Business Intelligence, S4 HANA Modeling, Data warehousing Tools, Data Modeling, Administration, Analysis, Design, Development, ETL, Deployment of various applications using different BI Technologies, Techniques, Structures, Global Onsite / Offshore Models, Agile Methodology, Predictive Analysis, ETL. * Core Experience on architect provide end to end solutions in the design and development of the applications Using IDT/UDT, WEBI Intelligence, Xcelsius-2008/2010, Dashboards, Business Explorer, Data connections. Administration activates, TABLEAU, Design Studio, SAP LUMIRA, Mobile reporting, Analysis for Office and Power BI, BI / BW and Complex Crystal Reports using SAP Business Objects. * Created folders in CMC and implement the security on various objects in CMC (Folders, Applications, Universe and Connections). Performance tuning on both admin and application related activities. * Trained and mentoring business users, Start /Stop, Enable/Disable, Clone, Add, remove Services (Delete, edit & Move). Work with SAP Support in case any issue is not resolved internally and Admin/applications related. In-depth knowledge on Tableau Desktop and Tableau Server. * Involved in the full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for Designing, coding, testing, implementing and supporting the ETL processes for data warehouse solutions and related data marts. Skilled in Data Model design and development using various tools like ERWIN 3.5. * Excellent ability in writing specifications and gathering requirements from the user to develop Reports as per The needs of the client and maintain documentation of the reports for future reference and SCEIS standards. * Strong Experience on live, Extract and Scheduling the TABLEAU / SAP LUMIRA / Analysis for Office Documents/Workbooks, Stories, admin and Security activities. * Strong Experience and development of WEBI /Crystal Reports, XCELSIUS. Different data connections of Live Office, QAWS, XML DATA, Web Services (BIWS). Performance tuning on both admin and application related. * Extensive Experience in Admin /Security of the various versions, Business Objects ( XIR2, XIR3, XIR4 0, XIR4 1/BI4.1, BOBJ 4.2), SAP LUMIRA (1/2), TABLEAU (8/9), Design Studio and MICROSTRATAGY (9.3). * Strong Administrator skills, DC migrations, Version UP - gradation, User groups, Security, support activities for All Environments (End to End activity). And implementing a Facets/ software environment also. * Enhanced multiple SAP ECC data sources such as 0CACONT_ACC_ATTR and 0UCCONTRACT_ATTR_2 as well as create and enhance the necessary info objects and info providers for BEX/ MDX queries. Modified transformations within BW using ABAP to produce accurate data for reports. * Created SAP HANA Information Models using Attribute, Analytic and Calculated Views. Developed MS Analysis Reports, Input Templates and Tableau Dashboard on HANA views. * Expertise in SAP Business Intelligence 4.0, 4.1, 4.2 tools and SAP HANA1.0 Data bases. * Different TABLEAU \ LUMIRA Storey futures like Trend lines, Forecasting, Sets, Date comparisons. And Performance tuning for both admin (Vizql) and application related. * Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator Using BODS as an external system for ETL between ECC and BI with 360 Eye and Info bust * Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target and Trade Management. * Perform installation, migration, configuration, maintenance, technical support and troubleshooting of various Versions in Business Objects, TABLEAU, LUMIRA and Design studio. BODS * Created monthly and summary reports in WEBI 4.0\4.2for the different domains like Finance, Marketing and HR domains Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Voyager, Live Office. * Handled Change Requests (CRs), Issue Logs and Support Request (SRs) within a given target time. Coordinating / Working on various back end ETL teams and resolved Admin, Reports, Performance issues. * 4 years of strong experience as a MS-office DBA, Testing and SQL Server 2000 maintenance like Backup, Recovery and report generations. Good knowledge on US Section 508 and WCAG2.0. Good in UI Design. * Extensive Experience in corporate training, Good Team leading skills. Gained extensive experience in Designed, Development phase as part of the young development teams and couple of initiatives Well Advanced. Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer. * Have an eye for Detail and flair for learning's. Knowledge and POC's on BI, BODS, SAP HANA Modeler, Information Steward TECHNICAL COMPETENCIES Business Intelligence: S/4 HANA1605, BW / BI, Info Cubes, SLT, Business Objects BO 6.5, XIR1, R2, R 3.1/2, BOBJ 4.2 /4.1/ 4.0Central Management Console (CMC), CCM, User/Security/Server Management, LCM, IDT/ UDT, WEBI /Desktop / OLAP Intelligence, BIWS / Query as a Web Service (QWAS) /Live Office, Enterprise Performance, Promotion Management, Crystal Reports XI/ Enterprise, XCELSIUS Dashboards, Import Wizard, Publisher, Upgrade management Tool (UMT), Report Conversion Tool, BI Launch Pad, Business Explorer, SAP LUMIRA, Analysis for Office, Design Studio (1.5/1.6), MICROSTRATAGY9.4, TABLEAU (8/9), Desktop, EDI, HL7.4, HIPAA BODS, Architecture, Web, Mobile Reporting, UML and Use Cases, Asset Management Tools, Team Foundation Server (TFS), EHSM, BOPF, MDX, Data Federator, Knowledge on Data Stage, INFORMATICA, Cogon's, UI, EIR Accessibility, QLIK, BRIST, Facets, Power BI, Information Steward, Clarity, CDS views, HANA. Data Modeling: Star-Schema and Snowflakes Modeling, FACT and Dimensions. Programming & scripts: SQL, PL/SQL.MS Office Macro's, HTML, DHTML Data Base: SQL Server2005/2008/2012, Oracle, Teradata13.0/14.0, DB2, T/SQL. Industry Application: Manufacturing, healthcare, Food & Retail, Finance and Logistics, Energy, Telecom and banking Testing and Ticketing tools: Manual, Knowledge on Win runner, QTP and SM9, ISM, Remedy. Project Name : S4 HANA Embedded Analytics Lead on Business Objects on Business Objects, SAP LUMIRA and TABLEAU, HANA. Project: Upgrade and Transition (Production support) * Project: Schweppes Australia is an iconic soft drink brand. In 1783 Jacob Schweppes pioneered the remarkable process of capturing and bottling bubbles. Sixty-seven years later the Schweppes brand arrived in Australia, and in 1877 the first factory in Sydney was built. Schweppes Australia was acquired by Asahi Breweries in 2009. Formerly running as the beverages business of Cadbury Schweppes, Schweppes Australia Pty Ltd was separated on 27 February 2009. In April 2009, Schweppes Australia was acquired by Asahi Breweries Responsibilities: Worked as architect to provide End to End solutions for BOBJ Environment tools, HANA, BODS. Managed Services for BO 4.2 environment stability, sizing and sustainability, system slowness Expertise to Resolved the Daily issues in the Daily Production / Non Production Environments. Work on HANA data model KPI's to create view for reporting like calculating and analytical views * Designed and Modified IDT/UDT, WEBI, Design Studio, Business explorer Dashboards using Lookups and various formulae to analyze the data like PDF, Line, column and combination charts and Explorer. * Strong Understanding on live, Extract and Scheduling the TABLEAU, SAP LUMIRA Documents/Workbooks, Admin, Security. Developing with Microsoft Power BI tools including analytics, reports, dashboards, and data visualizations. Hands on knowledge of EIR Accessibility, required technical specifications, Techniques. * Created folders in CMC and implement the security on various objects in CMC (Folders, Applications, Universe and Connections). Performance tuning on both admin and application related activities. Trained and mentoring business users, Start /Stop, Enable/Disable, Clone, Add, remove BO Services (Delete, Move & edit). Work with SAP Support in case any issue is not resolved internally for all Admin/applications related * And 360 Eye and Info bust. In-depth knowledge on Tableau Desktop and Tableau Server. Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator using BODS as an external system for ETL between ECC, BI and SAP HANA1.0 Data bases * Created SAP HANA Information Models using Attribute, Analytic and Calculated Views. Developed MS analysis Reports, Input Templates and Tableau Dashboard on HANA views. * Enhanced multiple SAP ECC data sources such as 0CACONT_ACC_ATTR and 0UCCONTRACT_ATTR_2 as well as create and enhance the necessary info objects and info providers for BEX queries. Modified transformations within BW using ABAP to produce accurate data for reports * Expertise in SAP Business Intelligence 4.0, 4.1, 4.2 tools and SAP HANA1.0 Data bases * Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target Created repository and security domain with user groups and security implementation multilevel hierarchies are Setup enabling the drill down functionality, Create Derived Tables and good UI design. * Implement the Single Sign-On (SSO) application for the Operations, Updates the project and Utilize. Taking care End to end issues like, Report scheduling and handled various performance tuning issues on reports\Stories. * Responsible for Created user-groups in CMC and implemented the security model on the groups created like End to end solutions. Unit testing, integration testing, and automated testing. * Troubleshoot and Resolved by the Remedy incidents, New user creation, performance and ARS incidents Environment: SAP BO 4.2 SP2, IDT/UDT, Business explorer, WEBI, Dashboards, ISM, SAP HANA KPI's, BI, Analysis for Office, Design studio, SAP LUMIRA, TABLEAU, POER BI, EDI, UI, SLT, DXC. LUMIRA and TABLEAU BODS HANA. Upgrade and Transition (Production support) Project: Hillshire Brands is a manufacturer and marketer of packaged meat and frozen bakery products for the retail and foodservice markets and a wholly owned subsidiary of "https://en.wikipedia.org/wiki/Tyson_Foods" \hTyson Foods. The company's portfolio of brands include "https://en.wikipedia.org/wiki/Jimmy_Dean_(brand)" \hJimmy Dean "https://en.wikipedia.org/wiki/Ball_Park_Franks" \hBall Park "https://en.wikipedia.org/wiki/Hillshire_Farm" \hHillshire Farm "https://en.wikipedia.org/wiki/Kahn%27s" \h Kahns State Fair "https://en.wikipedia.org/wiki/Sara_Lee_Corporation" \hSara Lee Chef Pierre Pies Aidells Gallo Salame and Golden Island Premium Jerky. Responsibilities: Worked as architect to provide End to End solutions for various BOBJ Environment tools HANA BODS. Expertise to Resolved Daily issues for both Admin and Documents\ Reports in the Daily Production Environment. Created folders in CMC and implement the security on various objects in CMC (Folders Applications Universe and Connections). Performance tuning on both admin and application related activities. Good experience on the S/E version Migrations. * Trained and mentoring business users Start /Stop Enable/Disable Clone Add remove BO Services (Delete Move & edit). Work with SAP Support in case any issue is not resolved internally for all Admin/applications related Designed and Modified IDT/UDT WEBI Design Studio dashboards Stories using Lookups and various formulae To analyze the data like PDF Line column combination Pie charts and Local and Global filters. Strong Understanding on live Extract and Scheduling the TABLEAU SAP LUMIRA Documents/Workbooks/ Stories Admin and Security. Extensive expertise and experience implementing and developing with Microsoft Power BI tools including analytics reports dashboards and data visualizations. Extract transform and load the Data by using various transformations and good UI design with 360 Eye and Inforbust Responsible for Created user-groups in CMC and implemented the new security model on the groups created like End to end solutions and Performance tuning on both admin and Documents/Reports related activities. Created SAP HANA Information Models using Attribute Analytic and Calculated Views. Developed MS analysis Reports Input Templates and Tableau Dashboard on HANA views. Created Complex Crystal Reports using SAP Business Objects and SQL as data source Developed XCELSIUS Dashboards for top level management by using BIWS / Query as a Web Service. Expertise in SAP Business Intelligence 4.0 4.1 4.2 tools and SAP HANA1.0 Data bases Perform installation migration configuration maintenance technical support and troubleshooting of Business Objects TABLEAU implementations. Setup the Platform search applications and Service level memory issues. Used Variables User defined objects Scope of analysis Drill mode Slice and dice mode Prompts and Conditions to make reports accurate and easier for analysis. Unit testing integration testing. Used Restricted and Calculated Key Figures Virtual Key Figures Formulas Variables Replacement path Variables Customer Exit Variables User entry Variables in the Query Designer. automated testing * Created repository and security domain with user groups and security implementation multilevel hierarchies are Setup enabling the drill down functionality and created Derived Tables. Implemented Single Sign-On (SSO) and Taking care End to end issues like User groups Report Scheduling and various performance Activities. Hands on knowledge of EIR Accessibility required technical specifications * Data center Migration for the DEV /QA / PROD Environments and Repository. Upgrade service packs ODBC Drivers and Supported admin activity for the various Server/services supported. * Troubleshoot and Resolved by the Remedy incidents new user creation performance and ARS incidents. *
Accomplishments
Highlights:
Keywords
