Developer Consultant - Data Practice Resume Redmond, WA - Hire IT People

SUMMARY:

Aspiring to provide critical business insights through data and analytics propelling the employers vision into the future as a Business Intelligence Developer/Analyst.

TECHNICAL SKILLS:

T - SQL, PL/SQL, DAX
SQL Server Management Studio, SSIS, SSAS, SSRS, TFS, Excel, Power BI, Microsoft Visual Studio, Microsoft SharePoint, Toad, SQL Developer
Microsoft SQL Server 2016,2014, 2012, 2008 R2, 2008, MS SQL Azure, MS Access, Oracle 9i, 10g

PROFESSIONAL EXPERIENCES:

Developer Consultant - Data Practice

Confidential, Redmond, WA

Responsibilities:

Requirement analysis, Active feedback collection and recursive improvement and maintenance ( SSAS cube design, Azure/on-prem SQL objects to support Power BI )
Collaborated with management teams to deliver assigned programs - Developed group and individual timelines, assessed/identified potential bottlenecks process.
Established goals and milestones as per the desired results to be generated by the project.
Assisted the engineers in documenting the project designs and making changes as per needs.
Worked on Data Warehouse with Tabular Data Model to accomplish efficient reporting, Agile turnarounds and ease of maintenance.
Sophisticated reporting using Power BI for high productivity.

Developer Consultant - SQL BI Dev

Confidential, Redmond, WA

Responsibilities:

System Requirements and Technical design with complete SDLC involvement.
Data Load using ETL from OData Feed and OLTP SQL Servers .
Create Data Warehouse using Tabular Data Model.
Tuned Stored procedures accordingly increasing throughput by 50%.
Efficient reporting using Power BI to observe categorized growth statistics increasing client operations efficiency by 100% based on client feedback .
Automated onboarding process saving 60% time and documented it for future reference.
Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS .
Maintained Elite Database, SSIS Packages and resolved the issues raised by the end client.
Created ad hoc reports using Excel/SSRS tools to help clients with their business.
Designed HTML email pages for delivering the SSRS reports to the client.
Worked on designing/customizing the bugs reporting template in the Visual Studio to help the project follow the team standard

Software Developer Engineer

Confidential, Issaquah, WA

Responsibilities:

Prepare test case documents for test executions covering all the scenarios.
Carried out scenario based testing, Regression testing both White box and black box testing.
Performed Bug fixing and resolved the complex issues by collaborating with the field users and clients.
Provided customer support for various issues raised by the end users.

Business System Analyst

Confidential, Kirkland, WA

Responsibilities:

Requirement Analysis and preparing the Technical specification and Design Docs.
Created a Data Mart to streamline their existing report system to manage the inventory.
Collaborated with various teams to identify the data sources and Implemented the ETL 's to load data using SSIS packages that served as a source for reporting .
Delivered Excel based reports to clients on ad hoc basis.

Senior Programmer

Confidential

Environment: HP PPM 6.0 - 7.2, Toad, SMS Dev/Prod instances, ITSM Remedy, VMware

Responsibilities:

Involved in developing and configuration of Workflows, Request Type and Portlets(Bar & Pie charts).
Preparing deliverables for the release ( Design Docs, Unit Test Cases, Deployment Checklist, Configuration Guide, Release Notes and Training Materials).
Develop and maintaining the custom PL/SQL queries, functions and stored procedures.
Unit, Integration & Functional Testing .

We provide IT Staff Augmentation Services!

Developer Consultant - Data Practice Resume

Redmond, WA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship