SENIOR SQL SERVER , ETL DEVELOPER , T-SQL , SSIS , DATA WAREHOUSING
CHAKRAVARTHY SURAY
GENPACT LIMITED
10
years of professional experience
IT professional with 10 years of overall experience, including 6+ years of hands-on experience in SQL Server-based projects. Core strengths include T-SQL development, stored procedures, functions, views, query optimization, indexing, SQL Server Agent, SSIS package development, ETL workflows, data warehousing, data validation, reconciliation, and reporting automation. Experienced in translating business requirements into technical specifications, supporting application integration, and building Power BI and Excel dashboards for KPI/SLA monitoring. Working exposure to AWS S3, IAM, Glue, Lambda, and Athena; familiar with Microsoft Fabric data modeling concepts. Targeting remote SQL Server Developer, SSIS/ETL Developer, and SQL-focused Data Engineering roles.
Work History
3 Years
10.2023 - Current
3 Years
Senior Business Analyst
GENPACT LIMITED
10.2023 - Current
- Translate business requirements into technical and functional documentation for SQL and ETL solutions.
- Design SSIS workflows to extract, transform, and load data from Excel and CSV sources into SQL Server data warehouses.
- Develop T-SQL stored procedures, functions, views, and SQL Server Agent jobs supporting data processing and reporting workflows.
- Build Power BI and Excel dashboards to monitor KPIs and SLAs on monthly and fortnightly reporting cycles.
- Perform data validation and reconciliation across ETL stages to identify data discrepancies and reporting errors.
- Automate recurring processing through scheduled SSIS packages and SQL Server Agent jobs, reducing manual intervention.
- Analyze and tune SQL queries using execution plans and indexing strategies for operational and ad-hoc reporting.
- Prepare technical design documents, data-flow diagrams, and ETL mapping documents.
- Work with AWS S3, Glue, Lambda, and Athena for data storage, transformation, and analytics.
1 Year 5 Months
05.2022 - 10.2023
1 Year 5 Months
SQL / SSIS Developer
ACCENTURE LIMITED
05.2022 - 10.2023
- Implemented business rules and data transformation logic using T-SQL, joins, and user-defined functions.
- Developed stored procedures and functions to support application integration and reporting requirements.
- Created SQL views and automation scripts to reduce manual effort and support repeatable data processing.
- Automated reporting workflows using Power BI, Power Automate, SQL, and Excel.
- Designed and maintained database tables, indexes, constraints, stored procedures, functions, and views.
- Developed SSIS workflows using For Loop, For Each Loop, Sequence Container, Execute SQL, Email, and Data Flow tasks.
- Performed database schema, functional, and non-functional testing for SQL and ETL changes.
2 Years 6 Months
11.2019 - 05.2022
2 Years 6 Months
SQL Developer
JUSTDIAL LIMITED
11.2019 - 05.2022
- Created and optimized SQL scripts for data processing, performance tuning, and job scheduling.
- Developed SSIS packages to load and transform Excel data into databases using Control Flow and Data Flow components.
- Prepared source-to-target specifications and technical documentation for data transformation requirements.
- Created and maintained tables, indexes, constraints, stored procedures, functions, and views to implement business rules.
- Performed post-load data validation and reconciliation to verify data consistency.
3 Years 1 Month
07.2016 - 08.2019
3 Years 1 Month
Engineer
INDUS TOWERS LIMITED
07.2016 - 08.2019
- Coordinated field and operations teams responsible for electrical and infrastructure support at telecom tower sites.
- Worked with field teams, vendors, and management to resolve issues and support SLA compliance.
- Prepared site performance reports, audit documents, and compliance records.
- Supervised installation, maintenance, and troubleshooting of DG sets, power distribution units, batteries, and UPS systems.
- Contributed to a cross-functional improvement initiative associated with a 50% increase in positive feedback and a 20% reduction in complaints.
Education
Bachelor of Technology (B.Tech) - Electrical and Electronics Engineering
JNTU Anantapur | 01.2016
Skills
SQL & Database Development: Microsoft SQL Server
T-SQL
complex queries
joins
subqueries
stored procedures
user-defined functions
views
ADDITIONAL INFORMATION
Location: India | Work preference: Remote | Open to distributed teams and cross-functional collaboration
Personal Information
Availability: Open to Remote Opportunities
Timeline
Senior Business Analyst
GENPACT LIMITED
10.2023 - CurrentRead more
SQL / SSIS Developer
ACCENTURE LIMITED
05.2022 - 10.2023Read more
SQL Developer
JUSTDIAL LIMITED
11.2019 - 05.2022Read more
Engineer
INDUS TOWERS LIMITED
07.2016 - 08.2019Read more
JNTU Anantapur - Bachelor of Technology (B.Tech), Electrical and Electronics Engineering
Read more