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.
• Supply Chain - Purchasing area. Order Management, WMS, and Procurement.

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 Manager tasked 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/Business Analyst/Scrum master

• The project was a large mainframe, .net, database integration effort which produced reporting and upgrades to the existing system.
• Obtained requirements for several different .net applications
• Obtained requirements for several different data base structures and designs
• Supply Chain - Purchasing area. Order Management, WMS, and Procurement.
• 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
• Supply Chain - Purchasing area. Order Management, WMS, and Procurement.

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.
• Supply Chain - Purchasing area. Order Management, WMS, and Procurement.

Confidential

Business Analyst-Data Analyst-Architect

• 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.
• Responsible for the development and implementation of the Arms Ordering System which was stored in several SQL Server databases. I was the Lead Architect and Business Analyst for the internal Arms System. The system was designed with nine points of entry which required Transaction Replication over many servers and instances. Facilitated requirements sessions and led all phases of the database development lifecycle.
• Worked with Developers to generate processes to govern the UAT to Production Life Cycle. Wrote SQL Queries worked with Erwin and designed the database to third Normal Form. Worked in an iterative development environment and participate in all phases of a project. Gathered requirements for multiple applications and processes.
• Worked closely with both the user community and the IS technical staff to assure consistent interpretation of the user requirements throughout the construction phase of projects. Provided input to the Quality Assurance team in creating and documenting testing scenarios and results.
• Collaborated with business users and owners to identify, analyze, and improve processes or reengineer them as they relate to the priorities of the organization and the technological capabilities of the organization. Worked with Systems Analyst to develop prototypes and have them validated by relevant stakeholders.
• Worked with business intelligence and ETL. Analyzed data requirements, construct SQL queries, review DB models, and develop report design strategies.
• Supply Chain - Purchasing area. Order Management, WMS, and Procurement.

Confidential

Business Analyst-Architect

• Supported production environment. Supported one cluster with ten instances and three thousand users. Technology support for stored procedures, triggers, views, constraints, data model Erwin , source safe, DTS. Responsible for backups, restores and daily performance activities including database security. Used Crystal Reports as the reporting Tool. Supported three databases on one cluster.
• Migration of data from Lotus Notes into relational SQL SERVER Tables. Involved with .Net Application workflow processes into the relational tables. .Net applications which used a SQL SERVER Data Warehouse. Designed and developed both OLAP and OLTP databases. Provided input to the Quality Assurance team in creating and documenting testing scenarios and results. Development processes involved with the CMS.
• Collaborated with business users and owners to identify, analyze, and improve processes or reengineer them as they relate to the priorities of the organization and the technological capabilities of the organization. Worked with Systems Analyst to develop prototypes and have them validated by relevant stakeholders.

Confidential

SQL Server Database Administrator

• Project Lead worked as a contractor developing several different front-end applications in Lotus Notes. The front-end applications migrated data into a SQL SEVER repository.
• Maintained and developed the SQL SERVER database structure. Responsible for the finance application data store. Objects created were stored procedures, views, triggers, constraints, tables, indexes, reporting services with Crystal Reports.
• Responsible for backups, restores, database performance tuning. Developed a new Data-Warehouse OLAP

Confidential

Lotus Notes Developer/Architect

• Developed three databases with the complete architecture of the notes global setup and configuration. Wrote global advisor, a global application used for calculating taxes and IA's account information. Also wrote two sales applications. These three databases were written in Notes Script and Functions. Global advisor was written for Domino and placed out on the internet for viewing reports. These three databases were written to support all IA and sales activities in the field.
• The project was developed under budget and was placed into production two months before the deliverable dead-line.
• I traveled to other companies to write scripts that enhanced applications for the user community. I was the project consultant ensuring that Infrastructure to support all Notes databases were in place before the application was put into production. Used Notes Pump to port data into an Oracle Data Warehouse.

Confidential

Responsible for traveling around the country installing networks and notes servers. Responsible for installation and configuration of all Lotus Notes servers Os2 and Novell Wan. Supported over 1500 users. Developed the following databases: Cost tracking, Inventory Tracking, Care tracking and Purchase order system.