SUMMARY

• Having 8+ Yrs. of experience in BI (SSRS, SSIS, and SSAS) development knowledge and Data warehousing software applications.
• Hands on experience in working on SQL Server 2005/2008R2/2012/2016 databases, Azure SQL, Azure Azure Data Factory &Azure Data Lake.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2008 R 2/2012/2016.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, TEMPEffective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP), Indexed Views & Schema Binding, Clustered/Non-Clustered Indexes.
• Enhancing current technical expertise, and applying SSIS, SSRS, PerformancePoint Server (PPS), T-SQL transferable skill sets.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQLServer 2005/2008/2012 Analysis Services (SSAS).
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes usingSSAS.
• Experience in working Confidential Azure cloud platform in components of ADF, ADL and Azure SQL & Datawarehouse.
• Experience in analyzing and working on requirement gathering from business.
• Experience in working Offshore Onsite Model.
• Knowledge on reporting tool Tableau and MicrosoftAzureCloud space.
• Experience in working Excel Power Pivot &Power BI reports.
• Knowledge of programming languages, such as Java, Node.js, PHP etc.,
• Hands on experience in creating Scorecards and Dashboards using PPS.
• Having good Knowledge of ETL Concepts like Lookup Caches, Package Configurations and Variables.
• Hands on experience in Creating Stored Procedures, Functions, Indexes, Views and CTE.
• Experience in Extraction, Transformation, and Loading of data directly from different heterogeneous source systems like Flat File, CSV, XLS and Relational Database.
• Has good problem solving and analytical skills. Highly motivated professional, Team Player and teh ability to TEMPeffectively Work with, communicate and mentor people.
• Experience in Agile Methodology Scrum approaches in teh SDLC. knowledge of HDFS, and Hadoop/Hive and familiarity with big Data technologies (HBASE, Spark).
• Excellent communication skills: Able to interact with users and business owners.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS) Confidential Azure cloud platform (Azure Data Factory, Azure Data Lake, Azure SQL)

Reporting Tools: SSAS 2016/2008R2, Crystal Reports XI/X/9/8, Excel, Tableau, Power BI.

Database: MS SQL Server 2016/2008R2, MYSQL, MS-ACCESS.

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

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

Languages: T-SQL, MDX, VBA, VB 6.0, PL/SQL, UNIX, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, HTML, Java Script, CSS

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, VSTF.

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

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

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

AZURE SQL/T-SQL/SSIS/SSAS/Cosmos/Power BI/MS Azure Developer

Responsibilities:

• Involved in Technical and Business decisions for Business requirement, Interaction with Business Analysts, Client team, and Development team through Agile Kanban process.
• Creating Azure Data factories for loading teh data to Azure SQL database from Cosmos platform.
• Created complex power BI dashboards.
• Developed, deployed and monitored SSIS Packages for new ETL Processes.
• Performed teh role of Scrum Master in daily stand up calls.
• Developed, deployed and monitored SSAS cubes.
• Performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.
• Involved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources like SQL Server, Oracle, Text files and some Legacy systems.
• Expertise in using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files to SQL Server using SSIS/DTS packages using various features.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Strong experience in designing and implementing ETL packages using SSIS for integrating data using OLE DB connection from heterogeneous sources.
• Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
• Experience in creating reports from scratch using Power BI from Excel workbook dat contains Power View sheets.
• Created roles using SSASto restrict cube properties.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created calculated measures using MDX implementing business requirement
• Experienced working on Star and Snowflake Schemas and used teh fact and dimension tables to build teh cubes, perform processing and deployed them to SSAS database.
• Designed aggregations and pre-calculations in SSAS.
• Involved in designing Partitions in Cubes to improve performance using SSAS.
• Experienced in DevelopingPower BI Reports and Dashboards from multiple data sources using Data Blending.
• Used recently introduced Power BI to create self-serviceBI capabilities and use tabular models.
• Responsible for creating and changing teh visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on teh requirement using DAX queries.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data in to Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.

Environment: MS SQL Server 2014/2016, Power BI, SSIS, SSRS, SSAS, SQL Profiler, T-SQL, C#, web DEV(VB.NET), Visual Studio, Azure Data Factory, Azure Data Lake, Cosmos.

Confidential

SSIS/SSAS/T-SQL/Power BI Developer

Responsibilities:

• Built business intelligence and data visualization dashboards using various technologies such as Confidential Power BI.
• DesignedSSISPackages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per teh client requirements.
• Gatheird business requirements, definition and design of teh data sources and data flows.
• Written T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.
• Monitored and provided front-line support of daily processes.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Created SSIS packages for File Transfer from one location to teh other using FTP task.
• Create and maintain SSIS packages to extract transform and load data in to SQL Server.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Involved in ETL architecture enhancements to increase teh performance using query optimizer.
• Configured teh loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Designed various SSIS modules in order to fetch teh data in teh data staging environment based on teh different types of incoming data.
• Designed and created Report templates, bar graphs and pie charts based on teh financial data.
• Delivered enterprise, web-enabled reports using SSRS.
• Implemented Database project solution for deploying database objects.
• Created reports as per user requirements using MS Reporting Services 2012.
• Created report models using teh report model designer to support Ad hoc reporting.
• Involved in requirement gathering, analysis, design, development & deployment.
• Provided support to teh application developers on teh application databases.
• Configured and deployed different reports to teh servers using SQL Server 2012 SSRS
• Created complex stored procedures, triggers, cursors, tables, and views, using T-SQL.
• Experienced in T-SQL design, coding, testing and implementation.
• Developed and optimized stored procedures, views, and user-defined functions for teh application.
• Developed custom scripts and stored procedures for data import and manipulation in T-SQL.
• Used cascaded parameters to generate report from different Data Sets.
• Involved with T-SQL query optimization to increase teh performance of teh report.

Environment: MS SQL Server 2014/2016, Power BI, SSIS, SSRS, SSAS, SQL Profiler, T-SQL, C#, VB.NET, Visual Studio.

Confidential

SQL/SSIS 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
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Wrote Procedures and database triggers for teh validation of input data and to implement business rules Developed severalSQLreports for teh Business Users to check teh post processing rules.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Upgraded existing packages developed using SSIS 2008 to SSIS 2012 packages.
• Scheduled teh SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Created SSRS report templates for ease of report development.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• ImplementingDashboardsandScore Cardsusing Confidential Performance Point Server and integrated with share point.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Developed Star schema using SSAS cubes.
• Created parallel period, filter, ancestors and cross join MDX queries.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Involved in analyzing and designing disaster recovery/replication strategies with business managers to meet teh business requirements.
• Designed Dimensional Modeling using SSASpackages for End-User. Created Hierarchies in Dimensional Modeling.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified teh Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Experience in designing highly interactive visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Combined views and reports into interactive dashboards in Tableau Desktop dat were presented to Business Users, Program Managers and End Users.
• Reviewed basic SQL queries and modified inner, left and right joins in Tableau Desktop by connecting Live/dynamic and static datasets.
• Worked on generating various dashboards in Tableau Server using different data sources. Used Data Blending to merge data from different sources.
• Created multiple dashboards with Drill Down capabilities using dashboard prompts, Local and Global Filters.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure dat teh views and dashboards were reflected with modified data.
• Created Calculated Columns and Measures in Power BI and Excel depending on teh requirement using DAX queries.
• Responsible for creating and changing teh visualizations in Power BI reports and Dashboards on client requests.
• Responsible for building reports in Power BI from teh Scratch.
• Involved in administering user, user groups and schedule instances for Tableau reports.
• Maintaining Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on teh business needs.

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), Visual Studio 2010/2013, Tableau, MS Excel 2010, VB.Net, ASP.Net, C#, Python, Perl, TFS.