Senior IT Data Analytics Analyst Resume Philadelphia, PA - Hire IT People

SUMMARY

To use my knowledge of data warehousing, ETL processes, and systems development life cycle methodologies to ensure that the production database is loaded on - time, accurate, and able to be modified to accommodate any changes to business needs.

TECHNICAL SKILLS

Oracle 9i
10g
Unix (AIX
HP-UX)
ksh scripting
SQL
PL/SQL
TOAD
Informatica v7.0
Autosys v3.4
Syncsort

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Senior IT Data Analytics Analyst

Responsibilities:

Managed ETL (Extraction, Transformation, and Loading) of various data into production database encompassing claims, membership, and provider information for majority of states across the nation. Implemented many script (Unix, SQL) modifications within these ETL processes supporting various business needs. Took on the role of “Production Code Controller”, which involved moving updated scripts to production AFTER saving original version of production scripts.
Primary developer responsible for the incorporation of a new type of external data into the production database, CHIP (children's health insurance program), from raw datafile layout to loading into the database.
Collaborated with team members in designing / developing modifications to the monthly ETL processes for speed, efficiency, and ease-of-troubleshooting.
Handled the occasional bug fixes with the production ETL code in a timely manner, especially when in the midst of the production database load.

Confidential, Wilmington, DE

Senior Systems Design/Developer

Responsibilities:

Supported Sales, Marketing, Commercial Analytics, Managed Markets, and Incentives & Objectives groups with project work, data loads, data extracts, and ad-hoc requests. Collaborated with customers to develop the necessary requirement, designs, timelines, etc. either for projects or for system enhancements to meet business requests. Ran production data loads for Sales Prescriber and Contract Sales (Oracle 9i, 10g databases) on various schedules (weekly, monthly, and trimesterly) using both established and new technology (Autosys batch jobs and Unix (HP-UX) shell scripts (w/embedded SQL) and Informatica, respectively) as ETL methods. Performed data validation after these production loads; analyzing and cleansing input data files, checking data tables and/or scanning for log file inconsistencies. Jointly responsible for developing several ‘tools’ for aforementioned business departments by handling database aspects (creating report-specific tables/indexes) and working closely with front-end developer(s) assigned to these various projects. (Used a combination of shell scripts (w/SQL), Autosys and/or Informatica to automate data feeds and calculations required for these reporting ‘tools’). Depended upon for adherence in these reporting tools to ever-changing needs of marketing analysis strategies. Developed and tested all required table/report modifications.
Performed ad-hoc query generation, data exporting for business customers, external data vendors, etc. using shell scripts w/SQL to dump requested data in specific formats.
Used PL/SQL to implement logical row-based processing for certain data requests where appropriate.
Automated (via either Informatica or Autosys) any data extracts after determination was made that these data pulls would be recurring events.
Self-taught basic operating procedures of TOAD database tool for quicker and easier query issue resolutions.

Confidential, Wilmington, DE

Consultant / Team Lead

Responsibilities:

Team Lead at client site, AstraZeneca, overseeing and lending support to FCG consultants placed at client site. Technical Lead, National Evaluate project, dividing time between supervising and assisting team members with tasks, as well as performing own coding responsibilities. Project requirements consisted of developing and supporting enhancements to Xponent Prescriber and Xponent Specialty database loads to facilitate future growth (new brands, markets, etc.). Primary support for aforementioned monthly database loads.
Assisted in coding phase with several multi-dimensional database projects; developing and testing UNIX scripts, SOL scripts, and Autosys batch scripts.
Original FCG consultant at client site; responsibilities increased (to Team Lead) as number of FCG consultants grew at client site.

Confidential, Conshohocken, PA

Application Developer / System Administrator

Responsibilities:

Responsible for complete software development lifecycle for several classified database functions, including backup/restore, save/use query, merge tactical summary, and message generation.
Wrote ProC code to extract data from database (Sybase) as application developer.
As system administrator, diagnosed and resolved system and network problems, performed daily maintenance of four Sun 4/330 and two HP 9000/700 machines (networked via Ethernet), and created system changes/installation tape that configured all servers at initial reload to install database partition disk drives, etc.

We provide IT Staff Augmentation Services!

Senior It Data Analytics Analyst Resume

Philadelphia, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship