SUMMARY

• Total 7+ Years of experience in the analysis, design, development, implementation and testing of client/server applications. 3+ years of experience on Power BI.
• Designed and developed various visuals by using Power BI and creating data model by applying the required DAX functions.
• Determining connectivity mode for the data source, Import data to edit query builder from web data source in Power BI desktop, perform data cleansing, append queries, execute query by parsing parameter and Invoke custom function.
• Publishing Power BI reports and dashboards in Power BI service and Scheduling Data set to refresh for upcoming data in power BI server.
• Worked on Row level security, Drill thru, with Increase and decrease analysis with building hierarchies in Power - BI.
• Configure and deploy require applications to run thru Azure cloud services, created required Gateways to pull data directly from databases to get refreshed data regularly.
• Designed and developed reports from Data Warehouse using SSRS, Experience in design and implementation of Server and Parallel jobs including Batches and Job Sequencers. Good understanding of OLTP and OLAP.
• Good Knowledge of Data Modeling using Entity-Relationship Model, Dimensional Data Modeling using Star schema and snow flake schema.
• Expertise in extended star schema including Info Cube design, DSO design, Info Objects, Info Sources, Transfer, Update rules/Transformations
• Expertise in Designing/Developing the BO Universes, Ad-hoc/Canned Reports, Complex Reports using conditions using Business Objects, Web Intelligence and Webi reach reports
• Experienced in creating complex reports using Deski, Webi, Web reach and Xcelsius reporting tool with Business Objects functionalities like Filters, Formulas, Ranking, Query Prompts and Drill filters.
• Excellent technical communication skills, Interpersonal skills, versatile team player with proven problem solving skills, collaborate business users to analyze critical data and translate business requirements to technical, scalable specifications.

TECHNICAL SKILLS

OLAP/Reporting tools: Power BI, 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

ETL Tools: 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

Operating Systems: WIN 10,WIN 8, UNIX /Linux

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Power BI Developer

Responsibilities:

• Designing reports using Power BI, creating bookmarks and alerts
• Establish meaningful relationships between tables and create measures
• Designed reports using various visualizations, manage gateway, Publish reports to Power BI cloud services using DAX.
• Generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI
• Created Power -BI reports with proper model making ETL changes at edit query builder and append queries.
• Designing developing and maintaining solutions across the various sources to support the users.
• Understanding the business rules and changing the application for performance and stability and adhering to business rules.
• Design, create and test report using SSRS
• Validate report functionality with internal staff and end users.
• Checked for the integrity and cleansed Customer and Business data using Integrity.
• Experience in handling teams at both onshore and offshore.

Environment: Power BI 2.52, MSBI (SSIS,SSAS,SSRS), SQL Server 2016 /2014 Oracle, Windows 10 / Sever UNIX

Confidential, Detroit, MI

Power BI Developer

Responsibilities:

• Extensively involved in designing the integration part to flow the data form one system to another by interacting with the business users from multiple systems.
• Designed and developed the Power Bi solution for reporting and dashboard creation.
• Performance tuning of stored procedure, SSIS Packages and reports and Wrote complex join queries using T-SQL.
• Created and modified Stored Procedures, Functions, and Indexes.
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes and scheduled.
• Extensively involved in design of Dashboard to display all the customer related information.
• Developing the all the visualizations which are requested by the business users using Power BI.
• Design and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements and published enterprise.
• While design the Power Bi reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.
• Scheduled the data refresh for dashboards and reports to show the live data.
• Experience in handling Transition activities of the new applications from development team to support team

Environment: Power BI 2.41, SSAS, Teradata, SQL Server 2016, Informatica 9.6, Oracle

Confidential, Milwaukee, WI

Developer - BI/BOBJ

Responsibilities:

• Responsible for understanding Business & Technical requirements. Liaise with business users / Business analysts and understand functional specifications and business requirements.
• Creating OLAP Universe, creations of report using BEx Query and BEx analyzer.
• Created several reports like Top 5 Vendors Report, Statement of State wise, month wise, product wise payment particulars report, Dispatch plan to warehouse, Stock Ledger Report, Purchase Register Report
• Managed and monitored data loads with full update and delta mechanism and optimized the performance by adjusting packet size and data selections, Migrations of Database from Non Sap to SAP environment.
• Expertise in BO administration, designing Universes, Webi rich client reports.
• Involved in creation of Universes, Classes, Objects and Hierarchies for multidimensional analysis of database using Business Objects XI 3.1 for technical and sales departments.
• Extensively used Aggregate awareness and Index awareness and assigned securities to the users in their specific domains.
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection.

Environment: XML, Control M, Business Objects XI R2, Oracle 10g.

Confidential, Roselle Park, NJ

Business Objects -Developer

Responsibilities:

• Designed various jobs to extract data from CRM and ELM systems using OCI, ODBC and DRS connections.
• Interacted with Business Users and Managers in gathering business requirements.
• Creating Info cubes, ODS and Multi provider using BW system.
• Prepared Business/Functional Requirements, Design Templates, Developed standards documents, technical design specifications and Detailed Design documents.
• Worked on defining the cardinalities, Joins and implemented shortcut joins, derived tables.
• Defined custom hierarchies in the Universe to enable reporting on any level of the Business hierarchies using the Drill up/Drill down/Drill through/Drill across functionalities of the Web I report.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Created reports using Business Objects functionality’s like prompts, filters, using slice and dice, Drill options, Cross Tabs, Breaks, Sections/Master Detail and variables using complex formulae.
• Migrated Universes and reports from Development/Testing environment to Production Environment.
• Worked extensively on Import Wizard in Promoting the Universes/Reports based on the SDLC Process from Development to Acceptance to PROD landscapes.

Environment: Business Objects 6.5, Oracle 9i