SUMMARY

• Around 8 years of experience in SQL Server database development and administration, extensively worked in OLTP, OLAP, Client - Server & Enterprise Data Warehouse Environments.
• Strong experience in Microsoft Business Intelligence Tools including Integration Services, Reporting Services and Analysis Services.
• Skilled at developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T-SQL.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Extensive knowledge of various data sources like Oracle, Teradata, MS SQL Server, Flat files and HL7 files.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Interactive data visualization products focused on business intelligence such as MICROSOFT POWER BI.
• Expert in Data visualization and Data analyzation using Power BI.
• PublishingPower BI Reports fromPower BI Desktop toPower BI Service.
• Expert in creating multiple kinds ofPower BI Reports, Dashboards and Visualizations.
• Created reports inPower BI preview portal utilizing teh SSAS Tabular via Analysis connector.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BIreports.
• Experience in teh EPIC Medical software application (EMR).
• Experience in SQL Server 2012 Self Service BI tools like Power view, BISM Tabular models and SQL Server Data tools.
• Strong experience in Oracle database, worked with versions Oracle 9i, 10g, 11g.
• Hands-on experience with Tableau reporting tool.
• Solid experience in converting legacy MS Access and Crystal Reports to Reporting Services 2008/2008 R2.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Experience in integrating SSRS reports into external applications using report viewer controls and custom URLs.
• Hands-on experience in using self Service BI tools such as power view, report builder and BIDS
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Involved in developing reports from SSAS cubes using client tools like SSRS 2008, Excel 2007 and Report
• Industrial experience includes healthcare (HIPAA and HL7) and Insurance
• Implemented data migration using Informatica on demand and data loading using Data loader, import wizard.
• Hands-on experience in Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler,
• Database Tuning Advisor and Index Tuning Wizard.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version (SVN).
• Experience in dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Expertise in writing DML and DDL Code, Dynamic SQL as well as Query optimization& performance tuning
• Expert in using Complex Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), SharePoint 2010 development and Performance Point Services (PPS).
• Strong experience in creating script tasks with C# and VB.NET

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2

BI/Data Model Tools: Microsoft SQL Server Reporting Services, Crystal Reports and basic knowledge of Tableau, POWER BI.

ETL Tools: SSIS, Data Stage.

Programming: T-SQL, PL/SQL,C#, C. basic knowledge of Java & .Net.

IT Processes: Software Development Life Cycle (SDLC).

Database Tools: SSMS, Configuration Manager, Query Analyzer Profiler, SSAS, SSRS, Database Tuning Advisor, Export/Import Wizard, ODBC, OLAP, OLTP, DBCC, BCP.

Operating System: Windows 2012/2008/2003, Server Enterprise/Standard/Datacenter.

PROFESSIONAL EXPERIENCE

SQL/BI Developer

Confidential, MA

Responsibilities:

• Documenting teh requirement specification and framing teh business logic for teh ETL process
• Creating database objects such as tables, views, stored procedures, Indexes and CTE etc.
• Involved in entire product lifecycle development from teh requirement gathering through developing and Implementing in teh production.
• Migrating SQL Server 2008 to SQL Server 2016.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, XML task and various transformations.
• Worked on FTP and SFTP tasks in SSIS to transfer teh data to teh providers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Configured SQL mail agent for sending automatic emails when SSIS packages fail or succeed.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secure and extensible.
• Implemented table variables, temp tables, CTE's, and dynamic SQL techniques to improve teh performance of slow running queries.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Create ad-hoc SQL queries for customer reports, executive management reports.
• Developed Batch interfaces (FTP/ SFTP/FTPS) to process batch files.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Introduced Power BI in company by evaluatingPower BIand Tableau as earlier Crystal Reports were used.
• Built Ad-Hoc reports inPower BIdepending on business requirements was one of teh major responsibilities.
• Developed Reports to Visually explore data and create an interactive report Excel and Power BI.
• Using a Query Editor in Power BI performed certain operations like Fetching data from different file.

Environment: SQL Server 2016/2012/2008, T-SQL, SSRS, SSIS, Management Studio 2008 R2/2012/2016 Query Analyzer, Visual Studio 2008/2012/2016, POWER BI.

SQL/BI Developer

Confidential, Glen Burnie, MD

Responsibilities:

• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
• With direction from client, will develop production ready, bug free SSIS jobs to extract data, as assigned, from teh source database (EDW).
• Map SQL statements and Transact-SQL stored procedures from old data sources to new data sources.
• Converted Existing Crystal reports to SSRS 2012.
• Tuning teh Existing Stored Procedures used by teh Crystal reports for increasing performance as per user requests.
• Developed stored procedures to use in SSRS report using dynamic SQL and T-SQL.
• Import Data into Power BIusing different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with inPower BI to generate Marketing Campaigns metrics related to landing pages, Email Analysis and Visitors.
• Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform usingPower Query functions and DAX calculated Measures.
• Design Percentage, Month over Month and Year over Year measures after importing data intoPower BI desktop using DAX andPower Query functions. Slice measure inPower BI tile using calculated Dimension fields inPower BI.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Worked on FTP task in SSIS to transfer teh data to teh providers.
• Worked with SSIS for creating packages to transform data from different OLEDB Provider like DB2, Flat File, Excel, and Oracle and Automate teh ETL.
• Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Created SQL Server Reports and developed query for generating drill down reports using SSRS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Create ad-hoc SQL queries for customer reports, executive management reports.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Deployed teh reports to Sharepoint2010.
• Developed Batch interfaces (FTP/ SFTP/FTPS) to process batch files.
• Tested and validated HIPPA compliance and Hl-7 messages requirements in teh application.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Worked on Daily reports in Power BI to check teh daily status of all teh diagnostic center across teh world in all sites. Provided Auto refresh capability in power BI embedded.
• Analyzed teh forecast Using DAX with Linear regression concepts.
• Integrated reports in Power BI Service using report id tokens.
• Wrote DAX functions to show teh capability Analytics for teh reports.
• Developed Query parameters from outside teh power BI to filter teh data in power BI according to selection made in application.
• Auto Standardized and automated teh HEDIS Supplemental data process. Needed to get all filenames and types from folder path, then load all log files and member files, match members to gather more data elements needed for teh surveys and export member data to Excel file. This process loaded 100+ files and replaced a manual process dat took multiple analysts weeks to complete.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETL load

Environment: SQL Server 2014/2012, T-SQL, SSRS, SSIS, Management Studio 2008 R2/2012, Query Analyzer, Team Foundation Server, Power BI, Visual Studio 2008/2012, Power BI.

Sr. ETL/BI Developer

Confidential, Minneapolis MN

Responsibilities:

• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in teh Data Warehouse.
• Participated in teh design and development of teh Data Warehouse using Star Schema and Snowflake Schema.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Used knowledge of Health Care Information Systems EMR model to develop proposed workflow
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup, Filter, Update Strategy, Stored Procedure, Router, Expression, SQL and Sorter.
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2008R2.
• Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• Deployed SSRS reports in native and SharePoint mode.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Developed power view reports using Tabular Models in SQL Server Data Tools.
• Has Knowledge in Conversion Agent and converted word document, PDF, HL7and text into XML format.
• Developed various dashboards utilizingPower BI with multiple scorecards such as average claims processing times, sales trends, claim processing costs.
• Created analytical reports and dashboards withPower View to identify critical KPIs.
• Wrote DAX expressions to create calculated measures and columns inPower BI.
• Created dashboards with multiple graphs, pie charts, slicers, maps, heat maps utilizingPower BI.
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Published excel data toPower BI services usingPower BI publisher.
• ConfiguredPower BI On-premises gateway to set-up scheduled data refresh of datasets.
• Extensive used Team Foundation Server to implement version control for MSBI (SSIS/SSRS/SSAS) projects.
• Involved in HIPPA transactions and Validated HL-7 messages.
• Extracted data from excel files, high volume of data sets from data files, Oracle, DB2, SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area

Environment: MS SQL Server 2012/2008 R2/2008, Oracle 11g, SharePoint 2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel 2013, Tableau, Power BI, Power view, Powerpivot, Performance Point, MDX, Report Builder 3.0, DTS, C#, VB.NET, Erwin 4.0, XML, Informatica, SVN, Windows Server 2008, .NET 3.5, DTS.

Confidential

SSIS-SSRS-SSAS Developer

Responsibilities:

• Design, create and regular tuning of physical database objects (tables, views, indexes) to support normalized and dimensional models.
• Requirements analysis, data assessment, business process reengineering.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute teh SQLs on UNIX environment.
• Index maintenance & analysis.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Worked on loading various tables using Teradata Parallel Transporter.
• Worked on OLELOAD to load tables and to export tables into spreadsheets.
• Participate in Data Modeling sessions to identify data warehouse requirements.
• Involved in design, data modeling.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Create and Maintain Teradata Databases, Users, Tables, Views, Macros, Triggers and Stored Procedures.
• Create and Maintain Users Profile Definition to determine teh Performance.
• Performed felid-by-field mapping of interface between parent EMR system and downstream system
• Created and configured Workflows, Work lets, and Sessions to transport teh data to target using Informatica Workflow Manager.
• Worked on complex queries to map teh data as per teh requirements.
• Developed MicroStrategy Dynamic Dashboards in various modes and also worked extensively on widgets.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Tuned Tableau Dashboard Performance-Reduced Tableau Views load times to 5 seconds, Used Incremental Extracts to reduce extract refresh times.
• Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user acceptance testing and loading history data into Teradata.
• Designed delta load on all fact tables.
• Worked on Fast load, Multi load for loading teh data into teh Teradata database.
• Involved in working with PMON, monitoring teh usage of teh users.
• Involved in performance tuning of Informatica code using standard informatica tuning steps
• Involved in Performance tuning for teh long running queries.
• Explored ways to optimize existing ETL processes and enhance their performance.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Installed and configured SQL Server 2008.
• Installed & configured SQL Reporting services Add-in for SharePoint 2010.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server 2010.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, and Multi Valued Parameters and deployed on SharePoint 2010.
• Created variety of reports from SSAS cubes and deployed on to SharePoint 2010.
• Created reports using stored procedure and also involved in scheduling, creating snapshots and subscriptions for teh reports SSRS.
• Generated Tabular, Sub reports, Parameterized reports, pie charts and bar charts for teh Business users and created report models to support AD HOC REPORTING.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built teh SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Tuning of Informatica jobs with oracle as backend database
• Experience in Programming AMO OLAP advanced objects like KPI’s and Perspectives.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Regular responsibilities for updating and staging teh dimensional databases as well as rebuild teh Dimensions and cubes in Analysis Services.
• Installed and configured sharepoint 2010.
• Activated performance point services in sharePoint 2010.
• Experience in Planning and Monitoring reports in PerformancePoint Server.
• Expertise in creating logical data models by recognizing teh source tables and columns, to build Attributes Facts, Hierarchies and Relationships dat are necessary to create a MicroStrategy project.
• Used PerformancePoint Server to create interactive reports with an ability to drill down into details.
• Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Migrated database and performance point reports from one server to another.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors.
• Created Views and Index Views to reduce database complexities for teh end users.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Migrated from SQL Server 2005 to SQL Server 2008 and worked on teh transition.
• Using SQL server reporting services (SSRS) and crystal Reports delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.
• Worked on teh Reports module of teh project as a developer on MS SQL Server 2005 and 2008(using SSRS, T-SQL, scripts, stored procedures and views).
• Created different types of reports such as Cross-Tab, Drill-down, Top N, Summary, Ad-Hoc, Tablix Reports, Matrix Reports, Parameterized Reports, Cascaded Parameters, Gauges, Interactive Charts OLAP and Sub reports, and formatting them using both SSRS 2008/2005.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in teh cube.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, XML files etc.) and loaded teh data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and responsible for Deploying and also Scheduling teh SSIS packages and Jobs.
• Performed database transfers and queries tune-up, integrity verification, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild teh Dimensions and Cubes in Analysis Services (SSAS) and performed partitions, and Aggregations, calculation of queries with MDX.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Involved in project planning, scheduling for database module with project managers.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning teh database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize teh procedures and triggers to be used in production.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.