SUMMARY

• Enthusiastic, Flexible and Goal oriented team player with extensive experience as SQL server developer with around 6 years of experience in Health, Banking and Insurance. With strong understanding of data; analytics worked in analyzing and developing Client/Server database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server, SQL Server Integration, Reporting. Worked extensively on T - SQL coding and creating reports.
• Great skills in gathering requirements, understanding and analyzing the requirements.
• Worked in collaborative team environment with other developers, business analysts and with project management teams, QA team, App Support team.
• Experience in developing and maintaining database using complex queries
• Generate complex T-SQL queries using Joins, Sub-Queries to fetch data and analyses data.
• Experience in generating SQL Scripts to modified data and to perform daily database management tasks.
• Experience in developing and maintaining T-SQL, PL/SQL Procedures, Functions, Joins, Sub Queries, Views and, Constraints, Transactions, Tables, temp tables, table variables and Indexes.
• Wrote T-SQL, PL/SQL procedures to generate DML and DDL scripts that modified database objects dynamically based on user inputs.
• Proficient in Extracting, Transforming and Loading (ETL) data from different type sources such as Excel, Oracle, and Flat file using SQL Server Integration Services (SSIS) from OLTP to OLAP
• Highly experienced in creating and executing SSIS packages to extract transform and load data. Worked extensively on various data sources and different transformations in SSIS
• Experience in error handling and event handling: Precedence constraints, break points, check points and logging towards SSIS package execution in SSIS
• Experience in Deploying SSIS packages, job scheduling, SQL mail agent using SSIS catalog (SSIS integration service server)
• Experience in generating on-demand and scheduled reports for business analysis or management decision using (SSRS).
• Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to Users on-demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
• Experience in Configuring and maintaining Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in designing visual report solutions, including dashboards using SSRS and other data visualization/dashboard tools like Power BI.
• Used Power BI Desktop to connect various data sources and worked with different visualizations and created dashboards.
• Transformed and combined the data using Query Editor in the Power BI.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C, python, HTML5, CSS3, JavaScript

Operating Systems: Windows, MacOS

RDBMS/ Databases / Database Tools: MS SQL Server, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database

Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS

Reporting Tools: MS Reporting Server (SSRS), Excel Power View, Power BI

Others: SharePoint, SVN, Team Foundation Server (TFS), Microsoft Office, Salesforce, Jira

PROFESSIONAL EXPERIENCE

Confidential, BENSALEM PA

SQL Developer/Data analyst

Responsibilities:

• Gather the requirements of project from business analyst and App support team, Analysis the requirements and work with developers, DBA and testers to execute the task.
• Collaborate with senior DBAs to develop the store-procedure and implement logic for required business rule
• Expertise in working the life cycle of project from start to end by implementing the Agile process.
• Actively Participate in trouble shooting of claim process for eclipse application and Resolved the issue through modifying the store-procedures to process the claims for interior system.
• Involve in scrum calls to discuss the issues and resolve it with team members.
• Work on high-priority cases to deploy into production in timely manner.
• Create database objects such as temp tables, table variables, tables, cursors, indexes and user defined functions.
• Improve the performance of SQL Server, SQL scripts and store-procedures by implementing the User defined function, CTEs, and Indexes.
• Debug and optimize complex queries according to business specification and research to find out problem causing logic in store-procedure and resolved it as per business requirements
• Implement error handling using try and catch method and raise error system function in scripts and store procedures
• Optimizing and Performance Tuning SQL Scripts in order to make reports run smoothly and efficiently
• Verify the results according to requirement for application by performing Unit testing.
• Generate ad-hoc reports, tabular reports using excel power pivot
• Develop and modify the store procedures to generate reports and maintain data according to requirements
• Analyze data according to requirement with complex queries using Joins, Sub-Queries, Functions, Clauses and Generate reports
• Design, Develop, and Test Stored procedures, Views and Complex Queries for the creation of Reports
• Generated tabular reports, parameterized reports and ad-hoc reports using Report builder
• Built and maintained SQL scripts, indexes, and complex queries for data analysis
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
• Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.

Environment: MS SQL Server, SQL Server Data tools (SSIS), SSRS, report builder, Jira, salesforce, SVN, SQL Server Management Studio(SSMS)

Confidential, QUINCY MA

SQL/ BI/ Power BI Developer

Responsibilities:

• Gathered requirements of project from business analyst, Analysis requirements, worked with developers, DBA and testers to execute task.
• Worked in Agile process having expertise in life cycle of a project from start to end
• Created Complex Stored Procedures, Joins and Views using T-SQL to evaluate result for the reports
• Worked with T-SQL Functions, Tables, Indexes and Views and other SQL joins and statements for applications
• Designed, developed, and tested stored procedures, views and complex queries for the creation of Reports
• Designed, developed and implemented Power BI reports
• Strong understanding in creating Dashboards, Scoreboards in Power BI
• Used various sources to pull data into Power BI such as SQL Server, Excel, Web, Text/CSV etc.
• Using a Power Query in Power BI performed certain operations like fetching data from different file and performed ETL to get data into Table form
• Designed Monthly Project KPIs of Usage Statistics, Identity Compliance and Audit Reports in Interactive Dashboards/Storyboards using Tableau and Power BI
• Used various Data Visualizations with Power BI and published reports to Power BI Services
• Created matrix, Chart, Parameterized, Drill-down, Drill-through reports
• Deployed and uploaded the SSRS reports for the end users and involved in enhancements and modifications of Dashboards
• Created SSIS packages using control flow, data flow and error handling tasks and different data sources to the data mart using SQL Server Integration Services
• Worked with various containers in the control flow task such as For Loop, For Each Loop, Sequence
• Developed dynamic packages with variables and expressions. Able to load data from Excel, Flat Files, XML, different databases and SQL database
• Worked in using SQL execution task, and different Data transformations like Conditional split, Derived column, Look up, Union All, Aggregate, etc.
• Experience in Deploying SSIS packages, job scheduling, SQL mail agent using SSIS catalog (SSIS integration service server)

Environment: MS SQL Server, SQL Server Data tools (SSIS), Power BI, SSRS

Confidential, Pittsburgh, PA

SQL/BI developer

Responsibilities:

• Worked with business Analyst, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Designed, developed and implemented Power BI reports
• Using a Power Query in Power BI performed certain operations like fetching data from different file and performed ETL to get data into Table form
• Created measures in Power Pivot and Used various Data Visualizations with Power BI and published reports to Power BI Services
• Maintained Tabular, Linked, Chart, Parameterized, Sub reports, Drill-down, Drill-through reports according to business requirements in time-restricted environment
• Created various SSIS packages by extracting data from various sources according to the requirements
• Worked with various containers in the Control Flow task such as For Loop, For Each Loop, Sequence
• Worked with various sources in the data flow tasks and used various transformations. Some of the transformation are merge, merge join, union, Look up transformation, audit, aggregate
• Worked extensively on bad data with configuring the error output, conditional split, derived column transformation
• Deployed the packages in catalog method and worked on job scheduling and send mail task
• Physical implementation of database into SQL Server using T-SQL
• Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database
• Created stored procedures and functions to support efficient data storage and manipulation
• Created check constraints to maintain data integrity

Environment: SQL Server, Excel, Access and Windows, MS SQL Integration Services (SSIS) and MS SQL Reporting Services (SSRS).

Confidential, Troy, NY

MS SQL Server/ SSRS Developer

Responsibilities:

• Created different Parameterized Reports ((SQL Server Reporting Services)) which consisted of criteria in various reports to minimize the report execution time and to limit the number of records required
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistical information according to business requirements
• Created various types of reports such as sub reports, parameterized and Tablix by using SSRS
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Created reports using stored procedures and was involved in scheduling, creating snapshots and subscriptions for the reports
• Modified Migration of stored procedures and database objects between development and test environments
• Maintained complex Stored Procedures and views to generate various drill-through reports, parameterized reports and Sub reports using SSRS
• Tested reports and performed data validation on dashboards
• Setup SSRS to integrate with Team Foundation Server (TFS) to develop/build/deploy reports using TFS

Environment: MS SQL Server, SSRS, MS SQL Profiler, MS Access, MS Excel, Tableau