SUMMARY:

• Over 15 years of experience in software and database development and testing.
• Solid experience with large - scale software implementations including customization of vendor Retail POS Systems to meet business need, and involving developing in-house Mobile POS.
• Extensive experience with database technologies, data warehouse, database development using database languages.
• Deep understanding of software development and implementation methodologies including Waterfall, Agile, and SCRUM.
• Knowledge of Big Data and Hadoop, HDFS and Map Reduce.
• Performing feasibility analysis, scoping projects, and recommending alternative solutions and project strategies.
• Analyzing business processes, identifying deficiencies and researching solutions.
• Strong problem solving skills. Ability to take ownership and responsibility for all work.
• Known for keen expertise in all facets of project life cycle development, from initial analysis and conceptual design through implementation, quality review, and enhancement.
• Known for being able to bridge the gap between engineers and the business.

TECHNICAL SKILLS:

Languages: Java, JavaScript, RESTful/JSON, SOAP, C#, VB, SQL, PL/SQL, HQL, MySQL, Pro*C, Unix/Linux scripting, Perl, XML, HTML, ETL, Data Profiling

Databases: Oracle 11g, Microsoft SQL Server 2x, MDM, Teradata, knowledge of Mongo DB

BI Tools: BusinessObjects, Crystal Reports, MS BI, Tableau, Power BI

Application Servers: Oracle WebLogic Server, IBM WebSphere Application Server, IIS

Operating Systems: Unix/Linux, Windows

Development Tools: Eclipse, OR Mapping, SQL Assistant, TOAD, Oracle Developer, Visual Studio, Selenium

Source Control/Build Tools: GIT, Maven

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Senior Software \ Data Engineer, Software Engineer Lead, Senior Program Analyst

• Significant contributor to Confidential New Loyalty Program Project in Informatica MDM. Designed and implemented modules to migrate and consolidate the multiple existing loyalty programs into the New Loyalty Program.
• Defined and implemented pre-migration ETL process to ensure customer loyalty data are in sync in all the data source systems. Automated the ETL process.
• Defined and implemented the pre-landing schema and data mapping criteria. The pre-landing tables feed the source information to the Landing tables that are defined for each entity. Automated the process with Control-M.
• Developed and automated the Delta Detection processes which maintained and synchronized the customer information and loyalty points during the transitioning period in the MDM customer database.
• Lead the efforts of investigation on Enterprise Email Marketing Group production issues which had a high visibility within company and huge impact on customer shopping experiences. I dived deeply into the DATA, analyzed data set and pattern, and generated different reports to help marketing group to visualize the issues. I was able to uncover not just the data issues but also application bugs. We quickly deployed the fix and recovered over millions of customer emails.
• Responsible to generate and publish Confidential Daily Report on New Customer Generation and Customer Update by Data Source and Application System. The report helps Leadership and Marketing group to visualize the information over 20 Data Sources and Application Systems.
• Dashboard visualization of product daily promotions vs event special promotion, single unit vs multi-unit promotions, promotions vs sales, vs profit using BI tools.
• Responsible to generate transactional statistics reports to assist Marketing and Business strategic group to plan and budget during the selection of POS System (Tablet and Mobile) new features and enhancements.
• Lead team design and build Confidential major sale events dashboard for loyalty customer Enrollment, including Marketing Campaigns, Email Campaign, Customer Segmentation, and Channel Analysis.
• Provided the solution and developed POS module for Confidential InComm Gift Card project. This project added a new range of Confidential Gift Card retail stores using InComm services. A huge win for Confidential Gift Card sales, especially during holiday seasons.
• Responsible to generate reports for Confidential Privacy Group to investigation Privacy Incidents.
• Responsible to generate reports for Confidential Loss Prevention Group to investigate Credit Card Fraud, and Return Fraud cases.
• Supported over 30 applications across all platforms: applications and systems range from POS (Tablet, Mobile) in 300 stores, to central data batch processing; Monitoring and troubleshooting from the customer facing all the way to Master Customer List (CRM), Data Mart/Customer Data, Inventory Transfer application, Sales Collectors, Mobile Fulfillment application, Shipping & Package Tracking application, Vertex Sales and Return Online and Offline Calculation.
• Analyze data in response to new business requests, perform maintenance and changes on interfaces, and identify and resolve data discrepancies across multiple business applications.
• A mentor for new hires and contract team member. Responsible for bringing them up to speed on the business logic and processes and providing technical assistance.
• Significant contributor to prevent Confidential from hacking and fraud sale transactions, which optimally protect our customer information as well as loss prevention for the company.
• Enhanced a central data transformation system for Point of Sale that collected data coming from upstream sources, transforms the data and pushes the data to the store server. Extensively developed Pro*C and SQL based ETL. Involved in all phases of project life cycle and provided subject matter expertise.

Confidential, Bellevue, WA

Senior Software Engineer

• Lead the development of Planet NOVA network performance optimization and CRM application for wireless telecommunications providers. Planet NOVA is a dynamic Oracle star schema data warehouse product. Worked with other developers to design, develop, test, and document UNIX Shell scripts, PL/SQL, SQL*Plus, SQL*Loader, and Pro*C routines to implement the ETL processes for the data warehouse required to process in excess of 80M calls/day.
• Lead the development of C++/Visual Basic ADO application for manipulating data warehouse slowly changing dimensions. This GUI application is part of Planet NOVA, which provides meta-data to map input data fields to production database fields as part of ETL processes. Allows user to maintain the network dimensional tables and retrieve network topology information.
• Utilized SAP BusinessObjects Designer tool to design and create universes for a network topology for Oracle Star Schema Relational Database. In addition, generated and published reports based on end-user requirements using WebIntelligence, provides the ability to allow user to query and report across the web.
• Created XML code that generates and maintains Planet NOVA process code. Expanded process definition capabilities and refine functional treatments within the XML code.
• Designed and developed 2G and 3G Record Auditing reports which report records flowing through CEOS multi-process streams, and display the balances among CEOS processes in terms of input versus output records/blocks that have been dropped, split, aggregated, persisted sent, and re-sent.

Confidential, Seattle, WA

Senior IT Consultant

• Served as Senior Oracle developer worked on Confidentiaa Roaming Information Management System Interfacing Oracle Financial project. Responsibilities include: review the ER Model based on the business requirements, design and develop all the interfaces for accounting users to maintain roaming information and generating report using Oracle Form/Reports.
• Served as Oracle DBA \ Developer at Western Digital Company. Responsibilities included: Converting from SQL database to Oracle. Monitoring improving database performance, backup / recovery planning and verification, patching the application and databases.
• New Account Loader (An Oracle Web Service Application), at Confidential. The application tracks and maintains all the accounts in the marketing data mart based on certain criteria. Responsibilities include: load new accounts using SQL*Loader from comma delimited files and FTP to the production Sales Marketing Department computer, developed Oracle PL/SQL stored procedures to process the data, which includes data validation, populating, updating, and reloading repaired data.
• Develop Financial and Marketing Reports at Magic Wireless. Gather user requirements, define functional and data requirements, develop revenue, reseller commission, and new commercial subscriber reports using Actuate and Crystal Report. Oracle PL/SQL stored procedures, triggers and packages were extensively used to perform the complicated financial calculations.