Sql Server Software Engineer

Satish Matukumilli

(Database Developer & Analytics-ETL)

************@*****.***

PH.: +91-929*******

Senior Software Engineer – Database& Analytics

Senior Software engineer having 13 years of experience with very good technical and functional knowledge along with team working skills for database development in MS SQL Server 2005, 2008 R2, 2012, 2014, 2016 versions, PostgreSQL, Hands on Analytics - ETL Designee,Amazon Redshift and Performance Tuning and Certified Azure Cloud Fundamentals.

Summary

Sound knowledge in analysis, development of database SQL, T-SQL queries. Expert in developing database objects in SQL Server 2005, 2008 R2, 2012, 2014, 2016.

Extensive experience in SQL Server Database development and Master Data maintenance, developing T-SQL queries, stored procedures, Functions, SQL Backend Jobs and Expert to write user defined functions of own tools like utilities and well knowledge in design, database objects and entities like creating tables, indexes, triggers, views based on client requirement with global thinking and future usage prospective.

Hands in fine tuning of T-SQL Queries, Performance tuning using and optimizing T-SQL queries using Query Execution Plans and SQL Profiler.

Good hands-on in data loads from one database structure to another different database structure in SQL Server database and expert in Data Migration in MS SQL server.

Hands on Production deployments and maintenance and production support.

Hands on experience in Requirement gathering, analysis and writing technical specifications.

Hands in developing reports using SSRS tool.

Creating SSIS Packages.

Expert in Problem Solving in Client Productions and hands in solving the production related issues with high priority & hands-on in overcoming the deadlocks using concurrency testing.

An Excellent team player with problem solving and troubleshooting capabilities and Effective in working independently and collaboratively in teams.

Very proactive in learning and leveraging emerging technologies. Mentored engineers; believe in leading by doing.

Hands on Performance tuning and index optimization, normalization, and de-normalization.

Hands on Data Analytics and Python

Knowledge and hands on PostgreSQL development.

Knowledge in different domains like E Tolling, Telecom, Finance, Wellness & Spa, Data Analytics and Gas and Power Analytics.

Educational Summary

MBA (Distance) from Andhra University with an aggregate of 72%.

MCA from University of Mysore with an aggregate of 73%.

BSC (MPE) from Andhra University with an aggregate of 74%.

Intermediate from Board of intermediate with an aggregate of 72%.

SSC from Board of school of secondary education with an aggregate of 73%.

Technical Skills

Operating Systems

Dos, Windows NT, Windows 95/98,Windows 2000 rofessional,XP,2008,2010

Packages

MS-Office, Open Office, LibreOffice

RDBMS

MS SQL Server 2005, 2008 R2, 2012,2014, 2016, SSRS, PostgreSQL, Redshift

Build Tools

Team City, New relic, Beyond Compare, Win Merge, Erwin, Redgate, Python

Version Control

Tortoise SVN, TFS (Team foundation server), Jira, VersionOne, Git

SDLC

Agile model, Waterfall model

Professional Experience

Project #

1

Project Domain

Banking

Project Name:

ATHENA ( Commercial Loan Process )

Client

US and UK Based Customers

Role

SENIOR SOFTWARE ENGINEER

Organization

Wells Fargo

Description:

Wells Fargo is an American multinational financial services company with provides all kind of banking needs like Loans, Investment offers, Saving Schemes, Insurance etc.

Wells Fargo Provides Investment products and services are offered through Wells Fargo Advisors.

ATHENA is the one of the application in Wells Fargo to providing The Commercial loans to the Customers in the US Market.

Roles & Responsibilities:

Requirement and impact of Business analysis and write story board as per requirement.

Ability to support the change requests as defined by the new regulations Education.

Creation and Maintenance of Database Objects like writing T-SQL Commands, stored procedures for managing the Master Data and data loads.

Focus on daily based deliverables using daily scrum meeting.

Involve in coding in database objects in development, integration, QA, UAT, production.

Supporting to QA team to move DB related changes and fixes.

Performance fixes to improve the query execution time.

Project #

2

Project Domain

Global Gas Data Analytics

Project Name:

LNG and EU GAS

Client

LNG

Role

SENIOR SQL DEVELOPER

Organization

S&P Global

Description:

S&P Global, a leading Data analytics business management software used by LNG globally, and web-based business Market intelligence, Ratings, Platts.

S&P Global provides a suite of integrated business intelligence solutions including powerful analytics, advanced reporting and market intelligence, ratings, global gas, petrochemical, Finance, commodities for across the global businesses. We provide key customer information in intuitive, interactive dashboards, helping independent businesses identify the best opportunities to improve their bottom line.

Roles & Responsibilities:

Requirement and impact of Business analysis and write story board as per requirement.

Ability to support the change requests as defined by the new regulations Education.

Creation and Maintenance of Database Objects like writing T-SQL Commands, stored procedures for managing the Master Data and data loads.

Focus on daily based deliverables using daily scrum meeting.

Involve in coding in database objects in development, integration, QA, UAT, production.

Supporting to QA team to move DB related changes and fixes.

Performance fixes to improve the query execution time.

Project #

3

Project Domain

Manage spa, salons, massage centers

Project Name:

Manage my spa

Client

Enrich, Kaya, Tips and Toes, Massage Heights, etc

Role

Senior Database Developer and Performance tuning and Data Analytics

Organization

Zenoti

Description:

Zenoti, leading SASS business management software used by salons, spas and med spas globally, today announced that Douglas J, a highly successful and reputable salon chain, has chosen Zenoti to replace its current technology solutions. Douglas J will use Zenoti to manage its three salon locations and six Douglas J Aveda training institutes.

Roles & Responsibilities:

Requirement and impact of Business analysis and write story board as per requirement.

Ability to support the change requests as defined by the new regulations Education.

Creation and Maintenance of Database Objects like writing T-SQL Commands, stored procedures for managing the Master Data and data loads.

Focus on daily based deliverables using daily scrum meeting.

Involve in coding in database objects in development, integration, QA, UAT, production.

Auto deployment of Database scripts to PROD environment and Support.

Supporting to QA team to move DB related changes and fixes.

Performances fix to improve the query execution time.

Project #

4

Project Domain

Advanced Reporting

Project Name:

Acsellerate

Client

ECI Software Solutions

Role

Senior Database Developer and Performance tuning

Organization

Ascendia

Description:

Ascendia, leading Sales force business management software used by ECI Acsellerate globally, and ECI Acsellerate web-based business intelligence and CRM.

ECI Acsellerate provides a suite of integrated business intelligence solutions including powerful analytics, advanced reporting and integrated CRM for European businesses. We provide key customer information in intuitive, interactive dashboards, helping independent businesses identify the best opportunities to improve their bottom line.

Roles & Responsibilities:

Requirement and impact of Business analysis and write story board as per requirement.

Ability to support the change requests as defined by the new regulations Education.

Creation and Maintenance of Database Objects like writing T-SQL Commands, stored procedures for managing the Master Data and data loads.

Focus on daily based deliverables using daily scrum meeting.

Involve in coding in database objects in development, integration, qa, uat, production.

Auto deployment of Database scripts to PROD environment and Support.

Supporting to QA team to move DB related changes and fixes.

Performance fixes to improve the query execution time.

Project #

5

Project Domain

Cell Tower Site Share Assets Management

Project Name:

ATC

Client

American Tower Corporation

Role

Database Developer

Organization

TARANTULA.NET

Description:

As per cell tower companies’ requirement Tarantula.net is provide cell tower site share and asset management specifically developed to meet the tower companies needs of the global market. The solution provides the following capabilities.

Cell tower Site Share and asset management is one of the tower asset Management systems for ATC. To Create Low-cost highly efficient asset and site share management that increases the tower company and customer convenience. Tarantula.net would be making the interoperable such that it can be used across multiple cell site share and asset collection. Tarantula.net having several clients in India and other countries there are VIOM Networks, American Tower Corporation, telecom, Wind, Chorus, Airwave, INDUS Towers, Vertical, HTA, Indosat, Telesonica, e.co, Motorola;:

Roles & Responsibilities:

Offers national and worldwide cell tower site share and assets management including support.

Tower Companies enroll with "Site Share Management", which owns and manages rollout/colocation/upgrade process of cell towers.

One site works based on capacity and signal strength and network connections everywhere-establishing national interoperability-a goal of cell tower company industry and TRAI.

Requirement and impact of Business analysis and write story board as per requirement.

Ability to support the change requests as defined by the new regulations Education.

Creation and Maintenance of Database Objects like writing T-SQL Commands, stored procedures for managing the Master Data and data loads.

Focus on daily based deliverables using daily scrum meeting.

Involve in coding in database objects in Dev, Integration, QA, UAT and Production.

Auto deployment of Database scripts to PROD environment and Support.

Supporting to QA team to move DB related changes and fixes.

Project #

6

Project Domain

AUTOMATE TOLL PLAZA SYSTEM

Project Name:

CEBA

Client

ICICI-Bank

Role

Database Developer

Organization

TOLLPLUS

Description:

As per client ICICI requirement Toll Plus is migrate Toll Product customer account level to vehicle tag account level has been specifically developed to meet the tolling needs of the India market. The solution provides the following capabilities.

I-Toll is one of the Indian Toll Management systems for ICICI. To Create Low-cost highly efficient toll management that increases the customer convenience. ICICI Bank would be making the tag interoperable such that it can be used across multiple toll collection plazas. The Bank would act as a Central Clearing House (CCH) for settlement of financial transactions of the toll agencies and update the Tag account status of road users. This will help minimize the toll operators operating cost and offer them better control through centralized user accounts. Additionally, the Government will benefit through improved transparency on toll transactions and reduced revenue leakages. Following are the major modules in CEBA:

Customer Service Center

Inventory Management Center

Report Processing Center

Problem Management Center

Finance Management Center

Image Processing Center

Audit Control Center

Concessionaire Center

System Administration Center

Roles & Responsibilities:

Requirement and impact analysis and Ability to process the toll violations as defined by the new regulations Education

Creation and Maintenance of DB Objects.

Writing T-SQL Commands, stored procedures for managing the Master Data.

Auto deployment of DB to PROD environment and Support.

Migrating customer account level Database structure data to vehicle tag account level with out 0 errors and without second person involved.

Supporting to QA team to move DB related changes and fixes.

Production support and Releases.

Academic Project

Project Name:

E-Learning

Organization:

Nanomindz Technologies, Visakhapatnam

Location

Offshore: Visakhapatnam

Onsite: NA

Duration

May 2010 – Nov 2010

Onsite: NA

Environment

Database :

SQL SERVER 2008

Description:

E-Learning is basically as content driven site where trainers involve in uploading the content, list learning objectives and time allocation for the training. The uploaded content can be downloaded and used by trainee for reading and knowledge up gradation and to minimize complexity in understanding, analyzing a topic or subject, memorize and reproduce.

Trainers and learners both can save their version of document with all the changes for their future purposes in their respective logins. Learners have a provision to save learning cards for quick reference at any point of time. E-Learning site provides search options to search subject wise topics, books, learning cards and content within the site or from other sites.

Roles & Responsibilities:

Developed dynamic web pages using Asp and Html, CSS.

Written Data Access Layer, Business Access Layer.

Store and fetching Data from database using ADO.net.

Written Sql queries for Bandwidth, Internet Access, Minutes and Search modules.

Written Client Side Validation Scripts using Java Script.

Create tables and Written Procedures, Functions, Views.

Personal Details

Name: Satish Matukumilli

Email: ************@*****.***

Phone: +91-929*******

Father Name: Atchyuta Ramayya

Mother Name: Veerabadhram

Date of Birth: 10-05-1987

Marital status: Married

Languages known: English, Telugu, Hindi

Present Address: Hyderabad

Contact this candidate