SUMMARY

• Over 8 years of strong experience in SQL Business Intelligence with demonstrated success in the Database Design, Development and Deployment of large - scale enterprise applications.
• Having experience in Manufacturing data as to load different data from various manufacturing sites and understanding the business and having experience in Medicinal and Clinical domain.
• Experience in MS Business Intelligence suite of products like SSIS, SSAS and SSRS.
• Hands on experience with Database development in OLTP and OLAP.
• Experience in creating stored procedures, functions, triggers, cursors, tables, views, indexed views, temp tables, dynamic sql, CTEs, sql cmd commands.
• Worked on FDA regulation environment in solving NCR’s and CAPA issues.
• Solid knowledge of Relational Database Management Systems and Data Warehouse Concepts.
• Worked on T-SQL, DDL, DML, Primary Keys and Foreign Keys.
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access and DB2 into SQL Server 2014, 2008 R2/ databases.
• Created SSIS packages with Error handling, notifications and package configurations.
• Created audits/logging for SSIS packages on task level and package level.
• Designed, deployed, and maintained of variousSSRSReports. Created reports using SQL Server Reporting.
• Worked on Control Flow tasks like For each loop, execute process tasks, execute package tasks, script tasks and Data Flow tasks like derived column, look up, merge, script, union.
• Used SSIS Checkpoints, property expressions and variables to customize data processing.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from OLTP, relational databases and OLAP cubes.
• Experience with Data Governance, Master Data Management, and metadata management.
• Hands on experience in developing Custom Reports and different types of Tabular reports, Matrix reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Developing report models to give users flexibility to create dashboards of their own choice.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Worked on setting up SSRS reports for data driven subscriptions.
• Creating relations and attribute hierarchies in cube. Configuring user roles, groups, database email accounts and profiles.
• Worked on migration project for the client in order to reduce flaws in the previous project and develop a new project with less manual intervention and to make it automated for future usage.
• Deploying SSIS Packages, SSRS reports and SSAS cubes to production serve.
• Experience in using Oracle, DB2 sources in healthcare industry for loading the data into DB.
• Involved in Data modelling for star schema and involved in advancement of the data warehouse.
• Experience in creating Type1, Type2 and Type6 Dimensions in the projects.
• Worked directly with the business users for report development in developing monthly, weekly and for adhoc reports in SSRS.
• Understanding query flow using execution plan and tuning the query to use appropriate Scan/Seek (Index Seek, Index Scan and Table Scan).
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER 2008/2005 Dashboards / Reports.
• Experience in client interaction while providing technical support and knowledge transfer.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003/2000 , Windows 8/7/Vista/XP

Languages: SQL, T-SQL,Visual basic, C#, VB.Net, ASP.Net, XML, HTML, Java Script

Tools: /Utilities: SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2012/2008/2005 , SQL * Plus, Toad.

Databases: MS SQL Server 2012/2008/2005 , Oracle11g/10g, MS Access

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, DTS X Change, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Tableau, Qlikview.

PROFESSIONAL EXPERIENCE

Confidential, Round lake, IL

SQL/SSIS/SSRS Developer

Responsibilities:

• Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server 2014, Cognos Cubes, Oracle databases for Pharma industry in Manufacturing and clinical data.
• Created SSIS packages with Error handling, notifications and package configurations.
• Worked on Control Flow tasks like For each loop, execute process tasks, execute package tasks, script tasks and Data Flow tasks.
• Worked on Job scheduling for ETL'S using SQL Server Agent.
• Deployed SSIS packages for after working on complex enhancements.
• Created and Executed the Stored Procedures and Complex Queries.
• Worked on QA risk Management Critical process on Manufacturing data of Medical and Clinical Products.
• Maintained applicable tracking and management tools as Tortoise SVN.
• Creation of technical design documentation and helped in developing Functional Requirement documentation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Worked on NCR’s for the F.D.A and resolved the issues for reporting.
• Documentation and analyzing existing design for developing new architectural model for the enhancement project to reduce flaws in FDA reporting.
• Developed new packages for the system from scratch.
• Created the SQL Server Agent jobs for the created ETL and scheduling them to run on daily and weekly basis .
• Worked on VBA coding for developing excel Runnables and connecting to SQL server database.
• Worked on Enhancements of the packages for automation of data removing manual intervention.
• Worked on FDA validation reports and data.
• Involved in Data modelling for star schema and involved in advancement of the data warehouse.
• Worked on Tableau desktop for some of the reports replicating the SSRS reports,
• Worked on all the major SQL-skills like Aggregates, Views, Database objects, stored procedures.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reports.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Environment: SQL Server 2014 management studio, Visual studio 2013, Oracle,DB2, Cognos, MS Excel, Business Intelligent technologies like SQL, SSIS, SSRS, SSAS, Tableau 8.2.

Confidential, Phoenix, AZ

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in analysis, design, development and enhancement of the application that applies business rules on the data on weekly basis.
• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T SQL code and SQL joins to ensure efficient data retrieval.
• Experience in end to end banking and credit card process experience.
• Ensure best practices are applied and integrity of data is maintained through security, documentation and change management.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created loggings in the existing SSIS Packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reports.

Environment: SharePoint, SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, PL-SQL, DB2, MS Access, MS Excel & Windows 2003 server, Business Intelligent technologies like SSIS, SSRS, SSAS.

Confidential - Phoenix, AZ

SQL/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interaction with users, DBAs, System Admin and technical manager to fully understand the requirements of the system.
• Created audit events for master and child packages to track the status of the package execution.
• Created notifications, alerts to let support team know in case there are any failures.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, TRY and CATCH blocks
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Worked on Mercurial source control to manage code.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.

Environment: SQL Server 2005/2008R2/2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel & Windows 2003/2007 server, Business Intelligent technologies like SSIS, SSRS.

Confidential - Fort Myers, FL

SQL/SSIS/SSRS Developer

Responsibilities:

• Created Star schema Dimension Modeling for the Data Mart using Visio and created dimension
• And fact tables based on the Business requirement.
• Involved in Database design process and Data modeling process using Microsoft Visio 2007.
• The data was extracted, scrubbed, formatted so it could be loaded to tables of a data ware house (ETL).
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Experience in generating On-demand and Scheduled Reports for business analysis or Management decision using SQL Server Reporting Services.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Worked on Team foundation Server source control (TFS) to manage code.

Environment: MS SQL Server 2008R2, SSRS, SSIS, MS SQL Server Analysis Services 2008, OLAP, Performance Point Server 2007, ETL, UML, Erwin, DTS/SSIS, BIDS, SharePoint Portal Server 2007, Windows 2008.

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

• Installing different Hot fixes for Deadlocks, Blocking and indexes.
• Detection and resolving of Blocking and Deadlocks using Profiler.
• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Used BCP command line utility to replicate a database.
• Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS 2005. Used Table control, Matrix control for cross tab reports.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, Visual Studio 2005/2008, Microsoft Office share point 2007, windows 2000/2003/XP, .NET Framework, C#, VB, ASP.NET, ADO.NET.