Sql Server Data
Resume:
DEEPIKA JADAV
SUMMARY
SQL Server BI (SSIS, SSAS, SSRS) Developer
. Over 6 years of experience in IT, with primary
skill on the Analysis, Design, Development,
Implementing and Testing Client/server application
using Microsoft SQL Server and BI suite.
. Experience across all phases of SDLC from project
initiation to post-implementation
. Experience in installing, configuring, managing,
upgrading and migrating, monitoring and
troubleshooting SQL Server 2000/2005/2006/2008
R2/2012.
. Created SSIS Packages using Various Transformation
like Lookup, Derived Columns, Condition Split,
Data Conversion, Aggregate, Merge Join, Sort,
Execute SQL Task, Data Flow Task, and Execute
Package Task etc. to generate underlying data for
the reports and to export cleaned data from Excel
Spreadsheets, Text file, MS Access, SQL Server,
Oracle, FTP Server, XML files, CSV files.
. SQL Server development including DTS, Microsoft
Analysis Services, Performance tuning, Reporting,
Designing logical/physical databases and
Troubleshooting.
. Experience in Data Modeling (Logical and Physical Design of
Databases), Normalization and building Referential Integrity
Constraints.
. Very good knowledge in HIPAA compliance.
. Good Hands on experience dealing with On-
Site/Offshore model and worked with Development,
Production Support and Quality On-site/Offshore
experience.
. Experience in Data Warehouse Modeling with SQL
Server Analysis Service (SSAS).
. In-depth knowledge of T-SQL, SSAS, SSRS, SSIS,
OLAP, OLTP, Reporting and Analytics.
. Created SQL Server Analysis Projects (SSAS) and
proficient in Referenced relationships for
Business Intelligence applications using MS SQL
Server 2005/2008.
. Experience in writing efficient multi-dimensional
expression (MDX) as per the design requirements.
. Created OLAP Cubes and performed data mining on
the data using the fact table and the dimension.
. Expert in Cube Designer in Business Intelligence
Development Studio(BIDS) to edit various
properties of a cube, including the Measure
groups and Measures, Cube dimensions and
Dimension relationships, Calculations
. Experience in SQL Server 2000/2005/2008 R2/2012
RDBMS database development including T-SQL
programming.
. ETL skills, Data modeling, Dimensional Modeling
knowledge with experience in developing data
movement, data cleansing and data integrity
processes for the purposes of loading decision
support applications utilizing advanced knowledge
of DTS packages and Transact SQL, design and
support/enhancements/maintenance.
. Microsoft Reporting Service (SSRS) with Report
authoring, Report management, Report delivery and
Report security. Experience in developing User
reports and management reports using MS SQL Server
Reporting Services (SSRS).
. Designed complex SSAS solutions using multiple
dimensions, perspectives, hierarchies, measures
groups and KPIs to analyze performance of
Strategic Business Units as well as corporate
centers. Knowledge in Data modeling, creating star
and snowflake schemas in SSAS
. Supported team in resolving SQL Reporting services
and T-SQL related issues and Proficiency in
creating different types of reports such as Cross-
Tab, Conditional, Drill-down, Top N, Summary,
Form, OLAP and Sub reports, and formatting them.
. Experience in creating indexed views, complex
stored procedures, effective triggers, and useful
functions to facilitate efficient data
manipulation and consistent data storage.
. Expert in Extraction, Transforming and Loading
(ETL) data flows using SSIS; creating
mappings/workflows to extract data from Oracle,
SQL Server and Flat File sources and load into
various Business Entities.
. Experience in working on C#.NET and ASP.NET web
pages
. Extensive use of DTS in SQL Server, T-SQL, Stored
Procedures, Functions and Cursors and Triggers
etc. Extensive experience in data migration
between homogenous and heterogeneous system using
various tools (Data Transformation Services (DTS),
SSIS).
Technical Skills
. Databases: SQL server 2000/2005/2008 R2/2012,
MS Access, Informix, Oracle 11g
. Operating Systems: Windows XP/7
. OLAP/Reporting Tools: SQL Server Analysis
Service (SSAS), SQL Server Reporting Service
(SSRS), MDX, Cognos, Framework Manager
. ETL Tools: SQL Server Integration Services
(SSIS), SQL Server DTS, Informatica, Data Manager
. Other Tools: Microsoft Visual Source Safe,
Microsoft Office, MS Visio
. Data Modeling Tools: Microsoft Visio 2008/2010
. SQL Server Tools: SQL server Management Studio,
SQL server Query Analyzer
. Programming languages: C, SQL, PL/SQL, T-SQL,
C#, Asp.NET, C, C++, Java, VB 6.0, VB.NET
. Data Modeling: Star Schema Modeling, FACT,
Dimensions Tables, Physical and Logical Data
Modeling
. Data Warehousing & BI: SQL Server, Business
Intelligence Studio, SSIS, SSAS, SSRS (SQL Server
Analysis Services and SQL Reporting services),
DTS.
PROJECT EXPERIENCE
Client: MedAssets Inc
Saddle River, NJ
November 2014 Till Date
ETL (SQL/ C#/SSIS) Developer/
Data Programmer
MedAssets work with clients to identify
and sustainably reduce the primary drivers of the costs of delivering
healthcare. They team with clients to make sure they're achieving optimal
operational results
through best practices on
processes and the use and management of people and non-labor expenses. They
help providers define, implement and adhere to clinical processes and
standards that lead to measurable.
improvements in quality of
care and patient safety. They partner with clients to implement processes
and technologies that optimize capturing the reimbursement they've earned,
and to help them navigate evolving
healthcare business and
payment models
Responsibilities:
. It's a DTS to SSIS migration project wherein we
migrate DTS i.e. the old version of SSIS to
version 2008.
. It also includes all the conversions within the
existing SSIS packages wherein we covert the
VB.NET code to C#
. Extensive use of C# and VB.net scripts to parse
files, read files, extract data, performs
transformations and load the data.
. Created joins and sub-queries for complex queries
involving multiple tables.
. Creating hash keys using a user defined
function in SQL to accomplish unit testing of all
SSIS packages. This is done to ensure that the
packages are converted correctly and data matches
as per the transformations done in SSIS to the
transformations done in SQL stored procedure and
in a function
. Extensive VB.NET to C# code conversion for all
the hospital projects
. Created SSIS Packages using SSIS Designer for
export heterogeneous data from various text files, Excel Spreadsheet to SQL Server 2008 R2/2012.
. Experience in Extracting, Transforming and
Loading (ETL) data from Excel, Flat file to MS SQL
Server by using SSIS services.
. Designed and developed SSIS (ETL) packages to
validate, extract, transform and load data from
OLTP system and CSV Files and load into staging
tables and further those loaded into the warehouse
. Involved in migration of DTS Packages (2000) to
SSIS (2008) and troubleshoot migration issues
. Experience in creating SSIS packages using
different type's task and with Error Handling.
. Designed SSIS Packages to extract, transfer,
and load (ETL) existing data into SQL Server from
different environments
. Experience in creating complex SSIS Packages
with error handling using control and dataflow
elements.
. Optimization of procedures and queries.
. Migrated DTS packages and SQL Server 2005
packages to SQL Server 2008 R2
. Weekly work updates given to manager
Environment: MS SQL Server 2000,2005/2008 R2,
Management Studio, BI Suite, DTS, Data Modeling,
VB.NET,C#, OLAP, OLTP, T-SQL, ETL-SSIS
Client: UPS Capital, Atlanta,
GA
April 2014 to October 2014
ETL (SQL/ Data Manager/SSIS)
Developer/Production Support
UPS Capital, the financial
services business unit of United Parcel Service, offers traditional and non-
traditional financial services and insurance products
Responsibilities:
. Created joins and sub-queries for complex
queries involving multiple tables.
. Led the support for all the ETL related
technical issues related to global data warehouse
as well as Logistics (NALS &PALS) datamart
. Generated dynamic stored procedures for the
database development.
. Provided level 2 & 3 ETL support for low and
high priority issue using SSIS and Data Manager
ETL tools
. Created SSIS Packages using SSIS Designer for
export heterogeneous data from OLE DB Source
(Oracle), Excel Spreadsheet to SQL Server 2008
R2/2012.
. Experience in Extracting, Transforming and
Loading (ETL) data from Excel, Flat file to MS SQL
Server by using SSIS services.
. Designed and developed SSIS (ETL) packages to
validate, extract, transform and load data from
OLTP system and CSV Files and load into staging
tables and further those loaded into the warehouse
. Involved in migration of DTS Packages (2000) to
SSIS (2008) and troubleshoot migration issues.
Expert in generating drill down Reports in SSRS
2005/2008/2012.
. Experience in creating SSIS packages using
different type's task and with Error Handling.
. Designed SSIS Packages to extract, transfer,
load (ETL) existing data into SQL Server from
different environments for the SSAS cubes.
. Experience in creating complex SSIS Packages
with error handling using control and dataflow
elements.
. Optimization of procedures and queries.
. Experience in creating complex SSIS packages
using proper control and data flow elements.
. Created SSIS Packages to migrate slowly
changing dimensions. Scheduling the SSIS packages
and Jobs.
. Designed SSIS Packages to extract, transfer,
load (ETL) existing data into SQL Server 2000, SQL
Server 2008 and SQL Server 2005.
. Weekly work updates to client
. Developments and enhancements both in Data
Manager and SSIS
. Documentation for all the work done. The same
being shared with client
Environment: MS SQL Server 2005/2008 R2, Management
Studio, BI Suite, DTS, Data Modeling, VB6, OLAP,
OLTP, T-SQL, ETL-SSIS, ETL-Data Manager, Cognos
Client :Jubilant, Gurgaon,
India
February 2012 to March 2014
SQL BI (SQL/SSIS) Developer
Jubilant Food Works Limited
(the Company) is a Jubilant Bhartia Group Company. The Company was
incorporated in 1995 and initiated operations in 1996.
The Company & its
subsidiary operates Domino's Pizza brand with the exclusive rights for
India, Nepal, Bangladesh and Sri Lanka. The Company is India's largest and
fastest growing food service company,
Responsibilities:
. Analyzed the requirements and selected the
appropriate tables that is to be populated
. Migrated DTS packages from SQL Server 2005 to
SQL Server 2008 as SSIS Packages.
. Involved in migration from SQL Server 2005 to
SQL Server 2008.
. Experience in building and maintaining Data
marts.
. Wrote DTS packages to transfer data from
heterogeneous database & different files format
(Text File, Spread Sheet) to SQL Server.
. Created tables for data warehousing
applications and populated the tables from the
OLTP database using DTS packages
. Materialized views, dimensions and stored
outlines for optimal performance
. Wrote Triggers and Stored Procedures to capture
updated and deleted data from OLTP systems
. Published high-level technical documentation to
set standards, guidelines and best practices for
SQL Server Database Design, Coding Standards,
Periodic Data refresh, across the enterprise
Environment: SQL Server 2000/2005/2006/2008
Enterprise Edition, SQL BI (SSIS), XML, C#.NET,
Oracle.
Client:JDIrving, Canada,
St. John January 2011 to January 2012
SQL BI (SSIS/SSRS)
Developer
Founded in 1882, J.D. Irving, Limited
(JDI) has operations in Canada and the United States. They are a team
of 15,000 dedicated employees, with business units in:
Forestry & Forest, Products
Transportation Shipbuilding & Industrial Marine, Retail, Industrial
Equipment, Construction Services & Building Materials Consumer
Products.
It was a migration project
which had two modules Data Migration and Integration
Data Migration
Requirement was to migrate
the data for some of their companies from older version of JDE to
enterprise one version of JDE through SSIS
Data Integration
To integrate all the data
from third party sources using SSIS based on the business logic shared by
client
Responsibilities:
. Developed SSIS packages using SQL server
integration services version 2005, 2008 and 2012.
. Migrated JDE data from AS400/World soft to JDE
E1using SSIS packages
. Extracted data from heterogeneous systems like FTP
Server, Oracle, SQL Server, XML Files, CSV files
transforming them according to the business logic
and requirements gathered from client.
. Used many SSIS components like Execute SQL Task,
Conditional split, Data Flow Task, lookup,
. Sequence container, for each loop container,
Merge, Merge Join, Union all, Derived column, data
conversion etc.
. Involved in Optimization of SQL Server queries
. Reviewed and worked on Testing of SSIS packages
for the Team
. Proposed solutions to Team for complex client
requirements for the development in SSIS
. Played leadership role from and for the offshore
team on Integration module.
. Interacted customers weekly for sharing the
updates
. Documented design of SSIS packages using Visio
2007, 2010
. Reviewed design documents from peers
. Developed various operational Drill-through and
Drill-down reports using SSRS
. Developed different kind of reports such a Sub
Reports, Chars, Matrix reports, Linked reports
. Used cascaded parameters to generate a report from
two different Data Sets
. Actively involved as part of team for gathering
and analyzing the needs of end user requirement
and system specification.
. Guided team on the development of the requirements
that were received periodically from client
. Worked on scripting with Vb.NET and C# in SSIS
packages.
. Worked with complex T-SQL using SSIS.
. Worked on complex XML files and performing XSLT
operations through Script as well as XSLT
transformation.
. Created Stored Procedures, Triggers, Functions,
client specific Views for the Application.
Extensive testing on the Performance of the Stored
Procedures.
. Optimized SQL queries for efficiency and provided
queries and procedures for the front-end
application.
. Imported and exported data to and from various
heterogeneous sources using various techniques
like DTS.
. Extracted data using SSIS from OLTP to OLAP.
. Created ad-hoc queries and reports as requested
and provide on-going analytical support for these
requests.
. Migrated DTS packages from SQL Server 2000 to SQL
Server 2005.
. Used various advanced SSIS functionalities like
complex joins, conditional splitting, column
conversions etc. for better performance during
package execution.
Environment: SQL Server 2005/2008, OLAP, OLTP, MS
Excel, Visio 2005/2007, C#.Net, DTS, T-SQL, SSRS 2008
Client: Vestergaard Frandsen,
Mumbai,India
January 2009 to December 2010
MS SQL (SSIS) Developer
Vestergaard is an
international company dedicated to improving the health of vulnerable
people, most of who live in developing countries.
Responsibilities:
. Installed and configured SQL Server 2005
successfully
. Used the concepts of priority constraints,
looked up tables to validate data while dealing
with SSIS
. Developed and scheduled the SSIS packages to
perform the ETL tasks like creating a
datawarehouse
. Troubleshot SQL database transaction log files
related issues
. Performed ad-hoc analysis and reporting
. Generated daily, weekly and monthly reports for
the managers using Excel
. Developed and implemented the SQL Server
Integration Services (SSIS) packages to populate
the data into the Enterprise Data Warehouse from
various sources like Flat File Source, Excel
Source into OLEDB Destination (SQL Server)
. Transformed data from various data sources
using OLEDB connection by creating various DTS
packages
. Created SSAS cube and generated SSRS reports
out of it
. Client handling through calls and emails
independently
. Timely documentation on the work and to be sent
to client
. Client handling through calls and emails
independently
Environment: SQL SERVER Integration services, MS SQL
Server 2005 Enterprise Edition, T-SQL, MS Office
2003, MS Excel and Windows XP
Client:Systime Computer
Corporation, Mumbai,India
June
2008 to December 2008
C# Developer/ Programmer
SYSTIME Computer Corporation
provides systems integration and consulting services. Its solutions include
accounts payable process automation solutions that help customers to
identify
areas of improvement in the
accounts payable process; and invoice processing solutions. The company
also provides VersaPOS, an end-to-end retail management solution developed
for retailers.
Requirement was to develop web
application for resource management and analysis of metrics associated with
resources management operations, also integration between SRMS database
with
project management tool
PSA, reports and dashboards through SSRS 2008.
Responsibilities:
. Gathered requirements from the Resource
Management Group/RMG for developing the website
. Extensive use of C#.NET and ASP.NET to create
web pages using SQL SERVER 2008 as a backend
. Extensive use of AJAX controls to embed advance
features on the webpage
. Unit Testing, Integration testing to ensure
website works as expected
. Created OLTP design, establishing logical and
physical design for sql server data tables
. Created relationships therefore creating a Data
Model, Created tables and view
. Created SSAS cube so that the reporting can be
done on this cube.
. Developed reports in Cognos with meaningful
information that an end user would like to see
about the resource, Resource project allocation,
Project release etc.
. Developed various operational Drill-through and
Drill-down reports using SSRS
. Developed different kind of reports such a Sub
Reports, Charts, Matrix reports, Linked reports
. Created parameterized Reports
. Actively involved as part of team for gathering
and analyzing the needs of end user requirement
and system specification.
Environment: Windows XP, C#.NET, ASP.NET, MS SQL
Server 2008, SSRS 2008
Contact this candidate