CAREER SUMMARY:

• Proven expertise in data modeling, data analysis, and database programming in SQL, PL/SQL.
• Excellent communicator, coordinator, and team player.
• Experience in complex database application development, integration, maintenance, and support in both transactional (OLTP) and Business Intelligence systems (OLAP).

TECHNICAL SKILLS:

• Data Governance, standards, and guidelines
• PL/SQL, SQL programming and tuning
• Data analysis
• Data mapping
• ELT
• Waterfall, Agile, Scrum, Kanban, LEAN, Pair Programming, Test Driven Development (TDD)
• Unix, Linux
• MS Windows
• Mac OS
• CA ERwin
• SQL Navigator, SQL Developer, TOAD, DBArtisan
• Informatica
• Decision Point Administrator
• Oracle Designer/Developer/Reports
• Crystal Reports
• Hyperion Brio
• Cognos
• Oracle 11g/10g/9x/8x/7x
• MS Access
• Mongo DB
• Cassandra
• SQL
• PL/SQL
• Unix shell scripting
• HTML
• SQL, Cassandra CQL, Mongo query
• C/C++, Java, Python, Node.js
• XML, Json
• Emacs text editors
• AWS Cloud (EC2, S3)
• SQL*Plus, SQL*Loader
• Curl, Cron
• MS Office applications
• PVCS, VCS, SVN
• Postman REST client
• UML, RUP

EXPERIENCE:

Confidential

Senior Data Engineer

Responsibilities:

• Coordinated and collaborated with Web Application Engineers, Business System Analyst, Product Owners, Database Administrators and the external source teams to implement data migration strategies and programs to import Consumer data from Hurley, Converse, Confidential Brazil, Confidential Australia, and Confidential Factory Store systems. Analyzed the sample source data, created data mapping logic to clean and transform the source data into the required values and format, developed PL/SQL scripts based on the data mapping logic to extract the data from staging area into the production transactional Oracle database. Collaborated with Web Application Engineers, created Python scripts to load the data into AWS Cloud Cassandra database.
• Analyzed and resolved web service operational and consumer data issues using SQL scripts for data extraction.
• Supported Confidential Product Launch events during the off - business hours on a team rotational basis, monitoring the application performance and resolving any issues that occurred during the Launch window.
• Created operational and analytical reports. For reports to be published on a regular scheduled basis, implemented Cron jobs to execute SQL scripts, generate the reports, and deliver to the customers by email.
• Provided information to external teams regarding Consumer data and Identity and Access Management web services.
• Collaborated with a Java application engineer to develop a data validation program to ensure data consistency between Oracle database and the newly created AWS Cloud Cassandra database.
• Analyzed data discrepancies between several source systems. Proposed technical strategies to resolve and fix data issues and implemented the technical solutions based on Product Owners’ decisions and business data requirements.

Senior Data Engineer

Confidential

Responsibilities:

• Reverse engineered Product Catalog (PCAT) physical data model from Oracle database. Analyzed the actual data, corrected and completed detail information for the physical data model, created logical data model, and published the data model on the department’s intranet portal. Presented the data model to the application engineering team.
• In a project to replace the existing product data system, created staging and operational layer data models and database objects for a new schema to source product data from Confidential (EBI) Teradata database into Digital Consumer Technology, Product Information Oracle database. Analyzed the data, created source-to-target data mappings, and implemented SQL scripts with business and data transformation logic for the data extract, transform, and load (ETL) engineers. Validated the data loaded to staging and operational layers. Collaborated with the EBI Production Support team to resolve any data load issues.
• Created product information data mappings and SQL scripts with business logic and data transform to be used in the ETL jobs for Confidential product information data feed for Confidential product recommendation business partners, such as Certona.
• Provided expertise in data analysis, Oracle database, SQL and PL/SQL programming. Assisted other Java application engineers with SQL coding, tuning, and debugging. Assisted the Database Administrators with troubleshooting and resolving any data and system issues.
• Collaborated with other data modelers in the department, providing peer reviews, recommendations, feedback, and knowledge sharing.
• Created a Unix shell script program for the Database Administrators (DBAs) to automate database script deployments, to simplify Production release process, and eliminate the formerly required error-prone manual steps.

Senior Data Engineer

Confidential

Responsibilities:

• Reverse engineered and created physical data model for Confidential Oracle source database. Created conceptual and logical data models to highlight important business data domains: Consumer Profile, Social, and Multiple Sport Platform ( Confidential Plus).
• Led a team of application developers and multiple software vendor engineers in a Proof of Concept (POC) effort to select a new data repository technology platform to consolidate data from multiple existing transactional systems. Coordinated and communicated to ensure all parties agree on the direction and methodology for the project. Gathered and provided key information and statistics proving the criticality of the issue to gain resources and support from the product owners and stakeholders.
• Collaborated with Data Architects, Subject Matter Experts, and Application Engineers in designing logical data models for the following subject areas: Events, User Experience, Consumer Data Privacy Preference, and Open Authentication (OAuth). For each of the business subject area, created a physical data model from the logical data model, generated a DLL script, and created database objects in Oracle database.
• Created PL/SQL packages to be called by Web Application to process and store data for Consumer Data Privacy Preference.
• Participated in Data Modeler and Data Engineer teams to develop the department data modeling, database object naming standards, and PL/SQL coding standard and best practice guidelines.

Senior Data Modeler

Confidential

Responsibilities:

• As a lead data modeler, designed, maintained, and published conceptual, logical, and physical data models for Product Line Plan transactional system, adhering to the industry best practices and Confidential Corporate data management and governance standards and guidelines.
• Created Product Line Management XML schema, deriving from the transactional system physical data model, for external system integration.
• Created, maintained, and published Product Line Plan Management external data model. Collaborated with Confidential team in data provisioning effort to get the data from Product Line Plan Management system to the Enterprise Information System (EIS).
• Led a team of subject matter experts (SMEs), business consultants, and application engineers in Corporate Data Management, including Data Governance and Data Alignment processes. Coordinated the team and facilitated the discussions to define and revise Footwear, Apparel, and Equipment Product Line Plan data definitions and abbreviations, achieving a shared-understanding of Confidential business terminology among the different departments within Confidential .
• Collaborated with the business partners to gather business data requirements. Designed and developed initial data models for Product Catalog Management and Mine the Margin projects.
• Performed as a liaison representing the Global Product Integration (GPI) team to the Confidential Planning Department in the Planning Foundation project. Managed the Planning IT partners’ expectations by providing resource availability, solution implementation plans, and proposed and negotiated a workable timeline for defect prioritization decisions. Coordinated the resources, release activities, and timelines with the Planning IT partners.
• Managed defect resolution process for the Planning IT data integration from the Customer Database (CDB) system to the Enterprise Information System (EIS). Coordinated multiple teams, including Global Product Information (GPI), Planning Information Technology (Planning IT), Confidential (EBI), and Integration Control Center (ICC) to track and resolve the defects. Communicated technical requirements and business impact explanations to keep all teams on the same page in the implementation plans and timelines.
• Investigated and analyzed data issues and defects to determine the source for the defects within the integrated systems and assigned the defects to the responsible team.

Senior Business System Analyst

Confidential

Responsibilities:

• Led a Proof of Concept (POC) effort and coordinated cross-functional teams, including application engineers, database administrators (DBAs), and business system developers to define the methodology, business process, and technical steps to get data from a newly developed Product Development Management system into the Decision Support System.
• Led a team of Cognos report developers and planned activities and timelines to demo Cognos reporting software usage and functionalities to the business partners.
• Developed SQL codes to generate test data in Oracle database for Report Developers to use.
• Collaborated with application engineers in creating and validating SQL logic to create integration views (for the downstream systems to use as a source for data consumption) in a consistent standardized format with correct and complete business logic, and easy to use by combining data from multiple tables (data denormalization) when it made logical sense.
• Led and coordinated the Production Support team and the downstream systems’ application engineers to clean up the Product Data Management database, divesting the obsolete database objects and removing obsolete log data. This initiative reduced over 10 percent of data issues and system errors that took up production support and system maintenance time and recovered sizable database storage space.
• Mentored new team members and contractors in on-boarding process, going over production support, functional and system knowledge, technical tools, procedures, and processes, which helped them to quickly get up to speed.
• As an Architecture Core Team member, organized a forum to socialize Software Development Life Cycle (SDLC) governance and facilitated discussion among multiple Business Intelligence teams to align process and practice with the governance.

Senior Data Modeler

Confidential

Responsibilities:

• Led a team of subject matter experts (SMEs), business partners, and application engineers to define, gather, and analyze business and system data requirements for Apparel, Footwear, and Equipment Material and Supplier.
• Designed, developed, maintained, and published conceptual, logical, and physical data models for Footwear, Apparel, and Equipment Material Management, Supplier Management, and Production Integrity Decision Support System, adhering to the industry best practices and Confidential Corporate data management and governance standards and guidelines. Generated DLL scripts and collaborated with the database administrators to create Oracle database objects for the Decision Support System.
• Created and updated a data modeling play book with data modeling processes and lessons learned from each project to ensure process improvement in subsequent projects.
• Designed and created a web portal to publish Confidential Decision Support System data models, data dictionary, documentation, and Brio reports.
• Collaborated with business Subject Matter Experts (SMEs) to gather the business reporting requirements. Designed, developed, and published integrated operational and analytical reports in Hyperion Brio.
• Developed Informatica ETL mapping and tasks to extract, transform, and load Apparel and Footwear Material Management data from the source transactional systems to the Decision Support System.
• Worked with Database Administrators (DBAs) and a team of application developers to forecast Decision Support System storage needs for upcoming projects. Created a storage and performance monitoring process.
• As a Confidential Business Intelligence System Content Lead, represented Confidential, Decision Support System (DSS) team and contributed to the development of Confidential Global Business Intelligent Software Development Lifecycle (SDLC) process.

Confidential

Application Developer and Implementer, Engineering

Responsibilities:

• Designed and developed DPA auto-configured data warehouse logical concepts, star schemas and metadata for Oracle Financial Applications, Siebel Sales, Siebel Call Center and Service, and Clarify Customer Relationship Management (CRM) business domains.
• Consulted, analyzed, and designed customized data warehouse solutions to fit customer specific business information needs.
• Performed extraction, transformation, and load (ETL) data between data warehouses.
• Implemented DPA data warehouses for customers both on site and remotely.
• Developed data warehouse software tools and infrastructure.
• Created validation strategies, validation reports, business reports, implementation guides, and documentation for DPA warehouse.
• Worked with the Customer Support team and customers to solve Oracle Financial Application data warehouse data and technical issues.
• Tested the software applications and reviewed training material and documents for DPA software products, including DPA Web Analyst (web-based reporting tool), DPA DecisionCast, and DPA data warehouse
• Developed a demo data warehouse for the DPA Sales department.

Confidential

Business System Analyst

Responsibilities:

• Worked with users in gathering, analyzing, and setting financial application requirements.
• Developed transactional software/application solutions.
• Automated and simplified financial processes for Oracle Financial Application General Ledger.
• Acted as primary support and administrator for the Essbase, an OLAP Decision Support System for enterprise financial data.
• Developed new Essbase applications and databases for Currency Conversion module.
• Troubleshot various applications and worked with vendors and other IT support to maintain and develop the system.
• Supported and assisted business users in using the Infonet, the financial reporting intranet web portal.

Confidential

Applications Developer/Analyst

Responsibilities:

• Developed, integrated, and managed the Customer Fulfillment Information System Intranet page.
• Improved and maintained the Customer Data Warehouse (CDW) data auditing process.
• Analyzed and resolved data quality issues and system errors.
• Developed and supported order and sales batch data feed from Data Warehouse to Essbase OLAP.
• Mapped and migrated data between business transactional systems to the data warehouse.
• Developed data extraction, transformation, and load jobs (ETL), sourcing data from both flat files and transactional systems.
• Developed reports in Oracle Reports 2.5 and Crystal Reports.
• Participated in fire call production support for Customer Data Warehouse. Analyzed and resolve data and system errors that occurred.
• Created and maintained Customer Data Warehouse performance statistic graphs and process using Oracle Graphic Designer.