We provide IT Staff Augmentation Services!

Senior Programmer And Business Analyst, Power Bi Developer Resume

5.00/5 (Submit Your Rating)

Kalamazoo, MI

SUMMARY:

  • Accomplished Software Engineer & Power BI Developer
  • Expertise in Power BI Development | Proficient in Design/Code/Test/Debug | Applying Best Practices & Standards
  • I wanted to take this opportunity to thank you for your assistance to the IBP Team on our CTO Project.
  • Your quick turnaround and re - running the programs for the multiple iterations needed by the team, even during evening hours, were critical to ensuring we kept our tight project schedule. Experienced Software Engineer Driven leader actively pursuing an executive opportunity in software development where strategic vision, technical proficiency, and expertise in software development, business intelligence and analytics, and team-based collaborative project execution will be held at a premium.
  • Technology-Focused Innovator with extensive experience designing and building Power-BI solutions that meet the needs of Confidential 500 corporations; at Confidential, excels in a series of engagements with Confidential Corporation, building dashboards and reports aligned with the needs of the client.
  • Well Versed in Designing, Coding, Testing and Debugging with expertise applying standards/best practices to meet all client and company goals; skilled in coordinating the completion and delivery of multiple concurrent projects in a challenging, time-critical environment.

LEADERSHIP AND TECHNICAL EXPERTISE:

  • Software Development for Confidential 500 Corporation
  • Designing/Implementing Complex Projects
  • Improving Processes and Code Integrity
  • Success in Team Based Environments
  • Expertise in Requirements Gathering
  • Expert in Design, Code, Test, and Debug Phases
  • Skilled in Microsoft Power-BI
  • Effective Project and Program Management
  • Engaging with Confidential 500 Clients
  • Achieving Success Under Strict Deadlines
  • Leading Database and Report Design
  • Implementing Standards & Best Practices

TECHNICAL PROFICIENCIES:

Programming Languages: T-SQL, DB2, C#, ASP .Net, JAVA, C, C++, Unix, XML

RDBMS: MS SQL Server 2005/2008R2, Oracle 10g/9i/8, MS-Access 2005, DB2, AS/400

SQL Server Tools: SSIS, SSRS, SSAS, SSMS, SharePoint Server

Other Tools: Performance Point Server (PPS 2007/2010), Power-BI, Tableau

PROFESSIONAL HISTORY:

Confidential, Kalamazoo, MI

Senior Programmer and Business Analyst, Power BI Developer

Responsibilities:

  • Fulfills a critical role serving as a trusted advisor and subject matter expert in Power BI, a suite of business analytics tools developed by Microsoft, leading the creation of a Proof of Concept model featuring dashboards and reports.
  • Navigates the project through all phases, including requirements gathering, design, development, and testing.
  • Led the team in the development of a Business Requirements Document (BRD), User Requirement Specifications (URS), Technical Design Specification (TDS) and Functional Specification Document (FSD).
  • Served as an invaluable resource for the identification and prioritization of issues, root cause analysis, and expedited resolution to ensure the highest levels of client service and support; administers the Change Request process.
  • Provided reports tailored to the needs and perspective of individual users, implementing row-level security that grants access and filters data based on user-level factors.
  • Coordinated the User Acceptance Testing, Integration Testing, and Regression Testing, reviewing all test cases and test scenarios for accuracy and completeness.

Senior Programmer and Business Analyst

Confidential

Responsibilities:

  • Leveraged expertise in Microsoft Excel to build customized reports tailored to the unique needs of Confidential Corporation stakeholders.
  • Maintained accountability for the production and revision of the Business Requirements Document (BRD), User Requirement Specifications (URS), Technical Design Specification (TDS) and Functional Specification Document (FSD) while managing and resolving all issues and change requests.
  • Established a Traceability Matrix and collaborated with the Quality Assurance team to ensure the execution of all functional testing responsibilities.
  • Authored test scripts, and reviewed test cases and test scenarios in the course of orchestrating User Acceptance, Integration, and Regression Testing.

Report Developer and BI Developer

Confidential

Responsibilities:

  • Worked with business analysts and other Confidential stakeholders to define, build and execute projects to enhance reporting functions, leveraging expertise in ETL packages to mine data from multiple sources, including SQL Server, Flat Files, Excel spreadsheets, and XML files.
  • Satisfied reporting needs through the development of dashboards, scorecards, and key performance indicators.
  • Applied skills in SQL Server Integration Services (SSIS) to transform and load data into destination tables; developed SQL Objects that included complex stored procedures, triggers, functions, views, and tables.
  • Credited with building an SSAS cube, including measures, dimensions, calculations, and partitions using DB2 Named Sets, as well as various Cube actions to enable drill-down reports in Microsoft Excel.
  • Developed reports serving the needs of multiple internal business users enabled in iSeries/AS400, DB2, and XML; wrote requirements documents for all reports created in XML using DB2.
  • Met month-end financial reporting needs through the development of static reports using SSAS cube formulas in Microsoft Excel complete with graphs and trends.

Microsoft SQL Server BI Developer

Confidential

Responsibilities:

  • Involved in the development of Microsoft SQL Server Business Intelligence project that pulled data from multiple sources, transformed with SSIS, and loaded into SQL Server destination tables.
  • Enhanced the performance of stored procedures and long-running queries through the analysis of query plans, I/O statistics, joining techniques, and indexes.
  • Engaged with multiple user groups within the client organization to identify business needs and build enterprise reports in SSRS 2008 R2; additionally, optimized the program metrics report, statistical reports, and demographic reports.
  • Contributed to enhanced report security by creating roles in SSAS Cube and building groups in Microsoft SharePoint Server that defined users with authorized access to reports and dashboards.
  • Engaged with clients during all phases of project implementation, including ETL, Reporting, Production Support, Enhancements, and troubleshooting.

Confidential

Java/SQL Intern

Responsibilities:

  • Met the needs of multiple clients of this IT consulting firm while gaining invaluable expertise in Java and SQL.
  • Involved in the design of databases, including the development of table relationships, stored procedures and triggers that validated data entered into the system.
  • Wrote SQL scripts to automate the insertion, update, and deletion of data in Microsoft SQL database tables.
  • Developed web pages using a combination of HTML, CSS, JSP, and JavaScript programming.

We'd love your feedback!