Pradeep Kumar Govindlu Kalagaggri
Cleveland,OH
Summary
Results-driven Data Quality Analyst with over 14 years of expertise in leveraging data visualization, big data, and Informatica tools to enhance data quality outcomes within enterprise data warehouses. Proficient in creating impactful dashboards, reports, and data models while executing complex SQL queries and managing data extraction, transformation, and loading processes using Tableau, OBIEE, Python, Informatica PowerCenter, Teradata, and Oracle. Demonstrates a strong ability to bridge the gap between business and technical teams, ensuring seamless collaboration and effective communication. Committed to delivering actionable insights that drive informed decision-making and optimize organizational performance.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
PNC Bank
05.2023 - Current
- Requirement gathering and Rule Assertion for new and existing rules (business and structural) for the given Line of Business.
- Developing/Creating end-user reports which would in turn help in Federal reporting, data analytics, and decision-making using Tableau reporting tools
- Involved in designing PoC for Data Quality Application to make it more visible to consumers
- Developing/Creating Tableau end-user reports which would in turn help for Alation Project Consumers
- Developing/Creating Tableau end-user reports which would in turn help for CDI Application Consumers and Analysts
- Developing and creating new Overview Dashboards for MDM Application.
- Developing/Creating ETLs for Populating DGA Application data to Reporting schema data so that they would be used for report creation.
- Analyzed large datasets to identify trends and inform strategic decision-making.
- Developed and implemented data visualization dashboards for enhanced reporting accuracy.
- Collaborated with cross-functional teams to optimize data collection processes and improve efficiency.
- Mentored junior analysts in data analysis techniques and tool utilization for skill development.
- Migration of ETL components from Lower Environment to Higher Environments using Artifactory, uDeploy etc
- Creation of CA7 jobs for scheduling ETL jobs
- Developing/Creating Critical Data MDM dashboards as per latest business requirements.
Senior Business Intelligence Analyst
Dataeconomy Inc, Citizens Bank and Citibank
04.2022 - 04.2023
- Developing/Creating end-user reports which would in turn help in AML reports, data analytics, and decision-making using the Tableau reporting tool
- Created Trending, Ranking, Sankey Charts, Maps, Customized charts and Insights reports which would be used as PoC reports for attracting new clients for providing AML Services
- Loading sample data on My SQL server database, AWS Athena to connect to tableau using data blending techniques on the Tableau tool
- The reports I developed have been used as showcase reports for AML solutions that my company provides as a solution to new clients and the reports can be viewed below link.
- Https://www.dataeconomy.io/products/aml-cockpit.html
BI Lead and Data Quality Analyst
TCS, PNC Bank
03.2011 - 03.2022
- Requirement gathering and Rule Assertion for new and existing rules (business and structural) for the given Line of Business.
- Manual execution of rules by creating SQL Scripts, preparing data quality analysis reports, and providing reports to SMEs for review and sign-off to automate.
- Developing/Creating end-user reports which would in turn help in Federal reporting, data analytics, and decisive making using OBIEE and Tableau reporting tools
- Development of automated Data Quality framework on Teradata using programming languages such as Shell Scripts and CA7 Scheduler
- Code review of all the components including Informatica ETLs, CA7 Scheduling, Unit Test Case, IQA, EQA documents, etc. developed by Peers with the code review checklist.
- Daily Analytics Report creations for different Lines of Business initiatives such as CECL, and CMDM based on their requirement.
- Involved in conversion of Reports from Oracle database to Teradata for OBIEE reporting using SQLs, SQL query changes, and query tuning as required
- Designing the data quality engine to automate rule execution by preparing high- and low-level design documents
- Deployment of code (both ETL and OBIEE) to various environments (Test, QA, and production) using DevOps tools – uDeploy, Bitbucket, etc.
- Coordination with the TCoE team and Business users for functional and user acceptance testing.
- Production readiness activities such as documentation, Object inventory preparation, and Turnover meetings with production support teams before deployment in production.
- Performance optimization of the existing code based on requirements.
- Perform, analyze and resolve defects, bug fixing, and defect prevention.
- Resolving issues relating to technical and functional components and escalating matters requiring immediate attention to the immediate supervisors.
- Daily status reporting over daily calls and by emails to Project Lead and weekly calls and status reports to Managers and Clients.
- Development and enrichment of Compliance documentation for existing and new application components.
- Coordination with the Offshore team for development-related activities.
- Proof of concept (POC) on Ad-hoc requirements
- Providing estimates on Reporting requirements.
- Analyzed data quality metrics to identify discrepancies and recommend improvements.
- Developed and implemented data validation procedures to enhance accuracy across systems.
- Collaborated with cross-functional teams to address data integrity issues proactively.
- Led training sessions for staff on best practices in data management and quality assurance.
- Streamlined reporting processes, reducing turnaround time for data reviews and assessments.
- Evaluated large datasets for quality and accuracy.
- Generated standard and custom reports to provide insights into business performance.
- Implemented business intelligence solutions to increase operational efficiency.
Data Analyst
PNC Bank (Offshore Through TCS)
08.2011 - 12.2014
- Development of ETL Mapping/session/workflows using Informatica, and Shell scripting for automated data quality on historical data for different source systems.
- Performed data profiling to identify the pattern of data using the Informatica Analyst tool and Teradata Stored Proc.
- Developed Unix Script for email notification for notifying clients.
- Preparing a Job flow diagram for executing the different jobs in the best possible way.
- Migration of ETL code, Database components, and CA7 jobs to the higher environment using uDeploy, Bitbucket (git), Artifactory, etc.
- Perform IQA on developed code and peer review.
Education
Bachelor of Technology - Electronics and Communications Engineering
PDA College of Engineering
Belgaum, India01.2010
Skills
- Proficient in Tableau
- Oracle Business Intelligence expertise
- Data extraction and transformation
- Skilled in Tableau Desktop analysis
- OBIEE and webtool experience
- Informatica PowerCenter expertise
- Experience with data warehousing tools
- Experience in US banking systems
- Data accuracy management
- Data analysis expertise
- Experienced in applying technical skills
- Tableau expertise
- Nine years of OBIEE experience
- ETL development with Informatica Power Center
- 14 years of experience in SQL and database technologies
- Experienced in application usage and support
- Data quality management
- Experience in data governance
- Extensive experience in US banking
- Proficient in data analysis techniques
Certification
Tableau Desktop Specialist - 2020
Languages
English
Kannada
Telugu
Hindi
Industry experience
US Banking
Environments
Offshore and Onshore
Accomplishments
- Collaborated with team of 20+ in the development of Data Quality Project.
- Resolved product issue through consumer testing.
- Supervised team of 5 staff members.
Timeline
Senior Data Analyst
PNC Bank
05.2023 - Current
Senior Business Intelligence Analyst
Dataeconomy Inc, Citizens Bank and Citibank
04.2022 - 04.2023
Data Analyst
PNC Bank (Offshore Through TCS)
08.2011 - 12.2014
BI Lead and Data Quality Analyst
TCS, PNC Bank
03.2011 - 03.2022
Bachelor of Technology - Electronics and Communications Engineering
PDA College of Engineering