SUMMARY

• 7 + years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2012/2014/2016 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience using highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Plan deployments, moving from Dev to QA to Production environments
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Logical and Physical Database Design & Development for OLTP and OLAP
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Supported team in resolving SQL Reporting services and T - SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Has in-depth knowledge of Transact-SQL (Data Definition Language, Data Manipulation language).
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Designing and developing using ASP.NET framework through agile development methodology.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheet lately using SQL Server 2012/2014/2016 .
• Experience in generating drill down Reports, handling parameterized Reports in SSRS 2005.
• SQL Server 2014/2012 OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Microsoft Packages: MS- PowerPoint, MS- Excel, MS- Word

ETL and OLAP Tool: SQL Server Integration Services, SQL Server Analysis Services

Reporting Tools: SQL Server Reporting Services(SSRS), Power BI

RDBM: SQL Server 2012/2014/2016

PROFESSIONAL EXPERIENCE

Confidential, Florida

Senior MSBI developer

Responsibilities:

• Plan deployments, moving from Dev to QA to Production environments
• Responsible for providing 24x7 fast paced DBA support for production, staging and testing environment.
• Responsible for setting up and maintaining several staging, QA, testing and production environments.
• Creating and maintaining access for these environments to different type of users.
• Having experience in Project management, end to end planning, Coordination, implementation and setup of Database Servers.
• Logical and Physical Database Design & Development for OLTP and OLAP
• Developing reports and email alerts using SSIS and SSRS for care managers of services to be provided.
• Created and scheduled member authorization process and generating these reports.
• Involved in performance tuning of the databases, troubleshooting, managing the use of disk space (capacity planning), memory and connections.
• Responsible for creating SSIS packages to run remittance process (to process claims to be provided to the providers).
• Responsible for scheduling and monitoring SQL server agent jobs and Database Maintenance process in production and internal environment.
• Created jobs, alerts, log to monitor the critical errors.
• Daily monitoring of the database performance and network issues.
• Configured and maintained Transactional replication.
• Captured and analyzed the long running stored procedures using SQL Profiler and tuned the same to improve application performance.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created various complex T-SQL Queries, Stored Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Data center migration and also upgraded SQL Servers from 2012 to 2014 / 2016.
• Experience on working in Agile/Scrum environments.

Environment: SQL server 2016/2014, DTS, SSIS,SSRS, Import/Export tools, SQL Server Agent, FTP, Oracle, Power BI, Agile.

Confidential, Rockville, MD

MSBI developer

Responsibilities:

• Extensively working in data Extraction, Transformation and Loading from source to target system using SQL Server 2015 Integration Services.
• Importing Source/Target tables from the respective databases by using Execute Package Task using Control Flow Tasks in SQL Server 2015 Integration services.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Execute SQL Task, Email Task and Data Flow Tasks.
• Prepared Unit Test Specification Requirements
• Implementing various types of report execution techniques. Worked with parameters as filters on reports.
• Created the data flows using transformations such as the Derived Column, Union All, Conditional Split, Row Count, Audit and Script Component.
• Scheduled the ETL Package, Email, Store Procedures
• Creating Reporting DataMart, SQL Jobs
• Configuration Production server and DR server, UAT,DEV,ST
• Creating Power Bi Reports and Dashboard

Environment: SQL server 2016, DTS, SSIS, SSRS, Import/Export tools, SQL Server Agent, FTP, Oracle, Power BI

Confidential, NJ

BI developer

Responsibilities:

• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Expertise in generating reports using MS Reporting Services 2014/2012
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in writing VB scripts for user define functions in SSRS.
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Excellent command on subscriptions, report snapshot and report cache.
• Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Involved in dealing with off short team
• Created and modified Stored Procedures, Functions, and Indexes.
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Optimizing query performance with the help of Execution Plan and SQL Profiler.
• Created and scheduled Jobs using SQL Server Agent
• Used Event Handlers for Exception Handling in SSIS packages.
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities.

Environment: SQL server 2014/2012, DTS, SSIS,SSRS, SSAS, Import/Export tools, SQL Server Agent, FTP, Oracle