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 with 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 the performance of queries with 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 with 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 the 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 the Dimensions and cubes with 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 the 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 the 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 with complex formulas and to query the 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 the Databases for the Bureau of Vital Statistics.
• Involved in creation and review of functional requirement specifications and supporting documents for business systems, and developed the Database design per the requirements.
• Migrated all the historical data from flat files to the 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 the database.
• Responsible for the performance tuning and optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Designed and scheduled SSIS packages to transfer the 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 the 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 the 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 the 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 the 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 the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked with 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 the performance of queries with 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 the Database Consistency Checks, scheduling the 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 with SQL Server Analysis Services (SSAS) and queried the data with 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 the 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 with 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 the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Data analysis and Reporting with extensive use of power pivot and pivot tables.
• Performed dynamic and interactive time series analysis with power view.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Databases, Tables, Views, Stored Procedures, Triggers using T-SQL.
• Used T-SQL extensively in creating efficient Stored Procedures for the optimal performance of the system.
• Responsible for creating and modifying T-SQL stored procedures for validating the integrity of the 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 with End user and changing the cubes and documentation according to the requirements.
• Involved in user based optimization design for creating Aggregations and pre-calculating the same in SSAS, identified the data source and the data source views.
• Conducted data migration processes from Oracle Server to SQL Server utilizing the 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 the various data sources, created packages for different data loading operations for many applications.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created different chart reports, helped in analyzing performance counters using SSRS.
• Created reports with Analysis Services Cube as the 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 the 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 the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the 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 the needs of the business case.
• Used Configuration Files in SSIS to ease the process of moving the 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 the Report Server to access it through browser.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Created Jobs Performance reports that queries system tables to track the 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 the 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.
• Effectively worked on Normalization & De-normalization of databases using T-SQL.
• Created documentation on the all the 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 the SQL Server databases as a developer helping administrator.
• Involved in the 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 the 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 the 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 with 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 the 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.