SUMMARY

• Results - driven, customer focused IT professional with 10 years’ experience in the IT industry, 6 years progressive experience as a Microsoft SQL Developer. Worked extensively on query writing and ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions (SSRS, Qlik, Power BI, Tableau), SQL Server Analytical Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

• Worked Extensively on ETL process using SSIS package.
• Excellent in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent and scheduled Jobs using SQL Server Agent.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2 as SSIS Packages.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Collaborate with data architects for data model management and version control.
• Developed physical data models and created DDL scripts to create database schema and database objects
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Developed functions, views and triggers for automation
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Installing SQL Server Client side utilities and tools for all the front-end developers/programmers.
• Obtained and evaluated relevant information to handle inquiries and complaints
• Kept records of customer interactions and transactions
• Prepared weekly sales reports for the sales team and sales management
• Involved in performance tuning to optimize SQL queries using query analyzer.
• Understanding of HIPAA

Confidential

SQL Developer

Responsibilities:

• Developed new Data Warehouse System and implementing the packages and reports as per the requirements of the internal departments involving Accounts, Finance and HR. Creating and enhanced the RDBMS systems on existing Payroll/Financial Databases using SQL server and BIDS (SSRS, SSIS)
• Design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting. Tested and analyzed relational and OLAP data. Enforced different business constrains and rules using triggers and check constraint.
• Capture & clarification of business requirements through a range of analysis techniques (data flow diagrams, sequence diagram, case tool analysis, gap analysis and work & process flow diagrams).
• Involved in conducting meetings for Agile projects requirements sessions with stakeholders and able to articulate and create the requirements in User Story format. Worked with stakeholders, Product Owner for effectively scoping/user stories.
• Responsible for the creation of reports/cubes using SQL Server 2016 Reporting Services (SSRS) and Analysis Services (SSAS). Created various reports using MS Reporting Services (SSRS) and deploy public reports in dynamic Web portal.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• 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.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects. Developed dimensions and fact tables based upon the requirements and based on these facts and dimensions, designed SSAS cubes.
• 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 reports that can handle dynamic grouping and dynamic sorting. Was involved in Debugging and then scheduling the reports to run automatically. Created monthly dashboard Reports for automatic changing of User Credentials.
• Provided technical support to internal developers and external clients. Set up database backup and recovery strategies

Confidential

Remote Help Desk Support Specialist

Responsibilities:

• Managed call center activities to meet service level agreements
• Performed PC support and maintenance for over 100 people
• Create help desk documentation with step by step instructions on problem resolving techniques
• Respond to queries pertinent to package details, e-commerce solutions, email configurations and search engine submission packages
• Installed operating system, software, antiviruses and patches
• Provide technical support to customers via telephone, email and through tickets
• Assigned and regulated permission on demand