SUMMARY

• 7+years of IT experience working with MSBI/Power BI.
• Worked in different domains like Insurance and Banking Organizations developing IT applications.
• Working in Agile Methodology
• Developed and maintained SSIS packages to integrate with different type of sources such as SQL Servers, Oracle, flat files, and non - SQL sources.
• Good Knowledge of Normalization, Performance Tuning, Development Life Cycle source control and ticketing systems and Version Control tools while Design and Development of Data warehouse.
• Developed and maintained tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax.
• Worked on different C# scripts to Automate SSIS packages to load the data directly to the staging data base.
• Configured Check Points, Break points, Event Handlers and Logging to the SSIS packages.
• Proficient in creating Stored Procedures, Views, Functions and Triggers in T-SQL for designing and Developing SSIS packages.
• Worked on change requests, identifying the defects and working on resolution, processing on SSIS Packages.
• Expert in Creating Tabular and Multidimensional cubes using SSAS
• Expert in creating Partitions, Measures and calculated Colum’s using DAX
• Dimensions, and Calculated Measures, Partitioning and building MDX queries.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Highly skilled in developing OLAP cubes using SSAS measures, measure groups and dimension members in SQL Server Analysis Services using Dynamic Analysis expression (DAX), mathematical formulae, and user-defined functions.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes usingSSAS.Developed the SSAS 2012 Tabular model reports from Data warehouse using SSDT.
• Excellent hands on experience in creating groups and measures, KPIs.
• Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Used Power BI to create self-service BI capabilities and use tabular models.
• 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.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

TECHNICAL SKILLS

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

Reporting Tools: SSRS 2014/2012/2008/ , Excel, Tableau, Power BI, Tibco Spotfire.

Database: MS SQL Server 2014/2008/2005 , MS-ACCESS, Azure.

Programming: C, C++, TSQL.

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

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Power BI Developer

Responsibilities:

• Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, documentation & implementation.
• Worked on building reports for tracking Incidents & Change management on top of Service Now Data.
• Using Service Now REST API’s to pull the data in Power BI.
• Modeling the Data in Power BI to perform combined analytics and published to Power BI Service by implementing incremental refresh.
• Worked on data integration & automation using PowerShell to pull data from email and load it to MySQL Database.
• Performed Power BI Administration task such as managing Gateways, managing workspaces and publishing Apps for broader content consumption.
• Worked on Power BI Embedded to make the report accessible through the company’s intranet portal.
• Automated Power BI Refresh using Power BI REST API’s in combination with PowerShell.
• Conducted workshops and trainings for Business Users & Power Users on Power BI.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.

Confidential, Chicago, IL.

MSBI/SQL/Power BI Developer

Responsibilities:

• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• SSAS cube development in both SQL 2012 and 2014 for operational performance metrics. develop tabular and multidimensional models that are compatible with warehouse standards from scratch.
• Created databases and backups as needed.
• Worked in creating Stored Procedures, Triggers, Functions, Indexes, Tables, and Views for applications.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Test and validate OLAP cube in different environment.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Wrote complex calculations using MDX.
• Developed paginated reports for print ready reports on bagging
• Created both star schema and snowflake schemas using SQL Server Analysis services.
• Created scripts in XMLA to deploy in different environments.
• Created and transformed data such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created row level security to filter the data as per the security standards
• Created role base security for power users
• Created custom hierarchy and dashboard using Tibco Spotfire.
• Created linked servers using ODBC drivers.
• Created user groups and allowed permissions to user.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Created recently introduced composite models to support report requirements.
• Created calculated columns and measures using DAX.
• Import data from different data source to createPowerBIreports and dashboards.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries

Confidential, St, Louis, MO.

Power BI Developer

Responsibilities:

• Import data from different data source to createPowerBIreports and dashboards.
• Involved in creating dynamic well-organized, accurate and insightfulPowerBIreports/dashboards to support strategic decisions.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Worked on end to end project in Azure Environment by pulling the source data from SQL Server and storing the data in Azure SQL Server using Blob Storage and creating reports usingPowerBIDesktop.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created different reports inPowerBIDesktop and publish toPowerBIonline.
• Strong knowledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development withPowerBI.
• Worked onPowerBIdesktop andpowerBIservice to publish the reports.
• Able to implement row level security on data and understand application security layer models in Power BI.
• Defined the report layout in SSRS.Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures. develop tabular and multidimensional models that are compatible with warehouse standards.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Provided 24X7 production support to ensure timely and error free delivery of reports.

Confidential, Mason, Ohio.

BI Developer

Responsibilities:

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS.Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Designed and created OLAP cubes on data warehouse.
• Proficient in making DAX queries in Power BI desktop.
• Designed a partitioning strategy to refresh cubes effectively.
• SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Design web-based resource areas in collaboration with IT guidelines.

Confidential, Quincy, Massachusetts.

MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Developed Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views source control and ticketing systems.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Used Joins, CTE's, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and Stored Procedures and enforced business rules via checks and constraints.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration services (SSIS)
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SSIS.
• Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Developed SSAS OLAP Cubes and Partitioning Cubes.
• Wrote DAX queries to retrieve data from OLAP (SSAS) cubes.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running Stored Procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with dynamic sorting, defining data source and subtotals for the report.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and formatting them using both SSRS.

Environment: Windows 2003 Server/XP, SQL Server 2012/2008/2005 , SQL Integration Services (SSIS), SQL Reporting (SSRS), Business Intelligence Studio, Visual Studio 2008/2005, Team foundation Server, Tableau, VB.NET, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

Confidential, DALLAS, TX

SQL/BI Developer

Responsibilities:

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS.Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Design web-based resource areas in collaboration with IT guidelines.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, TFS, T-SQL, XML, MS Excel, Erwin, Visual Studio.