Sr Business Intelligence Developer Resume Redmond, WA - Hire IT People

SUMMARY:

To utilize my 10 years of experience in management consulting as well as software development to help enterprises develop cloud - based applications to achieve operational efficiency and maximize profitability.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Sr Business Intelligence Developer

Confidential, Redmond, WA

Responsibilities:

Responsible for maintaining a financial recon system to make sure finance is reporting the right revenue for a system that has millions of records daily
Developed Cosmos SCOPE script as part of the system migration from SQL replica
Supporting Financial Directors to comply with SOX and pass quarterly audit by running adhoc reports requested by the auditors

Environment: Windows, Sql Server, Visual Studio

Skills: Database design, SQL, SSAS, XML job engine (similar to SSIS), C#, SCOPE

Sr Software Development Engineer

Confidential (Contract), Redmond, WA

Responsibilities:

Responsible for fixing worldwide payment issues for commercial part of the commerce platform, for example, Office 365 and Azure
Developed a tool in C# to handle thousands of XML payment files and resolved escalations from COO in timely manner
Continued to use the tool to resolve over 1,000 issues involving 10,000 invoices
Be a team player by working with multiple teams to ensure the payment is being reflected in customers’ invoices

Environment: Windows, Sql Server, Visual Studio

Skills: Database design, SQL, SSAS, XML job engine (similar to SSIS), C#

Lead Technical Consultant

Confidential (Contract), Redmond, WA

Responsibilities:

Became the person-to-go within the team for reporting, greatly minimized the time for worldwide supportability program managers to create their own reports
Proactively bridged new relationship with new teams in order to develop strategic metrics for the management
Scorecards are being presented to General Managers of different organizations

Confidential

Sr. Business Intelligence/Data Warehousing Developer

Responsibilities:

Led development of a large scale DW in 4 months from scratch
Worked in the Microsoft Enterprise Services Reporting team as a lead BI developer to develop a scorecard to track the performance of Microsoft Service Lines with over 70 metrics for COO Kevin Turner and Corp VP of WW Services
Developed a data warehouse with SQL Server 2005 Analysis Services to consolidate over 15 data sources and 70 metrics from across Microsoft internally
Developed a scorecard with PerformancePoint Server to present the metrics in an analytical way
Led ETL developers and testers on the ETL process and fact table design

Confidential

Sr. Database Developer

Responsibilities:

Worked in the BI COE (Center of Excellence) group as a technical analyst and a developer to perform functional analysis, prototyping and production development for a worldwide data mart used by all subsidiaries of Microsoft in the world
Designed a data mart with 1 TB of data involving over $100 billion revenue for Microsoft to better target their customers over the world using SQL Server 2005
Data complexity involved nearly 100 million rows of transaction in over 100 countries worldwide with over 2 million end customers
Designed and implemented over 20 SSIS packages for the ETL process of the MMBC data mart using SQL Server Integrated Services 2005
Led a team of 3 business analysts to perform testing and business analysis against the data mart
Designed OLAP cubes for Partner Channel Reporting to match customers with the right partner against MMBC using SQL Server Analysis Services 2005

Confidential

Sr. Software Developer / Architect

Responsibilities:

Led cross-team communications between Sales, Marketing, Finance, IT to gather business/technical requirements for reporting
Designed a service-oriented application with ASP.NET, ADO.NET C# and XML web service to streamline cross-organizational business communication on Business Investment Funding (BIF)
Created 5 different BIF financial reports for Microsoft senior managements for better management of the $70 million BIF funding using SQL Reporting Services 2000