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