SUMMARY

• Over 10+ years of professional experience as MS SQL Server Database Design, Development and Reporting.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance
• Good Knowledge in Installing, Upgrading, Migrating and, Configuring of Microsoft SQL Server 2005/2008
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions
• Efficient, in creating Sub-Queries and Joins for complex queries involving multiple tables, using Exception Handlers.
• Having good experience in creating, modifying, using and debugging Indexes, Indexed Views in observing Business Rules and appropriate Triggers to assist efficient data manipulation and data consistency
• Hands on experience on Extraction Transformation and Loading (ETL) processes using tools like SSIS between different homogeneous/heterogeneous systems, OLTP databases and implemented Incremental load in SSIS packages.
• Experience in designing Ad hoc reports and different types of Drill Down, Drill Through reports, Tabular reports, Cross tabs, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS 2005/2008.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity for teh relational Database Model implementing as per business requirement
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS Packages.
• Knowledge in Creating WebI Reports by using various Business Objects functionalities such as Tracking, Drill, Sort, Filters, Ranking, Graphs, Functions and Formulas, Alerts, Sections and Breaks.
• Experience with BMC Remedy IT service Management, Incident and change Management.
• TEMPHas experience working with various Version control systems SVN, IBM Rational Clearcase and VSS.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008/2012/2014 Oracle

MICROSOFT Technologies: SSIS, SSRS, DTS, SSAS, SQL Enterprise Manager, SQL Management Studio, SQL Server Business Intelligence Tools, .net

Programming Language: SQL,T-SQL,PL-SQL, C, C++, C#, Java, Oracle9i

Operating Systems: Win 9x/NT/2000/XP/Vista, MS-DOS, UNIX, Windows 2003 server

Scripting Language: VB Script, Java Script, HTML

Reporting Tools: Business Objects Reporting tool, MicroStrategy, Information Design Tool, QlikView, Tableau.

MS Office: Word, Power point, Excel-Pivot table, Vlookup, formulas

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, CT

Business Intelligence Developer/Analyst

Responsibilities:

• Developed and Optimized Stored Procedures and User-Defined Functions to data retrieval and modifications.
• Converting complex business logic into backend programs like store procedure and functions to achieve business functionality.
• Written complex SQL statements using joins, sub queries, correlated sub queries and CTE’s.
• Extensively worked on store procedures and functions to develop SSRS reports since they enhance teh report performance.
• Optimized store procedures and long running queries to using indexing strategies and query optimization techniques.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from Online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in teh data transfer.
• Used multiple transformations in SSIS to meet teh business requirements by collecting data from various sources.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Involved with Query Optimization to increase teh performance of teh Report.
• Used Reporting service (SSRS) to publish data to teh end user via HTML, PDF, Excel, and CSV formats.
• Support of existing report system and automated processes.
• Execute periodic list pulls for teh Recruitment & Customer Marketing teams.
• Create ad hoc SQL queries for special reporting needs.
• Developed Business Objects Webi reports for Compliance process.
• Testing of new reporting feeds and universe enhancements.
• Create reporting universe documentation for user reference.
• Diagnose and troubleshoot job failures.
• Help communicate teh status and priority of help desk tickets and change Control.
• Provide Business Objects user training.
• Document new reporting requirements or enhancements as needed.
• Help individual users build new reports based on teh universe.

Environment: SQL Server 2014, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, Crystal Reports, XML, MS Excel, MS Access, Business Objects.

Confidential, White Plains, NY

Business Intelligence Developer/Analyst

Responsibilities:

• Gathering requirements from end users understanding teh need behind their
• Requests and developing reports accordingly.
• Collaborate with clinical users and informaticist to gather business requirements for new data development tasks. Analyze clinical work flow and application to identify related information extraction method in SQL data warehouse.
• Converting complex business logic into backend programs like store procedure and functions to achieve business functionality.
• Developed complex store procedures to generate various Drill-through, Drill-down reports, parameterized reports, Matrix reports and Linked reports.
• Created numerous simple to complex queries, views and store procedures involving Multi-table joins and self joins and correlated sub queries with best execution plan.
• Hands-on development in complex data extraction utilizing SQL technologies such as Stored Procedures and SSIS. Engineer efficient, automated and reliable solutions to deliver accurate data results.
• Develop complex SSRS reports and scheduled delivery processes utilizing SSRS, SSIS and SQL jobs.
• Efficiently produce Ad-hoc SQL based reports in an on-demand environment.
• Worked on Improving, reengineer and optimize legacy reports utilizing available technologies.
• Maintain existing and develop new ETL processes to facilitate healthcare data exchange between SQL data repository, DataMart and other data sources

Environment: SQL Server 2012, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, Crystal Reports, XML, MS Excel, MS Access, Business Objects.

Confidential, Purchase, NY

Business Intelligence Reporter

Responsibilities:

• Developed and Optimized Stored Procedures and User-Defined Functions for teh Application.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created numerous simple to complex queries, views and store procedures involving Multi-table joins and self joins and correlated sub queries with best execution plan.
• Optimized store procedures and long running queries to using indexing strategies and query optimization techniques.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Generated Adhoc report based on teh statistical analysis of teh data from various time frame and division using SQL and SQL Server Reporting Services (SSRS).
• Used Reporting service (SSRS) to publish data to teh end user via HTML, PDF, Excel, and CSV formats.
• Involved with Query Optimization to increase teh performance of teh Report.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Formatted teh reports using teh Global variables and expressions in SSRS.

Environment: SQL Server 2012, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, Crystal Reports, XML, MS Excel, MS Access.

Confidential, Stamford, CT

Business Intelligence Developer/Analyst

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for teh Application.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Generated Adhoc reports periodically based on teh statistical analysis of teh data from various time frame and division using SQL.
• Generated Adhoc report based on teh statistical analysis of teh data from various time frame and division using SQL and SQL Server Reporting Services (SSRS).
• Developed various Ad hoc reports operational Drill-through and Drill-down using SSRS 2008.
• Created queries for generating drill down reports in SSRS 2008. Formatted teh reports using teh Global variables, expressions and Functions.
• Used Reporting service (SSRS) to publish data to teh end user via PDF, Excel, and CSV formats.
• Extensively worked with excel Pivot reports and Pivot charts for analyzing teh data from various systems for business needs.
• Developed Adhoc reports using Teradata SQL and Microstrategy.

Environment: SQL Server 2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, Crystal Reports, Teradata, MicroStrategy, XML, MS Excel, MS Access.

Confidential, Sandiego, CA

SQL Server Developer/ SSIS/SSRS

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for teh Application
• Used Try catch for exceptional handling.
• Interacting with Business Analysts and Developers in identifying teh requirements and designing and implementing teh Database Schema
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from Online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in teh data transfer
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various Ad hoc reports operational Drill-through and Drill-down using SSRS 2008.
• Created queries for generating drill down reports in SSRS 2008. Formatted teh reports using teh Global variables, expressions and Functions.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports.
• Used Reporting service (SSRS) to publish data to teh end user via HTML, PDF, Excel, and CSV formats
• Involved with Query Optimization to increase teh performance of teh Report.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Developed custom reports using SQL Reporting services.
• Dealt with Fine-tuning Stored Procedures to improve performance that was achieved through SQL tuning advisor.

Environment: SQL Server 2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, XML, MS Excel, MS Access.

Confidential, Newark, NJ

SQL Server developer

Responsibilities:

• Created and maintained versions of DDL for tables, indexes, constraints, views etc.
• Created several T-SQL/SQL views and functions to implement error handling
• Wrote various T-SQL stored procedures and Developed database Triggers to enforce data integrity and additional referential integrity.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Defined stored procedures for module integrity and application.
• Used multiple transformations in SSIS to meet teh business requirements by collecting data from various sources.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Created dynamic packages in SSIS to meet teh requirements and created Database Maintenance Plans for teh various data Sources and centralizing teh data using SSIS.
• Implemented teh database for production and marketing purpose.
• Designed and implemented several complex reports and administration modules in SSRS.
• Formatted teh reports using teh Global variables and expressions in SSRS.
• Used Reporting service (SSRS) to publish data to teh end user via HTML, PDF, Excel, and CSV formats.
• Supported OLAP team to providing data from SQL Servers.
• Developed Ad hoc reports using Complex SQL Queries.
• Managed ongoing activities like importing and exporting, backup and recovery.

Environment: SQL Server 2008, SSIS, SSRS, T-SQL, MS Excel, MS Access.

Confidential

Responsibilities:

• Major maintenance, Monitoring teh system performance and Reporting, bug fixes
• Creation and Maintenance of SQL Functions and Stored Procedures, Shell Scripts for existing system as part of bug fixing and enhancements.
• Worked on tuning teh SQL Queries by code review.
• Included in teh creation of tables by using all SQL constrains and data types.
• Developed SSRS Reports as per teh business requirements.
• Design documents for change requests/enhancements.
• Development of solutions for interfacing with other systems.
• Responsible for implementing and testing teh change request/enhancements.
• Testing and Deployment of Solutions.
• Anchoring teh defect Prevention activities.
• Developed test cases, performed functionality and Regression testing.
• Responsible for Tracking of incident response times and SLAs.
• Prioritize support activities and focus on critical business services.
• Performed teh root cause analysis for teh reported critical issues and ensured that SLA is achieved.
• Proactively interacted with other interface teammates whenever required to carry out teh CAT testing with ease during SIIAM UPGRADE.
• Supported during teh SIIAM Upgrade deployment.
• Involved in performance tuning using indexing (cluster index, non cluster index) tables.

Environment: SQL Server 2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, CRM Clarify, MS Excel, MS Access.

Confidential

Intern -Java Developer

Responsibilities:

• Involved in Designing, Debugging and Testing of form modules.
• Development of teh User Interface screens using teh Developer.
• Wrote transact SQL utilities to generate table insert and update statements
• Developing SQL*Reports
• Involved in coding of Triggers, Packages in teh Application Level at each and every Transaction.
• Analyze user requirements and report generation.
• Used Export and Import Oracle Utilities to Move Tables between Schemas.
• Designed menus and responsibilities to different level of users in teh organization.
• Assisted in documenting teh business flowchart, user manual and technical manual.