C Shivani

Email: adhk1e@r.postjobfree.com

Phone: 971-***-****

SUMMARY

•6 years of experience as Business Intelligence Developer and SQL Developer in Production, Development and Staging Environments.

•Worked in various domains like Banking and Tele Communication.

•Involved in Huge data migrations, transfers data using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.

•Experience in Installation, Configuration and Updates of SQL Server 2005/2008/2008 R2/2010/2012.

•Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, Joins, Sub Query, User Defined Functions, Triggers.

•Good knowledge in Performance Tuning, Optimization and Data integrity.

•Experience in solving Real Time issues with Index Fragmentation, Query Tuning, Error and Event Handling.

•Experience in BI Development and Deployment of SSIS packages from MS-Access, Excel and Oracle.

•Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.

•Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

•Experience in enhancing and deploying the SSIS Packages from development server to production server.

•Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables.

•Development of Multi-dimensional Objects (Cubes, Dimensions) using Analysis Services(SSAS).

•Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.

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

•Expertise in generating reports using SQL Server Reporting Services, Power BI, Power Pivot, Power Query and MS Excel spreadsheets.

TECHNICAL SKILLS

Programming Languages : C, C#, T-SQL

Database Technologies : SQL Server 2005/2008/2012/2014, BIDS, SSDT, SSIS, SSAS, SSRS

Development Tools : Visual Studio 2003/2005/2010/2013

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

Power Query, DAX, Power View, Tableau, Excel.

EDUCATION

Jawaharlal Nehru Technological University (JNTU), Hyderabad, India Sept’2009-May’2013

Bachelor of Technology

PROFESSIONAL EXPERIENCE

Client: Microsoft. April ‘2019 – August 2020

Role: SQL/Power BI Developer

I was responsible for gathering, analyzing, and creating data that showcases how FastTrack team delivers benefits and measures successes within tenants. Analysis of FastTrack data by leveraging existing tools, reports and creating new reports and dashboards through Microsoft based tools.

Manipulate and analyze complex, high-volume, high-dimensionality data from varying sources.

Present findings, recommendations and collaborate with key stakeholders to answer questions through data analysis.

Client: Microsoft. Mar ‘2019 – April 2020

Role: SQL/Power BI Developer

Created new Power BI dashboards and enhanced some existing reports under Modern Workplace BI Suite. My responsibility was end-to-end delivery of reports which included requirements gathering, analyzing data sources, writing ETLs to periodically get data in local SQL Server DW and creating reports based on the requirements of the stakeholders.

Client: Microsoft. Jan ‘2018 – Mar 2019

Role: SQL/Power BI Developer

The Goal of this project is to propose and demonstrate a solution framework that can accurately forecast and reforecast. The call center volume for variety of predicators using data science techniques where in the forecast will be used to optimize all aspects of workforce management including headcount, training and assignment.

Responsibilities:

• Expert in Developing multiple kind of Power BI Reports and Dashboards.

• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service& Report Server.

•Explore& Analyze data in a Variety of ways and across multiple visualizations using Power BI.

Project Specific Activities:

•Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.

•Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data source.

•Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

•Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.

•Creating Dashboard Reports using Power BI.

•Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.

•Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

•Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.

•Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.

•Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.

•Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).

•Worked on both live and import data to Power BI for creating reports.

•Worked with Power BI gateway to schedule daily job to refresh data.

•Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server using Direct Query.

•Managed relationship between Power BI using Schemas such as Star & Snowflake.

•Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.

•Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.

•Deployed Dashboards, Reports and Data sources in the Power BI Service.

Client: Infosys

SQL Developer June’15 – Nov’16

Responsibilities:

•Designed and implemented Stored Procedures and Triggers for automating tasks.

•Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.

•Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.

•Involved in migrating huge amount of data from legacy database to the newly designed Normalized database using SSIS.

•Involved in using migration techniques like BCP, SSIS and regular stored procedures and scripts.

•Pulling data on a daily basis from OLTP database to OLAP or staging database using SSIS packages.

•Created indexes to increase the reports performance.

•Used the reporting tools MS SSRS 2012 to build the reports.

•Expertise at using SSRS 2012 to build various kinds of reports based on requirements. Developed Drill-through, Drill-down, Sub reports and Cascading reports.

•Developed complex stored procedure using T-SQL to generate reports using SSRS 2012.

Infosys Limited -Systems Engineer March’14 – May’15

SQL Developer

The mission of ERS (Employees’ Retirement System) is to be the guardian of the retirement systems it administers for the ultimate benefit of the members, retirees and beneficiaries of those systems. This mission is accomplished through ERS’ core responsibilities which include pension administration; the collection, reconciliation and disbursement of contributions for the welfare of the members, retirees and beneficiaries of the plans; and the sound and secure investment of the retirement funds.

Responsibilities:

•Created and modified procedures, triggers and functions

•Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.

•Modified store procedure for performance tuning

•Used system stored procedures and DBCC commands.

•Used DTS packages to do file operation, to apply business rules.

•Transformed data from text file to SQL server using OLE Automation Objects

•Deployed database objects from development/testing environment to production environment

•Created DTS package to export and import data from SQL Server to text files and data files.

•Worked with Application Developers to support Development activities and achieve optimal efficiency.

•Monitored and scheduled existing/new jobs on production environment.

•Created all administration tasks of SQL Server.

•Responsible for keeping system and databases up-to-date by making necessary changes.

Aurobindo Pharmacy, HYD, India Sept’13- Feb ‘14

SQL Developer, Trainee

Description: The various modules of this Product are Personal Information Maintenance, Salary Details, Leave Details, Loans and Reports. The HRI System allows the Data to be shared while maintaining the confidentiality of the information. Generation of Reports is faster; queries can be handled with ease to enhance productivity at the same time. System generates Salary, Income Tax and routine reports required by HRD. The System is based on C/S architecture using Visual Basic as Front-end and SQL server as backend.

Responsibilities:

•Interacted with end users to gather Requirements. Created technical, user documentation.

•Studied and designed the system.

•Install, Update, Configure and Maintain the MS SQL Server.

•Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.

•Write T-SQL queries for the retrieval of the data.

•Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.

Contact this candidate