Ankur Singh

Email: acgcbb@r.postjobfree.com Phone No: 619-***-****

5+ years of experience in developing Data Warehouse, ETL and Business Intelligence solutions using

Microsoft SQL Server 2000/2005/2008.

DESIGN AND T-SQL

• An expert in data analysis, data designing, data mapping, data quality, business and MDR (Minimum

data requirements) gathering, Technical Specification writing, project management.

• Initiated JRD/JAD sessions with different Auditors, Business Users to capture and document the

BRD and transform the relevant /approved BRD into SRS and FRS.

• Experience in designing OLTP Relational Schema and performing Normalization up to 3NF.

• Excellent experience creating complex Stored Procedures, Functions, Triggers, Views and other

database objects to support the applications.

• Used deterministic and non-deterministic functions like Cast, Convert, IsNull, Dateadd, Datediff,

Checksum, Getdate, Identity etc. to enhance the functionality of my T-SQL code.

• Hands-on knowledge of T-SQL optimization techniques such as SQL Profiler, Database Tuning

Advisor, various types of Indexes and Indexed Views and analyzing Execution Plans.

• Proficient in advanced querying techniques like Pivots, CTEs, and Ranking Functions etc.

• Created DML triggers to audit the new transactions that will be loaded in increments to the relational

data warehouse as well as DDL triggers as constraints in several databases ensuring their integrity and

synchronization with the overall system.

• Used SQL Server Agent for scheduling jobs and sending failure notifications.

DATA WAREHOUSE/ BUSINESS INTELLIGENCE

• Good experience in creating ETL strategies for extracting, profiling and loading data form

heterogeneous sources into destination.

• Proper understanding of Star Schema dimensional design.

• Used different tools like SSIS, BCP and BULK INSERT for ETL.

• Extended SSIS packages by creating custom functionalities with Scripts Task using .Net.

• Utilized SCD, Merge, Lookup, Derived Column, and data conversion transformations in SSIS.

Developed SSIS packages using Master Child packages and involved in optimizing packages. Set up

transactions, loggings, event handlers and checkpoints to handle errors.

• Deployed SSIS packages using configurations such as XML and SQL Server configuration.

• Used proper SCD method to maintain history in warehouse with SCD transformation, merge and

look up transformation.

• Modified attribute hierarchies within SSAS for accurate reporting purposes.

• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill

down reports using SSRS 2005/2008.

• Set up schedules for push and pull delivery methods for reports using Subscriptions in SSRS.

• Formatted reports for various visual representations using conditional formatting and templates.

• Creating reports from cubes using MDX queries.

WORK EXPERIENCE

Bally Technologies Inc., Las Vegas, NV November’2012- July’2014

Software Engineer II

Bally Technologies, Inc. is a manufacturer of slot machines and other gaming technology based in Las

Vegas, Nevada.

The company was founded in 1968 as Advanced Patent Technology. It eventually changed its name to

Alliance Gaming and acquired, in 1996, Bally Gaming International, a formal division of Bally Manufacturing.

In 2006, the entire company adopted the bally name, a trademark that originated in 1932 by the Bally

Manufacturing Corporation.

RESPONSBILITIES

• Installing Data warehouse for different clients and provide maintenance support to them.

Created multiple complex queries for the data profiling and auditing purposes.

• Creating and deployed SSIS packages using various Transformations such as Multicast, Merge Join,

Lookup, Created and maintained star schemas following the best design practices in the industry to

assure the effectiveness and consistency of the design.

• Extensively involved in creation, development and deployment of various Database objects like

Stored Procedures, Triggers, Indexes, Views and User Defined Functions in SQL Server 2008

according to the front-end application needs.

• Optimized several stored procedures using SQL profiler for report latency and fast delivery access.

Created various views and materialized views that will be accesses by both the end users and the

database administrators.

• Created SSIS packages for loading data from various heterogeneous sources, cleaning data and

populating the data marts.

• Created various complex stored procedures for ETL as well as maintenance of the database.

• Created hierarchies and aggregates that will optimize the analysis against the cubes by either

creating set-count aggregations or Usage based aggregations.

• Good knowledge of proactive caching in automatically updating the large sized cubes using different

options.

• Scheduled and monitored various jobs using the SQL Server Agent like package execution and cube

processing as well as notification associated with each process.

• Responsible for creating, populating and optimizing the cubes using SSAS and SSMS.

• Using VB Scripts to filter data based on dates and then extract data from various sources.

• Using MDX queries to create reports.

Principal Consulting Inc, Dallas, TX September’2012- October’2012

BI Developer/ Data Analyst

RESPONSBILITIES

• Directly contacted with client and collected the business requirements.

• Read VB codes and migrated VB jobs into SSIS packages.

• Took in charge the whole SSIS package design and development.

• Use Integration Server Catalogs to manage and execute Integration Services packages.

• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to

data warehouse databases and data mart databases.

• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS

transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived

Column.

• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.

Worked as a developer in creating complex Stored Procedures used in SSIS package.

Tempur-Pedic Inc., Lexington, KY November’2011- April’2012

BI Developer/BI Support

Tempur-Pedic International, Inc. engages in the manufacture, marketing, and distribution of bedding products

worldwide. Its products include pillows, mattresses, and adjustable beds, as well as various cushions and

other comfort products. The company markets its products through furniture and bedding, and specialty

stores, as well as department stores; direct response and Internet; chiropractors, medical retailers, hospitals,

and other healthcare markets; and third party distributors. Tempur-Pedic International sells its products under

TEMPUR and Tempur-Pedic brand names. The company was founded in 1989 and is based in Lexington,

Kentucky.

RESPONSBILITIES

• Involved in identification of all the stakeholders and held extensive conversations with Subject Matte

Experts to understand data and business logic

• Involved in gathering business requirements as endeavor that will facilitate the planning and the

implementation phase of a data warehouse.

• Created complex stored procedures, indexes, views, functions, and triggers on creation and

optimization to improve response time and to enforce business requirements through T-SQL.

• Involved in performance tuning, query optimization, database optimization and maintaining data

integrity with complex TSQL scripts and implemented business rules.

• Developed SSIS Packages to extract, transform and load data from heterogeneous sources like flat

files, Production SQL Servers (2005) and oracle servers into SQL Server 2008 Staging Database.

• Identified and tracked the slowly changing dimensions, heterogeneous Sources (SQL Server, flat

files, excel, access).

• Used proper error handling techniques like logging, checkpoints, and event handler etc. to handle

errors in the packages.

• Created complex SSIS packages (Master-child) with properties like package configurations, SSIS

loggings as well as custom loggings (using event handlers).

• Proper optimizing techniques like parallel execution, buffer usage, checkpoints, optimized query

used for optimizing the packages.

• Worked on Optimization and Debugging of ETL packages at Control Flow and Data Flow level along

with making proper use of transactions and checkpoints.

• Developed SSRS Reports like drill through reports, drill down reports and parameterized reports.

Scheduled several reports to be delivered to multiple users and subscribers in several intervals as well as

forms like Excel, PDF and Text.

• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that

generate them.

• Using VB script to get connection details from configuration database and also used in script task to

refresh excel file and email it on daily basis.

PROJECTS AT TEMPUR-PEDIC

Direct Costing Phase 1:

There are five stages in creating mattress here and each stage has material cost, direct labor cost, fixed and

variable overhead costs. All data has been entered into access databases through different forms. I was

involved in creating SSIS package, which has all the stages with proper business rules implementation. And

also I was also the part of support team to troubleshoot the errors that comes into package.

SSRS Reporting (CRM-SSRS Reports):

I was responsible of creating different simple and complex SSRS reports. In one of the report there was a

requirement of having all the countries in drop down menu and user can only see data only of that country

which he has access to. The tough part was data was coming from CRM and for that I had to deal with two

types of security permission, one from SSRS side and another from CRM side. And also the report

requirement was very complex to implement.

TimeXtender Temur-Pedic Projects:

I have also worked on TimeXtender tool. This is a tool, which is used to create data warehouse and cubes. I

was involved in the support team. My work is to solve issues come in TimeXtender, the users who are facing

problems to solve them. If package fails, then finding the actual cause and solve them, adding new tables

into warehouse etc.

MS Excel Reporting:

I was involved in creating pivot table directly from data and cubes, and after that according to requirement

creating reports for domestic and international users. These reports have proper security, we have given

security through stored procedure as we have different users in different countries and we have to give

access to users only to their related data so that cannot access other users’ or country related data.

MS Excel Training:

I was assigned to give proper training on Excel pivot tables from very basic to advanced level like how to

create pivot table till dynamic linking, ranking charts etc. The reason behind this training is to train different

country users so that they could easily create pivot reports by their own instead of sending small

requirements to developing team.

Dynamic AX Cube processing and SSRS reports:

I have also started working on dynamic AX SSRS simple reports. Also I am responsible for processing AX

cubes whenever needed so that users can see updated data.

Epiq Systems, Portland, OR May’2011-October’2011

SQL Developer/ETL Developer

Epiq Systems is a leading provider of integrated technology products and services for the legal profession.

Our software applications and Web-based platforms offer case management and document management

solutions for electronic discovery, legal notification, claims administration, and controlled disbursement.

Worked with the clients and Business analysts for requirements gathering, business analysis,

•

testing, and metrics and project coordination.

Used complex data transformations and tasks in all the SSIS packages.

•

Used SQL Server Agent to schedule Packages into Jobs as well as T-SQL queries.

•

Implemented the Master/Child Package Model so that only the Master Package has to be scheduled

•

which will in turn fire the other packages, using SSIS 2008.

Involved in Mass Updates in different databases using transactions.

•

Implemented various business rules and name exceptions according to need in different stored

•

procedures for paper and web claims.

Performed Unit testing and System Testing of SSIS packages. Documented the entire SSIS Process.

•

Promoted SSIS packages from Test Environment to Production Environment by maintaining multiple

package configurations in SSIS.

Designed, developed and deployed Reports using SSRS 2005/2008.

•

Formatted reports by applying parameters, and assigned parameter defaults and data types.

•

Optimized reports by optimizing the embedded queries, or optimized the stored procedures that

•

generate them.

PROJECTS AT EPIQSYSTEMS

Bottom Line Invoice System:

I created the invoice system using SSIS in which I had to import text files from a FTP server into specified

location. After that I had to put those files into folders based on their names. I had to generate folders for

them automated. Then I had to take images for related folders, put them into folders and zipped them

together. I used 7-zip software for that.

Huntington Bank Automated System:

Here in this project I had to create an automated system in which I had to pull files (text files) from one

location and grab all the information from those files into our database. Each file had thousands of records,

which come on daily basis. Every file has string so first I had to create stored procedure to extract each

person’s information and then create archive table also to review latter in case. I also schedule my package

3 times a day.

Farmers Med Pay Paper & Web Import:

People file their claim via paper and web. My job was to create imports for both paper and web, which was

based on specific business requirements of my client, and I was also responsible for name exception

handling and business matching rules. These imports are used to match the details of claim holder from

existing database of client or not and then import all the details of claim holder into specified tables in Dbs.

Mass Updates on Daily Basis:

According to need of the client’s requirements I had to do mass update in the existing databases

with the help of transactions so that even if update fail, it do not make the server down.

Visesh Infotecnics Ltd., New Delhi, India July’2007-June’2008

Software Trainee

Interacting with client and requirements gathering and design the application to

•

meet the user’s requirements documents.

Responsible for quality assurance of finished websites including the validation

•

of links and web forms.

Assist the documentation team and deliver new product to client.

•

Analyzed SQL Server2005 databases to determine needed data.

•

Implemented reports and report request forms for use on the Web.

•

RevOs Pure Ltd., Noida, India October’2006 –June’2007

SQL Intern-Trainee

Gathered specifications and requirements prior to the system testing

•

Involved in writing the test cases for testing and perform system testing.

•

Used Test Director for analyzing defects, reporting and tracking.

•

Used SQL to perform backend testing on databases.

•

VSNL, New Delhi, India July’2006 – Aug’2006

Intern-Trainee

This 6 weeks training provided me with my first industrial exposure on software

•

development life cycle.

Also I came to know about implementation of formal software quality assurance

•

processes and methodologies, including integration with overall development

processes.

I learned about functionality, compatibility, reliability, performance, security and

•

related testing of a variety of web-based applications, from static web sites to complex

interactive web applications incorporating multiple front and back end

database/web/internet technologies, application design and testing for web-based bug

tracking system.

OTHER PROJECTS

Project Management System

• Created a project management system to maintain different kinds of projects in a

company using PHP, database made by MySQL.

• Multiple Users can modify different sections of projects.

• Respective teams can keep track of their project life-cycle and development.

• Bugs were reported and dealt with, using interactive forum.

Shopping Mall Database

• Created a computerized system to maintain data and records of a shopping mall.

• System kept track of incoming and outgoing inventory stock.

• It acted as metadata for another employee database for respective stores in mall.

:

Technical Support

Front –End - PHP

o

Back –End - SQL Server 2005

o

Hospital Patient’s Database Management System

• Created a project is used to maintain the records of hospital’s employees and Patients.

• This project kept track of the treatment cycle according to the priority of the case.

GIS- Banks of San Diego

• This project was developed to locate the banks of San Diego on its map with their

attributes.

• Two banks can be selected simultaneously to calculate the distance between them.

• Pop-up was created that provided details of a bank like address, phone number, street

view image etc. on clicking the bank on the map.

• I used MOJO20 and Java Swing.

SOFTWARE SKILLS

Programming Languages C, C++, C#, Perl basic

Web Technologies HTML, PHP, CSS, Java Script

Databases SQL Server 2005/2008, MySQL, MS Access

Software Development tools Eclipse, Net beans

Other Software’s Adobe Photoshop, Dreamweaver

Platforms Windows XP/Vista/7

Network related software FTP, SSH

Tools and Reporting SSIS, SSRS, SSAS, TFS 2008/2010, MS Excel, TimeXtender

EDUCATION

• SAN DIEGO STATE UNIVERSITY, USA

Master of Science in Computer Science- GPA: 3.2

• UTTAR PRADESH TECHNICAL UNIVERSITY, INDIA

Bachelor of Technology in Computer Science – GPA: 3.7

Contact this candidate