PROFESSIONAL SUMMARY:

• Over twelve - year, hands-on, IT professional expertise in business scope definition, business requirements gathering, functional design, extensive data analysis, data definition, data cleansing, data mapping, ETL (Extract-Transform-Load), ERD (conceptual, logical & physical models), reports development (ad-hoc, canned & weekly/monthly generated reports), project technical documentation, end-users training, support & trouble-shootings and applications maintenance.
• Successfully designed and modified many relational databases’ ERD models (logical & physical) for new and existing applications including legacy systems conversion and participated in dimensional modeling (star & snowflake designs)
• Extensive experience in getting directly involved with the development and upgrading of various RDBMS (Oracle, SQL, FOXPRO & PC/FOCUS)

EXPERTISE / KNOWLEDGE:

• Business scope definition
• Business requirements gathering
• Functional design
• Data analysis
• Data profiling
• Project documentation
• ETL (Extract - Transform-Load)
• ERD (conceptual, logical & physical)
• Project technical documentation
• Legacy system conversion
• Complex data reports development
• Relational databases
• Dimensional modeling
• (star & snowflake schemas)
• BI (SSIS, SSAS & SSRS)
• SQL DB
• Oracle DB
• SQL & PL/SQL
• SQL* Loader
• PC/FOCUS
• FOXPRO
• ASP.NET
• Cold Fusion
• MS Visio

KEY SKILLS AND COMPETENCIES:

• Strong analytical & critical thinking
• Excellent organizational & interpersonal skills
• High attention to details
• Perform well in a pressurized time sensitive environment
• An excellent problem solver
• Effective written & oral communication
• A self starter, a fast learner

WORK EXPERIENCE:

Data Analyst / SQL Developer

Confidential

Responsibilities:

• Conducted business process definition and business requirements gathering
• Performed data definition, data analysis, data population and ERD designs (conceptual, logical & physical)
• Coded website data reports using SQL

Confidential

Reports Developer

Responsibilities:

• Analyzed & validated company’s existing healthcare system’s ERD
• Conducted business needs analysis and business requirements gathering
• Performed data definition, data analysis, data cleansing, data validation and data population (ETL)
• Conducted end-users meeting sessions in defining business process scope and gathering business requirements
• Coded numerous data reports using PL/SQL & SQL
• Worked closely with management in producing many customized reports per clients’ special requests by identifying key data requirements and integrating them from multiple data sources

Confidential

Programmer Analyst

Responsibilities:

• Participated in business scope definition and business requirements gathering
• Performed thorough data analysis, data definition, data uploading & table (data) population
• Designed ERD
• Delivered end-users training and on-going system support
• Facilitated end-users meeting sessions in defining business process scope and gathering business requirements
• Performed data analysis, data cleansing, ETL & data validation
• Extracting Documentum data necessary for custom reports creation
• Successfully translated business needs to detailed development specifications
• Incorporated numerous pre-scheduled & pre-run Oracle Reports (in .rdf format reports, using Confidential & Confidential jobs and Confidential shell script file) and other required Adobe Acrobat .pdf files
• Provided application training to supporting staff, post system maintenance, trouble-shooting and end-users support

Confidential

Responsibilities:

• Coordinated with the former 4-D DB owner, IT infrastructure personnel in determining its technical & business requirements
• Successfully designed ERD (conceptual, logical & physical models)
• Performed data analysis, data mapping, ETL, data validation

Confidential

Responsibilities:

• Designed many mini-databases extracting data from Confidential twisting system logic to produce numerous essential “horizontal data” custom reports
• Coordinated with Estimating & Pricing liaison to determine new business requirements and incorporated those data into Confidential
• Released numerous Confidential versions to reflect major accounting data updates and system logic changes
• Updated data (rates and bid factors) using flat files on a frequent basis
• Coded numerous canned, generated & distributed ad-hoc data reports in support of department’s needs and management’s special requests during proposal bidding process
• Performed system testing, deployment, trouble shooting, proposal set-ups, supporting staff training and direct end-users support

Confidential

Responsibilities:

• Played a role as one of the key-personnel in deploying Confidential for Long Beach division
• Participated in meeting sessions with cross functions, managers and supporting staff identifying business needs, procedures & processes
• Coordinated with Seattle and Long Beach IT infrastructure team in testing and implementing Confidential in different Windows environments (i.e. Win95, Win2000 & WinNT)
• Composed Confidential integration process manual
• Assisted end-users during installation process