SUMMARY

• A 5 years of IT experience as a MSBI and SQL developer that includes migration of data and building of reports using SQL server 2016/2014/2012/2008 R2/2008/2005 and Visual studio 2010/2008.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2014/2016 with expertise on data normalization.
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).
• Experienced in designing and developing large number of reports in SSRS and power BI using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity and for optimum performance in relational and dimensional database environments.
• Data migration across different databases like MS SQL server, Oracle, My SQL, PostgreSQL, Excel, Open data sources, xml, MS access & flat files using SSIS packages.
• Knowledgeable with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering & analysis, detailed design, development, testing and post implementation support
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• 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 SQL Server 2005/2008/2012 Analysis Services (SSAS).
• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

ETL Tools: Microsoft SQL server integration services.

Analysis and reporting services: SSAS, SSRS, POWR BI, MS Excel.

Database: SQL server / My SQL, MS Access

Architecture: Relational DBMS, OLTP, OLAP

Programming language: T-SQL, Python

Data Modeling: SAP Power Designer

Methodology: Agile

Version control tools: team foundation server (TFS), GitHub

Other: MS Office

Operating system: Windows Server

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Gather, analyze, and document business requirements and translate into technical specifications, prototypes
• Develop and design data model and modify existing database model based on the requirement
• Analyzed translated data into informative reports and visuals based on business requirements.
• Connected to various data sources, importing data and transforming data for Business Intelligence.
• Design, test, and develop interactive and visually appealing reports, dashboards, KPIs, and visualizations using Microsoft Power BI
• Write test case for the back end and front end and conduct per review for accuracy prior to deployment.
• Write and execute queries upon request for adhoc report or testing purpose.
• Implemented row level security and understand application security layer models in Power BI.
• Publish and share reports and dashboards to maximize user access, user adoption and business value.
• Proficient in making DAX queries in Power BI desktop.
• Integrate Power BI reports into other applications as needed
• Connecting data sources, importing data, and transforming data for Business intelligence.
• Participated and created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed ad-hoc reports and complex enterprise reports including drill down, drill through reports, cascading reports, sub reports, linked reports using SSR
• Strong experience in Analysis, Design, development, and implementation of end-to-end Business intelligence

Confidential

SQL/Power BI developer

Responsibilities:

• Gather, analyze, and document business requirements and translate into technical specifications, prototypes
• Develop and design data model and modify existing database model on the requirement
• Developed Logical and physical data model using SAP Power Designer and mapped the data into database objects.
• Provide accurate time and effort estimates as well as lead projects of various complexities in an Agile environment.
• Developed visually appalling reports, dashboards, Matrix and KPI scorecards using Power BI by pulling data from heterogeneous data sources and platforms such as SQL server database, data warehouse, websites, Analysis services, CSV, Azure SQL database, Azure data lake, excel
• Publishing and scheduling Power BI reports as per the business requirements.
• Create and modifying Tables, view, Stored Procedures and Functions using T-SQL
• Prepare and maintain database design and data Mapping documentation.
• Written complex procedures, functions and created database objects to manipulate data.
• Troubleshoot issues and optimize reports, processes, and SQL queries/Stored Procedures.
• Designed, developed and established KPIs report to monitor, analysis and provide strategic insights to drive performance for Loan risk department.
• Developed metrics that provide data for loan process management and indicators for future service improvement opportunities.
• Developed report on loan performance on a daily, weekly and monthly basis in Power BI and SSRS
• Worked with senior management team and operation-level managers to gather requirements
• Extract, Transfer and load the data from different data sources like flat files, SQL servers and excel using SSIS.
• Created overly complex SSIS packages using various Data transformations like conditional split, Fuzzy lookup, Multi Cast, Derived column, Lookup, Union All, merge, Copy etc.
• Designed stored procedures to insert new data and update existing data
• Involved in designing and deploying Data warehouse using Snowflake designs for the operational data.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarches based on the OLAP reporting needs.
• Proficient in writing Power BI Data Analytics expressions (DAX)
• Worked with business leaders and data analysts to develop business intelligence solutions and reports
• Strong experience in Analysis, Design, development, and implementation of end-to-end Business intelligence