Rajiv Puli
Sr Data Analytics/ Project Manager
San Francisco,CA
Summary
Results-driven IT professional with over 18 years of extensive experience in software design, development, and data warehousing. Expertise in creating and optimizing complex reports and interactive dashboards using Cognos and Tableau, employing advanced data visualization techniques to transform intricate datasets into actionable insights. Recognized for a proactive approach and adaptability in collaborating with cross-functional teams and clients, ensuring alignment with business objectives while delivering high-quality analytical solutions under tight deadlines. A tech-savvy innovator skilled in identifying opportunities for technological enhancements, committed to leveraging versatile skills in project management and problem-solving to drive team success and contribute to organizational growth.
Overview
20
20
years of professional experience
Work History
Sr BI Cognos Lead/ Tableau Developer/ Project Manager Full Time
University of California at San Francisco (UCSF)
03.2013 - Current
- Installed and configured the Cognos10/11 applications on Windows server.
- Created security groups and added users to those groups.
- Deployed packages and reports to Production.
- Created scripts and scheduled them to automate transformer cubes builds.
- In Cognos Framework manager (FM), built relational sources for reports and Transformer cubes.
- Built transformer models using FM packages and reports as source.
- Defined joins between tables and calculations in FM.
- Created reports and Dashboards against relational and Cubes sources in Report Studio.
- Created Drill through Reports and Drill up-down reports.
- Used Javascripts to customize the reports according to requirements in the Report Studio.
- Improved performances of the Reports.
- Converted their legacy reports according to the new standards.
- Worked on Relational and Dimensional reports.
- Developed and deployed reports/packages.
- Set up security folders and grant/ revoke access to users.
- Peer reviews: testing reports developed by Peers.
- Built transformer models and the cubes.
- Built batch file and created task schedulers to run these Bat files based on triggers.
- Created reports against the cubes.
- Developed data sources for the dashboards in Tableau Desktop.
- Developed, Debugged and Published dashboards.
- Set up access for users and deployed dashboards built by Users.
- Led a project where ERP systems where transitioning to new location with different architecture which impacted downstream teams like data engineers and BI teams.
- Developed projects plans in Workfront and Smartsheet. Conducted meetings with Cross functional teams to understand the changes, prepared meeting notes and reported the timelines and status to the stakeholders.
- Environment: Tableau 2025.x, Cognos 11.x Cognos 10.x, Framework Manager, Report Studio, TM1 10.1.1 , MS Excel, Oracle 11g, Oracle 19, Toad.
Cognos BI Consultant/Analyst
Lawrence Berkeley Lab
01.2012 - 01.2013
Cognos BI Consultant/Analyst
Affymetrix
06.2011 - 11.2011
Cognos BI Consultant
Datacert
05.2011 - 06.2011
Cognos BI Consultant/Analyst
Sears Holdings
11.2009 - 04.2011
Cognos BI Consultant/Analyst
Paradigm
03.2009 - 10.2009
Cognos BI Consultant/Analyst
University of Washington Physician (UWP)
12.2008 - 03.2009
Cognos BI Consultant/Analyst
NetApp
04.2008 - 11.2008
Cognos BI Consultant
Kaiser Permanente
03.2008 - 04.2008
Cognos BI Consultant
Fairfields Residential, LLC
07.2007 - 01.2008
Cognos BI Developer
WebEx Global Communications (Cisco)
02.2007 - 06.2007
Cognos ReportNet Developer
Shell Oil
10.2005 - 01.2007
Education
Bachelor - Engineering
JNTU
India05.2004
Skills
- BI Tools: Cognos, Tableau, QlikView, Motio
- OLAP and BI tools proficiency: Cognos Transformer
- Proficient in SQL
- Project management
- Strong verbal communication
- Cognos 8 certified
- PMP certification training
Timeline
Sr BI Cognos Lead/ Tableau Developer/ Project Manager Full Time
University of California at San Francisco (UCSF)
03.2013 - Current
Cognos BI Consultant/Analyst
Lawrence Berkeley Lab
01.2012 - 01.2013
Cognos BI Consultant/Analyst
Affymetrix
06.2011 - 11.2011
Cognos BI Consultant
Datacert
05.2011 - 06.2011
Cognos BI Consultant/Analyst
Sears Holdings
11.2009 - 04.2011
Cognos BI Consultant/Analyst
Paradigm
03.2009 - 10.2009
Cognos BI Consultant/Analyst
University of Washington Physician (UWP)
12.2008 - 03.2009
Cognos BI Consultant/Analyst
NetApp
04.2008 - 11.2008
Cognos BI Consultant
Kaiser Permanente
03.2008 - 04.2008
Cognos BI Consultant
Fairfields Residential, LLC
07.2007 - 01.2008
Cognos BI Developer
WebEx Global Communications (Cisco)
02.2007 - 06.2007
Cognos ReportNet Developer
Shell Oil
10.2005 - 01.2007
Bachelor - Engineering
JNTU