SUMMARY

• Around 8 years of experience in the SQL Server/MSBI Developing and Administrating for very large and complex databases in SQL Server on 32 bit and 64 - bit environments.
• Experience in the Database Analysis, Design, and Development, Implementation and Testing using Microsoft SQL Server 2018/2017/2016/2014/2012/2008 R2 and MSBI
• Strong experience using T-SQL statements, SSIS, SSRS, Power BI, Tableau and SSAS for various applications.
• Experience in Data Migrating /data integration, data validation and cleaning, data mapping using SSIS.
• Experience working with performing various SSIS data transformations & data flow tasks.
• Created SSIS packages to perform Extract, Transform and Load data from various sources and destinations
• Extensive experience in designing and developing rich user experience reports using SSRS, Power BI and tableau for building different kinds of reports required by the business users
• Experience working with Microsoft Power BI reports and migrating reports from other sources
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using Multidimensional Expression (MDX).
• Experience in creating SQL Jobs and backup scripts, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages based on Business or application needs
• Maintained security, assigned logins, permissions and desk support for problems related to Active Directory.
• Active involvement in all the phases of the Software Development Life Cycle (SDLC) like Requirement Analysis, Design, Development, Unit Testing and Maintenance using RDBMS, with waterfall and agile scrum methodologies.
• Experience working with TFS and performing code review of code written by peer developers
• Experience in supporting 24/7 on call in production and development environment.
• Experienced in using Data Analysis Expressions (DAX) to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Analyze past trends and make suggestions to meet future requirements with respect to capacity and performance.
• Experience working on Banking, Financial, Utility, Pharmaceutical, Health care , and Internet, oil and Energy environments .
• Strong interpersonal, written and verbal communicator and can deliver effective presentations, and maintains collaborative relationships. (Managerial, functional, technical users) Positive attitude and willing to take new responsibilities.
• Experienced in interacting with business users to analyze the business process/ requirements, transforming requirements into specifications, documenting, and rolling out the deliverables

TECHNICAL SKILLS

Languages: MS SQL, T-SQL, C# .Net, PL/SQL

Databases: MS SQL Server, Oracle, MS Access, SQL Query Analyzer, Red gate tools, Database Tuning, SQL Server profiler

SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Report Builder

Business Intelligence Tools: SQL Server Integration Services (SSIS), Export & Import (DTS), SQL Server Reporting Services (SSRS), Power BI, Tableau, SQL Server Analysis Services (SSAS), Data Analysis Expressions (DAX), Multi-Dimensional Expressions (MDX), Teradata, Erwin

Applications: MS Word, Excel, Power Point, Outlook

Web: HTML, XML, ASP.NET, VBScript

IDE’S: SQL Server Management Studio - 2018, 2017, 2016,2012,2008, Visual Studio 2017,2015,2013,2012,2010, Oracle SQL Developer

Methodology: Agile, Waterfall Object-Oriented Analysis/Design, UML

Data warehouse: Inform ENT, Knowledge Share, Power Share, Toad

Operating Systems: Windows O.S, Linux

Version Control: Team Foundation Server, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Hammonton, NJ

MSBI/Power BI Developer

Responsibilities:

• Involved in Extraction, Transforming and Loading (ETL) data from different sources into various Business Entities using SSIS.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Designed and developed Power BI reports using data visualizations using Power BI desktop.
• Extensively worked on various SSIS Tasks like Execute SQL Task, data flow task, file system tasks and Transformations like Derived Columns, Condition Split, Lookup, Merge Join etc. to generate underlying data for the reports and developed processes to identify the data errors and provided suggestions to resolve the data issues.
• Actively participated in interacting with users, team lead, DBA’s and technical manager to fully understand the Application/System and Business requirements.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.
• Developer Power BI for creating reports according to business requirements and Power Pivot to develop data analysis prototype, for advanced visualize reports.
• Implemented DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
• Scheduled and maintained nightly and Monthly loads of data by creating the corresponding job task by using Scheduled Jobs to automate various processes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Involved in creating and designing Tables, Views, and Stored procedures in supporting the business requirements.
• Extensively used Joins, Sub-queries and temporary tables for complex queries involving multiple tables from different databases.
• Created Indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Robust MS Access and Excel skills with Power Pivot, PivotTable, Pivot Chart, Power View, Lookup functions and formulas.
• Optimized the SQL Queries using tools such as Profiler Trace, Execution Plan, SQL Trace, Database Engine Tuning Wizards etc. for efficiency and better performance.
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Experience working with EDW team with SSRS deployments and related cosmetic changes, at very short periods of notice.
• Generating formatted SQL Server Reports by creating different kinds of reports like Parameterized, Tabular, Matrix, Drill down and Drill through reports using SSRS and Report Builder.
• Working with production support team to provide quick fixes and converting frequently used production support scripts into stored procedures.
• Used Agile Software Development methodology and integrated with various cross functional Teams, like Report Development Team, Operations Team and Marketing Team etc. to take their inputs and evolve and continuously improve the Reporting DataMart to meet the business needs.
• Developed error checking and resolution routines. Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT Process.
• Worked with business users to refine the business requirements for designing and developing the solutions required

Environment: MS SQL Server 2016/2017/2018 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), Tableau, SQL Server Management Studio (SSMS), Visual Studio 2016/2015, Windows Server 2012, Microsoft Office Suite, T-SQL, JIRA, SolveItNow

Confidential, East Petersburg, PA

MSBI Developer/Database Administrator and Developer

Responsibilities:

• Design, develop, test and implement SSIS packages related to the extraction, transformation and loading ETL process for database applications, in accordance with established standards .
• Experience with SSIS Integration and in Analyzing data, find problem areas, and providing solutions
• Configure and deploy SSIS packages and SSRS reports.
• Responsible for gathering and assessing business information needs and preparing system requirements
• Create User Logins for various business departments, applications and granted controlled rights to them to access various database objects like tables, views and stored procedures.
• Experience in Installing, maintaining and upgrading SQL Server and Visual Studio on Test, Development and Production Environments.
• Experience in Performance Tuning and Monitoring Resource Usage with Performance Mon itor
• Experience extracting data from a large variety of sources, transforming and loading to a SQL Data warehouse.
• Provide production support for ETL processes . Responding to bug fixes and enhancement requests and Supported maintenance of local databases
• Expert in configuring and managing Linked Server, Data transfer between SQL Server.
• Validated change requests and made appropriate recommendations, standardized data implementation
• Documented steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
• Created detailed source to destination (target) mapping documents explaining things like business rules, error handling strategy, restart/reload strategy etc.
• Used customer requirements to improve functionality (speed, performance / usability).
• Participate in special projects as needed and performs other duties as assigned.
• Worked in a team environment and Worked on multiple assignments concurrently under aggressive deadlines
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs for customized and ad-hoc Queries .
• Create SharePoint Document Library and Publish SSRS reports and Power Pivot Workbooks
• Developed scripts to automate the daily and routine tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS and Created Summary Reports, Sub Reports for data visualization.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representative for various categories and regions based on business needs using SQL Server Reporting services (SSRS), Power BI and Tableau
• Used ETL tools to populate data from various data sources, created packages for different data loading operations for application. Consult with the business to determine logical design for new business solutions
• Performing code reviews, analyze execution plans, and re-factor inefficient code
• Following Data standards, resolve data issues, complete unit testing and system documentation for ETL processes
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements

Environment: MS SQL Server, T-SQL, SQL Server Management Studio 2017(v17.3),2016,2012, Visual Studio 2015,2013,2012,2010 MS SQL Reporting Service (SSRS), MS SQL Integration Service (SSIS), Erwin, Team Foundation Server, MS Excel, MS Word, MS Access Visual Basic, Toad, Teradata, Knowledge Share, Inform Ent, Power share

Confidential, Waltham, MA

MSBI Developer

Responsibilities:

• Experience with SSIS Integration and in Analyzing data , find problem areas, and providing solutions
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and data visualization to enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Created linked servers between SQL server and oracle.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database, which provides efficient and granular level of control.
• Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Configured and deployed SSRS reports onto Microsoft Office SharePoint Server
• Deployed reports in to Report Manager, created Ad-Hoc reports using Report Builder.
• Created report in SQL Server 2008 and deployed them on local host for remote access.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Performed code reviews, analyze execution plans, and re-factor inefficient code
• Adhered to data standards, resolve data issues, complete unit testing and system documentation for ETL processes
• Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable

Environment: MS SQL Server, T-SQL, SQL Server Management Studio, Visual Studio, Crystal Reports, MS SQL Reporting Service (SSRS), MS SQL Integration Service (SSIS), Erwin, MS Excel, T-SQL, MS Access.

Confidential - Reston, VA

SSRS Developer

Responsibilities:

• Imported and Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Developed Complex Queries using different SQL joins and T-SQL Queries.
• Installed and configured SQL Server Reporting Services (SSRS) and provided administration, maintenance of the Reporting Server and deployed Reports using Business Intelligence Development Studio (BIDS).
• Wrote Parameterized Queries for generating tabular reports, formatting report layout, sub reports, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS.
• Worked extensively on creating SSRS canned and ad-hoc reports (Model based) using Business Intelligence Development Tools, Report Builder 2.0.
• Generated Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS.
• Degenerated Dimensions and Tabular Data Modeling for Moderate to Large Data Systems.
• Work on generating various dashboards in Power BI using various data source.
• Published reports for various clients using SharePoint
• Administered the reports and assigned permissions to the valid users for executing the reports.
• Regularly monitored Time/Data driven Subscription based SSRS reports (Daily, Monthly and Weekly).
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as created stored procedures used in SSIS to load/transform data to the database.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked as a developer in creating complex T-SQL, stored procedures, cursors, tables, and views and other SQL joins and statements for applications.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Used indexes to enhance the performance of individual queries and enhance the stored procedures reading the Execution Plan.
• Working experience on Medicare/Medicaid/QNXT. Supported Production and Development databases
• Documented all processes and dataflow involved in the database using Microsoft Visual studio.
• Involved in discussions with the clients to understand the project requirements.
• Involved in complete Software development life cycle (SDLC) of the project including Analysis, design, develop, deployment, test, implement and production.

Environment: MS SQL Server, SQL Server Management Studio, Visual Studio, Business Objects, Entity Spaces, SSRS, SSIS, Erwin, SQL Server Data Tools