Shwetha Ramesh
Senior Software Engineer at State Compensation Insurance Fund- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Developing ASP.NET MVC Web Applications (70-486)
Microsoft -
Developing Windows Azure and Web Services (70-487)
Microsoft -
Implementing Microsoft Azure Infrastructure Solutions (70-533)
Microsoft -
Programming in C# (70-483)
Microsoft -
Programming in HTML5 with JavaScript and CSS3 (70-480)
Microsoft -
Querying Microsoft SQL Server 2012 (70-461)
Microsoft
Experience
-
State Compensation Insurance Fund
-
United States
-
Insurance
-
700 & Above Employee
-
Senior Software Engineer
-
Jan 2019 - Present
Data modeling and ETL data pipeline - Building ETL data pipeline by consolidating various data sources across organizations, transforming data through SQL and SnowSQL, designing and building staging tables in Hadoop Data Lake and feeding accurate transformed data into core metrics dashboards. UDF and UDAF - Building UDF and UDAF in Hive to achieve complex logic in large datasets. Internal tools design - Built robust tools to automate the data import and export process between RDBMS and HDFS which eliminated 90% of the human errors. ETL Tools Development - Designed and developed a robust automated ETL pipeline to generate dashboards to provide key metrics reviewed by executives weekly. Front end development. Develop the User Interface of interactive reporting platform in HTML, CSS and Javascript using Knockout framework Show less
-
-
-
Accenture
-
Ireland
-
Business Consulting and Services
-
700 & Above Employee
-
Senior Software Engineer
-
Mar 2016 - Jun 2018
- Application Design - Enhanced applications for transacting thousands of daily insurance policies (New business, Amendments and Cancellation transactions), which reduced application-processing time from 5 hours to 2 hours.- Responsible for developing and deploying enterprise grade platforms that enable data-driven solutions. Provides technical expertise where required within Information Technology Projects.- Develop, test, and modify software to improve efficiency of data platforms and applications.- Designed and developed a data warehouse for partner services and analytics reporting using Snowflake and Hive. - Developed Java utility to automate the data import and export process between RDBMS and HDFS.- Developed Lucene indexing engine with Hive to perform faster data retrieval.- Production Support - Provided continuous operational support to existing systems and on-call support for critical issues. Show less
-
-
Software Engineer
-
Jan 2015 - Nov 2016
Client: Cisco Systems- Developed Hive queries along with generic UDF and UDAF to process large datasets.- Developed distributed caching mechanism to avoid small table joins, leading to 20% of reduction in query execution time.- Developed ETL functionalities using Hadoop technologies and data quality scripts to perform anomaly checks.
-
-
Associate Software Engineer
-
Jan 2014 - Mar 2015
Worked as a Java Developer - Designed & developed utilities using Java to support data engineering activities.- Developed ETL functionalities using Hadoop technologies for business executive reporting. - Analyzed business requirements and implemented the user stories as per the requirement.- Prepared unit, integration test cases performed extensive testing and validation of the application.
-
-
-
Accenture in India
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
Java Developer Intern
-
Jul 2013 - Dec 2013
- Involved in developing user interfaces using JavaScript and CSS. - Wrote JUnit/NG test cases to perform sanity check prior to production build - End-to-end tracking of tickets and escalating tickets to the appropriate resolver groups to restore normal service operations as quickly as possible. - Involved in developing user interfaces using JavaScript and CSS. - Wrote JUnit/NG test cases to perform sanity check prior to production build - End-to-end tracking of tickets and escalating tickets to the appropriate resolver groups to restore normal service operations as quickly as possible.
-
-
Education
-
2009 - 2013
B N M Institute of Technology, BANGALORE
Bachelor of Engineering - BE, Computer Science
Community
