Summary
Overview
Work History
Skills
Timeline
Generic

Your Name

Summary

Over 5 year of IT Experience in Database Design and Bi development on MS SQL Server 2014, 2012,2008 versions on various development, test and production environments with various business domains. *Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). *Proficient in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes Created various Complex Formula Reports to query the database for business Intelligence. *Strong DBA/Development skills writing T-SQL scripts, worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generating various types of reports using SSRS on OLAP databases. *Demonstrated expertise in MS SQL Server 2012/2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts. *Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan. *Evaluates and refine Business Intelligence goals, business objectives, decision support needs, data and performance requirements to meet departmental/project level objectives. *Provides design support for the development of business intelligence solutions. *Works on multiple tasks/projects as team member. *Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems. *Proficient in the use of query and reporting analysis tools. *Standardize data collection by developing methods for database design and validation reports. *Evaluates and validate quality of performance on completeness of Business Intelligence models and solutions. *Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions. *Experience in deploying created reports in various sources like Web browser, XML and PDF. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. *Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

Overview

5
5
years of professional experience

Work History

SQL Developer

Wells Fargo
Great Falls, MT
01.2016 - 04.2017
  • Involved in Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
  • Installed SQL Server 2014 and Management tools using SQL Server Setup Program.
  • Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
  • Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
  • Perform DML, DDL Operations as per the Business requirement.
  • Creating views and prepares the Business Reports.
  • Resolved production issues by modifying backend code as and when required.
  • Used different joins, sub queries and nested query in SQL query.
  • Documented the data such as entity relationships and attributes, file descriptions and definitions.
  • Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
  • Testing of code functionality using testing environment.


SQL/Bi developer

Neogenomics Laboratories
06.2014 - 12.2015
  • Created SQL Server Reports using SSRS for management.
  • Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
  • Documented the data such as entity relationships and attributes, file descriptions and definitions.
  • Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical requirements.
  • Participated in developing logical model and implementing requirements on SQL Server 2012.
  • Created the database for the reporting team.
  • Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
  • Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • To keep track of data manipulations using Audit functionalities.
  • Generated custom and parameterized reports using SSRS.
  • Reorganized database structures as needed, automated procedures at regular intervals.
  • Optimized long running Stored Procedures and queries for effective data retrieval.
  • Optimized SQL queries for improved performance and availability.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.

SQL developer & Tester

Wells Fargo
Greenwich
04.2013 - 05.2014
  • Participated in developing logical model and implementing requirements on SQL Server 2008.
  • Created the database for the reporting team.
  • Solved various T-SQL issues using Query Analyzer.
  • Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
  • Created ad hoc T-SQL Queries.
  • Created backup and restore operations.
  • Created Database Triggers to implement business requirements.
  • Created complex Stored Procedures and Functions to support the front-end application.
  • Optimized SQL queries for improved performance and availability.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
  • Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
  • Reorganized database structures as needed, automated procedures at regular intervals.
  • Optimized long running Stored Procedures and queries for effective data retrieval.
  • Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
  • Worked with DBA to maintain referential integrity by defining table and column level options such as primary/foreign keys, cascade delete and column constraints on applicable data-mart tables.
  • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

SQL Developer

Cognizant
City, STATE
05.2012 - 03.2013
  • Participated in developing logical model and implementing requirements on SQL Server 2008.
  • Created the database for the reporting team.
  • Optimized SQL queries for improved performance and availability.
  • Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
  • Designed and developed the database based on these requirements.
  • Carried out a Developer's role on MS SQL Server 2008, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views).
  • Involved in migration of SQL server 7 to SQL server 2008 using Upgrade Advisor.
  • Installed and Configured SQL Server 2008, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to the database.
  • Involved in assisting QA team in deploying and testing the application, which uses SQL Server as a database.
  • Involved in creation of stored procedures, triggers using T-SQL according to the requirement of the projects.
  • Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.

Skills

  • Languages: SQL HTML, XML MySQL, Oracle 11g/10g/9i, MS SQL Server 2016/14/12/08, DB2 v81
  • Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server
  • Operating System: Windows 08/07/05/NT/XP, Linux, Mac
  • ETL Tools: Informatica Power Center 961/86 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Data manager10x, SSIS/SSRS
  • Developments tools: Microsoft Visual Studio 2015/13/12/10/08 and 2005, PowerShell
  • Tools: MS Visual Studio, MS Office (Word, Excel, PowerPoint, Access)

Timeline

SQL Developer

Wells Fargo
01.2016 - 04.2017

SQL/Bi developer

Neogenomics Laboratories
06.2014 - 12.2015

SQL developer & Tester

Wells Fargo
04.2013 - 05.2014

SQL Developer

Cognizant
05.2012 - 03.2013