Chandan

Email: acgkns@r.postjobfree.com

Phone: 727-***-****

SUMMARY:

• Around 8 years of experience in MS SQL Server and worked extensively on Integration services (SSIS),

Reporting services (SSRS) and Analysis services (SSAS)

• Created Management Reports through SQL Server Reporting Service on demand.

• Used Query Analyzer, Execution Plan to optimize SQL Queries.

• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate

Triggers to facilitate efficient data manipulation and data consistency.

• Extensive knowledge in T-SQL queries (DDL and DML)

• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP,

Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data

Warehousing and Data Migrations.

• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User

Defined Functions, Relational Database models and Data integrity, and SQL joins .

• Deploy packages to file system and schedule the jobs using SQL Server Agent.

• Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping,

Replication and SQL Server Clustering.

• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index

Tuning Wizard and Database Engine Tuning Advisor.

• Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel

spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the

transformation constraints.

• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL)

solutions for data warehousing using SQL Server Integration Service (SSIS)

• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports

like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.

• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS)

• Experience in creating ETL mappings in Informatica to load data from different sources to different target

databases.

• Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server

Analysis Services (SSAS)

• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models

such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.

• Development Projects in SQL Server and Microsoft.Net.

• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional

Tables and Operational Data Store (ODS)

• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions

effectively and aggressively in challenging environment.

TECHNICAL SKILLS:

OS Windows 2000, Windows Server 2003, Windows server 2008

Databases SQL Server 2008/2005/2000, PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0

Languages C#.Net, VB.Net, XML, ASP.NET, T-SQL

Scripting HTML, XML, Java Scripting, VB Scripting

Languages

Web Tools C#.Net, ASP.Net,VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting SSRS 2005/2008, SSIS 2005/2008

Hardware IIS 6.0/5.0/4.0

Version & Defect Microsoft TFS, MS VSS, Synergy, HP Quality Center & Jira

Control

Others MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio,

Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server

2000/2005 Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows

Scripting Host

EDUCATION:

Bachelors in Computer Science Engineering at K.S. Institute of Technology, Bangalore in 2005.

PROFESSIONAL EXPERIENCE:

State Farm Insurance, Champaign, IL Sep 13 –

Till Date

Sr. SQL Server/ BI Developer

Description: The project was designed and developed to load the data warehouse from different OLTP reporting staging

databases. The "Looping Process" of SSIS packages was scheduled to run on regular basis in order to update data in data

warehouse. The information gathered from these data marts were then used to build a cube for enhancing information

access, enhance analysis process and dynamic report generation on demands.

Responsibilities:

• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel

Spreadsheet, text files into Data Warehouse.

• Various ETL Transformation tools were used for Control Flow and Data Flow tasks

• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008

• Designed and implemented Parameterized and cascading parameterized reports using SSRS

• Created star schema in SSAS and developed SSRS reports based on the cube.

• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database

code as well as T-SQL code from developers and QA.

• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.

• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and

data extraction.

• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved

performance and availability.

• Involved in writing queries for Stored procedures, clustered and non-clustered indexes

• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics,

recompiling stored procedures and performing other maintenance tasks.

Environment: MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text

editor, MS Visio 2005, DTS, SQL Query Analyzer, SQL Developer.

EMC, Southborough, MA Jul 12 – Aug 13

SQL Server/BI Developer

Description: HR-BI is a Human Resource Management System, which is designed to handle the human resource

activities for the organization. It provides information about employee data which starts when applicants apply for job in

the institution. HR-BI also provides information about employee data, new hire, Offer made, Req created, Promotion,

Termination, and Payroll data. The change of certain business rules required development of new modules to the system.

With an Employee ID the status of activities can be tracked with this application. This system used to generate various

reports for the management to made decision for company.

Responsibilities:

• Worked with Business Analysts to understand the requirements.

• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design,

Coding, Implementation, SIT, UAT, and Production Move).

• Perform ETL processes using SSIS tool for SQL Server

• Design/Develop complex queries efficiently as per the given business requirements.

• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.

• Worked on Table Partitioning to load current and historical data.

• Worked with Business users to understand the Business Logics as per the need.

• Worked with Financial data to calculate Comp.

• Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries

for complex queries involving multiple tables.

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

• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various

transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.

• Implemented changes in Cubes (SSAS) as per the requirement.

• Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.

• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze

performance of System.

• Created Transact-SQL(stored procedures, views, triggers, sub-queries, joins)

• Generated reports using SQL server reporting services (SSRS).

• Scheduled Jobs and Alerting using SQL Server Agent.

• Design/Develop Test Plans, Test Cases and documentation of various processes involved.

• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.

• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.

• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure

the completeness of batch processes, Scripts and processes.

• Documentation of all the processes involved in maintaining the database for future reference.

• Responsible for maintaining and supporting production databases.

• Created standard report subscriptions.

• Created report snapshots and cache for better performance.

• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access

with respect to security in Report Manager.

• Perform /coordinated end to end Migration process in TEST /PROD ENV.

• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script

component.

• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.

• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing

indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, VB.NET Query Analyzer, Windows 7, Team Foundation Server

(TFS) NET Framework 2.0.

Commerce Bank, Plato, MO Dec 10 –

Jun 12

SQL/BI Developer

Description: The Commerce bank is a federally chartered bank that provides services like checking, credit card services,

student banking, online banking, mobile and text banking. The project involved enhancing existing EDW and creating

data marts and SSRS report and Dashboard for reporting.

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business

logic and dynamic nature of the front end application.

• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer

and Enterprise Manager.

• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-

Clustered Indexes for significant performance boost.

• Configure the SSIS Package for run time Parameters and Configuration file.

• Created store procedures to calculate net return and Gross return of the Funds.

• Performed T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server

2005.

• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation.

• Develop the Slowly Changing Transformation to maintain the Historical Data.

• Creating Stored Procedures for SSIS and for Reporting in SSRS.

• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well

as managed the subscription and authentication of these reports.

• Maintained scheduling of subscription reports with the subscription report wizard.

• Handling the errors during data moving and Sequencing the task as per requirements.

• De-normalizing database using Stored Procedures for a single row feed to legacy system.

• Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front-end application.

Environment: SQL Server 2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS), Query Analyzer, MS-Excel, MS Access 2000, SQL profiler, SQL Server Agent.

Meritain Health, Buffalo, NY Oct 09 –

Nov 10

SQL BI Developer

Description: Client reporting system / analysis was initiated in order to replace the existing reporting system with

accuracy in the data coming out from the newly implemented data-marts. The project was focused mainly implementing a

data warehouse, which would drive the reporting systems and analysis carried out in business to support effective

decision-making.

Responsibilities:

• Involved in gathering requirement and setting up technical roadmap based on the future goal.

• Designed SSIS packages in SQL BI to extract data from Salesforce.com using WSDL (web service) feed and to

integrate with the report delivery system integrated with the enterprise portal.

• Designed and architected the mechanism using SSIS/DTS to data load from the Legacy Claim Systems DB2 to

SQL Server mitigation databases

• Designed complex stored procedure using T-SQL, dynamic SQL, Cursors, and Common Table Expression in the

phase of data cleansing, data audit, reconciliation and data load in the marts and facts.

• Involved in the design of data mart with confronted dimension abiding Type 2 changes to be used across the

various providers, claims, eligibility, adjustments and plans at enterprise level for generating system claim

reports.

• Designed and implemented several complex mechanism using stored procedures and SSIS packages in order to

clean and record auditing on data during the life cycle.

• Implemented jobs for the data load using SSIS packages to load crosswalk (mapping tables) for daily, weekly and

monthly refresh in the ODS and HIPPA reason/rejection codes.

• Designed and implemented application for escalating error during various load status and notification.

• Cleaned existing (SSIS/DTS) packages for loading into the Claims, PPO existing source system databases.

• Fine tune and Performance Tuning by demoralizing the dimension to the lowest granularity for faster and detailed

and accurate reports coming out of the marts.

• Involved in the mechanism to track down the changes and archiving the changes for the loads taken in marts for

future tacking and correction in the source system

• Designed and maintained db jobs for the marts, file, package load and notification

• Lead the architecture of the Report design and delivery/release mechanism for the Client Reporting System for

Monthly and Quarterly Reports packages from data marts.

• Designed complex quarterly and the monthly package integrated in the cover page and sub report style using

SSRS 2008.

• Implemented reporting packages involved Drilldown, Graphs, Sub reports, Shared Data sources, and

parameterized reports.

• Deployed and documented the existing process schema analysis, database diagram, procedures, functions,

packages for future references and maintenance in Subversion

Environment: Windows 2003 Server, SQL Server 2012, SQL Server Business Intelligence Tools, VS2008 TFS, SSRS

2008, MOSS 2007, VBScript, .Net, C#, DB2/ZOS, Pl/SQL, Microsoft Office, Windows 2000/XP, IIS 6.0.

Tata Consultancy Services Mar 07 – Sep 09

SQL BI Developer

Description: The project involved enhancing existing EDW and creating data marts and SSRS report and Dashboard for

reporting.

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages

in both the environments (Development and Production).

• Implemented Event Handlers and Error Handling in SSIS packages.

• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

• Created SSIS packages for Data Conversion using data conversion transformation.

• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat

files.

• Weekly Update the Dimension and Fact tables through SSIS Packages and Updated the cube in SSAS.

• Created a report model on SSAS cubes.

• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders

• Created Logical/physical Data Model in Erwin and have worked on loading the tables in the Data Warehouse

• Worked extensively with the Erwin Model Mart for version control

• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis

Services (SSAS) and Reporting service (SSRS)

• Used SSRS 2008 to create customized reports and ad hoc reports.

• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution

Environment: SQL Server 2005, Erwin Data Modeler, Oracle Golden Gate(OGG),Rational Performance

Tester(RPT),SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS),SQL Server Analysis

Services(SSAS).

Vijaya Corporate Bank, India Jul 06 – Feb 07

SQL Developer

Description: This project was for the Student Finance division of a leading bank. The department in the company

provides students with loan solutions to pay for and manage the cost of higher education. Customer-centric data base was

build to analyze transactions across finance, marketing, risk, collections, and consumer relations was developed.

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.

• Involved in the Data modeling, Physical and Logical Design of Database

• Created tables, indexes, sequences, constraints, triggers and procedures.

• Stored procedures and triggers were used to implement business rules.

• Helped in integration of the front end with the SQL Server backend.

• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)

• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries

• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS.

Contact this candidate