Samson Podishetti
Software Developer
Hyderabad,TG
Summary
PROFESSIONAL SUMMERY: Overall 10+ years of experience with 7.5 years of IT experience. Experience with Snowflake Virtual Warehouses. Experience in Configuring Snowpipe. Experience in using Snowflake Clone and Time Travel. In-depth knowledge of Data Sharing in Snowflake. In-depth knowledge of Snowflake Database, Schema and Table structures. Familiar with integration of Snowflake with data visualization tools (Tableau/Power BI). Experience in developing SQL scripts and stored procedures that processes data from databases.
Overview
10
10
years of professional experience
Work History
Product Engineer/SR Technical Support Engineer
SumTotal Systems Inc
- Enterprise Learning Management System (ELMS, SME
- Project Description (ELMS):
- SumTotal Learn is the only enterprise learning management solution that connects the dots between the skills and competencies people need to be better at their jobs –delivered in the context of what they are trying to accomplish – and, prepare the organization for tomorrow, to measurably improve performance.
Senior Technical Support Engineer
ADP Pvt. Ltd
- On the core Learning Management Suite assisting
- Production Control and Analysis of Workflow
- Interacting with B2B Enterprise level clients on their requests through the Salesforce CRM and
- JIRA
- Working on various platforms and suites as below: SQL Server & SSIS development and maintenance (2008,2012,2014) to validate and manipulate data, resolving Data inconsistency and data corruption
- Optimize databases and its processes by applying indexes, Creating security, backup, and recovery specification
- Running Scripts and Stored Procedures to create efficient ETL processes T-Sql programming (stored procedures, functions, etc.,)
- Knowledge of Troubleshooting, Logging & Error handling mechanisms
- Knowledge on other RDMS & file type sources
- Dynamic approach and configuration
- Working on IIS with experience in
- Consulting or client service delivery experience
- Experience with private and public cloud architectures, pros/cons, and migration considerations
- Architectural exposure to Windows, VMware, Oracle, SQL Server, IIS Server and other technologies
- Server Operating Systems (e.g
- Microsoft Windows.)
- Virtualization Platforms (e.g
- VMWare)
- Cloud Computing and Storage (AWS)
- Cloud Management Platforms INFRASTRUCTURE PLATFORM Splunk SIEM Platform Management for querying of server logs Collaborate with the vendor and internal teams
- Document the cause and resolution of outages
- Manage application enhancements to improve performance and stability
- Along with Database domain working, the other areas of expertise include Web services (SOAP and Rest UI), Data Integration Extensive experience with Customer Triage calls and conference
- Manage customer escalations efficiently by creating war room discussions with required teams
- Mentor new team members and provide on job training where required.
Senior Software Engineer / Tech Lead
- Tech Mahindra India Pvt Ltd, Vertica DB
02.2022 - Current
- Responsible for End to End migration of data from Vertica to Azure Blob through a custom framework and then to Snowflake internal stage to Snowflake
- Created tables and views on snowflake as per the business needs
- Used COPY to bulk load the data
- Extracted Data from sources Data Files and migrated 1000 + database Tables and views from
- Vertica to Snowflake
- Created different tasks to automate the data loads
- Migrated mappings from Dev to Test and from Test to Prod
- Performed Unit testing and system testing
- Validating the data from Vertica to Snowflake to make sure it has Apple to Apple match
- Responsible in writing script for mapping different fields for Various File types like CSV, JSON, TAR,
- XML
- Created documents such as Source-to-Target Data mapping document, and Unit test case document
- Redesigned the Views in snowflake to increase the performance
- Evaluate Snowflake Design considerations for any changes
- Reviewed high-level design specification, ETL coding and mapping standards
- Created custom views for the client which will be used for reporting through BI Tools (Tableau and Power BI) based on Snowflake Connections
- Assigned work to my direct reports and scheduled sessions to provide KT and address any issues they encounter
- Created reports to share the status updates with client.
Product Engineer/SR Technical Support Engineer
Sum Total Systems Inc
11.2016 - 02.2022
- Project 2: Galaxy Data Mart - Subscription model, The purpose of the project is to migrate the data from Oracle to Snowflake ecosystem and create the new
- ETL jobs in Snowflake in order to process ETL jobs faster
- Calculating the TV Audience projection for large amount of data which will be ingested from Oracle to AWS S3 which will be consumed by the reporting teams
- Responsibilities:
- Data moved from Oracle to AWS S3 to Snowflake internal stage to Snowflake with copy options
- Created internal and external stage and transformed data during load
- Created Snowpipe for continuous data load
- Used COPY to bulk load the data
- Migrated 500 + database Tables and views from Oracle to Snowflake
- Created streams and tasks to identify Change Data Captures
- Validating the data from Oracle to Snowflake to make sure it has Apple to Apple match
- Created tables and views on snowflake as per the business needs
- Created data sharing between two snowflake accounts (Prod—Dev)
- Created data sharing out of snowflake with consumers
- Redesigned the Views in snowflake to increase the performance
- Used Temporary and Transient tables on diff datasets
- Time traveled to 56 days to recover missed data
- Created roles and access level privileges and taken care of Snowflake Admin Activity end to end
- Define roles, privileges required to access different database objects
- Define virtual warehouse sizing for Snowflake for different type of workloads
- Evaluate Snowflake Design considerations for any change in the application
- Helping to create Reports in Tableau and power BI based on Snowflake Connections
- Communicate with peers and supervisors routinely, document work, meetings, and decisions.
Associate Functional Consultant / Application Support
ADP L&P
02.2014 - 11.2016
- Description: ADP Reporting
- ADP Reporting is a tool developed by ADP for the clients to create or extract reports from the database (Enterprise, Payforce)
- My team will connect to the data base extract the data and validate the data in the reports for the client
- Responsibilities:
- Discuss Custom reports specifications with ADP's Payroll clients; analyze their technical reports and once the estimate is approved, create the reports in Crystal Reports and publish them in
- Infoview
- Modify existing custom reports as per client's requirements and post the modified reports in
- Infoview
- Creating complex reports as per Client's requirement
- Perform research on report data issues and
- SQL queries using SQL Developer and Toad
- Interacting with Clients / Business partners / internal users on multiple projects to create functional and technical documents for custom reports
- Creating /Deleting/Modifying different reports in Business Objects and Infoview
- ADP L&P iSucceed is a website developed by ADP for the associates to learn and take trainings associated to the team they are assigned
- Responsibilities:
- My role is that I am the ADMIN for iSucceed where I assign courses to the associates and provide them access as well
- I run reports of the clients/customers using SQL to get the data they need
- Move content on to the website from the Developers is also an extra task that I do on a day to day basis.
Associate
Hinduja Global solutions, EBOS
10.2012 - 01.2014
- EBOS is into Healthcare
- The employees must follow up on the health claims
- The data provided to them will be provided by my team
- Worked closely with the employees and found out trends to reduce the manpower and working hours.
Education
Bachelor’s -
B.COM - Computers
Kakatiya University
Master’s - Business Administration
Osmania University
Skills
TECHNICAL SKILLSCloud Technologies Snowflake, SnowpipeAWSDBMS Snowflake, SQL Server, MySQL, OracleReporting Systems SplunkProgramming Languages SQLOperating System WindowsIDEs IntelliJSupport Tools Siebel CRM, SalesforceHealthcare skills HIPAA, PHIHealthcare Tools Allscripts Interface Engine, Allscripts PM, Allscripts HER
Accomplishments
- Worked in a Business-to-Business Environment with US Healthcare Providers – Florida Hospitals
- Medical Group
- Job Role is to follow up on the claims (Accounts Receivables) from the US Insurance Companies both Federal and Commercial
- Worked as Back- End Process Administrator following the US Healthcare Guidelines
- Additional to Claims follow-up worked on refunds, denial management, Billing and Medical coding
- Company: - Deloitte Consulting
- September 2011 – October 2012
- Project 6: EBOS
- Role: Associate3
- Description:
- EBOS is into Healthcare
- The employees must follow up on the health claims
- The data provided to them will be provided by my team
- Worked closely with the employees and found out trends to reduce the manpower and working hours
- Responsibilities:
- Worked in a Business-to-Business Environment with US Healthcare Providers – Florida Hospitals
- Medical Group
- Job Role is to follow up on the claims (Accounts Receivables) from the US Insurance Companies both Federal and Commercial
- Worked as Back- End Process Administrator following the US Healthcare Guidelines
- Additional to Claims follow-up worked on refunds, denial management, Billing and Medical coding.
Additional Information
- Experience with REST API consumption using Postman. Understanding of various data formats such as CSV, PARQUET, JSON etc. Good knowledge of RDBMS topics, ability to write SQL Queries. Experience working in Snowflake database implementations. 2+ years of working experience on core LMS assisting Production Control and Analysis of Workflow. Modified query to increase report performance. Extremely worked with the Clients for requirements gathering and drafting those requirements. Hands on experience on JIRA, Splunk, Jasper soft, Salesforce, IIS servers, R12 reporting tool. Perform problem analysis (RCA) on business-critical applications based on issue reports from end users and share the analysis and resolution with stakeholders. Responsible for client satisfaction by ensuring that services are delivered according to agreed (SLA) and other contracts.
Timeline
Senior Software Engineer / Tech Lead
- Tech Mahindra India Pvt Ltd, Vertica DB
02.2022 - Current
Product Engineer/SR Technical Support Engineer
Sum Total Systems Inc
11.2016 - 02.2022
Associate Functional Consultant / Application Support
ADP L&P
02.2014 - 11.2016
Associate
Hinduja Global solutions, EBOS
10.2012 - 01.2014
Product Engineer/SR Technical Support Engineer
SumTotal Systems Inc
Senior Technical Support Engineer
ADP Pvt. Ltd
Bachelor’s -
B.COM - Computers
Kakatiya University
Master’s - Business Administration
Osmania University