SUMMARY:

• 8+ Years of PL/SQL Oracle, ASP.NET, Classis ASP & VB.Net, VB Script, MSSQL Server, VB6, VBA Excel, MS Access and Crystal Reporting skills.
• C#, HTML, XML, CSS3, PHP, JavaScript, JQuery, Ajax, UNIX/HP(C, KORN, BORN) Shell scripting.
• 5+ Years of extensive solid Investment, Banking/Mortgage Loans and Finance experience.
• 5+ Years of experience in developing and maintaining Crystal Reports 2008, SQL Server 2005/2008/2014 views, user defined functions, stored procedures, custom and ad - hoc SQL development.
• I am self-taught, self-motivated, and proactive. With an innovative attitude, and is committed to the use of best practices to produce high quality applications. Loves to write code in a high-paced and challenging environment with an emphasis on using best practices to develop high quality software that meets project requirements, budget, and schedule. I also enjoy learning new technologies and sharing findings with his colleagues. .
• Excellent leadership skills: planning, customer service, organization, analytical and problem solving.
• Skilled in writing code that is easily maintainable, well documented, meets user specifications, and is completed by scheduled deadlines.
• Demonstrated ability to create technical documentation that is clearly written, well organized, well structured, and accurate.

PROFESSIONAL EXPERIENCE:

Confidential, Encino, CA

SENIOR MS PL/SQL BI/Crystal Reports Developer

Responsibilities:

• Heavy hands-on experience in developing over 50+ new and modified SQL Server Views, Functions, Stored Procedures and Crystal Reports for converting and implementing new companies into existing environment.
• Produced and analyzed large complicated T-SQL stored procedures and functions for inserting, deleting, retrieving, updating and manipulating data in SQL Server to perform data metrics on hospital readmissions, high patient utilizations and patient trend analysis.
• Developed and maintained Crystal Reports which include dynamic grouping and sorting, formulas, running totals, sub-reporting, drill down and summary reports, cross-lab reports, and parameterized reports.
• Conducted quantitative data analysis in producing ad hoc internal and external reports.
• Worked collaboratively with department heads to understand their business objectives and make suggestions regarding query/report design.
• Identified and troubleshooter for query, reporting issues and inaccuracies.
• Developed and modify existing Crystal Reports with SQL Server for various departments including Finance, Medical Management, Network Management and Claims Operations.
• Interacted with users to gather requirements and prepare report specifications.
• Worked with business requirements analyst to identify and understand source data systems as it related to target application/reports.
• Designed and develop Views, Stored Procedures, Functions and Crystal Reports relating to converted database.
• Adapted current and created new reports relating to enhance data from source system.

Confidential, Anaheim, CA

SENIOR VB.Net SQL APPLICATION DEVELOPER

Responsibilities:

• Analyzed, developed, and updated an internally developed application called DART (Data Analysis Reporting Tool using Crystal Reports & Excel). Tool operates on a VB.Net/ MS SQL 2008 Software Data Base platform with over 400 users.
• Developed an ASP.Net application that tracked Schedule Overrides for Confidential Field Operations. Application was interfaced through SharePoint, using ASP.Net /MS SQL Data Base/Stored Procedures & Functions.
• Developed and enhanced reports using Crystal Reports and MS SQL.
• Developed MSI Installation Packages for outsourced organization for deployment of software upgrades. Also developed a self-updating module using VB Script and MS SQL.
• Initial assignment was correct screen mapping of 142 VB.Net report request screens. This involved reconfiguration and positioning of custom class controls that were used to select reports and pass parameters in a MS SQL 2008 Server Environment.
• Role was responsible for updates to existing code and writing new code for enhancements. The projects also include analyzing data and applying Business Rules to determine outcomes.
• Updated and created stored procedures, functions, and designed new tables.
• Develop new modules for the client application by working closely with the team to maintain component reusability.
• Analyze requirements, produced technical designs, updated the application, conducted software testing, and implemented the software solution and support production issues.

Confidential, Burbank, CA

DEVELOPER/ANALYST

Responsibilities:

• Developed and implemented a desktop Cost Tracking application using VBA Access.
• Application interfaced with SharePoint, Excel and SAP.
• This application is used to tract invoices from hardware vendor to gaming units through North America and Canada.
• Application required five Access Data Bases in the controlling and verifying of accounting charges.

Confidential, Woodland Hills, CA

Senior Application Developer/Analyst

Responsibilities:

• Modeled, analyzed, developed, implemented, and maintain a Financial Investments Applications (PAM) using ASP.Net, Oracle PL/SQL, Access, Excel and Crystal Reports.
• All reports were developed using Crystal and Access Reports.
• Developed a ‘Stock Options Trend’ analysis software using VB6 Oracle/Access DB.
• Strong quantitative and analytical skills in the development of Oracle PL/SQL stored procedures. Built queries and interfaces to extract financial data. Queries were difficult financial calculation that went as far as six levels of SQL nesting & calculating.
• Rewrite of an ASP.Net “Rideshare” Web Application to VB.Net/JavaScript/AJax Oracle.
• Developed an ASP.Net Application for Company Fitness Program. This application tracked employee’s walking workout activities.
• Requirements gathering along with team for developing data interface rules (specifications) between eCounsel Application and Company Claims System.
• Responsible for the software design and architecture when developing the software extraction rules.
• Extracted data using SSIS Tools.
• Established development timelines (in concert with project manager) highlighting milestones.
• Programmed, tested, troubleshooting, debugged and correcting eCounsel Rules used for Alerts, Matter Notifications and data extractions.

Confidential, Torrance, CA

Senior Application Software Developer

Responsibilities:

• Rewrote an Oracle Forms (7) Human Resource and Assets Management Application for the USAF into a VB.Net/Oracle/PL/SQL/H.P. UNIX Platform. It was redesigned centralizing all key facets associated with personnel management and asset allocation.
• Also developed miscellaneous related applications, ad hoc quires and Crystal Reports utilizing Oracle and Access.
• System tracked personnel data, training, position assignment, deployment eligibility, and professional certification and asset responsibilities.
• The redesigned and programming produced 116+ VB.NET Window Forms and modules.
• Evaluated software, system problems and potential solutions during the conversion.
• Created new business opportunities for Northrop in marketing the new applications to potential customers.
• Rewrote Oracle Forms DB call to Oracle Pl/SQL Stored Procedures and functions.
• Performs all phases of applications systems analyses and design using SDLC Methodologies.
• Work was performed independently with the freedom to develop own methods.
• Provided 2nd tier technical support to clients for new installed applications.
• Assignments require strong ability to interact with users who were not too familiar with Information Technology processes.
• Working knowledge of Windows with strong writing, speaking and documentation.
• Produced over 40+ Crystal Reports during the rewrite of an Oracle Forms 7 Human Resources and Assets Management Tool into a VB.NET Oracle/Pl/SQL System. They we highly customized with ‘secure’ user configuration parameters and adhering to Privacy Act Requirements.

Confidential, Torrance, CA

Web Product Application Analyst/Project Leader

Responsibilities:

• Redesigned Confidential Intranet Education Website for Brand Marketing using HTML/Master Pages.
• Planed and organized the development of technical support protocol for External & Internal Web site.
• Developed Quick Place (IBM) Knowledge Data Base for department managers to track budget and projects using Access.
• Proven leadership capabilities: Coordinates various areas to ensure deadlines are met, resolve conflicts, produced project plans, consulted with users and vendors for needs assessment.
• Manage moderately complex to complex projects.
• Researches and develops and evaluates alternative systems solution and recommends the most efficient and cost effective solution for the systems design or integration.
• Acted as technical business liaison between primary assigned area and other Confidential Financial Groups.
• Required the ability to communicate effectively both orally and in writing.
• Conducted system architecture studies of new and existing website systems or subsystems for development of integrated systems which operate at low cost levels.
• Conducted studies of new or existing systems and recommend changes based on these findings.
• Produced directs solutions to system/business problems.
• Developed Access DB for budget tracking, streamlining of Budget procedures, student tracking and class deployment for classes in China using MS Access.