SUMMARY

• Having 8+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server in Development, Data warehouse, Test and Production Environments on various business domains like Banking, Financial, Insurance and Health Care.
• Expertise in writing complex T - SQL queries, Joins, Stored Procedure, Functions, Indexes, Query Optimization, Views, Normalization, Error Handling, Trigger and Temporary tables.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R 2/2012/2014.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS and SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Excellent knowledge in Scheduling Jobs and Alerts using SQL Server Agent.
• Extensive knowledge in managing and automating Control flow, Data flow, Events and Logging programmatically using .Net framework for SSIS packages.
• Expertise in maintaining Batch Logging, Error Logging with Event Handlers, Configuring Connection Managers using SSIS and hands on experience in trouble shooting database issues.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Experienced in writing the MDX queries to develop the Key Performance Indicator (KPI) Objects, Calculated Members, and Actions and to get the data from the OLAP cube for the reporting purpose.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Expertise in using Package Configuration Wizard to configure SSIS packages.
• Expertise in creating Report Models for building AD hoc reports using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in developing User reports and management reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS. Expertise in creating Cell Level Security in cubes using SSAS.
• Experience in migration and recreation of existing Dimensions and Cubes using Star Schema to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Experience in generating periodic reports based on the statistical analysis of the data using Power Pivot, Power View and power BI.
• Good team performer, strong interpersonal and communication skills with self-motivation and creativity individual.

TECHNICAL SKILLS

Operating System: Windows NT/XP/ 2000/2003/7/2008 servers.

Database Tools: SQL Server Management Studio, SQL Mail, SQL Alerts, SQL Integration Services (SSIS), SQL Analysis Services (SSAS), SQL Profiler and Query Analyzer.

Databases: MS SQL Server 2005/2008/2008 R2/2012/2014, MS Access 2007/2010 and Oracle 10g.

Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS), Import/Export Wizard and SAP Data Services.

Programming Languages: T-SQL, ASP.Net, VB.Net, Java, C and C++

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

MS SQL Developer/ MSBI Developer

Responsibilities:

• Created SQL server jobs using SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Designed and developed SQL SSIS packages to extract data from various data sources such as access database, Excel spreadsheet and flat files into SQL server for further data analysis.
• Enhancing performance using optimization techniques normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch process and scripts.
• Generated reports using global variables, expressions and functions for the reports.
• Generated and formatted reports using Expressions and Functions for the reports. Designed and implemented trendy report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names in SSIS.
• Performed the deployment of the developed Packages into various Environments and schedule them as Jobs through the SQL Server Agent.
• Worked on troubleshooting and updating various issues with the existing ETL process.
• Created and Modified Stored Procedures, Triggers, Tables, Views and making use of Merge Statements instead of Cursors in T- SQL Optimized queries by looking at Execution Plan for better tuning of the database.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Worked on Power BI and prepared dashboards to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI.
• Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Environment: MS SQL Server 2014, SQL Server Management Studio, Integration Services (SSIS), Reporting Services (SSRS), VB Script, Visual Studio, MS Excel, Power BI and MS Access

Confidential, Norristown, PA

MS SQL Developer/ MSBI Developer

Responsibilities:

• Creating SSIS Package Configurations and maintaining their tables by editing the values of the variables as per the requirement.
• Performed the deployment of the developed Packages into various Environments and schedule them as Jobs through the SQL Server Agent.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Involved in Performance tuning and Query Optimization using execution plan.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports. Configure the report server and generate the report models for user interactions.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access, Excel Spreadsheet and DB2 into SQL Server databases.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created copies of operational databases using the Import/Export Wizard and OLAP/OLTP environment.
• Worked on SSIS Script component using Visual Basic Applications and C#, by creating generic C# components that can be used in the external packages in SSIS.
• Created various types of reports such as drill down reports, matrix reports, sub reports, and chart reports using SQL server reporting services (SSRS).
• Hands on experience with Database development in OLTP and OLAP.
• Proficient in using SQL server integration (SSIS) to build data integration and workflow solutions Extract, Transform, and Load (ETL) solutions.
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access, Excel Spreadsheet and DB2 into SQL Server databases.

Environment: MS SQL Server 2012/2014, Integration Services (SSIS), Reporting Services (SSRS), MS Visual Studio 2012, SQL Server Management Studio, MS Excel and Windows 7.

Confidential, Sterling, VA

MS SQL/MSBI Developer (SSAS, SSRS)

Responsibilities:

• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created number of complex formulas to calculate the amounts related to different claims in sub reports using different types of variables like shared variable and retrieved them from master report.
• SSAS cube development in SQL 2012 for financial planning and operational performance metrics.
• Developed new data mining models using SSAS. Developed reports from SSAS Cubes and automate them.
• Created Dimensions with the cube wizard and individually and Generated Named calculations and named queries.
• Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, and calculated members using SSAS 2012 and wrote many MDX scripts while developing the reports from the cubes using SSRS.
• Created SSAS tabular model, calculated measures and data security for report data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in development and Production environment.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team. Involved in preparing training document for application development and QA/UAT teams.
• Developed reports using SSRS and crystal reports. Used table control, matrix control for cross tab reports.
• Developed and Extending SSAS Cubes, dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.

Environment: MS SQL Server 2012, SQL Server Management Studio, Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio, MS Access, MS Excel and Windows Server 2012.

Confidential, Tampa FL

MS SQL Developer/ (SSIS/SSRS) Developer

Responsibilities:

• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, Oracle and XML to create and maintain a centralized data warehouse.
• Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Extensively used Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.
• Developed T-SQL Queries, Triggers, Functions and Stored Procedures. Adding the new features to the existing stored procedures.
• Developed many stored procedures which acts as data source for the all the web-based and reporting applications here in this project. Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Chart-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
• Responsible for MS SQL Server in Production, Test, Development and Replication and Cluster Server Environments. Resolve any deadlocks issues with the Database/Servers on a real-time basis.
• Performed the deployment of the developed Packages into various Environments and schedule them as Jobs through the SQL Server Agent.
• Designed and developed various complex reports for customer service team. Generated reports that can handle dynamic grouping and dynamic sorting.
• Assist with writing and maintaining project documentation, including but not limited to formal requirements, design documents and test plans.

Environment: MS SQL Server 2012, SQL Server Management Studio, Integration Services (SSIS), Reporting Services (SSRS), MS Visual Studio, Power BI, MS Access, MS Excel and Windows 7.

Confidential, Boston, MA

MS SQL Developer/ MSBI Developer

Responsibilities:

• Created parameterized reports and Ad hoc reports using Report builder and developed dashboards with different KPIs, scorecards for the users/management and deployed them using Excel.
• Implemented modules of ETL process using several complex SSIS packages like Pivot Transformation, Derived Columns, Conditional Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task.
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Designed, created and deploying SSIS packages for transferring data from flat files, excel spreadsheets and heterogeneous data to and from SQL server.
• Created DTS Packages to copy tables, schemes, views and to extract data from Excel using SSIS.
• Provided statistical information through different reports to explain business conditions and scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Created complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
• Designed scripts for Sort Task, Fuzzy Lookup and Lookup Transformation to check for duplicate records and delete/modify/update them on this staging table depending on the business rule.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.

Environment: MS SQL Server 2008 R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Studio and Windows XP.

Confidential, Richardson, TX

MS SQL Server Developer (SSIS, SSRS)

Responsibilities:

• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Created audits/logging for SSIS packages on task level and package level.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Experienced in writing T-SQL, working on DTS, SSIS, SSRS, Data Cleansing and Data Migration.
• Created the datasets based in MDX Queries and implemented performance and analysis reports using SSRS.
• Created various types of reports such as drill down reports, matrix reports, sub reports, and chart reports using SQL server reporting services (SSRS).
• Tracking report usage by logging the information such as the number of times the reports has been viewed and user related information.
• Configure the report server and generate the report models for user interactions.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access, Excel Spreadsheet and DB2 into SQL Server databases.

Environment: MS SQL Server 2008 R2, MS Visual Studio, Integration Services (SSIS), SQL Server Management Studio, Reporting Services (SSRS), MS Access, MS Excel and Windows XP.

Confidential

MS SQL Developer

Responsibilities:

• Created new database objects like Functions, Procedures, Triggers, Packages, Indexes and views using T-SQL in SQL server.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Developed SQL Server objects such as Tables, Materialized Views, Clustered and Non-Clustered Indexes, Stored Procedures, Triggers and Constraints.
• Import and Export of data from one server to other servers using Data Transformation Services.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created Triggers, Views, User Defined Functions and Stored Procedures from DTS.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created custom Stored Procedures and Functions to support various operations.
• Migrated data from text fields and excel spreadsheets to SQL Server database using DTS.
• Created backups and recovery procedures for altered databases and implemented automated jobs for database backup.

Environment: MS SQL Server 2008/2005, T-SQL, Visual Studio, MS Excel, MS Access, SQL Server Management Studio and Windows XP.