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 Confidential 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 Confidential in Confidential, Confidential, retail, insurance industries, and Confidential 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

• Tech Lead of License Email Notification System for City of Chicago, including analysis, design, configuration, development, testing, and implementation.
• 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

• Cross-functional cooperation (SME/PM) with various Walgreens resources, UNIX Admin, WebSphere Admin, DBA, Security, Network, Infrastructure, QA, Business owner/user, internal users (support, developer), Corporate Purchasing to design, procure, develop, and implement new Logfaces system in HA (High Availability) with Load Balancer, two app servers, and active/passive DB servers. The system allows IT support to real-time monitor 200+ Confidential applications and conduct quick troubleshooting.
• Developed/Coded various size of Confidential 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.
• Designed and implemented Confidential Purge/Report system (Rx, Confidential t, Prescriber for 60+ tables in local and central) to ensure effective protection and integrity of data asset. The key purged data are saved (ETL) into Enterprise Data Warehouse (EDW) for reporting and archiving.
• Played the role of tech lead of Confidential Buyout project: Microsoft Business Intelligence (MSBI) Life Cycle.
• Used ETL to load Buyout Confidential t 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 Confidential Buyout data.

Confidential

Senior Program Analyst

• 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 Confidential 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 Confidential Web Application Tools that assist Confidential 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 Confidential t 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

• Provided 24x7 production support for 120+ Confidential 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, Confidential t, 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 Confidential 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

• 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

• 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.