Sr. Data Analyst Resume
Philadelphia, PA
PROFESSIONAL SUMMARY:
- Hands - on technical and functional knowledge in Business Analysis, Agile Development, Business Intelligence, Data Warehousing, ETL and Business Process Improvement within the Financial Services
- Pharmaceutical, Healthcare, Fuel Products & Services, Telecommunications/ Mass Media, and Life Insurance & Annuity industries. An IT professional with demonstrated versatility across the SDLC spectrum.
TECHNICAL SKILLS:
Applications / Programming: SQL Server
Data Quality: Oracle Client, Toad for SQL Server, MS Excel
Content Management System: MS SharePoint 2010
Requirements Document Mgt: CaliberRM 2008, HP Quality Center 10
Business Intelligence: Hyperion / Brio, Oracle Discoverer
Business Analysis: MS Visio, Business Process Flow Charts
Business Continuity: Continuity Logic Frontline Live, MS Systems Center
Project Management: MS Project, Project Initiation, Project Charter and SDLC
Development Methodologies: Software Engineering Process (SEP), SDLC, RAD, Agile
PROFESSIONAL EXPERIENCE:
Confidential - Philadelphia, PA
Sr. Data Analyst
Responsibilities:
- Supported process monitoring, quality improvement, policy coordination, & communications efforts, required to support the established US Transparency Data Operations & Reporting (TDOR) team.
- Conducted data QC/QA, transformative tasks to ensure accuracy/completeness of Open Payment / US HCP Spend Transparency reporting requirements & federal submission preparation.
- Maintained control of effective policy, process, procedure documentation in compliance with established US Transparency requirements, business/audit standards.
- Executed, maintained, & enhanced Level 1 monitoring SQL queries for Federal, State, CIA, & CMS reporting.
- Created Level 1 monitoring process improvements that reduced workflow completion time by 30%.
Confidential - Horsham, PA
Sr. Business Analyst
Responsibilities:
- Elicited & documented requirements from Loan administration business group to automate manual insurance compliance review process for internal Insurance Compliance System development project.
- Identified mandatory DB fields from multiple systems to be extracted for merged source of truth ICS database.
- Developed and maintained business requirement document (BRD) artifacts for project stakeholders and sponsors.
- Facilitated future state process flows work sessions with business group. Documented business needs for new ICS front end GUI.
- Created Excel framework/mock-ups for new ICS system.
Confidential - Philadelphia, PA
Sr. Business / Systems Analyst
Responsibilities:
- Facilitated the requirement flow between Business units and IT software development team as the primary project liaison for projects pertaining to web content management & Epic development; IT architecture upgrade, clinical and business continuity asset management.
- Developed & maintained business requirements document (BRD) artifacts for executive sponsors, stakeholders, and PMO review.
- Created flow diagram, use case artifacts for new feature functionality for new system enhancements.
- Created & executed User Acceptance Testing (UAT) artifacts for enterprise wide asset management project.
Confidential - Monroe, LA
Business Systems Engineer
Responsibilities:
- Facilitated the requirement flow between Business units and IT software development team as the primary liaison.
- Developed & maintained business requirement documents (BRD) for new feature functionality that enhance system flexibility, reliability and maintainability for new products and services.
- Led project stakeholders to analyze complex client problems, defined system vision and scope, elicited and gained consensus on functional requirements.
- Maintained and developed use case, data dictionary assumption, business rules, artifacts for project stakeholders.
Confidential - MACUNGIE, PA
Owner / Business IT Consultant
Responsibilities:
- Conducted al Financial Workshops & Seminars.
- Developed individually tailored financial planning for business owners and families.
- Specialized in Family diversifying retirement income,, and Wealth accumulation. & Distribution management.
- Participated in NYL sponsored Community Outreach Child ID Events.
Confidential - Philadelphia, PA
Business Analyst
Responsibilities:
- Drove Optimization Planning for daily Campaign Marketing data from a manual to an Automated System.
- Broke down analysis for current Daily & Weekly system job flow.
- Monitored Daily system job ETL process schedule.
- Conducted Business Requirements Gathering Sessions.
- Designed & developed performance monitoring Excel reports.
Confidential - New York, NY
Financial Advisor
Responsibilities:
- Completed accelerated G program to receive Series 7 License in less than 12 weeks.
- Refined work productivity through goal oriented to effectively increase time management performance by 25%.
- Developed techniques for cultivating a personal client base through client need assessments.
Confidential - Miami, FL
Business Analyst
Responsibilities:
- Discovered, analyzed, synthesized, and documented informational needs for both analytical, and decision support.
- Translated functional requirements into technical requirements used by development team.
- Worked with the Quality Assurance Manager to develop the System Test Plan.
- Participated in project scope definition and represented the user community in the technical design process.
Confidential - BKLN, NY
Business Support Manager
Responsibilities:
- Supervised Access DB team efforts in Excel report publications used by all management levels for strategic planning and decision making purposes.
- Monitored and ensured successful nightly transactional processing for daily market trading.
- Managed team efforts as the escalation point for handling all system issues to a successful resolution.
- Created standard team procedures to maintain synchronized communication between all business functional groups resulting in new hire time reduction of 30%.
- Conducted yearly performance reviews of all team members resulting in compensation adjustments.
Confidential
Quality Assurance IV/ Business Analyst
Responsibilities:
- Delivered Program Management Artifacts.
- Spearheaded the QA responsibilities that lead to a successful NYSE launch of the Exchanged Traded Fund (ETF) symbols listings.
- Created structured test plans, scripts and conditional data using formal testing methodologies.
- Published documents intended for executives, developers, clients, and regulatory agencies.
- Developed and executed detailed (UAT) plans based upon functional requirements and system design.
- Coordinated development meetings with product planning to identify and reduce program defects.
