Sql Server Data

Location:

Bridgewater, NJ

Posted:

July 23, 2012

Contact this candidate

Resume:

Aarti Kekade

******.***@*****.***

Employer details: Ronald,973-***-****,*******@**********.***

Professional Summary:

7+ years of administration, design and development experience in SQL server 2008/2005/2000

system in OLTP and OLAP environment.

5 years of experience in SSIS, SSAS and SSRS of MS SQL Server.

Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.

Highly expert in translating Business System Design document into technical design document

Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.

Experience in scheduling SSIS packages using SQL Server Agent.

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

production server.

Proficient in implementing all transformations available on the SSIS toolbox.

Excellent knowledge of using variables and expressions in SSIS packages.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views,

User defined data types, Cursors and Indexes using TSQL.

Experience in writing complex TSQL queries using Inner, Left, Right, Outer and Cross Joins.

Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential

Integrity by using Triggers and Primary and Foreign Keys.

Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions,

hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing

dimension etc.

Expertise in creating various type of reports such as Complex drill down & drill through reports,

parameterized reports,Matrix reports, Sub reports and Charts using SSRS based on Relational

and OLAP databases.

Expert in dimensional data modeling, and cube development, partition, aggregation and

optimization using SSAS.

Excellent command in deploying analysis projects using SSAS services.

Successfully performed SCD transformation and deployed SSIS package with security.

Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of

Relational database modeling and Dimensional database modeling concepts with star schema

and snowflake schema design and implementation.

Experience in performance tuning of TSQL, SSIS Packages, SSRS Reports and SSAS cubes.

Excellent communication skills, exceptional versatility and adaptability, a strong team player with

an ability to take new roles, hardworking and fast learner.

Good skills with computer science concepts, analytical skills and programming.

Education Qualifications:

Bachelors in Engineering and Technology, India

Skillset:

Sharepoint MS-SQL Server 2008/2005/2000, MS Access, T- SQL, PL/SQL, SQL server Reporting

Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), DTS,

1 Page

SQL Server BI Development Studio (BIDS), Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Autosys, Windows

98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, MS Office 2007/2003

C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET, MS Visual Studio 2008/2005.

Projects Summary:

Genpact Solutions Pvt Ltd, NY 7/2011-Present

MS SQL Server Developer/SSIS

Genpact, a global leader in business process management services, is a company of choice for clients,

partners and employees all over the world. Genpact smart enterprise processes (SEP) framework leads

to superior business outcomes.

Project was Designing ETL to populate data warehouse, importing data from various sources like flat

files, excel files, .xml files then cleaning and scrubbing of data, adding validations to the data using

SSIS,loading data to staging and then to data warehouse.

Hardware/Software:

MS SQL Server 2008, MS SQL Server Integration services 2008(SSIS), XML, T-SQL, MS Visio, Windows

XP.

Responsibilities:

Developed ETL packages using SQL SSIS to migrate data from various sources into SQL Server

2008 database.

Created SSIS packages using advanced tools (pivot transformation, derived columns, conditional

splits, term extractions, multicasting)

Used SQL profiler for troubleshooting, monitoring and optimizing of SQL Server

Loaded Excel files into stage tables by using Bulk Copy Program BCP and SSIS packages.

Successfully deployed SSIS packages with defined security.

Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup

transformations to validate the data.

Involved in package configuration to make the packages dynamic for successful execution of

packages in development and production environment.

Implemented data views and control tools for guarantee data transformation using SSIS.

Responsible to monitor performance and optimize SQL queries for maximum efficiency.

Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and

tuned them such that they perform well.

Used advanced features of T-SQL in order to design and tune T-SQL to interface with the

database and other applications in the most efficient manner.

Created stored procedures for the business logic using T-SQL.

Involved in performance tuning of SSIS Packages .

Zef Scientific Inc, MA 7/2010 to 6/2011

MS SQL Server Developer/SSIS/SSRS

2 Page

Zef Scientific is a premier independent engineering and scientific organization specializing in maintenance

and service of the crametography and mass spectrometry.

Because of company's growth and so growth of database that was 4.3 TB with 85 servers Zef scientific's

increased requirements moved to 2008 version having good and enhanced feature.

As a part of development team my role was to create reports according to business requirements using

SSRS tools and populate the data warehouse using SSIS.

Hardware/Software:

MS SQL Server 2008/2005, MS SQL Server 2008 Reporting Service2008, Business Intelligence and

Development System 2008, T-SQL, Erwin, MS-Office, MS Visio, Windows XP, SharePoint SSRS

Responsibilities:

Participated in meetings and interactions with users, team lead, DBAs and technical managers to

fully understand the requirements of new system.

Involved to write complex T-SQL queries and Stored Procedures for generating reports.

Worked on SSIS to import the data from different format.

Responsible for creation of new database objects like stored procedures, tables, view, triggers,

function according business logics.

Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup

transformations to validate the data.

Loaded flat files into stage tables by using Bulk Copy Program BCP and SSIS packages.

Scheduled database jobs for automation of DBA tasks.

Partitioned large tables1.2 million rows tables using range partition.

Performed data extraction from OLTP to DW for decision making using SSIS.

Defined report layouts and wrote queries for drill down reports and identified and included report

parameters using SSRS.

Developed complex reports and provided to business people for further analysis.

Developing various simple to complex reports using SSRS, share report with the help SharePoint.

Identified various data sources and established connections between source and the target using

SSIS based on the required reports.

Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in

application.

Generated plan for developing processes, automation of maintenance jobs, tuning SQL Server,

locks and indexes configurations.

Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server

backup strategy and automation.

Provided support to the application developers on the application databases.

Worked on linked servers to run distributed queries between SQL server and other data sources

like excel using ODBC, OLE DB Drivers.

Qualifacts Systems Inc, Nashville, TN 08/2009 – 06/2010

MS SQL Server Developer/SSAS/SSIS

Qualifacts is the largest provider of Software-as-a-Service and web-based Electronic Health Records for

the behavioral health and human services market.

3 Page

Project was Designing ETL to populate data warehouse for microstrategy reporting, importing data from

SQL Server database and make them incremental, cleaning data and adding validations to the data

using SSIS,perform reporting and deployment, Creating cubes using SSAS for reporting purpose.

Hardware/Software:

MS SQL Server 2008/2005, SSAS 2008,SSIS 2008,T-SQL, VB.

Responsibilities:

Designed a complex SSIS package for importing data from SQL Server 2005.

Implemented data views and control tools for guarantee data transformation using SSIS.

Extensively worked on SCD transformation in SSIS package.

Successfully deployed SSIS packages with defined security.

Developed logical database and converted into physical database using Erwin.

Proficiently created Reports based on the requirements using SSRS 2008.

Involved to write complex T-SQL queries and Stored Procedures for generating reports.

Defined parameters for parameterized Reports using SSRS.

Designed and developed various Service Management Reports, utilizing Dynamic and Cascading

Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using

SSRS 2008.

Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using chart

experts for BI needs.

Successfully worked with Report Server and configured into SQL Server 2008.

Created Batch files to run the script in development, production environment.

Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained

the data.

Extensively worked with OLAP cubes to generate drill through reports in SSRS.

Designed MDX queries in accessing cubes and hands-on experience in query structuring,

performance optimization.

Responsible to monitor performance and optimize SQL queries for maximum efficiency.

Proficiently scheduled the Subscription Reports with the Subscription Report wizard.

Involved in the analysis, design, development, testing, deployment and user training of analytical

and transactional reporting system.

Tuned SQL queries using execution plans for better performance.

Created Query for ad hoc Reports and Users design Custom Queries.

Analyzed reports and fixed bugs in stored procedures.

Dow Jones and Company,South Brunswick,NJ 04/2008 -07/2009

MS SQL Server Developer / SSIS

Dow Jones & Company is an American publishing and financial information firm. Dow Jones offers

business and financial information to the individual reader around the globe. Its publications and

Web sites are some of the best known and most respected brands, regularly engaging more than

42 million readers worldwide.

The project was about importing data from different services like Wall Street Journal, Smart

Money, and Market Watch etc. in the form of flat files and XML files, Data cleansing and

Scrubbing, creating packages using DTS and storing the refined data into Data Ware House.

Hardware/Software:

4 Page

MS SQL Server 2008, SSIS 2008, T-SQL

Responsibilities:.

Carried out a Developer’s role on SQL (using SSIS, T-SQL, Stored Procedures and

Views).

Used ER-win, Normalization, Dimension Modeling and Enterprise Manager for Logical

and physical database development.

Imposed Referential Integrity of data by creating different constraints.

Migration of the data from text files to Oracle database and SSIS packages for the

processing of different policies.

Managed all indexing, debugging, optimization and performance tuning

Created stored procedures,triggers and functions for the business logic using

PL/SQL.

Performed coding of several database triggers and stored procedures and maintained

integrity constraints.

Designed and developed Data Transformation Process.

Successfully performed SSIS packages and scheduled them.

Used advanced features of PL/SQL in order to design and tune PL/SQL to

interface with the database and other applications in the most efficient manner.

Effectively used views to prevent unauthorized access in Oracle.

Managed performance and tuning of SQL queries and fixed the slow running queries

in production

Created numbers of complex formula in sub report using different type of variables

likes shared variable and retrieved them from master report.

Built and performed user acceptance testing on new and modified reports.

Designed and Implemented the Stored Procedures and Triggers for automating tasks.

Market Axess, NY 3/2007– 03/2008

MS SQL Server Developer/SSAS/SSIS

Market Axess gives investors a single trading platform with easy access to multi-dealer

competitive pricing in a wide range of credit products.

Project was Designing ETL to populate data warehouse for microstrategy reporting, importing

data from SQL Server database and make them incremental, cleaning data and adding

validations to the data using SSIS,perform reporting and deployment, Creating cubes using

SSAS for reporting purpose.

Hardware/Software:

MS SQL Server 2005, SSAS 2005, SSIS 2005,T-SQL, VB.

Responsibilities:

Designed a complex SSIS package for importing data from SQL Server 2005.

Implemented data views and control tools for guarantee data transformation using

SSIS.

Extensively worked on SCD transformation in SSIS package.

Successfully deployed SSIS packages with defined security.

5 Page

Developed logical database and converted into physical database using Erwin.

Proficiently created Reports based on the requirements using SSRS 2008.

Involved to write complex T-SQL queries and Stored Procedures for generating

reports.

Defined parameters for parameterized Reports using SSRS.

Designed and developed various Service Management Reports, utilizing Dynamic and

Cascading Prompts, sub-reports, charts, parameterized reports, conditional and

dynamic reports using SSRS 2008.

Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by

using chart experts for BI needs.

Successfully worked with Report Server and configured into SQL Server 2008.

Created Batch files to run the script in development, production environment.

Developed a multi-dimensional database and OLAP cube using SSAS that stored and

maintained the data.

Extensively worked with OLAP cubes to generate drill through reports in SSRS.

Designed MDX queries in accessing cubes and hands-on experience in query

structuring, performance optimization.

Responsible to monitor performance and optimize SQL queries for maximum

efficiency.

Proficiently scheduled the Subscription Reports with the Subscription Report wizard.

Involved in the analysis, design, development, testing, deployment and user training of

analytical and transactional reporting system.

Used stored procedures, wrote new stored procedures and triggers, modified existing

ones, and tuned them such that they perform well.

Tuned SQL queries using execution plans for better performance.

Optimized by assigning relative weights to the tables in the Catalog and Query

Performance.

Used Query for ad hoc Reports and Users design Custom Queries.

Analyzed reports and fixed bugs in stored procedures.

KPIT Cummins Infosystems Ltd., Pune, India 02/005 – 02/2007

MS SQL Server and BI Developer

This is a software consulting Services Company that specializes in various areas like IT services, Product

Design services, Business Process Outsourcing etc.

The project is primarily aimed on tracking down the information of various customers and type of plans at

different locations. Worked with data warehouse and designed and implemented enterprise reports for

end users and management group. Organized database from different firm sources to a single destination

like SQL Server 2005.

Hardware/Software:

MS SQL Server 2005/2000, MS SQL Server 2005 Reporting Service, MS SQL Server Integration

Services 2005, BIDS, Erwin, T-SQL, Windows XP.

Responsibilities:

Created database objects like tables, views and indexes.

Created and modified stored procedures, triggers and cursors.

Resolved any deadlocks issues with the Databases/Servers on a real-time basis.

6 Page

Formulated and documented the physical ETL process design based on business requirements

and system specifications with strong ETL design skills, including source to target mappings,

transformations, lookups, aggregations, expressions.

Created packages in SSIS with error handling as well as created complex SSIS packages using

various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column

conversion, fuzzy grouping, script components

Involved in deploying SSIS packages for various environments.

Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Implemented logical and physical database modeling using Erwin tool.

Designed and implemented complex SSIS package and scheduled it for OLAP to satisfy BI

requirements using SSAS.

Successfully implemented SCD transformation in SSIS and performed security.

Archived and restored data warehouse database.

Provided technical guidance and support to end-users by developing documentations required.