Microsoft Business Intelligence Developer

• MS SQL Server 2008/2012, SSIS, SSAS, SSRS, MS T-SQL, Data Warehouse
• Detail-oriented programmer/developer with 15 years' success devising innovative and tailored database solutions t meet the ever-changing business requirements in the pharmaceutical, insurance and finance industries. Ten plus years in the leadership and supervision managing a team of database developers in designing, developing, employing, customizing and enhancing in-house business intelligence applications. Proficient in Visual Basic VBA languages with experiences in creating and developing business intelligence and reporting applications using Microsoft SSIS, SSAS and SSRS. Proven track records of rapidly creating and developing Dashboard, GUI Excel forms, charts and graphs for sharing data between MS Office applications, i.e. PowerPoint, Access and Word. Knowledgeable in creating stand-alone Excel applications t be used by multiple users in SharePoint and network environment. Demonstrated expert skill in Structured Query Language SQL that enables the candidate t incorporate complex query solutions and present them in simple-to-use interfaces such as in Excel forms and Access applications. Possess skills t develop Microsoft multi-dimension cubes using Microsoft SSAS platform for data mining and performing business analytics. Technical proficiencies include
• Environments Microsoft SharePoint, MS SQL 2008/2012, AS/400, IBM DB2, Microsoft MS Visual Studi 2008/2012. Microsoft Business Intelligence Development Suite. Citrix Thin Client Network.
• Programming MS SQL 2008, Visual Basic 6, VBA, VBScript, XML, DB2, MS Access, MS Excel, MS SharePoint 2007, Structured Query Language SQL , ASP, OLEDB ODBC Connectivity, MS Query, Microsoft TSQL, Com/Com Technology, IBM Query 400 , Crystal Report 8.5.
• Development Expert in Rapid Application Development RAD ,Multi-tier Distributed Applications using Object Orient Programming, Stand-alone Database Program with Rich Client Interface, Building Access application employed in SharePoint environment, XML Solutions, Financial Applications using VBA, MS Excel MS Solver.

Professional Experience

Confidential

Excel Global Usability Application Developer

• Sole contributor and developer of an Excel VBA application t track and monitor that new products comply with the company policies and departmental protocols in each stage of their development from conception t launching int the markets. This Excel management tool is t be used globally as a de fact blue print for all Pepsic products s that a uniformed and consistent product launching framework may be achieved and the process can be monitored, analyzed and studied t achieve greater efficiency and minimize duplication of efforts among different stakeholders and company groups.
• The Excel VBA application serves as a self-contained management tool t store the progress information of each new product during the different stages of its development. It allows the management and different development teams t quickly share information, t create timelines of the launching of the new products, and t prioritize resources based on the launch-readiness of the product lines. The information collected for each product through the Excel tool will als be used t speed up the process of bringing other similar products int the markets.

Confidential

Lead Database Program Developer a Pfizer project l

• Lead role for the design and development of a database solution t support a team of 235 users in the SharePoint environment t record, track and monitor the various processes and facets of a pharmaceutical project. Performed the ETL process Extract, Transform and Load t Integrate client's current and archived datasets in the database solution. Used SSIS t import 248 plus Excel spreadsheets at set intervals t the MS SQL Server database. Created multi-dimensional cubes t aggregate datasets based on time periods and display the data through Excel spreadsheets thus monitoring the task stages and progresses of the 14,500 plus regulatory notice actions RANs based on the hub-regions, markets, product lines, APIs, etc. Generated reports for day t day team operations and high level management dashboard and metrics using SSRS and Excel MS Query.
• Engaged and contributed in the project's modeling and workflow sessions. Successfully deploying an architectural solution for the Microsoft database in a SharePoint network platform that optimizes the database efficiency and speed and facilitates the simultaneous access by multiple users. Sole contributor t the rapid development and implementation of the database solutions t track and monitor the team's work load and performance via the creation of Excel dashboard and the use of key performance indicators KPIs and various reporting functions t meet the requests of the clients, stakeholders and the team leaders and supervisors.
• Developed and continue t develop automation solutions using Microsoft Excel and Access applications and t meet the reporting and analytics requirements of the team leaders and supervisors in the day t day business operations. Successful in implementing business rules t govern the workflow and t streamline the work-in-progress among various project teams premised on Visi flow charts and business requirements provided by Pfizer's conformance officers. Achieving outstanding database response time over the network environment and SharePoint / Citrix platform by optimizing the data load via a backend/frontend database configuration.

Confidential

Contract Developer on MS Access Database Application with Excel

• Sole Contributor and developer of a pricing model application PMA using Microsoft Access and Excel 2007 in the implementation of a global pricing scheme. The Access database pricing and reporting application enables users t retrieve and download past historical sales data in units, gross and net sales volume, gross and net prices and cost-of-goods-sold values. Through the user interface in Access forms, users may select and filter desired business categories and download datasets t Excel spreadsheets. The application then can calculate the optimum pricing increases t achieve a user-defined projected sales volumes, break-even number of units, and many other statistical features t assist management setting price movements at the SKU level of each product for the upcoming sales cycle.
• I was als working on the proposed development of a data warehouse architecture and system workflow featuring MS SQL Server 2008R2. The pricing scheme acts as the launch pad of a large data warehousing project tracking and archiving fact transactions and entity contexts s that precise purchase behaviors and seasonality of sales may become available t the various marketing staff t achieve optimum profitability. A migration feasibility study from MS Access t SQL Server 2008/2012 was drafted using the MS Upsize Wizard. Once the upsizing/migration has completed, the proposed database warehouse model will use MS SQL Server 2008R2 and SSAS technology t develop cubes for data mining and establishing KPIs displayed in MS Excel.

Confidential

Independent Consultant on Database Development

• Consulting and participating in the creating, developing of a litigation support application for law firm uses. The application stores evidentiary documents in various formats, contains calendar feature t schedule, track and project different phases of the case progress, maintains a comprehensive client billing system, reports real-time costs and expenses for user-input time period, and many other cutting-edge features, such as case budgeting, cost project, analyses of venue selection and jury profiling. Details of the application are confidential and proprietary .
• The core application is created using Visual Basic 6 VB6 for its ease of maintenance and quick development. The VB6 application uses the multi-tier configuration consisting database layer, business layer middleware in modular formats for its quick coupling and ease of revision without the need of changing other layers and the presentation tier consisting of extensive GUI graphic user interface . Since the program is premised on Visual Basic 6, it is easily interfaced with the Microsoft Word, Outlook, Sharepoint, etc. and it is coupled with MS SQL Server 2008 as its backend database system. Within the VB6 application, extensive automation programming invoking other Microsoft Office Suite applications are used, e.g. an Excel application with user graphic interface in the forms of ActiveX component and form controls, may request information via an often-used ad hoc query t be retrieved from a MS Access database.

Confidential

Claims / IT Report Supervisor

Supervise, develop and maintain company-wide business intelligence reporting functions for various departmental, external entities and upper management use. Create Pivot Table reports and analyses using MS Excel 2007 2010. Responsible for overseeing the migrating of legacy Excel files with add-ins, macros, modules DNS components t the new Excel 2007 and Excel 2010 versions. Design and implement company-wide graphic user interface BI applications for extracting data results from company back-end databases and made available t end users via front end programs using Visual Basic, ASP, Microsoft office applications and others. Use ODBC technology and MS Office Query t extract and distribute real time business intelligence and company data from the back end data sources t the front-end company users.

Key Achievements:

• In 2011, created, implemented and tested the data-retrieval end of a dynamic business intelligence web application using MS SQL 2008 as the backend database and ASP codes for programming the application logics and database retrieval. I played the key role in the ETL process and in the normalization of the relational for optimum performance over the network and in query execution. Working with the webmaster using Adobe Dreamweaver CS4 as the interface for the generation of web pages. The application enables our insured account Honda Motorcycle of America t view and retrieve loss data and number of claims and their dollars amount among their hundreds of motorcycle dealers/warranty repair services in the Confidential.
• The application can als perform drill-down analysis on a real time basis at the web and t download and produce business intelligence reports in Excel 2007 2010 format with many GUI graphic user interface , e.g. Microsoft form controls t enable the end-used t further perform quantitative analysis in charts, graphs and financial summaries.
• I was the project leader of a team of three, consisting Sompo's database administrator, a webmaster and a consultant. I was instrumental in the conceptualization of the application and the lead contact person with the client's IT members.
• Aside performing the database logic programming, I als conducted the ETL , the cleaning and scrubbing and mapping of the client's data in conformity with our back-end IBM AS/400.
• In 2010, assisted the IT department staff in developing, implementing and verifying various data-retrieving algorithms and ad hoc queries, dash-boarding when the company migrated t Oracle's business intelligence BI application in 2010 and collaborate with IT team leaders using MS SSRS t test and develop reporting applications.
• I was the testing programmer t insure the SQL queries and resulting dataset of migrated applications conform and yield consistency t our requirements and the IBM AS/400 archival databases.
• I was assigned t develop and training program for the Oracle BI application for the company. The objectives were t instruct company users how t use the comprehensive dashboard, query-criteria selection, report templates, aggregate financial summary, automatic email distribution list and many others. As part of training, I als created detailed user manual with screen shots, instructions, stored examples, etc, both in written and vide formats. I als acted as a backup help desk person for our Claims Department for the Oracle application.

Confidential

Chief Consultant/Legal Strategist

• Provided legal and corporate services t small businesses in the greater New York area and maintained a general law practices servicing the New York Chinese community. Since this is a non-IT endeavor, further details will be furnished upon request.
• Developed commercial real estate investment strategies
• Devised cooperative conversion planning for realty developer
• Created ejectment strategy for landlords having rent strike situations