SUMMARY

• 7 years of professional experience in analyzing, designing, and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS) and PowerBI.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS, creating mappings/ workflows to extract data from SQL Server Excel file, Flat File sources and load into various Business Entities Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies using ETL.
• Expert in developing T - SQL (DDL, DML) statements, PL-SQL statements, Data Integrity (constraints), Rules and Validation issues.
• In-depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX (Multidimensional Expressions) Queries to retrieve data from Multidimensional SSAS Cubes.
• Created Dimension types such as Standard dimension, Parent-Child dimension and Role Play dimension in SSAS.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Experienced on creating multiple kind of Report inPowerBIand present it using Story Points and Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI.
• Expert in developing impactful reports using Tableau.
• Deploying and scheduling reports using SSRSto generate all daily, weekly, and monthly and Quarterly Reports including status.
• Used SSRS to create customized reports, on-demand reports, ad-hoc reports and was also involved in analyzing multidimensional reports
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports.
• Hands on Experience in Migrating SQL database toAzure data Lake, Azure data lake Analytics,Azure SQL Database, Data BricksandAzure SQL Data warehouseand Controlling and granting database accessandMigrating On premise databases toAzure Data lake storeusing Azure Data factory.
• Hands of experience in using SQLinDatabricksfor data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.
• Hands on Experience with HANA, BODS (ETL), Lambda Functions.
• Worked on different Agile Methodologies like Rally & Jira.
• Used Octopus (GIT) for automatic deployment of Packages and code.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: SSRS 2017/ 2016/2012/2008 , Crystal Reports XI/X/9/8, Excel, Power BI, Tableau.

Database: MS SQL Server 2018,2016, 2014/2012/2008/2005 , Oracle 10g/9i/8i, PostgreSQL 9.0/9.1, MYSQL, MS-ACCESS, MDS.

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL, Java, EE, Shell Scripting.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, SSMS

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Web Technologies: HTML, XML, JSON, JavaScript, PHP, jQuery.

PROFESSIONAL EXPERIENCE

Confidential, Orange, CA

SQL/SSIS/SSAS/SSRS/POWER BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Created many calculated columns and measures using DAX inPowerBIbased on report requirements.
• Involved in Tabular Data Warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created several cubes, dimensions, and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R 2/2012/2014/2016/2018.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, PL SQL,DAX, OLAP and OLTP.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data inAzure Databricks.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

Environment: MS SQL Server 2016/2012/2008 R2, Oracle 10g, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Windows 8, Microsoft Azure.

Confidential - Wichita, KS

SQL/SSIS/SSAS/SSRS POWER BI Developer

Responsibilities:

• As a member of BI reporting team my main responsibility is to work with the project controls team to enhance an existing Microsoft Tabular Cube designed for reporting of Confidential ’s projects data.
• Worked with the customers of the cube to understand reporting requirements, translating those business requirements into technical requirements, and executing development in a data warehouse, including a SQL database and SQL Tabular Cube.
• Strongly acquired knowledge and analytical skills of both business processes and applications.
• Actively applied Agile Methodology practices for development of the Microsoft reporting environment.
• Created Physical Model Designs and Logical Model Designs for the Enhancement of projects with estimating time and effort to complete the project.
• Used SSIS package (ETL) to transform data from MYSQL (RDBMS) data warehouse to SQL server database and to convert data into framework with PK’s, indexes and remove duplicate rows.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Flat file, Text formatted data by using different transformations present in SSIS such as Merge, Conditional Split, Union all, Script task, OLE DB command, data conversion, Look-Up, Transformation and more.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Good Experience in Partitioning SSAS cubes based on the cube structure, schema and data sets and writing Stored Procedures to process the cubes on daily bases to reduce the processing time.
• Extensively used DAX for Tabular cubes and Power BI based on the complexity of the measure and requirement.
• Handled testing on the cube and reports were generated using Power BI.
• Created Stored Procedure, functions, indexes (Clustered, Non-Clustered), tables, semantic views and SQL joins utilizing latest DML and DDL syntax.
• Operated performance tuning on the tables and Semantic views which take more time to query the results by creating indexes on the fact tables.
• Extensively Worked on cursors, CTE’s, Schemas, Permissions Performance issues with Client and Server-side database design.
• Implementing Security roles on SSAS cubes and Power BI services by implementing authentication and authorization methods.
• Scheduling the SQL Server Agent Jobs and monitoring the scheduled jobs daily, where most of the jobs load data into staging tables and process SSAS cubes.
• Handed deploying SSIS packages, SQL scripts, SSAS cubes into the Production environment and supporting them for any new enhancements or bug fixes.
• Proficiency in using Source Control in TFS (Team Foundation Server), creating user stories tasks and keeping the Source control updated with updated codes of DB scripts, SSIS packages, SSAS cubes.
• Good knowledge on how the data flows from SAP to HANA and HANA to SQL Server, as SAP is the data source for most of the data in the cooperation.
• Hands-on experience with BODS (ETL) to transform and Load data from HANA to SQL Server and Used to refer to the HANA views to look for the source code and logic for the columns in SQL tables.
• Configured Check Points, Break Points, Event handlers and Logging to SSIS packages.
• Acquired knowledge on the Data sources SAP ERP system and an EcoSys PPM environment.
• Worked with the team which uses Python Scripts to load data from EcoSys API’s to SQL tables. Where I used to help them in testing their code by comparing the data in EcoSys PPM Data source and SQL tables.

Environment: MS SQL Server 2016/2012/2008 R2, Visual Studios 2017/ 2015 Shell/ 2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, MDAX, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2013/ 2018, MS Excel, Excess, Windows 8/10, SAP, HANA STUDIO, EcoSys PPM.

Confidential, Dallas, TX

SQL/SSIS/SSAS/SSRS/ POWER BI Developer

Responsibilities:

• Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
• Maintained all the SQL documents including installation and data conversion Procedure documents.
• Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Creating multi-dimensional cubes using SSAS and designing DW schemas.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Deployed the SSIS Packages to the MSDB as well as File System based on the requirements.
• Designed ETL Packages with Microsoft SSIS 2012 to pull data from various sources like DB2, SQL Server, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions, and triggers.
• Worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages to run sequentially using SQL Server Agent job and windows Scheduler.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2.
• Used breaks, calculations, sorts, filters, and sections to enhance data presentation in reports.
• The ETL process was documented for future references.

Environment: SQL Server 2008R2/2005 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, SSAS, DAX, VisualStudio.NET IDE, Agile, Windows 2000 Advanced Server, Windows 2003 Advanced Server, ASP, MS Excel, MS Access, Visual Studio 2008.

Confidential, Seattle WA

SQL BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Performed T-SQL tuning and optimizing queries and stored procedures, which take longer time in execution.
• Extensively used Joins and subqueries for complex queries involving multiple tables from different databases.
• Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTE’s), User Functions, Views and Indexes.
• Created SSIS packages to extract data from various flat files, Excel spreadsheets and loading into SQL server.
• Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like Execute SQL Task, data flow task, file system task.
• Used data transformations like aggregate, sort, Multicasting, Conditional Split, Derived Column etc. in creating SSIS packages.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and SnowFlake Schema.
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join and Row Count.
• Responsible for creating new reports as well as modifying the existing reports using SQL Server Reporting Services (SSRS).
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS).
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports, Charts and Pie Charts.
• Developed report parameters and performed Parameterized and cascading parameterized reports and sorting the data, defining subtotals for the reports using SSRS in Visual Studio.
• Designed complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirements.
• Created various SSRS Reports involving a variety of features like Reports, Charts, Gauges, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Involved withQuery Optimizationto increase the performance of the Report.
• Strong analytical ability. Proficiency in quickly identifying the cause and solution of a particular database related problem.
• In-depth knowledge of all the widely used operating systems. Able to install and operate databases on different OS platforms.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users, add reports to the SharePoint portals.
• Documented and maintained history of changes for future reference.

Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, Visual Studio, SQL Server Management Studio (SSMS), T-SQL, SSIS, SSRS, SSAS, Visual basic, SQL Server Agent.