Sumathi R
Senior Software Consultant
Chennai,TN
Summary
Looking forward to a position of software professional in a challenging working environment where there is possibility for perfection and an impetus to strive harder with complete perseverance to reach the ambitions of the organization and personal aims too.
Overview
8
8
years of professional experience
Work History
Software Engineer
ADF Data Science Pvt ltd
08.2016 - 08.2017
- Generated the reports using MySQL and Python, based on data requests from other teams.
- Portfolio monitoring of process flow and business analysis.
- Handling technical issues in process flow and data.
- Monitored the performance of the database and checked the execution time.
- Gathered business requirements and converted them into SQL stored procedures for database-specific projects.
- Created files, views, tables, and data sets to support operations and Analytics teams.
- Researched and resolved data issues related to existing data and processes in place before my tenure.
- Created and scheduled SQL Agent jobs and maintenance plans.
- Troubleshoot for various anomalies in applications, loan volume, and systems in general.
- Setting up alerts (using MySQL and Python) to find the bugs and escalation mechanism.
- Building data architecture, data modeling, data mart using ETL tool.
- Proactively automate various processes for seamless operations.
- Performance tuning is performed at the Mapping level, as well as the Database level, to increase the data throughput.
Software Engineer
Agile Business Intelligence Service Pvt Ltd
03.2018 - 11.2019
- Implemented one PADB command, which is unique to Redshift.
- Improve data COPY/MOVE efficiency by up to 50x (Transferring million records in 40 secs).
- Helped develop and fully test Interleaved sort key, a new sort algorithm that helps customers quickly filter data in a Redshift cluster.
- Gained tremendous experience in MPP, Columnar Storage, Data Compression, and Query Optimization.
- Worked independently on designing, developing, deploying, and monitoring pipelines to process a large amount of data directly in Redshift using Copy commands from S3 for faster processing.
- Utilized Amazon S3 as the main storage for loading files.
- Developed auditing and error handling mechanism that stores data in a relational database.
- Collaborated directly with QA and other teams to identify issues and resolve them in a timely manner.
- Participated in biweekly stand-up meetings to report progress and receive new tasks.
- Documented projects and debugging instructions according to company standards.
- Developed new challenging concepts and achieved positive results in various technologies like AWS Lambda, Redshift, SnapLogic ETL, and Python.
Senior Software Consultant
Deloitte Shared Services India LLP
11.2019 - Current
- Preparing the database scripts for DB objects and executing them in AWS Redshift. Involved in gathering the requirements from the business.
- Analyze and Tune the Redshift database objects by making use of different performance techniques, such as distribution keys, sort keys, and encoding techniques, according to the table requirements.
- Created parameter files and Python scripts for operations like file validation, report generation, data cleansing, and file processing.
- Developed many automated jobs using Python scripting to reduce manual work and increase data accuracy.
- Developed a Python script to find the unmatched records between two different DBs (Redshift and Postgres).
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Mentored newer team members by sharing extensive technical expertise, contributing to a supportive work environment that encouraged growth and learning.
Education
B.E(ECE) -
S.K.R Engineering College
12th -
AKT Academy Matric Hr Sec School
10th - undefined
St Micheal’s Hr Sec School
Skills
AWS Redshift, SQL , SparkSQL
Technicalskills
Very Strong at query optimization and Performance tuning, Bulk data load and unload to S3 and Redshift., Integrate Python with Redshift for complex data integration., Other AWS Service—AWS Lambda, AWS CloudWatch, S3, glue, Kinesis Stream, Kinesis Analytics., Good at python scripting for automation process., Determined optimal business logic implementations, applying best design patterns., Increased speed and memory efficiency by implementing code migration to convert Informatica ETL jobs to SnapLogic ETL jobs., Good at working with Spark for large scalable distributed data solutions., Strong knowledge in writing stored procedures, functions and views., Good in writing and tuning complex sub queries, index, and triggers., Strong knowledge in MySQL and query optimization., Debugging., Good at optimizing SQL Server performance., Good at join concepts and T-SQL functions, Good knowledge of the design and implementation of the Data Warehouse life cycle., Good in multidimensional modelling (star schema, snowflake schema)., Good knowledge of Data Warehouse/Data Mart design concepts., Good hands-on working experience with SnapLogic ETL Tool.
Disclaimer
I hereby declare that all the above information is true, correct and complete to the best of my knowledge and belief. I assure you, if I selected, I shall do my duties with utmost Satisfaction of my superiors.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Accomplishments
- Collaborated with team of 6 in the development of Caterpillar Migration Project.
Languages
English
Advanced (C1)
Tamil
Bilingual or Proficient (C2)
Work Preference
Work Type
Full TimeWork Location
HybridImportant To Me
Paid sick leaveWork from home optionPaid time offFlexible work hoursCompany CultureWork-life balanceHealthcare benefitsPersonal development programsCareer advancementTeam Building / Company RetreatsStock Options / Equity / Profit SharingTimeline
Senior Software Consultant
Deloitte Shared Services India LLP
11.2019 - Current
Software Engineer
Agile Business Intelligence Service Pvt Ltd
03.2018 - 11.2019
Software Engineer
ADF Data Science Pvt ltd
08.2016 - 08.2017
B.E(ECE) -
S.K.R Engineering College
12th -
AKT Academy Matric Hr Sec School
10th - undefined
St Micheal’s Hr Sec School
Similar Profiles
Nidhishree Nidhishree null
Process Lead at ADF Data Science Pvt. Ltd.Process Lead at ADF Data Science Pvt. Ltd.
DhileepKumar PalanisamyDhileepKumar Palanisamy
Principal Software Developer (Devops) at NSM Services Pvt Ltd (Mr.Cooper)Principal Software Developer (Devops) at NSM Services Pvt Ltd (Mr.Cooper)
Shashikanthraddy PatilShashikanthraddy Patil
Medical Data Abstractor at OM1 Data Science Pvt LtdMedical Data Abstractor at OM1 Data Science Pvt Ltd