PROFESSIONAL SUMMARY:

• 7+ years of IT experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2012/2014/2016/2017/2019, SSIS/SSRS/ETL and OLAP development knowledge and data warehouse application in various domains like Financial, Retail and insurance.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Expert in Design, developing and maintaining SSRS reports.
• Expertise in creating Cascading Parameterized and Parameterized reports involving Drill down, Drill through features with Matrix, Chart and Sub reports using SSRS.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML, Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in the designing, developing, and deploying SSIS packages using various control flow tasks and data flow transformations like conditional split, derived column, look up, merge, sort etc.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2019.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts, and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.

TECHNICAL SKILLS:

Databases: MS SQL Server 2019/2017/2016/2014/2012/2008 R 2/2008/2005/2000, Oracle 8i/9i/10g and MS-Access 97- 2007.

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x and Windows 95/98/XP.

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS), Talend Big Data Fabric and QlikView.

Web Technologies: HTML, DHTML, XML, Visual Studio and MS Front.

Programming languages: C, c#, VB.NET, Python, Visual Code, JavaScript, Visual Basic for Applications (VBA) and ASP.NET, SQL and PL/SQL.

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Erwin and Microsoft Visio 2000/2003.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL Developer

Environment: MS SQL Server 2016/2017/2018/2019, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Migration Assistant, Windows XP, SQL Server Profiler, SQL Server Management Studio and TFS.

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Data Analysis and Designed the logical and physical model architecture for database.
• Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.
• Convert data from Legacy system to SQL Database.
• Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
• Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, and calculated members using SSAS 2019 and wrote many MDX scripts while developing the reports from the cubes using SSRS 2019.
• Implemented Auditing using triggers.
• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Created schema objects, rules and granted roles to the users.
• Involved in Query optimization, Performance Tuning, and Index Creation.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports.
• Database Backup and restoring the database.
• Worked in Database Security, Replication, and Log shipping activities.
• Validating and Testing of the Database data, SQL codes and application (White box and Black box).
• Created different power BI reports utilizing the desktop and online services and schedule refresh.
• Assist end users with problems installing the power BI desktop, installing and configuring the personal and on-premises gateway, connecting to data sources and adding the different users.
• Created different visualization in the reports using custom visual like Bar Charts, pie Charts, Line Charts, Cards, Slicers.
• Experienced in developing power BI reports and dashboards from multiple data sources using data blending.

Confidential

SQL/SSIS/SSRS Developer

Environment: SQL Server 2005/2008/2012/2014 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), MS SQL Profiler and SQL Query Analyzer.

Responsibilities:

• Configured and installed SQL Server 2016, on Windows Server and migrated databases from different databases like Cache, Chronicles of EPIC to MS SQL Server 2016.
• Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team of EPIC for the development of the system.
• Created various Stored Procedures, User defined functions, Views for the complex business logics and implemented triggers.
• Designed and created different ETL packages using SSIS from Oracle source, Excel, CSV Files, Text files, MS Access to SQL server as destination.
• Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation.
• Created Subscriptions for the users to deliver the reports in a timely manner.
• Implemented Power view for the visualization of reports.
• Designed and maintained a web reporting environment including portal, dashboards and scorecards for the Insurance Claims using Share Point.
• Created Pivot tables in excel using data from various sources like SSRS and MS Access.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Scheduled the monthly, weekly, and daily reports to run automatically onto the dashboard and configured the report viewing security for various users at various levels using report manager.
• Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.

Confidential, Arlington, MD

SQL/BI Developer

Environment: MS SQL Server 2012/2008/2005, SSRS 2008, SSAS 2008, T-SQL, MS-Excel, XML and Windows 2003/NT/XP.7.

Responsibilities:

• Gathered requirements through meetings with the Users, business analysts and team members.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Created indexes, Constraints, and rules on database objects.
• Created views and stored procedures and optimizing them.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL SSIS.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Created and maintained security profiles for MS BI reporting needs.
• Involved in developing Complex SSRS Reports (2008/2005) involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Creating some Score cards and Dashboard Reports Using SSRS 2008.