SUMMARY

• Detail - oriented and result-driven professional with excellent technical, analytical and communication skills demonstrated by6+yearsof experience inDatabase Design, Programming, Development and Implementationof Client-Server Applications & Database systems usingMicrosoft SQL Server, Teradata, Oracle databases andSQL ServerBISuite of ProductsSSIS,SSRS,andSSASin various domains likeFinance, Retail, Health Care and Insurance as SQL/MSBIDeveloperand Data Analyst.
• Good knowledge ofRelational Database Management System (RDBMS)andData Warehouse Concepts (OLTP & OLAP).
• Good Understanding ofSoftware Development Life Cycle(SDLC)and Relation Database Architectures.
• Proficient in MS SQL Server suite of products likeSSRS,SSISandSSASof MS SQL Server 2005/2008/2012/2014 .
• Understand rules and regulations ofHIPAA as imposed during Electronic Data Interchange (EDI).
• Extensively worked onSystem analysis, Design, Development, Testing and Implementation of projects (SDLC).
• Experience in creating and maintaining database and its objects.
• Experienced in creating complexStored Procedures, DTS packages, Triggers, Cursors, tables, Views, Table Partitioning and other SQL Joins and Statements.
• StrongSQL Server 2005/2008/2012/2014 DeveloperSkillsincludingwriting User defined functions, Views, Query writing.
• Have experience in developingStoredProcedures for.Net applications and SQL Server Data Tools.
• Extensive knowledge onCDW,Oracle Forms and Reports.
• Built, published and customized interactive reports and dashboards, report scheduling usingTableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Extensive proficiency inExcel - Pivot table,PowerQuery,PowerView Dashboardsgeneration and maintenance.
• DevelopedETL packages to Load datafrom various sources toSQL server and SQL Azure.
• Good knowledge in deploying applications onWindows Azure.
• Developed Ad hoc reports usingSQL, PL/SQL, and UNIXto fulfill business analysts, Operations Analysts, and Financial analyst’s data requests
• Involved inQuery Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Good interaction with Business Analysts, Project managers, Operations/ process, Financial analyst and team members to coordinate job tasks.
• Flexible, enthusiastic and project oriented team player with solid communication and Leadership skills to develop creative solution for challenging client needs
• Self-motivated and possess the ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. A Strong inclination for finishing the job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
• Expertise in writingcomplex Stored Procedures, Indexed Views and Triggers for data
• Consistency and manipulation.
• Expertise in writing and tuningTransact-SQL (T-SQL) (DDL/DML)Queries.
• Good Knowledge ofNormalization/De-Normalization, Normal Form and Data Modeling.
• Proficient in SQL Server technologies suchReplication, Index, Functions and Store Procedures.
• Experience in creatingIndexes, Views,ComplexTriggers,EffectiveFunctions,and appropriateStored Proceduresto facilitate efficient data manipulation and data consistency.
• Proficient in designing highly flexible Database Architectures andData Modeling, Data Mapping, Table Optimization and Performance Tuning.
• Worked onPowerBIPowerPivotto develop data analysis prototypes.
• Experience in usingPowerBItool for developing dashboards.
• Proficient in creatingPowerBIDashboards,Interactive ReportsandCompelling Visualizations.
• Worked extensively on creatingRelationships, Measures,and CalculatedColumnsin thePowerBI.
• Expert in usingDAXandKPIsin thePowerBI.
• Experience in publishingPowerBIDesktop reportscreated inReport viewto thePowerBIservice.
• Efficient in usingPowerViewandPowerMapto visualize reports.
• Experience in using MicrosoftPowerBIPowerQuery to extract data from external sources and modify data to certain format as required in Excel, and createdSSISpackages to load excel sheets from PC to database.
• Experience in usingBulk Copy (BCP), Data Transformation Services (DTS)andSSISwith MS SQL Server 2000/ 2005/2008/2012/2014 .
• Expertise in creating Packages usingSSISforIntegration Services.
• Has a very good experience in creatingSSISPackagesto manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managingEvent Handlers, Package Configurations, Logging, System andUser-defined VariablesforSSISPackages.
• Excellent experience in maintainingError LoggingwithEvent Handlers and Configuring Connection ManagersusingSSIS.
• Worked with data extraction usingSSISandData Warehouse staging, and loading.
• Hands on experience in SQL Server DTS andSSIS(Integration Service) package design, constructing, and deployment
• Experience in managing and automatingControl flow, Data flow, EventsandLogging programmatically using Microsoft.NETframework forSSISpackages.
• Experienced in defining Query for generating drill down reports inSSRS 2005/2008/2 .
• Expert in designing report layout.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats usingSQL Server Reporting Services(SSRS)in Business intelligence development studio (BIDS).
• Experience in developing various kind of reportslike Cascading parameters, Drill down, Drill through, Sub-reportsandCharts.
• Experience in creating Ad-hoc reports, data driven subscription reports by usingReport Builderin SSRS.
• Expert in Experienced in sorting the data, defining subtotals for the reports.
• Proficient in using global variables, expressions and functions for the reports
• Expert in handling Sub-reports inSSRS2005.
• Experience in Reporting Services(SSRS) 2005/2008/2
• Experience inOracle Reports.
• Solid Knowledge in developing cubes usingPartitions, KPI’s,and Perspectives, slow moving dimensions etc., and created various user roles.
• Proficient in buildingCubes,definingReferenced Relationshipsand creatingHierarchiesinSSAS.
• Created complexSSAScubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in DesigningData martandData WarehouseusingStar SchemaandSnowflake Schema for implementingDecision Support Systems.
• Experience in Design and optimization ofOLTP, OLAP tools, creatingSSASbased OLAP Cubes.
• DevelopedMDX Scriptsto create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in calculating measures and dimension members usingMulti- dimensional expression (MDX), mathematical formulas, and user-defined.

TECHNICAL SKILLS

ETL (Extract Transform Load) Tools: SSIS,SQL Server Management Studio, SQL Server Data Tools 2012, SQL Server Business Intelligence development studio (BIDS,DTS)

Reporting/Analysis Tools: SSRS,SSAS, Tableau, Crystal Reports, Power BI, SharePoint

Data Modeling: Erwin Tool, MS Excel

Databases: SQL Server 2016/2 R 2/2008/2005/2000 , MS Access, DB2

IDE Tools: VisualStudio.Net 2005/2008/2010/2013/2015 , 2017,Visual Studio Online

Tools: & Scheduler’s: SQLDeveloper,Control M Scheduler, Quality Center, Rally, Jira (Agile Tools).

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

MSBI (SSIS/SSRS/SSAS/ETL) DEVELOPER

Responsibilities:

• Involved in completeSoftware Development Life Cycle(SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSASTabular Solutionsand launched a series ofParameterized Dynamic Dashboards.
• UsedDAX (Data Analysis Expressions)functions for the creation of calculations and measures in the Tabular Models.
• Develop complexMDX (Multidimensional Expressions), Stored procedures, Function table and views to generate variousDrill-through, Drill-down reports, with Dynamic grouping capability, Parameterized dynamic Dashboard/Scorecardand link and pass the selected parameter values it to itssub-reports usingSSRS.
• PerformedNegative testingandOut- of- box scenariotesting based onBRD(Business requirement document) andFRD(functional requirement document).
• Installation, Upgrade and Migration ofSQL Server 201 R2 and 2008
• Maintain and Manage SQL Databases including Backup, Performance Monitoring and optimization.
• Installation and Maintenance ofSSIS,SSRSandSSAS(SQL Integration, Reporting and AnalysisServices)
• Designed and developedSSISPackagesto import and export data fromMS Excel, SQL Server and Flat files.
• Managed the metadata associated with the ETL processes used to populate the data warehouse usingSSISpackages, extensively worked onmappings, incremental data loading, andSSIS transformations.
• Involved in completeSSISlife cycle increatingSSISpackages, building, deploying and executingthe packages in both the environments (Development and Production).
• Identified the field/column level data quality issues of the source systems to drive thedata quality, data cleansing and error checking in the ETL mappings.Identify and document the source to target mapping data lineage usingSSIS
• UsedSSISfor (ETL) extraction, transformation and loading data fromHeterogeneous source systems.
• Used variousSSIStransformations such asConditional Split, Derived Column,which were used for Data Scrubbing, data validationchecks during Staging, before loading the data into Production tables.
• Used various Transformations inSSISDataflow, Control FlowusingContainersandFuzzy Lookups etc.
• Involved inETL Architecture Enhancementsto increase the performance using query optimizer.
• ImplementedEvent HandlersandError HandlinginSSISpackages.
• Involved inAnalyzing, designing, building &, testing of OLAP cubes withSSAS.
• Developed logical and physical data models (using Star Schema), design data access strategies and wrote SQL code to access and manipulate data stored inrelational databases.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Developed visualizations and dashboards usingPowerBIandPowerView.
• Experience in developing and managing reports and Dashboard usingPowerBI.
• PublishedPowerBIReports fromPowerBIDesktop toPowerBIService.
• Created Tabular Models as a source toPowerBIDashboards and scheduled jobs to refresh it in a timely manner.
• Made changes to the existingPowerBIDashboard on a regular basis as per requests from the Business.
• Created multiple kinds ofPowerBIReports, Dashboards and Visualizations.
• CreatedPowerBIReports using the TabularSSASmodels inPowerBIdesktop and published them to PowerBIService and available in Web clients and Mobile Apps.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complexSQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DMLand User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved inNormalizationandDe-Normalizationof existing tables for faster query retrieval.
• Developing various reports -Drill Down, Cascading, Drill through, Parameterized, Sub-reports and Charts using Global Variables, Expressions and Functions usingSSRS.
• Deployed and generated reports on to the server using theReporting Services Report Manager.

Environment: MS SQL Server 2016/2014/2012 , SQL Server Reporting Services(SSRS),Power BI, SQL Server Integration services(SSIS),SQL server Data Tools(SSDT), MS Excel, Windows XP,TFS.

Confidential, San Diego, CA

MSBI/SQL(SSIS/SSAS/SSRS/TSQL) DEVELOPER

Responsibilities:

• Responsible in writing stored procedures, Triggers, User-defined Functions, Views, Cursors and creating constraints for both Online and Batch requests handling business logic and functionality of various modules
• Perform extensive review of top queries in the environment by analyzing wait trends, reviewing execution plans and column statistics. This resulted in identification of many problems in the environment such as missing indexes/large heap tables/bad clustered index choice etc.
• Perform effective, efficient T-SQL queries and optimize them by examining the SQL Server Estimated Query execution plans and by using SQL Profiler.
• Researched and Analyzed complex SSIS packages which are used to populate Staging, Mapping and Data Warehouse Databases.
• Developed a SSIS package by using Script task and File System Task to refresh the Excel Workbook on daily basis.
• Developed ETL mappings to Extract data from staging area and perform required transformations as per business requirements and load into ODS and Data Warehouse tables.
• Create PowerPivot Reports, publish reports onto SharePoint and deploy models into SQL Server SSAS Instance.
• Wrote T- SQL queries, Store Procedures.
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL.
• Improved Performance of the database by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler, Performance Monitor, and Database Engine Tuning Advisor.
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration
• Create and Manage Parameterized SSRS Reports on-demand (ad hoc) reporting requests from the business units to support the changing needs of the business.
• Develop data visualization reports and Tableau Dashboards. Build Dashboards, automated reports and report templates using advanced Tableau functions.
• Created dashboards in tableau using the various sources of data from Excel sheets, Teradata.
• Create and maintain executive dashboards in Tableau to track performance, support decision making and contribute to the continued development of report automation, self-service distribution through SSRS and Tableau.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Develop SSAS Tabular Model using data from database and using DAX (Data Analysis Expressions) functions for reports and Tabular Models, Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model.
• Created Calculated Columns, Measures in Power BI & Excel depending on the requirement using DAX queries.
• Created Roles for SSAS Tabular Model to provide additional Security at the row-level by using row-level filters.
• Worked extensively with the offshore team, helped translate requirements and explain any changes from the business.
• Collaborate with Developers, Business owners to ensure the creation of production Business Intelligence Designs and implementations.

Environment: SQL Server 2016/2014, MS Excel (PowerPivot), Integration Services (SSIS)2016/2014, Analysis Services (SSAS) 2016/2014, Reporting Services (SSRS) 2008R2, Informatica, Power BI, Tableau 10.0, Tableau Server.

Confidential, Boston, MA

MSBI(SSIS/SSAS/SSRS) DEVELOPER

Responsibilities:

• Performed DTS for data transfer from Oracle, FTP, MS Excel and text file to SQL Server 2012.
• Developed severalstored proceduresto handle large amount of data manipulation.
• Developed, monitored and deployedSSIS(SQL Server Integration Services)packages.
• Created ETL packages usingSSISto extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Responsible for transferring the data usingSSISpackages from excel/flat file sources to database.
• Published migrated data usingSSIS,DTS Wizard (Data Transformation Service)Tool through data flow tasks, look up transformations and script tasks.
• Responsible for scheduling jobs, Altering and maintainingSSISpackages as per schedule.
• UsedTeam Foundation Server (TFS)for version control, source control, reporting and to maintain the SSISpackages.
• Experience inSSISscript task, look up transformations and data flow tasks usingT- SQLandVisual Basic(VB)scripts.
• Created indexes both non-clustered and clustered indexes in order to maximize the query performance.
• Modified queries and stored procedures to improve the performance.
• Involved in creating Cubes and Tabular models usingSQL Server Analysis Services(SSAS).
• Experienced in Data Marts, Data Warehousing, OLAP, Star Schema Modeling, Snowflake Modeling and Dimensions tables using MS Analysis Services.
• SetupSSRS(SQL Server Reporting Services)to integrate with Team Foundation Server(TFS)to develop/build/deploy reports using TFS 2012.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix by usingSSRS andCrystal Reports.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Developed, Prepared Unit Test documents for allSSRSreports.
• Generated on-demand and scheduled reports for business analysis or management decision using SSRS.

Environment: MS SQL Server 2014/2012, Windows Server 2012,SSIS,SSRS,SSAS,Crystal Reports, T-SQL, VB.Net, Visual Studio 2012, TFS, DTS Wizard, TOAD and MS Excel.

Confidential

SQL BI(SSIS/SSAS/SSRS) DEVELOPER

Responsibilities:

• Interacted with a team of business analysts, data architects, application developers, ETL developers and testers. CreatedSSISpackagesto extract data from varioussources including SQL Server, Excel, Flat file, CSV, transformed the data and loadedinto the target data warehouse.
• Proficient at Transforming and validating data usingSSISTransformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Identified dimensions and facts to be included inOLAP datamart through analysis of a multitude ofOLTP data sources.
• Improved Performance by creatingClustered and Non-Clustered Indexesand by optimizing the T-SQL statements usingSQL Profiler.
• Written complexSQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implementedcell-level securityin cubes usingSSAS.
• Automated KPI metrics reporting usingVisual Studio Team Services/Power BI.
• DevelopedTabular, Matrix reports(also called crosstab or pivot), Charts and graphs as per customer requirements UsingSSRS.
• Expertise in creatingReport model usingSSRSso that non-technical users can create their own reports
• Responsible for optimization of reports using a multitude ofSSRSreport optimization techniques at report level and query database level.

Environment: MS SQL Server 2014/2012 Management Studio, ETL,SQL ServerIntegration Services(SSIS),SQL ServerReportingServices(SSRS),SQL ServerAnalysis Services(SSAS),OLAP, Data Ware Housing, T-SQL, SQL Profiler.

Confidential

SQL(SSIS/SSAS/SSRS) DEVELOPER

Responsibilities:

• Experienced in Extracting, Transforming and Loading(ETL)data fromExcel,Flat file, toMS SQL Serverby usingDTSandSSISservices.
• CreatedpackagesinSSISwitherror handling.
• Worked with different methods of logging inSSIS.
• Extensively designed the packages and data mapping usingControl flow task,Sequence container task,Dataflow Task,Execute SQL Task,Data conversion task,Derived Column taskandScript TaskinSSISDesigner.
• Involved in completeSSISlife cyclein creatingSSISpackages,building,deployingand executingthe packages in both the environments (Development and Production).
• Good understanding ofMicrosoft Reporting Service(SSRS)withReport authoring,Report management,Report deliveryandReport security.
• Excellent report creation skills usingMicrosoft Reporting Services(SSRS).
• Createandedit alertsonReports, as per User request
• Modifytheexisting reportsby addingnew logicanddeleting existing logicas the line of Business changesperiodically
• Migrate reports fromDevtoProduction
• Provide oncall supportafter reports are deployed to production
• Export reports in various formats likeMS Excel,PDF,MS Word,TextandCSV
• Experience in creatingTabular reports,Matrix reports,List reports,Parameterized reports,Sub reports,Ad hoc reports(SSRS)
• Experience in writingT-SQL scripts,dynamic SQL,complex stored procedures,functions, triggers.
• UsedTableau 8.2andPowerBIfor creatingDashboardsover thedatabase system.

Environment: SQL Server 2012/2014,SSIS,SSRS,SSAS,OLAP, OLTP Performance Point Server, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL, Tableau,PowerBI