Ms Sql Server Management Studio Resume
SUMMARY
- 30 years working on group and individual projects simultaneously, T - shaped skills, With so many I-shaped skills, Think Ben Franklin
- 22 years application support, system & business analysis, system and database design and testing - team motivator, mentor, leader
- 22 years IBM mainframes, Syncsort, Fileaid, TSO, Procs, ZOS / OS MVS JCL, Gener, JES3, COBOL, TSO, ISPF, ESA
- 22 years experience with Systems Design Life Cycle in a Client Server Environment, SDM, SDLC, RUP
- 22 years experience with IMS DB/DC, MFS, DLI, BMP, BMC SOFTWARE, Checkpoint Restart, VSAM
- 22 years experience with Translating Business Strategy/Drivers into IT requirements - Project Estimations
- 22 years experience with the definition & enforcement of standard data element names, abbreviations, characteristics, values, aliases.
- 22 years experience with the enforcement and maintenance of governance policies, processes, performance measurements, UX/UI Design
- 16 years experience with Microsoft Office (Word, Excel, Project Manager, Power Point etc.) DB2, SPUFI, QMF, SQL, Binds, Declgen, Joins, Cursors, Dynamic SQL
- 16 years experience with Project Discovery approaches and estimations RFI/RFP/RFQ / RFC monitoring
- 4 years experience running my own business, monitoring & modifying Best Practices Hands on experience in developing and managing Business Intelligence applications
- 4 years experience Data Migration Project - Mostly Mainframe Data and Teradata to Hadoop
- 2 years experience JAVA, Focus, Halappi, Scripts, HTML, REXX, Java, Stored Procedures triggered by Java, WLM, BMC Software, Stored Procedures
- 2 years experience with State Clients 1 year coding experience CICS 6 years design; 6 months Princeton SofTech's Relational Tools “Move For DB2”
- Utilized quality disciplines to manage new application development projects through complete project lifecycles
- Experience with and gut level understanding of ITIL, Waterfall, RUP, & Agile, Unified Software development methodology.
- Work effectively with senior management in planning future feature development and implementation.
- Participating in the budget & long-range strategic planning process. management strategies. Proven ability to contribute to long-term company success & profitability
- Creatively view (and suggest solutions to) problems arising from changing business process variables.
- Used my experience providing insight into key business dynamics such as competitive activities and industry trends. Senior Advisor to the Release Planning Team
- Deep understanding of Business, Market and Industry functionality and current IT trends - Responsible for Project Success
- Served on the following teams: ISG, ITSCM, CMS, SKMS, SPM, CAB, CSIP, PIR, SPM, BAR and BSA
- Versatile and Experienced Business Analyst with a solid background fueling process improvements in regard to cost, performance & efficiency.
- Adept communicator with expertise in strategic planning, competitive analysis, assessment, team leadership and project management.
- Exceptional written and verbal communication skills and interpersonal skills. Proven ability to contribute to long-term company success and profitability
- Self-motivated with can-do attitude; adaptive with the ability to grasp things quickly. resolved conflicts to drive decisions
- Proven experience in significant, complex multi-tier architecture, multi-million dollar software development
- Relationship manager with product owners and development teams to create an environment of continuous improvement. A team builder.
- ITIL is the liaison between technical and non-technical personnel - includes Value Added and Business Best Practice guidance, Identify Key Performance Indicators, Project Metrics, Milestones, Key Deliverables, Risk Abatement, Company wide approach to IT integration
- PRINCE2 & PMBOK Knowledge, Life insurance and Real Estate licenses - Intimate knowledge of Contract Law & Insurance
- Served on various Governing Boards of NP organizations for many years advising on planning, strategy, personnel issues
TECHNICAL SKILLS
LANGUAGES: COBOL II, MF COBOL OS MVS JCL SQL EASYTRIEVE, QUICKJOB, REXX, CLISTS FOCUS, MARK IV, SAS, CICS OS JCL JES 2, JES 3 MVS XA ZOS Windows XP, 7 AS400 Client Server, NDM, FTP
SOFTWARE: CA7 and UCC7 Lotus Notes, Outlook, SharePoint MS-ACCESS, PROJECT, EXCEL, WORD, Visio, PowerPt. Workbench / Animator FTP and MQ Series - TCPIP TSO ISPF ESA - EXPEDITER - HALLAPI Spufi, QMF, SQL, DB2 v 9 IMS DB/DC DLI & BMP & MPP & MFS & BTS FILEAID / FILEAID IMS IBM UTILITIES ABEND AIDE CHANGEMAN, ENDEAVOR, APS, PUPS, DCCS
Data Architecture: Use Cases Wireframes UML Logical Data Designs/Models Data Integrity / Profiling Embarcadero Data Modeling Tool Data Warehousing / Facets Data Mapping / Mining / ETL Referential Integrity Identify Data and Solution Patterns Inovis-data normalization Source to Target Mapping Business Intelligence Data Modeling, Data Blending, Taxonomies
Other Tools / Skills: Functional Design Doc. Process & Event Diagrams Project Scope Definition Project Charters / Scope / Feasibility Resource Management Fit - Gap -Trade-Off Analysis CRUD, System & Program Flow Diagrams / Traceability Matrix JAD Chairperson RACI Chart DevelopmentPrioritization and Management of Requirements & Deliverables Full SDLC and RUP Group Motivational Skills Offshore/ Cross Cultural /Cross-Functional Project Management Strategy/Roadmap/BPR RAD / Agile Development Project Rollout Control / Software DeploymentQuality Assurance / Metrics Cost/Benefit Analysis - ROI Trend Analysis, Capacity Planning, Resource Plans, Budgets Project Proposal Prep
PROFESSIONAL EXPERIENCE
MS SQL Server Management Studio
Confidential
Responsibilities:
- Defined SLAs, Populated the Document Repository - Aggressive Project Plan to close open tickets. Ran reports on SAP often using Crystal Reports.
- Used Confluence's task management feature to delegate, monitor and track changes to tasks assigned to each employee. Used Cisco Jabber for IM.
- Queried SAP Universes, SAP Containers using SAP/ Query Builder. Provided BI solutions to customers.
- Tickets tracked tru ServiceNow. Queries developed tru SQL Server Management Studio. Success Tickets closed in a timely fashion.
Chief Designer/Solution Architect/Data Analyst/Data Investigator
Confidential
Responsibilities:
- Data Migration Project - Mostly Mainframe Data and Teradata to Hadoop
- Agile - Sprint Based Project Plan, Standup meetings, implement features from the product backlog, Gathered feedback on Project Deliverables. Jira Tickets
- Document repository - Confluence, Aggressive Project Plan to Analyze complex COBOL code. Rectify Logic, Reduce Redundancies. Gathered Requirements.
- Used Model Driven Architecture (MDA), Service Oriented Architecture (SOA)
- Intermediary between Business & Off Shore Development Team. Developed the Look of the Solution Documents. Project on schedule Customers very Happy
- Picked up a full-time non-career related job while aggressively searching for career related work. Interim Job that does not belong on my resume. No I will not document this job.
Implementation Business Analyst/Trainer
Confidential
Responsibilities:
- Agile - Monitor Burndown, Backlog, Standup meetings, Use Case Points, Actor Definitions, Story cards. implement features from the product backlog
- Shareable Content Object Reference Model (SCORM) - XML framework to define and access learning objects data shared learning management systems (LMSs)
- SACWIS is CRM(customer Relationship Management) on Steroids. Think SALESFORCE w ultra-high security & without boundaries in a dynamic environment.
- All that personal information that cannot legally be gathered is collected, organized and stored on government servers for secure dissemination.
- Much of what I did is part of court ordered changes, lawsuit prevention, family privacy issues. Lives depend on what I do. Child welfare is the highest priority.
- Complete each sprint on time under budget. Please understand and respect that I cannot say much about this job. Created User Stories
- Picked up a full time non-career related job while aggressively searching for career related work. Interim Job that does not belong on my resume. No I will not document this job.
Business Analyst/Architect
Confidential
Responsibilities:
- Data Migration Project - Mostly Mainframe Data and Teradata to Hadoop
- Coordinated re-development and testing (detailed Test Plans & Test Cases) of 3 processes that are the proprietary core of AML @ JPM. SAP BO links.
- Coordinated the large parallel test of Teradata to Hadoop with off shore 3rd party supplier TATA. Wrote the requirements for changes to the batch processes.
- Since JPM was moving from Teradata to Hadoop - they decided to reconfigure some of the AML processes to streamline mainframe code, ITSM Framework
- I spent much of my time tracking down connections and explaining why Business Objects were not working as they had in the past, DDL, Link, server problems.
- CMDB - designed the structure to gathered elements and guided customers on how to create ad hoc reports. Completed project on time under budget.
Vehicle Ordering Process
Confidential
Responsibilities:
- Streamlined processes and documented process improvements. Managed 16 major data refreshes in less than a year. Coordinated with off shore 3rd party. Chaired CAB
- Signed off on 3rd party supplier. Created project charter, work plan, business and technical objectives of a project while working closely with project sponsor. Built an effective team.
- Established project organization, methodologies & defined roles and responsibilities. Followed industry practices such as the PMI's framework. Run Books.
- Owned the Release Management lifecycle including scheduling, coordinating & the management of releases Go-Live activities. Responsible for measuring KPIs to provide baseline metrics.
- Designed, planed, coordinated work and managed relationships between different teams at different locations, Ensured that the project plan was successful.
- Responsible for the planning, design, build, configuration, testing of all software to create the release package. Communicated to stakeholders.
- Maintained release schedule for all services, ensure alignment across partners & vendors. Directed corrective actions when performance fell below objectives.
- Provide leadership & guidance, best practices to release management/delivery team. Recruit & manage a release/deployment team, made of employees & contractors both on/off-shore.
- Created structure in a complex environment w emphasis on quality, productivity, consistency. Set deadlines, assigned responsibilities, and monitored progress.
Mainframe Support / Business Analyst
Confidential
Responsibilities:
- Supported the Meijer Credit / Debit Card processing system - COBOl, Easytrieve, IMS, DB2,TSO, Interface to Web-based applications User Stories. Persona Def.
- Created system documentation where there was none. Provided on and off site 24/7 support for critical systems. SKU processing, Live testing
- Front-line support for customer calls and emails by taking ownership and accountability for the call resolution process. Created & closed Remedy Tickets
- Managed incidents, defects & change requests. Prioritize requests from other project managers. Personal gratification I can go back to basics and be successful
Mainframe Support / Business Analyst
Confidential
Responsibilities:
- Supported the largest Warehousing complex in the USA - ,Interface to Unix. SharePoint testing.
- Front-line support for global customer calls and emails by taking ownership and accountability for the call resolution process.
- Facilitated timely turn-around of production abends, customer service requests, and post-launch issues. FTP, EDI, MQ Series
- Managed incidents, defects and change requests. Prioritize requests from other project managers & 3rd Party Vendors. Created User Stories
- eTracker Tickets for Change-Man and Endevor issues. Personal gratification that I can go back to basics and be successful
Test Lead/Business Analyst
Confidential
Responsibilities:
- Business Process Redesign – Wrote Test Cases conducted JAD sessions, Built Financial Models to represent real world experiences. Served on CMS team.
- Facilitated global requirements meetings w stakeholders & suppliers. Issue Management, Product Disposition–The clearing point for Direct Enrollment
- Manage customer issues by gathering clear, concise description of the problems, investigate customer incidents. Tested feedback to reinsurance, risk assessment
- Created and maintained Project Status Dashboard, tested Business Objects. Created User Stories -Prioritization & Management of Requirements & Deliverables
- Edited XML files Inbound Requests/Outbound Requests IBR / OBR - Participate in defect reviews – automated SharePoint testing, Requirements Traceability
- Met Government Mandated start of FFM / Exchanges part of the Patient Protection and Affordable Care Act (PPACA- AKA Obama Care) avoided penalties.
Lead Bus/Sys Analyst/Coordinator
Confidential
Responsibilities:
- Business Process Redesign – Wrote requirements conducted JAD sessions, VISIO, Issue Management, Built Financial Models to represent real experiences.
- Participated in the process of configuration management. Created a traceability matrix of the requirements to design using MS Excel. Created User Stories
- Requirement elicitation via interviews with business & technical staff Incorporate these requirements into a variety of artifacts. SSRS reporting, Peer Reviews
- Used data from Actuarial Data Stores to create live representations of MLR calculations to enhance the dialog for Call Center clerks. Reinsurance, Risk Corridors,
- Process redesign to meet customer objectives. My Success was a completed test system design - verified to user satisfaction
Lead Bus/Sys Analyst/QA Test
Confidential
Responsibilities:
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Context Diagram, Actor Definitions - Data Mapping – Issue resolution. Business Process Redesign
- Multidimensional, metadata analysis. Maintain safety, security, and privacy standards Created User Stories. Wrote the BRD, Test Cases, Test scripts, Technical Specs.
- Participate in Defect Triage, issue investigation and resolution customer/support as appropriate. Prioritize, escalate and track incidents according to the SLA. – Hands on leadership
- Business Process Redesign – Wrote requirements conducted JAD sessions, VISIO, Issue Management, Built Financial Models to represent real experiences.
- Lead Development of Requirements Project Rollout Coordination & Control - Completed test system design - verified to user satisfaction
Data Modeler QA Test
Confidential
Responsibilities:
- Met w customers, chaired JAD meetings. Gathered & Documented Business Requirements, Processes Installation, Issue Management, Product Disposition. Hands on leadership. Coded SQL
- Communicate with system end users to gather system feedback, conduct defect reviews, improved functionality. Multidimensional, metadata analysis - Lead Development of Requirements
- Business Process Redesign – Wrote requirements conducted JAD sessions, VISIO, Issue Management, Built Financial Models to represent real experiences. Actor Definitions.
- Wrote the Detail Test Design - Lead Development of Requirements - Wrote Technical Specs - Used SAS for ad hoc reporting. Excellent ability to plan, document and develop procedures.
- Defined stage scope and boundaries via deliverables and timetable – defined business case. Completed test system design. Project Rollout Coordination & Control – Customer Delighted
Supplier Change Lead Bus/Sys Analyst
Confidential
Responsibilities:
- SLR-Defined stage scope and boundaries via deliverables and timetable – defined business case – update risk log - Business Impact Analysis Business Objects Reporting/Design. VISIO
- Lead Development of Requirements - Wrote Technical Specs- Use Cases – Data Mapping. Business Process Redesign. Issue Management, Installation, Product Disposition, Wireframes
- Excellent ability to plan, document & develop procedures, and objectives in support of critical projects for clients – Resource Planning. The focal point for questions.
- Manage deployment of web-based, Client-Server, & Mainframe applications. Member of the change advisory board (CAB. Organize and conduct vendor evaluation
- Wrote requirements, conducted JAD, Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Validated code to requirements - Saving the State $50 million
Management Lead Bus/Sys Analysts/Data Modelers QA Testers
Confidential
Responsibilities:
- Led the effort to optimize Business Processes using advanced IT tools - measurable cost savings – Cost Benefit Analysis - Completed Power Point documentation and presented it to the client
- Provided technical, user and business assurance documents during the start and middle of the project - Data Mapping – Business Architecture - Embarcadero Data Modeling Tool
- Design and Development for both OLTP and Data warehousing environments. data mapping. Participated in the ongoing process of configuration management. Business Process Redesign.
- Wrote Context, Entity Relationship, Data Flow, Use Case, Class, Activity, Sequence, Extensions Diagrams, Wireframes, Business Rules, Traceability Matrix, Business Objects/Artifacts
- Wrote requirements conducted JAD sessions, VISIO, Issue Management, Built Financial Models to represent real experiences. Solutions embraced by Stakeholders.
Lead Bus/Sys Analyst / Data Modeler QA Test
Confidential
Responsibilities:
- Medicare, Medicaid, and HIPAA transaction processing – Claims Medical Billing – took control of the project– Issue resolution Wrote the Detail Test Design - Wrote Technical Specs. ETL
- Built a system to compare 837 Facility & Professional local transactions to NASCO – DB2 Applied Knowledge of Business-IT to requirements - Lead Development of Requirements
- Built test cases, executed tests and verified results– took control of MS Project – tested feedback links -Wrote the Comprehensive System Design, Analyzed Customer Technical Requirements
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Wireframes – translate requirements to functional specs. Business Process Redesign –
- Wrote requirements conducted JAD sessions, VISIO, Issue Management, Built Financial Models to represent real experiences. Business Objects Reporting/Design.Mapped Data Nasco to BC.
- Project Roll Out, Coordination & Control Completed test system design, built, and executed tests verified to customer satisfaction – Process verified that MOS works - $40M saved
New Development / QA Programmer/ Analyst
Confidential
Responsibilities:
- Moved DB2 data between Prod. & Test environments via Princeton Softech’s “Move for DB2” Developed Business Cases / Use Cases Built test cases, executed tests and verified results-
- Developed Event Diagrams, Process Diagrams, System and Program Flow Diagrams, Wireframes – Data mapping used Test Director and Share Point for QA used RUP SLC & Ford SDM
- Business Process Redesign – Wrote requirements conducted JAD sessions, VISIO, Issue Management, Built Financial Models to represent real experiences. Built the Stored Procedure interface between JAVA and DB2 using Stored Procedure Builder / WLM / DB2 Connect– Project Successful- $100M savings
Management Project Leader
Confidential
Responsibilities:
- Lead Development of Requirements Project Rollout Coordination & Control - Business Impact Analysis – Business Process Redesign SKU Processing
- Responsible for diagramming Mainframe / Web systems using Visio - Prioritization & Management of Requirements & Deliverables Micro Focus re-hosting. Used SAS for ad hoc reporting
- Responsible for training and giving direction to new employees - MS Project - Business Continuity Planning – Issue resolution - Cost Benefit Analysis. Supervised 20 people most offshore.
- Cross Functional / Divisional / Corporation Planning – Resource Planning & Reallocation – Disaster Recovery Design. Participated in the ongoing process of configuration management.
- Built test cases, executed tests and verified results- used Test Director and Share Point for QA– automated testing Created a document repository – Developed ad hoc Task Forces
- Wrote Rexxes that queried DB2 tables to format reports on data structures – Data Mapping /Data Design - Chaired and organized meetings to finalize efforts to create new test environments
- Became the focal point for questions from the Ford & Visteon sides – Business Architecture Used JAD Applied Knowledge of Business-IT to Requirements, Ford SDM
- Part of a Large Team the Largest Single IT Project Ever and it was Successful SEC satisfied
