Sr Programmer/ AnalystÂ Resume

SUMMARY:

Highly accomplished and creative report developer with deep experience in all aspects of software development. Excellent analytical skills. Detail oriented. Well regarded for interpersonal, written and verbal communication. Effectively handles multiple tasks simultaneously. Works well independently and as a team member.

TECHNICAL SKILLS:

Actuate 7.1
Agile
Crystal 10.1
Microstrategy 9.0
Oracle 10 g
PL/SQL
Web Intelligence 10
UNIX C Shell
MS Office
SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Roseville, MN

Sr Programmer/ Analyst

Responsibilities:

Develop dashboards and visualizations using SQL Server.
Developed comparative dashboard, which compared purchase dollars and quantity, across different timelines.
Developed overall dashboard, which looked at drug classes, branding, unit price, and metric calculations.
Developed discrete dashboard, which showed dollar expenses and drug purchases, over daily and monthly timeframes.
Performed report optimization testing.
Primary support for production issues.
Worked in an agile setting.

BI Developer

Confidential, Bloomington, MN

Responsibilities:

Developed dashboards, reports, templates, and visualizations using Microstrategy.
Developed and supported queries using PL/SQL for development, unit testing, and analysis.
Creation of metrics, attributes, filters, prompts, cubes, transformations, and hierarchies. Created advanced chart types, visualizations and complex calculations to manipulate the data.
Developed Quote Statistics dashboard using Confidential . This dashboard helped our marketing team determine the different part numbers each client was quoted, and which part numbers the client purchased.
Developed Profit Ratio dashboard using Confidential, which included pie charts, heat maps, and graphs to illustrated sales across regions, countries, and clients.
Reverse engineered Spotfire Dashboard into a Microstrategy Dashboard for Market Intelligence reporting. This dashboard showed part numbers, along with Digi - key’s price and our competitor’s price per part.
Interacted closely with clients, technical teams, and stake holders to evaluate their specifications and requirements to meet deadlines and stay within budget.
Wrote and revised business requirement documents with clients, technical teams and stake holders until sign-off was obtained.
Worked in an agile setting, which included release planning, sprint planning, sprint review, and retro meetings.

Sr Programmer/ Analyst

Confidential, Minnetonka, MN

Responsibilities:

Developed and supported reports using Crystal and Actuate.
Developed and supported queries and stored procedures using PL/SQL for development, unit testing, and analysis.
Wrote specs and documentation to go along with programs.
Developed over 30 universes using Web Intelligence.
Developed trigger file scripts using UNIX C SHELL for Fulfillment Transmission reports.
Primary support for production environment, including user setup, security, scheduling, and client profile setup.

Sr Programmer/ Analyst

Confidential, Bloomington, MN

Responsibilities:

Developed programs, scripts, reports, and menus using Informix, PL/SQL, COBOL, DB2, Actuate, UNIX C SHELL, and Oracle.
Primary support for Actuate environment, including user setup, security, scheduling, and client profile setup.
Participated in on-call rotation.
Performed project management tasks for most projects.
Wrote specs and documentations to go along with programs.
Developed over 100 Actuate reports for load process, manual entry, and system performance.
Developed Archive/Delete scripts for databases using UNIX C SHELL, and Oracle.
Developed Standby Database platform for system performance and disaster recovery.
Developed Member Load Process using COBOL/JCL/DB2 to load member information from a client file to our mainframe database with member eligibility checkpoints as part of the load process to ensure eligibility accuracy.
Developed Member Term Process using COBOL/JCL/DB2 to term members that are not on the clients input file to avoid providing benefits to ineligible members.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship