yyyyyy x. yyyyyy                         250 clara street #0000 xxxxxx xxxx , xxxx , xxxxx 00000

(xxx-xxx-xxxx                                                                                                                             abc@xyz.com

objective

solutions-focused information technology professional with expertise in deliverable data warehouse management, data integration and business intelligence eager to contribute technical expertise as well as dynamic project management and operational enhancement abilities in a senior it project management assignment.

career profile

ø  12+ years of team and technical project management experience.

ø  relevant education and professional development.

ø  skilled in oversight of project-integrated database tools.

ø  extensive background in all facets of deliverable data warehousing, data integration and business intelligence.

ø  adept in mentoring and supervising large-scale staffs.

ø  proven capacity in system/data analysis and design work.

ø  strong ability in informatica, pervasive data integrator, business objects, crystal reports, microstrategy and erwin.

ø  upcoming pmi certification.

ø  maintain current knowledge of emerging technologies/tools and adept in rapidly acquiring new skills.

ø  experienced manager of data warehouse systems and application development.

ø  deliver decision support systems for c-level management.

ø  oversee sql server operational team converting manual scripts to automated pervasive data integrator etl routines.

ø  successfully create data marts, extract data for third party vendors and convert reporting to new systems.

ø  effectively revitalize broker branch offices (hardware and software) and build various client server applications.

ø  launch intranet data warehouse data dictionary web sites.

ø  initiate alternative billing applications.

ø  develop and project lead executive decision support reporting systems.

ø  enable senior management to perform revenue/cost analysis savings.

technology skills

ibm 3090, mvs operating system/jes2, pc s, unix (hp & sun), microsoft windows servers, jcl, sar, sas, sql (teradata, informix, sql server, oracle), ucc7, roscoe, tso, ispf, cobol, delphi, pervasive, powersoft products, microsoft office suite, visio, microsoft project

professional experience

lifemasters, south san francisco, ca                                                                                          2006 - 2008

senior manager client data integration/data warehouse manager

       recruited to oversee five terabyte operational health care data warehouse containing membership/provider data, medical, pharmacy and laboratory claims.

       supported and reported to cio for 1.5 years.

       spearheaded etl design initiatives saving 15 man days per month by streamlining and re-engineering manual data loading processes.

       slashed staff requirements from 17 to six data analysts by selecting/acquiring pervasive etl software (java based).

       utilized eight new client/adapted systems to accept and send hipaa industry standard file formats.

       lowered client data integration project time line from 90 to 45 days by leveraging previously built automation.  

       supervised staff of 15 with etl programming team, data analyst team and systems analysts.

       developed architecture for etl data loading automation using pervasive software.

       conducted in-depth data/systems analysis covering reviewing scripts and stored procedures.

       initiated project plans, status reports and issue tracking.

       effectively led status meetings and vendor calls.

       coordinated closely with business and technology groups to develop technical design, requirements and alternatives.

       orchestrated projects to develop analytical data marts for departmental reporting groups.

       managed data loading of over 250 files per month.

       utilized industry-standard hipaa file format (834, 837, ncpdp and hl7), most in proprietary formats.

       administered data extraction for sending files to external vendors using hipaa formats.

       launched systems to track data quality results from over 300 unique tests.

       delivered updates to all levels of senior management.

       environment: microsoft sql server (5 terabytes) & reporting services, ms project , pervasive etl tool (etl and data quality), microsoft sharepoint, microsoft office, hl7, xml,  834, 837 (i & p), ncpdp

 

yyyyyy x. yyyyyy, page two

 

accenture technology solutions (kaiser), oakland, ca                                                                 2004 - 2006

senior systems analyst

       retained to serve in project manager role while on assignment at kaiser.

       led staff team in analysis of report conversion from legacy systems to epic/clarity data warehouse.

       successfully performed system analysis and developed specifications for over 100 reports.

       facilitated training of data stewards in report generation using crystal reporting against teradata.

       support thousands of end users.

       templates developed utilized for national project.

       aided epic subject areas: optime (surgery), inpatient, outpatient and prelude (revenue).

       facilitated epic reporting data model/crystal reporting to kaiser employees.

       served as liaison between ncal and scal it departments and senior management.

       successfully mentored junior accenture ats staff including performance reviews.

       developed reporting specifications documents, project plans while managing project issue log.

       environment: teradata, crystal reports, microsoft visio, powerpoint, microsoft office, epic clarity database and microsoft project.

 

providian financial, san francisco, ca                                                                                         1999 - 2003

manager data services support and tools

       tasked to oversee three data warehouse systems with 22mm+ accounts.

       developed analyst team to conduct data modeling and data warehouse tool support.

       ensured business content understanding to end-users and departments.

       designed integrated on-line data dictionary from three informix data warehouse system dictionaries.

       successfully integrated erwin data modeling repository into lotus notes. 

       supervised staff of 10

       contributor for new data warehouse design/data model reviews.

       initiated ddl for new data storage requirements.

       effectively managed erwin, informatica, business objects administration, microstrategy and related bi software.

       originated policy/procedures, service level agreements, archive and disaster recovery plans.

       environment: unix, business objects, informix, microsoft office, erwin, informatica, microstrategy, lotus notes and microsoft project.

earlier background

prior to 1999, served as: systems manager, providian financial, san francisco: vp, software development manager, wheat first butcher singer, richmond, va: project leader financial applications, overnite transportation systems, richmond, va; systems analyst, state of virginia; senior analyst, general medical company, richmond. va.  in these assignments, built outstanding analysis, development, project management, team leadership and advanced technical skills.

 

education

total data warehousing institute (tdwi), member c 2008

 

at&t, reston, va

teradata programming and overview, 1995

 

providian learning institute, san francisco, ca

entrepreneurial leadership and project leadership, 2000

 

miami dade community college, miami, fl

ibm os jcl, gpa 4.0, 1988

 

northeastern university, boston, ma

certificate of computer science, gpa 4.0, 1987

starting pmi certification in january, 2009

 

activities

key volunteer and award recipient, san francisco aids walk; past 10 years-current, fundraiser, san francisco aids foundation bicycle ride, raising over $15k to date; past 3 years.

yyyyyy x. yyyyyy                         250 clara street #0000 xxxxxx xxxx , xxxx , xxxxx 00000

(xxx-xxx-xxxx                                                                                                                             abc@xyz.com

 

 

 

cover letter text

 

date

 

 

 

hiring agent name

title

company name

address

city, state   zip code

 

dear                   :

 

i am currently seeking a challenging career opportunity in an information technology/financial control capacity and am submitting my resume for your review.  in advance, i thank you for your time and consideration.

 

as demonstrated in the accompanying resume, my professional qualifications include over twelve years of highly successful it project management and technical analysis experience with major corporations. to complement this background, i possess demonstrated expertise in project integrated database tools, advanced data warehousing applications, staff supervision, strategic planning and providing critical data/advisement to senior management as well as strong developmental, problem-solving and managerial capabilities.  as an employee, you will find me to be an enthusiastic and disciplined team player, committed to supporting you in achieving your objectives through superior performance. 

 

i am confident that i could be a valuable asset to your firm, and look forward to interviewing with you in the near future to further discuss my areas of experience and expertise that would be a contribution to your organization.

 

 

 

 

sincerely,

 

 

yyyyyy x. yyyyyy

 

attachment