Rajkumar

732-***-****

acn6aa@r.postjobfree.com

SUMMARY:

• Over 9 years of experience in MS SQL Server 2012/2008R2/2008/2005/2000, T-SQL, SSIS / DTS, SSRS, SSAS,

Database Migration and Physical/Logical design

• Very Strong in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Analysis

Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

• Worked on User requirement gathering directly with the USERS and also with the Business Analyst to creates

various Reports, Packages and to work on the data

• Expertise in ETL tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS),

Embarcadero DT/Studio, SPSS, Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment

• Experience with T-SQL, DBCC, DCL, DDL, DML, Stored procedures, Indexes, Views, Synonyms, Joins, Sub

queries, CTE's, Derived Tables User defined functions Scripts and established relationships between tables using Primary

Keys & Foreign Keys

• Expertise in Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleansing and

Standardizing data loaded into OLTP and OLAP databases using SSIS

• Experience in working with version control tools such as subversion control (SVN), Microsoft Visual

Source Safe, Team foundation server (TFS)

• Experience with SSIS performance tuning using counters, error handling, event handler, re-running of

failed SSIS packages using checkpoints and scripting with Active-X,C# and VB.NET in SSIS and Java in

DT/studio

• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report)

form, Conditional, List items, Charts and Sub reports

• Expertise in generating reports using Performance Point Server, Crystal Reports, SQL Server

Reporting Services, BO and Excel spreadsheet

• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database

triggers using tools like SQL profiler, and database tuning Advisor (DTA)

• Experienced with designing Dimensional Model using Star Schema and Snow Flake Schema for Data

Warehouse, SSAS cubes, Fact and Dimension Tables, Data Mining and deploying and processing SSAS

Objects

• Experienced in MS Analysis Services (SSAS) programming for Data Warehouses (Schemas), Proficiency

in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon surrogate key

assignment and CDC (change data capture)

• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical,

troubleshooting, and problem solving skills

CERTIFICATION:

Microsoft Certified Technology Specialist (SQL Server 2005)

EDUCATION:

Bachelor’s Degree in Electrical and Electronics Engineering

TECHINICAL SKILLS:

T-SQL, PL/SQL, C, C++, Java, JavaScript, HTML, XML, COBOL

Languages

MS SQL Server 2012/2008R2/2008/2005/2000, MS Access, Oracle 9i and

RDBMS

10g

SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence Studio, Erwin Data

Database Tools

Modeler, Query Analyzer, SQL Server profiler, Enterprise Manager

Windows 98/2000/XP/NT/Vista, Windows 2000/2003 Servers, Mac, UNIX

Operating Systems

Relational DBMS, Client-Server Architecture, OLTP, OLAP

Architecture

SVN,TFS, Visual Source Safe

Version control

Tools

Crystal Reports, BO

Other Tools

PROFESSIONAL EXPERIENCE:

United Postal Service (UPS), Atlanta, GA Jun 13 – Current

Role: Developer/Business Intelligence Consultant

Revenue per plane is the global network marketing tool that will enable UPS to bring visibility to the quality and mix

of revenue flying on brown tail. Primarily, small package, cargo, GFF and USPS fly on Brown tail.

It is also responsible for the detection of anomalous pattern, trend in various kinds of data e.g. lost packages, sales in a particular

location or region etc. and report to the concerning region managing directors and managers.

Responsibilities:

• Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping

• Experience working with Freight and Small Business data

• Extensive experience working with T-SQL involving the development of complex queries, stored procedures, views,

triggers, CTE's, and user-defined functions

• Designed and developed efficient dynamic SSIS packages for processing Fact and Dimension tables with complex

transforms and using Procedures

• Used various SSIS tasks such as Conditional Split, Derived Column, Script task for data scrubbing, and data

validation checks during staging

• Developed ETL SSIS packages to load data into databases using various SSIS tasks like Execute SQL Task, Bulk Insert

Task, Data Flow Task, File System Task, Send Mail Task, Loop Container Task, and Active Script Task

• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages

• Involved in daily batch loads (Full &Incremental) into Staging and ODS (Operational Data Source) areas, troubleshooting

process, issues and errors using SSIS

• Experience working with Growth Volume and Revenue data

• Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Succeed

• Involved in SSIS Performance Tuning Using Counters, Error handling, Event handling

• Used SQL Profiler for debugging issues, performance tuning whenever necessary

• Responsible for logical and the physical design of the data mart

• Experience working with data sources such as Microsoft SQL Server, Access, Cubes, Excel Sheets, Flat Files

• Created Cross-Tab, Drill-down and Sub-Report for Monthly and Quarterly data using SSRS

• Created new reports and modified existing SSRS reports

• Designed different types of reports such as drilldown, drill through/Linked, dashboard, sub reports using SSRS

• Extensive usage of Filters, Parameters (Hidden, Multi select, default, null), Expressions, Interactive Sorting, Cascading

in the report designer to make the report flexible and creating drop down values

• Used Images, hyperlinks, Visibility and hidden, Page Breaks features to make the reports attractive and understanding

for the business users

• Built, deployed and uploaded the SSRS reports into SharePoint Report Test, QA servers

• Worked on Cache, Snapshots and Data driven Subscriptions in SSRS Report server

• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint

Environment:

SQL Server 2012 Enterprise Edition, SSIS, SSRS, SSAS,T-SQL, PL/SQL,SQL Profiler, VB.NET, C#, XML, MS Excel, MS Access,

Visual Studio 2010

South Carolina Department of Revenue, Columbia, SC Jan 12 – May 13

Role: SQL Server Developer/System Analyst

Discover Tax (DTAX): It is a robust data warehouse to provide a data to the auditors to review information on tax returns, also

established an extensible and scalable platform that will support additional data sources, compliance solutions, and business

intelligence functionality as new objectives are identified. Created reports and dashboard to analyze the revenue on various programs

Responsibilities:

• Worked on migrating Embarcadero DT Studio packages to SSIS packages

• Used various transformation tasks and containers to create ETL packages and for data conversion

• Created Dynamic packages using SSIS Variables, Scripting, event-handlers and package configurations

• Worked with the Users and Business Analyst on various stages of the Project

• Responsible for Creating and Modifying T-SQL stored procedures, triggers Using DDL, DML for

validating and integrity of the data

• Created SSIS and T-SQL stored procedures to transfer data from OLTP, Flat files to staging area and finally

transfer into Data warehouse and data marts

• Worked on various compliance programs on Tax data for auditing and revenue generation

• Recreated UAT(User acceptance test) environment by migrating data from Production to UAT server using

SSIS and T-SQL procedures

• Responsible for detailed analysis to create the Data Source Requirements for the DT Studio ETL model and

SSIS packages

• Worked on migrating files from SFTP and FTP location to local directories

• Involved in SSIS Performance Tuning Using Counters, Error handling, Event handling

• Monitored and supported Production Jobs

• Involved in requirement gathering to create various SSIS packages to pull the data from different source and

• Involved in migrating the packages to production

• Used Java in embarcadero DT Studio packages and Vb.net in SSIS packages to validate and modify data in

the packages

• Worked with both BO and SSRS environment to deliver data in required format for the Reports

• Worked on BO by doing enhancement to the existing reports and creating canned and Ad-hoc reports

• Worked on migrating reports from SSRS to BO

• Used TFS for the development and migrating various Projects to production

• Imported bulk flat file data source into SQL server data base using Bulk Copy Program

• Worked on the system testing the data loads that are created by other developers

Environment:

SQL Server 2008 Enterprise Edition, SSIS, SSRS, SSAS 2008, Embarcadero DT/studio, Java, .NET Framework, T-SQL,

VB.NET,C#,XML, MS Excel, MS Access, Visual Studio 2008, BO

Massachusetts Department of Elementary and Secondary education, Boston, MA Jun 11 – Dec 11

Role: SQL Server Developer/DBA

SIF (School Interoperability Framework): The project is to implement SIF data model. It is a data sharing open specification for

academic institutions from kindergarten through grade twelve. The specification is composed of two parts: an XML specification

for modeling educational data, and a Service-Oriented Architecture (SOA) specification for sharing that data between institutions.

Responsibilities:

• Worked in a multi cluster multi version SQL Server environment with databases preparing and loading data using SSIS

packages

• Developed various dynamic SSIS packages as per business requirement for importing and exporting student data files from

various sources like Oracle, SQL server, Access database, Flat files to Massachusetts State’s Department of Education (DOE

Server)

• Created functional requirement specifications and supporting documents for data collection on student, teacher, and

school data also to support business systems

• Worked on database design and modeling

• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental

load

• Worked on Event Handlers and Error Handling in SSIS packages and notified process results to various user

communities

• Debugged and created complex stored procedures, Triggers, Views, T-SQL queries, PL/SQL queries and other database

Objects

• Created CDC (Change Data Capture) for tables for capturing the Changed data

• Involved in performance tuning for long running Stored Procedures and SSIS packages

• Used SQL Profiler for debugging issue, performance tuning whenever necessary

• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum

efficiency using SQL Profiler Index Tuning Wizard

• Requirement gathering from users to work on data and creating reports

• Designed, deployed, and maintained various SSRS Reports in SQL Server 2008

• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for Progress Book,

Teacher license, student demographics using SSRS

• Worked on SIF, CEDS, and ED-F data models

Environment:

SQL Server 2008R2 Enterprise Edition, SSIS, SSRS, SSAS 2008, .NET Framework, T-SQL, PL/SQL,VB.NET,C#,XML, MS

Excel, MS Access, Visual Studio 2008

FedEx Corporation, Memphis, TN Jun 10 – May 11

Role: Business Intelligence Consultant /SQL Server developer

The Security Data Research and Analysis group in FedEx Services is responsible for the analysis and forecasting of shipping

volume, missing packages, loss claims etc. for each location, region and different operational-company of FedEx (Express, Ground,

Freight etc. Databases used for storing and querying data are Oracle, Teradata and SQL-Server.

Roles and Responsibilities:

• Under the guidance of the database architects, implemented database designs through SQLDDL Queries to create tables,

views, functions, indexes, triggers and stored procedures

• Wrote various stored procedures and SQL queries for the Claiming, Research of shipping volume data as per business

rules

• Created various dynamic SSIS packages (ETL) to export the Data from Oracle, Teradata, Flat files, Excel to SQL server

OLTP to OLAP and also worked on moving files from SFTP and FTP location to local directory

• Skilled scheduled the jobs to streamline and automate cumbersome repeated tasks using SQL Server Agent

• Implemented Event Handler and Error Handling tasks in SSIS

• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance

of databases

• Implemented Event Handler and Error Handling tasks in SSIS

• Used SSIS Data Profiling Task to analyze data quality for the purpose of application improvement

• Involved and created Dimensional modeling by identifying the fact and dimension tables based on the user & reporting

requirements and for business forecasting process

• Advised optimization of queries by looking at Execution Plan for better tuning of the database

• Used Reporting Service (SSRS) to generate canned reports, parameterized reports, Free form Reports, cascading

reports, dashboard, and drill-down drill-through reports with various charts

• Used SSRS organized reporting services scheduling, creating snapshots and subscription management activities to

deliver the reports to intended audiences including corporate investors and shareholders

• Monitored and Fixed data quality issues in Development, Test and Production Environment

Environment:

SQL Server 2008 R2 Enterprise Edition, SSIS, SSRS, SSAS,T-SQL, PL/SQL, Teradata, SQL Server Query Analyzer, Visual Studio,

Team Foundation Server,, VB.NET,C#,XML, MS Excel, MS Access, Visual Studio 2008

Amdocs, Herndon, VA Apr 08 – May 10

Role: SQL Server Developer/SSRS/ETL/Analyst

Amdocs is a global leader in providing innovative software and service solutions designed to help companies build stronger and

more profitable customer relationships. It has over 23 years of experience in the communications sector; they have a global

experience and expertise and are a recognized market leader in Billing, CRM and OSS. They also provide solutions in the financial

services arena and continue to expand their global market reach.

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures,

Triggers

• Wrote efficient stored procedures for the optimal performance of the system

• Monitored performance and optimized SQL queries for maximum efficiency

• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data

• Created indexed views, and appropriate indexes to reduce the running time for complex queries

• Used VB to create XML web services that interface with SQL server

• To keep track of data manipulations using Audit functionalities

• Identified and worked with parameters for parameterized reports. Responsible for transferring the data using SSIS packages

from OLTP to OLAP

• Generated custom and parameterized reports using SSRS and MDX ad hoc reporting

• Created reports that call sub reports in SSRS

• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and

Graphs

• Responsible for creating datasets using T-SQL and stored procedures

• Created several packages in SSIS

• Scheduled the packages to keep extracting the data from OLTP at specific time intervals

• Used various transformation tasks to create ETL packages for data conversion

• Assisted in the design of star schema and snow flake schema

• Responsible for rebuilding the indexes and tables as part of performance tuning

• Used SQL Server Agent for scheduling jobs and alerts

• Active part in creating cubes from which data can be retrieved rapidly

Environment:

SQL Server 2005/2008 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, C#, ASP.NET, ADO.NET, Erwin, T-SQL,

VisualStudio.NET IDE, Windows 2000/2003 Server, XML, MS Excel, MS Access, Visual Studio 2005

Greenway Medical Carrollton, GA Jan 07 - Mar 08

Role: SQL Server Developer/SSRS/SSIS/SSAS

Electronic Health Record is a web portal for patients to view their medical profile online. This web based project provided patients to

view, change or delete their appointment times. Patients are able to renew their prescriptions and change their insurance

types/carriers online. Patients also have the flexibility to view and save their medical history for the past 5 years. A variety of types

of healthcare-related information may be stored and accessed in a user-friendly easy-to-use manner. This application not only

believed to increase physician efficiency and reduce costs but also promote standardization of care.

Responsibilities:

• Helped in the Installation and configuration of MS SQL Server

• Responsible for developing Stored Procedures, Triggers, Views and User defined functions

• Efficient use of Joins and sub-queries in queries that involve data from multiple tables

• Used Audit functions to keep track of the changes made to the database

• Responsible for design and Normalization of the database tables

• Used Exception handling to catch and report the errors

• Created custom and Ad hoc reports using SSRS

• Generated several drill down and drill through reports using SSRS

• Used DTS packages to implement Extraction, Transformation and Load (ETL)

• Involved in upgrading DTS packages to SSIS packages

• Modified existing SSIS packages to meet current business needs

• Played Active part in the development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and

Troubleshooting

• Had to modify the current stored procedures to meet the current design

• Responsible for creating indexed views, and appropriate indexes to cut the complex query time

• Involved in system testing

• Active part in maintenance of data cubes

• Monitored performance and optimize SQL queries for maximum efficiency

• Identified and defined the Datasets for report generation

• Wrote T- SQL queries for data retrieval

• Took part in the normalization and de-normalization of database

Environment:

MS SQL Server 2000/2005, SSRS, SSIS, SSAS, Business Intelligence Development studio, Visual source safe, Visual studio 2005,

Erwin, C#, MS Excel, MS Access

View Point Bank, Plano, TX Mar 06 – Nov 06

Role: SQL Server Developer/SSRS/SSIS

View point bank is a financial institution that offers mortgage and investment services to personal bankers and small businesses. It

offers three types of accounts like checking, savings and loan account. The customers are allowed to use the banks online services to

access their accounts online to view statements and to perform other transactions like transfer of funds and online payments. The

Bank gives its customers the option of opening the account online and also has the provision of online loan approval. The web

application was developed using ASP.NET as front end and SQL Server as backend database.

Responsibilities:

• Writing T-SQL queries, triggers, functions, cursors and stored procedures

• Migration from SQL Server 2000 to SQL server 2005

• Logical design and Physical design of SQL Server databases

• Monitoring the performance of the scheduled jobs and alerts

• Performance tuning and testing on stored procedures, indexes, and triggers

• Generated reports using SSRS

• Creating Reported for Tax and Audits Using SSRS

• Used SSRS to create drill-down and drill-through reports

• Scheduled jobs and alerts using SQL server agent

• Develop DTS/SSIS packages to extract and transform data

• Used various transformation tasks to create ETL packages for data conversion

• Imported flat files into database by performing Bulk data migration using DTS and SSIS

• Extract and transform data by developing packages using DTS/SSIS

• Connected OLE DB data sources and providers by creating Linked servers

Environment:

MS SQL Server 2005/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Business

Intelligence Development Studio, Microsoft Visual Studio 2005, C#, ASP.NET, ADO.NET, XML

Contact this candidate