• M.C.A from Indira Gandhi National Open University in Oct 2006. • Good understanding of the full software development lifecycle from design to implementation • Very strong in Data warehousing, ETL, SQL, MDX, DAX, T-SQ and Python • Extensive knowledge of Mortgage systems like IBIS and Equation • Extensive experience in creation of dashboards and reports using Power BI and Tableau • Good experience of use of SSIS, SSRS and SSAS for ETL, reporting and analytical projects. • Good understanding of testing the packages by test data. • Performance tuning the queries and monitoring of Job queues, logs and disk space • Creation of dashboards and reports for Management Information (MI). • Experience of batch script creation, identifying and resolving data related issues. • Data warehousing experience including star schema and normalized models. • Working knowledge of Agile/Scrum and Kimball methodologies. • Experienced with database design for highly transactional, highly available real time applications. • Understanding of business logic and process related to insurance and mortgages • Creation of pipelines in Azure and handling creating and handling build as a part of Dev Ops

Umesh Chintakindi

• M.C.A from Indira Gandhi National Open University in Oct 2006. • Good understanding of the full software development lifecycle from design to implementation • Very strong in Data warehousing, ETL, SQL, MDX, DAX, T-SQ and Python • Extensive knowledge of Mortgage systems like IBIS and Equation • Extensive experience in creation of dashboards and reports using Power BI and Tableau • Good experience of use of SSIS, SSRS and SSAS for ETL, reporting and analytical projects. • Good understanding of testing the packages by test data. • Performance tuning the queries and monitoring of Job queues, logs and disk space • Creation of dashboards and reports for Management Information (MI). • Experience of batch script creation, identifying and resolving data related issues. • Data warehousing experience including star schema and normalized models. • Working knowledge of Agile/Scrum and Kimball methodologies. • Experienced with database design for highly transactional, highly available real time applications. • Understanding of business logic and process related to insurance and mortgages • Creation of pipelines in Azure and handling creating and handling build as a part of Dev Ops

Available to hire

• M.C.A from Indira Gandhi National Open University in Oct 2006.
• Good understanding of the full software development lifecycle from design to implementation
• Very strong in Data warehousing, ETL, SQL, MDX, DAX, T-SQ and Python
• Extensive knowledge of Mortgage systems like IBIS and Equation
• Extensive experience in creation of dashboards and reports using Power BI and Tableau
• Good experience of use of SSIS, SSRS and SSAS for ETL, reporting and analytical projects.
• Good understanding of testing the packages by test data.
• Performance tuning the queries and monitoring of Job queues, logs and disk space
• Creation of dashboards and reports for Management Information (MI).
• Experience of batch script creation, identifying and resolving data related issues.
• Data warehousing experience including star schema and normalized models.
• Working knowledge of Agile/Scrum and Kimball methodologies.
• Experienced with database design for highly transactional, highly available real time applications.
• Understanding of business logic and process related to insurance and mortgages
• Creation of pipelines in Azure and handling creating and handling build as a part of Dev Ops

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent

Work Experience

Data Analyst / SQL Developer at Pepper Advantage Group UK
April 1, 2024 - December 1, 2025
Provided data analysis and SQL development support, created and deployed SSRS reports, built and amended SQL objects in SQL Server, and developed Snowflake pipelines. Worked on mortgage domain knowledge (including rate changes, eligibility, and remortgage processes) and collaborated on monthly file submissions. Created and configured SSRS subscriptions and automated reporting workflows, while supporting ticketing-based issue resolution and source control (SVN).
Business Intelligence Analyst / SQL Developer at Europe Arab Bank
October 1, 2023 - April 1, 2024
Analyzed Business Requirements Documents, explored data options, and developed data integration solutions. Created SSIS packages, loaded mortgage data into the data warehouse, backed up/restored databases for test/UAT environments, and authored test scripts. Built and modified SSRS reports and subscriptions, and delivered Power BI reports as requested by the business.
Business Intelligence Analyst / SQL Developer at Handelsbanken
December 1, 2022 - July 1, 2023
Analyzed business requirements, documented processes with flow charts, and designed data warehousing solutions. Created SSIS pipelines, Azure-based job orchestration, and dashboards with SSRS/Power BI. Responsible for test planning, UAT support, and reporting automation.
SQL Developer at HSBC
October 1, 2021 - November 1, 2022
Developed T-SQL scripts and SSIS packages to load and transform data into the data warehouse. Created Python scripts to ingest data, built ETL pipelines, and troubleshooted SSIS packages to ensure smooth processing.
SQL Developer at Two Circles
May 1, 2021 - October 1, 2021
Developed data warehouses and ETL pipelines, created job controllers and SSIS packages to load data into the warehouse. Designed star and snowflake schema models, and created Azure-based application and database jobs. Built APIs for data extraction from client sites and implemented scheduled data loads.
SQL Developer at OSB – One Savings Bank
January 1, 2019 - December 31, 2020
Contributed to MI projects with T-SQL and SSIS, built data warehouses and ETL pipelines, and implemented scheduled jobs. Supported UAT defects and automated data loading processes, including Azure-based deployments.
SQL Developer / Operation Analytics Officer at Neopost
May 1, 2018 - November 1, 2018
Produced daily, monthly, and group-level MI reports using SQL Server. Migrated Excel reports to SSRS, developed SSIS processes, created data cubes in SSAS, and implemented ETL pipelines. Worked on data-driven process improvements and automated data provisioning.
ETL/SQL Developer at Kensington and Chelsea and Hammersmith Council
March 1, 2018 - May 1, 2018
Migrated data from legacy systems to SQL Server, created ETL packages, tested packages against reconciliation frameworks, and produced SSRS summary reports. Collaborated with business analysts to translate functional specs into technical designs.
Analyst / SQL Developer at Dentsu Aegis Network
August 1, 2017 - February 1, 2018
Captured data processing requirements with ad hoc data flows using Kimball methodology. Created ETL packages, tested data flows, and resolved data-related issues. Built data models and reports to support MI and advertising analytics.
Sql Developer at Enzen (client UK Power networks)
March 1, 2017 - June 1, 2017
Performed MI report development, maintained SSRS reports, created ETL jobs to load data into the data warehouse, and developed cubes in SSAS using Kimball methodology. Performed Dev/UAT testing and production deployment.
Sql Developer at Comensura
July 1, 2016 - November 1, 2016
Created BI reports and dashboards using SSRS, implemented DAX/Power BI for analytics, and developed SQL scripts, stored procedures, and ETL processes to support MI and client reporting.
Sql Developer / Analyst at Weve
October 1, 2014 - September 1, 2015
Leveraged SSIS/SSRS for ETL and MI reporting. Wrote T-SQL scripts, performed data scheduling, and documented functional/technical specifications. Collaborated with teams to optimize database schemas.
Sql Developer at Metapack
June 1, 2012 - October 1, 2014
Extracted data from Oracle to SQL Server, performed ETL using SSIS/SSRS/SSAS, and developed dashboards and MI reports. Implemented T-SQL/MDX queries and scheduled jobs for data loading.
Consultant / Analyst at Capgemini Consulting Plc UK
January 1, 2011 - May 1, 2012
Supported House of Fraser projects with SQL/Oracle data integration, designed functional/technical specs, and provided testing support across UAT. Managed incident resolution and data interface issues.
Consultant / Developer at Capgemini Consulting India
April 1, 2006 - January 1, 2011
Worked on Matalan project, developed SQL Server and Oracle PL/SQL modules, created procedures/triggers, and delivered UAT-ready components. Assisted with data extraction and batch processing.
System Engineer / Team Lead at TCS (Lantastic Solutions)
November 1, 2004 - April 1, 2006
Code reviews, SQL/Oracle development, shell scripting in Linux, and supporting PKMS/WMOS interfaces. Led teams and delivered maintenance and data-related enhancements.
Team Member at Alphabetics Computer Services Ltd
October 1, 2003 - October 1, 2004
Developed PL/SQL scripts, stored procedures, and shell scripts for data extraction and manipulation. Provided support for ICICI Demat online services and batch data processing.
SQL Developer at Comensa
July 1, 2016 - November 1, 2016
Created MI/BI reports; developed DAX/Power BI dashboards; built SSIS packages for ETL; performed testing and documentation of functional/technical specs; collaborated with business analysts.
Support Analyst / SQL Developer at Capgemini Consulting Plc UK
January 1, 2011 - May 1, 2012
Supported HOUSE OF FRASER projects; created SQLs for data extraction (SQL Server 2008) and Oracle 10g PL/SQL; prepared functional/technical design documents; participated in UAT and issue resolution.
Team Lead / SME at Capgemini Consulting India
April 1, 2006 - January 1, 2011
Led data warehousing efforts for Matalan project; designed data flows, built SQL/PL-SQL objects, Crystal Reports; mentored offshore resources; delivered MI reports and data extracts for multiple clients; wrote shell scripts for data loading on Red Hat Linux.
System Engineer / Team Lead at TCS (Lantastic Solutions), India
November 1, 2004 - April 1, 2006
Worked with multiple clients (VSNL, MTNL, BSNL); reviewed procedures, SQL scripts (Oracle PL/SQL); performed unit/system/integration testing; provided offshore coordination and leadership.

Education

M.C.A. at Indira Gandhi National Open University
January 11, 2030 - October 1, 2006
H.S.C. at Elphinstone College
January 11, 2030 - March 1, 1993
S.S.C. at Mumbai Board
January 11, 2030 - March 1, 1991
M.C.A at Indira Gandhi National Open University
January 11, 2030 - October 1, 2006
HSC at Elphinstone College
January 11, 2030 - March 1, 1993
SSC at Mumbai Board
January 11, 2030 - March 1, 1991

Qualifications

Oracle 9i, Architecture and Administration
January 11, 2030 - January 9, 2026
ITIL V3 certification
January 11, 2030 - January 9, 2026
Oracle 9i, Architecture and Administration
January 11, 2030 - January 9, 2026
ITIL V3 certified
January 11, 2030 - January 9, 2026

Industry Experience

Financial Services, Telecommunications, Retail, Professional Services, Media & Entertainment, Software & Internet, Education