Sql Server Data

Sneha I Vivek

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

Phone: 408-***-****

PROFESSIONAL SUMMARY

Around 5+ years of IT experience in the Analysis, Design, Development, Implementation and Support of MS SQL Server in Production.

Expertise in total Microsoft BI Stack(SSIS,SSAS,SSRS)

Proficient in Tableau (Desktop, Server, Public, Mobile).

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Expertise in High Level Design of ETL, DTS Packages& SSIS Packages for integrating of data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Derived column, Conditional Split, Bulk Insert, Merge and union all.

Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC).

Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and Power Pivot.

Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.

Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and others making use of actions, other local and global filters according to the end user requirement.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.

Good understanding of Data Warehousing concepts and ability to utilize star schema and snow flake schema according to the requirement.

Experience in using T-SQL in SQL Server 2008, 2012, 2014 platforms.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)

EDUCATION:

Master of Computer Science, December 2014

Purdue University, Hammond, IN, USA

GPA: 3.5/4.0

Bachelor of Technology in Computer Science May 2011

Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh, INDIA

GPA: 3.6/4.0

TECHNICAL SKILLS:

SQL Server Tools

SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, SQL Profiler, Query Analyzer, SSIS, SSRS,SSAS

Databases

SQL Server 2000/2005/2008/2008 R2/2012, MS Access, Oracle, Excel

Programming Languages

SQL,T-SQL, VB

Operating System

Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0

Windows XP/98/95, MS DOS, Linux.

Scripting

HTML, XML, VBScript, JavaScript,C#,ASP.NET,VB.NET,

Tools

Erwin, Visual Studio 2008/2005

Source control tools

TFS, Visual Source Safe, SVN, JIRA

BI Tools

BIDS, Excel Reporting, Tableau, Report Builder 1.0/2.0/ 3.0, QlikSense.

PROFESSIONAL EXPERIENCE:

CISCO Systems, San Jose, CA, USA (May 2014 – Present)

SQL Server Developer/ BI Developer

Responsibilities:

Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.

Understanding the data mart design requirements from the Architects and Business Analyst.

Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Built compelling, interactive dashboards and visualizations in Tableau that answer key business questions and to support ad-hoc analyses.

Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.

Experience in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.

Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.

Converted HTML, XML data to SQL tables.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.

Logging the SSIS Packages, Scheduling using SQL Agent job and Send email updates regarding the process and job routine.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Prepared mapping documents and Process flow documents for ETL Processes.

Designed SSIS package for automatic data migration to transform Data from SQL Server 2005 to SQL server 2008.

SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.

Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.

Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2005/2008.

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008 R2

Built a consolidated Data Mart for five different Company Organizations which was further populated and used to build a Cube on SQL Server 2012 for further reporting requirements.

Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Creating Ad Hoc and Reports using SQL server 2008 R2 Reporting services.

Worked closely with business power users to create reports/dashboards using tableau desktop.

Created tables based on business needs, created views, used stored procedures, functions and indexes using T-SQL.

Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Maintain schedule jobs and perform troubleshoot on processes and resolve all issues.

Performed data analysis to generate various trend reports for commercial accounts based on branches.

Involved with Query Optimization to increase the performance of the Report.

Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries and others.

Wrote stored procedures to get the fields required for the reports.

Created datasets using stored procedures and reports using multi value parameters.

Environments: SQL Server 2008 R2, SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), VB.NET

Orbit Technologies, Hyderabad, AP, INDIA (May 2010 to December 2012)

SQL Developer

Responsibilities:

Involved in dimensional modeling to design data warehouse.

Generated stored procedures and functions for better performance and flexibility.

Involved in planning, designing and defining data flow process for moving data from OLTP database to data warehouse.

Collaborated with team members in writing SQL scripts, performing tests and providing appropriate follow-up actions and documentation.

Implemented Data Cleansing, Incremental Data Loading, Event Handling and Error Handling.

Used different types of transformations such as data conversion, conditional split, look up, derived column, aggregate, Multicast etc.,

Created SSIS packages to perform filtering options and import the data on daily basis from file server to database tables.

Prepared technical documents for SSIS Packages.

Created various forms of reports such as sub report, charts and matrix

Involved in Database design, Data modeling and writing Stored Procedures.

Optimized queries that were taking long time to display desired result set.

Created groups, roles, users and assigning access privileges to users.

Performed data analysis to generate various trend reports.

Mentoring the team. Coordinating with Development team.

Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.

Created various forms of reports such as tabular, matrix, charts, drill down and parameterized reports and deployed them to report server.

Involved in creating SSIS packages, building, deploying and executing the packages in both environments (Developments and Production).

Used SSIS package to load data from different platforms such as CVS, XML, Flat File and excel and Hands on experience in creating ETL packages using SSIS.

Environments: SQL Server 2008, SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS), Windows Server 2008 R2, Business Intelligence Developments Studio (BIDS)

Technical Coursework

• Software Engineering and Management

• Database System

• Algorithms and design

• Distributed Systems

• Operating System

• Compiler Programing

• Web Technologies

• Computer Networks

• Computer Architecture

• Introduction to Robotics

References:

References are available upon request.

Contact this candidate