SUMMARY;

• Highly accomplished Business Intelligence Manager with a distinguished 19 years IT career that includes 13 years in Business Intelligence, leading and Managing the design and implementation of advanced data capture, integration, analysis, and reporting solutions to enhance decision - making.
• An experienced SAP Project Manager with multiple years of experience in leading Business Intelligence Technical and Functional Teams.
• Managed Business Intelligence projects from conceptualizations to implementation. Skilled in partnering with business, leadership, teams and partners to identify needs, define strategy, and guide the delivery of tools, systems and analytics to measure performance against goals, identify trends, and respond immediately to new opportunities. Natural communicator and team leader with strong motivational skills and ability to produce and succeed.
• Expertise in building team consensus amid complex business and technical challenges. An effective leader who champions the use of technical standards and best practices.
• Successfully managed multiple projects to ensure that deliverables are met within Schedule, Budget, & Quality.
• Proven Ability to bridge the gap between IT, Business Users, and Management. Building and maintaining relationships with key business partners to keep their active engagement in the projects.
• As a practice manager and counselor, ensured professional development of staff.
• This includes ongoing coaching, mentoring, individual strength and development assessment, performance reviews and internal communication.
• Excellent technical, analytical and functional skills.

TECHNICAL SKILLS:

Business Intelligence Tools: SAP BOBJ 6.5/XIR2/XI3.0/XI3.1/4.0/4.1, Web Intelligence, Desktop Intelligence, Crystal Report XI/10/2008, BOBJ Universe Designer/Universe Designer Tool/Information Design Tool, Info View, Bi Launchpad, SAP Explorer, BOBJ Admin (CMC/LCM), Xcelsius, Lumira, Tableau, SAP HANA v1 SP9, SAP HANA Studio, BW 7.4, Bex Query, SAP BODS and SAP Data Services.

Data Visualization tools: SAP BOBJ Xcelsius, SAP Lumira, Design Studio, and Tableau 8/9/10(Desktop and Server)

SAP modules: SAP FI-CO and SAP Human Resource.

Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008 , Access, SAP BW, SAP HANA, SAP ECC, Oracle Exadata and Oracle JD Edward.

O/S: Windows 2000/NT/XP/Professional, UNIX.

Languages: SQL, SQL PL/SQL, Visual Basics 5/6.

Tools: SQL Plus, Toad, Remedy, Toad, QTP, HP Quality Center, IBM Rational Clear Quest, Accela, Calidus Portal.

Project Management Tools: MS Project, Visio, Jira, MS Project, MS Office Suite.

SDLC Methodology: Water fall, Agile Methodology, Scrum.

Other Skills: BI Strategy, Team Management, Analytics Solution Architecture, Requirements Analysis, Data Modeling, Data Visualization, Project Design, Execution & Management, Business Intelligence Roadmap & Strategy, Data Acquisition, Integration & Analysis, ETL, Dashboard & Reporting Frameworks, Systems Development Life Cycle Management, Project management, Team Development, Training & Leadership.

PROFESSIONAL EXPERIENCE:

Confidential, Creek, MI

Data Visualization Deliver Lead

Technologies: Tableau 10.2, .Net, SQL Server 2014, Business Objects Data Services (BODS)

Responsibilities:

• Work with business partners in understanding and translating business requirements into solution designs.
• Lead and provide suggestions and best practices for end to end data delivery.
• Performed traditional project management tasks like facilitating status meetings, updating status reports, and managing the team on a day to day basis.
• Responsibilities also include creating project plan, resource estimates, and budgeting.
• Managed the Scope and the Change Requests. Tracked and managed the Issues and Risks.
• Responsible for day-to-day direction of the project team, resource allocation and resource scheduling.
• Responsible for overall guidance/direction, problem solving, and motivating the team.
• Leverage my interpersonal skills to build solid rapport and relationships with client to drive business outcomes.
• Data Analysis for Kellogg’s Analytic DataMart, Keystone.
• Design and architect to accommodate data security and privacy.
• Prepare Conceptual, Logical and Physical data model.
• Lead Design sessions with Business Stakeholders & Sponsor.
• Profile, design, and model data and provide data product solutions using multiple data platforms.
• Prepare User Stories for .Net application and Tableau Dashboards Design & Development.
• Design and architect to integrate multiple, complex data sources to Application and Tableau dashboard that are transactional and non-transactional, structured and unstructured data.
• Maintain data dictionaries and data lineage.
• Prepare Source to Target mapping documents.

Confidential, Raritan, NJ

Business Intelligence Manager / Data Analysis Manager

Technologies: SAP Business Objects 4.1, SAP BW 7.4, Tableau 9.2, SAP HANA v1.0 SP9, SAP Business Objects Data Services (BODS), Oracle, Amazon Web Sphere (AWS).

Responsibilities:

• Leveraged functional, industry and ERP knowledge to develop value propositions, define project scope, budgets and schedules to balance business needs.
• Estimated work effort, skills/resource requirements and developed high level as well as detailed project plans.
• Developed and monitored efficient working of project budgets and schedules.
• Leading Support activities across individual managers, users, and support resources, ensuring service delivery quality, compliance, and efficient resource management.
• Serving as second escalation point for Incident Management, facilitating the understanding and leadership on resolution activities needed among business community and support teams.
• Coordinating and facilitating regular meetings and calls with business and internally within the Consumer portfolio, also providing necessary reports, presentations, and working on required follow-ups from meetings.
• Generating and analyzing service metrics. Reviews and work on SLA service improvements.
• Leading on-boarding activities of new application resources.
• Responsible for overall support team knowledge and service quality, constantly working to identify areas of opportunity for support group growth, leading training activities and implementation of any new initiatives.
• Responsible for handling all communication among different functional and technical service groups to ensure a fully leveraged delivery of services for all applications within portfolio.
• Work closely with support team to classify Incidents, including Incident prioritization/ categorization, recurring Incidents, conducting weekly Incident review meetings with support team.
• Works closely with support team, classifying Problems, including Problem prioritization/ categorization, conducting weekly meetings with support team.
• Provide proper visibility to the business on the Incidents and Problems.
• Working closely with support team identifying and classifying opportunities of improvement.
• Coordinating Service Requests, Operations maintenance, and Operations activities.
• Involved in the Data Extracting from the Source system, BW 7.4, using SAP ETL tool, Business Objects Data Services (BODS), and loading the data into SAP HANA Database.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Used SAP Hana views in SAP Business Objects Information Designing Tool to develop business layer of Business Objects universe.
• Designing and Building of SAP Business Objects Universes, Classes and Objects using both SAP Business Objects UDT (Universe Designing Tool) and SAP Business Objects IDT (Information Designing Tool).
• Design, Build, and Test Custom SAP Business Objects Webi Reports.
• Performed analysis of Business current state and proposed Tableau dashboard where business can visualize data in a reliable, flexible, and robust way.
• Led the requirements gathering effort, analyzed the requirements, worked with the subject matter experts (SMEs), and created Project scope for data visualization phase of the project.
• Produced the Design of attractive Tableau dashboards to convey the story inside the data.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Restricted data for particular users using Row level security and User filters.
• Involved in trouble shooting of performance issues which were associated with Tableau dashboards.
• Involved in administration tasks such as publishing workbooks, permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.

Confidential, Florham Park, NJ

Business and systems integration Manager

Responsibilities:

• Designed and managed the Business Intelligence project, within-budget and on schedule.
• Responsibilities includes day-to-day direction of the project team, resource scheduling, guidance/direction and problem solving; motivating team. Developing and evaluating staffing plans.
• Managed project plans, scope, resources, change requests, risks and issues.
• Worked with user community to identify the user's needs and delivering quality BI Solution.
• Provide senior management with an oversight of the project including risk mitigation and budget management.
• Provide the steering committee with project updates and directions on critical decisions to be taken.
• Ensure proper change management strategy and corresponding next steps.
• Lead the steering committee on SAP process change management activities.
• Gather Business Requirements, Setup Data Integration rules, coordinate with Business and third party Vendors.
• Coach cross-functional project team on the business perspective and strategic imperatives needed by the solution.
• Designing, prototyping and Creation of Functional designs for data integration, BOBJ Universe, Webi Reports and Tableau Dashboards.
• Involved in Offshore hiring process making sure that the right resources are allocated for the project.
• Manage offshore BOBJ Data Services Data Integration team in the process of loading data from external flat files for Strategic Pricing Project into EXADATA (Oracle) Database.
• Manage offshore HANA team developing Analytic/Calculation/Attribute views for Webi, and BOBJ Universe.
• Manage offshore Data Integration team in the process of Extract, Load, and Format the necessary Oracle JD Edward data for Strategic Pricing Project into HANA.
• Managed project status reports to ensure that the schedules and budget deadlines are on track.
• Performed analysis of Business current state and proposed Tableau dashboard where business can visualize data in a reliable, flexible, and robust way.
• Led the requirements gathering effort, analyzed the requirements, worked with the subject matter experts (SMEs), and created Project scope for data visualization phase of the project.

Confidential, Peapack, NJ

SAP Business Intelligence Lead /SAP Business Intelligence Solution Architect

Technologies SAP Business Objects 4.1, Universe Design Tool (UDT), and Information Design Tool (IDT). Web Intelligence, Bi launch Pad, SAP Core Modules (Finance, Human Resource), Oracle 11g, Toad and SAP BW 7.3, and Agile Project Methodology.

Responsibilities:

• Managed teams consist of Confidential Reporting Team along with client and other third party vendors in gathering, analyzing and documenting business requirements for SAP BOBJ Universes and Webi Reports build on top of various SAP Modules like Finance & HR.
• Successfully migrated multiple projects from Waterfall to Agile Methodology of Project management.
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility and ensured consistent application of scrum methodologies across the project team.
• Involved in multiple sessions with Business to gather Business Level requirements for reporting needs.
• Worked with Business Analyst & DBAs to ensure data flow and match requirements for reporting needs.
• Lead Offshore and Onsite teams for coordinated development and Production Support Responsibilities.
• Worked with SAP Life Cycle Manager and Import Wizard for Report migration between environments.
• Worked extensively to ensure proper scheduling times for all reports, including but not limited to reports sent to user inbox, and emails.
• Involved in troubleshooting of report level and SQL code level issues.
• Leveraged multiple teams to co-ordinate efforts ensuring maximum uptime.
• Involved in Data-Analysis, Data-Digging for resolving / answering data level issues to the end-clients.
• Reviewing designs and code output from development team and testing the reports.
• Performance monitoring and Tuning of reports during application testing and production operations.
• Establish and implement SAP Best Practices to ensure data quality and report performance.
• Develop, maintain and support reports using SAP Business Objects 4.1.
• Collaborate with DBAs, architects, and developers in the implementation of Reports.
• Working closely with other Confidential Technical and Functional groups at Pfizer.

Confidential, Tampa, FL

SAP Business Intelligence Manager /SAP Business Intelligence Solution Architect

Technologies: SAP Business Objects 4.1, Universe Design Tool (UDT), Information Design Tool (IDT), Web Intelligence, Bi launch Pad and SQL server 2008 R2.

Responsibilities:

• Worked closely with Business to get detailed information on what information they require in Universe. Worked closely with business to understand business process and applications and reporting requirements.
• Support Project leadership in Design, Development, Testing, and Sign-off reporting deliverables.
• Created and Validates Reporting architecture for clients reporting solution using Business Objects.
• Define, review, and maintained Project deliverables.
• Implemented and recommended industry BI standards and SAP best practices.
• Work closely with the different business groups.
• Set up and configured Business Objects Development, Test, and Production environments.
• Involved in Data Integration components of the project.
• Involved in Data ETL activities that were done using SAP data services ETL tool, BODS.
• Developed Functional and Technical Design Documents from End user requirements.
• Created, maintained, and updated technical requirements document, design document, Business Objects Architecture document, Business Objects Test Cases and Webi End User Training.
• Performed analysis/design/development/and unit testing of Business Objects Universe and Webi Reports.
• Trained Business Users on Webi and Bi Launchpad for UA Testing.
• Created Rich dashboards using Tableau, prepared user stories to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Extensively used data blending, embed functionalities in Tableau.
• Created Geographical Dashboard to develop quick filter to narrow down individual states and cities for revenue generation information.
• Building/publishing customized interactive reports and dashboards and scheduling using Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Confidential, New York NY

Business Development /Business Intelligence Lead

Technologies: MS SQL Server Reporting Service (SSRS) 2008 R2, Oracle SQL (PL/SQL)

Responsibilities:

• Developed Proof of concept using Accela licensing software and building Business Intelligence Solution for the Department of Building Licensing systems.
• My efforts helped Confidential in winning the contract worth over $10 million from state of NY department of Building.

Confidential, New York NY

Business Intelligence Lead/SQL Server Reporting Services Report Developer

Technologies: MS SQL Server Reporting Service (SSRS) 2008 R2, Oracle SQL (PL/SQL)

Responsibilities:

• Full project life cycle. (Project Initiation to Project Closure).
• Requirement gathering, design development, testing and Deployment of Reports and Correspondences.
• Worked closely with Business and Accela configuration team to get detailed information on what information they require in each Correspondence.
• Data mapping of database objects.
• Developed design of overall Reporting architecture based on Clients existing requirements.
• Provided technical expertise in Microsoft SQL Server 2008 R2 to develop detail technical design based on the clients’ requirements and Accela application configuration.
• Worked closely with Accela configuration team for optimal performance.
• Worked closely with SQL Developer to create custom Views and Stored Procedure.
• Design, Build, and Test Custom SSRS 2008 R2 Reports and Correspondences based on the client requirements built on Accela Data model, Oracle 10G, Visual studio, VB.Net and SSRS 2008 R2 in the Backend and Accela application in the front end.
• Used Custom VB. code for visibility control.
• Used IBM Rational Clear Quest for change management, bug tracking and defect resolution.
• Ensure project close-out and wrap-up activities are performed and documented.

Confidential, Wilmington, DE

SAP Business Intelligence Lead

Technologies: SAP Business Objects 4.1

Responsibilities:

• Created Requirement Gathering Template as Per SAP BI Best Practices that will be used during the Requirement Gathering process.
• Streamlined Functional Design Document.
• Design the process of Reporting requirements conversion to a functional design document.
• Created the Requirement gathering process Presentation to Confidential and Business leadership.