PROFESSIONAL SUMMARY:

• Experienced software professional with 8+ years of experience in Data Modeling, Data Analytics and Data Warehouse
• Experience as a technical architect.
• Expertise in Micro Soft BI Tools (SSIS/SSRS/SSAS/Power BI/Azure) and T - SQL using SQL Server 2005/2008R2/2012 .
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Expertise in Agile Scrum methodology, worked on Agile Environment. Experience in creating stories and tasks for Agile Iteration
• Expertise in Power BI, Power Pivot, Power View, Power Query and M language
• Experience in T-SQL (D DL, DML and DCL), Creating, developing new database objects by like 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 2000/2005/2008 R2/2012/2016 .
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experience in developing and debugging Stored Procedures and Triggers.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Used tools like MS SQL Profiler, Index Tuning Wizard, Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS 2005/2008 R2/2012/2016.
• Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server using SSIS /DTS using various features like data conversion etc.
• Hands on experience with migrating of DTS packages to SSIS from lower version (2005) to higher version (2005/2008/2012 ) and also trouble shooting migrating issues.
• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages .
• Experience in working with different type Dirty Data from Different sources.
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union .
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Creating and Deploying SSRS Reports on the portal for user accessibility.
• Hands on Experience in generating reports for OLTP and OLAP databases.
• Worked on ActiveX Scripting for job scheduling
• Experience in implementing surrogate key generation strategy in the Data warehouse.
• Experience in generating On-demand and Scheduled reports for management decision and business analysis by using SSRS.
• Proficient experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot) , Performance Point Server (PPS) and Power view .
• Hands on Experience in Excel Pivot tables .
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Worked with Confidential Power BI , DAX expressions, Power View and Power Query integrated with share point.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Excellent hands on experience in creating groups and measures, KPIs.
• Experienced in building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
• Experience in performance tuning, processing and deploying the cubes.
• Experience in cube partitioning for better database performance.
• Experience in TERADATA 12/13 and Utilities (BTEQ, FastLoad, MultiLoad and Tpump).
• Experience in Azure SQL, Azure data lake, Azure data warehouse, Azure data factory
• Experience in Azure Blob storage and azure pipelines
• Having good experience on big data.
• Having good experience on UNIX.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/2014 , ORACLE, MS Access, TEREDATA 12/13, DB2.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection) , SQL* Plus.

ETL-Tools: DTS, SQL Server Integration Services (SSIS), BCP, Import/Export Wizard, BI Studio, Informatica 9.5x.

OLAP - Tools: SSAS, MS Excel, Tabular Models

Reporting and Analysis Tools: Visual Studio, Report Builder, SSRS, Tableau, POWER BI Desktop, Power View, Power Map, Power Pivot

Programming: T-SQL, PL/SQL, VBA, Dynamic SQL, MDX, DAX, Hive, C# .NET, XML, JSON, Java, R, ActiveX Scripting, No SQL

Operating Systems: Windows 7/Vista/XP/2008/2003, Windows 9x, UNIX.

Application Packages: MS Office, Confidential SharePoint Server (MOSS) 2007/2010.

Cloud Tools: Azure SQL, Azure data Lake, Azure Data Warehouse, Azure ML

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

MS SQL/SSIS/SSRS/SSAS/TERADATA/Tabular Model/Power BI Sr.Technical Consultant

Responsibilities:

• Participated in the requirement gathering sessions to understand the expectations and worked with system analysts to understand the format and patterns of the upstream source data.
• Involved in writing the Design documents for new features & Enhancements
• Built a Tabular Model cube from scratch data.
• Built Measures in tabular model using DAX queries and created partitions in tabular model.
• Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS tabular model cubes.
• Build end to end automation of Social media sources
• Automate SSAS tabular model cube processing using XMLA queries.
• Developed Multiple Power BI dashboards on top of different sources
• Developed data model in Power BI and implemented Many to Many relation ships
• Automate Power BI data refresh by using Power BI Enterprise gateway
• Did custom transformation in power BI by using M Language
• Expertise in DAX Queries to build Power BI calculated measures and Calculated columns
• Published Power BI reports to Power BI web service and Implemented Security for users
• Directly interact with end users to get the ad hoc requirements and report modifications
• Developed POWER BI Ad hoc reports on top Existing Teradata data warehouse.
• Implemented project technical designs
• Getting data from Teradata data warehouse.
• Developed Tabular model and generates Power BI dash boards on top of that.
• Worked on R programming to create custom visual in Power BI.
• Developed data warehouse using SSIS, SSAS tabular models.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed Azure Pipe lines and getting data from IoT.
• Experience in Azure SQL and Azure blob storage
• Migrated legacy SSIS packages into Azure data warehouse
• Schedule Azure Pipe lines in Azure Job scheduler
• Migrating SQL Server 2012 SSIS packages to SQL Server 2016

Confidential, Redmond, WA

MS SQL/SSIS/SSRS/SSAS/Power Pivot/Power BI Senior Developer

Responsibilities:

• Created Databases, Data Marts, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created and modified tables, views, indexes, functions, triggers and stored procedures according to Business Requirement.
• Experience in managing semi-structured data through XML and JSON .
• Involved in complete SSIS life cycle in creating SSIS packages , building, deploying and executing the packages in both the environments (Development and Production).
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012 .
• Written stored procedures and used them in packages.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages .
• Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
• Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query) , Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Created reports by using Joins in multiple tables from multiples database using complex SQL queries
• Writing MDX queries to get the data from a tabular model.
• Extracting the non-structured data through JSON scripting and trimming in SQL databases.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
• Worked with Excel Power Pivot Tables.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports .
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI .
• Building Ad-Hoc reports depending on Business requirements is one of the major responsibility.
• Performing data management projects and fulfilling Ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Created Azure data warehouse and Azure data lakes using Azure pipeline.
• Having Good knowledge on Azure machine Leaning

Environment: MS SQL Server 2012/2014, BIDS, Management Studio ( SSMS ), ETL, Integration Services ( SSIS ) 2008 R2/ 2012, Reporting Services ( SSRS ) 2008 R2/2012, Power BI , TFS, SQL Profiler, SQL Server Query Analyzer, Tabular Models, Azure.

Confidential

Senior BI Developer/Project Owner

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Worked in Building Tabular Models using SSAS
• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point)
• Worked with DAX/MDX queries in building expressions for various business calculations
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Transferred the data using SSIS packages.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Generating Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Deployed the generated reports directly on the client’s workstation.
• Used star and snow flake schema in designing cubes for creating SSAS packages.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Monitored Scheduled jobs and alerts.
• Used ActiveX Scripting for automating job scheduling

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Pervasive, Windows Server 2007SSIS, SSRS, SSAS, TERADATA SQL, BTEQ.

Confidential, Florida

MS SQL Server/SSAS/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
• Worked with latest ASP.NET MVC framework on visual studio 2012.
• Developed the application using C#, ASP.NET , and JavaScript with SQL Server as the back end.
• Implemented .NET classes for Business logic Layer using C#.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema and snow flake schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Ad-Hoc reporting was one of the major responsibilities.
• Built SSAS Cubes for Aggregate reporting
• Worked in Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.

Environment: SQL Server 2000/2005, Enterprise Edition, SQL, Enterprise manager, SSRS 2005, SSIS 2005, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, VB.NET, ASP.NET.

Confidential

Sr. SQL Developer SSIS/SSRS/SSAS

Responsibilities:

• Utilized SSIS (SQL Server Integration Services) in producing Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads
• Monitored performance and optimize SQL queries for maximum efficiency.
• Generated a SSIS solution for developing a Data warehouse solution.
• Developed, monitored and deployed SSIS packages.
• Implemented drill down and drill through reports in SSRS.
• Created AD-Hoc Report models and drill down and drill through and complex reports using SSRS
• Reports are generated for Datasets by identifying and defining them.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Created views as per design needs.
• Responsible for maintenance of data integrity by performing validation checks.
• Tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008, MS SQL Server Integration (SSIS)/Reporting Services 2005/2008, TFS and Source Control.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Added/Changed tables, columns, triggers, and T-SQL code.
• Use of Indexes, Views, Trigger and Stored Procedures for updating and cleaning of the existing data and also the new data that has to be added.
• Migrating MS Access/Sybase SQL Server 11.5 databases to SQL Server.
• By utilizing constraints and writing triggers to apply the business rules. Backing Up and Restoring User Databases
• Managed and created databases for clients and also frameworks to provide import of client data and reporting of finalized data.
• Involved in performance tuning and backing up of two Confidential SQL Servers.
• Creating Distributed Partitioned Views, Debugging/Troubleshooting Stored Procedures and also upgrading existing ones.

Environment: SQL Server 2000, Windows 2000/XP, Sybase, Business Objects 5.x/6.x, Informatica 6.x/7.x SQL Query Analyzer, SQL Developer edition.