We provide IT Staff Augmentation Services!

Business Intelligence Analyst | Oracle Database Analyst Resume

3.00/5 (Submit Your Rating)

New, HampshirE

SUMMARY:

  • Provide cost savings and competitive advantage thru consensus building and facilitating among key stakeholders to obtain agreement on business requirements and functional designs.
  • Perform stakeholder interviews, analysis, influence key users and subject matter experts to gather, negotiate, document and validate complex business requirements.
  • Hands - on technical experience while leading all stages of software development life cycle efforts.
  • Skilled in technical analysis, requirements documentation, project management, customer service, client relationships, mitigation planning, risk management, workflow redesign, data analysis and migration, best practice implementation and cost benefit analysis.
  • Adept and experienced in problem solving and providing solutions. Excellent qualifications in leadership and interpersonal communications.
  • Expertise in application integration, system integration planning and COTS configuration.
  • Adapt to any working environment while maintaining professionalism and high quality performance.
  • Outstanding drive and focus on organizational objectives and customer need.
  • Passionate and enthusiastic about learning new technology and applying technology to solve problems.
  • Strong analytical and problem-solving skills; fast and continuous learner, constant researcher.
  • Strong determination to achieve an excellent outcome.
  • Ability to interact with and teach all levels of an organization.

TECHNICAL SKILLS:

Methodologies: Agile, JAD, RAD, SDLC, UML, Use Cases, Waterfall, Workshop Facilitation

Languages: VB, VBScript, SQL, PL/SQL, JavaScript, ASP, ASP.Net, ADO.Net, PHP, Ajax

Software: SQL Server, SharePoint, MS Access, Visual Studio, Office Suite, Project, Visio, IIS, Source Safe, Adobe Suite, Crystal Reports, Oracle, Toad, WebEx, BIDS

PROFESSIONAL EXPERIENCE:

Confidential, New Hampshire

Business Intelligence Analyst | Oracle Database Analyst

Responsibilities:

  • Provide business analysis, project management, data analysis for Dodd Frank Regulatory Reporting data warehouse project.
  • Confirmed project requirements by studying user requirements and conferring with team members.
  • Designed project application to streamline data gathering and validating for data warehouse workflow.
  • Project team member documenting, developing logical and physical databases descriptions and determining project scope and limitations.
  • Developed and effectively communicated governance routines, processes and validation procedures.
  • Communicated daily with business, technical professionals, staff, senior management providing technical guidance, analytical findings, change management experience and conflict resolutions.

Confidential, Massachusetts

Senior Information Systems Analyst | SQL | Senior Developer | Project Manager

Responsibilities:

  • Sarbanes-Oxley Compliance - Preventing and detecting fraud, money laundering, complying with SOX policies, procedures and passing compliance audits were my KPIs. Evaluated, recommended and implemented controls as well as assured manual overrides were properly executed.
  • Provided BA, PM, software development and strategic planning expertise.
  • Implemented business process reengineering project which decreased company Asset Reporting 125%.
  • Redesigned company financial reporting software and procedures resulting in 50% time savings.
  • Consistently met monthly financial reporting deadlines for 47 months.
  • Conduct data mapping, data analysis, workflow analysis, and requirements gathering for automating Enterprise data exchanges between Weston Financial and Washington Trust.
  • Lost productivity ROI analysis contributed to company network upgrade.
  • Perform monthly and quarterly SOX compliance audits of client and Principia CAMS data.
  • Communicated daily with business, technical professionals, support staff, senior management providing technical guidance, analytical findings and conflict resolutions.

Confidential

Marshfield, Massachusetts

Senior Business Analyst | SharePoint Administrator | SQL Server Developer | Project Manager

Responsibilities:

  • Introduced new technology to Program Office providing demographic, political, bridge repair analytics and reports never available before.
  • Provided data mapping, data analysis, workflow analysis, requirements gathering, functional specifications, application analysis, warehouse design, logical and physical models, proof of concept and program reports and graphs for Enterprise Data Warehouse.
  • Completed MassDot Highway Division’s data warehouse prototype.
  • Served as liaison between MassDot Highway and IT, provided stakeholder interviews, requirements gathering and specification support for the analytical needs of the Accelerated Bridge Program.
  • Reviewed SharePoint 365 and Primavera hosting proposals, performed cost benefit analysis and recommended a solution.
  • Developed ETL strategy and implemented ETL data mappings with BI Reporting Group.

Confidential, Windham, New Hampshire

Business Analyst | Senior Developer

Responsibilities:

  • Recruited to provide data migration, customer support and programming for installation of new VOIP Telephone System at CapitalOne Corporate Headquarters.
  • Performed requirements gathering, authored business and technical specifications; cost benefit and gap analysis and created GUI design.
  • Performed data analysis, mapping, validation and business rule programming for data migration. Documented workflow, conceptual database schema and logical data model using Agile.
  • Collaborated with CISCO and Verizon engineers, office facilities and client team members.
  • Met every go-live deadline while adapting to change in a fast-paced environment.
  • Redesigned and implemented project framework to manage VOIP installations at client sites. Framework replaced Outlook, Excel, Visio and Word with Internet solution utilizing SQL Server, Visual Studio, Ajax and ASP.Net technologies.

Confidential, Middleton, Massachusetts

Technical Consultant | Analyst | Programmer

Responsibilities:

  • Provided project management, business analysis, and customer support to US clients.
  • Redesigned and implemented application for client company to effectively price and manufacture new products. Customized application replaced Excel and Word with cost and scheduling modules that interconnected with Exact ERP. Reduced quote response time by 33%.
  • Analyzed business processes, documented requirements and programmed custom features for web-based CRM, business process and ERP software products using .Net, VB and SQL Server. Liaison with business owners, senior managers and technical support employees.
  • Provided technical consulting for Enterprise Software Products. Responsible for software installations, upgrades, hot fixes, SQL Server moves, data analysis, data conversions, data migration plans, disaster recovery plans and client workflow analysis.
  • Created, modified and converted Crystal Reports. Analyzed and mapped data to create new business development reports in support of client marketing campaigns using CRM software.
  • Performed requirements, programming, RAD prototype, implementation and training.

Confidential, Boston, Massachusetts

Software Engineer Contractor | SQL Developer | Business Analyst

Responsibilities:

  • Provided business analysis and project management to Treasurers Office Application.
  • Performed requirements gathering, designed, developed and programmed application upgrades, business process changes, project management and regulatory compliance for Fidelity’s $1.36 trillion Mutual Fund Audit Fees using Agile and JAD.
  • Analyzed business process, documented requirements and programmed new compensation fee changes for Board of Trustee restructuring.
  • Modified SQL Server schema, stored procedures and VB code for Fidelity’s Bank Loans and Interfund Lending Application

Confidential, Burlington, Massachusetts

Business Analyst | Senior Developer| Project Manager

Responsibilities:

  • Worked with Sox compliance to modified several applications that interfaced with Oracle Financials.
  • Recruited to provide analytical and PMI skills for several full SDLC consulting engagements.
  • Designed the Dunkin $80 million marketing program. Reduced monthly reporting from 30 to five days. Customized application provided tool for tracking yearly costs and marketing effectiveness. Modules interconnected with Oracle Financials.
  • Performed entire project lifecycle including business analysis, project management, software development, programming, implementation, documentation and user training.
  • Met every project milestone during five year consulting engagement.
  • Generated income by providing professional services for many projects.
  • Achieved 3% sales increase by reengineering Compaq Material Recovery Web Site.
  • Lead several .Net website enhancements. Team member performing DEC Manufacturing conversion to SAP.

Confidential, Braintree, Massachusetts

Business Analyst | Senior Developer| Project Manager

Responsibilities:

  • Designed and implemented an application that automated the office visit process of a Medical and Dental Malpractice Insurance provider. It numerically scored client policies and procedures while enabling a clinician two client visits a day, instead of having two clinicians visit one client for two days. Performed business analysis, project management, software development, programming and user training for project life cycle.
  • Designed and installed a cross-selling application for an insurance provider. Marketing and sales employees matched clients to company products to increase sales. Performed business analysis, project management, software development, programming and user training for project life cycle.

We'd love your feedback!