SUMMARY OF QUALIFICATIONS: Experienced Integrating MS Office applications automation with VBA and open source scripting for analysis and manipulation of large data sets in systems, such as Oracle, MS SQL Server, Essbase, PeopleSoft, Salesforce.com. Strong project management and data analytics background. Specialized in automating and streamlining business processes and analytical reports. Excellent people skills with strong problem solving ability.

Work Experiences

Confidential

BI Analyst

• Create new and maintain existing SQL queries, stored procedures, and SQL agent jobs in Microsoft SQL Server Management Studio 2008 R2.
• Design new reports in SQL Server Business Intelligence Development Studio.
• Evaluate and improve stored procedure and SQL query performance. Performed data migration on MongoDB.
• Created dbmail alert on data anomalies and abnormal user usage patterns as part of the fraud alert initiative.

Confidential

Consultant Contract

• Automated Management Report as part of Basel II Reporting requirements. This included retrieval of data from Oracle Reveleus into Access database processed the data in Excel and converted the final publish reports to PDF through VBA programming.
• Used regular expressions in VBA and Perl for data validation of Oracle database tables during data promotion and migration to ensure data integrity.
• Integrated MS Office applications with open source programming languages. This is accomplished by embedded SQL queries in scripts such as VBA, Java, and for analysis, text parsing, and validation of large complex data sets again OBIEE.
• Developed Java and Perl tools in extracting and parsing Oracle Essbase log into meaningful information for managing user access. Supports and modified VBA codes that use Essbase API to retrieve data from Essbase.

Confidential

Oracle and PeopleSoft Functional Analyst

• Resolved application logic failures and XML messaging issues between PeopleSoft and Oracle. This included reviewing and testing source codes, XML and XSD, regular expressions, and SQL queries in various environments against our front-end web pages.
• Automated data extraction and IT metric report buildings in Oracle, PeopleSoft, and SQL Server. This brought visibility to the corporate IT workloads.
• Collaborated with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs. This included creating process mapping of workflows, system inter-dependencies, and Software Development Life Cycles, resulting in identification of process weakness and problem resolution.

Confidential

Microsoft Office Application Programmer / Salesforce.com System Administrator

• Managed projects through various stages of SDLC for applications developments and deployments with Innotas, a project portfolio management tool.
• Supported over 200 users of Salesforce.com users. This included managing workflows, approval processes, mobile setup, data migration, security administration, coding, debugging, trouble shooting, and user trainings.
• Performed analysis, testing, and documentation on enhancements to existing applications, web based interfaces, and business to business solutions for the business.

Confidential

Data Manger

• Developed data quality assurance metric reports using VBA on MS Access and Excel. This ensured training data integrity and accuracy and significantly increased safety awareness and raised safety training compliance rates.
• Enhanced and strengthened communications and cooperative working relations with trainers, contractors, users, physicists, and on-site DOE regulatory agents resulting in better coordination of safety training and accident respond procedures.
• Created departmental resource projection and allocation reporting which brings visibility to schedule, workload, and resource allocation.
• Enhanced inter-department Incident Management Tool to extend its incident reporting and tracking capabilities. This was accomplished through a new UI design in one of the core module in the tool.

Confidential

Sr. Analyst

• Spearheaded the implementation of Competitor Database project combining competitors' data and sales projection data and created a proactive Market Planning Reporting System to significantly streamlined decision making processes.
• Developed proposals to streamline store maintenance processes based on store maintenance historical data and trends. This reduced maintenance overhead by over 15 million dollars.
• Coordinated the implementation of vendor EDI Compliance Measuring application resulting in improved communications and cooperative working relationships between manufacturers, vendors, and shippers.

Confidential

Software Installation and Configuration Technician

• Developed production database using MS Access to track production data, quality assurance issues, deployments schedules, and customer service issues. This centralized production data repository and analysis.
• Created detailed documentation of lessons learned while providing problem resolution support for customer complaints and product related issues.
• Performed usability and unit testing ensuring proper hardware and software application functions.