Sql Server Data

Sharath, Sr. BI Developer

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

Phone: 309-***-****

* *** ** ** ********** as an SQL BI (MSBI) developer with good analytical skills and experience in all the phases of Software Development Life Cycle (SDLC) including requirements, analysis, design, implementation, integration and testing, deployment and maintenance

Professional Summary:

Experience in excellent end user interaction, business requirement analysis, capacity planning, preparing the estimations and timelines of the projects and deliverables.

Experience working as an onsite coordinator and team lead.

Excellent data analysis skills using Advanced Excel, Power Pivots and various reporting tools.

Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Extensive experience with SQL development with strong knowledge in RDBMS and T-SQL concepts.

Extensive experience in SQL Server 2014/2012/2008/2005 and database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Experience in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, Excel files, legacy systems and loading into SQL server

Expertise working on various tasks within an SSIS package like sequence container, for loop, for each loop container, SQL tasks, files system tasks, script tasks and data flow tasks etc.

Experienced in performing various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.

Experience working with SQL reporting services (SSRS) reports like linked reports, sub-reports, tabular reports, charts, matrix reports and parameterized & cascading parameterized reports.

Expertise in creating SSAS Tabular Models for multidimensional data analysis and Power views for performance reporting.

Experienced in developing and deploying the Cubes using SQL server Analysis Services (SSAS).

Experienced in fine tuning and improving performance on an SSAS Cube.

Developed MDX Scripts and created datasets to perform reporting like interactive drill down reports and dashboard reports.

Strong skills in Advanced MS Excel, Power View, Power Pivot and Charts

Expertise in designing the dashboards and data visualization using Power Pivot and Power BI.

Experienced on data transformations, data modeling and data visualization using Power BI Desktop.

Good knowledge in writing complex Stored Procedures using T-SQL Scripting and CTE.

Expertise in query optimization & performance tuning. Used tools like SQL Profiler.

Good knowledge on SQL AZURE databases like Creating and managing SQL Server AZURE Databases.

Experience in Performance Tuning of SSIS packages.

Expertise in job scheduling to automate the ETL processes (SSIS package execution) using batch files, Autosys (CA Workload Control Center) and SQL server agent.

Extensive experience developing and maintaining Win forms, ASP.Net web applications and ASP .NET MVC applications using C# (4.0/3.5/3.0/2.0), .Net Framework (4.0/3.5/3.0/2.0, ASP.Net, ASP.Net MVC (5.0/4.0), ADO .Net, Entity Framework, JavaScript, JQuery, WCF services and Visual Studio.

Good knowledge on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism, good experience in Exception Handling and Debugging.

Experienced working with version control tools like Team Foundation Server-TFS 2010 and 2013.

Good working knowledge on creating and maintaining websites, development and setting up application pools etc in Microsoft Internet Information Services (IIS) 6, 7 and 8.

Experienced in creating test plans, test cases for Unit, System and Integration testing.

Experience working in Healthcare, Sales, Manufacturing and travel domains.

Good understanding of project issues, ability to work independently/teams, onsite coordinator, quick problem solver and effectively handled offshore team.

Technical Skills:

Database: MS SQL SERVER 2014/2012/2008/2005, MS Access 2010/2007/2003, Oracle 11g/10g/9i

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS), Power Pivot, Power View

Analytical Tools: SQL Server Analysis Services (SSAS)

Programming Languages: SQL, PL/SQL, T-SQL, C#.Net, ASP.Net, ADO.Net, XML, HTML

Other Tools: SQL Server Management Studio, Toad, Business Intelligence Development Studio, Visual Studio 2013/2010/2008/2005, QNXT 4.8/5.3

Servers: Windows 2012 R2/2008 R2/2008/2003, XP, Windows 7, Vista. Microsoft IIS (8/7/6)

Version Control Tools: Team Foundation Server 2013/2010/2008

Educational Details:

Master of Science in Industrial and Systems Engineering

Northern Illinois University, Dekalb, Illinois

Dec 2014

Bachelor of Engineering, Osmania University, Hyderabad, India

June 2007

Work Experience:

Molina Healthcare Inc, Longbeach, CA Jan 2015 – Present

Role: Sr. SQL BI developer

Description: Claims and Eligibility team is responsible for development, enhancement and maintenance of various internal and external applications to support claims, members, providers, compliance related processes. Loading, processing and tracking the claims, members and providers information in the system, compliance information, disclosure and PHI tracking are some of the processes supported by IT claims and eligibility team.

Responsibilities:

Involved in requirement gathering and analysis of business requirements, participated in requirements review meetings with business users, clients, project management and other teams.

Involved in capacity planning, project estimations and setting the projects timelines of projects or deliverables.

Worked as an onsite coordinator and effectively led offshore team by work assignment, code review and on-time delivery of the projects or deliverables.

Worked on intensive data analysis tasks using advanced excel and various reporting tools in suggesting various process improvements.

Migrated data from different sources (text based files, Excel spreadsheets, legacy systems and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Worked on various tasks within an SSIS package like script tasks using C#, sequence container, for loop, for each loop container, SQL tasks, files system tasks and data flow tasks etc.

Extensively worked on Deployment, Performance tuning of SSIS packages, data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.

Implemented email notification, notifying the support team on the status of the scheduled jobs.

Worked on dynamic configuration of SSIS packages through XML files and SQL server configurations.

Worked on loading the data into QNXT and extracting the data from QNXT into other staging databases.

Created SQL reporting services (SSRS) reports, sub-reports and taking care of the deployment issues.

Created various SSRS reports like linked reports, ad hoc reports, sub-reports, tabular reports, charts and matrix reports.

Created Metrics, KPIs and dashboards using Power View and Power pivot.

Worked on creating dashboards and data visualizations using Power BI.

Good understanding of Data Analysis Expressions (DAX) usage in developing dashboards and reports using Power BI.

Used Power BI Power Pivot to develop data analysis reports and used power view and power map to visualize the reports.

Worked on cubes creation using SSAS.

Involved in analyzing, designing and developing OLAP cubes with SSAS and adding calculations using MDX.

Good knowledge on Tableau.

Involved in designing and development of tables, views, user defined functions and complex stored procedures using T-SQL and CTE.

Involved in performance tuning both snowflake and star (dimensional) schema databases.

Developed applications using C#, ASP.NET MVC, ASP.NET Web Forms, ADO .Net, CSS, HTML, JavaScript and jquery.

Worked on application server management software like Microsoft Internet Information Services (IIS) 6, 7 and 8.

Worked on creating Virtual Directories, Sites and Application Pools using Internet Information Services (IIS).

Experience in working with version control tools like Team Foundation Server-TFS 2010 and 2013.

Good understanding of workload automation tools like Autosys (CA Workload Control Center) for SSIS, xml and FTP job scheduling.

Developed technical design documents, Change Data Capture (CDC) and functional required documents.

Created test plans, test cases for Unit, System and Integration testing.

Environment: SQL Server 2008/2012/2014, SSMS, BIDS, Visual Studio 2010/2013, SSMS, BIDS, TFS 2010/2013, IIS 7/8, ASP .Net 3/3.5/4, MVC 4/5, Entity framework 5, QNXT 4.8/5.3

Northern Illinois University, DeKalb, IL Jan 2013 – Dec 2014

Role: Graduate Research/Teaching Assistant

Description: Northern Illinois University (NIU) is a public research university in the state of Illinois..

Responsibilities:

Created ETL packages using data sources like SQL Server, Flat Files, CSV Files, Excel source files, Access Files, XML files and then loaded the data into Staging areas by performing different kinds of transformations using SSIS Control Flow and Data Flow transformations.

Worked on SQL Server 2012/2008 and database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Updating and maintaining the student database using MS SQL server.

Prepared the Metrics and KPIs and various reports using advanced excel, power pivot and power views.

Generated dashboards and ad hoc reports using Power Pivots and hosted on SharePoint.

Assisted students with database designing using Microsoft SQL Server, MS Access and SQL.

Helped students in data flow, data normalization and relational database designing.

Involved in extensive data analysis using advanced excel.

Maintenance of software of computers in department laboratory.

Assisted students with MS Access, Excel and Word related issues.

Planning the lab hours schedule for the lab assistants.

Environment: SQL Server 2008/2012, Visual Studio 2008/2010, SSMS, BIDS, MS Access, Advanced MS Excel, power pivot

Tata Consultancy Services Aug 2007 – Dec 2012

Project: Applied Materials Inc. Santa Clara, CA

Role: IT Analyst

Description: Applied Material’s Supply chain planning team deals with inventory management, forecasting and materials requirement planning of spare parts. Team is involved in intensive data analysis, and supply chain planning activities. Team supports internal applications and processes, to maintain the track of all the forecasting and inventory management activities.

Responsibilities:

Involved in Business Requirements gathering, User Requirements and technical requirements gathering by interacting with various stake holders of the project.

Involved in database designing for different projects and resolve database issues.

Created and developed the Stored Procedures, functions and triggers to support the application.

Responsible for development of SQL scripts to Insert/Update and Delete data in MS SQL database tables.

Designing, developing and deploying various ETL packages for data loading (SSIS)

Worked on developing SQL server integration service (SSIS) packages and SSRS reports.

Responsible for continuous enhancements of supply chain systems and procurement systems as a supply.

Good working knowledge on creating dimensions and cubes using SSAS.

Involved in data analysis, preparing the metrics and dashboards using advanced excel.

Responsible for finding the root cause by analyzing huge amount of data and suggesting the solutions to users.

Built table relationships and wrote stored procedures to clean the existing data.

Involved in Unit testing and System Integration testing.

Involved in writing test cases as part of testing process.

Environment: SQL Server 2008/2012, MS Access, Advanced MS Excel, C#, HTML, ASP .Net, Microsoft Visual Studio 2008, SSIS, SSRS. SSAS

Project: Engineering & Industrial Services, Bangalore, India

Role: Software Engineer

Description: Engineering and Industrial Service (EIS) is one of the service lines of TCS. EIS has projects from various engineering fields like automobile, aerospace, energy and manufacturing etc. Some of the clients are General electric, Nissan motors, General Motors etc.

Responsibilities:

Preparation of ETL Design Documents.

Creation of SSIS packages to implement ETL process to load fact and Dimensions Tables. Query Optimization and tuning the query, creating Indexes to improve the query performance.

Bulk Insert and loading the data files which comes from various legacy systems (Mainframes and Oracle database).

Expertise in Monitoring and Troubleshooting and resolving the SQL Server Performance issues.

Designing, developing and deploying various ETL packages for data loading (SSIS).

Participated in TCS internal learning program (ILP), a training program intended for campus recruits.

Environment: Windows 2003, SQL Server 2008, Microsoft Visual Studio 2008, SSIS, SSRS, Windows

XP, Windows 2003, Windows 2000

Contact this candidate