Sql Server Data
Resume:
Rajkumar
************.******@*****.***
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