Sql Server Data
Resume:
SUMMARY
. Around *+yrs of experience with database management, SQL development,
Software implementation.
. Around 3 years of experience in Health care industry.
. Good knowledge of RDBMS and experience with MS SQL Server 2012/2008/2005
. Good Experience working with BI tools SSRS, SSIS, SSAS.
. Worked with SSRS/Crystal Report/Tableau for creating complicated reports
including sub-reports, parameter based reports, graphical reports,
formula based, drill down reports, analysis reports.
. Created effective ETL strategies to Extract, Clean and Deliver Data to it
destinations.
. Good exposure to Informatica Power Center.
. Developed stored procedure, views, triggers and adding/changing tables
for data load and transformation, and data extraction and also to fetch
the data for the reports from different database.
. Good experience in Dimensional modeling using Star Schema/Snowflake
modeling concepts and Kimball strategies.
SKILLS
Programming Languages: T-SQL, PL/SQL, Basic programming in C#, C, C++
Database tools: SQL Server 2012/2008/2005/, Oracle 10g/11g, DB2, MS-
Access,
Internet Technology: Basic knowledge of ASP.Net, VB.Net, XML, HTML
Applications and Tools: SQL Server Management Studio, SQL Server
Integration(SSIS) Services,Qlikview Tableau, Informatica Power Center,SQL
Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS),Crystal
Reports, Visual Studio 2005/2008, Visual studio Teamsystem,
Visio2007,SharePoint Server(MOSS 2007), MS Office.
WORK EXPERIENCE
SQL /Report Developer
Oct
2010 - Present
Netsmart Technology - Illinois
Netsmart/Sequest Technologies is a leading provider of Electronic Medical
Record (EMR) software solutions for behavioral health, correctional
healthcare, substance abuse and mental health treatment.
Responsibilities:
. Developed complex billing and clinical reports using SSRS 2012/2008
and Crystal Report
. Developed, published and automated reports using SSRS 2012/2008
. Designed and implemented Parameterized and cascading parameterized
reports using SSRS
. Create reports using SSRS and SSAS cube as data source.
. Developed highly interactive best in class Executive Dashboard
consisting of Drill down dynamic charts, business scorecards,, KPI
Grids with advanced drill down capability giving executives ability to
analyze sales, revenue and slice it by any region/store, time period
etc.
. Trained Business analysts and power users to create ad-hoc reports on
their own using Report Builder 3.0.
. Worked on various data migration projects to migrate the client legacy
data to new system using SSIS packages and stored procedures.
. Implemented Type I, II changes in slowly changing dimensions using
SSIS.
. Designing and building data load procedures, using MS SQL Server.
. Create visually compelling and actionable interactive reports and
dashboards using Tableau.
. Used Tableau Desktop to analyze and obtain insights into large data
sets.
. Created complex TSQL queries, stored procedures, Functions and views
used for reports and maintaining reporting database.
. Worked on writing the TDD after gathering the requirements from the
client.
. Worked on maintaining the good documentation so that can be used for
future reference
. Scheduled Jobs Using SQL Server Agent.
. Provided 24 by 7 Production Support for both local and global
facilities.
Recycler.com Los Angeles (SSRS Report /SQL Developer)
Jun 2010 -Aug 2010
Responsibilities:
. Installed and configured SSRS 2008 and report builder 2.0
. Designed and implemented the security model for the SSRS and Report
builder users
. Developed Complex SSRS involving Sub Reports (Matrix/Tabular Reports,
Charts and Graphs).
. Design, deployment, and maintenance of various SSRS in SQL Server
2008
. Designed and implemented Parameterized and cascading parameterized
reports using SSRS
. Created stored procedures, views, functions that are used by Reports
to fetch the data from database
. Created the Report Model according to business requirement that can be
used for Ad Hoc Reporting by the business users.
. Build asp.net web application using C# which show the dealers Ads
Upgrades to the user,
Dealer Ads Details, Revenue generated by the Customers, Network Lead for
the Dealer.
Farm Credit Bank of Texas (SSRS Report/SQL Developer)
May 2009 - May 2010
Responsibilities:
. Developed Complex SSRS/CRYSTAL REPORTS involving Sub Reports
(Matrix/Tabular Reports, Charts and Graphs).
. Design, deployment, and maintenance of various SSRS/CRYSTAL REPORTS
in SQL Server 2005/2008
. Designed and implemented Parameterized and cascading parameterized
reports using SSRS/CRYSTAL REPORTS.
. Added the different types of the charts according to business
requirement to enhance the functionality of reports using Crystal
Reports/SSRS
. Created scheduled ssis packages to load data from association to the
database
. Migrated DTS 2000 packages to SQL Server Integration Services (SSIS)
and modified the packages accordingly using the advanced features of
SQL Server Integration Service.
. Designed ETL packages dealing with different data sources (SQL Server,
Flat Files, and XMLs etc) and loaded the data into target data sources
by performing different kinds of transformations using SQL Server
Integration Services (SSIS)
. Develop Multidimensional cubes and perspectives according to business
requirement using SSAS
. Built MDX queries for Analysis Services & Reporting Services to set
the goals, status and trend of the project.
. Used Team Foundation Server in Visual Studio in order to track and
edit bugs been tracked.
. Developing stored procedures, triggers, views, and adding/changing
tables for data load and transformation, and data extraction.
Life Insurance Corporation (LIC), India (Software Developer)
Jan 2006 - April2007
Responsibilities:
. Involved in creating and managing schema objects such as tables,
views, indexes, procedures, triggers and maintaining Referential
Integrity.
. Developed SQL scripts to Insert/Update and Delete data in MS SQL
database tables.
. Generated T-SQL scripts for application development.
. Developed SQL script to immigrate data from Excel sheet to sql server
7
EDUCATION
Illinois Institute of Technology, Chicago, IL
August 2007 - December2009
MS in Electrical and Computer Engineering
Dehradun Institute of Technology, Dehradun, India
August 2002 - July 2006
Bachelor of Technology in Electronics & Communication Engineering
Contact this candidate