SUMMARY

• An accomplished Information Technology professional with over 16 years of comprehensive experience in Data Analysis, Data Warehousing, Report Development, Programming Development and Technical Support.
• An understanding, innovative individual who has an excellent sense of teamwork by collaborating with non - technical and technical clients.
• Strengths include solid communication and problem-solving skills and adapting to change.

TECHNICAL SKILLS

• SQL
• Tableau
• Teradata
• MicroStrategy
• Oracle
• Crystal Reports
• SQL Server
• Microsoft Access

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL Reporting Specialist

Responsibilities:

• Develop and maintain operation reports and metrics that support Key Performance Indicators (KPI). Undertake ad-hoc queries and short term data and analytic projects to meet business application needs including systems testing and data validation.
• Prepare files and reports by appending data, deduping files, merge/purge functions, and data extraction.
• Compile and validate federal and state reports and submit those to requesting entities.

Technologies Used: Oracle, SQL Server, SQL, Toad, ETL, Microsoft Access, Microsoft Excel, Trizetto QNXT

Confidential, Los Angeles, CA

Data Analyst

Responsibilities:

• Analyzed campaign performance by reporting on key business metrics and develop insights through customer analysis. Maintained reports that measure trends and key business metrics such as household growth, cross-sell and profitability.
• Utilized campaign management application to develop and report on complex campaigns for multi-channel marketing.
• Developed Business Intelligence report transition from MicroStrategy platform to Tableau utilizing custom SQL.
• Write custom SQL that takes marketing campaign definitions, rules, selection criteria and enabled execution through Teradata.

Technologies Used: Tableau, MicroStrategy, SQL, Teradata, Teradata SQL Assistant, Microsoft Access, Microsoft Office

Confidential, Los Angeles, CA

Data Analyst

Responsibilities:

• Analyzed campaign performance by reporting on key business metrics and develop insights through customer analysis. Maintained reports that measure key business metrics such as household growth, cross-sell and profitability.
• Created ad-hoc reports and migrate existing Excel reports to Business Objects MicroStrategy environment.
• Write custom SQL that takes marketing campaign definitions, rules and selection criteria and enables execution through Teradata.

Technologies Used: SQL, Teradata, MicroStrategy, Microsoft Access, Teradata SQL Assistant, SQL Server 2008, Microsoft Office

Confidential, Ontario, CA

Reports Analyst

Responsibilities:

• Administered Business Objects Enterprise Central Management Console, Windows Active directory, Kerio Mail Server, and IBM iSeries Server. Analyzed and consolidated reports for major reporting software upgrade.
• Migrated reports from Crystal Reports 9 Enterprise to Crystal Reports 2008 Enterprise.
• Developed and customized reports using Crystal Reports 2008 Enterprise.
• Deployed new computers to users and maintained user access and security.

Technologies Used: Crystal Reports Enterprise, CommercialWare, Active Directory, IBM iSeries, SQL, Kerio Mail Server, SQL Server 2000/2005, Microsoft Office, Windows Server 2000/2003.

Confidential, Long Beach, CA

Programmer Analyst

Responsibilities:

• Delivered product customizations and integrations for Infra Corporations service management product infraEnterprise by writing code using structured methods using leading edge web development environments.
• Developed SQL queries, stored procedures, functions, and triggers in Oracle 10g and SQL Server environments.
• Wrote custom SQL and JavaScript to modify the base application to suite the customer’s specific business requirements.

Technologies Used: SQL, JavaScript, HTML, SQL Developer, CSS, SQL Server 2000/2005, Oracle 10g, Crystal Reports, Microsoft Office, Windows Server 2000/2003.

Confidential, City of Industry, CA

Reports Analyst

Responsibilities:

• Analyzed company’s reporting repository consisting of Oracle Reports, Crystal Reports, and Microsoft Access Reports. Collaborated with development team to identify reports which needed to be modified for major system upgrade. Wrote specifications for each report detailing how the report will be modified and created documentation.
• Developed SQL queries, stored procedures, functions, and triggers in Oracle environment.

Technologies Used: Oracle 8i, Oracle Reports 6i, SQL, Crystal Reports, Access, Visual Basic, Microsoft Office

Confidential, Long Beach, CA

Programmer Analyst

Responsibilities:

• Designed, development, and implementation of re-engineering the Market Area Report System by increasing code efficiency and reducing runtime to produce monthly reports.
• Created, modified, and maintained Oracle 8i relational database systems.
• Developed SQL queries, stored procedures, functions, and triggers in Oracle environment.

Technologies Used: Oracle 8i, SQL, Access, Visual Basic, VBA, Oracle Suite, SQL Navigator, Microsoft Office

Confidential, Costa Mesa, CA

Data Analyst

Responsibilities:

• Performed consulting, specification review, program coding, technical analysis, and problem resolution in a multi-tasking pro-active fashion to help drive solutions for clients.
• Contributed in making fiscal year department goals by decreasing average project completion time and increasing revenue.

Technologies Used: MVS, TSO, JCL, IBM Mainframe, DB2, SQL, DB2, SAS, Easytrieve Plus

Confidential, Los Angeles, CA

Programmer Analyst

Responsibilities:

• Performed program development, maintenance, modifications of customized Budgeting application. Developed, maintained, modified, and tested programs and online applications for Y2K compliance.
• Developed SQL queries, stored procedures, functions, and triggers in Oracle and SQL Server environments.
• Performed installation, DBA support, maintenance, modifications, database design, database exporting and importing, developed front-end Oracle forms, and provided technical support for Oracle 7.3/8i.

Technologies Used: SQL, Oracle 8i/7.3, PL/SQL, SQL Server, Access, DB2, Visual Basic, Crystal Reports, Oracle Forms & Reports, COBOL, JCL, CICS, MVS, TSO, QMF, AIX, Windows 2000 Server