PROFESSIONAL SUMMARY:

• Total 7+ Years of experience in the analysis, design, development, implementation of client/server applications. 2+ years of experience on Power BI.
• Designed and developed Power BI reports, dashboards, visuals on Power BI Desktop and published to Power BI Services
• Used DAX functions to create measures and columns,, use of Filters, drill down and drill through reports
• Created required Gateways to pull data directly from databases to get refreshed data regularly
• Worked on Row level security to restrict data access at hierarchical level in Power - BI
• Use of various visualizations and KPI scorecards to help client with informed business decisions
• Created necessary Data Models to accomplish various report requirements for the client
• Designed and developed reports from Data Warehouse using SSRS
• Inspired, amiable, team player, independent, good at problem solving, multitasker, completes tasks on time, great communication and interpersonal skills

TECHNICAL SKILLS:

OLAP/Reporting tools: Power BI 2.52/2.41, MSBI - SSRSS,SSAS, Business Objects XI/R3.1/R3/R2/6.x/5.x,SAP BI 7.0 (Universe Design, Desktop Intelligence, Web Intelligence, Salesforce, Tableau, ERP

MSBI: SSIS, Data stage 9.X/8.X/8.7

RDBMS: MySQL, MS SQL Server 2016,2014,2012 Denali, Oracle 12c/11g/10g/9i,Teradata, DB2

Languages: SQL, PL/SQL, HTML, XML, Python, Java, C, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Power BI Developer

Responsibilities:

• Understanding the business requirements and providing solutions through appropriate Power BI Reports
• Determining connectivity mode to get data to from the data source, SQL, DB2 to Power BI desktop
• Developing Power BI reports, dashboards and publishing to Power BI Services
• Created necessary Data Models to accomplish various report requirements for the client
• Use of DAX function to create measures and columns for reports
• Use of various visualizations and KPI scorecards, creating bookmarks and alerts for reports
• Use of append and merge queries, parsing parameters
• Using Filters, generating Drill through and Drill down reports with Drop down menu option in Power BI Reports
• Created required Gateways to pull data directly from databases to get refreshed data regularly
• Implementing hierarchical row level security as applicable to restrict data access
• Maintaining technical standards for design development, configuration and testing of BI reports and dashboards,
• Coordinating with onshore and offshore teams for smooth development of the project

Environment: Power BI, MSBI (SSIS,SSAS,SSRS), DB2, SQL Server, Microsoft office 365, Azure DevOps, Oracle, Windows 10 / Sever UNIX

Confidential , Ann Arbor, MI

Power BI - Developer

Responsibilities;

• Designed and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements.
• Creating Gateways and other related data connections
• Used Filters to genera te Drill through and Drill down reports with drop down menu option, sorting the data, and defining calculation s for Power BI reports
• Use of DAX function to create various measures and use of advance calculations for reports .
• Created various visual s as per client requirements like slicer, cards, Pie and donut charts, clustered bar and column charts, ribbon chart
• Applied Row level security to restricting data access
• Scheduled the data refresh for dashboards and reports to show the live data.
• Created SQL Queries, database scripts and Created and modified Stored Procedures, Functions, and Indexes.
• Experience in transition of the new applications from development team to Support team

Environment: Power BI 2.41, SSAS,, SSRS, SQL Server, Microsoft office 365, Azure DevOps, Oracle, Oracle, Microsoft office 365, Windows 10 / Sever UNIX

Confidential, Springfield IL

MSBI Developer

Responsibilities:

• Understand and translates business use cases and requirements into data analysis and data mapping and consequently data integration
• Identified data sources, provides data flow diagrams and documents source to target mapping and process.
• Designed, implemented and maintained database objects (tables, dimensions, views, cubes etc.) and database security
• Created necessary Data Models to accomplish various report requirements for the client
• Designed, created and tested reports using SSRS with use of required partitions, aggregations, calculations and use of KPI’s in reports for informed business decisions
• Transform ad hoc and manual processes into sustainable, repeatable, scalable, automated solutions
• Create and maintain visual dashboards to monitor the product
• Design, develop, and support multi-dimensional analysis with various OLAP technologies.
• Perform data analysis to troubleshoot data issues with the BI solutions and data integration process

Environment: SSAS, SSRS, SSIS, T SQL, MDX, SQL Server, ETL, Oracle, Microsoft office 365, Visual Studio, Windows 10 / Sever UNIX

Confidential, Indianapolis, IN

BI Analyst

Responsibilities:

• Understand existing business processes and designed and developed reports as per requirement
• Work with production data to design access structures, Identify the performance bottle-necks in the report and resolve the same, Performance Tuning and Optimization of reports,
• Create data results through techniques and tools such as basic queries, data mining and multidimensional analysis
• Understand the data structure and meaning in both the source and the target BI systems, identify and assess data sources, created source/target mappings
• Validated hierarchies, developed security rules/standards
• Converted existing reporting applications to the environment and developed new periodic report applications, perform query tuning and optimized existing production procedure code.
• Working with Global team and onshore team to ensure timely progress of the project
• Weekly & Monthly progress reports of the projects to top management
• Involved as a liaison between technical development team and top level management

Environment: XML, Control M, IBM Data Stage, IBM WebSphere, Unix, Business Objects XI R2, Oracle 10g. Microsoft office, Windows 10 / Sever UNIX