Name: PATAN RESHMA

Contact: 9542341360
E-mail: [email protected]

.
Having 3.8 years of experience in Data Warehousing & Business Intelligence Application,
gaining strong professional experience in Microsoft Business Intelligence Tools like SQL
Server Integration Services, SQL Server Reporting Service, SQL Server Analysis Services
Power BI etc, seeking leadership challenges.

PROFESSIONAL SUMMARY:

 Strong experience creating objects like stored procedures, functions, cursors, triggers, Indexes,
joins and views using T-SQL Development and production environment for SQL Server
2008R2/SQL Server 2012.

 Experience in Development of SSIS packages from Heterogeneous Systems and loading data into
different RDBMS tables

 Proven proficiency at Data Transformations like Lookup, Derived Columns, Conditional Split, Sort,
Data conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server
destination.

 Hands on Administrative tasks like scheduling, configurations and loggings.

 Experienced in Performance Tuning in SSIS Packages.

 Good experience on entire reporting life cycle right from development, deployment, configuration,
providing URL to business end users etc.

 Experience in Generating reports like Pie-charts, Bar graphs, Drill downs, Drill through, Sub-reports,
navigation reports etc… using SSRS.

 Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as
per Standards.

 Expert in writing SQL queries, stored Procedures, User defined Functions, Views and indexes by
using SQL Server.

 Good experience on CTE, Derived tables, temp table concepts.

 Experienced in programming tasks- Stored Procedures, Triggers, Cursors using SQL Server 2008
R2/2005 with T-SQL.

 Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with
support of Data-Flow Process Models, E-R Diagrams.

 In depth Technical knowledge in OLAP and OLTP Data modeling process.

 Good knowledge in writing MDX queries.

PROFESSIONAL EXPERIENCE

Working as a Software Engineer for IBM INDIA LTD from NOV 2015 to till date.

EDUCATIONAL QUALIFICATIONS

B Sc (Computers) from SV DEGREE & PG COLLEGE, ANANTAPUR.

TECHNICAL SKILLS

Operating Systems : Windows Family.

Technologies : Microsoft Business Intelligence Tools (MSBI).
ETL Tools : SQL Server Integration Services 2008R2/2012.
Report Tools : SQL Server Report Services 2008R2/2012.
Database : SQL Server 2008R2/2012.

MAJOR ASSIGNMENTS

3. Fluor Corporate Fluor Corporate, US

From May 2018 – Till Date

Tools : SQL Server, SSIS, SSRS

Team Size : 4
Designation : SQL Developer.
Environment : SSIS, SSRS, SQL Server and Power Bi.

Description:

Fluor is a global leader in engineering, procurement, fabrication, construction, maintenance, and

project management. Active across six continents, we work with governments and multinational
companies to design, build, and maintain many of the world's most complex and challenging
capital projects. Clients trust Fluor to deliver services to optimized their assets, improve their
competitive position, and increase their long-term business success. Our primary objective is to
develop, execute, and maintain projects with operational excellence, and we are consistently rated
as one of the world’s safest contractors.

Responsibilities:

 I Used to design SSIS Packages to connect to hetro genius sources and pulling data from
source an
Loading into data warehouse.
 After loading the data I used to generate name type of reports according to the client
Requirement.
 Generate the T-SQL: Stored procedures, Triggers, Functions, Tables, Views.
 Created Event Handlers for the Packages Using Event Handler Tab for Error Handling.
 Maintained log information in SQL table to tracking Errors and recording package execution
status.
 Created Configurations to change the package properties dynamically
 Good Knowledge on Optimizing the SSIS Packages.
 Extensively worked in data Extraction, Transformation and Loading from source to target
system.
 Generated the reports by using the Report Wizard and Report Server
  Building and generating reports with the help of Report Builder in the Report manager.
 Converting the reports from Crystal reports to SSRS reports.
 Generated the Reports Weekly and Monthly basis as per the Client Requirements.

2.Trader Joe’s Trader Joe’s, US

From Oct 2016 – March 2018

Tools : SSRS, SSIS

Team Size : 6
Designation : ETL Developer
Environment : SSIS, SSRS, SQL server 2008/2008R2/2012

Description:
Trader Joe’s tops our list of America’s Best Supermarkets. The chain boasts more than 400 stores
throughout the U.S. but most are concentrated in Southern California, where it originated. While the
majority of supermarkets offer more than 50,000 different products, Trader Joe’s stocks about
4,000 and most of them are Trader Joe’s brand. The diversity of gourmet, organic, and vegetarian
options as well as excellent prices and quality keep this store on top of the list.

Responsibilities:

 In the current project I work as an ETL Developer and the Reporting Developer and collected all
the required specifications of input data.
 I also worked in Data Extraction, Data Transformation and Loading the Data, also developing of
packages.
 Developed various packages to extract the data from different source like relational tables and
flat files.
 Worked on Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly
to dump the data in to SQL Database.
 Implementing Transformations in dataflow to clean data.
 Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and
included various reporting features such as drilldowns, drill through, sub-reports, navigation
reports (Hyperlink) etc.
 Report parameters included single valued parameters, multi-value parameters which also
consisted of different parameter types.
 Worked on all types of report types like tables, matrix, charts, sub reports  etc.
 Scheduled reports to refresh and run on daily, weekly and monthly basis in the report
manager.

1. Brinker International Brinker International, Dallas

From NOV 2015 – Sep 2016

Tools : SSRS, SSIS.

Team Size : 5.
Designation : MSBI Developer.
Environment : SSIS, SSRS, SQL server 2008/08R2/2012.

Description:
Dallas-based Brinker International, Inc. is one of the world’s leading casual dining restaurant
companies. Founded in 1975, Brinker produces $2.9 billion in sales and owns, operates, or
franchises more than 1,600 restaurants across 30 countries and two territories under the names
Chili’s® Grill & Bar and Maggiano’s Little Italy.

Responsibilities:
 Involved in Creating Database Objects like Tables, Stored Procedures, Views, Triggers, and
user defined functions for this project.
 Gathered Requirements from the end user and involved in developing logical model and
implementing requirements in SQL Server.
 Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential
Container, Execute SQL Task, Email Task and Data Flow Task.
 I Used to design SSIS Packages to connect to hetro genius sources and pulling data from
source and loading into data warehouse.
 Used different destinations like OLE DB Destination, Flat file, Excel destinations and different
sources like Flat file and OLE DB Source, CSV files.
 Creation of work flows with Data flow, Execute SQL task, and Execute package tasks And
Containers.
 After loading the data I used to generate name type of reports according to the client
Requirement.
 Responsible for creating reports based on the requirements using Reporting Services 2005.
 Identified the database tables for defining the queries for the reports.
 Identified and defined the Datasets for report generation.
 Wrote queries for drill down reports to get the dataset required to build the report.
 Deployed generated reports onto the Report Server to access it through browser.