SUMMARY

• Over 8 years of experience as a SQL Server Developer and BI Developer.
• Worked in various business domains like Healthcare, Insurance, Finance, and Retail.
• Worked closely wif customers, end users and collected requirements, resolved business process related issues.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large and Complex Databases.
• Expert in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Hands on Experience in Developing, Testing, Monitoring and Troubleshooting SQL Server 2014/2012/2008 R 2/2008/2005.
• Skilled at upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.
• Optimized teh performance of queries wif modifying T-SQL queries, normalized tables, established joins and created indexes.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Extensively Monitored Performance wif multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Experienced in strategically implementing teh indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Hands on experience in migrating data from Oracle to SQL Server.
• Expert Knowledge of Microsoft Business Intelligence tools that includes Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.
• Experienced in Designing and Building teh Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experienced in enhancing and deploying teh SSIS Packages from development server to production server.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Proficient in creating different Package Configurations such as SQL Server, XML configuration and Parent package variable.
• Implemented different Logging in SSIS packages to log events during teh run time.
• Experienced in designing, developing, and deploying professional and polished reports using SSRS.
• Experienced in creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Created Reports wif complex formulas and to query teh database for business Intelligence.
• Experienced working on different Data Visualization tools like Tableau, and Power BI.

TECHNICAL SKILLS

Programming Languages: VB.Net, T-SQL, PL/SQL

Databases: MS-SQL Server 2005/2008/2008 R2/2012/2014, Oracle 9i/10g, Microsoft Access

Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, Excel,SQL Server Management Studio (SSMS), Visual Studio, Enterprise Manager, SQL Profiler, SQL Server Data Tools (SSDT), Tableau, Power BI, SQL Server Analysis Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL Server Database Developer

Responsibilities:

• Built, maintained and tested teh Databases for teh Bureau of Vital Statistics.
• Involved in creation and review of functional requirement specifications and supporting documents for business systems, and developed teh Database design per teh requirements.
• Migrated all teh historical data from flat files to teh SQL Server using SSIS packages.
• Created stored procedures, triggers, functions, indexes, views, joins and T-SQL codes for applications.
• Managed indexes, statistics and optimized queries by using execution plan for tuning teh database.
• Responsible for teh performance tuning and optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Designed and scheduled SSIS packages to transfer teh data from flat files to databases daily, and created alerts for successful or unsuccessful completion of scheduled jobs.
• Created SSIS packages using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, Slowly Changing Dimension, and Change Data Capture.
• Dynamically supported end users for given requirements and developed teh SSRS reports accordingly.
• Generated Drill Through, Drill Down, and Ad hoc Reports. Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server. Scheduled teh monthly/weekly/daily reports to run automatically.
• Generated Tabular reports, Linked reports, parameterized reports, and generated reports that can handle dynamic grouping and dynamic sorting.
• Trained teh internal developers to create ad-hoc T-SQL queries, SSRS reports, and SSIS Packages, and provided them technical support.

Environment: MS SQL Server 2012, SQL Server Management Studio (SSMS), T-SQL, SSRS, SSIS, Microsoft Excel, C#.Net, SAS.

MS SQL/BI Developer

Responsibilities:

• Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing SSAS cubes.
• Loading data from various sources like Excel, flat files, to SQL Server database using SSIS Packages.
• Configured SQL mail agent for sending automatic emails when an SSIS package fails or succeeds.
• Extensively designed packages using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
• Developed different transformations like fuzzy lookup, derived column, Look up, Row count, OLEDB Command, and Data conversion task transformations in SSIS.
• Participated in reviews of issues related to SSIS packages/SSRS reports, and worked on troubleshooting those issues, fixing, testing and redeploying them.
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and Scheduling teh SSIS packages in SQL Server Agent.
• Responsible for monitoring daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SSIS.
• Responsible for Deploying teh SSIS packages and scheduling teh package through Jobs in all Tiers including Dev, UAT and Prod, Setting teh Configuration files which is done in teh specified tables and created technical specs documents for all teh enhancements.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked wif Tabular reports, Matrix reports, Gauges and Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drilldown reports, Drill through reports as well as Interactive reports per business requirements in time restricted environment using SSRS.
• Responsible for writing complex T-SQL queries and Stored Procedures for generating reports.
• Deployed reports on Report Server and SharePoint Server, also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports.
• Created User Defined Functions, Stored Procedures, and Triggers using T-SQL.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Responsible for creating constraints, Indexes, and Views using T-SQL.
• Optimized teh performance of queries wif modifying T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Performance tuning of T-SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Scripting teh Database Consistency Checks, scheduling teh scripts to run daily and weekly basis.

Environment: MS SQL Server 2012/2014, SQL Server Management Studio (SSMS), T-SQL, SSRS, SSIS, SSAS, Microsoft Excel, Team Foundation Server (TFS), C#.

Confidential, Chevy Chase, MD

SQL SSIS/SSRS Developer

Responsibilities:

• Created multidimensional OLAP cubes and dimensions wif SQL Server Analysis Services (SSAS) and queried teh data wif MDX script.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked on configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix teh errors in SSIS.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load (CDC).
• Performed control flow tasks like check database integrity task, backup database task, transfer jobs task, transfer logins task, transfer mastered stored procedures task.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts and sub reports.
• Created Linked reports and Ad-hoc reports based on teh requirement. Linked reports are created in teh Report Server to reduce teh repetition teh reports.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Data analysis and Reporting wif extensive use of power pivot and pivot tables.
• Performed dynamic and interactive time series analysis wif power view.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on teh given specs and requirements.
• Created Databases, Tables, Views, Stored Procedures, Triggers using T-SQL.
• Used T-SQL extensively in creating efficient Stored Procedures for teh optimal performance of teh system.
• Responsible for creating and modifying T-SQL stored procedures for validating teh integrity of teh data.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server.
• Used SQL Server error logs and event viewer to troubleshoot issues.

Environment: MS SQL Server 2008R2/2012, SSRS, SSIS, SSAS, T-SQL, Excel (Power pivot, pivot table), power view, share point server, MDX.

Confidential, Falmouth, ME

BI Developer

Responsibilities:

• Reviewed SSAS Cubes wif End user and changing teh cubes and documentation according to teh requirements.
• Involved in user based optimization design for creating Aggregations and pre-calculating teh same in SSAS, identified teh data source and teh data source views.
• Conducted data migration processes from Oracle Server to SQL Server utilizing teh SSIS Development platform.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Created and executed SSIS packages to populate data from teh various data sources, created packages for different data loading operations for many applications.
• Involved in extracting teh data using SSIS from OLTP to OLAP.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Created different chart reports, halped in analyzing performance counters using SSRS.
• Created reports wif Analysis Services Cube as teh data source using SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions and stored procedures using T-SQL.
• Involved in performance tuning of T-SQL queries using indexing (Cluster Index, Non-Cluster index) tables.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SSAS, Visual Studio 2008, Performance Monitor, Query Optimizer, Oracle 9i, MS Access.

Confidential, Bentonville, AR

SQL/BI Developer

Responsibilities:

• Understanding Program specifications based on Business and Data requirements and to develop ETL solutions based on these requirements and specifications.
• Extracted teh data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into teh target Data warehouse using SSIS.
• Designed SSIS packages using Transformations Sort, Merge, Merge Join, Union, Union ALL, Lookup, Aggregate, OLE DB Command and Derived Column.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match teh needs of teh business case.
• Used Configuration Files in SSIS to ease teh process of moving teh packages across servers.
• Configured SQL mail agent for sending automatic emails when a SSIS package fails or succeeds.
• Using SSRS, Deployed and generated reports of each quarter onto teh Report Server to access it through browser.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Formatted teh SSRS reports using teh Global variables, expressions and Functions.
• Created Jobs Performance reports that queries system tables to track teh duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, and SQL parameters.
• Creating, manipulating and supporting teh SQL Server databases.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• TEMPEffectively worked on Normalization & De-normalization of databases using T-SQL.
• Created documentation on teh all teh tables, stored procedures, views and user defined functions.

Environment: MS SQL Server 2005/2008 Enterprise Edition, T-SQL, Management Studio, SSIS, SSRS, SSAS, Visual Studio 2008.

Confidential

SQL Server Developer

Responsibilities:

• Maintained and supported teh SQL Server databases as a developer halping administrator.
• Involved in teh Data modeling, Physical and Logical Design of Database.
• Created and modified Stored procedures, triggers and User defined functions using T-SQL.
• Used profiler to monitor teh performance, Debug T-SQL statements and stored procedures in existing application, to identify slow running queries.
• Used DTS packages to do file operation, to apply business rules.
• Extensively used Ultra-Edit to verify teh text file provided by employer/agency and keep trace of files provided by employer/agency.
• Transformed data from text file to SQL server using SSIS.
• Deployed database objects from development/testing environment to production environment.
• Created DTS package to export and import data from SQL Server to text files and data files.
• Worked wif Application Developers to support Development activities and achieve optimal efficiency.
• Monitored and scheduled existing/new jobs on production environment.
• Keep trace of version of store procedure in Visual SourceSafe.
• Created user profiles and corresponding read, write and DDL and DML access properties were maintained on teh database.
• Responsible for keeping system and databases up-to-date by making necessary changes.

Environment: MS SQL Server 2005/2008, DTS, SSIS 2005/2008, SSRS 2005/2008, T-SQL.