CAROLYN LIM

Email: addg6n@r.postjobfree.com

Phone: 602-***-****

SUMMARY

Carolyn is an IT professional with a business, systems and technical analysis background having held assignments in all three disciplines. She has 10+ years in the IT industry across various multiple projects in various industries, good communication, and strong analytical background and worked in SDLC with various methodologies including Agile, RUP and Waterfall. Fast learner of new business domain/models when placed in new assignment in order to start being productive in SQL activities. Most recent assignment (Maricopa County) learning curve of domain familiarity in one week. Available to interview and start immediately in Phoenix, AZ and holds US citizenship.

TECHNICAL EXPERTISE

MS SQL Server, MS SSDT/SSIS/SSRS, Tableau, UML, OOAD, Rational Rose, RUP, Java, EJB, J2EE, CORBA, Oracle, PL/SQL, Unix (HP), HTML, Javascript, ASP, Visual Basic, Perl, LDAP, C, C++, Windows NT, PHP, Dreamweaver, Fireworks, Flash, Agile, Waterfall

PROFESSIONAL EXPERIENCE

Maricopa County Office of Public Defender (OPD)

Database Programmer Analyst (contractor)

Oct 2019 – Apr 2020

Assignment to clean up migrated data from their older TimeMatters to current Justware (case management platform). Perform analysis to remove duplicates, and write needed stored procedures, SQL and ETL agent jobs (SSDT), and SSRS forms of reports. Usage of CTE and multiple levels of query scripts. Discovery of non-consistent data as a result of incomplete data migration. This is an independent role to deliver the cleaned data at completion of contract.

Berkeley Research Group

Health Analytics Practice, Phoenix AZ

Data Analyst – 4/19 to 8/19

Loaded data received from client on cases worked on to SQL Server – including conversion from Excel to text files, and cleaning

Data wrangling of raw data to analytical ready data within SQL Server

Perform analytics on wrangled data to discover trends using SQL and Excel

Subject of data include claims to do with litigation and arbitration supplied by both plaintiff and defendants such as healthcare insurance companies, physician practices and facilities

11/18 – 01/19

Assisted with a Business Startup

Analyze customer data to assist decision in business direction including customized offerings, email outreach, and online content personalization

Usage of the following tools: Tableau, GRETL (Statistics tool), SQL Server Express, SQL Server Management Studio (SSIS)

Activities include maintenance/creation of tables in SQL, loading to and exporting data (ETL), cleansing and preparation of data to be imported to Tableau, investigating visual representation of data in Tableau in order to discover trends and projections, applying statistical observation to data in GRETL

Note: GRETL is an open source Statistics tool and stands for GNU Regression, Econometrics and Time-series Library

Wells Fargo, Chandler AZ

Business Analyst – 4/18 to 7/18 (Contractor)

Worked on gathering requirements, documenting process flows, and facilitated meetings to do with the Well Fargo Auto reconciliation efforts

Cigna, Phoenix AZ

Systems Analyst – 6/17 to 3/18 (Contractor)

Worked on gathering test data for regression testing, pulling data from databases for weekly audit for the 2018 Federal Medicare Care Replacement mandate (Tools SQL)

Worked on onboarding a Cigna vendor with gathering requirements for secure data transmission

United Health Care, Phoenix AZ

Systems Analyst – 4/16 to 12/16 (Contractor)

Gathered requirements for United Healthcare’s core application quarterly releases

Worked with the business analysts to identify dependencies on upstream and downstream systems

Transitioned the requirements to the development team

Worked with the QA team on scope of testing and defect resolution

General Motors, Phoenix AZ

Functional Analyst (CRM Siebel) – 3/14 to 2/16

Worked with business analysts to ensure requirements were represented in the functional design

Collaborated with the developers to ensure functional design is implemented

Performed system testing to ensure functional requirements are working

Assisted testers to ensure they understood testing requirements (Tools Agile, Siebel)

City of Phoenix Dept of Aviation (onsite at Sky Harbor Airport), Phoenix AZ

Senior Business Analyst – 3/13 to 1/14 (Contractor)

Produced Functional Specification for Sky Harbor Airport’s new Parking Accounts Receivable System which was implemented by Microsoft and the Aviation Team

Documentation included outlining system integration points to other systems which would feed in and receive data from this new system, including design and details for automation of toll gate arm control over entry/exit of parkers, automation of billing for all parking clientele types, and reporting

Created UML representation and modeling for systemic solution of Parking Office’s rather complicated accounting calculation of their billing of late fees, including definition of undefined transaction types

Identified testing scope for UAT for the Sky Harbor Airport’s Badging and Security system for Testers and conducted testing for the final go decision on Go-Live of the system

Coordinated with product vendor (QuantumSecure) testing and regression testing before and after Go-Live of the system, and as necessary post live

Aided Sky Harbor Airport Command Center in selection of software for assessment of new hires

Western International University, Phoenix AZ

Senior Business Analyst – 4/11 to 10/11 (Contractor)

Performed business process modeling and system analysis of current environment, onboarded users to provide requirements for a technical team, and test planning

US Airways, Phoenix AZ

Senior Business Analyst – 9/10 to 3/11 (Contractor)

Worked on requirements gathering, process streamlining, process redesign, prototyping and testing efforts to consolidate payroll system between US Airways and America West (Tools Visio, UML, Agile)

VMWare, Palo Alto, CA

Senior Business Systems Analyst – 7/07 to 3/08 (onsite Consultant for Infogain Corp, Los Gatos CA)

Worked on Support Call Center Siebel projects on documentation and workflow design

NetApp, Sunnyvale, CA

Senior Business Systems Analyst – 12/06 to 6/07 (onsite Consultant for Infogain Corp, Los Gatos CA)

Worked on financial project business process reengineering, analysis, testing and documentation using PL/SQL and Rational Rose

Chordiant, Manchester, NH

Senior Business Analyst – 9/05 to 11/06 (onsite Consultant for Infogain Corp, Los Gatos CA)

Worked on new product platform offering with development team and familiarizing first customer with its new functionality (Tools Rational Rose, UML)

Walt Disney Parks and Resorts Online, Scottsdale, AZ

Systems Analyst – 8/05 to 9/05 (Contractor)

Advised client on software methodology, performed gap analysis and onboarded team to on object oriented approach to design towards efforts on online web content and automation of a customer self service portal (Tools Rational Rose, UML)

Maximus, Inc., Scottsdale, AZ

Systems Analyst – 3/05 to 6/05 (Contractor)

Worked on use case and domain models, detailed design, UI design within the Rational Unified Process methodology framework (RUP) on a product enhancement effort. ( Tools Rational Rose, UML )

Nike, Inc., Portland, OR

Business Systems Analyst – 4/03 to 7/03 (Contractor)

Worked on use case and domain modeling for automation of Nike’s apparel creation process (Tools Rational Rose, Requisite Pro, UML, SQL )

US Air Force/Keane Federal Systems, Montgomery, AL

Lead Business Systems Analyst – 2/03 to 4/03 (Contractor)

Worked on USDOD Air Force wide IT modernization efforts performing requirements gathering, producing use case models and proof of concepts within the Rational Unified Process methodology framework (RUP) ( Tools Rational Rose, Requisite Pro, UML )

Aon Re International, Canada, Europe

Systems Analyst – 9/02 to 12/02 (Contractor)

In role of technical consultant to business analysts on how requirements would fit in a software solution and communicated via use case and domain modeling. (Tools Rational Rose)

Prudential/Real Estate and Relocation Services, Phoenix AZ

Business Analyst – 3/02 to 9/02 (Contractor)

Worked on requirements gathering, documentation and use case modeling for efforts towards a centralized online solution bringing in all disparate systems. (Tools Rational Rose, UML)

WorldCom Wireless, Phoenix AZ

Business Analyst – 7/01 to 11/01 (Contractor)

Worked on use case modeling and requirements gathering towards efforts on integration with UPS ( Tools Visio, UML, SQL Server 7.0)

Accenture, New Jersey

Software Engineer – 2/01 to 6/01

Worked as part of an internal team performing use case and domain modeling, and technical analysis with the development team towards the deployment of an internal asset based on Microsoft products

Worked on the solution for an insurance client as part of a technical team on rearchitecting a messaging mechanism for transport of data from external to internal systems

Sunquest Information Systems, Tucson, AZ

Use Case Engineer/Object Modeler – 8/00 to 1/01 (onsite Consultant for Cognizant, Inc.)

Worked on requirements gathering and use case modeling for a lab testing (diagnostix.com) website (Tools Rational Rose)

American Express Property and Casualty, Green Bay, WI

Use Case Engineer – 6/00 (onsite Consultant for Cognizant, Inc.)

Use Case Engineer to mentor AMEX BSA’s to transform functional specification into requirements utilizing Use Case/UML format

Volkswagen, Detroit, MI

Junior Technical Architect – 4/00 to 6/00 (onsite Consultant for Cognizant, Inc.)

Was part of technical team and performed object oriented analysis and design, software design and worked with offshore development team, attended onsite client JAD sessions for VW’s first online vehicle buying model project (The Beetle). (Tools Rational Rose, Java 1.2, JDBC, Reflection, Bean patterns, UML)

American Express Financial Advisors, Phoenix, AZ

Lead Programmer/Analyst – 2/00 to 4/00 (onsite Consultant for Cognizant, Inc.)

Performed analysis of web metric providers and delivered a solution for design of a summary dashboard view for upper management

Fusive.com, Inc., Deerfield Beach, FL

Technical Business Analyst – 5/1999 to 10/1999

Consulted at various local small business clients for Microsoft solutions

Motorola, Space Systems Tech Group, Phoenix, AZ

Software Engineer – 4/1997 to 1/1999

Part of internal development team for development of Motorola deployment platforms (Tools SQL PL/SQL, Java, Oracle, WebSphere )

Motorola, Semiconductor Products Sector, Phoenix AZ

Systems Analyst – 4/1997 to 1/1998

Part of support team to the finance community responsible for maintaining and producing reports, update and maintenance of database for the production of onsite semiconductor manufacturing (Tools PL/SQL, Store Procedures, interface application programming to intranet webpages, automated workflows)

CERTIFICATIONS

MCSE (Microsoft Certified Systems Engineer),

SQL Server 6.5 (Admin/Design)

Sun Certified J2EE Enterprise Architect

EDUCATION

Cleveland State University, Cleveland, OH

Master of Business Administration

Master of Computer Information Systems

Syracuse University, Syracuse, NY

Bachelor of Science in Civil Engineering

Contact this candidate