SUMMARY:

• An accomplished Data warehouse Project Leader with over 18 years of experience working with various operating systems and Databases in a variety of positions including project management, Business Intelligence solution implementation, Data Modeler, ETL Designer, Reports Designer and Systems Analyst
• He has spent over 12 years helping customers with their Business Objects Architecture strategy, Configuration, Design, and Integration with SAP BW, People Soft EPM, Implement Dashboards and Mark Logic. He has good knowledge of SAP, Hadoop Big Data and People Soft Infrastructure. He possesses excellent communication, interpersonal, intuitive, technical, analysis, organizational and leadership skills and has demonstrated ability to work efficiently in both independent and team environments.

WORK EXPERIENCE:

Confidential, Jackson, Michigan

SAP BI / Big Data Architect

Environment: Hadoop, MAPR, Apache PIG, Apache SQOOP, HIVE, SAP BW 7.4, BOBJ 4.1 SP3, AFO 1.4.8, SAP ECC, Business Explorer (BEx), SAP BPC 7.0, BEx Analyzer, Oracle, UNIX, AS400, ABAP4, BAPI, User exits, MarkLogic, Rally, MLCP, HPQC, Service center, Share point, Visio, and MS office 2013

Responsibilities:

• Successfully led PoC and PoT evaluation on Big Data technologies
• Responsible for MapR Cluster architecture and infrastructure setup
• Key - Focus areas included batch/real-time analytics, Next Gen Applications,
• Assisted teams on modern data manipulation, ingestion, transformation, reporting and visualization tools in Hadoop ecosystem
• Promoted a Cloud based solution to the enterprise
• Assisted teams on implementation of Hadoop modules and utilities usage
• Established architecture, infrastructure, deployment and solution patterns for Hadoop, MAPR, HIVE etc.
• Established NoSQL (MongoDB, CouchDB, Cassendra etc.) comparison matrix
• Architecture and infrastructure Solution of MarkLogic database
• Led the PoC and PoT for MarkLogic
• Architecture and infrastructure Solution of MarkLogic database
• Successfully led Mark Logic 7.0 infrastructure standup
• Established Mark Logic Solution Architecture for HA, DR, Backup and Security
• Established Hadoop Cluster Infrastructure
• Responsible for solution patterns for real-time, analytical (predictive, prescriptive, historical) use cases
• Responsible to complete BI reporting specifications.
• Responsible for activating delivered content
• Responsible for data modeling
• Responsible for design and develop BEx queries for various areas like PTP, APO, SCM & COPA
• Responsible for testing of BI content after SLO conversion
• Responsible for creating BW & BOBJ best practices / naming standards document
• Responsible for building visualizations with Tableau
• Responsible for building out BOBJ landscape
• Responsible for creating webi reports
• Responsible for migrating of BOBJ content across landscape
• Responsible for Design and implement security
• Responsible for Integration with SAP BW using BICS connectivity
• Responsible for set up backup, recovery of SAP BOBJ content
• Responsible for SAP Design Studio and Lumira POC
• Performance management and capacity planning (reviews performance statistics, sets thresholds)
• Responsible to resolve report problems because of upgrades, installation of any patches
• Coordinated work plan and activities in order to complete each course. This included:
• Coordinated with the Dawn key business users & Project team members on schedules & planning.
• Met with team members to confirm & develop course content.
• Ensured course due dates are met.
• Developed functional/technical setup for each course, including:
• Developed the appropriate testing data within the SAP clients.
• Executed each course (once developed) to ensure completeness and process flow.
• Coordinated the setup of the SAP user ID's and their testing (prior to course use).
• Provided information and assistance to both Dawn and Project team members to ensure that the team has a broad understanding of the concepts and integration points in this area of the project.
• Worked as Agile Scrum Master managing distributed teams and projects
• Developed an understanding of the detailed process, along with a 'big picture' view of the process & content.
• Supplement the other functional area teams in any additional tasks that may be required.

BI Architect

Confidential

Responsibilities:

• Expert in installing, integrating and upgrading BOE landscape
• Involved in upgrading and testing of content from BI 7.3 to 7.4
• Involved in testing of content / report after SLO Base unit of measure conversion
• Worked on PTP, COPA, APO and SCM reports
• Expert in Bex query development
• Expert in building SAP Hana Analytical, Attribute and Calculation views
• Designed and developed dashboards using SAP Design Studio
• Designed and developed dashboards using SAP Lumira
• Conduct architecture assessment of production implementations of SAP Business Objects
• Analyzed the existing environments and processes, providing recommendations for various areas including general architecture, load balancing, system configuration, backup and recovery strategy, system monitoring, security, and content migration processes.
• In addition, gathered future usage estimates and provided sizing and capacity planning estimates, and compiled all recommendations and sizing estimates to provide the client with a recommended architecture to accommodate current usage and expected future growth.
• Integrated BOE with Microsoft Share Point
• Installed and configured Data Services 4.0
• Expert in SAP Visual Intelligence
• Designed and developed universes
• Designed explorer views

Confidential

BI Architect

Responsibilities:

• Analyzed the existing reporting system and produced Fit Gap Document
• Worked with the Business Partners and defined report requirement document
• Good understanding of Risk applications BarraOne & StatPro
• Good understanding of Performance engine PACE
• Worked with BARA developers in extracting the data from the Risk engine
• Designed and enhanced various universes
• Leveraged Composite to blend data from multiple sources
• Built universe using Composite views
• Designed webi reports / Templates
• Enhanced Risk DB to meet Asset Liability reporting business requirements
• Worked in Agile/Scrum methodology environment.

Confidential

BI Architect

Responsibilities:

• Consulted on the creation of project scope document, project plan, requirements document, gathering the requirements, and methodology to be used.
• Enhanced all logical, physical, and dimensional data models in Power Designer.
• Assisted Sybase DBA’s in data warehouse specific tuning, loading, archiving, indexing etc.
• Designed, implemented, and trained team on Business Objects webi end user tool
• Acted as SME for the Migration of BOE from XI R2 to XI R3
• Involved in redesign of Universes as part of the Upgrade
• Acted as SME for the Migration of Informatica from 8.1 to 9.0.1

Confidential

SAP BI Reporting Architect

Responsibilities:

• Analyzed the existing reporting system and produced Fit Gap Document
• Responsible for defining and documenting report requirements, designing and validating reports.
• Performed an XIR3 Architecture and Migration from 6.5 to XI R3
• New Security Design Implementation.
• Involved in redesign of Universes as part of the Upgrade
• Architected and built the development, test, and production Business Objects environments, including integration with LDAP.
• Design Comp Sales Report
• Design Missing Stores and Missing Transactions Report
• Design Infoset, Info cubes, Multiprovider as per reporting requirements
• Design various BEx reports
• Design BEX queries and develop Universe on DSO, Info Sets
• Worked with the BI team in implementing various RICEF’s as per Business need
• Installed and configured Data Federator
• Trained users on Voyager
• Design webi and crystal reports

Confidential

Principle Architect - Upgrade Specialist

Responsibilities:

• Conducted various meetings with the business users to gather the requirement and developed a design documents and timeline for the migration
• Performed an XIR2 Architecture and Migration Assessment for a multi-environment consolidation effort, including migration of Business Objects 5.1.8 to XI R2
• Acted as technical lead for a large Business Objects XIR2 implementation, which took place in conjunction with the redesign of Financial Reporting and Investment Data warehouse.
• Involved in redesign of various Crystal Reports as part of the upgrade
• Involved in redesign of Universes as part of the Upgrade
• Architected and built the development, test, and production Business Objects environments, including integration with Microsoft Active Directory.
• Architected and built the production Business Objects environment to be BCP complaint.
• Involved in redesigning Financial Reporting Data mart
• Performed an Actuate Server Architecture and Migration Assessment for upgrade of Actuate 7 to 9 sp3
• Acted as technical lead for a large Actuate 9 implementation
• Architected and built the development, test, and production Actuate environments on HP-UX, including deployment of IPortal on Web sphere.
• Installed / Upgraded Test, Stage and Prod environment to Business Objects XI R3

Confidential

Senior Consultant - Business Objects / ETL Specialist

Responsibilities:

• Conduct architecture assessment of production implementations of Business Objects on AIX/WAS, including a Business Objects XIR2 Web Intelligence implementation and a highly customized Business Objects XI SDK implementation.
• Analyzed the existing environments and processes, providing recommendations for various areas including general architecture, load balancing, system configuration, backup and recovery strategy, system monitoring, security, and content SDLC processes.
• In addition, gathered future usage estimates and provided sizing and capacity planning estimates, and compiled all recommendations and sizing estimates to provide the client with a recommended architecture to accommodate current usage and expected future growth.
• Worked with the customer’s BI team to plan migration of BusinssObjects Environments.
• Assisted Zurich Insurance in the design and implementation of the physical architecture and security model for Zurich’s XIR2 environment, and provided turnover to a local Business Objects resource prior to perform the production rollout.
• Worked with the team to plan the integration of BusinessObjects XIR2 with PSFT EPM.
• Assisted in the design and implementation of the physical architecture and security model for FedEx’s XIR2 environment
• Also worked closely with the implementation team of Oracle consultants to oversee end-to-end design principles and guidelines for the EPM, universes, and reports.
• Acted as interim Business Objects administrator until the customer can hire a full-time employee to fill the role.
• The integrated solution was used to extract data from the legacy PSFT 8.8 Financials environment to provide a system-of-record for legacy data, in order to quickly provide financial reporting capability for the new custom environment.
• Performed an XIR2 Architecture and Migration Assessment for a CNA Surety company planning a migration for highly customized 5.x architecture to Business Objects Enterprise XIR2.
• Analyzed the existing application and database architecture to determine all available migration paths and options
• Analyzed the existing environments and processes, providing recommendations for various areas including general architecture, load-balancing, system configuration, backup and recovery strategy, system monitoring.
• Conducted various meetings with the users to gather the requirement and developed a design documents to develop various key metrics for the business
• Performed an XIR2 Architecture and Migration Assessment for a multi-environment consolidation effort, including migration of Business Objects 6.5.1.
• Acted as technical lead for a large Business Objects XIR2 implementation, which took place in conjunction with the implementation of BW Active Data Warehouse implementation.
• Architected and built the development, test, and production Business Objects environments, including integration to SAP.
• Designed & Developed pixel perfect Crystal reports
• Simultaneously, he acted as technical lead for a team of two analysts and four universe/report developers. Also worked closely with the implementation team of SAP consultants to oversee end-to-end design principles and guidelines for the universes, and reports.
• Over the course of the project, he also acted as interim Business Objects administrator.
• Assisted in testing and troubleshooting issues related to highly customized and prompted Business Objects reports.
• Worked with the DBA and as a liaison with members of the Business Objects Product Group to perform multiple load- and performance-testing sessions using Load Runner, in order to validate the 6.5.1 environment, and troubleshoot certain issues which the customer was experiencing on their Web Sphere application servers.
• Acted as principle architect and technical lead for a large Business Objects 6.5.1 implementation, which took place in conjunction with a ground-up, enterprise-wide Teradata Active Data Warehouse implementation, as well as a major Oracle Financials upgrade, a new Oracle CRM implementation, and significant process re-design across the entire company.
• Architected and built the development, test, and production Business Objects environments, including LDAP integration to Microsoft Active Directory.
• Simultaneously, acted as technical lead for a team of three analysts and six universe/report developers.
• Also worked closely with the implementation team of Teradata consultants to oversee end-to-end design principles and guidelines for the data warehouse, universes, and reports.
• Over the course of the project, also acted as interim Business Objects administrator until the customer was able to hire a full-time employee to fill the role.
• Installed and configured XI suite of products in a Windows environment provided best practice strategy. Mentored the internal users
• Good knowledge in implementing Rapid Marts
• Implemented GL/AP Data Mart, LLD (Loan Level Data Mart) and AP Data Mart against PeopleSoft EPM 8.9. Involved in gathering requirements, analysis and design of AP data mart.
• Developed the universe against these data mart. Created various web intelligence reports such as Income Statement, Balance Sheet, Trial Balance and Responsibility Report.
• Provided strategy / plan in installing CE 10 in an AIX environment using oracle as a repository Database, and web sphere as application server
• Did custom design and development to meet the business requirement.
• Migrated custom development on to the upgraded 6.5.1 environment, in a distributed environment.
• Provided migration strategy / plan on migrating from 6.1a to 6.5.1 migrated all the custom development on to the upgraded 6.5.1 environment.
• Made enhancements to the custom development.
• Supported the migration from 6.1a to 6.5 and Production support
• Supported migration (6.5.1) issue resolution.
• Developed Metrics and analytics for auditor information optimized the servers for better performance
• Supported day to day issue resolution
• Resolved performance issues in 6.1b environment; deployed BCAP.
• Upgraded the development environment to 6.5.1
• Reviewed the architecture, and made recommendation in optimizing the environment.
• Assisted in migrating the custom code to 6.5.1
• Assisted in the deployment of Enterprise 6.5.1 on HP UNIX and Web sphere as the application server and IIS as the web server also assisted in upgrading from 5.x to 6.5.1 Supported production and migration issues
• Deployed Enterprise 6.5.1 on AIX 5.1 using Web sphere as the application server and apache as the web server Assisted in deploying/migrating the custom application
• Deployed of Enterprise 6.5.1 on AIX 5.1 using Web sphere as the application server and IIS as the web server.
• Supported production issues.
• Worked with the developers in customizing the interface and the login process Assisted in upgrading from 6.1b to 6.5.1
• Provided Migration & Architecture strategy session for Northern Trust and migration of BO repository from Sybase to Oracle.
• Provided Architecture strategy session for HCA regarding the deployment of e6 suite of products and Troubleshoot performance issues on BCAP
• Configured and tuned Web Intelligence 2.7 on AIX 4.3.3 using iPlanet 4.1.SP9.
• Configured and setup BCAP based on the requirements of the Client.
• Monitored UNIX environment and analyzed system statistics to determine performance and tuned Web Intelligence accordingly.
• Worked with the Customer to assist in the data design required to create universes to support the Business reporting requirement

Confidential

ETL / Business Objects Specialist

Responsibilities:

• Deployed Web Intelligence 2.7.1 and Application Foundation 2.5.2 on Solaris 8, using Apache 1.3.12 DSO, with Web Logic 6.1SP2 as the Application Server.
• Deployed Enterprise 6.1a on Sun Solaris using Web sphere as the application server and BCA 6.1a on Windows 2000 SP3
• Deployed 5i suite of products, Worked with a large team to convert 4.x reports to 5.x. also designed universes to provide data access for the end-users for the Ad Hoc reporting needs.
• Deployed Web Intelligence 2.7.1 and Auditor 5.1 on Windows 2000 SP2, using IIS5 as the web server, configured Web Intellligence for LDAP Authentication.
• Also responsible for enhancement of Business Objects Suite of Products. Involved in designing the data model, developed ETL design specification and worked closely with the off shore team in development and implementation phase
• Acted as a financial Crystal Report lead responsible for providing financial reports to key personnel globally and also performing performance analysis and supporting / administering Crystal Enterprise and Business Objects.
• Responsible for designing and developing Universes for reporting purpose Universes were created for post and pre-analysis of the marketing data
• Implemented the Enterprise Financial Reporting Data Mart (EFDM) and analytics enterprise wide as part of the corporate data warehousing strategy
• Involved in gathering requirement, analysis and design of the EFDM.
• Developed the universe and created various Web Intelligence and full client reports such as Profit & Loss Statement, Balance Sheet reports etc. using Business Object 6.5.
• Defined and implemented user securities in supervisor module using bulk load (Export).
• EFDM Target database was Oracle 9i and Target reporting tools were Business Objects and Hyperion Essbase.
• Hyperion Essbase was a complete solution for reporting, that is used the budgeting and forecasting process along with reporting.
• As a project lead for Hyperion Essbase application, completed the design and development of an Essbase financial reporting system that containedbudget and forecast models.
• Implemented and administered the Hyperion Essbase application.
• Also, participated in requirement gathering and designing of enterprise financial data mart.
• Provided to 120 Essbase users on Essbase client tool “Essbase Excel Add In”.