We provide IT Staff Augmentation Services!

Business Intelligence Consultant Resume

Bellevue, WA

SUMMARY:

  • 12+ years of experience in Business Intelligence / Data Engineering / Data Analytics/ Data Science.
  • 8 years of experience in VB.net, C#, ASP .net Application Development; Currently working in T - Mobile as a consultant.
  • Handled responsibility of building and leading teams, project planning, reviewing requirements documents, preparation of SRS, database modeling, review of coding, implementation and maintenance of the projects in various Industry verticals like retail, finance, manufacturing, etc. and compliance to best practices & standards.
  • Strong working knowledge of operationalizing enterprise data pipelines to support BI Analytics and Data Science using Azure tools such as Azure Data Lake Storage (ADLS), Azure SQL Database, Azure SQL DW, Azure BLOB Storage, Azure Data Factory (ADF), Logic Apps.
  • Experience in Business Intelligence (BI) Tools like DTS for ETL service, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS - Tabular Model) using DAX.
  • Expertise in Power BI, Power Query, PowerApp visualizations and dashboards using various data sources. Alert handling using Power Automate.
  • Use Excel to quickly perform ad hoc analysis and reporting using advanced functions, power pivot tables and charts that illustrate insights in a clear and concise manner.
  • Well conversant with full SDLC and Waterfall and Agile methodology. Deep understanding and experience with OOPS, OOA, MVC patterns using C#, .NET, Web API, ADO.NET, Dataset, Data Reader, Data Adapter.
  • Development experience in Cosmos-Scope Scripting (Microsoft Big Data).
  • Analyze Splunk log to troubleshoot various ongoing production issues.

TECHNICAL SKILLS:

Database Systems: SQL Server, DTS, SSIS, SSRS, SSAS, Power BI, PowerApps, Azure Data Factory, Azure Data Lake.

Source Control: VSS, SD, VSTF, Bitbucket, GitHub

Languages: C#, VB.net, SQL, DAX, Power Query, Scope, Kusto, U-SQL, PowerShell

Web & GUI Development: HTML, XML, XSL, JavaScript, VBScript, ASP, .NET

Middleware: .NET Web Service, WCF, WEB API

DevOps: Splunk, NewRelic

Methodologies: Object Oriented (UML), Structured

Project Management: MS Project

EMPLOYMENT:

Business Intelligence Consultant

Confidential, Bellevue, WA

Responsibilities:

  • Define and track usage and KPIs, business success metrics for initiatives
  • Expert on qualitative and quantitative analysis of app/user behavior.
  • Define and analyze the signals that inform the success of features and Confidential programs, and where the product/program strongly resonates with customers and developers
  • Champion features needed to improve efficiency of customer deployments with internal and external partners to gather feedback and manage dependencies
  • Take complex problems and the associated data and craft answers in a concise form. Regularly present insights, status, recommendations and more to assist LT in making key business decisions.

Technologies: C#, SQL Server, SSIS, ADF, Azure DW, Power BI, Power Query, DAX, ADLs, Power Pivot, Cosmos, Scope, Kusto

DevOps Analytics Lead

Confidential, Seattle, WA

Responsibilities:

  • Extensively analysis on SQL data to find fraud activity.
  • Analyze Splunk log to troubleshoot various ongoing production issues.
  • Working enhanced feature releases and bug fixing for various applications using .net technology.
  • Designed and developed various SQL objects including stored procedures, SSIS Package, SSRS reports in SQL Server.

Technologies: ASP.Net, C#, SQL Server 2014, SSIS, SSRS, WCF, MSMQ, MVC, Splunk, Power Pivot, NewRelic

Data Analytics Consultant

Confidential, Redmond, WA

Responsibilities:

  • Development of COSMOS-SCOPE scripts to process tera-bytes of telemetry data to finding patterns.
  • Building Tabular Cubes and designing Power BI Dashboard Reports
  • Design ETL (SSIS, Stored Procedures and other data processing applications using PowerShell, C#, etc.) with best practice recommendations.
  • Development of SCOPE scripts to collect data from COSMOS and processing into SQL database.
  • Review technical documentation and design documents and code review

Technologies: SQL Server, SSIS, SSAS, Windows PowerShell, C#, .Net 4.0, Power BI, Power Query, Power Pivot, Cosmos, Scope

DevOps Analytics Consultant

Confidential, Seattle, WA

Responsibilities:

  • Working enhanced feature releases and bug fixing for various applications.
  • Extensively working on SQL data to find fraud activity.
  • Designed and developed various ASP.NET pages for the browser-based part of the application.
  • Developed generic code components using VB.net. Data Access, data manipulation by using ADO.NET in Database Access component.
  • Designed and developed various SQL objects including stored procedures, SSIS Package, SSRS reports in SQL Server.

Technologies: .Net Framework 3.5, ASP.Net, C#, VB.net, SQL Server 2008, Power Pivot. SSIS, SSRS, WCF, MSMQ, MVC, Splunk

Data Engineering Consultant

Confidential, Redmond, WA

Responsibilities:

  • Developed Scope scripts to collect data from Cosmos and processing into SQL database; Worked on Cosmos-Scope Scripting using Search Merged Log (SLAPI), MSN Logs, Atlas Logs, Toolbar Logs, IE Logs.
  • Development and maintenance of MSN and Bing Search Engine’s AnidPanel, Search Engine Transition Framework, Customer Intelligence platform and Keyword Intelligence. Analyze toolbar data with different search engine’s DSQ overtime.
  • Maintain the extraction in SQL Server and generate various ad-hoc reports for data analysis.
  • Multiple analytical studies of customer base in Search, MSN & ACML, using Cosmos logs.
  • Responsible for contributing to the design and coding of applications for the Outbound Royalties work stream. A high level of code quality and performance is required given the high transaction volumes Berlin systems will receive once in production. This role is responsible for working effectively with a large, diverse customer-led project team using the agile development methodology. Able to innovate and contribute given often loosely defined requirements - and to help the customers drive those requirements when needed. Delivery of components for ETL, data validation and error handling using the client’s preferred technologies and framework.
  • Creating the different agents for different sources including ISS, NIDS, ACS, SER, eTrust, FSS, and Proxy/Firewall to run at Sentinel server to process the events and analyze and store them in the database to resolve and prevent future threats. The agents are being written in JavaScript using Eclipse tools and sentinel 6.1 SDK.
  • Coding Data Access, Business Logic using C# for synchronizing the data between Sentinel and CRM Dynamics.
  • Designing the database for CR Reporting.
  • Involved in Functional and Technical documentation.

Technologies: .Net Framework 3.5, ASP.Net, C#, SQL Server 2008, Sentinel 6.1, Eclipse, Aptana Studio, JavaScript, Rule-LG, XML, Alliant, Cosmos, Scope

.Net Consultant

Confidential, Seattle, WA

Responsibilities:

  • Designed and developed various forms of the windows application.
  • Developed generic code components using VB.NET. Data Access, Data Manipulation using ADO.NET in Database Access component.
  • Developed stored procedures in SQL Server.
  • Setup and managed VSS for configuration management.

Technologies: .Net Framework 3.5, VB. NET, ADO.NET, SQL Server 2005, VSS.

.Net Consultant

Confidential, Redmond, WA

Responsibilities:

  • Sustain Engineering responsibilities include analysis and design for the CRs for different applications, coding with existing code compatibility, perform Impact analysis, unit testing, and sign off the dev builds for UAT.
  • Assumed Test Plan Management responsibilities for the Fort Knox project. Provided the test plan and scheduling test strategy for the project. Developed the test case categories and managed a test team.
  • Participated as a team member in the quality test team of BizTalk 2006 Adapters with runtime testing for Siebel, PeopleSoft, JDE Enterprise one and TIBCO EMS.
  • Developed test driver for the runtime test automation and utility tools for working with XML documents using C# for test automation.
  • Participated in white box testing for several adapters and responsible for running Code coverage i.e. Magellan test for adapters.
  • Designed and developed various ASP.NET pages for the browser-based part of the application.
  • Developed generic code components using C#. Data Access, Data Manipulation by using ADO.NET in Database Access component. Developed stored procedures in SQL Server2k.
  • Developed Periscope search for GotDotNet User Samples including full text search, filter search and quick search.
  • Modified existing code base to create dynamic index custom metadata to be embedded in User Samples in GotDotNet web site, is particularly important to .NET 2.0 online help to include content in an index crawled by Microsoft SharePoint Portal Server.
  • Involved in Functional and Technical documentation.

Technologies: .Net Framework 2.0, BizTalk Server 2004/2006, ASP.Net, C#, SQL Server 2000/2005, ETCM 2.0, SD, Product Studio

.Net Consultant

Confidential, Smyrna, TN

Responsibilities:

  • Designed and developed various ASP.NET pages for the browser-based part of the application.
  • Developed generic code components using C#. Data Access, Data Manipulation by using ADO.NET in Database Access component.
  • Used Java script and validation controls to do the client-side validations.
  • Developed stored procedures in SQL Server2k.
  • Setup and managed VSS for configuration management.

Technologies: .Net Framework 1.1, ASP.Net, C#, ADO.Net, JavaScript, HTML, DHTML, CSS, SQL Server 2000, VSS.

Application Developer

Confidential

Responsibilities:

  • Played as a Team Lead and technology instructor for InfoPath team for project IAP.
  • Developed an understanding of the architecture, efforts-to-date, specifications, issues, and problems of the intranet based IAP and PBP applications.
  • Led the completion of technical design, development, and deployment of the pilot deliverable.
  • Managed the development effort, provided hands-on coding in technologies the team lacked competency, provided problem resolution and root cause analysis.
  • Ensured that the integrated, complex technology was working properly and was stable. Led the next steps design effort, provided documentation and knowledge transfer.
  • Directed the effort of six resources and set up development and production infrastructure environments.
  • Have good contribution towards OEM, a complex project related to Microsoft revenues delivered in time.

Technologies: .Net Framework 1.1, ASP.Net, C#, ADO.Net, Visio 2000, UML, JavaScript, HTML, DHTML, CSS, InfoPath 2003, XML web services, SOAP, WSDL, SQL Server 2000, Siebel, Source Depot, Product Studio.

Hire Now