EXPERIENCE SUMMARY:

• Over 8 years of IT experience as a MS SQL Server Developer in various Industry verticals like Insurance, Healthcare, Banking, Telecommunications, Pharmaceuticals, Retail.
• Extensive experience in MS SQL Server 2008R2/2012, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Experience in developing the applications usingT - SQL Programming (DDL, DML, and DCL). Through Software Development life cycle (SDLC) experience.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel and MS Access CSV, flat file.
• Experience in working with BCP, and SSIS packages, creating jobs and linked servers for MS SQL Server/Sybase databases.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.
• Experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).
• Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS
• Expert in generating Drilldown reports, Parameterized reports, linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Built effective queries for high-performance reports and rendered them to HTML, PDF and Excel formats using SSRS.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions. Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Database consistency check using DBCC utilities and Database Engine Tuning Advisor.

TECHNICAL SKILLS:

Databases: MS SQL server 2005/2008/2012/2014 , Oracle, Teradata, MS Access

Languages: Transact: SQL, SQL, XML, HTML, PHP, C, C++, JAVA, MDX, and DAX.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

OLAP/ Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, Database Tuning Advisor, SQL server profiler.

Database Tools: SSMS, BIDS/Visual Studio, TOAD

Operating Systems: Windows XP/VISTA/2007/8/10, LINUX, UNIX.

Methodologies: Agile, Waterfall, Scrum

EXPERIENCE:

Confidential, Northbrook, IL

SQL Server BI Developer

Responsibilities:

• Worked as a developerin creating Stored Procedures, triggers, function, tables, and other SQLjoins and statements for applications.
• Created reports to retrieve data using database code objects, such as Stored Procedures, views functions and multiple T- SQLqueries.
• Handled slowly changing dimensions to maintain the history of data.
• Report Design and Coding for Standard Tabular type reports including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs using SQLQuery to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS.
• Created report models for ad hoc reports when the end user wants to see the reports on the fly.
• Responsible for Monitoring and Tuning Report performance by analyzing the execution plan.
• Responsible for making weekly backup databases by using SQL Server 2012 and restore these databases in different server.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for dataanalyzing.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Environment: MS SQLServer 2012/2014, SQLServer Integration Services (SSIS), SQLServer ReportingServices (SSRS), Visual Studio 2012/2014, SSMS, MS Excel, T-SQL, Crystal Reports.

Confidential, Norfolk, VA

SQL Server/BI Developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP.
• Production support, ad hoc queries meeting requirements from other development teams in a test driven agile development environment.
• Design and implementation of SSIS/ETL process for the system.
• Data conversion from mainframe system and Oracle databases to SQLserver.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Created/ modified stored procedures, functions, triggers, views and complex SQL statements for applications.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQLstatements using SQLprofiler.
• Worked with various Control Flows Tasks such as Send Mail Task, Bulk Insert Task, Execute Package Task and also worked on various Data Flow Tasks
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Modified stored procedures to meet current design and used them in SQLServer.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.

Environment: SQL Server 2008/2012, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2012/2014, Team foundation Server, OLE DB, SharePoint, Crystal Reports.

Confidential, Charlotte, NC

SQL BI Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in writing scripts for the client's requirements for reporting purposes.
• Responsible for writing T- SQLcode for creating cursor and handling the data validations.
• Developed complex T- SQLcode for the application.
• Maintained the physical database by monitoring performance, integrity and optimize SQLqueries for maximum efficiency using SQLProfiler.
• Monitored Scheduled jobs and alerts.
• Create new SSIS Packages to export flat files.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL developer for data to SSRS reports.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQLServer Reporting Services 2012/2008 using Oracle 11g as the data source.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex) reports to make minimize the report execution time and to limit the no of records required.
• Scheduled the SSIS jobs using SQLserver agent for daily, weekly and monthly loads.
• Used database maintenance plans for backing up the database and transaction log files.
• Comfortable mentoring others in my team for complex SSRS reports.
• Improved Report Performance and performed unit testing.

Environment: MS SQLServer 2008R2/2012, MS Analysis Services 2008, MS Access, SQL Reporting(SSRS)Visual Studio 2012/2014, Crystal Reports

Confidential, Dallas, TX

SQL BI Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Involved creating complex stored procedure based on business requirements.
• Worked as a database developeron databases like MS SQLServer 2008R2 using T-SQL, stored procedures and views to get data from Data warehouse.
• Created SSISPackages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQLTask, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSISpackages to dynamically execute on QA Server and Production server
• Deployed, Tested and Scheduled SSISpackages.
• Worked on designing reports using SSRS2012 mainly Parameterized reports and Sub reports.
• Printed contracts and reports from Quick Reports and Crystal Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Wrote PL/SQLStored Procedures, Functions, and Packages to implement Business Rules.
• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQLqueries.
• Deploying and scheduling Reports using SSRSto generate all daily, weekly, monthly and quarterly Reports including current status.
• Maintained report models for ad hoc reports and deployed on report server.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed incremental loading using MERGE statement in SQLserver 2008R2.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQLstatements using SQLprofiler
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

Environment: SQLServer 2008R2, T-SQL, SQL Profiler, Crystal Reports, Microsoft Visual Studio 2008, SSIS, SSRS.

Confidential, Irvine, CA

SQL BI Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and Access database, flat files to centralized SQL server destination. Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8minutes.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/SSMS on SQL Server 2005/2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when Data arrives and created indexes to the tables that have least updating to improve the query performance.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2005/2008, SSIS, T-SQL, Crystal Reports, Visual Studio 2008, MS Office, SQL Profiler, DTS Packages.

Confidential, Chesapeake, VA

SQL Server BI Developer

Responsibilities:

• Installed SQL server 2008, 2005 and applied service pack.
• Performance tuning of SQL queries and stored procedures using SQL Profiler
• Transformed and manipulated the data by using SSIS transformations and tasks.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Involved in daily maintenance of SQL servers.
• Fixing Performance issues by Indexing, Query Optimization etc.
• Used database consistency checks using DBCC utilities.
• Scheduled Jobs and Alerting using SQL Server Agent.
• Involved in troubleshooting all the performance issues for different database applications.
• Automated monitoring all the daily failed jobs in all the servers using system database, DTS and SQL Mail.
• Monitoring and scheduled jobs on production and staging environment.
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Performed data conversion from flat file into a normalized database structure.
• Created DTS package to export and import data from SQL Server to text files.
• Developed scripts for batch processing.
• Migrated data from Access 2003 to SQL server 2005.
• Created the DTS (SSIS) packages and scheduled them.
• Responsible for writing SQL Transactions, Creation and Enhancement of Stored Procedures.
• Expert in Reporting Services.
• Generated reports using MS Reporting services.

Environment: SQL Server 2005/2008, SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2008, DTS Packages.