We provide IT Staff Augmentation Services!

Supervisor Resume

4.00/5 (Submit Your Rating)

San Francisco, CA

Hire Now

SUMMARY

  • Experienced IT Professional with 10+ years experience leading data warehousing application initiatives
  • Serve as key IT management team member defining and executing strategic department goals
  • Deploy systems and process requirements optimizing performance and technology utilization
  • Allocate resources, establish timelines and deliver impactful analytic data warehouse solutions aligned with business needs
  • Oversee analysis, design, development, implementation, testing and production support imperatives
  • Lead the integration between end users and IT translating business needs aligned with key performance obiectives
  • Apply acumen, leadership, communication, technical and analytic expertise to drive favorable outcomes
  • Initiate software proiect development life cycle requirements, development, testing and production support tasks
  • Collaborate with cross - functional teams understanding requirements and executing data driven solutions
  • Adept at medical, pharmacy, membership and eligibility data relating to health plan operations
  • Conduct QA process and business scenario testing applying unit, functional, regression and integration testing methods
  • Design and develop ETL mappings using SQL and SQL server integration services
  • Extract, transform, and load disparate data sources such as Oracle, SQL Server, Teradata, flat files, excel, CSV and XML files
  • Analyze OLTP/OLAP data, perform E-R modeling, develop Star and Snowflake schemas creating fact and dimension tables
  • Knowledge with HIPAA EDI transaction sets 837I & P, 277, NCPDP and familiar with 274, 820 and 835 transaction sets
  • Exceed performance objectives resulting in increased responsibilities and promotions

TECHNICAL SKILLS

  • Databases: MS SQL Server 2005/2008/2012/2014, Oracle 10g, 9i/8.0/7.x, MySQL Modeling Tools Erwin 9.x/4.0/3.x, Microsoft Visio 2010
  • ETL Tools: Informatica Power Center 7.x/6.x, Pervasive 8.14/9.0, SQL Server Integration Services EDI Tools Microsoft Biztalk Server
  • Programming Languages: C, SQL, PL/SQL, TSQL, UNIX, Python Web Development HTML, Java, XML, VBScript
  • Operating Systems: LINUX, Windows 7/Vista/XP/2008/2003, Windows 9x

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Supervisor

Responsibilities:

  • Oversee enterprise data warehouse IT initiatives tracking and reporting encounter and pharmacy data 2016 - Present
  • Define and execute Enterprise Data Warehouse roadmap initiatives
  • Supervise 3 ETL developers maintaining enterprise data warehouse and care management applications
  • Manage team resources for all project intakes on a daily basis
  • Conduct weekly meetings discussing individual and team issues, risks and priorities
  • Serve an integral role being part of IT management organization and department strategic planning initiatives
  • Prioritize product backlog for EDW release cycle working with business
  • Provide training, ensuring accurate documentation and enhance communication
  • Involved in gathering requirements, functional specifications and mapping data for new Analytics Data Warehouse
  • Lead and implement SQL Server upgrades for three consecutive years

Lead Programmer Analyst

Confidential

Responsibilities:

  • Produced conceptual, logical and physical data models using Visio and Erwin data modelers
  • Led design processes, data collection methods and reporting format initiatives
  • Led the team in all aspects of data quality and enhancements for all data topics in EDW
  • Implemented 8 week release cycle for enterprise data warehouse
  • Applied advanced principles and practices of database management systems and operating procedures
  • Conducted testing and code review for all EDW releases
  • Established standards and procedures for code deployment and source control for EDW

Senior Programmer Analyst

Confidential

Responsibilities:

  • Designed and maintained applications and databases analyzing requirements and developing systems
  • Involved in design and development of data validation, roll back and error control routines
  • Created new interfaces for member, provider and claims data from QNXT claims processing application into EDW
  • Developed end to end data process flows in Visio for Enterprise Data Warehouse
  • Developed 277 Claim Acknowledgement EDI transaction using Biztalk

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship