We provide IT Staff Augmentation Services!

Database And Bi Solution Developer Resume

4.00/5 (Submit Your Rating)

Seattle, Wa

Hire Now

SUMMARY:

  • Skilled, motivated and result oriented BI developer with 4 - year experience creating user friendly BI Solutions to meet and exceed client requirements.
  • Expert level of software development life cycle and BI solutions and passion for seeing projects through from requirement gathering to development. solid understanding and hand on experience in enterprise database, data warehouse and report design and development, preventing and solving problems and providing outstanding support and leadership for small and large scale projects.

TECHNICAL SKILLS:

Data Warehouse Tools: MS SQL Server Analysis Services, Data Mining Tools, Integration Services

Business Intelligence Tools: SQL Server 2008/2012 Business Intelligence Development StudioMS Data Tools

Languages: T-SQL, C#, ASP.NET, XML, HTML5, CSS, JavaScript

Reporting Tools: SQL Server 2005/2008/2012 Reporting Services, MS-Excel 2010/2013, Power BI

Development Environment: Visual Studio.Net 2013/12/10/08/05, TFS

Data Modeling Tools: Microsoft Visio 2010/2013

Operating Systems: Windows/ 10/ 8.1/8/7, Vista

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA.

Database and BI Solution developer

Responsibilities:

  • Expertly performed requirement gathering and analysis, analyzed and documented the system specifications, business requirements
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and parametrized Drill-down and summary Reports using SSRS.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and clients with Query Optimization to increase the performance of the Report.
  • Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2012
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Technologies and tools used: MS SQL Server 2012,2014 and 2016 SQL Server Integration Services 2012, SQL Server Reporting Services 2012 Visual Studio 2012/13, TFS 2012/13, C#

Confidential

  • Played key role in preparing user requirement gathering, developing design documents and creating Database, Data warehouse and Business intelligence solutions to meet customer needs.
  • Followed full Agile Scrum SDLC and testing methodologies. Developed logical and physical data models, design data access and manipulate data stored in databases.
  • Created SSIS package configurations, SQL Server Agent jobs and job schedules and Imported data from multiple data sources such as OLTP, flat files, and created data flow solutions to cleanse and validate imported data. Inserted and/or updated newly cleansed and validated data into OLTP or OLAP databases.
  • Involved in design and development of Multidimensional and Tabular cubes, hierarchies, aggregations, KPIs, and roles in SSAS.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship