Senior BI Developer Resume

SUMMARY

8 + years of experience in analysis, design & development of client/server, web based & n - tier application.
Highly adaptive and determined worker who enjoys taking on a challenge and learning new technologies.
StrongSQLDevelopment skills including Stored Procedures, Indexing, Functions, Triggers, DistributedandAd-Hoc Queries.
Proficiency and expertise inSQL ServerReplication,Backup/Recovery,Disaster recoveryandplanning.
Designed and developed a full-scale reporting solution usingMS SQL Server,SSRS, SSAS.
Expertise in Database Administration with performance tuning, maintenance and troubleshooting capabilities.
Solid experience in the development of integration solutions withSSIS.
Solid experience in the development of integration solutions withSSAS (tabular,OLAP)
Developed applications web and windows application using C# (Asp.net, MVC)inBack-EndandFront-End.
Worked with Elasticsearch
Worked withWeb APIto provide services to HTTP requests.
Expert and creative in designing and developing ERP, CRM, dashboard applications, with analytical and business reports.
Expert in debugging an application using the debugging tools provided by the Visual Studio.Net.

PROFESSIONAL EXPERIENCE

Senior BI Developer

Confidential

Responsibilities:

Developed some web applications and monitoring databases for better performance.
Develop, test, and ensure quality including Performance & Security of Store Procedures and Functions in SQL Server.
Database programming, Stored Procedures and complex queries
Implementing a solution for store data in databases with Security.
Setup and Administrating of multipleSQLServer Transactional Replication.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Upgrading and migration from MS SQL Server 2012 to MS SQL Server 2014.
Analyzing data in SQL Server to check the velocity, security, performance issues.
Create SSIS Packages to extract data from different external sources like SFTP, FTP,other databases.
Preparing technical documents like technical requirements and deployment instructions.
Train, assist and transfer knowledge to new employees to understand business logic or solve the technical issues. Skills: MS SQL Server, ASP.NET, MVC, WEB API, SSIS, HTML5, CSS3, JavaScript, JQuery.
Use SSAS to provide high volume of data to client
Use Elastic Search to have better performance for searching
Use SSRS and SSIS.
Use Tabular, multidimensional cube and powerbi

Sql Developer

Confidential

Responsibilities:

Develop and design BI solutions with MS SQL Server 2008/2012
Using best practices of database development to produce high-performance, maintainable systems for a cloud-based multi-tenant platform.
Develop and maintain web service with C# and SDK for ETL processing, based on custom xml data to populate data and create
Develop/maintain ETL code using SQL and/or SSIS, mindful of performance and multi-tenancy.
Prepare and present technical specifications and design documentation. •
Participate actively in regular stand-up and other meetings as part of the Business Intelligence Scrum team. Skills: C#, Web API, MS SQL Server, SSIS,, HTML, JavaScript Enterprise Architect.
Developed Web Services for userauthentication and file transfer
Used X path, Xml Node to accessfiles and XML Data Document to synchronize withDatasets.
Compared the XML files sent by the Toll Authorities with XML Schemas.
Ensured Security to all the portals by creating Tampered proofed URLs.
Extensively used Grid Views sorting and paging, Implemented Template Columns for Custom Nested Grid Views
Worked on exporting reports to Excel from Grid views and Ultra web grids.
Deployment of Application on Test and Production Server, handled many production issues and enhancement to the existing live portals
Sql Developer: Acctec, Tehran, Iran
Workflow Engine for purchase and sales module, Implements By C#, windows service, SQL server, with multi-layer Architecture
Created Custom CRM System for making relationship between Customers and Vendor for tracking the Orders and Support the Sales.
Convert Database from, and improve Performance and working with data ware house
Developing Sage Accpac Erp.
Intelligent Reporting tools
Used SSRS and SSIS.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship