KOUSHIK

acyc5s@r.postjobfree.com

PH NO: 609-***-****

SUMMARY:

7+ years of experience in design, development, coding and testing of business and commercial applications

in MSSQL Server 2012/2008R2/2008/2005, MS Access, and Windows 2000/2003/2008.

Extensively worked on system analysis, design, development, testing and implementation of projects and

capable of handling responsibilities independently as well as a proactive team member.

Excellent knowledge of entire Software Development Life Cycle(SDLC) methodologies like waterfall

model and Agile methodology

Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.

Experience in OLTP/OLAP environment and Data Warehouse.

Strong knowledge on Oracle Architecture and Database Management.

Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining .

Work experience on MS SQL Server 2012/2008R2/2005/2000, Oracle, VB 6, crystal reports 6.

Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS

Designed and developed matrix and tabular reports with drill down, drill through using SSRS.

Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.

Worked as MS SQL Server Developer on enterprise and performance critical applications.

Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in

MS SQL Server.

Involved in migration of legacy data by creating various SSIS packages

Expert in Data Extraction, Transforming and Loading ( ETL) using various tools such as SQL Server

Integration Services (SSIS), DTS, Bulk Insert and BCP

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS

Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL

Profiler and SQL Server Debugger.

Expert in generating drill down reports in SSRS 2008.

Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML

files using SSIS.

Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved

in Logical and physical Design of the Database using Erwin tool.

Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and

Excel pivot tables.

Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.

Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.

Exceptional Computer Science background with programming skills in VB as a Junior Programmer.

Excellent verbal and written communication skills with a strong focus on customer facing interaction,

customer service, and presentation.

Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository

of codes and version control, branching and merging into production.

Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries

using DMV's and creating the necessary environment for Deployment.

Proficient with automated testing tools Win Runner, Load Runner and QTP for testing Client / Server

and Web based applications

Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.

Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication

skills.

Ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

Technical Skills:

Databases MS SQL server 2000/2005/2008/2012, Oracle, Teradata, MS Access, Netezza

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler,

Tools Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development

Studio, Data Transformation Services

Languages Transact- SQL, SQL, HTML, XHTML, C, XML

ETL Tools SQL Server Integration Services (SSIS), SQL Server DTS

Reporting Tools SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.

SQL server Management Studio, SQL server Query Analyzer, SQL server mail

SQL Server Tools service, DBCC, BCP, SQL server profiler.

Data Modeling

Erwin tool, Microsoft Visio 2000/2003

Tools

Windows server 2003, Windows 2000 advanced server/professional, Windows NT,

Operating Systems

Windows XP professional /standard, Windows 7 and UNIX.

Other Tools Microsoft Visual Source Safe, TFS, Microsoft Office, MS Visio.

PROFESSIONAL EXPERIENCE

Client: Cigna Health care, Bloomfield, CT Jan 2015 Till Date

Position: SQL Server SSRS/SSIS Developer

Responsibilities:

Interact with the system analyst & business users to gather business requirements, system specification and

enhancement.

Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel

spreadsheets, flat files and vice versa.

Published migrated data using SSIS, DTS Wizard (data transformation services) tool through data flow

tasks, look up transformations and script tasks.

Extensively worked on mappings, incremental data loading, and SSIS transformations that include:

lookup, filters, aggregators, scripts, multicasts, derived (not limited).

Intensively used SSIS Import/Export Wizard, for performing the ETL operations.

Scheduled the created SSIS /DTS packages using SQL server agent.

Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.

Created complex stored Procedures, triggers, cursors, tables, views and other SQL joins and statements

for applications by using T-SQL.

Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database

models, data dictionaries, and data integrity.

Created complex SSIS Package using Script Task, For Each Loop, Derived Columns, Fuzzy Lookup,

Condition Split, Sort, Union All, Execute SQL Task, Data Flow Task and File System Task.

Used various data transformations like Conditional Split, Script Component, Derived Column, Sort,

Merge Join and Data Conversion etc.

Involved in extracting the data using SSIS from OLTP to OLAP.

Worked on the Audit Logs that capture the audit details before and after the package execution using

Variables and Parameters.

Created SQL server reports using SSRS 2005/2008 for manager, customer support and that can deliver at

client s station.

Designed different type of SSRS reports: Tabular, matrix (cross tab), conditional, list items, charts and

sub reports.

Created cascading (collapsed) parameters to a report, and added report parameters that can be used in

user-defined function.

Responsible for ongoing maintenance and change management to existing reports and optimize report

performance.

Designed printable, interacted reports (drill-down and sorting functionality).

Created and designed reports based on query parameters and report parameters .

Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services

(SSAS).

Took part in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS).

Supported in creating KPI, calculation members and measure groups, and MDX queries.

Worked with preparing the documentation for analysis, Technical Specification documents, Functional

Specification documents, mapping documents etc., for various migrations and up gradation projects.

Environment: SQL Server 2012/2008/2008R2 Enterprise Edition, Netezza, SQL Server Business

Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share point Server, XML, MS

Visual Source Safe.

Client: Cardinal HealthCare, Dublin, Ohio Oct 2013 Dec 2014

Position: Sr. SQL Developer/ MSBI developer

Responsibilities:

Designed SSIS Packages to handle data migration (ETL Processes) from transaction system

Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS

Packages.

Used Sequence Container in Control Flow for linking all dimension tables.

Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split,

Sort, Merge Join, Aggregate, and Execute SQL task etc.

Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source

Views.

Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill

through functionality and Graphical presentations such as Charts and Dashboard type metrics using

SSRS.

Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.

Scheduled the monthly/weekly/daily reports to run automatically . Worked on querying data and creating

on-demand reports using Report Builder in SSRS reports and send the reports via email.

Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the

generated reports directly on the client s workstation.

Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in

SQL Server.

Performed activities like creation and indexing of the tables.

Created Views and Indexed Views to reduce database complexities for the reports.

Enhancing and deploying the SSIS Packages from development server to production server.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005, SQL Server

Reporting Services (SSRS) 2005, T-SQL, MS Office, Windows Vista

Client: Pizza Hut, TX June 2012 Sep 2013

Position: SQL Developer/MSBI Developer

Responsibilities:

Actively participated in interaction with users, team lead, DBA s and technical manager to fully understand

the requirements of the system.

Scheduled Complex Stored Procedures using SQL Server Agent.

Monitored and modified Performance using execution plans and Index tuning

Involved in project planning, also schedule for database module with project managers.

Responsible for writing T-SQL code for creating cursor and handling data validations

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user

defined data types and functions for the project.

Developed, tested and implemented Referential Integrity rules and regulations through constraints,

triggers and views, partitioned views.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management

Studio.

Created SSIS Packages user data from the Flat files on monthly and weekly basis.

Created Database objects views, and functions and developing procedures for implementing

application functionality at the database side for performance improvement.

Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in

MS SQL database tables.

Created views as required by front end developer for easier implementation on web pages, and triggers on

those views to provide efficient data manipulation.

Assisted and supported issues related to the queries and database systems.

Involved in rebuilding the indexes at regular intervals for better performance.

Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to

Data warehouse.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly

Reports including current status

Created datasets, data source and involved in deploying the reports in to the report server.

Created SSIS packages using script task by C#.

Created reports using SQL Server 2005(SSRS) and integrated into the web front end.

Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for

the analysis of Performance.

Created Drill reports which give all the details of various transactions like closed transactions, pending

approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS

(Reporting services).

Worked on Performance tuning, and optimization of procedures and queries.

Created ad-hoc queries from SQL Server databases for custom reporting needs. Worked on querying data

and creating on-demand reports using Report Builder in SSRS.

Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports

and linked reports using SSRS.

Environment: SQL Server 2005, T-SQL, SSIS, SSRS, VB.NET, ADO.NET, Microsoft Excel, Microsoft

PowerPoint.

Client: US BANK, St. Louis, MO Oct 2011 May 2012

Position: SQL Server Developer

Responsibilities:

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.

Experience in creating complex SSIS packages using proper control and data flow elements.

Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD s), Lookup,

Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as

per the client requirement.

Implemented Logging and Event Handlers on SSIS packages for trouble shooting.

Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with

proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS 2012.

Involved in analysis of Report design requirements and actively participated and interacted with Team

Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Created complex reports which involve more number of groupings and multi-value parameters.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process

for monthly Statements.

Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on

periodic basis.

Designed and developed databases using Oracle, MS SQL server.

Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.

Created multiple reports with drop down menu option having complex groupings within the report.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Experience in working on Cube structure optimization for MDX query performance in Analysis Services

2008/2005 (SSAS)

Worked on OLAP Data warehouse, Model, Design, and Implementation.

Used Service Oriented Architectural approach for developing Information Systems and later on used it for

databases.

Troubleshooting performance issues and fine-tuning queries and stored procedures.

Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups

and KPIs to analyze performance of Strategic Business Units as well as corporate centers

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Checked the configuration and performance of the existing databases including data file allocation, index,

fragmentation and impact on system performance. Analyzed potential problems (response delay, locking,

server down time, etc.) to avoid and optimize by following the Normalization standards to maintain data

consistency and by performing data validation.

Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2010/2008/2005 Enterprise Edition,

SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point

Sever, Office-2007, MS Excel, Oracle, C#.NET, ProClarity Analysis.

Client: ITC, India July 2009 Sep 2011

Position: SQL Developer

Responsibilities:

Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.

Involved in Normalization of the database and bringing it to 3NF.

Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential

integrity.

Created ER diagrams using Visio.

Created Views to enforce security and data customization.

Created Non-Clustered indexes to improve query performance and query optimization.

Involved in the performance tuning and optimization of T-SQL queries.

Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.

Created Stored Procedures for commonly used complex queries involving join and union of multiple

tables.

Developed user requested reports using Crystal Reports and Excel.

Created Drill down and Drill through reports using Crystal Reports.

Environment: MS SQL Server 2005, Windows NT platform, Visual Basic 6.0, Crystal Reports.

Contact this candidate