Pradeep Kotha
Business Analytics Architect
Pune,MH
Summary
Results-driven BI Architect with over 18 years of experience in leveraging technology and business acumen to deliver actionable insights. Proficient in Database, ETL, data visualization tools, and statistical analysis, with a proven track record of leading cross-functional teams to achieve strategic objectives.
Overview
18
18
years of professional experience
2
2
Certification
Work History
Assistant Vice President
Deutsche Bank Group
02.2014 - Current
- Technology Leadership & Team Management:
- Reported to CIO-1 of the Origination & Advisory division, defining and implementing technology strategy.
- Led the Business Intelligence strategy for the division as BI Architect
- Played a crucial role in establishing the O&A Pune Tech Center since its inception in 2018.
- Managed large teams of up to 40+ resources and multiple global projects.
- Recruited, coached, motivated, and assessed the performance of direct reportees.
- Business Intelligence & Analytics:
- Managed and led BI products in various roles like BI Architect, Lead and Developer
- Certified Business Intelligence Author.
- Partnered with Trading, Finance, and Data teams to lead end-to-end analytics projects, including requirement gathering, data acquisition, and dashboard development reports for Revenue Credits calculations, Earnings Reports, Risk Detection, Anti-Fraud and Money Laundering, Access Management, and Privacy Protection.
- Translated complex business requirements into actionable roadmaps with clear milestones and deliverables, presented data-driven findings to senior leaders, effectively telling the story behind the numbers.
- Provided training to developers and business users.
- Created Technical Specifications and Mapping Documents.
- Technology Strategy & Security:
- Ensured the security of IT assets (servers, databases, UI, etc.) against threats and unauthorized access.
- IT Application Owner (ITAO) for 10 applications/projects, successfully reducing excess spending and increasing efficiency.
Module Lead
Mphasis
02.2008 - 01.2014
- Facilitated Requirement Gathering and Documentation:
- Conducted comprehensive workshops with business and IT stakeholders to gather and analyze requirements, preparing detailed end-to-end solution documents that align with project goals.
- Developed End-to-End BI Applications:
- Created and deployed entire BI projects using various technologies for Databases, Data Marts ,ETL and reporting applications.
- Created Templates, leveraged industry proven methodologies to enhance developer productivity
and streamline application development processes. - Guided Project Teams to Success:
- Provided technical leadership and guidance to
project teams. - Took complete technical responsibilities and resolved complex issues.
- Performed Impact Analysis and Code Reviews:
- Conducted impact analysis and
reviewed Data Mart, ETL and Dashboards design to ensure adherence to BI best practices and
performed thorough reviews of technical documents to maintain consistency and compliance. - Managed Teams and Deliverables:
- Parallel stretch of support and development
responsibilities by supporting in house and client teams during the project development as well as supporting end users for their day-to-day business
operations. - Managed scrum calls and Sprints
Technical Associate
Tech Mahindra
08.2006 - 01.2008
- IBM Cognos and Datastage Solutions:
- Utilized strong reporting , cube designing, modelling and ETL best practices to deliver BI solutions.
- Designing and Developing Data Pipelines : Creating and configuring data integration processes using IBM InfoSphere DataStage.
- Building Jobs : Designing and building ETL (Extract, Transform, Load) jobs to extract data from various sources, transform it into a usable format, and load it into target systems.
- Data Mapping : Mapping data fields from source systems to target systems, ensuring data integrity and accuracy.
- Debugging and Testing : Testing and debugging ETL jobs to ensure they run correctly and efficiently.
- Performance Tuning : Optimizing job performance to handle large volumes of data and meet processing time requirements.
- Collaboration : Working closely with business analysts, project managers, and other stakeholders to understand data requirements and ensure the ETL processes meet business needs.
- Reporting:
- Creating and designing reports and Cubes using Cognos Report Studio and series 7 Impromptu and Powerplay Transformer.
- Optimizing the performance of reports and queries to ensure efficient data retrieval and processing.
- Testing and support to business users
- Documentation : Maintaining comprehensive documentation of data mappings, job configurations, reporting designs, queries used and any custom scripts or transformations used.
- Provided BAU Support: Managed Business-As-Usual (BAU) support, efficiently resolving incidents and minimizing operational disruptions. Taken care of change requests and enhancements.
Education
B.Tech in Information Technology -
Kakatiya University
Warangal, India05-2004
Skills
- Database: Oracle, Google BigQuery, MariaDB, ClickHouse,Microsoft SQL Server, IBM Db2
- ETL: Informatica, IBM Infosphere/Datastage and Abintio
- Reporting: Tableau, IBM Cognos Analytics, Microsoft PowerBI, Google Looker Studio/Data Studio and Amazon QuickSight
- Cloud: Google Cloud Platform
- Others: Jira, ServiceNow, Confluence, ERWIN 31/40, Unix, SQL Developer Data Modeler, HP Quality Center(ALM), StarTeam, GitHub, Toad
Certification
IBM Cognos certified BI Author
IBM Certified Solution Expert
Languages
English
Advanced (C1)
Telugu
Advanced (C1)
Hindi
Upper intermediate (B2)
kannada
Elementary (A2)
Timeline
Assistant Vice President
Deutsche Bank Group
02.2014 - Current
Module Lead
Mphasis
02.2008 - 01.2014
Technical Associate
Tech Mahindra
08.2006 - 01.2008
B.Tech in Information Technology -
Kakatiya University
Similar Profiles
Dnyaneshwar BhogilDnyaneshwar Bhogil
Trade and Transaction Analyst at Deutsche Bank Group, Deutsche BankTrade and Transaction Analyst at Deutsche Bank Group, Deutsche Bank
PRADEEP KUMARPRADEEP KUMAR
Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)
Manoj Singh SolankiManoj Singh Solanki
Senior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank GroupSenior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank Group
Mohit ShrivastavaMohit Shrivastava
Vice President - Network Operations Lead, India at DBOI Global Services (Deutsche Bank Group)Vice President - Network Operations Lead, India at DBOI Global Services (Deutsche Bank Group)
Abhishek JoshiAbhishek Joshi
Director Supply Chain Solutions and Capability at WNS Global ServicesDirector Supply Chain Solutions and Capability at WNS Global Services