SUMMARY:

• 10 years of development and administration experience in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005 and 2008
• Strong Transact-SQL query writing skills DDL, DML, and DCL .
• Good experience in creating objects such as Databases, Tables, Stored Procedures, Triggers and Cursors, Constraints, Indexes, Views, Indexed Views in Microsoft SQL Server 2000/2005/2008
• Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.
• Efficient usage of DBCC commands to increase the performance of the query.
• Experience in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQLServer performance.
• Experience in Database Backup and Recovery procedures.
• Experience in Performance Tuning and Query Optimization.
• Strong Data Extraction, Transforming and Loading ETL experience in using various tools such as Data Transformation Services DTS , SQL Server Integration Services SSIS , Bulk Insert/ BCP utility.
• Experience in creating/deploying Data Transformation Services DTS , MS SQL Server Integration Services SSIS packages using various data transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Expertise in report generation using SQL Server Reporting Services 2005 SSRS .
• Experience in creating different types of reports such as Cross-Tab, Drill-down, Tabular, Top N, Summary, Sub reports, Charts and Graphs and formatting them using SSRS 2005/2008.
• High expertise in creating Reports of all types in SSRS, like Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
• Good knowledge of Data Marts, Operational Data Store ODS , OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Have strong analytical, trouble shooting and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

SQL Programmer Analyst

Confidential

Confidential is a non-profit care management organization that matches frail seniors and people with physical and intellectual disabilities to the health and long-term care services they need. Confidential manages Family Care and Partnership, two of Wisconsin's public health and long-term care programs. These two programs serve more than 5,300 members across 21 counties in Wisconsin.

Responsibilities:

• Worked extensively with SQL Server Integration Services SSIS .
• Developed SSIS packages from scratch to transfer claims data in a correct format to third party administrators like Trizetto and Pharmastar.
• Developed template packages for error logging and event handling. These were used by users across IT while developing packages.
• Developed jobs and packages to automate the process of transferring data to FTE site.
• Developed packages using fuzzy grouping and fuzzy lookup transformations for pharmacists to evaluate drug names and map them to standard federal issued formulary files.
• Mentored users and non IT staff on SQL Server Integration Services.
• Developed a variety of stored procedures using T-SQL to generate datasets for various reports SSRS, Excel and Access .
• Developed T-SQL code to generate results for adhoc requests and saved the deliverables in user folders.
• Worked with performance tuning of already written SQL codes.
• Developed a variety of reports for Provider services, Member demographics, Business Metrics and Care team tools using SQL Server Reporting Services SSRS .
• Worked on making changes to existing reports which ranged from changing the source data to formatting changes of the report output.
• Worked on weekly loads which involves running a SQL server agent job and loading the output files into Trizetto solutions account and Qic link.
• Documented all the projects assigned using Subversion SVN and track-it technician client.

Environment:

MS SQL Server Management Studio 2012, MS SQL Server Reporting Services SSRS 2008 , MS SQL Server Integration Services SSIS 2010 , MS SQL Server Analysis Services SSAS , Visual Studio 2008, Microsoft Access, Subversion SVN , Track-it Technician Client, Windows 7.

SSRS Developer/SQL

Confidential is a global leader in power and automation technologies. Based in Zurich, Switzerland, the company operates in approximately 100 countries. ABB's business is comprised of five divisions that are in turn organized in relation to the customers and industries served.

Responsibilities:

• Developed and designed reports using SSRS 2010 and SSRS 2008.
• Implemented and maintained a reporting suite of over 70 reports while creating many reports to meet the individual user needs.
• Converted Access and Excel based reports to MS SSRS 2010 reports.
• Developed complex stored procedures using SQL Server for SSRS report datasets.
• Trained the users on MS SSRS Report Manager and Report Builder to develop their own adhoc reports.
• Performed data extraction, transformation and loading between SQL Server and other systems like SAPODS SAP Database , Oracle, Excel and Access databases.
• Worked with linking of Access and SQL Server databases to dynamically update the SQL tables.
• Designed and developed multi-dimensional objects like cubes and dimensions using SQL Server Analysis Services.
• Helped the rest of the group with network and desktop related issues.
• Involved in development and application of software to respond to customer requirements and to cost-effectively provide a means of analysing, producing, distributing and storing information.

Environment:

MS SQL Server Management Studio 2012, MS SQL Server Reporting Services SSRS 2010 , MS SQL Server Integration Services SSIS 2010 , MS SQL Server Analysis Services SSAS , SQL Developer, PL/SQL, HTML, SAP, Microsoft Access, Visual Source Safe, Windows Vista, Windows 7.

SQL Developer/SSRS Developer and

The Department of Public Instruction is the state agency that advances public education and libraries in Wisconsin.

Responsibilities

• Installed and supported the Microsoft BI tool set including SSRS and SSIS.
• Created high level design and performed system analysis.
• Administered and maintained the Report server.
• Designed and developed Front-end/Back-end/Web-user interface using SQL Server technologies
• Developed reports using SQL Server Reporting Services SSRS .
• Exported all the Info maker reports to SSRS.
• Developed complex stored procedures using T-SQL for reports.
• Established report templates.
• Trained the DPI IT Staff on SQL Server and SQL Server Reporting Services.
• Unit testing and documented the test results.
• Supported user acceptance testing.
• Deployed the created reports to Report manager.
• Supported preproduction and post production activities deployment, production shake out, production support etc
• Provided technical expertise in all phases of the software development life cycle.
• Supported to stabilize the systems, install new software releases, perform system upgrades, evaluate and installs patches and resolve software related issues, made hardware configuration recommendations.

Environment:

MS SQL Server Management Studio 2008, MS SQL Server Reporting Services SSRS , MS SQL Server Integration Services SSIS , SQL Profiler, Index Tuning Wizard, Oracle 11g, SQL Developer, PL/SQL, HTML, Visual Source Safe, Windows XP, Windows 7.

BI Data Specialist

The Sherriff's Office is a law enforcement agency representing a variety of criminal justice disciplines. The Sheriff's constitutional mandates includes keeping and maintaining the peace throughout the county, maintaining the county jail, providing bailiff services for circuit courts and serving legal process.

Responsibilities

• Assist in the creation of data access methods for system data sources to be included in compstat and operational reports as part of the agency wide business intelligence solution.
• Developed views, stored procedures, and ETL processes.
• Developed SQL Queries using Dynamic SQL.
• Worked with linked servers and wrote complex SQL to retrieve data.
• Worked with built in functions developing custom functions, aggregating data, and combining multiple data sources.
• Used OpenQuery and OpenRowset methods to retrieve data from native databases through OLE DB and ODBC.
• Created SSIS packages for transferring data from various data sources like MS Access, Excel, .Txt file, .CSV files.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Worked closely with Information Builders report developers and county staff to ensure solutions meet business needs.
• Worked with end users and analysts to assist in determining business needs and designing solutions to meet those needs.

Environment:

MS SQL Server Management Studio 2008/2005, MS SQL Server Integration Services SSIS , Win XP/2003 running in Active Directory, Mainframe DB2 Version 8, StarSQL ODBC Driver to connect to DB2 Data sources, WebFocus, SharePoint, Ceridian, CJIS, Positron Switch Data.

SQL Server/BI Developer

Confidential is one of the top-selling brands in health foods stores, an award-winning manufacturer, a respected advocate of the natural product industry, and a leader in the fields of nutritional science and methods development. The project involves building an analytical data mart and business intelligence capability which involves high use of data integration and validation using SSIS. Build various reports, dash-boards using SSRS.

Responsibilities:

• Involved in Requirements Gathering to define data requirements for reporting warehouse.
• Installed and maintained MS SQL Server 2008.
• Migrated databases from SQL Server 2005 to SQL Server 2008.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Studied the existing OLTP system s and created facts, dimensions and star schema representation for the data mart.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Involved in database designing using Normalization.
• Created the clustered/non-clustered indexes on tables, and traced out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce complex business rules and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, .Txt file, .CSV files.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for creating batch files and scheduling the jobs.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery when ever needed.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.

Environment:

MS SQL Server Management Studio 2008/2005, Query Analyser, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services SSIS , MSSQL Server Analysis Services SSAS , MS SQL Server Reporting Services SSRS , Microsoft Visual source Safe, C .net.

SQL Server/BI Developer

Confidential is a progressive marketing and technical sales organization which provides services and distributes specialty chemical products to segments of adhesives, coatings, ink, institutional industrial, personal care, plastics, rubber and related industries. In this project complex T-SQL queries were generated. Performed ETL process using SSIS and involved in generation of reports as per the business requirements. Performed performance tuning of databases for efficient data retrieval.

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Installed and Configured SQL Server 2005 and also Upgraded the existing database to SQL Server 2005
• Experience in designing Database Models.
• Designing and building data load procedures, using MS SQL Server 2005.
• Worked Extensively with SSIS to import, export and transform the data between the linked servers.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Used SQL Profiler and Query Analyser to optimize DTS package queries and Stored Procedures.
• Generated complex custom Reports using SSRS 2005 as per the customer requirement.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
• Migrated DTS objects to SQL Server Integration Services SSIS environment.
• Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services SSIS Packages, Bulk Insert and Utilities like BCP.
• Fine-tuned SQL queries using hints for maximum efficiency and performance.

Environment:

MS SQL Server 2005, MS SQL Server 2000, , MS SQL Server Integration Services SSIS , MSSQL Server Analysis Services SSAS , MS SQL Server Reporting Services SSRS , MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C Oracle, T-SQL,QueryAnalyzer.

SQL Server Developer/Reports Developer

Confidential mission is to help the people we serve improve their health, well-being, and sense of security. The project dealt with managing the data warehouse, creating cubes for the sales of the drugs and generating reports.

Responsibilities:

• Responsible for creating Reports based on the requirements using SSRS 2005.
• Identified and defined the Datasets for Report generation.
• Wrote queries for Drill-Down Reports and defined Report Layouts.
• Identified and included Report Parameters.
• Formatted the Reports using Global Variables and Expressions.
• Created SSIS packages for transferring the data from different systems.
• Upgraded SQL Server 2000 DTS packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services SSIS .
• Used SSIS and Bulk Insert Task to transfer data in and out of the Server.
• Defined and processed the Facts, Dimensions Cubes using OLAP.
• Involved in generating multi-dimensional Cubes and reports using OLAP Services
• Created tables, views, indexes and user defined functions.
• Optimized query performance by creating Indexes.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.

Environment:

MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services SSIS , MSSQL Server Analysis Services SSAS , MS SQL Server Reporting Services SSRS , MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C Oracle , T-SQL, Query Analyzer.

SQL Server Developer/Jr. DBA

Confidential is one of the leading providers of auto, home and life insurance in As a consultant at Confidential for the Human Resource Management System HRMS , part of an ERP Enterprise Resource Planning , developed and helped to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, leave or absence, payroll data, and change of certain business rules required development of new modules to the system.

Responsibilities:

• Coded the SQL Server Stored procedures for the enhancements.
• Unit, System, Integration and Regression testing of the procedures.
• Tuning and optimization of the stored procedures.
• Involved in the full life cycle of this enhancement Analysis, Development, Implementation and Testing .
• Created databases, tables, relationships, constraints. Wrote SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Enhancement involved implementation of SQL Server with the usage of Stored Procedures, SQL Execution Statistics / Plans, Optimizer and SQL Profiler for back end.
• Planning organizing the work structure, configuration, risk and delivery management.
• Administered various applications like Maintenance Management and Financial Account System.
• Maintained the client's policies and Customer Databases and tuning of the database instances.
• Worked with all database objects, including tables, clusters, indexes, views, and procedures.
• Troubleshoot problems concerned with the Databases, Applications, and Development tools.
• Created new databases for users as required. Checking the alert logs daily for oracle errors.
• Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup Recovery strategies.
• Creation of logins and user ids and setting up privileges and procedures for protection of data. Designed screens and reports layout.

Environment:

MS SQL Server 2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import Export Data, Windows 2000 Server.

Database Developer

Confidential

Responsibilities:

• Analyzed the data quality, validated the data, designed and created tables, server roles, logins and users in the database.
• Performed system implementation, index creation.
• Designed and implemented integrity constraints, written triggers and stored procedures to offload middle-tier transactions.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Analyzed the data quality, validated the data, server roles, logins and users in the database.
• Performed system implementation.
• Compressed data files by removing empty database pages and updating index statistics.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Evaluated and monitored database performance and carried out maintenance duties such as performance tuning, backup, restoration and disaster recovery.
• Responsible for managing users, roles and profiles.
• Setting up Maintaining the Data Replication Servers

Environment:

SQL Server 2000, DTS, Access, Excel, SQL Profiler, Import Export Data, Windows 2000 Server.