SUMMARY:

• Programmer Analyst with 18 years of experience in analysis, development and maintenance of business applications.
• Import/Export and manipulated data from and to MS Excel, SQL Server, Oracle to multiple MS Access Database Applications.
• Created Web reports using MS Access Database, SQL and MS Excel.
• Expertise in using Microsoft Business Intelligence( SSIS, SSAS and SSRS)
• Performance Point server, Share Point Site
• Experience of system testing on all stages of Software Development Life Cycle.
• Strong desire for quality, attention to detail.
• Learn new tasks and procedures quickly.
• Excellent communication and interpersonal skills and Confidential very good team player with the ability to work independently, cooperative and flexible.

TECHNICAL SKILLS:

UNIX, MS Access, MS Excel, VBA, Visual Basic, MS SQL Server, Microsoft Business intelligence Tools (SSIS, SSRS, SSAS), Crystal Reports, ActiveX Controls, Oracle, Cold Fusion, Power Point, DB2, Web Server, JavaScript, VBScript, ASP, .NET, XML, MS Visual Studio, ODBC, HTML, API, XML, Performance Point Server 2007 (PPS), SharePoint, Visual Source Safe 6.0, TFS, Aldon 5.4.

PROFESSIONAL EXPERIENCE:

Confidential, Aliso Viejo, CA

Sr. BI Analyst/Report Developer

• Creating new and modifying existing reports using MS SQL Server BI Development Studio tools SSRS, SQL2012, MS Visual Studio. Develop Ad - Hoc reports.

Confidential, Sacramento, CA

Sr. BI Analyst/Report Developer

• Creating new the Reporting Services solution projects, designing reports using MS SQL Server BI Development Studio tools (SSRS, .NET, C#), SQL2012, MS Visual Studio 2010/2012/2013 . Analyzed, designed, maintained, debug and tested the new and existing applications. Develop Ad-Hoc reports.

Confidential, Roseville, CA

Sr. BI Analyst/Report Developer

• Creating new the Reporting Services solution projects, designing reports using MS SQL Server BI Development Studio tools (SSRS, SSIS, SSAS), MDX, DAX, SQL2005, SQL2008R, SQL2012, Visual Studio 2010/2012/2013 , Oracle11g, Tableau 8.0, PowerBI, HTML, Access2013 and MS Excel.
• Analyzed, designed, maintained, debug and tested the new and existing applications. Converted the Tableau reports to SSRS. Automated existing manual reports using Microsoft SQL SSRS and SSIS. Develop Ad-Hoc reports. Document technical requirements.

Confidential, Honolulu, HI

Sr. BI Developer/Analyst/Report Writer

• Creating new the Reporting Services solution projects, designing reports using MS SQL Server BI Development Studio tools (SSRS, SSIS), SQL2005, SQL2008R, SQL2012, Visual Studio 2008/2010, Oracle, HTML, Teradata, QNXT, MS Access and MS Excel. Analyzed, designed, maintained, debug and tested the new and existing applications.
• Utilizing star schema data stores as the basis for report development. Design and develop complex stored procedures, tables, views for applications.
• Develop Ad-Hoc reports. Cleansing and loading FTP files using SSIS.
• Develop reports for doctors to track patient satisfaction. Develop clinical access reports. Analyzing and updating HEDIS (Healthcare Effectiveness Data and Information Set) measures.
• Build and send email monthly email subscriptions to over 400 doctors. Developed validation and tracking reports. Collaborate with Business Consultants and Executive Leadership to confirm technical requirements. Document technical requirements.

Confidential, Honolulu, HI

Sr. Data Analyst / Report Writer

• Creating new the Reporting Services solution projects, designing reports using MS SQL Server BI Development Studio tools (SSRS, SSIS), Visual Studio 2008, SQL2008R, Oracle and MS Excel. Analyzed, designed, maintained, debug and tested the new and existing applications.
• Design and develop complex stored procedures, tables, views for applications. Develop Ad-Hoc reports. Work very closely with business analyst and end users to understand the report requirements. Designed technical documents, use cases and test cases.

Confidential, Pleasant Hill, CA

Sr. Data Analyst / Report Writer

• Creating new the Reporting Services solution projects, designing reports using MS SQL Server BI Development Studio tool SSRS, Visual Studio 2008, JavaScript, MS Access and MS Excel. Analyzed, designed, maintained, debug and tested the new and existing applications.
• Design and develop complex stored procedures, functions, tables, views for applications. Develop Ad-Hoc reports. Used the VB and Java scripts in script component for data transformations.
• Used sub reports functionality for complex report calculations. Work very closely with business analyst and end users to understand the report requirements.

Confidential, Fairfield, CA

Sr. Data Warehouse Analyst

• Designing and developing dashboards, scorecards, reports, user interfaces using Microsoft SQL Server Business Intelligence Development Studio tools (SSIS, SSRS, SSAS), Visual Studio, ASP.Net, JavaScript, Performance Point Server 2007, SharePoint, Crystal Reports, MS Access and MS Excel.
• Work with business users to understand and develop report requirements.
• Analyzed, designed and tested new and existing applications using Access 2003/2007, SQL Server, Report Builder 2.0 and Excel, migrated the Microsoft Access tables and queries to the Microsoft SQL Server tables and views. Creating data warehouses involving star and snowflake schemas.
• Converting analytical requirements into dimensional models (star schema, snowflakes). Design and develop stored procedures, views, and MDX queries necessary to support SSRS report.
• Perform data analysis and data profiling and identify data quality issues. Testing and documenting technical specifications for application.
• Analyzed, designed and debugged the SSIS packages, mapping data attributes for each environment.
• Creating and designing the SharePoint Sites, publishing reports from PPS into SharePoint and creating documentation.

Confidential, San Francisco, CA

Sr. Data Analyst / Report Writer

• MS Access, SQL, T-SQL, MS Visual Studio 2005, Net Framework, Crystal Reports11.
• Converted Crystal Reports to Reporting Services. Used SSIS to create ETL packages to validate, transform and load data into SQL Server Database from different sources. Deployed and configured SSRS reports in SQL Reporting Services Server.

Confidential, Rancho Cordova, CA

Sr. Programmer Developer / Data Analyst

• Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces, reformatted and cleansed the data, and loaded it into another database, debug and tested for the IT Department using VB.Net, ASP.Net, MS Visual Studio, VBA, Crystal Reports, designed DTS Packages, MS Access, SQL, Excel, VB Script, SQL Server data warehouse DB, SSIS, ETL, SQL Reporting Services, BI, T-SQL, Mainframe, Unix, DBA, SAS, Cobol, Oracle, ODBC. Prepare project timelines, implementation specs and user acceptance.

Confidential, Concord, CA

Sr. Programmer / Developer

• Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces, debug and tested new applications for the multi-user database systems for the Commercial Loan Department using MS Access, SQL, VBA, MS Excel, Active X control.

Confidential, Sacramento, CA

Programmer

• Web site design and programming using ASP.Net, SQL Server, ADO, UNIX, SQL script, DTS Package, CSS, VBScript, JavaScript, GUI, HTML, DHTML, XML, VSS, MS Visual Studio, PhotoShop, MS Access Project, MS Access DB. Work with clients to help plan, design and direct web Project. Assist in domain name registration, site planning and architecture, logo design, graphics.
• Support Access project for California Medical Association.

Confidential, Palo Alto, CA

Sr. Data Analyst Programmer

• Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces, debug and tested new applications for the multi-user database systems using Visual Basic 6.0, SQL Server 2000, SQL, ODBC, MS Access, MS Excel, ASP. Analyzed and converted data from SQL Server, Oracle, Excel, TXT files to MS Access database. Trained users how to use new applications and created user documentation.

Confidential CO, Fresno, CA

Sr. Business Data Analyst

• Participated in all phases of development including implementation, maintenance, prototype, user interface, database interfaces, debug and tested new and existing applications for the multi-user database systems using MS Access 2000, MS Excel, Power Point, DB2, SQL Server 2000, SQL, ODBC. Trained users how to use new applications.

Confidential, Concord, CA

Sr. Applications Developer / Programmer Analyst

• Developed and maintained Internet/Intranet applications using MS Access, MS Excel, ASP, ColdFusion, SQL Server, ADO, UNIX, Oracle, SQL, PL/SQL, VBScript, JavaScript, GUI, HTML, XML, MS Visual Studio, Visual Basic. Created Business and Trade Solution Web Application. Developed reports for Corporate Affairs Web Sites.

Confidential, Walnut Creek, CA

Sr. Programmer Analyst

• Created Confidential multi-user front end for the Marketing Control and Finance systems using MS Access 97, VB, ASP, Business Objects, DB2, ODBC, SQL, MS Excel.
• Participated in all phases of development, implementation and maintenance, prototype, user interface, debug and tested new applications. Import, Export and link data from Text File, MS Excel 4.0 to Access Database.
• Created connection using ODBC and API. Trained users how to use new applications.

Confidential, Oakland, CA

Sr. Business Analyst/Report Writer

• Converted Confidential VB 6.0 to MS Access 97. Analyzed, designed, coded, developed, and tested new and existing applications, for MS Windows NT multi-user database system using Oracle tables, Access 97, SQL Server, SQL, HTML and Excel.

Confidential, Oakland, CA

Sr. Data Analyst/Report Writer

• Performed analysis, debugs, programming, testing and designed for management accounting and data analysis purposes using SQL Server 7.0, Visual Basic 4.0, ASP, HTML, Cold Vision, VB Script, Oracle 7.3, MS Access 2000, PL/SQL, MS Transact SQL, SQL, Crystal Reports, Web Server, MS Excel, Business Objects, MS Word, Power Point Viewer 97, ODBC and API.

Confidential, San Francisco, CA

Business Analyst/Report Writer

• Created Confidential multi-user front end for the Customer Control and Accounting systems Using Java Script, JavaScript, ASP, HTML, MS Access 97, Visual Basic 5.0, Oracle, MS Outlook and Active X Controls, Power Point, SQL, MS Excel. Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces, tested new applications. Converted existing Access Database to new application and from MS Excel to MS Access 97 database. Import, Export and link data from Oracle, Text File, MS Excel 4.0 to Access Database.
• Trained users how to use new applications.

Confidential, Vacaville, CA

Business Analyst

• Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces, debug and tested new applications for the multi-user database systems using MS Access 97 for Visual Basic Applications code, VBA, SQL Server 7.0, SQL, HTML, MS Excel.
• Converted reports from MS Excel to MS Access 97 database. Import & Export data to Access Database. Created Security for Databases. Trained users how to use new applications.

Confidential, Cupertino, CA

Business Analyst

• Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces, debug and tested new applications for the multi-user Compaq and Siebel systems using MS Access 97, SQL, HTML, ODBC, API, Visual Basic 5.0, MS Transact SQL, MS Outlook and Active X Controls, MS Exchange 4.0, Mail extension 3.6 OCX.

Confidential - direct position, Redwood City, CA

Programmer Analyst/Report Writer

• Converted Confidential File Maker Pro 4.0 to MS Access 97.
• Analyzed, designed, coded, developed, and tested new and existing applications, for MS Windows NT 3.51 multi-user database system using MS Access 97, SQL Server, SQL, HTML, MS Excel 4.0 and File Maker Pro 4.0.

Confidential, San Francisco, CA

Programmer Analyst

• Performed analysis, design, debugs, programming and testing of Confidential variety of business and accounting applications using Visual Basic 4.0, Oracle 7.3, MS Access 97, SQL, PowerPoint, ODBC, and API.

Confidential, San Francisco, CA

Programmer Consultant

• Converted an MS Access version 2.0 database to MS Access 97. Analyzed, designed, programmed, developed, tested and maintained the Multi-user using MS Access 97 database for Visual Basic Applications code, SQL, HTML, Excel. Centralized and consolidated databases in California and Texas. Trained personnel how to use new systems.
• Interfaced with user groups to determine system requirements that automate the process of cars inventory control. Prepared detail specifications. Responsible for the analysis, design, development, test, troubleshooting and implementation of new business application for cars inventory using Excel 4.0. MS Access 97, Visual Basic 4.0, ODBC, API, PowerBuilder, Crystal Reports 4.5 and SQL. Developed and implemented Legal Assist System for law offices using SQL, MS Access 2.0. Created case and hearing handling modules, table maintenance and reports. Enhanced performance for existing reports by optimizing queries.
• Participated in all phases of development, implementation and maintenance, prototype, user interface, database interfaces and debugging of warehouse inventory control system applications using MS Access 2.0, SQL, MS Excel 4.0 & 5.0.