PROFESSIONAL SUMMARY

• Around 8 years of experience in Database Design, Development & Support of MSSQL Server in Production and Development.
• Strong technical noledge in MS SQL server development and Microsoft BI Tools.
• Strong working experience on SQL Server 2012/2014/2017 including SSIS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience in creating tables, stored procedures, views, triggers, functions, indexes, data integrity, data dictionaries, and relational database models.
• Expertise in design, development, testing and support of ETL process for large scale Data warehousing using SQL server (2005, 2008, 2012), SQL server integration services (SSIS/DTS), SQL server reporting services (SSRS) and Analysis services (SSAS) and DWH concepts.
• Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2012/2014 and Transformation.
• Experience on Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check wif DBCC Commands.
• Experience in SQL Server OLAP database development including KPIs, Data mining, working wif changing dimensions.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Experience in Designing and Building teh Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in creatingPower BIDashboards (Power View, Power Query, Power Pivot, Power Maps).
• Used different type of slicers available in Power BI for creating reports.
• Experience converting SSRS reports toPowerBI.
• Experience working wifAzureSQL Database Import and Export Service.
• Experience in deploying SQL Databases in cloud (AZURE).
• Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Create reports in Power BI preview portal utilizing teh SSASTabularvia Analysis connector.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points and Logging.
• Experienced in Extracting & Injecting Data intoAzureBlob, SQLAzureusingAzureData Factory pipelines from cloud data sources.
• Experience converting SSRS reports toPowerBI.
• Strong noledge on Row Transformations, Partial Block and Block Transformations.
• Experience in creating Ad - hoc reports and data driven subscription reports by using Report Builder.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• DesignedSSAScube to hold summary data for Target dashboards.
• Developed Cube wif Star Schema.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked wif both live and import data in to Power BI for creating reports.
• Experience in RDBMS database and tables design Normalization, De Normalization, Clustered, Non-clustered, Unique, primary, foreign keys and Indexes.
• Experience in creating Jobs,SQLMail alerts and schedulingSSISPackages usingSQLServer Agent.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Experience in Full Software Development Life Cycle (SDLC) including Analysis, Design and Review of Business and Software Requirement Specifications; Development, Testing as per Agile software development methodology.
• Managed relationship between tables in Power BI using star schema.
• Responsible for creating and changing teh visualizations in Power BI reports and Dashboards on client requests.
• Worked on creating theAzureGateways,AzureScheduler and maintaining Pipelines.
• Proficient in using SQL Server Profiler for monitoring teh performance of an instance of teh SQL Server Database Engine, Analysis Server and Integration Services.
• Good Knowledge on data visualization toolspowerBIandPowerPivot.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.
• TEMPEffective Team Player wif excellent Analytical, Programming, Written and Verbal Communication skills.
• Proven ability to approach and solve problems TEMPeffectively and independently.

TECHNICAL SKILLS:

Relational Databases: MS SQL Server 2005/2008/R2/2012/2014, Oracle, MS Access.

Reporting Tools: SSRS, Report Builder.

Database Tools: SQL Server Business Intelligence Development studio(BIDS), SQL Server Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, SQL Profiler, TFS.

Languages: SQL, T-SQL, PL/SQL, VB.Net, V.B6.0, C, C++, ASP.Net.

Web Technologies: HTML, XML, XSL

Data Modeling Tools: ERWIN, ETL, Visio, Microsoft Office Suite.

BI Tools: SQL Server Reporting Tools (SSRS)SQL Server Integration Services(SSIS)SQL Server Analytical Services (SSAS).PowerBI(PowerQuery,PowerPivot,PowerView,PowerMap)

Operating Systems: Windows 2000/XP/2003/2008, UNIX, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential

MSBI Developer

Responsibilities:

• Created SQL queries, stored procedures, views and functions as per requirements.
• Designed SSIS Packages in SQL Server 2015 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Mart and OLAP technologies.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Build and deploy end to end ETL Process to load data into Data warehouse from flat files and source SQL databases using SSIS.
• Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Worked on creating dashboard and tabular reports using SSRS.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Experience in working wif SSAS in creating data sources, data source views, named queries, cubes, roles, calculated columns, dimensions and deploying of analysis services projects.
• SSAS cube Analysis using MS-Excel, Power pivot and Power BI.
• Created cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways.
• Worked on designing and development of SSAS cubes and MDX queries.
• Created MDX queries to extract data from teh Data Mart.
• Created user roles and security for cubes dimensions and measure groups.
• Defining relationships between dimensions and measure groups.
• Created Power BI dashboards using live connection to SSAS tabular model.
• Deployed Cubes, Dimensions and Partitions DEV, STAGE and Production live servers.
• Managed relationship between tables inPowerBIusing star schema.
• UsedPower BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Used MicrosoftPower BI, Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Power BI/SSRS reports are used for creating Dashboards, drilldown reports, Scorecards.
• Scheduled and monitored SSRS report subscription and deliveries such as Email Delivery and File Share Delivery as required.
• Implemented several DAX functions for various fact calculations for efficient data visualization inPowerBI.
• Created various Excel reports using drop downs and v-lookups connected to teh SQL server.

Environment: SQL Server 2017, T-SQL, SQL Profiler, SSIS, SSRS, SSAS,VSTS,Oracle10g, Query Analyzer, Power BI, Power Pivot, Windows, MS Excel.

Confidential services, IL

SQL BI Developer

Responsibilities:

• Worked on new Data ware house design for ETL and Reporting projects using SSIS, SSRS andAzure.
• Created various kinds of reports usingPowerBIand Tableau based on teh client's needs.
• Experienced on creating multiple kind of Report inPowerBIand present it using Story Points.
• Installed Personal gateway on teh server and used to configure teh refresh schedule for dashboard.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created complexSSAScubes wif multiple fact measure groups and multiple dimension hierarchies based on teh OLAP Reporting needs.
• Implemented thecubeobjects like KPIs, Calculated Members using MDX, Aggregations, and Translations as well as Attribute Relationships and Hierarchies to improve summarization performance of queries.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call teh packages.
• Implemented Event Handlers and Error Handling inSSISpackages and notified process results to various user communities.
• Involved in Analyzing, designing, building & testing of OLAP cubes wifSSASand in adding calculations using MDX.
• Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQLAzuredatabase
• Involved in Dimensional Data Modeling andCubepartitioning inSSAS.
• DevelopedSSIS,SSRS/ T-SQLCode and schedules jobs for Jobs Monitoring Automation.
• Worked on PowerShell Script onAzureAutomation account for creating teh scheduling jobs on SSAS cube processing on daily basis.
• Configuring and Deploying of all teh Reports (RDL, RDS) across various SDLC environments.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Experienced in SSAS tabular data modelling.
• Experience in Developing and ExtendingSSASCubes, Dimensions and data source viewSSAS-Data Mining Models and Deploying and ProcessingSSASobjects.
• Developed Scorecards/Reports for teh system usingSSRS, PowerBI.
• Built Ad-Hoc reports inPowerBIdepending on business requirements was one of teh major responsibilities.
• Create Daily/Weekly/Monthly power view reports using Power View Reports and schedule them on teh SharePoint for teh refresh.
• Created Power BI Dashboards to show KPI's in teh project.
• Designed, coded and implemented ad hoc reports in SSRS.
• Worked on formatting SSRSreports using teh Global variables and expressions.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Create reports in Power BI preview portal utilizing teh SSASTabular.
• Experience in Creation and deployment of cubes onSSAS.
• Designed and implemented SSASTabularCube as teh reporting layer.
• Create Power View reports using Power Pivot Data models.
• Developed impactful reports usingSSRS, MS Excel, Pivot tables and Tableau to solve teh business requirements.
• Experienced in performed partitioning of cubes as well ascubeoptimization in order to increase teh performance of cubes inSSAS.
• Creating and deploying parameterized reports usingpowerBIand Tableau.
• Worked on Data Analysis Expressions (DAX) for accessing data directly fromtabularSSAS database.
• Import data from SQL Server databases and Analysis services into power pivot data model.
• Maintained teh physical database by monitoring performance, integrity and optimizeSQLqueries for maximum efficiency usingSQLProfile
• Created Power BI Reports using theTabularSSAS models in Power BI desktop and published them to Dashboards using cloud service.
• Created various kinds of reports using Power BI and SSASTabularbased on teh client's needs
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Created data base backups and restored in several environments.
• Created designs and process flow on to how standardize Power BI Dashboards to meetthe requirements of teh business.
• Developed ADF Pipelines for Extracting & Injecting Data into ADF, SQLAzureand Blob.
• Migrated topology from on premises to Cloud using teh optimizedAzureArchitecture solutions.
• Created Load balancer architecture to distribute teh load amongAzureVirtual Machines basedon regions for SQL Analysis Services and Web Applications.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Made changes to teh existing Power BI Dashboard on a regular basis as per requests from Business.
• Created data maintenance plan for backup and restore and update statistics and rebuild indexes.
• Granted access to teh data base users by creating logins wif appropriate role permission.

Environment: SQL Server 2016, T-SQL, SQL Profiler, SSIS, SSRS, SSAS,TFS, SSAS, MS SQL Server 2012/2014 R2,Oracle10g, Query Analyzer, Power BI, Power Pivot, Windows 2010, MS Excel.

Confidential, VA

SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Configured and installed SQL Server on Windows Server and migrated databases from different databases to MS SQL Server.
• Created various kinds of reports usingPowerBIand Tableau, SSRS, Excel, and PowerPivot based on teh client's needs.
• Created calculated measures in acubeby using MDX scripting and worked on slowly changing dimensions.
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, tan moved teh data into dimension and fact tables.
• DevelopingTableauDesktop reports & dashboards both as standalone and as secureTableau Server reports.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created Data-data packages inSSISas part of teh automating teh process for billing method.
• Scheduling and MaintainingSSISPackages and batch jobs through SQL Server Agent and using Shell Scripts, C# Script and batch (.bat) files on a day to day basis
• Publish teh developed dashboard, reports on theTableauServer so dat teh end users having access to teh server can view teh data.
• Creating multiple kinds ofPowerBIReports, Dashboards and Visualizations.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's & DAX Queries using SQL Server 2012 Analysis Services Tabular Model.
• CreatedPowerBIReports using teh Tabular SSAS models inPowerBIdesktop and published them toPowerBIService
• Involved in performance tuning to optimize queries and enhance teh performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard.
• Wrote complex Stored Procedures, functions and triggers as and when needed and to convert data logically as per teh business requirements to improve teh productivity of teh claims processing system.
• Experienced working on Star, Crystal and snow flake schemas and used teh fact and dimension tables to build teh cubes, perform processing and deployed them toSSASdatabase.
• Experience in configuring wif checkpoints, error logging and package logging to redirect error rows and fix teh errors inSSIS
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all teh SSIS Packages.
• Set up ETL Jobs to run on a nightly basis into teh Data marts by Scheduling SSIS Packages via SQL Server Agent.
• Developedcubeperspectives, conditional formatting and developed propercuberefreshing methodology either usingSSASprocessing task or Pro-active caching.
• Documented all kinds of Reports and SSIS ETL Packages.
• Designed and developed various types of reports usingTableau.
• Worked wif complex reports for Batch process usingTableauand wif building teh portal to access all teh reports.
• Involved inCubeOptimization and Partitioned and assigned proper storage modes for teh cubes dat are used as sources for my reports.
• Employed bar charts, bubble charts, andPowermap to answer business questions wifPowerBI.
• Mapped millions of records over Bing maps from Excel data model and discovered actionable insights for strategic planning utilizingPowerBI(PowerMap).
• Designed and DevelopedSSISPackages using various Control Flow and Data Flow items to Transform and load teh Data from various Databases and into Siemens Servers usingSSIS.
• ImplementedSSRSsolutions, used dashboards and gauges to enhance for teh business users.
• Created Parameterized reports and Linked reports wif teh noledge of report server architecture.
• Used Team Foundation server (TFS) to check in teh code changes on daily basis & to keep track of teh changes in teh team.
• Involved in testing teh SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled teh performance issues TEMPeffectively.
• Connected to teh FTP Server and pull teh group of Excel sheets into teh SSIS from thefolder located on FTP Server.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using parameters, queries and reports in SSRS Report Builder, Developed data-driven subscription to end-users.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Responsible for Deploying, Scheduling Jobs, Alerting and MaintainingSSISpackages using integration services catalog.

Environment: T-SQL, SSIS, SSAS, SSRS, MS SQL Server 2012, TableauDesktop (Desktop, Server), Microsoft Visual Studio,Tableau, SQL Server Management Studio, MDX, Excel, Windows server 2008, Visual Studio 2008/2010, TFS

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Analyzing teh transactional data in DB2 and other source systems using Data Profiler.
• Worked wif integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data).
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load teh Data usingSQLServerIntegration services (SSIS)
• Responsible for ProcessCUBEPartitions and Dimensions.
• Created new logical and physical design of database to fit new business requirement and implemented new design intoSQLServer.
• Created complexSSAScubes (Bottom Up designed cubes) wif multiple fact measure groups and multiple dimension hierarchies based on teh OLAP Reporting needs.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to teh business requirement.
• Experienced in implementing complex dynamicSQLcommands such as Stored Procedures, Triggers, Functions, Indexes, Tables, Views,SQLjoins and other T-SQLstatements.
• Understanding teh OLAP processing for changing and maintaining teh warehousing, optimizing Dimensions, Hierarchies and adding teh Aggregations to thecube.
• Involved in writing MDX queries for various calculated members
• Utilized Extract, Transform and Load (ETL) process inSQLServerIntegration Service (SSIS) to migrate databases from Heterogeneous data Sources (DB2, Access, or Excel) to a centralized IT destination.
• Wrote MDX scripts for KPIs and Calculated members based on teh business requirements inSSAS.
• Experienced in Developing, Monitoring, Configuring and Deploying SSIS packages.
• Monitored performance and optimizedSQLqueries for maximum efficiency.
• Extensively worked on reports usingSQLServerReporting Services (SSRS 2008, 2012) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart Sub Reports and Dashboards using Sparkline, Gauge and Bars etc.
• Worked wif Flat Files, OLE DB Source, and Excel Source loading.
• Pulled data from different sources viz. Web, SQL Server, OData, public,SSAScubes, Tabular model and corporate data sources for dashboard generation using Power Query.
• Involved in Deployment of SSIS Packages across various Production, QA environments.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Strong conceptual, analytical, and design skills wif leadership qualities. Able to work wif a team or individually wif excellent communication skills, and ability to meet deadlines in a fast-paced work environment.
• Created various reports according to teh business requirements. Individually authored, installed, deployed and managed reports using SSRS 2008.
• Generated various Report models on Views and deployed them on to teh production reportingserver.
• AnalyzedSQLqueries using Execution plan, Query Analyzer,SQLProfiler and database Enginetuning Advisor. Hands on experience in using tools like Index Tuning Wizard,SQLProfiler and Windows Performance Monitoring.

Environment:SQLServer2012/2008R2,MS Excel, MSSQLQuery Analyzer, Crystal Reports,SQLProfiler, SSAS, SSIS, ETL, MSSQLServerReporting Services, MSSQLServerAnalysis Services.

SQL Server Developer

Responsibilities:

• Installed and configured MSSQLServerand Applied service packs and hot fix.
• Logically and physically designed database for projects on basis of user requirements using ERWIN.
• Created complex Stored Procedures.
• Used Query Analyzer to optimizeSQLQueries.
• Wrote various Stored Procedures for teh purpose of application development
• Converted variousSQLstatements into Stored Procedures thereby reducing teh Number of database accesses.
• Ensured constraints and writing triggers to apply teh business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Successfully loaded data from an EXCEL, Access into aSQLServerdatabase Table.
• Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones
• Worked closely wif teh team in meeting teh deadlines pertaining to design and development deliverables.
• Scheduled Backups and performed Restore operations for system test data.

Environment:MSSQLServer2012, T-SQL, Enterprise Manager, Windows Server, MS Office, Erwin.