Surya Kiran
Sr. Manager
About
Performance-driven data analytics professional with over 20 years of rich and extensive experience in Supply Chain Analytics, Data Operations and Data Analysis. Expertise in Data onboarding, ETL/ ELT using various tools like Alteryx, Matillion, SQL server, Redshift, etc. Keen interest in managing complex analytics projects and insights generation by merging a variety of data sources. Operations Specialist with excellence in gathering and understanding requirements of clients to understand As-Is process and develop solutions for To-Be process. Forward-focused Project Executor with exposure in swiftly executing projects with competent cross-functional skills and ensuring on-time deliverables within pre-set cost parameters. Gathering and analyzing business requirements to create technical specifications such as source to target mapping and data modeling. Designed and implemented Matillion and Redshift based ETL/ELT data pipelines using SQL stored procedures, dynamic SQL, CTEs, window functions, data cleansing/validation, incremental loading, duplicate handling, SCD Type 2, audit/error frameworks, and performance optimization.
Skills & Expertise (20)
Work Experience
Sr. Manager
Levadata Software Solutions Pvt Ltd
Jul 2018 - Present
Spearheaded several operations including SLAs Management (Service Level Agreement), and TAT Adherence. Defined standards & guidelines, governance structure, best practices that worked as benchmark for excellent client satisfaction. Customer onboarding for Pre-Sales prospects and new client implementation on the Levadata cognitive sourcing platform. Automated data onboarding operations like Data Cleaning / Transformations / Loads using Matillion ELT, AWS-Redshift DB, Alteryx data wrangling, SQL Server, advanced Excel/Access tools, data sync between multiple platforms/databases.
Lead Report Developer
C3i Solutions (an HCL Technologies Limited company)
Aug 2015 - Jun 2018
Providing solutions for new client implementations on data onboarding and reporting solutions and Dashboards. Maintenance of existing dashboards/reports using Excel, Access, SSRS and Power BI. Responsibilities includes data cleansing and transformation, data consolidations and data merging, data loads into target as SQL server database from various applications/inputs (flat files, csv files and access tables, etc). Managing team to achieve business objectives, PTO management, mentoring the team on technical aspects and team building activities.
Manager
Karvy Data Management Services Limited
May 2014 - Aug 2015
Team Management to achieve business objectives (quality and timely delivery). Understand Client products, internal tools and processes and leverage work efficiency based on solid data analysis. Translate analysis to actionable business insights by reports and presentations. Report development using Excel and VBA with SQL Server, Dashboards, Adhoc Reporting. Tool Development using Excel Forms and VBA for Banking and Finance domain (ECS Mandates for RBI process and NACH XML output formats).
Manager
C3i Support Services Private Limited (an HCL Technologies Limited company)
Jul 2006 - Apr 2014
Managed back-office and reporting functions in IT Service Management domain. Developed and maintained Business Objects Crystal Reports XI and Excel Dashboards. Utilized SQL Server, Oracle TOAD, and Access for database management.
Education
B.Com Computer Applications - Osmania University
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (20)
Click a skill to find developers with the same skill
