SUMMARY

• 13.5+ years of strong experience in designing and building Business Intelligence, Analytics and Reporting solutions for various industries. Good experience in modelling, provisioning, mining and analyzing data.
• Managed several full lifecycle projects while being responsible for delivery. Currently working for Cognizant Technology Solutions US Corp.
• Experience in modeling and building Enterprise Data Warehouse and Data lake with SAP Data Services (BODS), SSIS, ERwin, SAP HANA, SAP BW/4HANA, Oracle, SQL Server, DB2, Teradata and Amazon redshift.
• Experience in designing and developing analytical applications, operational BI reports, Dashboards and created compelling stories for management with Lumira Designer, Web Intelligence, Crystal Reports, SAP Analytics Cloud and SAP Dashboards/Xcelsius, Tableau and Qlikview.
• SAP BOBJ administration experience using CMC, created scalable User and Content management plan for securing BI applications, artifacts and users. Created reusable access levels, performed content migration
• Experience in logical data modeling in HANA Studio, Information Design Tool (IDT) and Universe Design Tool (UDT). Created Universes incorporating complex business logic, join conditions, custom filters and LOVs, cardinality, aliases, contexts, derived tables and applied row level security on users.
• Experience in creating HANA Information models and securing them and data with object and analytical privileges.
• Experience in creating Predictive models in our Data Science initiative using Gretl and have knowledge of R and Python.
• Experience in managing both onshore and offshore teams, delegated tasks and effectively utilize resources, maintaining and managing RAID log. Wore many hats like Project Lead, Analyst, Architect, Onsite coordinator and developer.
• I get things done with timely follow - up, able to positively influence and motivate my team.
• Estimated projects, prepared work breakdown structure (WBS), proposals, involved in pre-sales activities assisting the sales managers.
• Initiated and conducted requirement evaluation workshops with senior management and functional teams. Highly experienced in analyzing and translating business requirements into technical requirements and identifying technical and functional gaps.
• Experience in all aspects of stake holder expectation management, strategy, assessments, upgrades, implementation and execution of Project. Experience working with cross functional teams.
• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing. Fair experience using SDLC tools like ALM.
• Highly organized, detail oriented professional with excellent project management, communication, presentation and leadership skills.

TECHNICAL SKILLS

• Reporting Tools: SAP Business Objects 4.2 Suite, Web Intelligence, CMC, Lumira Designer 2.x, SAP Analytics Cloud, Design Studio, Crystal Reports, Analysis Office 2.x, SAP Dashboards / Xcelsius, Tableau 11.x, Qlikview 11.2, Power BI 2.x
• ETL Tools: SAP BODS 4.2, Microsoft SSIS
• Database: SAP HANA 2.0, SAP BW4/HANA, Amazon Redshift, Google BigQuery, Oracle, SQL Server, Teradata, IBM DB2, MS Access
• Data modeling: SAP HANA Studio, SAP Data Hub, Information Design Tool (IDT), Universe Designer Tool (UDT)
• & Orchestration:
• Cloud Computing: SAP Cloud Platform
• Programming: R and Python

PROFESSIONAL EXPERIENCE

Analytics Lead

Confidential, Chicago, IL

Responsibilities:

• Worked closely with Business to understand existing pain points in the internal audit process and identify scope where the business process can be simplified and improved with technology
• Analyze Business Requirement document and understand legacy reporting solution
• Frequently work with functional team to identify and fix gaps in the logic or requirement
• Initiate regular all hands meeting with the stakeholders from Business, Functional, Security and Development team to review the requirements and plan for checkpoints
• Analyze requirements and help users in choosing right tool for the need; create a Prototype and get required approval from end users
• Prepare detailed technical specification document and get it reviewed by Business and functional team
• Create RAID log based on the analysis meetings
• Modularize the development activities and assign to Development team
• Participate in weekly agile team meeting to track progress
• Perform gap analysis and meet with respective stake holders to bridge the gap between the requirement and Information models
• Enable the end user to test the artifacts that are completed in the development environment
• Track user comments and enhancements from the user testing and include them in development stream
• Develop security model and BOBJ Access Levels based on the security requirements, test the model thoroughly
• Initiate discussions and meetings to discuss Design and layout of Dashboards and the security access model required to cater various users
• Write rigid unit test case; manage and coordinate testing activity from offshore and onsite resources
• Review and approve the Design Document from the development team. Perform artifacts migration across environments.
• Assist the users in UAT phase and consolidate the comments, prepare plan for bug fix, assign the tasks to the corresponding team member and get the issue resolved
• Oversee the hyper care phase and hand over to MSP team for support

Solution Environment: SAP Business Objects Web Intelligence 4.2, SAP BODS 4.2, Analysis Office 2.6, SAP HANA 2.0

Analytics Lead

Confidential, Chicago, IL

Responsibilities:

• Help AbbVie to leverage their new BOBJ investment, provided consultation on choosing right Authentication, Connection to BW and HANA, choosing right tool for the use cases, build a rigid and scalable BOBJ security model, customizing the BOBJ launchpad, creating templates, establishing reporting and Dashboarding best practices, create standard unit test scripts that applies to all projects, create an acceptable model for new user getting access to BOBJ environment and provide sizing suggestions
• Meet with Business and functional person to gather requirements
• Prepare a document with the list of Business Questions that the application is expected to solve
• Work with functional team to understand the logic involved and tables involved
• Device an optimal way to provision the data to analytical application
• Leverage the existing custom extractors that feeds to SAP BW
• Prepare RAID log and update that regularly
• Develop a prototype to confirm the conditional prompts logic in possible and get user signoff
• Prepare design documentation for both Bex queries and Lumira Designer
• Oversee Bex queries development and coordinate the Lumira Designer front-end development
• Initiate weekly status meeting with the Client to review checkpoints completion and identify issues
• Create unit test scripts and perform through testing of the development artifacts
• Assist users with BOBJ Platform and in the UAT process
• Review and approve the Design Document from the development team.
• Involve in SDLC process, oversee the hyper care phase and hand over to MSP team for support

Solution Environment: SAP Business Objects 4.2, SAP Lumira Designer 2.x, SAP BW4/HANA

Lead BI Consultant

Confidential, Branchburg, NJ

Responsibilities:

• Analyze the Business Requirement document and understand legacy reports and their source data
• Participate in the requirement analysis sessions to go over the functional requirement documents.
• Assign the HANA model development tasks to the team and track the progress. Build calculation views, review security roles.
• Prepare mapping document between HANA models and the legacy reports.
• Perform gap analysis and meet with respective stake holders to bridge the gap between the legacy reports and Information models
• Initiate brainstorm sessions to discuss the reporting solution possibilities to satisfy the requirements and help users in choosing right tool for the need
• Develop proof of concepts and have that reviewed with the clients and end users
• Initiate discussions and meetings to discuss Design and layout of Dashboards and the security access model required to cater various users
• Assist users in leveraging HANA models in Analysis Office
• Initiate weekly meetings for the development team to track progress and identity potential risks at the earliest and prepare appropriate mitigation plans.
• Prepare unit test case and perform through unit testing and coordinate the testing of the entire team
• Assist the users in UAT phase and consolidate the comments, prepare plan for bug fix, assign the tasks to the corresponding team member and get the issue resolved

Solution Environment: SAP Design Studio 1.6, Web Intelligence 4.1, Analysis Office 2.4, SAP HANA 1.0