Sql Server Data

PROFESSIONAL SUMMARY:

Over all *+ years of experience in Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2008/2005/2000.

Expertise in all phases of Software Development Lifecycle (SDLC) involving Software Analysis, Design, Development, Testing, Implementation, Production Deployment and Maintenance of Oracle/MS SQL database in Client/Server and Web based environments.

Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.

Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).

Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de-normalization.

Extensive experience with T-SQL, Functions, Views. Created complicated SQL procedures to meet the requirements of the systems being developed.

Experienced in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Good Knowledge in overall SDLC comprising requirements gathering, modelling, development, integration, testing, debugging, deployment, documentation and maintenance support.

Worked in Software methodologies like Agile and Waterfall models.

Good Understanding in various Hadoop Distributions like Cloudera to implement and make use of them.

Experienced in developing Applications using Hadoop ecosystem like MapReduce, Hive, Pig, Sqoop, Flume and HBase

Excellent understanding / knowledge of Hadoop architecture and various components of such as HDFS, JobTracker, TaskTracker, NameNode, DataNode, MapReduce & YARN

Experience in importing and exporting data using Sqoop from Relational Database Systems to HDFS and vice-versa.

Developed Kafka producer and consumers, HBase clients, Spark and Hadoop MapReduce jobs along with components on HDFS, Hive.

Knowledge in converting Hive or SQL queries into Spark transformations using Scala.

Worked on the core and Spark SQL modules of Spark extensively.

Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).

Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.

Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Experienced in performing Incremental Loads and Data cleaning in SSIS. Managed Error handling, logging using Event Handlers in SSIS.

Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS

Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.

Experience in writing Expressions in SSRS and Expert in fine tuning the reports.

Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.

Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.

Knowledge of SQL Server solutions including Log shipping, database mirroring, Replication and clustering.

Worked in OLTP & OLAP environments that include QA, Production and development, implemented and maintained database schema and Entity relationship diagrams from business requirements.

Experienced on Performance monitoring using SQL Profiler scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.

Managed all database servers in development, staging, test and production environments.

Worked with internal enterprise architects and consultants, assisting in the development of current and target state enterprise data architectures.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and also worked in a technically challenging environment.

EDUCATION:

Masters Degree in computer science.

CERTIFICATIONS:

CCD-410: Cloudera Certified Hadoop Developer

Coursera: Health Informatics on FHIR

TECHNICAL SKILLS:

Languages

T-SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.

RDBMS

SQL Server 2012/2008/2005/2000, Oracle 11g/10g/9i/8i and MS Access 2003/2000/97

DWH / BI Tools

SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools & Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP.

Operating Systems

Unix, Windows NT/XP/2007/2003/2000,Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE:

Client: Fallon Health, MA

Role: Application Developer II July’17 – Present

Fallon Health requires the ability to create, print, reprint and mail Enrollment in an automated fashion. Fallon Health will utilize a vendor to process extract files and produce member letters pertaining to Enrollments. Letters can be generated automatically and/or on demand. Each grouping of letters is addressed separately due to the changes in record selection criteria and triggers to identify the letters. The end result will be forwarded automatically to the vendor via SFTP.

Responsibilities:

Designed SSIS Packages to read data from SQL Server tables and creates an output file in a specific file format.

Developed SSIS packages and deployed to multiple environments

Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.

Tuned complex SQL Queries.

Experience with SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages

Wrote stored procedures and User Defined Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Involved in Deployment and Administration on SSIS packages.

Involved in business meetings for requirement gatherings and prepared BRDs

Played a major role in production support of SSIS jobs.

Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.

Did the whole documentation of packages and applied Naming Standards.

Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages.

Client: Fresenius Medical Care, MA

Role: SQL Developer Mar’16 – June’17

Reusable Web Services For FreseniusRx and FMS is a project set up to design, development and implement FHIR Services that expose FreseniusRx data as respective FHIR Resources. The FHIR Resources and Services are scoped for consumption within realm of Fresenius Kidney Care's Enterprise Applications / Systems.

Responsibilities:

Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.

Created views to restrict access to data in a table for security.

Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Tuned complex SQL Queries.

Involved in performance tuning of the database and T-SQL queries using Execution Plan.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.

Client: Southern New Hampshire University, NH

Role: SQL Server SSIS/SSRS Developer Aug’14- Feb’16

Southern New Hampshire University, also known as SNHU, is a private, nonprofit, coeducational, and nonsectarian university situated between Manchester and Hooksett, New Hampshire, in the United States. The university is accredited by the Commission on Institutions of Higher Education (CIHE) of the New England Association of Schools and Colleges, and also has specialized accreditation for its schools and programs.

Responsibilities:

Re-engineered key applications and stored procedures to strengthen response times in order to provide timely delivery with improved reliability and reduced costs across the University

Involved in creating Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)

Automated existing SQL Reports via Report Subscriptions and Data Driven Subscription a using SSRS 2008.

Involved in configuration report Server using report Server Configuration Manager and deployed the SSRS reports in SharePoint.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).

Provided support to Employees and Students on over 40 different programs and applications from installation and training to problem resolution.

Worked on Performance Tuning, Capacity Planning based on user needs, and SQL optimization.

Created complex Stored Procedures and Views to pull data into reporting services from the Databases.

Worked on removing duplicates while migrate the data using joins and Row number by partition clause.

Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Created various SSIS packages for data migration which processes multiple flat files coming from utility server and loads into different database tables.

Used various transformations in SSIS packages to modify the data from the source.

Involved in extracting the data from flat files in the development server and loading the clean data into the production server using SSIS

Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing

Generated database SQL scripts and deployed databases including installation and configuration.

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.

Transformation of data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS) tools.

Generated Daily, Weekly and Monthly reports for the query analysis of managers and end users.

Environment: MS SQL Server 2008/2012, Oracle 10g, SSIS, SSRS, XML, T-SQL, Stored Procedures.

Client: Houghton Mifflin Harcourt, Boston, MA

Role: SQL Server SSIS/SSRS Developer Aug’12–Jul’14

Houghton Mifflin Harcourt is an educational and trade publisher in the United States. Headquartered in Boston's Back Bay, it publishes textbooks, instructional technology materials, assessments, reference works, and fiction and non-fiction for both young readers and adults.

Responsibilities:

Involved in all phases of SDLC, and gathered business requirements from business people.

Design/develop database using SQL SERVER 2000/2005.

Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.

Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.

Developed SSIS Packages using xml, OLEDB, file system, Look up tasks.

Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).

Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.

Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2008.

Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.

Deployed SSRS Reports in SharePoint Environment.

Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.

Scheduled Complex Stored Procedures using SQL Server Agent.

Monitored and modified Performance using execution plans and Index tuning.

Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server Management Studio 2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), SharePoint Moss 2007, Windows XP

Client: Cook Children’s Health Care, Fort Worth, TX

Role: SQL BI Developer SSIS Feb’10 – July’12

Cook Children’s Health care System is a not-for-profit, nationally recognized pediatric health care organization. The Project was to move SQL Server 2000 to a higher version of SQL Server, VB, DTS, SSIS, FTP and automation. It would be converting DTS Scripts to SSIS as well as converting existing automation scripts to a new version of the software.

Responsibilities:

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

Involved in modifying DTS/SSIS packages with ActiveX scripting for transferred data modifications.

Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.

Supported the team in resolving in DTS and T-SQL related issues.

Experience in Automate process 9 which executes the sql jobs daily/weekly/monthly.

Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.

Using Checkpoints in packages to enable the package to run from the point of failure.

Developed SSIS using different ETL transformations like Derived Column, Data Conversion, Lookup, Merge, Slowly Changing Dimension, Union All and Conditional Split.

Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.

Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Modification of database object such as addition of Triggers, modification of tables, stored procedure to meet customer requirements on SQL server Management Studio (SSMS).

Monitoring Execution Plans to enhance the performance of the queries.

Involved in creating Adhoc reports and data driven subscription reports by using Report Builder in SSRS.

Modified existing Reports and sql Stored procedures in SSRS 2012.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DTS, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Visual Studio 2010.

Client: PrimeroEdge, Houston, TX

Role: SQL BI Developer SSIS Nov’08 – Jan’10

PrimeroEdge is the industry leading provider of software solutions for Child Nutrition departments in K-12 school districts across the country. PrimeroEdge is a comprehensive and integrated management solution with the goal of helping districts serve their students, parents and communities better. PrimeroEdge enjoys very high customer satisfaction and continues to develop and deliver software and services with the highest commitment to responsiveness, quality, innovation, and customer focus.

Responsibilities:

Involved in Data Source layer, data transformation layer, data storage and retrieval layer, analytical layer and presentation layer of business intelligence solution

Used Linked servers to connect to remote OLEDB source and joined the data present in OLEDB source with local data (referred the oledb source more than once)

Used open row set function for one time access of the other OLEDB source data

Data from sources MS SQL Server, Oracle, text files, Microsoft access are extracted, transformed and loaded into a data warehouse

Involved in the design of star and snow flake schemas for the data warehouse

Handled inferred and slowly changing dimensions while loading fact and dimension tables respectively

Involved in package migration from DTS to SSIS, running upgrade advisor tool against DTS packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually

Involved in loading the fact and dimension tables

Identified and defined fact and dimension relationships

Involved in the ETL process, used SSIS tasks and transformations to accomplish the ETL process

Deployed reports on to the report manager and presented them to the users creating custom vb.net applications and asp.net pages

Created data source views from data sources SQL Server, Oracle

Included computed columns using named calculations and removed unwanted columns using named queries

Designed time and geography dimensions including hierarchies

Created different drill down and parameterized reports depending on the requirements and developed data driven subscriptions for those reports using SSRS and report manager.

Environment: MS SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005, DTS, T-SQL, VSS, Window Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer.

Contact this candidate