We provide IT Staff Augmentation Services!

Business Analyst  Resume

Monterey Park, CA

SUMMARY:

  • Result driven IT Professional, strategic thinker, excellent technical, analytical, communication, customer service, and leadership skills.
  • Expertise in providing and implementing practical solutions based on business needs and best practices to generate immediate stakeholder deliverables on schedule and providing excellent customer service and on - site/off-site support.
  • Proficient in building and leading cross-functional teams for complex engagements, project tracking, and reporting.

TECHNICAL SKILLS:

Methodologies: SDLC Waterfall, Agile

Modeling: Visio; understanding of UML

Microsoft: Excel, Access, PowerPoint, OneNote, Project

Languages: SQL, JCL/ESA, COBOL/II

Operating Systems: MVS/ESA, Windows/XP/VISTA, AIX, UNIX, MS-DOS, PHP, Windows Server 2008, MS-SQL Server

Collaboration: JIRA, Confluence, Mercury QC, SharePoint

Databases: IBM DB2, Microsoft Access, MS SQL Server, MySQL

Tools: IBM DB2 Utilities (Repair, Load, Quiesce, Backup, Load), IDCAMS/VSAM, DITTO, CA-7, CA-11, CA-1, IBM Utilities (IEBCOPY, IEBGENER), JOBTRAC, File Aid, SORT utilities, Endevor, IBM Hourglass, RACF, DFHSM, Mercury Test Director, Expediter, Abend Aid, Easytrieve, MVS/JESS2 operator console commands, FTP, TSO/ISPF, SDSF, CA-SAR, Beta 92, Omegamon, Sort utilities, File Aid, Selenium IDE, Atlassian JIRA and Confluence, WIKI-Docs, Clarity, SharePoint, DB2 SQL, PostgreSQL

Telecommunication: VTAM, Netview

OLTP: CICS/ESA, CEMT/CEDF tools

SAP: SAP R/3 - FSCD/FICO

WEB: HTML, DHTML, CSS, JSON, XML, Client Web services, Javascript, Chrome, IE, FireFox, Safari, IE, Javascript, VBA

Enterprise Solutions: FileNet, Datacap

PROFESSIONAL EXPERIENCE:

Confidential, Monterey Park, CA

Business Analyst

Responsibilities:

  • Gathers data from configuration management database and map data relationship against legacy configuration management database to produce survey results for system managers
  • Collects performance and data metrics and prepare status for management
  • Provides project status and timeline to stakeholders and management
  • Remediates critical project timeline issues
  • Analyze, clean, and format raw data for analysis and reporting to EIS management
  • Analyzed and formatted data in Excel file format using VLOOKUP and VBA for Enterprise Information team
Confidential, Burbank, CA

Business/Data Analyst

Responsibilities:

  • Gathered data requirements and performed data mapping record to record relationship on EIDR, CID, data to identify media assets for EST and VOD related projects
  • Drives and participates in design, development and implementation of application initiatives
  • Performed data analytics using SQL queries, Excel VLOOKUP, Match and Pivot tools to provide media asset metric reports to management.
  • Provided business stakeholders ad hoc data metrics using Excel pivot reporting
  • Performed unit testing and worked on task issues and remediation.
  • Provided project and timeline status to all stakeholders and management
  • Provided Media Asset Management (AVAILS) reporting analytics
Confidential, Monterey Park, CA

Business Analyst III Lead

Responsibilities:

  • Gathered data element requirements and mapped record to record relationship
  • Drives and participates in design, development and implementation of applications
  • Works closely with developers and testers to ensure requirements and functional designs are translated accurately into working technical designs and that test plans/scripts serve customer needs.
  • Perform tests and work on remediation of issues.
  • Provided project status and timeline to stakeholders and management
  • Participated in internal banking audit OFAC compliance initiatives gathering and verifying data stream flows end to end through FIS/Metavante, ACH, Lock-box application platforms.
Confidential, Woodland Hills, CA

Business Analyst/Business Intelligence

Responsibilities:

  • Worked with IT application teams to document data mart, and data flows across brand and analytics applications.
  • Used Mercury Quality Center (HP) to work on, resolve, and track BI related tasks and incidents
  • Created and executed project and resource plans to meet business needs.
  • Gathered and documented business and project technical requirements from various project stakeholders on an ongoing basis.
  • Provided BI analytics application support, error tracking and escalation.
  • Provided data dictionary and data mapping analysis.
  • Provided cube data analytics reporting.
  • Defined and tracked project scope metrics including data completeness and data accuracy for reporting purposes using SQL 2008 SSIS/SSRS and Legacy DB2 SQL.
  • Provided Excel (Power) Pivot data analytics on data cubes using SharePoint collaboration platform.
  • Provided level two tier application support, defect reporting and follow up
Confidential, Simi Valley, CA

Business Analyst

Responsibilities:

  • Documented and improved asset management data capture and reporting.
  • Worked with multiple vendors to reconcile budget, manage assets, and orders.
  • Performed business process analysis and documentation of current and future processes.
  • Performed data analysis, compare, and integration of asset data using LANDesk and MS Access.
  • Created and executed project and resource plans to meet business needs using MS-Office suite.
  • Gathered and documented business and project technical requirements from various project stakeholders on an ongoing basis.
  • Performed first level analysis of all asset tracking issues and data challenges.
  • Defined and tracked asset management metrics including data completeness and data accuracy for reporting purposes using SharePoint for collaboration.
  • Ensured that data quality standards, procedures, and methodologies were being followed to track assets and accuracy of budget and financial reports.
  • Prepared, managed, and presented project status using MS-Office tools.
  • Maintained and executed asset tracking process using Excel VBA.
  • Prepared and presented project status report to team and management.
Confidential, Glendale, CA

Business/Data Analyst

Responsibilities:

  • Worked with IT application teams to document database designs, and data flows across brand and analytics applications.
  • Created and executed project and resource plans to meet business needs.
  • Gathered and documented business and project technical requirements from various project stakeholders on an ongoing basis.
  • Provided title analytics application support, error tracking, and escalation.
  • Worked with finance, accounting, contract management, operations, sales, brand and product management and publishing category teams to analyze business issues and data challenges and recommend information solutions to streamline work flows.
  • Defined and tracked quality assurance metrics including data completeness and data accuracy.
  • Ensured data quality standards, procedures, and methodologies were being followed.
  • Identified opportunities to reduce data redundancy. Researched and discovered trends in data use and optimize single sources of data.
  • Developed recommendations for new applications and processes or enhancements to current applications as needed to ensure data integrity.
  • Scripted and analyzed complex SQL queries to extract data for analytics, data mapping, and reporting.
  • Utilized BI reporting tools, Micro strategy and Cognos for title analysis reporting of Disney Publishing business.
Confidential, Pasadena, CA

Business Analyst/Project Manager I - IT ERM

Responsibilities:

  • Prepared on-going project status to business unit and management.
  • Followed established standards and SDLC waterfall and agile methodologies for solution development and implementation.
  • Created and modified MySQL queries to extract data for back-end reporting purposes for management and users during UAT.
  • Created and executed project and resource plans to meet business needs.
  • Gathered and documented business and project technical requirements from various project stakeholders on an ongoing basis.
  • Leveraged teams effectively to maximize productivity and motivates teams to work together.
  • Worked and managed multiple projected initiatives during SDLC simultaneously.
  • Collaborated with business units, quality assurance, developers and testers throughout the project lifecycle to provide clarification or resolve business- and process-related problems.
  • Tracked and reported project implementation status to senior management.
Confidential, Glendale, CA

Senior QA/Business Analyst

Responsibilities:

  • Collaborated and provided stakeholder requirements during top-down data modeling for new and existing projects.
  • Used JIRA to work on work stream related tasks and incidents
  • Created and executed queries to join multiple tables using PostgreSQL to extract and verify data results during QA back-end testing.
  • Gathered and documented testing and business requirements.
  • Participated and lead agile sprint meetings to determine release testing status and prepare for next release.
  • Documented and published operation procedures, processes, templates using Confluence
  • Created, reviewed, and documented test cases and archive all test case results in collaboration with software developer.
  • Provided assistance to the development team by reviewing and interpreting HTML. JavaScript, JSON code during error analysis of application testing.
  • Performed Quality Assurance (regression, functional) white-box testing of GUI front end application (API) on IE, Safari, Firefox, Chrome, using Selenium IDE, and back-end testing using JSON.
  • Analyzed and improved QA procedures and processes.
  • Provided cross browser application support and system error tracking and resolution using JIRA.
Confidential, Monterey Park, CA

Business Systems Analyst

Responsibilities:

  • Wrote functional documentation for development team based on business requirements.
  • Solved organizational information problems and requirements by analyzing requirements; recommending system controls and protocols.
  • Determined operational objectives by analyzing business functions; gathering information; testing and evaluating output requirements formats for Enterprise Content Management projects (Datacap, FileNet).
  • Analyzed project requirements; constructed and modified workflow charts and diagrams; studied system capabilities; documented specifications as needed.
  • Worked with development and business stakeholders using bottom-up data modeling approach for large re-engineering project.
  • Recommended process controls by identifying problems; writing improved procedures.
  • Chaired staff and business stakeholder meetings. Recorded and published meetings.
  • Worked with development team on project requirements by identifying project milestones, phases, and elements during SDLC;
  • Supported application team by creating ad-hoc SQL queries from scratch during unit testing data analysis.
Confidential, Los Angeles, CA

Systems Analyst Team Lead QA

Responsibilities:

  • Collaborated with developers, business stakeholders in database data mapping.
  • Created and modified from simple to complex SQL queries during system integration white-box testing to verify data results.
  • Created, reviewed and modified regression and integration test cases.
  • Facilitated and participated in RAD and JAD meetings with key development and business stakeholders.
  • Collaborated and provided stakeholder requirements during top-down data modeling for new and existing projects.
  • Provided technical support during QA SIT, UT, and UAT activities including creation and verification of test cases.
  • Assisted during data warehousing initiatives in the ETL process of extracting data from different source formats for the load.
  • Collaborated with key stakeholders to guide project direction and increase likelihood of project success in PLA such as Fire/Auto and commercial lines.
  • Assisted in gathering business requirements, translating to functional requirements, manage project plans, schedules, deliverables, action items, milestones, task assignments, scope, issues, and risks using SharePoint.
  • Facilitated project status meetings to review feedback on project progress, results, coordinate escalation, and problem resolution if required.
  • Analyzed functional application processes, identify and document processing inefficiencies during SDLC life cycle.
  • Performed SAP FSCD pre-release testing cutover activities using SAP R/3 application platform server and communicate verification of readiness to stakeholders and development teams. Track, process and monitor daily release testing of SAP FSCD (FICO, FI) activities using SAP application platform server.
Confidential, Costa Mesa, CA

Senior Consultant

Responsibilities:

  • Created and tracked project timelines, milestone, reported status, and delivered environment test platform to the client on schedule.
  • Trained and mentored new consultant, contractor, and Farmers employees on applications and technical solutions.
  • Prepared, communicated and followed up on relevant release project validation by all stakeholders.

Hire Now