Data Sql Server

ABHISHEK RAMAMURTHY PUGAZHENDI

: 815-***-**** : ************@*****.***

*** ****** **, *** *, Dekalb, IL

PROFILE SUMMARY

Talented and technically sophisticated business/data analyst with extensive 2+ years experience in eliciting business requirements, database development, database administration, reporting, developing client and vendor relations, managing multiple software applications, and IT Project development. Known for excellent troubleshooting skills and ability to analyze data and engineer well-researched, cost-effective, and responsive solutions. Dedicated to continuously discovering, evaluating, and implementing new technologies to maximize development efficiency. Possess confidence, enthusiasm, excellent communication, and time management skills.

core competencies

Database Development ● Data Analytics and Reporting ● Data migration

Database Administration ● Data Warehousing ● Customer Satisfaction

Business Intelligence Reporting ● Data Mining ● Team Building

Data Modeling ● Testing/QA/Rollout/Support ● IT Project Management

AREAS OF HIGHLIGHTS

Extensive MS SQL programming experience for items such as Stored Procedures, input/output of data sets for use in flat files, and various other systems.

Grounded in the development and implementation of process change/improvement strategies for gathering, compiling and sourcing of data via MS SQL databases, Data Modeling, Analyzing Data, Coding and Database, and Inferential Statistics

Effective relationship building across multiple organizational levels and divisions to help achieve data modeling of specific data asked from both end users and corporate executives.

technical skills

Languages / Scripts: C, .NET, VB Script, HTML 5,CSS 3,XML Database/ETL Tools: MS Access, MYSQL, SQL Server, SSAS, SSIS, and SSRS.

Informatica Tools: Microsoft BI, SQl Server Management Studio, Visual Studio, IBM Datastage, Visio

Applications: MS Excel (Macros, Pivot Tables, Solver, VLOOKUP), MS PowerPoint, Ms Project

professional experience

Business Data Analyst September 2015 - August 2016

VERIZON

Notable Achievements:

Spearheaded the loading, extraction, cleansing, processing, and validation of client data.

Successfully developed mappings in Microsoft SQL Server 2016 to load data from different sources into the data warehouse using different transformations like Source Qualifier, Aggregator, Router, Joiner and Update strategy.

Efficiently developed visualizations and interactive reports utilizing SSAS based on requirements.

Created dimensional model (cube) and tabular model (power pivot). Experienced in writing DAX and MDX queries.

Performed Drill analysis, sliced & diced on data, and generated Dashboards using SQL Server.

Oversaw the developing of stored procedures, triggers, functions, joins, and views using SQL Server.

Automated iterating tasks using macros in MS Excel reducing manual effort and increasing productivity.

Data Engineer December 2013 – August 2015

SITEL

Notable Achievements:

Participated fully on a Project Management Application which has helped create optimized plans for projects focusing on managing various complexities such as cost, time, dependencies, and priorities across departments.

Successfully developed Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, SequenceDiagrams, Component Diagrams, Data Flow Diagrams, and Flow Charts using MS Visio.

Carried out Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Performed Data mapping, logical data modeling, created E-R Diagrams and utilized SQL queries to filter data.

Worked on Master Data Management for Standardizing data from different sources.

Worked on troubleshooting the build, deployment activities by providing technical assistance to team members using SQL Creating Master-pages and Page-layouts in SharePoint 2007 and 2013.

Abhishek R. Pugazhendi 815-***-**** ************@*****.***

EDUCATION

Northern Illinois University, Illinois 2016 - 2017

Master of Science in Management Information System (GPA 3.4)

ACADEMIC PROJECTS

Data Analytics using SQL Server October 2015 – January 2016

Created and maintained a data warehouse for a recruiter sample dataset in SQL Server and generated ad-hoc reports according to the requirements using SQL Server Reporting Services (SSRS).

Data Analysis Project (Google Analytics) October 2016 – December 2016

Used PowerBI to create a Google Analytics dashboard to analyze website views and traffic. Created dashboards based on region and timezone.

REFERENCES

Available Upon Request

Contact this candidate