SUMMARY:

Dedicated and results oriented professional with progressive experience in information technology systems. Overall 19+ years’ experience in Information Technology system implementation and maintenance for Telecommunication, Government, Finance and Education industries. Technology expertise and implementation experience on Mainframe to Oracle migration, Oracle ERP, Enterprise Data Warehousing using Informatica and Oracle, Oracle Business Intelligence, Big Data Technology using Apache Hive and Spark SQL. Always passion of learning new technology trend, recently completed Data Science course from Confidential .

HIGHLIGHTS OF EXPERTISE:

• Project/Program Management Process Improvement CRM - Install Base, Service Contract
• Service Management Operational System BigData - Hadoop Development
• Channel Partner Management Risk Management/SOX Enterprise Cyber Security

TECHNICAL PROFICIENCIES:

Databases: Oracle 10g, 11g, 12c

Hadoop: Hadoop distribution from MapR, Apache Hive, SparkSQL, Drill, Sqoop

UI Tools: Business Objects 6.5, OBIEE, Tableau 9 & 10, Oracle Forms & Reports 6i

PM Tools: HP-PPM, Clarity, Inpensa, MS-Project

Platforms: Windows XP/10, UNIX, LINUX

CRM: Oracle 11i TCA, Service Contract, Install Base

Languages: C, C++, COBOL, Shell Scripting, SQL, PL/SQL, Java, HTML, XML, Python, R function

Other Tools: Rally, Jira, Informatica 9.6 & 10.2, SQL*Developer

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Principal Engineer/Data Analyst

Responsibilities:

• Architect and built centralized warehouse for Enterprise Cybersecurity reporting and analytical needs in Oracle, Informatica, OBIEE, Tableau, Cloud API
• Managed ECS warehouse implementation efforts from inception to reporting dashboard, working closely with Business and IT stakeholders
• Developed various ECS strategy metrics reporting for cybersecurity vulnerabilities using Vendor findings, Application findings, Penetration Testing, SSDLC, Patching, End of life, Security Training, Disaster Recovery data
• Developed various ETL using Informatica technology sourcing data from Oracle, SQL*Server (SumTotal), Cloud API (Qualys) and applying transformation rules using configurable business rules data model
• Supported various metrics prototyping development to support management ad-hoc reporting requests

Confidential, Raleigh, NC

Principal Engineer/Architect/Technical Manager

Responsibilities:

• Derive business initiatives working closely with Business and IT stakeholders on strategy and roadmap
• Managed various IT initiative, vendor management, communication and engagement with PMO and IT teams
• Managed multiple development teams on project delivery using Agile, Hybrid and Waterfall methodologies
• Led IT efforts of Tiger team on operational system issues which increased accuracy rate of service metrics from 40 to 95% with proactive and on-time publication of service rebates
• Led migration and re-architecture from Informatica/Oracle to Hadoop/Spark/Hive which improved Service Metric rebate engine processing time by 80% and reduced overall rebate payment cycle from 6 weeks to 1 week
• Designed and rolled out new self-service reporting model for business using Tableau with Apache Hive as data source using Apache SparkSQL and Drill connectivity
• Periodically reviewed SOX process and control, identified risks and issues and proactively addressed them
• Led service management measuring Cost, Risk, Quality, Speed, User Experience metrics. These metrics are reviewed quarterly in CIO service review

Project Lead

Confidential, San Jose, CA

Responsibilities:

• Managed project development effort 10-15 quarterly and monthly releases working closely with Business, Operation and IT teams to ensure business and functional requirements are delivered on schedule
• Regularly contacted core team meetings and checkpoint reviews, provided weekly status to IT management
• Individually designed anomaly handling process to check calculation issues in advance and compare weekly and monthly partner metrics to check any functional issues before publication
• Managed efforts of disaster recovery implementation to 20 critical business function under Channels portfolio, annually fail-over testing planned between data center
• Major contribution to performance tuning initiative of monthly calculation process which has bring down monthly metrics calculation duration from 15 days to 3 days, this gave feasibility for weekly publication
• Analyzed operational data, suggested and implemented B2B and automated reporting solution based on users reporting request pattern
• Defined and maintained data governance artifacts on downstream and upstream data consumption, data mapping, data dictionary and data life-cycle process

Operation Lead

Confidential, San Jose, CA

Responsibilities:

• Contact Weekly operation review meetings with IT and business team
• Implemented Oracle10g DataPump utility for customer updates from D&B, saved 36hrs of processing time
• Developed business intelligence dashboard engine which gives weekly and monthly reporting on customer and address match rate, problem areas and help in business process improvement
• Case management, root-cause analysis, system performance monitoring and long term fix on production issue

Technical Lead

Confidential

Responsibilities:

• Extensively worked on customization, interfaces and new development of Oracle forms and reports for Service Contracts and Installed Base
• Developed auto-sweep program for evergreen service contracts are automatically extended or renewed
• Design and developed custom archive and purge project which improved overall system performance, customer satisfaction and productivity
• Developed custom form to move and terminate mass service line products. Implementation helped business users can choice offline or online based on transaction volume

Confidential

Module Leader, System Analyst, Programmer Analyst

Responsibilities:

• Define process flow, data flow, functional hierarchy, and ER diagrams in Oracle Designer Repository
• Creating the required functions, procedures and packages as part of coding standards
• Developed complex dissertation search/report engine which was core to the business to generate catalogs
• Individually explored Oracle Designer tool and groomed project team members
• Developed complete project life cycle from analysis to coding in Oracle Designer
• Prepared reusable templates for Oracle Forms and Reports, and coding standards for SQL and PL/SQL
• Developed reusable business process libraries