SUMMARY

• Over 8 years of IT Experience as a SQL Server Developer / Business Intelligence Developer in analysis, design, development, testing, Deployment and Maintenance of SQL Server Technologies.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2008/ 2012 / 2014/ 2016.
• Experience in Database Design, Development and maintenance of database applications on SQL Server 2008/20012/2014/2016 R2 in OLTP / OLAP / BI environment.
• Proficient inETL (Extract - Transform - Load)using SQL Server Integration Services (SSIS).
• Proficient in T-SQL Queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL and etc.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, Form,OLAP and Sub reports, and formatting them.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report on SSAS Cube and using SSRS to develop Drill-down, Drill-through And Cascading reports.
• Experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Expertise in OLTP / OLAP system study, developing Database Schemas like STAR Schema and Snowflake Schema used in relation, dimensional and multidimensional modelling.
• Experience in creating various database objects in C#, Visual Studio and ASP.net and deploying them to the SQL Server.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL ServerSSIS.
• Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de-normalized reporting systems (OLAP) as well as staging areas, Data marts.
• Expert in Cube designer in Business Intelligence Development Studio (BIDS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
• Experience in creating jobs, SQL Mail Agent, Alerts and scheduleSSISPackages.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages toSSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Expertise with scheduling and monitoring jobs using SQL Server Agent to perform hourly/daily/monthly data loads.
• Good communication and interpersonal skills. Strong points include quicker grasp to new concepts, the ability to pursue matters in great detail and able to work in a team.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012/2008 R2,2005, MS-Access 2000

Database Tools: SSMS, BIDS/Visual Studio

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSRS,SSAS

RDBMS: SQL Server 2005/2008R 2/2012/2014/2016 , Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012/2013

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP, Windows 7/8

Other Tools: Erwin, Visio, Visual SourceSafe, MS Office suite

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

SQL Server Developer

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data tables.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created functional specification document and technical specification document.
• Created logging, custom logging and error handling packages.
• Converted data types using Derived Column, Data Conversion Transformation.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed cursors and views to improve performance in data transactions.
• Performed job scheduling in the SQL Server Environment.
• Worked with Transactional and Snap-shot Fact-Tables.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services, SQL Server Reporting Services, DTS, MS Access, MS Excel, Windows 2008 servers, T-SQL, PL/SQL,.Net, VBA, Visual Studio 2013.

Confidential, Phoenix,AZ

ETL Developer /MSBI Developer

Responsibilities:

• Created new databases and objects such as tables, stored procedures, constraints, and indexes to maintain referential integrity of data T-SQL for SQL Server 2014.
• Worked in Extracting Transforming and Loading (ETL) data from Excel. Flat file to MS SQL Server by using SSIS.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Migrated SSIS Packages from SQL server 2008 to SQL Server 2014.
• Immensely used the transactions concept to take care of all the DML queries that are executed in the stores procedures and roll backed the transactions whenever the stored procedure is errored out.
• Created packages using SSIS SSMS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed unit test plans for SSIS packages. Modified the existing SSIS packages to meet the changes specified by the users. Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Developed packages to handle data cleaning, loading multiple files and executing tasks multiple times (using for Each Loop).
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2014.
• Generated Sub-reports, Drill-down, Drill through and Parameterized reports using SSRS 2014.
• Created reports to retrieve data using stored procedures that accept parameters.
• Worked as developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, views and other T-SQL code and SQL joins for applications.
• Created Grouping, sorting columns and writing expressions as per business requirements.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in creating and updating Indexes and Statistics to keep up the SQL Server Performance.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Practical involvement in creating dimensions using STAR and SNOWFLAKE schema.
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Extensive used Team Foundation Server to implement version control for MSBI(SSIS/SSRS/SSAS) projects.

Environment: SQL Server 2012/2014, SSIS (2014/2012), SSRS (2012/2008), SSAS (2014/2012), Visual Studio 2010/2013, MS Excel 2010, T-SQL, C#, VB Script, Window 7, Team Foundation Server.

Confidential, Portland, OR

SQL BI Developer

Responsibilities:

• Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Optimized queries tuned and monitored server performance using SQL Profiler.
• Implemented different types of constraints on tables.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Developed SSIS solution for developing a fully-fledged data warehouse solution.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Responsible for creating the reports based on the requirements using SSRS 2012.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Identified and defined the Datasets for the report generation.
• Deployed the generated reports directly on the client’s workstation.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented the calculations to aggregate physical measures.
• Involved in writing scripts for the clients requirements for reporting purposes.
• Actively supported business users for change in requests. Gathered user requirements.
• Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.

Environment: SQL Server 2012, SSIS (2014/2012), SSRS (2012/2008), SSAS (2014/2012), Visual Studio 2010/2013, MS Excel 2010, T-SQL, C#, VB Script, Window 7, Team Foundation Server.

Confidential, San Antonio, Texas

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in creating technical specification documents after gathering requirements from business users.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and automated stored procedures.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using SQL Server Agent.
• Writing VB.NET and C# coding in Script task and script component.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Managing and automating Control flow, Data flow, Events and Logging for SSIS packages.
• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).
• Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS). Promoted RDLs to Reporting Service Server.
• Defined relationships between Dimensions and Measure groups.
• Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Defined Granularity with in a measure group and drill through actions.
• Planned Backup strategy based on projects requirements.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.

Environment: SQL Server 2012, Business Intelligence Development Studio, SSRS 2012, SSIS 20012, MS Visual Studio 2008, T-SQL, C#, VB Script, Window 7, Team Foundation Server.

Confidential

Junior SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2008 successfully on Windows Server 2003.
• Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
• Error handling using Try-Catch Block.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
• Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
• Created Master Child package using variables and Execute package task in SSIS.
• Assisted the front end application developers with their queries.
• Taking Databasefull Backup, Transaction log backup & differential backups.

Environment: SQL Server 2008, T-SQL, VB, MS Word 2005, DTS, SQL Profiler, Visual Source Safe, DTS/SSIS 2008, Import and Export Wizard, BCP, Windows Server 2008 UNIX.