SUMMARY

• Lead Oracle Developer with significant progressive experience in full life - cycle software/database development (SDLC) including requirements analysis, application design, development, testing, implementation, maintenance, and improvement
• Played the role of tech lead of Pharmacy Buyout project: Microsoft Business Intelligence (MSBI) Life Cycle.
• 8 years of experience with data warehousing and data modeling.
• 4 years of experience with MSDI and PDW.
• 8 years of experience with ETL design and data integration.
• Extensive business knowledge in healthcare, pharmacy, retail, insurance industries, and Pharmacy Benefits Management
• In-depth understanding of the latest IT technologies and the capability to quickly adapt to new technologies
• Excellent project management, analytical and problem solving skills, with strong attention to details and quality standards
• Solid experience in large-scale real-time applications, enterprise integration, and multi-tier distributed client/server systems
• Strong communication and leadership skills; highly motivated individual and an outstanding team player

TECHNICAL SKILLS

Databases: Oracle 11g/12c, Exadata, GoldenGate/CDC; MySQL, SQL Server, Data Warehouse, metadata, ETL, Tableau, Informatica, Big Data, Hadoop (HDFS, Pig, Hive, HBase), AWS, TOAD12.7, ERWin, ERD, DB2

DB Utilities: SQL*Loader, Export/Import, Data pump, Explain Plan, TKPROF

Languages: SQL, NoSQL, T-SQL, SQLPlus, PL/SQL, Shell Script, C, Pro*C, Visual Basic, Java, Perl, SVN, XML

Operating Systems: Windows, UNIX (AIX 7.1, Solaris, SCO), Linux (Red Hat, SUSE), AS/400, VMware, Mainframe

Application Tools: Business Intelligence, Business Objects, Microsoft Visual Studio, Microsoft BI (SSIS, SSAS, SSRS), SharePoint, Advanced Access/Excel, Statistics (SAS/SPSS), UML Modeling (MS Visio)

Monitoring Tools: Foglight, Tivoli, Splunk, Logfaces

Other Tools: Microsoft Project, Microsoft SharePoint, Remedy 7.1, JIRA, Requisite Pro, Agile, Waterfall Model, JIRA, LoadRunner, Tuxedo, Tomcat, IBM WebSphere MQ, IBM BPM/ODM, RAD 8.5, Apache

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Lead Oracle Developer

Responsibilities:

• Develop database trigger, package, function, and stored procedure using PL/SQL and maintain the scripts for various data feeds.
• Perform database tuning, SQL query tuning, performance tuning/optimization, and DB monitoring.

Confidential, Deerfield, IL

Lead System Analyst/Project Manager, Business Services and Solutions

Responsibilities:

• Developed/Coded various size of pharmacy projects utilizing ER modeling for OLTP/OLAP, Oracle, PL/SQL, RAD 7.0, Java, Web Services, Service Broker.
• Led key profile projects such as Express Pay, New Manufacture, and Prescription Transfer.
• Project manager of pharmaceutical rebate management system project.
• The system is a mixture of OLTP, batch job, analytical data mart, ETL, and reports. (Oracle, Java, JSP, Javascript, Perl, HTML, XML).
• Conducted application/server/system/database capacity planning, analysis, and forecast to avoid 31% system outage due to the lack of capacity/resource.
• Developed Oracle triggers, packages, functions, and stored procedures using PL/SQL for public use in various IT departments.
• Performed database tuning, query tuning/optimization, and performance tuning/monitoring.
• Developed, coordinated the implementation of, and annually tested a comprehensive Disaster Recovery plan to safeguard Walgreens’ assets, including server/database/application Disaster Recovery.
• Played the role of tech lead of Pharmacy Buyout project: Microsoft Business Intelligence (MSBI) Life Cycle.
• Used ETL to load Buyout Patient and Prescriber data (MS Access, Excel, CSV, XML) into Data Warehouse on SQL Server 2012.
• Analyzed data, data cleaning, validation, and provided various reports to Business users.
• Created BI Dashboard - Business users can easy analyze Pharmacy Buyout data.

Confidential

Senior Program Analyst

Responsibilities:

• Played the lead role by providing expertise and guidance to groups including on-site, off-shore teams across the division in the design, implement, and support of solutions for pharmacy related applications.
• Web page design, User interface design with JavaScript, JSP.
• Led and participated the full system development life cycle of projects, size from medium to large and team members from 6—15, utilizing Oracle
• PL/SQL, RAD 7.0, Java, Web Services, Service Broker, J2EE, JavaScript, JSP, and Servlet. Examples of projects: Immunization, Rx Saving Adviser, and WebSDL (Web version of mini Intercom Plus).
• Played the role of tech lead and analyst of Rx Pricing project.
• Collaborated closely with business users and pricing team to provide business decision support and analytics to automatically calculate daily Rx prices for stores in the 50 states and D.C.
• Led the Design and development of Pharmacy Web Application Tools that assist pharmacy supervisors to perform various tasks, such as sales report, with SQL Server, J2EE
• WSAD, HTML, Servlet, JSP, Java Beans, ADF, SDF, RAP Java Frameworks, Perl/CGI, and JavaScript.
• Increased Patient Search performance by 30% with tuning Oracle query (from 3 seconds to 2 seconds), which directly resulted in saving $3 million a year.

Confidential

Senior Application Developer

Responsibilities:

• Provided 24x7 production support for 120+ pharmacy batch jobs (ESP scheduling/automation); identified batch job related issues, which reduced the department’s batch job ABEND rate by 24% between 2001 and 2002.
• Successfully enhanced dozens of database jobs that process millions of Rx prescription, patient, and prescriber data daily, using C, Pro*C, SQL, PL/SQL, Benthic Golden32, explain plan, TKPROF, hints, Unix shell scripts, Perl, awk and sed.
• Implemented performance and stress test to eliminate 13% of defects before production pilot; saved 1,260 hours of labor in one release rollout.
• Worked with business users to acquire new project requirements and conducted ROI analysis and created new project charters.
• Enhanced/implemented e-Prescribe Test Bench for Pharmacy and Clinic, using Java, JavaBeans, AWT, Swing, XML, sockets, Ant, IBM VAJ, UML, and WSAD 5.1.
• Led the analysis and design of e-Prescribe (eRx) and XML Message Wrapper Project, using J2EE, WSAD 5.1, JSP, HTTPs, SOAP, XML, BEA Tuxedo, PL/SQL, batch jobs, and C/Pro*C, Sun Solaris 8, Redhat Linux 8, HP Unix, Visio.

Confidential, Skokie, IL

Oracle Database Administrator

Responsibilities:

• Instructor: Database Programming, CIS 331; Database Management Systems, CIS 502.
• Oracle database installation, set up, configuration, patch, support, maintenance
• Oracle Database performance tuning
• Oracle Database backup and recovery
• SQL and application tuning

Oracle Developer

Responsibilities:

• Developed and maintained Claim System with Oracle DB and Forms; conducted application performance tuning by reducing 18% of process time.
• Worked on SQL join conditions (outer join, etc.), correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Created the DB design using Erwin, MS Visio tools or modifying the existing design according to the new requirements.