We provide IT Staff Augmentation Services!

Migrations Consultant Business Analyst Resume

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • Prince2 qualified IT Project Manager and Project Analyst with over 25 years of IT experience in Banking, Telecoms, Utilities, Transport and industries.
  • Experienced in project management and business analysis in matrixed environments, gap analysis, project scoping and shaping, requirements ratification, collaboration on solution design, process maps, stakeholder management, implementation support and review, resource planningapplication analysis, requirements gathering, documentation, UAT testing, , mi (mgt. info) provision and project/stage reviews, cost estimations, resource requirements and estimations in environments using .NET 4.5, ASP.NET, VB.Net, C#, MS SQL 2016.
  • ETL Solutions for medical insurance
  • Developed reports for board members
  • Developed user manuals for team members
  • Developed UAT scripts
  • Developed online help files
  • Developed User Requirements documents
  • Developed Technical and Functional Requirements documents
  • Trained in Prince 2 project methodology
  • Trained in Scrum and Agile project management
  • Developed project outline and phases for various projects
  • Project Coordinator for a number of projects with external customers
  • Written both RFPs and RFIs as well as input for MOAs
  • Gained experience with ER modeling, Ganes Sarson, GUIDS, UML and OOA/OOD
  • Investigated use of Test Driven Development methodology
  • Gained experience with .NET and Web Services
  • Investigated and proposed technical solutions to communicate with local councils using SOAP, XML and DOM.
  • Created XML messages and DOM doc.s
  • Imported XML DOM doc.s and messages into SQL 2000 & 2005
  • Project Lead/Manager for 32 developers. Project consisted of 3 teams.
  • Gained extensive experience importing and exporting data from SQL Server
  • Extensive use of TSQL
  • Migrated databases between versions (upwards only)
  • Extensive SSRS and SSIS(ETL)
  • Site development and tuning for Google, Bing and Yahoo and investigating the use of Facebook, Myspace and Linkedin for ad campaigns.
  • Developed, maintained and designed databases
  • Extensive use of Stored Procedures and Functions
  • Use of Integrated Security
  • Use and development of Dynamic Views (DMVs)

TECHNICAL SKILL SUMMARY:

  • Developing Procedures, Policies & Documentation
  • Information Mapping
  • MS Project for Windows 4.0 - 2010
  • MS Access for Windows 1-2003
  • MS SQL Server 4.2, 6, 6.5, 7, 2000, 2005, 2008, 2012, 2014 and 2016
  • MS Visual Studio (TEAM EDITION)
  • MS VSTEST and VSTESD (MS VISUAL STUDIO TEAM)
  • MS VS Code
  • MS PowerShell
  • Power BI
  • MS Power Query
  • VB6 - VB.NET
  • VISIO 4-2013
  • VISIO UML
  • Stylus Studio (XML, etc)
  • WISE for Windows package installer (5.1)
  • MS Word v 1.1 - 2016
  • MS Excel v 3.0 - 2016
  • EasyCase (Case tools)
  • ERWin
  • Rational Rose Enterprise
  • OOD/OOA (GUIDS Method and OOAD with UML)
  • Gane Sarson (process mapping methodology)
  • USE CASE Systems Analysis (OBJECTORY and Rational Rose)
  • Information Engineering (Db design/data mapping)
  • ALT - Application Lifecycle Testing (System Development Lifecycle)
  • TDD (Test Driven Development) with VSTest and NUnit
  • SEO (Search Engine Optimization)

PROFESSIONAL EXPERIENCE:

Migrations Consultant Business Analyst

Confidential, Los Angeles, Ca

Responsibilities:

  • Charged with migrating Arizona customers out of the sql databases, took over day to day Access ETL then full time BA
  • SSIS Migration packages
  • Developed SSRS reports
  • Maintained and extended MS Access ETL processes
  • Developed PowerShell scripts
  • Became 1 of 2 BA’s for our area

Database Design Consultant

Confidential, Pasadena, California

Responsibilities:

  • Charged with development of reports and database design/implementation for Network devices and space used
  • Technical Specifications, Database design and implementation
  • Hands on development of databases (Stored Procedures, T - SQL, Db/Query Tuning & ER Modeling)

Confidential, West Covina, California

Business Analyst

Responsibilities:

  • Charged with development of SQL scripts, analysis of banking irregularities (business analysis) and documentation for purposes.
  • Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)
  • Development Excel pivot table reports
  • Development and maintenance of ETL packages and systems
  • Process documentation for users and other business analysts
  • Process error analysis of C++ and C#

ETL Consultant

Confidential, Los Angeles, California

Responsibilities:

  • Technical Specifications, Database design and implementation
  • Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)
  • Development and maintenance of SSRS reports
  • Development and maintenance of SSIS packages and systems from ORACLE
  • Gap analysis with user interviews

Database Design and Tuning Consultant

Confidential, Cypress, California

Responsibilities:

  • Charged with development of reports and database design/implementation with overseas development team.
  • Application allowed clients to see their tax exposure on demand.
  • Technical Specifications, Database design and implementation
  • Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)
  • Development and maintenance of SSRS reports

ETL/SSIS Consultant

Confidential, Thousand Oaks, California

Responsibilities:

  • Charged with maintenance of SSIS packages, SQL stored procedures and systems documentation as well as extending the current databases while communicating with the iSeries and LandSafe systems for Confidential .
  • Technical Specifications, Database design and implementation
  • Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)
  • Development and maintenance of SSIS packages and systems
  • Gap analysis with user interviews

Project Coordinator/Manager and Database Designer

Confidential, Downey, California

Responsibilities:

  • Charged with Business Analysis, Project Coordinator, Project Management, Systems Analysis, etc. for a mixed team of permanent and contractor staff. This included interviewing other department members and external agencies to gather requirements and perform gap analysis, conduct hiring interviews, participate in budget allocation ($2,000,000/6 mths), RFIs, writing application requirements, assigning and tracking developer tasks and reviews for SEMIS web site.
  • Other duties involved prioritizing helpdesk tickets involving MIS system faults, daily progress reports and testing/review of MIS components (QA) as well as tuning of various Stored Procs, Data Transformation packages (SSIS) and RDLs (SSRS).
  • Technical Specifications, Database design and implementation
  • Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)
  • User requirements analysis
  • Budget analysis
  • Development and maintenance of SSIS packages and systems
  • Development and maintenance of SSRS reports
  • Gap analysis with user interviews
  • MIS QA
  • Work flow assignments to team members
  • Project planning and progress reporting
  • Interviewing candidates for new positions
  • System documentation
  • Db documentation

Business Analyst

Confidential

Responsibilities:

  • Charged with development/project manager of “MasterAsset” system within Confidential .
  • Duties included analysis of user requirements (Business Analyst) with external businesses within the insurance industry.

Owner

Confidential

Responsibilities:

  • Charged with development/project manager of website as well as generation of articles for use in ad campaigns.

Hire Now