SHIVAN MAHAJAN
Coral Springs,FL
Summary
Versatile Senior Manager specializing in Analytics and skilled at planning, implementing, and overseeing key improvements to drive business growth and efficiency. History of cultivating an open culture with free exchange of information. Pursuing new professional challenges with a growth-oriented company.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Sr. Manager, Analytics Consulting
Ultimate Software/UKG
01.2024 - Current
- Responsible for BI methodologies development processes, governance, and tool selection
- Guide and manage Analytics teams in developing and executing the complete range of analytics deliverables
- Leading a technical team of BI consultants both onshore and offshore
- Work with internal and external customers to develop cost-effective solutions
- Responsible for improving efficiencies across products
- Work with Executive Relationship Managers to improve sales by providing a solution to client reporting needs.
Manager, Analytics Consulting
Ultimate Software/UKG
07.2019 - Current
- Responsible for BI methodologies development processes governance and tool selection
- Accountable for the delivery of project capabilities and business results
- Developing information and object-based data warehouse to support Business Intelligence infrastructure and scalability
- Automated process to improve responsiveness and maintain high level Information systems services
- Leading a technical team of BI consultants both onshore and offshore
- Developed and implemented BI new hires’ training plan
- Work with internal and external customers to develop cost-effective solutions
- Responsible for estimating client projects
- Accountable for improving report development efficiencies by leveraging existing content
- Work with Executive Relationship Managers to improve sales by providing a solution to client reporting needs
- Responsible for managing a workload of forty thousand plus hours and five million dollars revenue per year
- Part of the Analytics Development services where the recurring revenue has grown to two-plus million dollars from seven thousand dollars in 2016.
Sr BI Consultant
Ultimate Software/UKG
10.2011 - 07.2019
- Provide product and subject matter expertise to clients and other team members
- Lead team members and partners to successful completion of projects
- Work with Management to create report development standards
- Assist in the onboarding of new hires and partner resources
- Giving online and in class training on report studio, Cognos Connection, Security, event studio and query studio
- Member of Tech Guru’s team who are responsible for new strategies to improve team efficiencies
- Help Management in estimating the projects
- Requirement gathering from the client
- Project documentation which includes report specification and warranty document
- Report development using report studio
- Creating BI Alerts for changes in employee personal information
- Update Framework Manager Model with additional tables, functions or stored procedures
- Creating database objects: stored procedures and functions
- Setup security for BI Reports and folders
- Update existing or create new transformer cubes
- Creating employee turnover Dashboards for Management
- Build report studio (MDX) reports using cube as a package.
Cognos 8.4.1 Developer and Administrator
Spherion Corp/SFN
03.2007 - 10.2011
- Optimized the Cognos environment to support more than 1000 users
- Responsible for the maintenance of Cognos environment
- Installed FP3 in Cognos 8.4.1
- Assigned security on Cognos Connection based on Global Groups and DLs
- Build framework model for Query Studio users
- Mentoring Query studio to users
- Build Framework Model for Report studio reports
- Updated existing reports in report studio with extra functionality
- Customized the reports by adding calculations, conditions and functions
- Assigned data level security using Cognos Groups
- Assigned data level security using a security table
- Created Dashboard for the management
- Documenting the technical design of reports
- Scheduled graphical reports for the management
- Optimized reports to save significant amount of run time
- Included java script in the report for an extra functionality
- Published Report documentation on the Cognos Connection
- Created cubes using Cognos Transformer
- Assigned security in cubes using Global Groups
- Responsible for maintaining and publishing cubes
- Build report studio(MDX) reports using cube as a package.
Cognos 8.1 Developer
Niutech Inc
01.2006 - 03.2007
- Migrated reports and cubes from version 7 to cognos 8
- Documenting the migration process from version 7 to cognos 8
- Creating packages in Framework Manager by importing metadata and creating the joins
- Publish packages in Cognos Connection
- Created, Published and Managed packages
- Created Reports using prompts and drill down
- Customized the reports by adding calculations, conditions and functions
- Created and Published cubes to Cognos connection
- Assigned security on Cognos Connection based on user groups
- Involved in the installation and configuration of cognos 8 on development and production machines
- Optimized cubes by using Time-Partioned cubes
- Created Burst reports
- Created events using Event Studio that checks for table updates and replication delay
- Created a Dashboard
- Documenting the technical design of reports and cubes.
Cognos Consultant
AIG Insurance
07.2005 - 12.2005
- Worked extensively on Cognos Impromptu and PowerPlay with the implementation of Impromptu Reports and PowerPlay Cubes
- Responsible for the design, development and implementation of Cubes and Reports using OLAP Tools - Cognos Impromptu and PowerPlay in Oracle Environment
- Created different joins according to User requirements
- Involved in analyzing joins to improve performance of reports
- Customized the reports by adding calculations, conditions and functions
- Conducted User Interviews and documented their queries, business analysis and data warehousing needs
- Migrated metadata from Impromptu and Architect using the migration utility and mapped it to the corresponding metadata of ReportNet
- Created, Published and Managed packages
- Created Reports using prompts and drill down
- Configured ReportNet to use the Cognos Series 7 namespace to render Series 7 entries in Cognos Connection
- Integrated ReportNet with third-party security providers like Application Server
- Published reports and cubes to Cognos connection.
Education
Master of Business Administration -
University of Florida
Gainesville, FL08.2012
Bachelor of Science, Computer Science -
Sacred Heart University
Fairfield, CT12.2004
Skills
- SQL Server
- Cognos 11/Tableau
- MS Office
- Forecasting
- Customer Service
- Data Warehousing
- Business Administration
- Project Management
Accomplishments
Received 2023 Leader of the Year Award
Certification
IBM Certified Designer Cognos 10 BI Reports
Timeline
Sr. Manager, Analytics Consulting
Ultimate Software/UKG
01.2024 - Current
Manager, Analytics Consulting
Ultimate Software/UKG
07.2019 - Current
Sr BI Consultant
Ultimate Software/UKG
10.2011 - 07.2019
Cognos 8.4.1 Developer and Administrator
Spherion Corp/SFN
03.2007 - 10.2011
Cognos 8.1 Developer
Niutech Inc
01.2006 - 03.2007
Cognos Consultant
AIG Insurance
07.2005 - 12.2005
Master of Business Administration -
University of Florida
Bachelor of Science, Computer Science -
Sacred Heart University
Similar Profiles
Charon Covington-WrightCharon Covington-Wright
Lead Services Project Manager at UKG (formerly Ultimate Software)Lead Services Project Manager at UKG (formerly Ultimate Software)
Scott ShafferScott Shaffer
Business Development Representative II at UKG (LEGACY ULTIMATE SOFTWARE GROUP, INC.)Business Development Representative II at UKG (LEGACY ULTIMATE SOFTWARE GROUP, INC.)
Gustavo A. TorresGustavo A. Torres
Sr. Implementation Representative at UKG Inc, formerly Ultimate Software IncSr. Implementation Representative at UKG Inc, formerly Ultimate Software Inc
Martin AndersonMartin Anderson
Service Worker II - Parks & Recreation at City of MargateService Worker II - Parks & Recreation at City of Margate
Sandro RavelinSandro Ravelin
Customer Service Sales Representative at NexRep LLCCustomer Service Sales Representative at NexRep LLC