Summary:

• Twenty three Years IT experience utilizing skills in many software packages and tools. 15 years as a Business Analyst. SDLC, 12 years as a project manager, ITIL Foundation Certified, 8 years T-SQL. 8 Years Data Ware-Housing Design and Architecture, 5 years Jira Agile Plug In , 10 years OLTP, Team Work PM Cloud Based OLAP, Business Intelligence, iRise, T-SQL, CMS, TOAD Oracle Micro strategy, Top Team, HP Quality Center, HP SQL Editor Oracle , PL SQL, Erwin, SharePoint, ETL, Team Foundation Server, AMOD, Development life cycle, Six Sigma. 12 Years Project Management. 10 Years Data Modeling and Architecture ER Studio and ERwin , Team-Work project management. PM Architecture and Design. Business Design and Requirements. Experience in sessions such as RAD, SDLC, JAD and Agile. Gathered Requirements for multiple applications and the processes, workflow. 12 years Business Analysis Experience.
• Senior Business Analyst -Warehouse Developing and implementing an Analytics and Business Intelligence line of business for several different clients. Design, Gather Requirements, develop and implement client specific database marketing data warehouses using SQL Server Management Studio.
• Developing and implementing a SQL Server Report Server - SSRS with dynamic live analytical reports using SQL Server 2005, 2008 Business Intelligence Development Studio. Develop and implement an easy client internet access portal for viewing and downloading reports.
• Develop SSIS packages, DTS packages and schedule client data load packages utilizing SQL Server 2005, 2008 Integration Services - SSIS. Develop and automate stored procedures to create/update client data warehouse tables, analytical and reporting summary tables.
• Gather Information to map and convert data types to new data stores from old or outdated systems. Provide clear specifications to the software teams. Define functional and quality requirements for the PM.

Project Management Business Analyst Summary:

Scrum Master/Team Lead for BI Reporting and the Data Warehouse development team. Responsible for the design and build of a new Parallel Data Warehouse using the latest Microsoft Technologies for use as a new reporting platform. Assisting the organization in the strategic transformation from traditional waterfall to agile SCRUM operations. Responsible for teaching project managers agile practices and assisting in the conversion to agile within their high performing project teams. Systematically and rapidly teaching agile concepts across newly developed high performing teams across the organization in a manner that encourages team members to embrace new thought patterns and stretch to reach new levels of accomplishment. Continuously monitored morale and maintained a delicate balance navigating the organization through change while not introducing overwhelming amounts of change too rapidly. Project Managertasked with leading Information Technology Programs and Projects. Application Development Environment C / ASP.NET / SQL Server / Oracle. Instituted process improvement to the support workflow that drove all work items through a common entry point so that it could be monitored, estimated, prioritized, and delivered as promised. Prior to instituting this practice work was being accepted through various sources including emails, phone calls, personal visits, etc., and had no system of prioritization or delivery. After instituting process improvement, clients had clear expectations regarding delivery of work and customer satisfaction was increased significantly. Successfully trained and transitioned the team from Waterfall to Agile Scrum and broke ground for the entire organization to begin instituting Scrum practices. The Parallel Data Warehouse four streams of data project's success was based on communications, organization, clear cut business requirements, agile tasking work groups and team work.

Technical Skills:

T SQL, Erwin Data Modeler, ER Studio, Share Point, Architecture and Design, Excel, Word, Visio, Power Point Comparison Tools Visual Studio , SSIS, SSRS, DTS, BI, ETL, Crystal Reports, Microsoft Project, HP Quality Center, Jira, Testing Life Cycle, Promotion Processes, integration management, Data Governance, Meta Data management, Team Work PM and more.

Professional Experience

Confidential

Project Manager

• Obtained requirements for several different .net applications
• The project was a large mainframe, .net, database integration effort which produced reporting and upgrades to the existing system.
• Obtained requirements for several different data base structures and designs
• Liaison between development team and the business units
• Liaison between the development teams and the government agencies.
• Managed sprint meetings and product backlog
• Worked with the product item owners
• Planned the sprints and coordinated resources, budget and product analysis for each sprint interval.
• Managed a large Tiger teams in order to run several sprints in parallel.
• Designed a data mart to be used for Justice System reporting.
• Managed all KPIs to the appropriate business unit leads
• Managed scheduling of daily standup and all types of reporting to business leads Burn down, burn up, resource allocation, KPIs. BRD's, Technical requirements documents, diagrams, flow charts and so forth
• Involved and lead the design for the logical model which was used to create a successful dimensional data mart.

Confidential

Project Manager/Business Analyst/Scrum master

• Obtained the requirements for an enterprise data warehouse
• Managed using both Agile and Waterfall Methodologies
• Modeled the data-marts for reporting Star and Snow-flake
• Mapped the data to the EDW from other legacy systems
• Lead the JAD, Scrum sessions with the ETL and development teams
• Designed both a physical and logical model for the EDW/Data-Marts
• Managed scrum meetings and client relationships. Managed sprint back-logs
• Worked with the Product owners to identify Sprint objectives

Confidential

Project Manager / Business Analyst

• Business Analyst Project Management, Change Management. Create and gather business requirements, business processes and system requirements.
• Liaison between IT developers and the business units. Elicit business requirements from the client Transform those requirements into functional and non-functional requirements. Modeling Cubes, Dimensions and Data-mart for SSRS reporting Services. Gathered Requirements for SDLC Loan Applications process.
• Use Toad and HP SQL Editor to write Database queries to pull Data Sets
• Business Intelligence Model and design architecture experience. Use iRise and SharePoint for business requirements. Work in Large Customer- focused environment. Provide clear specifications to the software teams. Define functional and quality requirements for the PM.
• Work as PM to manage timelines using the Agile Project style.
• Certified with our HP Quality Center software for all testing requirements.
• Business Terms, field mappings and BRD Process.
• Involved with large scale project to merge many reporting systems into one Data Mart.

Confidential

Project Manager / Business Analyst-Data Analyst-Business Intelligence

• Working on a conversion project that involved Data Mining, Dimension tables, Cubing data and Dot Net VB application to a SQL 2005 Database. SSIS, T-SQL, Mapping procedures, gathering requirements and data analysis.
• Use iRise for business requirements. Converting data from many different data sources to the new Data-Warehouse and two Data-marts. SSIS, SSRS, DTS, SSAS.
• Gathered requirements worked with developers and clients to complete the project. Provide clear specifications to the software teams. Define functional and quality requirements for the PM. SDLC for the application Contact Management system.

Confidential

Business Analyst-Data Analyst-Business Intelligence

• Worked on multiple projects using the following tools: Microsoft Project, SSIS COGNOS, Query Analyzer, Profiler, Activity Monitor, DETA, DTS, Query Editor, Query Execution Plan Analysis, Erwin, Crystal Reports, Ralph Kimball Data Warehouse Techniques, and Performance Monitor.
• Worked with software engineers in the development and implementation of the latest technologies and systems in integration. Duty to define and drive the scope of technical software projects. Championed requirements analysis, meeting with business owners, and performing current state system analysis. Conceptual and technical designs, including the use of object-oriented analysis and design techniques. Testing Management and Execution - System, Integration, and Performance.
• Brought to the table analytic skills Conversion experience requirements, design, development, and execution. Facilitated requirements sessions and led all phases of the software development lifecycle. Worked with Service Oriented Architecture SOA , .NET Technologies, Databases SQL SERVER and ORACLE and enterprise applications.
• Worked with Developers to generate processes to govern the UAT to Production Life Cycle. Worked with SSIS T-SQL PL-SQL to query the database for solid relational information. Draft requirements and functional design documents. Analyze and mapped business processes. Provided input to the Quality Assurance team in creating and documenting testing scenarios and results. Worked with business intelligence and ETL. Analyzed data requirements, construct SQL queries, review DB models, and develop report design strategies. Gathered requirements for the Adapt SDLC Application.