Prashant Rupani
Tampa,FL
Summary
Experienced Senior Cognos Developer with a 15-year track record, adept at leading global teams and delivering impactful solutions. The track record showcases a demonstrated proficiency in analyzing critical support needs, identifying opportunities, and driving innovative strategies to enhance reliability and productivity using Cognos in supply chain, retail, banking, insurance, pharmaceutical. Strive to bring an unwavering commitment to driving success, trying to be an ideal candidate for the team. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior Business Intelligence Developer
Rooms To Go
09.2023 - Current
- Managed a team of data analysts to plan and track report development process
- Improved report performance, resulting in a 92% reduction in load times for critical metrics like Delivered Qty, Return Qty, Exchange Qty, and Service Qty
- Created complex measures to display Quantity metrics for Last 30, Last 60, Last 90, Last 180, Last 365, MTD, QTD, YTD.
Senior Specialist - Data Engineering
LTIMindtree
07.2023 - 09.2023
- Lead client meetings for a large brewing company to gather requirements to develop insight driven dashboard in an agile environment
- Analyzed complex data sets and understand business requirements to create effective data models in Framework Manager
- Managed and developed Cognos reports using Report Studio using prompts, filters, conditional variables
- Managed user groups and roles, dispatchers and services in Cognos Administration
- Create content maintenance tasks and run them at a scheduled time
Senior Solution Architect
E2open
02.2022 - 06.2023
- Worked with Product Architect in defining the requirements and needs of customer for various e2open products
- Lead client engagements for designing and developing BI solutions in order to deliver a valuable and insight driven dashboards in an agile environment
- Successfully led and managed a team of three direct reports, optimizing their strengths and fostering a high-performing, cohesive unit to achieve goals
- Improved the performance of dashboards by 25 % by using optimized loading and performance tuning of SQL
- Designed and developed reports for various customer using various e2open products like E2PR, E2SC, SnOP etc
- Installed, configured & upgraded Cognos in distributed environment on multiple servers like Development, Quality and Production
- Performed content store maintenance tasks, back-up tasks, managed data sources and connections, dispatchers & services in a distributed Cognos environment as a Cognos Administrator
- Configured Cognos Web Server, Application Server, Content Manager so as to ensure load balancing and address performance issues
- Develop reports with filters, multi-prompts with drill through capabilities, conditional styling, exceptional highlighting, using complex data gathered from disparate data sources using Report Module
Senior Associate - Projects
Cognizant Technology Solutions
02.2014 - 02.2022
- Worked with Business Analyst in defining the requirements and needs and designed report specifications during team meetings and translated them into BI solutions
- Liaise between Project Managers, Business Users and IT Infrastructure resources and translate various business requirements into approved corporate technical specifications
- Supported implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
- Mentor the team members on implementing Data Warehouse and Business Intelligence best practices
- Designed and developed data models using various data modeling tools like Dynamic Cubes/Transformer/Framework Manager
- Develop reports with list, crosstabs, master detail, filters, multi-prompts with drill through capabilities, conditional styling, exceptional highlighting from disparate data sources using Cognos Report Studio
- Upgraded Cognos from v10.2.2 to v 11.0.10 as part of client's initiative to roll out the analytics version of Cognos to the business community
- Enhanced the reporting structure and optimized the Cognos PRL Report there by resulting in a savings of $10,000 per year for banking client by automating PRL Attestation Compliance Report in Cognos for Product Reference Library process owner
- Trained the users in using new tools in Cognos 11 to help them transition smoothly to Cognos 11
- Prepared frequently asked questions document, reference guides like How to run a Report, How to schedule a report, How to create a simple report in Cognos 11 to help the users to reinforce the learnings from the training sessions
- Trained the users on new features of Report Module, Data Module, Dashboard, Story in Cognos Analytics 11.0.10.
Programmer Analyst
Vensoft LLC
02.2008 - 02.2014
- Analyzed the business requirements and convert them into lucid technical design specifications and optimal technical solutions
- Implemented package, object and data security across using Framework Manager and implemented security at Cognos Connection level
- Worked on Cognos Framework Manager to import data from heterogeneous data sources and to create Framework data models (Relational & DMR) and packages using Dynamic Query Mode (DQM) & Compatible Query Mode (CQM) engine
- Develop reports with filters, multi-prompts with drill through capabilities, conditional styling, exceptional highlighting, using complex data gathered from disparate data sources
- Built Active Reports using various decks/controls so as to optimize the report on Mobile Devices
- Designed and developed dimension, levels, hierarchies, measures, calculations in OLAP cubes using Transformer 10.1.1/8.4.1 and implemented security within them
- Automated the OLAP Cubes on conditional basis using Autosys and Unix Environment
- Create and maintain documentation of operating procedures, functional requirements specifications, technical design specifications, application designs and training user guides
- Test and document all code changes involved during various stages of testing including unit testing, system integration testing, user acceptance testing, and production testing.
Education
Master of Science - Information Systems
New Jersey Institute of Technology
Newark, NJ12.2007
Bachelor of Engineering - Information Technology
Mumbai University
Mumbai06.2006
Skills
- Cognos
- T-SQL
- PL/SQL
- Windows
- UNIX
- Teradata
- Netezza
- IBM DB2
- Oracle
- SQL Server
- Report automation Business analysis
- Database administration Project management
- Performance tuning ETL development
- SQL querying Data warehousing
- Data modeling Dashboard design
- Data Mapping
- Data Modeling
- Advanced Analytics
- Data Migration
- Technical Documentation
- Information Management
- Fluent in English
Certification
- IBM Certified Developer - Cognos 10 BI OLAP Models
- IBM Certified Designer - Cognos 10 BI Reports
- IBM Certified Developer - Cognos 10 BI Metadata Models
Timeline
Senior Business Intelligence Developer
Rooms To Go
09.2023 - Current
Senior Specialist - Data Engineering
LTIMindtree
07.2023 - 09.2023
Senior Solution Architect
E2open
02.2022 - 06.2023
Senior Associate - Projects
Cognizant Technology Solutions
02.2014 - 02.2022
Programmer Analyst
Vensoft LLC
02.2008 - 02.2014
Master of Science - Information Systems
New Jersey Institute of Technology
Bachelor of Engineering - Information Technology
Mumbai University
Similar Profiles
Jasmine A. RosierJasmine A. Rosier
Office Assistant at Rooms To GoOffice Assistant at Rooms To Go
Terrence NoblesTerrence Nobles
Forklift Operator at Rooms To GoForklift Operator at Rooms To Go
Giovanni PastranaGiovanni Pastrana
Delivery Driver and Installer at Rooms To GoDelivery Driver and Installer at Rooms To Go
Loretta KatesLoretta Kates
Customer Service Supervisor at Rooms To GoCustomer Service Supervisor at Rooms To Go
Dylan WhitneyDylan Whitney
Lead Landscaper at Sweet William Garden & DesignLead Landscaper at Sweet William Garden & Design