We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume Profile

2.00/5 (Submit Your Rating)

Aliso Viejo, CA

Summary:

  • Programming Languages: SQL, T - SQL, C, Visual Basic 6, Java, VB.NET
  • Databases: SQL 2000/2005/2008/2012/2014, OLTP, OLAP, Data Warehouse, Business Intelligence
  • Database Modeling and Design: UML, OMT
  • VBA, T-SQL, Stored Procedures, SSRS, SSIS, BI Developer
  • Web Development: HTML, DHTML, CSS, JSP, JavaScript, VBScript, classic ASP, ASP.NET
  • Knowledge of Web Services, XML, XSLT, LINQ, MVC 4 and AJAX
  • SharePoint development and administration

WORK AND PROJECT EXPERIENCE

Business Intelligence Developer

Confidential

  • Database modeling and design, SSRS marketing/executive reports
  • Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Skills: MS SQL Server 2005/2008, MS SQL Server Reporting Services, Team Foundation Server TFS, T-SQL, Visual Studio 2008/2010/2012, C, Web Forms, MVC4

SQL /.NET Developer contractor

  • SQL/.NET development quarterly board reports for 35 funds, fund management application
  • T-SQL stored procedures, functions, views and triggers
  • Transferring the data ETL to SQL server by SSIS
  • Performed business analysis, technical analysis, systems design, application software programming
  • Rebuilt the indexes at regular intervals for better performance
  • Monitored and modified Performance using execution plans and Index tuning
  • Monitored SQL server performance using SQL Profiler to find performance and dead lock

Senior Software Engineer

  • Managed web application projects
  • Developed/maintained databases
  • Online stores marketing/data analysis/SSRS
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer

SQL/.NET Web Developer

  • SQL/.NET developer using .NET 2.0 and SQL 2005
  • Projects: Medical claim forms web application, I/O files standardization, database design and analysis, Windows Services and Web services
  • Laboratory requests and results processing standard HL7 file parsing and transformation
  • Full practice SDLC: analysis, design, coding, testing and maintenance
  • Restructuring the stored procedure, designing, coding and developing the same using the T-SQL Programming

SQL/.NET Developer

SQL/.NET Developer

  • Web application development: Developed a medical bill review system which enables adjustors to review bills and make decisions to pay, adjust or deny the bills, using JSP, JavaScript, CSS, DHTML, J2EE, Tomcat, and MySQL
  • Development tools: classic ASP, VB6, SQL 2000, Visual Source Safe, Microsoft Visual Studio
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
  • Contributed to the development, maintenance, and enhancement of CRM marketing lead administration system
  • Used ASP.NET2.0 with C or VB.NET and SQL 2005
  • Deployed projects: case management, employee directory search, store location list, form request download, event scheduling and calendar portal on home page
  • Set up SQL Server configuration settings for better server management
  • Provided effort estimates and prioritized tasks
  • Maintained the existing applications classic ASP and ASP.NET
  • Analyzed business requirements, designed database tables, wrote stored procedures, analyzed user interfaces, coding, testing use cases, and deployment for new projects
  • Documentation: Developed a users' menu and FAQ menu for using the web application, in HTML and PDF forms, using Apache Forrest
  • Other projects: VB6 and Java

Web Developer Participated on the technical team responsible for module implementations, upgrades, development, maintenance and production support Visual Basic Windows application development

  • Web application development: Worked on an inventory system project and a shipment tracking system project for a logistics company
  • Database design and modeling: Created tables, database normalization and ER diagrams

IT Director

  • Developed internet banking projects conducted interface design and business requirements definition
  • Managed troubleshooting and user support for software and hardware
  • Maintained banking system and updated patches
  • Trained users to use banking systems Fidelity System, formerly Alltell System
  • Conducted internet security and IT policy
  • Evaluated new IT projects and necessity for purchasing new software/hardware

Web Programmer

  • Designed, architected, developed and implemented a B2B online ordering application which allows users to proceed with or reject orders based on business requirements
  • Web technologies: classic ASP
  • Database: Oracle 8i
  • Platform: Windows 2000

Programmer/Analyst

  • Provided web interface design and web application development
  • Updated and created the company's internet/intranet web pages
  • Created database for clients and web interface to access the data

We'd love your feedback!