PROFESSIONAL EXPERIENCE:

• Over 6 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2015/2017 and 2018 in Production, QA and Development Environments.
• Strong experience with T - SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in upgrading SQL Server 2008/2008 R2/2012/2014 to SQL Server 2016 and data migration among versions.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and SSAS (analysis services).
• Expert in Extracting, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005, 2008 R2/2012 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
• Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Working experience of designing Ad-hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
• Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Experience in working with Database setup, partitions and maintenance.
• Worked on Jira and infra tickets daily which include updating SQL queries/reports.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL Server Developer

Responsibilities:

• Analyzed and identified the Test Cases based on design document of the application. Created daily, weekly and monthly financial reports, ROI reports and performance reports, outstanding loan by store, Performance by store.
• Involve in data integration project to integrate data from two different sources and loading data into a single Data warehouse to ensure data integrity.
• Created User Defined Functions, Views, stored procedures as per business requirements.
• Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data.
• Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks.
• Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating Database objects.
• Used control flow tasks like For Loop Container, for each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks.
• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.
• Involved in different kinds of Data Model Instance and they are Conceptual Design, Logical Design and Physical Design.
• Worked on Transforming and Loading data using SSIS Import/Export wizard.
• Developed Tabular Reports, Sub-Reports, Matrix Reports, drill down Reports and charts using SSRS.
• Performed sorting, formatting and grouping to custom reports in SSRS and also published reports to the report server virtual directory. Worked on Data Consolidation/Migration Project building.
• Performed successful installation and configuration of SQL Server 2017.
• Created Temporary tables with Temporary variables using Transact SQL (T-SQL).
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Hands on experience with developing reports using SSRS.
• Interacted with Developers in troubleshooting application and Report Developing.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance.

Tools: /Technology Used SQL Server 2016/2017, Visual studio 2015, SQL Server Integration Services (SSIS), Analysis Services (SSAS), Microsoft Visual studio 2013, Excel, VBA, C#

Confidential, Columbia, SC

BI Developer/SQL Server Developer

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Migration of DTS packages to SSIS packages and individually designed MS SQL Server 2008 database, coded stored procedures (T-SQL).
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Worked with various XML data and worked on creating ETL packages with loading all package in loop and loading them in SQL server
• Created package with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience with writing T-SQL, PL/SQL code and working on Dashboard and crystal reports
• Worked with Quest SQL Compare table and the data compare between Dev to Test and Test to Prod environment.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
• Created temporary tables and table variables while creating complex queries in SQL Server 2008/2012/2014.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Designing, developing, implementing, and maintaining reporting frameworks..
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Merging data into a single server environment to have better control, consistency and security of data.
• Worked with developing .NET application using ASP.NET, ADO.NET.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Adept at rebuilding indexes on various tables.
• Optimized the SQLs and Informatica mappings which handled millions of records
• Adept at debugging stored procedures using SQL Server Profiler.
• Restored QA server from development periodically to test the queries on the QA server.
• Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards.
• Worked on HL7 inbound and outbound interfaces. Define data specifications and map out data crosswalks. Understanding of interface messages and triggers such as A01 (Inpatient), A02 (Transfer), A03 (Discharge), A04 (Outpatient), A05 (PreAdmit), A08 (Update), A17, Merge messages, appointments, and other types of HL7 messages; ORM, ORU, DFT, MDM, MFNetc.
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Configured SQL mail agent for sending automatic emails when a SSIS process failed, succeed or completed
• Done front end ASP.Net application bridging to the back-end Database systems.

Tools: /Technology Used SQL Server 2008/2008 R2/2012/2014, Windows 2003/XP, Enterprise Manager, SSIS, SSRS, SSMS, SQL Profiler, T-SQL

Confidential, Philadelphia, PA

SQL Programmer

Responsibilities:

• Analyzed existing business scenarios and business rules. Worked as SQL Server Analyst / ETL Analyst using SQL Server 2008 R2/2012 for this Project.
• Source Controlling using IBM Rational Clear Case.
• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server .
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Experience in working with Medicare and Medicaid insurance data, Medicare parts A, B, C and D. Insurance pricing, Insurance Claim Adjudication.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Tools: /Technology Used SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Oracle, Visual Basic

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2016/2014/2012/2008 ), MS Access, MS Excel, Crystal Reports, Business Objects 4.0

Database: MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML and CSS

Operating Systems: Windows (10/8/7/Vista/XP), Windows 2015/2012/2008 Server

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.