RASHMI JHA

Email: ac8zrr@r.postjobfree.com

SQL BI Developer

Established professional SQL BI Engineer with more than 8 years of experience in designing and implementing efficient BI system to generate insights, identify trends and opportunities, and transform data into actionable information in a timely manner to extract useful business insights & help in critical business decisions in a large-scale, complex and distributed environment. Expertise in using various software tools, languages and methodologies with special expertise SQL BI and SQL Server technologies.

Areas Of Expertise

Multiple Data source ETL

Complex SQL/T-SQL

Creative Problem Solving

Portal & Dashboard Design

SSIS transformations for Data Cleansing

Business Requirement Gathering

Analytical & Detail-Oriented

OLAP and Cube designing

Ad-hoc, Custom reporting

Testing SSIS packages

SQL Profiling/Tuning

DTS and SSIS

Experience in DMV and DMF

Interpersonal Skills

Testing SSRS reports

Professional Experience

GA Department of Education Feb 2016 – Sep 2016

Project: County Financials

Sr. SSRS Report Developer, R&D

Analyze, develop, implement and Test software systems.

Write, update and maintain MS SQL Server Database /SSIS/SSRS applications, software packages to handle specific jobs such as storing or retrieving data (using T-SQL), controlling other equipment.

Developed the financial cascaded and parameterized reports.

Developed the SSRS 2012 / 2014 reports from the different sources of reports like Cognos and Oracle.

Write and maintain complex queries, Stored procedures, functions and T-SQL for the generating reports based on the requirements.

Performance tuned T-SQL scripts.

Responsible for validating data and testing the reports as well.

Developed various operational Drill-through and Drill-down reports using SSRS.

Prepare and maintain all project related documents such as application architecture documents, database design documents, Business requirement documents and enhancements documents.

AT&T May 2013 – Jan 2016

Project: Mobility Services

Application Developer

Responded to various report requests from Business Users; worked with assigned Business Analyst to gather reporting requirements.

Collected and evaluated reporting requirements to determine level of priority.

Developed SSIS and SSRS Projects for Business Intelligence Solutions; created Performance Evaluation Reports that showed KPIs (key performance indicators).

Maintained integrity and Deployment of SSIS packages and developed SSRS reports.

Monitored SSIS packages that pulled data from various customer data sources; packages were used to scrub large amounts of customer data before loading into SQL Server.

Responsible for creating the tables, views, stored procedures using T-SQL.

Used DMV’s and DMF’s for SQLServer performance.

Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.

Designed and developed various reports such as Tabular, Matrix, Drilldown, Drill Through, and Parameterized Reports using SSRS 2008/2012.

Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Developed SSRS reports from extracted data stored in SQL Server 2008/12 database.

Created and altered complex T-SQL queries in SQL Server Management Studio (SQL Server 2008 R2/12).

Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.

Configured Data Flow Tasks that executed T-SQL scripts, sent emails, pulled data, transformed data, and imported data into SQL Server 2008/12 database tables.

Satyam Computers Pvt. Ltd. Mar 2006 – Jan 2010

Project: Reuters XRS

SQL Server BI Developer

As an ETL/SQL developer, the project comprises of developing, implement, designing the financial data for the company. Project also extended the responsibilities to create many Database objects and tune the existing one and integrate data to existing Data Warehouse of the organization in-place.

Involved in all phases of SDLC, and gathered business requirements from business people.

Design/develop database using SQL SERVER 2005.

Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.

Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.

Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).

Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.

Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.

Created OLAP Cubes and Dimensions using SSAS in data warehouse environment.

Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, Views and other SQL joins for applications.

Scheduled Complex Stored Procedures by using SQL Server Agent.

Monitored and modified Performance using execution plans and Index tuning.

Education & Technical Skills

Bachelor of Engineering, GEC Bilaspur, India

Languages

:

NET, C/C++, UNIX Shell Programming, SQL, T-SQL, HTML, XML.

Database

:

SQL Server 2005/2008/2012, MS Access 2000, Oracle 9i/10g

BI Tools

:

SQL Server Analysis Services 2005/2008 R2/2012, SQL Server Reporting Services 2005/2008 R2/2012, SQL Server Integration Services 2008R2/2012

ETL Tools

:

Export & Import (DTS), SSIS (Integration Services)

Other Application

:

Microsoft Visio, Cognos 8, Visual Studio, SQL Developer, Subversion (SVN)/TFS/ Microsoft Visual Source Safe

Databases Utilities

:

Enterprise Manager, Query Analyzer, SQL Server Configuration Manager, Business Intelligence Development Studio (BIDS), SQL Server Surface Area Configuration, Database Engine Tuning Advisor, SQL Profiler

Contact this candidate