Business Intelligence/database Developer Resume
Irvine, CA
SUMMARY:
To gain full - time employment as an SSRS Report/ Database Developer
TECHNICAL SKILLS:
Skills: PHP/My SQL, ASP.NET, C#.NET, VB6 and VBScript development, CGI, PERL, SQL, XML, SOAP, HTML, Drupal, Flash, Dreamweaver, Visual Interdev,C, Java, Javascript, Database Management, Networking, TCP/IP, MS SQL 6.5/7.0/2K,2005,2008, Linux, LAMP, Windows NT, 2000, XP, IIS5/6.
EXPERIENCE:
Confidential, Irvine, CA
Business Intelligence/Database Developer
Responsibilities:
- DTS conversion into SSIS Packages.
- Extensive SSRS development.
- Extensive T-SQL development including stored procedures and user defined functions.
- SSAS development.
- Develop new reports per customer specifications
- Create and modify existing stored procedures and UDFs for Confidential ’s OLTP and OLAP databases.
- Modify and update existing SSRS and Crystal reports.
- Convert Crystal Reports to SSRS reports.
- Debug and correct problems and errors in existing SSRS and Crystal Reports in a production environment.
- Some C# and VB.NET development.
Confidential, San Diego, CA
SSIS/SSRS/Crystal Developer
Responsibilities:
- Database development and optimization
- SSIS Package development.
- SSRS reports development.
- Convert Crystal Reports to SSRS/RDLC
- Extensive MS-SQL stored procedure, UDF, T-SQL development
- Integrate reports into .NET Framework 4.0 solution
- Modify .NET solution for Windows 7, MSSQL 2008 R2
- VB .NET development
- Create/modify MSSQL Stored Procedures and Functions
Confidential, Vista, CA
DBA/ SSRS/SSIS Developer/ Report Architect MS-SQL PHP/ MySQL Developer
Responsibilities:
- Developed an OLAP data warehouse for sales forecasting, order tracking and shipping.
- Create DTS and SSIS packages to transform data to the data warehouse.
- Developed SSAS Dimensions and Cubes for data analysis.
- Optimize databases for performance utilizing the Database Engine Tuning Advisor, SQL Server Profiler, Execution Plans and other tools.
- Maintain database referential integrity for peak performance and minimized data footprint.
- SSRS report development
- MS-SQL 2008 R2- T-SQL development
- Extensive development of SQL scripts, stored procedures and UDFs and views.
- Microsoft Dynamics back end integration into reporting service.
- Developed shipping / labeling software that integrates into Microsoft Dynamics.
- Manage I.T. Staff - Oversee day to day technical issues on site.
- Plan I.T. infrastructure upgrade for failover and recovery.
Confidential, Lisle, IL
Responsibilities:
- Design and construct a OLTP MySQL database for a prototype application to be used for client demonstrations. Design and code a middle tier utilizing PHP to link the data layer to the presentation layer.
- Implement AJAX functionality within the prototype application for seamless user interactivity. Client side JavaScript coding and CSS creation.
- Consult with Confidential ’ CTO to decide the best methodologies for business logic coding.
- Assist creative consultants on overall look of prototype application. Hands-on graphic design using PhotoShop.
Confidential, San Diego, CA
Senior .NET Developer
Responsibilities:
- Develop Internet and Intranet based applications using Microsoft .NET technologies as per business requirements and functional specification documents.
- Analyzing, maintaining and developing Software Systems—including new and existing custom-database and Internet-related systems—used to support business goals.
- Performing project and task estimation.
- Performing Coding/Programming tasks to specification and in accordance with Development standards. Technology includes VB.NET, C#, ASP.NET, AJAX, JavaScript, ADO.NET and SQL Stored Procedures.
- Researching and resolving Coding issues.
- Participating in the design and development of databases and websites.
- Assisting in developing and running queries.
- Providing estimates for completion times and required resources for assigned projects and program initiatives.
- Extensive experience with Microsoft Visual Studio.
Confidential, Encinitas, CA
Lead Internet Developer
Responsibilities:
- Design and develop all web applications for Confidential .
- Duties include ASP.NET, C# .NET, PHP development and database creation for all internet applications.
- Create and optimize relational databases for application and reporting services.
- Retrieve and parse data from vendors and transmit to web and mobile applications. Extensive use of Visual Basic, SQL Server, Active-X DLL’s, MySQL, ASP, Perl, Java Script and XML.
- ASP.NET/HTML/PHP and CGI/Perl.
- Visual Basic application development.
- Database creation and normalization, creation of stored procedures and functions. Extensive use of SQL Server and MySQL.
- Some wireless development including BREW and MIDP and WAP.
- Oversee web development team and interface with clients.
- Integral part of day to day management team at Confidential .
- Extensive ASP.NET, VB6, PHP and database development.
Confidential, Irvine, CA
Lead Developer
Responsibilities:
- Develop database driven internet applications for clients of Confidential . Duties include: database creation and normalization, creation of stored procedures, functions and ASP.NET/HTML pages. Clients include Confidential iSeries, Sparkletts Water, Evian, Mazda of North America, Dannon and Burger King.
- Extensive database development and optimization.
- Developed and currently maintain Confidential ’s ISeries Connect, a workflow and promotions approval web application.
- Create custom ASP/SQL - FLASH applications for promotional Web sites.
Confidential, Anaheim, CA
Sr. Web Developer
Responsibilities:
- Create new and maintain existing web pages on the Confidential Online and hosted Web sites.
- Develop custom Web sites for reporting, offer entry and retailer/client services utilizing ASP, ADO and SQL Server 7.
- Created Confidential Web site for Food Industries Circle/City of Hope for charity bidding online.
Confidential, Santa Barbara, CA
Owner/Web Designer
Responsibilities:
- Design web sites to customer specification.
- Implement custom CGI, ASP, Database and Java scripting.
- Design and create web graphics utilizing Photoshop.
- Configure web servers and related software on UNIX and Windows NT platforms.
Confidential, Santa Barbara, CA
Technical Support Supervisor/Programmer
Responsibilities:
- Provide on-site and telephone support for clients of Confidential Systems’ Medical Document Imaging and Retrieval System.
- Create Windows based client/server software utilizing C and SQL.
- Database management of Informix, Oracle and SQL Server relational databases on UNIX and Windows NT platforms.
- Extensive hardware troubleshooting and configuration.
- Configure and maintain in-house and client networks.
- Supervise Confidential Systems’ technical support staff.
Confidential, Goleta, CA
Database Administrator
Responsibilities:
- Manage the Inventory Control System’s Informix relational database.
- Create SQL scripts for inventory control purposes.
- Provide technical support and training for users of Confidential ’s inventory control systems.