SUMMARY:

• Build and scale data infrastructure that powers batch and real - time data processing
• Streamline data into Data lake.
• Develop and implement best practices ETL Processes
• Work effectively with scrum in Agile Methodology.
• Perform production support.
• Expertise in UNIX/Linux and scripting skills, shell, Perl, Python, etc.
• Strong Database knowledge and experience: MySQL, Teradata and Oracle. Ability to write complex SQL

TECHNICAL SKILLS:

Skills/Tools: AWS Cloud Ops, AWS CLI, DATALAKE, MySQL, GIT, SOAPUI, XML, XSLT, HTML, SOAP/REST, JSON, AGILE METHODOLOGY,AB INITIO ETL TOOL, AUTOSYS, TIDAL, TERADATA UTILITIES, BTEQ, ORACLE, SQL/PLUS, UDB/DB2, SQL SERVER, PYTHON, SHELL SCRIPTING, TOAD, TD TOOLS, PERFORCE, TIDAL, SQL ASSISTANT, HP QUALITY CONTROL, CLEARCASE/CLEARQUEST, AWK/SED SCRIPT, TABLE BASE, MAINFRAME DB2, C/C++, IBM 370/390 C/C++, MS SQL SERVER, JAVA, JDBC, J2EE, VISUAL BASIC (MTS, COM/DCOM, ADO, RDO), INTERACTIVE, ERWIN, CRYSTAL REPORT, SQL, IBM ASSEMBLER, COBOL, PASCAL, BASIC, LOTUS NOTES, WORD, EXCEL, LOTUS 1-2-3, POWERPOINT, WINDOWS NT, WINDOWS 98, WINDOWS 3.X, UNIX, LINUX, TSO, JES2, CA-VIEW, FILEAID, ENDEVOR, JCL, UTILITIES, VSAM, CLIST, CA-EASYTRIEVE,REMOTE DESKTOP MANAGER

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Staff Software Engineer in Test

Responsibilities:

• Working with Agile Methodology using AWS Cloud Technology. Expertise in Cloud Automation using Perl, Python and expertise in shell scripting. Have defined and completed automation framework of new applications/projects starting from scratch.
• Expertise in design and development of Data Integration programs, maintenance, enhancement design and implementation, upgrades, testing, performance tuning and optimization.
• Experienced in creating test infrastructure/framework from the ground-up.
• Having deep knowledge and clear visions in Software Development/Test Life Cycle. Defined Test Strategy clearly for every test effort.
• Applying analytical and problem-solving skills to clarify user stories and determine appropriate testing scenarios. Validate the iterative development of products against functional and technical specifications.
• Working closely with Product Owner to define User Stories to support new system features
• Automating batch scripts to validate batch job results
• Conducting functional, regression and integration testing for GUI, Batch and Backend processes
• Log, track, and verify SW defects resolution. Conduct a full defect life cycle
• Strive for maximum requirements coverage via SOAPUI test suites and test cases
• Develop and execute test plans, test cases and test scripts to support Agile delivery team, Blackhawk Network Next Generation
• Develop, coordinate and conduct test plans to support end to end test efforts
• Proactively identifies issues and acts upon them by owning an issue to its resolution
• Consistently ensures that all tests are conducted and documented according to Blackhawk standards
• Coaching and guiding junior Test Engineers and DevOps Engineers.

Confidential, Foster City CA

Lead Data Engineer/Lead Test UI/ETL Engineer

Responsibilities:

• Certified Agile Methodology, successfully deployed many projects which applied Agile Methodology
• Successfully rolled out Unica Product at Confidential to support many Confidential Loyalty Campaigns
• Successfully rolled out Confidential Payment Control (VPC) program for Commercial Card Program
• Coordinating/supporting many UAT and E2E test efforts
• Testing Ab Initio ETL Confidential Data Service Application.
• Testing ETL Processes that load data into data warehouse Hadoop
• Testing and coaching resources to Micro Strategy reports
• Coaching and working with off-shore QA Analysts on Confidential Control Payment System
• Developing Unix Korn Shell Scripts to generate/fabricate large datasets to simulate production volume to support performance testing
• Creating shell scripts to load data into database to support downstream application functional tests
• Developing Unix Korn Shell Scripts to validate data through functional and regression testing.
• Analyzing business requirements and ensure that off-shore resources cover all requirements and use cases on test cases
• Managed consultants to define automation frameworks to support Regression efforts

Confidential, Foster City CA

Development/Global Open Systems Developing

Responsibilities:

• Testing Ab Initio ETL Confidential Extras Application.
• Coaching and working with off-shore QA Analysts on Confidential Extras Project
• Developing Unix Korn Shell Scripts to validate data through functional and regression testing.
• Understanding a large data-warehouse (150 TB) system architecture, including ETL tools, SQL scripts, subject-area business logic and reporting UI tools
• Analyzing business requirements, create test plans, environment setup requirements, feature and integration test cases
• Planning and coordinating cross-team cross-functional integration testing efforts

Confidential

Lead Data Engineer/Lead Ab Initio Developer

Responsibilities:

• Developed scalable and reusable ETL Ab Initio processes which used Teradata load/unload utilities: FASTLOAD, MLOAD, PT LOAD and TPUMP. These generic processes worked effectively and reduced/eliminated lots of development cycles
• Performed tuning many ETL Ab Initio load processes to ensure effectiveness, accurately and meeting SLA.
• Worked with Business to understand the requirements in detail and come up with a solution approach in full development cycle
• Accountable for data integration, implementation and maintenance product development and enhancements.
• Profiled data to ensure that Teradata tables were indexed ensure data distribution to avoid data screw
• Partitioning Teradata tables properly to improve queries performance and avoid unnecessary full table scanning.
• Working on Oracle to Teradata Migration Projects. This project is high visibility and on the fast face and I had managed to meet all project deliverables
• Produced deployment documents in detail so QA and release manager can conduct production deployments
• Production support to ensure data loads met morning SLA

Confidential

Lead ETL Developer Consultant

Responsibilities:

• Supported Actimize Application: provided Actimize Vendor data for model tuning, testing Actimize
• Vendor code, supporting Production Support Group on Actimize staging, testing, coordinating many Actimize production deployments
• Performing Actimize maintenance from end to end on regular releases.
• Worked on In-session Risk Scoring (IRS): developing IRS using Abinitio ETL Tool, Unix Shell script, Autosys and Oracle Database.
• Experienced in loading and processing of large data sets
• Migrated Actimize Project to real-time platform had saved Confidential Bank lot of money

Confidential, Foster City CA

SW/QA Engineer

Responsibilities:

• Experienced with Large Database Design and large transactional database/data warehousing
• Knowledge of best practices in the areas of application design, performance, scalability and maintainability.
• Architected Ab Initio ETL Chip Subscription extracted, stored and aggregated Confidential Chip data transactions then loaded into the Data Warehouse. This project was deployed in production successfully, on time and met all user’s requirements
• Architected Ab Initio ETL Global Merchant Chargeback Monitoring Program Subscription using ETL exacted, stored and aggregated Confidential Chargeback transactions then loaded into the Data Warehouse. This project was deployed in production successfully, on time and met all user’s requirements
• Developed Unix Korn Shell scripts to compare data in many migrations from legacy system to new platform using Ab Initio ETL Tool, Unix and Ab Initio Corp System upgraded
• Documented ETL transformation rules on Confidential Common Master Log System Global for Authorization and Clearing and Settlement Data
• Experience in loading and processing of large data sets
• Project Leader of Sears Retail Sale Reporting System:
• Developed and maintained a database of accounting applications using DB2 Mainframe and CICS
• Implemented several programs for reporting purposes\
• Maintained Production support for Sears Sale Reporting System Technical Lead for a group of seven developers