Sql Server Data

KATYAYANI

Mobile: 251-***-****

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

PROFESSIONAL SUMMARY

* ***** ** ********** ** Database Design, Development, and maintenance of database applications on SQL Server2008/2008R2/2012/2014 and MSBI Stack.

Experience in complete Software Development Life Cycle (SDLC). Used Waterfall Model, and Agile Methodologies-Scrum.

Hands on experience in database programming in writing T-SQL/PL-SQL Stored procedures, Triggers, Constraints, Indexes, and Batch Scripts using various DDL and DML commands.

Technically hands-on commercially experience mainly with a full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server (PPS).

Experience in a different type of reports including Tabular forms, Matrix form, Conditional, drill down, List items, Charts, and SubReports using SSRS.

Proficient in writing MDX, DAX Scripts to create datasets to perform reporting and included interactive drill-down reports, report models, and dashboard reports.

Strong knowledge of Data Marts, Data warehousing methodologies and concepts, OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT, and Dimensions Tables using Analysis Services(SSAS).

Experience with working on Power BI and related reporting tools to produce a variety of Dashboards.

Experienced in the development of Reports for Financial needs of the business using Crystal Reports.

Developed several crystal repositories using Crystal Enterprise Business View Manager and created reports from repositories.

Good understanding of project management disciplines and operates independently in performing moderately complex applications software development functions.

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS

BI Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools.

Languages: C, C++, .Net, C #, SQL, T-SQL, PL-SQL, MYSQL.

Operating Systems: Windows 10, Windows7, Windows Vista/XP, Linux.

Databases: MS-SQL Server 2014/2012/2008R2, MS-Access, Oracle, MySQL

ETL Tools: SQL Server Integration Services (SSIS), Import/Export Wizard

Scripting: HTML, DHTML, Shell Scripting, Java Scripts, VB Script, XML, JSON.

Reporting Tools: SSRS, SSAS, PowerBI, Tableau, Spotfire, Crystal Reports.

CERTIFICATION

Certified Scrum Master – International Scrum Institute.

-Waterfall, Agile- JIRA.

PROFESSIONAL EXPERIENCE

Morrison Management Specialists, Mobile, AL February 2017 – Till Date

BI Developer

Responsibilities:

Created Stored Procedures, Functions, Maintenance Jobs, and Triggers using SQL.

Optimized and fine-tuned various stored procedures.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files,) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages

Supposed to transform unstructured data from various data sources using SSIS Transformations like Data Conversion, Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.

Used to provide Logging, Error handling by using Event Handler and Custom Logging for

SSIS Packages.

Played Support Role several times fixing bugs/issues, addressing issues from field users.

Created Tabular reports, Cross-Tab Reports, Matrix, Sub Reports, and Parameterized reports.

Analyzed reports and fixed bugs in stored procedures.

Designed and implemented stored procedures and triggers for automating tasks.

Fine-tuned SQL queries for maximum efficiency and performance.

Designed SSIS packages to migrate client data warehouse from SQL Server 2005\2008r2\Oracle\MYSQL to SQL Server 2012\2014 environment.

Configured the report viewing security for various users at various levels using Report Manager.

Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Implemented SSRS Business Intelligence life cycle such as configuration of report server configurations, Deployment of reports, creating report subscription (Data Driven) in development, Test, Production Environment.

Created requirement documents, technical design documents and knowledge sharing documents.

Created dashboard reports using PowerBI Service.

Designed cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.

Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, PowerBI, Visio, Share point, MS Office 2010, Windows 10, T-SQL.

Computer Technology Solutions, Mobile, AL February 2016 - December 2016

Power BI developer

Responsibilities:

Analyze the Application support documents and Service Level Agreements (SLA).

Participated in gathering the business requirements and Database Specifications.

Prepared HLD and LLD Technical Description Documents.

Involved in Data Base Normalization.

Created Packages using Complex Store Procedures and TSQL queries

Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs

Implemented stored procedures and functions to meet the dynamic nature of SSIS packages and SSRS Reports existing software application requirements.

Used different Control Flow Tasks and Data Flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.

Developed Tabular, Drilldown, parameterized, Cascaded, and sub-reports using SSRS.

Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns with Multiple Data Flow tasks

Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed event types.

Extensive use of DAX expressions in tabular models as per business requirements.

Worked on Developing and Publishing Power BI Dashboards in Power BI site.

Created relationships between tables in Power BI using Star and Snowflake schemas.

Created Power BI Dashboards using a different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc.

Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports.

Involved in Trouble Shooting Complex Reports.

Environment: MS SQL Server 2012, SQL Server Integration Services, Microsoft Visual Studio, Team foundation server (TFS) 2010, T-SQL, PowerBI, MS Excel, Windows 2010 Server

Medtronic March 2014- June 2015

BI Developer

Responsibilities:

Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful, and standardized data and reporting.

Developed tables, Views, Stored Procedures, and Triggers using SQL Server Management Studio.

Identified and resolved the query performance using SQL Profiler.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Established Inner Join, Outer Join and created Indexes whenever necessary.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Worked on extracting, transforming, and loading data using SSIS Import/Export Wizard.

Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.

Responsible for installation, configuration, security, maintenance, restoration of SSRS.

Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports, and Charts using SQL Server Reporting Services (SSRS).

Performed Sorting, formatting, and Grouping to custom reports in SSRS.

Created Query Parameters and Report Parameters to control data returned by the query and filter data at the report level.

Fully utilized the Software Development Life Cycle processes including requirement.

Environment: Microsoft SQL Server Management Studio 2010, SSDT, SSIS, Windows Server 2010, Microsoft Office 2010, SQL Reporting Services (SSRS), TFS.

Apollo Health Street October 2013 - February 2014

Developer

Responsibilities:

Developed physical data models, data warehouse models and created DDL scripts to create the database schema and database objects.

Created and maintained tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.

Writing T-SQL queries and Stored Procedures to extract data and to get the required value from the given data.

Created Functions, Packages, Triggers, and Indexes using T-SQL in all the environments for SQL Server.

Maintained complex Stored Procedures using Joins and Subqueries.

Designing and modeling database according to Requirement and made changes according to it.

Used to analyze long running queries and tune the same to optimize application and system performance.

Environment: SQL developer, SQL Server 2008R2, Windows 7, Microsoft Visual Studio.

EDUCATION

Master of Science – Electrical and Computers Engineering, Dec 2016

The University of South Alabama, Mobile, AL.

Bachelor of Technology – Electronics and Communications Engineering

SCR Engineering College, India

Contact this candidate