Data Analyst

Sreerag Yesodharan

***** ** **** ***** #***** Redmond, WA 98052 *.*******@*******.*** 425-***-****

Information Technology Data Analyst and Developer

Highly qualified IT System/Data analyst and developer with experience in a wide range of environments, including data analysis and client relations platforms. Motivated, energetic, and passionate about the most current technological developments. Committed to improving performance experiences for clients and internal teams. Serve on various projects and initiatives, saving costs where possible, and excited about developing new opportunities for client engagement. Flexible, with an aptitude for streamlining processes for greater efficiency. Thrives in fast-paced environments.

Outstanding 8+ year track record of successful experience in system/data analysis

Experience working with relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards.

Certified Professional in Power BI, Statistics analysis with R and Data Science Essentials.

Working experience in Power BI dashboard for Ecommerce teams at Microsoft.

Three-year specific background in Microsoft software licensing data analysis and trends.

Proficient in Microsoft technologies related to SQL BI tools (SSIS/SSRS), Power BI, MS Office/One-Note

Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.

Proficient in .NET C#, VB.NET and strong working knowledge on Visual studio, VSTS, BI Development

Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models

Received the Star Performer Award for business unit in Q4 of 2015-2016

Proven aptitude to use and administer large databases using analytical tools

Areas of Expertise

Stakeholder Management

Solution Analysis

Teamwork/Collaboration

Document Management

Data Analysis

Cost Savings Initiatives

Client Relationships

Microsoft Applications

Business Intelligence

Client Relationships

Excellent Communication

Cost Savings Initiatives

Professional Experience

PM/Lead Data Analyst Microsoft -Bellevue, Issaquah Feb 2015 - Present

oServed as the PM/Lead analyst for automation team, driving multiple high-impacting projects through agile model by facilitating Sprint Planning and Reviews, defining the user stories, prioritizing and communicating the status to the stakeholders

oSuccessfully led team to automate day-to-day operations reporting involving SQL and BI(SSIS/SSRS and Power BI) development, saving up to 260+ hours of manual efforts/month

oPerformed study on forecasts, demand of Azure Products for supporting the Ecommerce VL creation team using R and Power BI visualizations.

oDesigned and Deployment of SSRS Reports for the SWE team for monitoring VL tool performance.

oGenerated compliance and Audit framework using C# and Power BI reporting on SharePoint data, which led to timely Track of risks/issues, and current state of work to business partners and leadership team.

Data/System Analyst Microsoft - Redmond Jan 2013 – Jan 2015

oServed as solution/data analyst for volume licensing in quotation and agreements space worth $25B+ responsible for driving business critical requirements into Enterprise commerce tools.

oCreated use case diagrams to explain the flow of events and conducted statistical analysis as and when required and provided summaries of configurations to Business input.

oLead planning, design and implementation of Data Quality Audit and Data Enhancement Solutions which alerted several data issue instances saved approximately 150+ hours of incident management resolution.

oInvolved in analysis of massive and complex DATA validation by writing several complex SQL and R programming for data chart presentations and coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.

oTrained data analysis beginners to improve overall efficiency of team

Data Base Developer/Administrator Microsoft – Hyderabad, India April 2011 – Dec 2012

oWorked as Database developer to resolve several high-priority CPE issues; was involved in requirements analysis, functional spec preparation and solution documents for change requests on Partner learning analytics application data modeling and data warehouse.

oEnhanced .NET cookie decryption for partner authentication and regression dashboard tool using C#.

oInvolved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

oCreated automation test suite using MTM saving approximately 35 hours of testing for every release cycle.

Junior Database/BI Developer Microsoft – Hyderabad, India Dec 2008 – Mar 2011

oDeveloped key features, such as SQL Database Archiving and Replication, using SSIS for database performance and disaster recovery

oInvolved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.

oUsed SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.

oAssisted the deployment team to troubleshoot the deployment issues on production servers, and avoided extended downtime for the production go live.

Education

Bachelor of Technology (B.Tech.), Jawaharlal Lal Nehru Technological University

Hyderabad, India, 2008 Specialization: Electrical and Electronics

TECHNICAL SKILLS AND CERTIFICATIONS

Tools: Power BI, R Studio, Microsoft Azure Machine Learning Studio, Visual Studio, SQL Server (SSIS, SSRS), MS Excel, MS Power Point.

Databases: SQL Server 2012/2016.

Methodologies: OOAD, Agile, Business and Data Modeling.

Languages: R, C#, T-SQL, HTML.

Microsoft certified Volume License Domain certificate VL100 and VL 200

edX Verified Certificate for Data Science Orientation

edX Verified Certificate for Querying with Transact-SQL

edX Verified Certificate for Analyzing and Visualizing Data with Power BI

edX Verified Certificate for Statistical Thinking for Data Science and Analytics

edX Verified Certificate for Introduction to R for Data Science

edX Verified Certificate for Data Science Essential

Contact this candidate