SUMMARY:

• Over 7 years of Strong experience in the IT industries as SQL Developer and Business Intelligence Developer.
• Experience in data warehouse development with Integration Services (SSIS), Analysis services (SSAS) and Report development (SSRS).
• Working in implementing Cloud Services.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experienced in creating and using CTE, Cursors, Functions, Triggers and Stored Procedures.
• Excellent knowledge of Software Development Life Cycle (SDLC), Data Warehouse Life Cycle (DWLC), Agile.
• Performed ETL implementation using SQL Server Integration Services (SSIS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Extensive experience performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Identified Critical Success Factors (CSFs) and developed Key Performance Indicators (KPIs) for generating reports.
• Experience in developing Custom Report and different types reports like Tabular Reports, Matrix Reports, Ad hoc reports, Drill Down, Drill Through and distributed reports using SQL Server Reporting Services (SSRS).
• Expert in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports and formatting them.
• Experience in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS) and Worked on Data modeling, creating star schemas in SSAS.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Implemented the new SQL Server 2014 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Understanding of how Power BI works in extracting data from OLE DB systems and generating reports.
• Exposure in using Team Foundation Server (TFS) and Git as a source control, source repository and project tracking solution.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills, good team player and ability to acquaint to fast changing skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2012, 2008, 2003, 2000, XP, NT, Linux, Unix.

Databases: MS SQL Server 2016/2014/2012/2008 R2/2005, Sybase, Oracle, MYSQL, Postgres.

ETL and Reporting tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS), Tableau

Database Tools: SQL Server Management Studio, BIDS, SSDT(SQL Server Data tools), SQL profiler, SQL Query Analyzer, Index Analyzer, DTS

Data Modeling Tools: Erwin, Red gate, SQL Lite speed, Fog lite, Redshift, Backup Utility, Visio, Veritas NetBackup

Languages: T-SQL, C#, .Net, Visual Studio, C/C++, Shell Script, PERL, Javascript, XML, HTML, Python.

Network Topologies: Microsoft Office Suite

Version Control: TFS, Git

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

SQL Server Developer

Responsibilities:

• Involved in creating database objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures and Constraints.
• Created and developed the Stored Procedures, Triggers to handle complex business rules. Wrote complex SQL statements using Joins, Sub-queries, Correlated Sub-queries and CTE.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Designed SSIS packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in Incremental data loading.
• Developed SSIS 2012 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2014/2012 for further Data Analysis and Reporting by using multiple transformations.
• Involved in development of Incremental Load process using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed stored procedures, for automating the process of performing tests to identify major employee expenses, cost cutting, monitor KPIs and overall employee expense management
• Involved in Identified Critical Success Factors (CSFs) and developed Key Performance Indicators (KPIs) for generating reports.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Involved on call production support 24/7 for Production Jobs.
• Involved as a Lead for UAT team for bug fixes and production issues.
• Involved in transforming data from dev into Stage & Prod environments using BCP Process.
• Participated in Sprint meeting and updating status on reports in Agile Environment.

Environment: SQL Server 2014/2012, SSIS, SSRS, SSAS, Visual Studio 2012, ASP.NET, Team foundation server 2013

Confidential, Columbus, OH

SQL Server Developer

Responsibilities:

• Created new database objects like procedure, functions, packages, triggers and views using T-SQL in development production environment for SQL server.
• Deploy SSRS report in SharePoint for web-based access for multiple end users.
• Developed SSIS Packages to Extract, Transforms and Load data into data warehouse database from heterogeneous database data sources.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
• Hand on experience in Business Intelligence Process for Data Integration and Migration services.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Tables using Analysis Services.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Tableau, Visual Studio 2010, MS Excel, Windows XP.

Confidential

SQL Server Developer

Responsibilities:

• Developed Queries for generating drill down and drill through reports in SSRS 2008 R2.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Worked in agile methodology to discuss status and product backlog in scrum methodology.
• Created Linked servers to connect OLE DB data sources and providers.
• Administered the SQL Server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Based on the mapping document, with the use of MS Visio have created Dimension and facts for the dimensional modeling in data modeling.
• Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency
• Designed and developed web user controls, master pages, validation controls, CSS files using C#.NET, VB.NET, XML, HTML and ASP.NET 2.0/3.5.
• Designing Logical and Physical Data Model with Erwin tools
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes.
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed and deployed reports with Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
• Managing security roles in SQL Suite
• Created data packages and modeling data integration flows with SSIS from various data sources.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server 2008, T-SQL, SQL Profiler, SQL Server Agent, MS Visio, MS Excel, XSLT, Visual Studio 2010, Asp.NET, VB.NET, C# .NET, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's & MDX Queries using SQL Server 2008R2 Analysis Services.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS.
• Involved in 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 using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution.
• Involved in testing, bug fixing and documenting the work for the project at each and every phase.

Environment: MS SQL Server 2005/2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), SSDT, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.