SUMMARY

• Having more than 5 years of IT experience in Database Development, Administration, Data Analysis, and Mapping, System Analysis, Design, Development and Support of MS SQL Server 2016,2014,2012, in Production, Testing and Development
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low - level design documents.
• Proficient in design and development of Relational Database Management Systems, with strong experience on Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Proficient in Data Modeling up to 3rd Normalization form and Dimensional Modeling using Star and Snowflake schemas.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Strongly experienced on development, implementation, administration, and support of ETL workflows and processes for large-scale Data Warehouses using SQL Server SSIS.
• Expert in developing ETL workflow using SSIS packages- implemented Full, Incremental and Remigration workflows.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using on SQL Server 2016,2014,2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Extracted, transformed, and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
• Good working Knowledge with Facts, Dimensions, Measure Groups, Calculated Members, Hierarchies and Cube Partitions in Multi-Dimensional Cubes. Also developed Cube deployment strategy through XMLA file, Processing through SSIS package and SQL Agent Job.
• Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Extensive experience on delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Hands-on in development of Drill down Reports in SSRS and Generated daily, weekly and monthly reports for the manager.
• Developed Sub Reports, Matrix Reports, and Charts using SQL Server Reporting Services (SSRS).
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating databases / file groups/files/transaction logs.
• Responsible for 24X7 production support on a callout rotation basis for all SQL databases.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. 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.
• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance and can work in demanding project schedules.

TECHNICAL SKILLS

Languages: SQL, Web Services - C#, OLAP, VB.Net

ETL Tools: SQL Server Integration Services SSIS, SSRS, SSAS and DTS.

Databases: MS SQL Server (2016, 2014, 2012), MS Excess, DB2

Reporting: Crystal Report, SQL Server Reporting Services (SSRS)

DBATools: SQL, VMware, MS Visio, CA ERWIN

Operating Systems: Windows Server

PROFESSIONAL EXPERIENCE

SQL/ SSIS/SSRS Developer

Confidential, Detroit MI

Responsibilities:

• Involved in complete life cycle of Timesheet and Pay roll process including design, development, and testing.
• Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling the jobs.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, Advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Defined check constraints, rules, indexes, and views based on business requirement.
• Programmed User Defined Stored Procedures, Views, User Define Functions and Complex Queries as per complex business scenarios and rules.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.
• Created Temporary Table and Common Table Expression (CTE) for query Optimization.
• Applied various types of Control Flow tasks and Data Flow tasks like For Each Container, execute SQL task, Script task, Transfer For Loop Container, Aggregate, Derived column and Transfer Database Task according to need of Data Transform and Data Cleansing and insert new data into Database using SSIS packages
• Migrated XML data files, Flat files into SQL Server staging database. Imported the huge text files, CSV files data from FTP through SSIS to local environment.
• Used SSIS script task using vb.net and C# Script to create XML File and Flat File. Utilized ADO.net to connect SQL Server with application.
• Worked with SSIS to load data files to SQL Server and the other way. Maintaining the data, database Backups and Restoration, backup strategies, scheduling backups.
• Designed and developed Data warehouse environment for OLAP & Data mining in SSAS
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Developed Batch File, checkpoint file and Logging file for Data Integrity.
• Developed Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services (SSRS).
• Designed and maintained variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Deployed the SSIS Setup and Database Setup in production environments.
• Developed Standard Tabular and List Report for Management Purpose.
• Built Jobs using SQL Agent to run SSIS Package from Server.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Deployment of Scripts in Production and Test environments.
• Resolved Bugs in production Environment created by Quality Assurance.
• Reporting on a weekly basis to the project manager.

Environment: Microsoft SQL Server 2016, SSIS, SSRS, SSAS, Crystal Reports, MDX, XML, ETL, OLTP, OLAP, ASP.Net, C#, SQL Profiler, Java Script, Windows Server 2016

SQL/ SSIS Developer

Confidential, Arlington, TX

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.
• Modified the existing ERD's to insert more tables, columns and constraints using MS Visio 2008 for more refined data models.
• Worked extensively on development of T-SQL programs to create Tables, Views, and triggers Functions, Indexes and Triggers and stored Procedures.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Developed complex SQL Queries using multiple joins for Ad hoc reports using Report builder based on the business requirements
• Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.
• Created and maintained database for Server Inventory, Performance Inventory.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Used SSIS and T-SQL stored procedures to migrate data from various Claims processing (Mainframe), providers (Oracle), and Members (Access) databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed SSIS ETL packages to extract data from heterogeneous database and sources and then transform and load into the data mart, heterogeneous databases and sources include ORACLE, MS ACCESS, FLAT FILES, Excel Files etc.
• Configured and Deployed the SSIS Packages and developed jobs for efficient running of the packages. Also Involved in creating SSIS jobs to process the multidimension cube. Earned Expertise in Deploying SSIS Package to Production and used different types of Package configurations to export various package properties to make package environment independent.
• Fine-tuned various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.
• Used BCP to transfer the data files to another server.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Responsible for creating reports based on the requirements using SSRS.
• Responsible for creating parameterized and drill down reports based on the requirements using SSRS.
• Used TFS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Environment: MS SQL Server 2014, SQL server Integration Services, SQL Reporting Services, VSSMicrosoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, VisioWindows Server 2012 R2.

SQL/ SSIS Developer

Confidential, Minneapolis, MN

Responsibilities:

• Interact with clients to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Programmed complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Responsible for creating schema objects like tables, views and indexes.
• Programmed stored procedures to be used by front end report development.
• Programmed Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain Physical Structures.
• Utilized Dynamic Management Views, System Views for Indexing and other Performance Problems
• Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
• Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Implemented the Master Child Package Model in the EDW and Data-Mart for easier maintenance and better performance of SSIS Packages review.
• Worked in setting up auditing, logging environment to track the status of the events like error raise, task fail.
• Designed tool to automatically add derived column, parameter, and configuration value to the package.
• Developed SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, FTP Task, For Each Loop containers etc
• Troubleshoot failed jobs on the server which involved stored procedures/SSIS packages.
• Scheduled the SSIS packages to run at different intervals to load the data using SQL Server Agent.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server
• Work with DBAs, QA and systems support personnel in elevating and automating successful code to production.
• Used TFS for version control.
• Created documentation as required for operational support

Environment: SQL Server 2012, T-SQL, ODBC, TFS, MS Excel, MS Access, Visio, BIDS, Visual Studio 2013, Windows Server 2012

Jr. SQL Developer

Confidential, Minneapolis, MN

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement
• Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.
• Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other database objects as per the business requirements
• Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in tables for wholesale lending to different merchant banks Developing Power BI report using Power Apps Entity data and other Databases.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Developed SSIS packages to Push and Pull data using Rest APIs and other different sources and vendors.
• Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension and other transformations from different sources.
• Used different type of Transformations for Data Conversion, Sorting, and cleaning the data from different sources into Company format.
• Created Package Configurations, Event Handlers for On Error/Warning/Task Events.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packges.
• Maintained the physical reports by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Provide support to junior co-workers and work with offshore resources for knowledge share.
• Doing peer/ code review of co-worker abd junior developer and make necessary revision to make sure code best practice has been followed and to eliminate errors into PROD environment.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Created and updated data into CRM and providing support.
• Worked on Upgrading and automating manual jobs and scripts into SSIS and scheduled in sql agent.
• Used diffetnt types of files like XML, JSON to load the data into sql database using Cozyroc components.
• Developing test strategies, test plans based on functional specifications, use cases, and business requirements
• Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modelling

Environment: SQL Server 2012, Windows 2012 Server, Excel, Erwin, InfoPath, ESX 2.X, 3.X, SSIS