SUMMARY

• Total 7+ Years of experience in teh 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 teh required DAX functions.
• Determining connectivity mode for teh 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, wif Increase and decrease analysis wif 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 teh 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 wif Business Objects functionalities like Filters, Formulas, Ranking, Query Prompts and Drill filters.
• Excellent technical communication skills, Interpersonal skills, versatile team player wif 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 wif Drop down menu option, sorting teh data, and defining subtotals in Power BI
• Created Power -BI reports wif proper model making ETL changes at edit query builder and append queries.
• Designing developing and maintaining solutions across teh various sources to support teh users.
• Understanding teh business rules and changing teh application for performance and stability and adhering to business rules.
• Design, create and test report using SSRS
• Validate report functionality wif internal staff and end users.
• Checked for teh 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 teh integration part to flow teh data form one system to another by interacting wif teh business users from multiple systems.
• Designed and developed teh 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 teh customer related information.
• Developing teh all teh visualizations which are requested by teh business users using Power BI.
• Design and developed teh Power BI solution to create reports, visualizations and dashboards as per teh business requirements and published enterprise.
• While design teh Power Bi reports and dashboards, teh measures are created using DAX programming language. Writing all teh calculations using DAX formulas.
• Scheduled teh data refresh for dashboards and reports to show teh live data.
• Experience in handling Transition activities of teh 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 wif 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 wif full update and delta mechanism and optimized teh 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 teh users in their specific domains.
• Used @functions to create predefined conditions and prompts to filter teh 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 wif 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 teh cardinalities, Joins and implemented shortcut joins, derived tables.
• Defined custom hierarchies in teh Universe to enable reporting on any level of teh Business hierarchies using teh Drill up/Drill down/Drill through/Drill across functionalities of teh Web I report.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by teh 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 teh Universes/Reports based on teh SDLC Process from Development to Acceptance to PROD landscapes.

Environment: Business Objects 6.5, Oracle 9i