PROFESSIONAL SUMMARY:

• Over 8 years of IT experience on Microsoft SQL Server 2012/2016 Development and Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Sound knowledge of software development life cycle (SDLC) with substantial experience with object - oriented analysis and design methodologies.
• Expertise in MS SQL Server 2012/2008R2/2008/2005 and Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Experienced in RBMS Concepts, Database Management Systems, and Database Physical and Logical design & Data Modeling.
• Excellent SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• I had extensive experience in extracting data from sales database into SSIS and using those extracted data for generating business object reports.
• Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Advanced extensible reporting skills creating various complex reports in SSRS 2005/2008 including tabular reports, drill down reports, drill through, matrix reports, chart reports, sub reports and parameterized queries for generating cascading reports.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, Stored Procedures, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Experienced in deploying and enhancing the SSIS Packages from development server to production server.
• I have Expertise in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Proficient in writing complex T-SQL (DDL, DML), using new features like CTE, ranking functions, top(n), pivot and building referential integrity constraints.
• Extensively worked on how to design and develop cubes using SQL Server 2005 Analysis Services(SSAS) and leverage the advanced BI functionality of SQL Server 2005.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Working knowledge in Java.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Proficient in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining.
• Excellent interpersonal skills, analytical, problem solving and presentation skills.

TECHNICAL SKILLS:

BI Tools: SQL server reporting services (SSRS).

ETL Tools: Informatica Power Center 8.x, SQL Server Integration Services (SSIS).

Databases: MS SQL server, Oracle 8i/9i/10g, DB2, MS Access

Database Tools: Teradata, TOAD, APEX Data Loader.

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1.

Languages: Java, R, C, C++, SQL, PL/SQL, T-SQL, HTML, JavaScript and XML.

OS: Windows 2000, Server 2003, 2012, VISTA, Windows NT 4.0, Mac OSX, Linux, UNIX.

Front End Tools: Microsoft Office, Microsoft Project, Microsoft Visio, and Visual SourceSafe.

WORK HISTORY:

Confidential, Phoenix, AZ

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.

Environment: MS SQL server 2014/2012, ASP.NET, BIDS, T-SQL, Oracle, .NET, Visual Studio, MS Server Integration services (SSIS) MS Server Analysis services (SSAS), MS Server Reporting services (SSRS)

Confidential, Dallas, TX

SQL Server Developer/SSIS /SSRS

Responsibilities:

• Conducted Logical and Physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Created and developed stored procedures and triggers to handle complex business rules, history data and audit analysis.
• Filtered bad and inconsistent data using complex T-SQL statements and implemented various constraints and triggers to maintain data consistency.
• Used SQL script to find heavily fragmented indexes and have re-organized the indexes accordingly to get desired performance from the tables.
• Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Migrated data from heterogeneous data sources and legacy systems to a centralized SQL Server using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Implemented Error handlers and Event handlers in SSIS packages.
• Created packages to validate, extract, transform and load data to centralize SQL Server using OLEDB providers from the existing diversified data sources.
• Maintained databases, performed software installation and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check using DBCC commands.
• Generated daily and weekly monthly reports involving customized and on-demand reports using SSRS and also involved in analyzing multi-dimensional reports in SSRS.
• Formatted tables with global variables and expressions in order to meet the business analyst's requirement to analyze the data.
• Involved in applying row level security to a few confidential reports and giving permissions to a list of specified delegates to access such reports.
• Involved in improving the performance of SQL Server by designing efficient schemas, fine-tuning of indexes and avoiding scalability pitfalls while using SQL XML.
• Experienced in designing efficient schemas by separating OLAP and OLTP workloads and by devoting appropriate resources in building the schemas.
• Responsible for query optimization using MS SQL tools like Query Optimizer, SQL Profiler, Index Tuning wizard.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services, MS SQL Server Reporting Services, SQL Server Agent, SQL Enterprise Manager, OLAP, OLTP, XML, T-SQL, SQL Profiler, Index Tuning wizard, MS Access 2008, MS Outlook.

Confidential, Boston, MA

SQL Server Developer /SSIS/SSRS

Responsibilities:

• Interacted with business users for understanding and gathering business requirements and involved in project planning, scheduling the database module with project managers.
• Worked with SQL in writing complex queries to fit the Clinical workflows and develop ad-hoc reports requested by Physicians.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
• Created Reports in SSRS with different type of properties like Chart controls, Interactive sorting, SQL parameters etc.
• Monthly CIR reporting to Department of Health by generating the Immunization data in the required format.
• Maintain Crystal Reports library and custom Crystal reports for OR Manager an application documenting the patient’s surgical procedure, three phases surgical preoperative, intraoperative and postoperative.
• Actively involved in extracting the workflows from Physicians that can help in writing the reports.
• Helped application teams in Query Analyzing and its optimization.
• Provided various reports for various departments including census for the development of the hospital.
• Provided Ad-hoc Query for the MLM programmers.
• Experience in developing HRSA reports for the funding of the hospital.
• Assisted with financial reporting for entire hospital network.
• Created custom fields, created custom screens and assisted in working with clinical leads to determine reporting analysis.
• Created DTS, SSIS packages for data integration from various data sources like Access, and SQL Server 2008 R2 into the operational SQL Server and deployed them by using configuration tools.
• Strong knowledge of SQL including queries, views and stored procedures, SSRS and SSIS.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Created Stored Procedures, triggers, views, temp tables for data manipulation & reporting.
• Create ad-hoc reports upon request.
• Closely worked with the networking team to provide the solution for existing printer mapping.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008 R2, Visual Studio 2008, PL-SQL, Share Point, Oracle 10g, MS Access.

Confidential, Raritan, NJ

MS SQL Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Developed and optimized T-SQL stored procedures and UDF’s to support the bottom line invoice system.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Converted Actuate Reports to the reports in SQL Server Reporting Services and established Reporting Framework.
• Deployed Reports onto the Report Server.
• Used SSIS packages to do file operation, to apply business rules.
• Created several SSIS jobs and packages and executed those tasks
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Created various dynamic reports using SSRS and Crystal reports.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled reports and exported in PDF format.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server Development Studio 2005, 2008, SQL Server Business Intelligence Development Studio 2005, 2008, SQL Server 2000.