SUMMARY

• Around 6 years of experience in IT as Business Intelligence developer working in various domains such as Finance, Insurance and Healthcare in 2012/2008R 2/2008/2005/2000 Windows Environment and other tools and technologies.
• Experienced in software development life cycle in all phases.
• Extensive experience in using Microsoft BI studio including SSIS, SSAS, SSRS for implementing ETL in data extraction, transformation, loading and building various reports.
• Expertise in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using MS SQL Server 2000/2005/2008.
• Experience in using various sources to pull data into Power BI such as Oracle, SQL Server, Teradata, SQL Azure, etc.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Expertise in writing complex DAX functions in Power BI.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expertise in generating reports using Power BI, SQL Server Reporting Services, Tableau, MS Excel spreadsheets and Power Pivot.
• Expertise in designing complex reports like reports using Cascading parameters, Drill - Through Reports, Parameterized Reports and ad-hoc reports using SQL Server Reporting Services based on client requirements.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Good team player, Excellent interpersonal and communication skills combined with self- motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

• MS SQL SERVER 2012/2008/2005/2000
• MS SQL SERVER Management Studio
• Business Intelligence Development Studio
• SQL Server Enterprise Manager
• Oracle
• Teradata
• DB2
• SQL
• T- SQL
• Power BI
• Tableau
• MS Excel
• MS ACCESS
• SQL Server Integration Service (SSIS)
• SQL Service Analysis Service (SSAS)
• SQL Server Reporting Service (SSRS)
• SQL profiler
• MS VISIO
• Windows NT/2000/XP
• ASP.net
• VB.net

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

SQL Server/ SSIS/ SSAS/ Power BI Developer

Responsibilities:

• Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2000, 2005, 2008, 2012.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Used MS SQL Server SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create
• Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Scheduled Automatic refresh and Scheduling refresh in Power BI service.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Created Workspace and content packs for business users to view the developed reports.
• Expertise in writing complex DAX functions in Power BI
• Developed power BI reports and dashboards from multiple data sources
• Explored data in a variety of ways and across multiple visualizations using Power BI
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Worked on all types of transformations that are available in Power BI query editor.
• Created Drill Down Reports, Drill Through Report by Region.
• Wrote calculated columns, Measures query’s in Power BI desktop to show good data analysis techniques.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications. Created different Power Pivot reports as per the client requirement.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.

Environment: MS SQL Server 2017 Management Studio, Business intelligence development studio (BIDS), SQL Server Integration Services(SSIS), SQL Server Analysis Service(SSAS), Power BI, T-SQL, Visual Studio 2017, Microsoft Azure, MS Access, MS Excel, windows 2000/2003 VB.net.

Confidential, Dallas, Texas

SQL/MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of
• Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Use to update the database properties directly by getting into facets.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Ad-Hoc Reports, Summary Reports, Sub Reports.
• Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer Representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS).
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, CTE’s, redesigning schemas and many more.
• DDL Scripts for generating Tables, Views, Functions.
• Involved in performance tuning using indexing (Clustered Index, Non-Clustered Index) tables.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Generated Reports using Global Variables, Expressions and Functions for the reports.

Environment: ASP.Net, MS SQL Server 2005/2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, SSRS, SSIS, SSAS, MS Excel.

Confidential

MS SQL/ MSBI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Designed and developed custom .NET components and user controls using ASP.NET. Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Designed and created data extracts, supporting SSRS, Power BI reporting applications.
• Developed various dashboards in Power BI as per client requirements.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily and worked on all types of transformations that are available in Power BI query editor
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, Power BI, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, T-SQL.