Synopsis: *+ years of experience in developing complex TSQL queries, ETL packages and Reports using MSBI Visual studio tools. Expertise advanced analytics with hands-on Big-data, Python, Power BI applications and Snowflake, Azure platforms. Subject matter expert in US, UK health care, Manufacturing, Life Science and Aviation domains.
EXPERIENCE SUMMARY
Hands-on cognition in MS-Azure and Snowflake cloud data platforms
Extensive experience in TSQL, SSIS, SSRS, and SSAS.
Experience in ETL design, execution and report building on huge data.
Well acquainted with Software Development Life Cycle and Software Testing Life Cycle.
Strong fundamental knowledge in conventional and cloud ELT process.
Experience in fine tuning and optimizing complex queries and store-procedures.
Flexible enough to adapt new technologies and environments.
Good at understanding the data and extracting insights from structured and semi-structured data.
Involved in client engagement, testing, technical documentation and go-live processes.
Work experience as an Information Security audit coordinator.
ACADEMIC QUALIFICATION
Highest Degrees
Institute
Year
% Secured
MBA (HR and Marketing)
S V University, Tirupati
2015
69.3
Master of Technology
(Digital Elec. and Comm. System)
JNTU - A, Ananthapuram
2013
82.5
Bachelor of Technology
(Electronics and Comm. Engg.)
JNTU - A,
Ananthapuram
2010
65.3
Intermediate (10+2)
BIE, Andhra Pradesh
2006
84.0
Secondary School Certificate (10th)
Board of Secondary School, A.P
2004
84.0
CERTIFICATION
Snowflake Hands On Essesntials – Web User Interface certification in 2020.
Dot-Net and MS-SQL server training certification at Naresh Technologies in 2010.
WORK EXPERIENCE:
Organization Name
Location
Designation
Service Period
Hexaware Technologies Limited
Chennai
System Analyst / Module Lead
July 2019 – Till Date
EXL Service, SCIOinspire Consulting Services Pvt. Ltd.
Chennai
Senior Programmer Analyst
Apr. 2017 – July 2019
Tata Consultancy Services Limited
Chennai
Senior Process Associate
Mar. 2015 – Mar. 2017
School of Engineering & Technology, SPMVV
Tirupati
Academic Consultant
June 2013 – May 2014
Data Genic Private Limited
Bangalore
Associate Software Engineer
Jan. 2011 – Nov. 2011
PROJECTS HANDLED AT HEXAWARE TECHNOLOGIES LTD.
Project 1: Freeport McMoRan Inc., American Concentration; Driver Safety and BridgeStone Tire Management Systems
Domain
: Manufacturing & Consumer
Role
: Module Lead
Environment
: MS-Azure, T-SQL, Snowflake Cloud DB.
Duration
: October 2019 to May 2020.
Tools Used
: Python, MS-Azure Databricks, Teradata 15.1, Snowflake and PostMan
Description: The customer is a mining business player, who has multiple sites to extract and supply metals like Copper and Molybdenum. We receive multiple data sources which need to be feed into RDBMS using ETL and perform analytics. Data modeled in DWH as per client requirement. Design analytics to run on Power BI and SAP BO reports on top of the processed data to find the trends at site.
Roles and Responsibilities:
Migrating conventional ETL process to advanced Cloud ELT process
Identifying room for optimization and development.
Developing python scripts to perform advanced analytics.
Executing the Pyspark scripts to feed API data into RDBMS.
Reporting to the project coordinator about the status of the development progress daily.
Interacting with the clients and resolving the issues.
Information Security audit coordinator.
Project 2: Indigo, Migrating aviation and cargo ETL process to advanced level.
Domain
: Global Travel & Transport
Role
: Team Member
Environment
: MSBI, Power BI, My SQL, Windows 2010
Duration
: July 2019 to Sep 2019.
Tools Used
: Visual Studio 2018, SSMS 2019 and Power BI
Description: The customer is an Indian domestic aviation firm involved in the passenger travel and cargo services. They were able to provide transport and travel service to their customers globally. The data need to be feed into RDBMS using ETL and modeled in DWH star schema as per client requirement. Designing cubes to run Power BI reports and to fetch insights of the trends from the data source provided.
Roles and Responsibilities:
Understanding the client requirements by studying functional document.
Review of the Scripts and suggesting modification in the scripts.
Developing SQL SPs, SSIS packages to perform ETL on data source.
Executing the scripts and packages to feed given data into RDBMS.
Reporting to the project coordinator about the status of the development progress daily.
Interacting with the onsite people and resolving the offshore issues.
Attended daily status meetings and provide detailed status report to the project management.
PROJECTS HANDLED IN PREVIOUS COMPANIES.
Company Name
: EXL Service formerly SCIOinspire Consulting Services.
Project Name
: Humana and UHC Eden Migration
Role
: Team Member
Environment
: SSMS, SAS, Hadoop Hortonworks, Windows
Duration
: Jan 2018 to June 2019.
Tools Used
: Anaconda Python, HiveQL, Zeppelin and MS 2012 server R2
Description: The objective of the project is to bring the entire health care data from different sources to one repository using Big Data - Hadoop and perform advanced analytics to generate more revenue from false and abused claims using Report Optimization mechanism. Migration of codes from SQL to SAS and HiveQL also while converting fixing the legacy logic to generate more Hit rate for optimum revenue.
Role and responsibilities:
Interacting with the clients and senior management to gather requirements and preparing required flows and documentation for development.
Migrating current logic from SQL and SAS using Ambari Hive & Zeppelin for over paid claims selection using advanced tools like Hadoop.
Process Orchestration of the developed process to mitigate human intervention.
Providing brisk training to the team to cope with the project deadlines.
Proposing new thoughts to the management for more revenue generation by analyzing data trends using Tableau.
Company Name
: EXL Service formerly SCIOinspire Consulting Services.
Project Name
: Novartis life sciences Data Intelligence.
Role
: Team Member
Environment
: My SQL, Windows 2007, Azure server, O365
Duration
: Apr 2017 to Dec 2017.
Tools Used
: SSIS, SSRS, SSAS, TSQL, SSMS 2014
Description: The main objective of this initiative is to provide life sciences business revenue details to the field managers to apply incentives to the top performers in the sales department.
Based on product sales per territory the revenue will be calculated, and incentives provided to the team.
Role and Responsibilities:
Involved in developing SSIS packages, SSRS reports and cubes using SSAS.
Deploying developed packages and reports in the Azure server and maintaining the application
KT sessions to team members on application functionality.
Role level report development and controlling.
Interacting with clients for gathering new requirements and updating them on status of project progress on weekly basis.
Company Name
: Tata Consultancy Services Limited.
Project
: Vitality Health
Environment
: Windows SSMS, Visual Studio
Software
: Oracle 11g, SSMS, Visual Studio
Role
: Team Member
Duration
: Mar 2015 to March 2017
Description: Vitality Health is a Healthcare Insurance incentive system, which identify customers who adhere to their good habits and the threat from the customers who will be willful expenses to the company by unhealthy habits. Source of data would be CSV, Excel and Flat files placed in FTP server. Using ETL and reporting mechanisms the objective of the project would be executed.
Role and Responsibilities:
Involved in maintaining MSBI application and taking data backup in critical scenarios.
Interacting with clients for gathering new requirements and updating them on status of project progress.
Optimizing the reports and queries for faster results.
Implementing CRs based on customer requirement.
Company Name
: Data Genic Pvt. Ltd., Bangalore
Product Name
: Data Genic
Role
: Team Member
Environment
: Oracle
Duration
: Jan 2011 to November 2011.
Description: DATA GENIC is a Product that takes feeds from different energy data sources to build the trends of energy share market.
Role and Responsibilities:
Developed and executed ETL packages
Involved optimum maintenance of the application.
Generated reports and analyzing the trends of data for various clients.
ACHIEVEMENTS:
Star performer award at TCS for the contribution & being role model to other team members.
Acquired opportunity to work at VESTAS, Chennai as an award for winning 1st Prize at seminar.
Published technical papers in National and International Journals. Participated in technical workshops organized by prestigious institutes like IIT Bombay.
Projects experience at National Atmospheric Research Laboratory (a branch of ISRO, India) as an academic opportunity.
PERSONAL PROFILE:
Full name
: Melpakam Sudhakar Sasidhar
Date of Birth
: 20th January 1988.
Gender & Age
: Male, 32 Years
Nationality
: Indian
Marital status
: Married
Languages
: English, Hindi, Telugu and Tamil.
Passport number
: R9125212
PAN number
: AUEPM9349Q
UAN number
Aadhar number
Areas of Experience
Industries
Health Care & Insurance, Aviation, Share Market, Manufacturing and Consumer, Life Sciences
Applications
Pycharm, Anaconda
Hadoop (Hive & Zeppelin)
Azure Databricks, Snowflake,
MSBI (IS, RS & AS)
MS Power BI.
Cloud computing
Microsoft Azure, Snowflake Cloud DB
RDBMS
MS SQL Server 2019
Oracle 11g
Teradata 15.1