SUMMARY:

• Over 8+ years of IT experience in Database/Data Warehouse design, development & administration using Microsoft SQL Server 2016/2012/2008 R2/2008/2005, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS) in DEV, and TEST and PRODUCTION environments with various domains.
• Expertise in generating Ad hoc reports, tabular reports, Matrix reports, Drill-down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers using SSRS.
• Experience in Developing and Tuning T-SQL, PL/SQL Complex Queries, Stored Procedures, UDF'S, triggers, views, Indexed views and error handling using Try-Catch blocks.
• Experience in supporting Very Large databases (VLDB) and Very large tables with millions of rows and troubleshooting the problems.
• Implemented Normalization, Transactional, Snapshot replication and Performed log shipping as Disaster recovery solutions.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP).
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012/2014/2016.
• Proficient with extraction and migration of data from various data sources like MS Access, Oracle, Excel, flat files and XML to the SQL Server using import/export wizard, DTS/SSIS, bulk insert and BCP utilities.
• Highly experienced in providing Logging, Package Configurations, Error Handling using Event Handlers and custom logging for SSIS packages.
• Worked on power pivot models, power maps and Power view.
• Experience in testing reconciles (initial) and delta (daily) ETL loads.
• Extensively worked with batch scheduling tool Autosys to run and monitor the ETL workflow jobs.
• Experience creating Cubes with Dimensions and Fact tables in OLAP using SSAS and creating calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Proficient in creating Drill Down Reports, Ad-Hoc, data driven subscription, Parameterized reports, Charts using SSRS and MS Excel for data analysis.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. Good understanding of Darwin LIMS architecture.
• Strong understanding of the principles of data warehousing using Fact Tables, Dimension Tables, star and snowflake schema and Slowly Changing Dimensions Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in Using DMVs/DMFs/DTA/ITW/ Performance dash board and database snapshot.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Created Rich dashboards using Tableau/Power-BI Dashboards and prepared user stories to create compelling dashboards to deliver actionable insights.

TECHNICAL SKILLS:

TSQL:, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2016,2014,2012,2008R2,2008,2005

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Power BI, Visual Studio, Cognos, OBIEE, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Boston,MA

MSBI / Power-BI/SQL Developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Created Power-BI driven dashboards and reports.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• 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.
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Webservices and API's in Azure SQL.
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
• Use login feature for analysis purpose.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Added intelligent system in SSIS to identify actual change and new change in dimension.
• Design SSRS and excel reports, expense analysis, and balance sheet analysis.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Prepared complex reports using SSRS and deployed into MS CRM.
• Processed the data mapping for all the migrated jobs using SSIS and Power-BI.
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance to tune them.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power-BI Service Desktop tool.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power-BI and SSRS reports.
• Created script to migrate SQL server object from one environment to another environment.
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes.
• Designed and Implemented an Application using C#, ASP.NET and implemented client side and server-side validations using JavaScript and Validation Controls.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2016/2012 and 2008 OLAP databases.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required.
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.

Environment: MS SQL 2008 R2/2012/2016, SSIS, SSRS XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server, Power-BI Tool.

Confidential, Brentwood, TN

BI Developer

Responsibilities:

• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Created new ETL packages to validate, extract, transform and load data into data warehoused databases using SSIS packages.
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server and Flat files.
• Developed packages in SSIS with error handling.
• Involved in data cleaning to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformation.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgradation of System Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster with Mulch-instances.
• Configured and Monitored Database Mirroring for Application Development environment.
• Designed Cubes with Star Schema using SQL Server Analysis Services (SSAS).
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Actively involved in developing complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector and also created roles using SSAS to restrict cube properties.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.

Environment: SQL Server 2014/2012/2008, Query Analyzer, SSIS 2014, T-SQL, Excel, Microsoft SQL Reporting Services 2014 (SSRS), SQL server 2014/2012/2008 . Analysis Services (SSAS), DTS, T-SQL, Windows Server 2012 R2, XML, MS Excel, MS Access.

Confidential, Minneapolis, MN

MS SQL Server /SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Project-manage Oracle MDM implementations for Oracle customers.
• Developed Custom Logging so the user can know when a row is inserted in custom logging table by every SSIS package that executes if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using DB Amp pro tool.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Used "SQL Profiler T-SQL Duration" template for tracking execution time of T-SQL Statements.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meets business and system requirements.
• Documented the project work and process.

Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Visual Source Safe 2005, C#, SQL Profiler.

Confidential, Linthicum, MD

SQL (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data, Normalized tables.
• Created Tables, Views, and Triggers, Stored Procedures, Functions and other T-SQL scripts.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Worked on Filtered Views, views and Base table integration between different source systems.
• Worked with different methods of logging in SSIS and created packages in SSIS with error handling.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for on-going ETL Processes.
• Modified existing ETL packages to support additional/new features based on the customer requirements.
• Provide technical support, troubleshoot and monitor packages released for staging.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed and maintained daily\weekly status report and same to Higher Management.
• Working with QA team on the Defects assigned and Test Case review.
• Repaired/recreated PPS reports damaged in the conversion process.
• Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to understand business requirements.
• Responsibilities involve Requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.
• Responsible for adhering to our Programming, documentation and process standards • Created and Managed OLAP Cubes using SSAS.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Implemented Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
• Worked on the enhancement of SSAS, Processing multi-dimensional cube (In MOLAP storage mode), querying multi-dimensional cube using knowledge of MDX.
• Implemented the calculations to aggregate physical measures.
• Defined relationships between Measure groups and Dimensions.
• Good experience in On-site/Offshore development model.

Environment: MS SQL Server 2008R2/2012, SQL Server Reporting Services 2008R2, SSIS, SSAS, Unix, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.

Confidential, Linthicum, MD

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP.
• Production support, ad hoc queries meeting requirements from other development teams in a test driven agile development environment. Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Design and implementation of SSIS/ETL process for the system.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Design, develop, implement, and assist in validating ETL processes - full ETL development lifecycle.
• Data conversion from mainframe system and Oracle databases to SQL server.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles .Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
• Modified stored procedures to meet current design and used them in SQL Server.
• Moving data from SQL server to Dynamics CRM and initial entity creation.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Server Management Studio, MS Excel, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• 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.
• Involved in ETL architecture enhancements to increase the performance using query optimizer • Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High-level dashboard using SSRS 2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.