Resume

Sign in

Sql Server Data

Location:
Teaneck, NJ, 07666
Posted:
September 24, 2018

Contact this candidate

Resume:

SIRAJ

Phone: 408-***-****

Email: ac65us@r.postjobfree.com

PROFESSIONAL SUMMARY:

5+ Years of experience in Data Design and Development In Microsoft SQL Server 2016/2014/2012/2008R2, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS.

Good command with T-SQL in constructing Triggers, Tables, implementing Stored Procedures, Functions, Views, Data Dictionaries and Data Integrity.

Expertise in writing DML DDL and Transaction queries in T-SQL for MS SQL Server database.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to improve up the SQL Server Performance.

Hands on Experience in Managing, Monitoring and Troubleshooting SQL Server Management Studio 2012, 2014 and 2016.

Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

Expertise in designing Data Flow task and Work Flow task on SSIS.

Good understanding in database and data warehousing concepts (OLTP & OLAP).

Experienced in developing complex stored procedures to generate Ad hoc reports using SSRS

Ability to transform the data from the staging database and transform the data using Data Flow Tasks and worked extensively with on ETL process using SSIS Packages.

Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).

Responsible for creating SQL Server Drill down and Drill through Reports using SSRS to fit business requirements, and implemented into SQL Server 2012.

Expert in creating simple and parameterized reports and also complex reports involving Sub reports, Matrix/Tabular Reports, Charts and Graphs using SSRS.

Hands on experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.

Significant experience with data intensive visualization/analytics tools Tableau Desktop, PowerPivot, Power Bi Reports.

Active participation in Software Development Life Cycle (SDLC) Agile Scrum methodology.

Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS:

SQL Server Tools

SQL Profiler, Query Analyzer, SQL Server 2016/2014/2012/2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS.

Database

MS SQL Server 2016,2014,2012, 2008,MS-Access.

Language

C, C++, C#, JAVA,HTML, T-SQL.

Operating System

Windows 10/8/7/Vista/XP/NT/2000, DOS, Windows Server 2003.

Tools

Microsoft Visual Studio 2015/2013/2012/2010/2008/Share Point Server 2007, Microsoft Project Server 2007, ProClarity, QTP

Architecture

Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools

SSRS (SQL Server Reporting Services), Tableau Desktop, Power Bi

ETL Tools

SSIS (SQL Server Integration Services).

PROFESSIONAL EXPERIENCE:

Client: Centene Corporation, St. Louis, Mo May 2017- June 2018 Role: SQL BI Developer (TSQL/SSIS/SSRS)

Description:

Centene Corporation is a large publicly-traded company and a leading multi-line healthcare enterprise that serves as a major intermediary for both government-sponsored and privately insured health care programs. The main lines of Centene include Medicare, Medicaid, The Health Insurance Marketplace System, (via the ACA), Tricare, as well as traditional commercial insurance.

Responsibilities:

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Responsible for creating constraints, Indexes, and Views.

Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.

Experience in using different transformations like fuzzy lookup, derived column, Look up, Row count, OLEDB Command, Data conversion task transformations in SSIS

Used various ETL tools like SSIS/DTS for data flow from source files like Excel, Tables, and Views to other databases or files with proper mapping.

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

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

Loading data from various sources like Excel, flat files, to SQL Server database Using SSIS Package.

Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs.

Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.

Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Performed data conversions from Flat files into a normalized database structure.

Gathered and documented reporting requirements to design, develop, test and implement reports and dashboards that utilize the underlying data store.

Designed SSRS reports using Single Value Parameters, Multi Value Parameters, and Cascading Parameters.

Created Sub-Reports, Drilldown-Reports using MS SQL Reporting Services (SSRS).

Developed Queries for generating drill down, drill through reports in SSRS.

Analyzing & reviewing the Business Requirements, Design and functional Specifications, which involve series of meetings with developers and Documenting System requirements using standard templates.

Environment: Windows 10, MS SQL Server 2014/2016, SQL Server Management Studio (SSMS), T-SQL, SQL Server Report Services (SSRS), Microsoft Excel, Team Foundation Server (TFS) Agile.

Client: Inovalon.inc, Bowie, MD May 2016 – April 2017

Role: SQL Server BI Developer (SSIS/SSRS)

Description:

Inovalon is a leading technology company providing cloud-based platforms empowering a data-driven transformation from volume-based to value-based models throughout the healthcare industry, Inovalon brings to the marketplace a national-scale capability to interconnect with the healthcare ecosystem on massive scale, aggregate and analyze data in petabyte volumes to arrive at sophisticated insights in real-time, drive impact wherever it is analytically identified best to intervene, and intuitively visualize data and information to inform business strategy and execution. Leveraging its platform, unparalleled proprietary data sets, and industry-leading subject matter expertise.

Responsibilities:

Developed Stored Procedures in SQL Server 2016 and modified existing stored procedures as needed.

Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.

Designed and created views for security purposes, implemented rules, defaults, and user defined data types.

Involved in optimizing the procedures and triggers to be used in production and also involved in Performance tuning and Query Optimization.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and T-SQL code from developers and QA.

Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas using SQL Server Reporting Services (SSRS).

Developed drill down/Tree view report, Drill through reports and sub reports for organizing and efficient display of data.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014/2012.

Conditional formatted the reports for applying different styles to report items or properties, based on the data.

Custom coded the report as per the necessity by embedding the code directly in the report.

Experience with using Team Foundation Server (TFS).

Deployed the reports and Created subscriptions for the reports in report manager.

Developed data extraction and output specifications for reports based on analysis of end user’s requirements.

Gathered specifications from internal customers to understand requirements, analyze data and provide valid report designs.

Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.

Implemented report subscriptions and methods for report distribution based on agreed timelines and according to specifications.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Experience in creating packages to transfer data between ORACLE and FLAT FILES to SQL SERVER using DTS/SSIS

Created Package for capturing error data, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.

Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.

Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.

Utilized event handling effectively to generate audits and logs for the generated packages.

Environment: Windows 10, MS SQL Server 2014/2012, SQL Server Management Studio (SSMS), T-SQL, SQL Server Report Services (SSRS), Microsoft Excel, Team Foundation Server (TFS).

Client: Medinova Hospitals,Hyderabad, India July 2012 - Sep 2015

Role: SQL Server Developer

Description:

The Medinova hospitals group is one of the largest healthcare groups in India. The MPMS (Medical Practice Management System) project was aimed at building a data warehouse for tracking patient records. Flat Files, Oracle tables, DB2 tables and Excel spreadsheets were part of the source data, which came in on a daily, weekly and monthly basis.

Responsibilities:

Created and modified procedures, triggers and functions

Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.

Modified store procedure for performance tuning

Used DTS packages to do file operation, to apply business rules.

Extensively used Ultra-Edit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency.

Transformed data from text file to SQL server using OLE Automation Objects

Deployed database objects from development/testing environment to production environment

Created DTS package to export and import data from SQL Server to text files and data files.

Worked with Application Developers to support Development activities and achieve optimal efficiency.

Monitored and scheduled existing/new jobs on production environment.

Created all administration tasks of SQL Server.

Used system stored procedures and DBCC commands.

Keep trace of version of store procedure in Visual SourceSafe.

Responsible for keeping system and databases up-to-date by making necessary changes.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2012, MS SQL Server Reporting Services 2008/2012, T-SQL,BIDS.13.



Contact this candidate