PROFESSIONAL SUMMARY:

• Over 7 years of total IT experience; in Analysis, Design, Development, Implementation, Testing & Support of Data Warehousing and Data Integration Solutions using Informatica power center.
• Experience in Database Design, Development and Implementation of SQL SERVER 2017/2015/2014/2012/2008 R2/2005 and ETL/Business Intelligence applications using Microsoft components.
• Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.
• Working experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, and DCL commands for various business applications.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, Cursors and Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Expert in using SQL Server Agent to Schedule and monitor Jobs.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) and Trouble shooting the migration issues from DTS to SSIS conversion
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008/2008 R2) & features.
• Expertise 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.
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms.
• Developed SQL scripts to handle different databases of insurance applications and created front end application in VB.Net 2005 to achieve desired results and data.
• Strong Experience in Unit, Integration and System Testing.
• Expert in Crystal Reports, SQL Reporting Services (SSRS), Crystal Reports.
• Developed reports & Dash board by using excel services and business Intelligence.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 , ORACLE, MS Access.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), SQL* Plus.

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SQL Server Reporting services (SSRS), PowerBI

RDBMS: SQL Server 2012/2014/2016 , Oracle 11g/10/9i.

Programming: T: SQL, PL/SQL, Dynamic SQL, DAX, C# .NET, XML, Java, Hive.

Operating Systems: Windows 7/Vista/XP/2008/2003, Windows 10, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Bluffton, SC

SQL Server BI / ETL Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Created ETL SSIS packages both design and code to process data to target databases.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.
• Documented all the work and all the process of integration and reporting services for further s
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server, SSRS, SSIS, SQL Query Analyzer, SQL profiler, IIS, Enterprise Manager, Windows Server, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio, MS Access, Crystal Reports, MS Excel.

Confidential, Boston, MA

SQL Server BI/ETL Developer

Responsibilities:

• Involved in designing the physical database models on SQL Server RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Using DTSX Change tool converted DTS packages to SQL Server SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Responsible for maintaining cubes using SSAS and populate the cubes with the data
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS
• Created incremental data load task using SQL Server Integration Services
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS, Oracle, Enterprise Manager, ERWIN Data Modeler, Windows Server, HTML, XML, C#.

Confidential, Norwalk, CT

SQL Server BI / ETL Developer

Responsibilities:

• Involved in gathering system specification requirements for the project and ceated new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Utilized Dynamic SQL for user customizable queries by SQL Server and optimized complex queries and stored procedures utilizing SQL Profiler and DTA.
• Created dimension and fact tables for staging database following Kimball Methodologies.
• Performed data extractions from heterogeneous sources such as flat files, Excel files for ETL processes.
• Developed efficient ETL packages utilizing error logging, dynamic variable expressions, sequence containers, conditional precedent constraints, and conditional data flow.
• Identified and effectively handled early arriving facts and late arriving dimensions utilizing inferred members.
• Redirected error outputs to error output tables to identify dimensions and facts that were not properly populated.
• Customized KPI’s, calculations utilizing multi-dimensional expressions (MDX).
• Created dimensional hierarchies to improve cube performance.
• Developed SSRS Reports such as drill through, drill down, linked, sub reports and parameterized reports.
• Identified slowly running reports utilizing Execution Logs in Report server database.
• Scheduled report delivery on daily, weekly and monthly basis utilizing subscriptions.
• Used TFS (Team Foundation Server) for code check-in and check-out and managed different versions of complicated code and distributed them to different teams in the organization.
• Worked on the backend Databases of health Care applications such as QNXT

Environment: SQL Server, SSIS, SSAS, SSRS, BIDS, SQL Server job agent, MDX, MS Visual Studio, MS Excel

Confidential, West Deptford, NJ

SQL Server BI Developer

Responsibilities:

• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Worked on performance tuning of Views, CTE’s, stored procedures.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Used star schema in designing data marts for creating SSIS ETL packages.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2012.
• Involved in part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Designed SSIS packages to transfer the data from, flat files and Excel documents to the Staging area in SQL Server
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used DAX operations that were used to create custom calculations in power Pivot for Microsoft Excel workbooks and Analysis Services Tabular (SSAS) data warehousing.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Responsible for building reports in power BI from the Scratch.
• Responsible for creating and changing the visualizations on the power BI reports and Dashboards on client requests.
• Connecting power BI to different data sources - SQL databases, Cubes, Web services, Web trends, Excel, Azure.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via power BI.
• Responsible for Scheduling jobs for weekly, daily data refresh on different power BI reports.
• Involved in UI Design for power BI Reports and designed effective layouts.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in power BI.
• Created Roles and implemented Row level security for user Authentication in power BI.
• Created effective Dashboards in power BI Service and made the reports user friendly and interactive.
• Worked with power BI mobile app and created mobile layouts to view reports and dashboards effectively. Installed On premise data gateway and scheduled daily data refresh in power BI.
• Developed Complex calculated measures using Data Analysis Expressions (DAX)
• Deployed the generated reports directly on the client’s workstation.
• Used power BI Custom visuals like power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better.
• Embedded power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Responsible for creating and changing the data visualizations in PowerBI reports and Dashboards on client requests.
• Provided Continuous Maintenance and Development of bug fixes on power BI Reports
• Deployed Dashboards, Reports and Data sources in the power BI Service used source control such as TFS and VSTS.

Environment: MS SQL Server, SQL Server Integration Services, MS SQL Server Reporting Services, SQL Server Analysis Services, Power BI, Windows

Confidential, Wilmington, DE

SQL Server Database Developer

Responsibilities:

• Gathered user requirements from users and managers to better understand the business logic of the company and create SQL database that fits their needs
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
• Successfully migrated data to new location using Snapshot Replication and implemented Merge Replication to support up to date record of Inventory Information.
• Created Views to replace old tables and created new tables with triggers to support new business needs.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Migrated Crystal Reports to SSRS reports manually
• Created AD-Hoc Report models and drill down and drill through and complex reports using SSRS
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Alerts and scheduled SQL Agent jobs to generate Reports.

Environment: SQL Server, SSRS, T-SQL, Script, JavaScript, ASP.NET, Microsoft Office