SUMMARY:

• Microsoft - certified Power BI developer with 7+ years’ experience working with enterprise level systems in large corporations and global teams.
• Experienced in full BI lifecycle from requirements elicitation to production deployment, user, and post go-live support.
• Lead requirements discussions with IT and business teams with the goal of delivering products dat meet expectations.
• Experience in designing dimensional models (star and snowflake schemas).
• Develop, test, and deploy enterprise BI solutions in Microsoft BI, MicroStrategy and SAP Crystal Reports - 7 years.
• Create and maintain BI/DW ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows) - 5 years.
• Working with RDBMS and developing complex SQL queries - 5 years.
• Plan, estimate, prioritize and define business and functional requirements - 5 years.
• Develop and execute automation test scripts in a structured environment in HP UFT - 2 years.

TECHNICAL SKILLS:

BI/DW: Power BI Desktop, Power BI Service, MicroStrategy Developer, SQL Server Management Studio.

Database: SQL, PL/SQL, Transact-SQL (T-SQL), VBA.

Data Analysis Languages: Power Query, M, DAX formula language, MDX.

Administration: Microsoft Power BI administration, O365, Azure.

Source Control/Project Management: JIRA, Team Foundation Server, SharePoint, Git, HP ALM.

PROFESSIONAL EXPERIENCE:

Confidential

Application Developer

Responsibilities:

• Successfully led a HR reporting initiative as architect, analyst, and developer in a new BI tool for the company (Power BI).
• Defined operating and deployment model for Power BI.
• Designed a star-schema like data model to support key HR processes and metrics.
• Profiled flat file sources and cleaned, transformed, shaped in Power Query.
• Flattened employee-manager hierarchy all the way up to the CEO.
• Implemented dynamic row-level security based on the organizational hierarchy.
• Developed highly interactive people metric dashboards for executive leadership team.
• Designed and developed dashboards and reports to track and monitor EDW data quality.
• Reconcile key EDW metrics versus operational data sources and build visuals to track discrepancies between source and target systems.
• Designed a high-level snapshot page containing key metrics and their reconciliation statuses.
• Onboarded new external and internal datasets into the EDW using Kimball dimensional modelling techniques.
• Created subscription-based grid reports for Claims and Broker Management teams.
• Researched and found a solution to a longstanding issue with date selectors in MicroStrategy dossiers dat helped eliminate a monthly manual process.

Environment: Power BI, MicroStrategy, Oracle 12c, PL/SQL Developer, Microsoft SharePoint, JIRA.

Confidential

BI Developer

Responsibilities:

• Automated cleansing and consolidation of data from multiple sources, saving more TEMPthan 80 hours of manual work weekly.
• Created reports, dashboards and visualizations for financial research analysts and business consultants.
• Extracted data to automate KPI reporting and dashboards with insights shared to key decision makers.
• Transformed data into consumable formats like pivot tables, pivot charts, etc., to answer business questions.
• Created and administered App Workspaces to control access to dashboards.

Environment: Power BI Desktop, Power BI Service, SQL Server, Analysis Services, Office 365.

Business System Analyst

Confidential

Responsibilities:

• Partnered with the business including business analysts to create, review, or implement business requirements.
• Planned, estimated and executed development, QA and deployment effort of 25 critical BI reports - delivering within budgeted timelines.
• Created and handed off 30 Functional Design documents to the production support team by way of noledge transition meetings.
• Trained and guided offshore BI resources to develop reports by adjusting schedule to overlap time zones.
• Facilitated discussion between IT and business to translate requirements to technical specifications.
• Performed unit testing and conducted user acceptance testing working alongside business partners.

Environment: Oracle 11g, SAP BusinessObjects, Crystal Reports for Enterprise, Microsoft SharePoint.

Confidential

IT Development Associate

Responsibilities:

• Developed 120 BI reports in SAP Crystal Reports in Cargill’s reporting environment, working with major time constraints due to Actuate end-of-life.
• Wrote complex SQL to retrieve objects (fields) in SAP BusinessObjects/Crystal designer tool.
• Performed unit testing and coordinated UAT, reporting status and outcomes to project manager.
• Deployed, scheduled, and monitored reports on the BusinessObjects server.
• Implemented a dashboard in Excel to track status of all 120+ reports under development in real time.
• Authored user guide and other docs to train and assist users with transitioning to Crystal Reports.

Environment: Oracle 11g, SAP BusinessObjects, PL/SQL Developer, Crystal Reports for Enterprise.

Confidential

Software Developer

Responsibilities:

• Developed SSIS packages to integrate data from various sources into EDW.
• Developed and published analytical reports and data visualizations in SQL Server Reporting Services.
• Created reports with drill-down, drill-through, interactive sorting, multi-value parameters, various calculations and joins using tabular sets and models.
• Developed source-to-target mappings to meet business application requirements.
• Identified data discrepancies and data quality issues and worked to ensure data consistency and integrity.
• Implemented SSAS tabular and multidimensional models to deliver self-service BI capabilities.

Environment: SQL Server 2012, SQL Server Integration Services, SSMS, SSAS, SSRS, TFS.

Confidential

Test Engineer

Responsibilities:

• Developed automation test suites as part of the End-to-End Test Phase of GuideWire ClaimCenter® implementation, a critical milestone for the client.
• Created detailed, comprehensive and structured test plans and test cases to ensure timely deliverables.
• Estimated, prioritized, planned, and coordinated testing activities within a 6-member team.
• Designed and developed automated test sets in HP UFT using function libraries and database verification.

Environment: Oracle 10g, HP QuickTest Professional 11, HP UFT, HP ALM, Quality Center.

Confidential

Assistant Quality Manager

Responsibilities:

• Developed test plans and test case specs after reviewing functional and design spec documents.
• Provided subject-matter expertise in Clinical Documentation across the Software Testing Life Cycle - Requirement Analysis from end-user perspective.
• Identified and defined User Roles participating in business process/applications.
• Assisted QA Manager in management of a team comprising software testers and business analysts.

Environment: HP QuickTest Professional 10, HP Quality Center, Microsoft Excel 2007.