SUMMARY:

• SQL Server/ BI Developer with 7.5 years of rich professional experience in Healthcare and Banking domain.
• Extensive experience with MS BI stack: Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and Power BI SDLC from prototyping to deployment.
• Good experience as a SQL Developer in MS SQL Server 2008/2 in Production, Quality & Development environments.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2008/2 with expertise on data normalization.
• Experienced in designing and developing large number of reports in Power BI, SSR using the data from ETL Loads and various heterogeneous data sources.
• Strong experience in developing optimized and complex T - SQL queries.
• Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• 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 .
• Created complex expressions using the MDX scripting to solve complex designs.
• Experience in creating and deploying SSIS ( ETL process) packages using various Transformations such as Slowly Changing Dimension , Multicast , Merge Join , Lookup , Fuzzy Lookup , Conditional Split , Aggregate , Derived Column and Data Conversion Transformations .
• Strong technical knowledge in MS SQL Server development including DTS , Microsoft Analysis Services, Reporting, Designing logical/physical databases and Troubleshooting.
• Good knowledge in deploying applications on Windows Azure.
• Developed Ad hoc reports using SQL, PL/SQL, and UNIX to fulfill business analysts, Operations Analysts, and Financial analyst’s data requests.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star , Snowflake , Normalized and De-Normalized Schemas with respect to query and analysis requirements.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Experience with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Involved in Database Design , Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models. Used tools like MS SQL Profiler, Index Tuning Wizard , and Windows performance for monitoring and tuning SQL Server performance.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Expertise in Data Transformation and Data Migration.
• Strong experience in Data warehouse concepts, ETL.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Working knowledge in Agile/Scrum Environment and used TFS (Team Foundation Server).
• Ability to handle Multiple Tasks, Self-Motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

TECHNICAL SKILLS:

T: SQL, C, HTML, CSS, ASP.NET, VB, C#

RDBMS: MS SQL Server 2016/2014/2012/2008/2005/2000 , MS Access, Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables. SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013 Crystal Reports, DAX

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

Systems familiarity: OLTP,DSS,OLAP,MDX

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

WORK EXPERIENCE:

Confidential, PA

Sr. MSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed various Triggers, Stored Procedure . Migrated tables from old data warehouse to new database for transaction history of the application.
• Developed and maintained a combined data store for reporting purposes.
• Successfully completed Support testing and defect resolution for the database changes.
• Responsible for performance tuning and optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Created effective reports using visualizations such as Bar chart , Clustered Column Chart , Waterfall Chart , Gauge, Pie Chart and Tree map in Power BI.
• Created reports to retrieve data using function, views, stored procedures and T-SQL code using parameters.
• Part of Code review during QA , UAT and Production deployment.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Design and Developed complex canned reports using SSRS from multiple data providers in Underwriting and Claims systems, user defined objects , Aggregate Aware Objects, Charts and synchronized queries.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX , Data Mining Models , developing reports using MDX and SQL.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Used the Business Process Modeling (BPM) to GAP Analysis to bridge the gap between business processes
• Developed use cases, workflow, screen mock-ups, and conversion requirements
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Formatted dashboards, multiple chart types, trends , and KPIs with Power View to support analyses.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Created Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
• Migrate existing data into the Power BI .
• Used DAX for creating calculated columns and calculated measures.
• Created many dashboards in Power BI using DAX expressions and deployed them using content pack.
• Implementing and managing Event Handlers , Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Involved in Creating Parameterized , Cascaded , Drill-down, Cross-tab and Drill-through Reports using SSRS .
• Developed Report Models for building customized Ad hoc reports. Played a Content Manager role on report server.
• Worked in Agile Methodology and used Phabricator when deploying scripts to production.
• Used JIRA to managing tasks.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Monitoring SQL Error Logs , Scheduling Tasks , Database Activity , Eliminating Blocking and Deadlocks .

Environment : SQL Server 2008/2, SSIS, T-SQL, Excel, Microsoft SQL Reporting Services (SSRS), SSAS, Power BI, SQL Server Analysis Services (SSAS), T-SQL, Windows 8, XML, MS Excel.

Confidential, Port Washington, NY

Sr. MSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.
• Developed packages in SSIS with error handling.
• Created DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.
• Implemented Performance Tuning and Query Optimization .
• Created Package Configurations to deploy packages from development to production server .
• Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS)
• Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data.
• Developing SSIS packages that upload multiple flat files using For each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Improving the database performance by creating and using both Clustered and non- Clustered Indexes and by optimizing T-SQL statements. Using Azure portal to audit and analyze the events during a particular time horizon and stored in the script.
• Created ETL process using SSIS to transfer data from heterogeneous data sources by extensively using PIVOT to Normalize the data also combining data from different sources using UNION ALL .
• Worked with Marketing department to improve the external and internal website and posting latest updates.
• Actively involved in developing Complex SSRS Reports involving Sub Reports , Matrix / Tabular Reports , Charts , and Graphs .
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries with JOINS to enhance the performance of Databases.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment : SQL Server 2008/2012/2014 , Visual Studio2017, 2015,2013, Framework 4.5, C#.Net, XML, Entity Framework, Microsoft Office, Excel, Word, Windows server 2010,Business intelligence development studio, Tableau 10.4,SQL profiler, MS Visio, T-SQL, DTS, Data Analyzer.

Confidential, Santa Clara, CA

MSBI/SSIS/SSRS Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Taking Database Full Backup, Transaction log backup & differential backup in daily routine.
• Traced long running queries and deadlocks using SQL Profiler.
• Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Worked on Power BI and prepared dashboards to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI .
• Involved in Installation, Configuration, and Deployment of Reports using SSRS .
• Scheduled the reports to run on daily, weekly basis in the report manager.
• Created SQL server jobs to execute SSIS packages according to the load type of the data.
• Involved in writing stored procedures to create table structures in stage and pulling data from metadata.
• Involved in creating marts and developing mart views used for the report building.
• Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.
• Designed and deployed reports with Drill Down, Drill Through , Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS .
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Created multiple Data Driven Subscriptions that delivers Power BI reports as excel and PDF output on network file system
• Created multiple Email Data Driven Subscriptions that sends email to top-level executives consisting of different reports that helped in taking financial decision and future business strategies
• Discovered and corrected critical bugs in the data migration process that led to in-correct data being reported to clients and government reporting
• Generated daily, weekly and monthly reports for the managers
• Developed Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse
• Used ETL to implement the Slowly Changing Transformation , to maintain Historical Data in Data warehouse

Environment : MS SQL Server 2005/2008/2008 R2/2012, Business Intelligence Development studio (SSRS/ SSAS/SSIS), Oracle 11g/10g/9i, MS Office Access 2003 and Visual Studio 2008, .Net 3.5, Team Foundation Server 2010, Agile Methodology (Spring, SCRUM), T-SQL

Confidential, Bedford, NH

MSBI Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.
• Tested the applications along with the Quality Assurance testing teams.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Used Microsoft Visio to draw business process swim lane diagrams.
• Created report snapshots and cache for better performance.
• Created Dimensions with the cube wizard and also individually.
• Identify and raise system capacity related issues (storage, licenses, performance threshold)
• Performance, capacity & utilization monitoring
• Optimization and Performance tuning
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Used SQL Server 2008 Enterprise Edition to extract raw data from data warehouse
• Prepared authorization groups and user groups based on the cross functional responsibilities of the different users of different systems
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Assisted in building a business analysis process model using Visio.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Developed complex stored procedures using T-SQL statements for query optimization

Environment : SQL Server 2008, SSAS, MDX, OLAP, SSIS, T-SQL, SSRS, Windows Server 2003, Performance Point Server 2007, MS Access, Visual Studio 2005.

Confidential

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2008 , MS Access.
• Installed and maintained MS SQL Server 2008 .
• Created Database Objects - Tables, Indexes, Views, User-defined functions, Cursors, Triggers, Stored Procedure, Constraints, and Roles.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Extensively developed SQL Procedures, Functions, Triggers and Packages.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Rebuilding the indexes at regular intervals better performance
• Written various stored procedures for the purpose of application development
• Design and implemented data access stored procedures and triggers for automating tasks
• Used joins and sub-queries to simplify complex queries involving multiple tables
• Worked on crystal reports with many complex stored procedures
• Created multi-format reports using Crystal report
• Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Develop SQL Server Agent jobs and packages to populate data.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions , Look up , Aggregate, Derived Column , Conditional Split , Fuzzy Lookup , Multicast and Data Conversion .
• Involved in performing database Backup and Recovery.
• Created and manipulated many small and Complex packages to perform ETL operations.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Environment : SQL Server 2008/2008R2, T-SQL, DTS, MS-Excel, Windows 2000/2003, Visual Studio 2008/2010, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, MS Visio, Data Analyzer, MS Excel, Word