Pratap Reddy
BI Sr Associate
Hyderabad
Summary
Result-oriented professional targeting assignments in Business Intelligence/ Data Analytics with an organization of high repute; Offering nearly 11 years of experience
Overview
12
12
years of professional experience
1
1
Certification
Work History
Sr. BI Developer
JP Morgan Chase
05.2017 - Current
- Leading the delivery of BI applications which spans across multiple tools like Tableau, Cognos, Alteryx
- Work with business stakeholders, application developers, production teams to gather business needs and discuss solution options
- Gathering user requirements to meet end client specifications, implement new enhancements and provide production support
- Build Tableau dashboards, wireframes based on end user requirements
- Build Cognos Framework Models and develop cognos reports for business stake holders
- Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations
- Created Alteryx workflows to prepare data for Tableau using multiples data sources
- Converted Cognos reports to Tableau Dashboards
- Developed reports and dashboards using Cognos Report Studio
- Created Cognos Framework models, Packages & published the packages
- Created Automated process for data cleaning to data visualization as outcome using Alteryx to Tableau
- Experience in creating visual reports, dashboards and KPI score cards using Power BI
- Proficient in running DAX queries and expertise in the application of advanced level calculations to data collection
- Experience in analyzing the data and building the graphs using the python libraries Pandas, NumPy, Matplotlib, Seaborn
- Published workflows to Tableau server using Python tool in Alteryx
- Working in rapid Agile development environment
- Environment: Tableau, Cognos, Teradata, Oracle, Power BI, SQL Assistant, Windows 10.
Cognos/Tableau Developer
HTC Global Services
01.2016 - 05.2017
- Develop, Organize, manage, and maintain graphs, tables, and document templates for the efficient creation of reports
- Gathering user requirements to meet end client specifications, implement new enhancements and provide production support
- Created Tableau Tableau dashboards, wireframes based on end user requirements
- Developed reports and dashboards using Cognos Report Studio
- Created Cognos Framework model, Packages & publishing the packages
- Created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings and provided Knowledge Transfer to the end users
- Environment: Tableau, Cognos, Teradata, Oracle, Power BI, SQL Assistant, Windows 10
Cognos Developer
Yash Technologies Pvt Ltd
12.2014 - 01.2016
- Created Technical design document for Report studio reports based on Functional specification
- Understanding the Specification and develop the reports according to client requirements
- Extensively used HTML& Java Script to validate Date Prompts and provide better user interface to the customers
- Extensively used prompts, master-detail query relationships, grouping and sorting features of Report Studio to generate efficient and user-friendly reports
- Bursting the Reports in Cognos Environment
- Extensively used conditional format features of Report Studio to generate efficient and user-friendly reports
- Extensively used Drill- through reports, Master detail reports
- Scheduled and Distributed reports using Schedule Management in Cognos Connection
- Created User Documentation to train the client-side users of the system
- Communicating status to Onsite on a regular basis
- Environment: Cognos 10, SQL Server
Cognos Developer
Hexaware Technologies Pvt Ltd
04.2011 - 10.2014
- Created Technical design document for Report studio reports based on Functional specification
- Understanding the Specification and develop the reports according to client requirements
- Extensively used HTML& Java Script to validate Date Prompts and provide better user interface to the customers
- Extensively used prompts, master-detail query relationships, grouping and sorting features of Report Studio to generate efficient and user-friendly reports
- Bursting the Reports in Cognos Environment
- Extensively used conditional format features of Report Studio to generate efficient and user-friendly reports
- Extensively used Drill- through reports, Master detail reports
- Scheduled and Distributed reports using Schedule Management in Cognos Connection
- Created User Documentation to train the client-side users of the system
- Communicating status to Onsite on a regular basis
- Environment: Cognos 8/10, SQL Server, SSIS, Informatica, Cognos Workforce Analytics.
Education
Master of Computer Applications -
Andhra University
Skills
Cognosundefined
Certification
AWS Solution Architect Associate
Timeline
AWS Solution Architect Associate
04-2023
Sr. BI Developer
JP Morgan Chase
05.2017 - Current
Cognos/Tableau Developer
HTC Global Services
01.2016 - 05.2017
Cognos Developer
Yash Technologies Pvt Ltd
12.2014 - 01.2016
Cognos Developer
Hexaware Technologies Pvt Ltd
04.2011 - 10.2014
Master of Computer Applications -
Andhra University
Similar Profiles
Lisa Olivia GrenviczLisa Olivia Grenvicz
Private Client Banker at JP Morgan Chase & Company (Chase Bank)Private Client Banker at JP Morgan Chase & Company (Chase Bank)
Taylor SimsTaylor Sims
Client Services Specialist & Associate Banker at JP Morgan Chase & Chase BankClient Services Specialist & Associate Banker at JP Morgan Chase & Chase Bank
Miranda GuerreroMiranda Guerrero
Associate Banker Market Expansion at Jp Morgan Chase ChaseAssociate Banker Market Expansion at Jp Morgan Chase Chase
Soumya ShobhanaSoumya Shobhana
Risk Analyst at JP Morgan Chase & Co.Risk Analyst at JP Morgan Chase & Co.
Suresh BhumireddySuresh Bhumireddy
Technical Specialist at Bosch Global Software TechnologiesTechnical Specialist at Bosch Global Software Technologies