OBJECTIVE

Business Systems Analyst

SUMMARY

Possesses over fifteen 15 years of as business analyst, data modeler, data architect, and other technology and manager roles. Worked in Wall Street, Silicon Valley, and global workplace for twelve 12 Fortune 500 and five 5 Dow 30 companies, including IBM, Cisco, AT T, AIG, Visa, Chase, Bank of America, Deutsche Bank, and Coach.

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst

Utilized MS Project, Microsoft Office Suite 2013, MS Outlook, MS Visio, MS Excel advanced features including Pivot and functions, and MS Word with macros, MS PowerPoint, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Oracle 11g, SQL Developer, PL/SQL with GROUP BY and SUBSELECT, SQL Plus, Quest Software Toad for Oracle Professional 10.1, SQL Server 2012 with T-SQL, SSAS, SSIS, SSRS, Data Quality Services DQS , and IBM DB2, SAP Crystal Reports 2011, SharePoint, WebEx, Extended Markup Language XML , LDAP, Lync 2010, HP Service Manager, Clarity timekeeper, PeopleSoft timekeeper, Informatica PowerCenter and Metadata Manager, Teradata SQL Assistant

Confidential

Business Systems Analyst, Solution Architect

• Created plans, timelines, statement of work, technical questions, and use cases from business requirements for Proof of Concept, Pilot of Data Strategy, Data Management, Data Lineage, and Data Governance initiatives, programs, and projects
• Reviewed and evaluated data mapping and data modeling processes for feasibility, revamp, and process improvement
• From the MassMutual Retirement Services Tech Strategy, formed a Data Strategy that includes policies, standards, and procedures for a Data Management Program that covers policies for Data Architecture, Database Administration, Data Modeling, Data Governance and Stewardship, Data Security and Privacy, Data Movement and Integration, and Data Lineage. Scope of review includes technologies in SAP, Informatica and Metadata Manager, Teradata and Financial Services Logical Data Model FSLDM , Oracle, OBIEE CRM, DB2, and, SQL Server.
• Reviewed Informatica PowerCenter 9.0, 9.1., 9.5, and 9.6 versions, and recommended and implemented a Proof of Concept POC with Metadata Manager in collaboration with Informatica consultants as solution to interrelate enterprise Executive Leadership Initiative, Business Architecture, Business Model, Tech Strategy, Data Dictionary, Teradata Financial Services Logical Data Model FSLDM , ERWIN data models, and Informatica Business Glossaries and Repository objects including data mappings, mapplets, source, target, data integration services.
• Kicked off Data Strategy Pilot by creating ontology structure, and verified traceability using Teradata SQL Assistant, Informatica Power Center and Metadata Manager and SQL Server.
• Used Windows 8.1, Microsoft Office Suite 2013 with MS Excel advanced features including Pivot and Functions, Informatica PowerCenter 9.6 Business Glossary and Repository, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Teradata, Oracle 11.2 SQL Developer and PL/SQL, SQL Server, DB2, SharePoint, WebEx, Extended Markup Language XML .

Confidential

Business Systems Analyst, PM, Solution Architect

• Collected and reported data asset and data model inventory, and determined that the scope of responsibility is 30 very large data models of 12,000 entities and tables and 110,000 attributes and columns.
• Analyzed, collaborated with managers, DBAs, analysts, and developers, and approved service request changes to Integrated Care Management System ICMS data models and databases.
• Gathered records and documentation of historical changes to data models and data bases of past 20 years.
• Used Microsoft Office Suite 2013, ERWIN 8.2, Oracle 11.2, SQL Developer, PL/SQL, SQL Plus, Toad for Oracle Professional 10.1, SAP Crystal Reports 2011, SharePoint, WebEx
• Confidential As Business Systems Analyst, Manager
• At FTR, a full service telecommunications company, managed projects, project managers, and fifty 50 development team staff. Projects include Customer Relationship Management CRM applications using services oriented architecture SOA via Enterprise Services Bus ESB , IBM Sterling-Comergent CRM, Salesforce services, and in-house DPI account and order management application services, and, Frontier.com customer-facing product and services ordering portal. Developers include project managers, team leads, data modelers, Java programmers, Salesforce analysts, Sterling architects and configuration experts, and business analysts.
• Managed and apprised VPs and Directors about project plan and timelines, progress, status, and open issues. Situated staff facilities and development environment, such as laptops, desktops, cubicle assignments, desk phones, access to Concurrent Versions System CVS , network ID, LAN connectivity, and integration and system testing environments.
• Collaborated and negotiated with concurrent development projects and initiatives.
• Coordinated with managers, recruiters, and contractor vendors on talent acquisition and onboarding requirements.
• Led data modeling team in assessing work load, timeline, and deliverables. Also, gathered requirements and defined new tables and columns required to accommodate new use cases, methods, and processes.
• Researched and prepared basic Android mobile device application development platform using Java and Eclipse.
• Used ERWIN, Oracle SQL Developer, DB Visualizer, SQL Server, MS Office Suite, MS Project, TSO, and other mainframe infrastructure software and tools.
• Confidential Managed efforts of and issue resolution in data modeling, data analysis, data migration, data architecture, data quality, and extract-transform-load ETL .
• Daily touched base with team staff onshore and offshore to gather and control progress and tackle open issues.
• Maintained open issues list with columns for title, long description, resolution explanation, unique tag number, reported date, resolution date, person and organization assigned, urgency, and criticality.
• Participated in joint application development JAD sessions with technologists, analysts, programmers, managers, executives, and architects to formulate solutions and project plans.
• Designed conceptual, logical, and physical data models and designed of Oracle target databases, and applied governance to corporate standards and industry best practices.
• Reported weekly to software provider executive and management team on progress, budget remaining and actual expense dollars, and human resources requirements.
• Reported biweekly to client managers and project managers the status of consolidated program and project plan summary, progress, open issues, and work in progress.
• Managed the account, project managers, developers, and development team staff in USA and India over several years long program of forty 40 application retirement projects migrating and archiving application data in DB2, SQL Server, Sybase, DATACOM/DB, SAP, Siebel, Oracle Transportation Management OTM , VSAM, flat files, and software-proprietary databases into Solix managed Oracle databases via Solix EDMS software and tools.
• Managed personnel onsite in WI and offsite in California and India with project, human resource, timesheet, and expense issues and management reports.
• Balanced and reported weekly the burn rate of provisioned contract hours and submitted change requests for more hours to completion.
• Managed project budget, timeline, and personnel onsite in WI, offsite in California and India with project, human resource, timesheet, and expense issues and management reports. Reported weekly per statement of work SOW actuals with estimate to completion ETC vis- -vis budget, submitted change requests for more hours to completion, and forecasted company revenues. Demonstrated superior manager ability and experience by delivering under budget and ahead of schedule all requirements.
• Interviewed and recommended candidates for technology roles and positions hiring.
• Used ERWIN, Oracle SQL Developer, DB Visualizer, SQL Server, MS Office Suite, MS Project, TSO, and other mainframe infrastructure software and tools.
• Confidential Managed a subproject under the Mainframe Elimination Customer Order Billing MFE COB project to migrate 400 million records from the mainframe to SQL Server and Oracle DBs using Solix EDMS, Informatica, and Crystal Reports, in collaboration with Solix offshore, in-house development, and DBA teams.
• Designed conceptual, logical, and physical data models and designed 2TB DB in SQL Server using fiscal date partitioning scheme across POC, Development, Test, and Production environments.
• Managed a team of developers in a second subproject to migrate MFE COB Daily processes and data into SQL Server archive DB, using Informatica, SSIS, and Toad.
• Managed, planned, collaborated, and implemented the Grinnell Archive solution migrating AS/400 General Ledger chart of accounts, Accounts Receivable, Accounts Payable, Human Resources, and Payroll historical transactional data into SQL Server 2008R2 archive DB.
• As SQL Server Architect, designed, modeled, planned, deployed, tuned, and validated Grinnell Archive Solution conceptual data model, logical data model, physical data model, and DBs onto local host, Development, Test, and Production environments.
• Confidential Successfully managed and implemented into Production the Docketing Project for the Legal Department that installs Thomson Reuters Intellectual Property IP Manager as the replacement intellectual property IP software and converts patents, disclosures and trademark data into the IP Manager database. Moreover, the project includes installing and implementing specialized search engine tools from Xpriori that copies, annotates and catalogs relevant Legal Department electronic case materials and documents. Oversaw project managers from DIRECTV that manages the IT Infrastructure preparation of managerial and technical, hardware and software support, and, Thomson Reuters that execute the data conversion. Collaborated with several business units with various IP competencies.
• Successfully managed and implemented into Production the Fraud Management System Countermeasures FMC project that includes an enterprise integration EI programmer via Oracle and Neural Technologies software solutions. FMC automates manual procedures that manage identified fraud subject accounts. This entailed overseeing an analyst programmer and collaborating with other IT hardware and software development teams.
• Applied Project Management Professional PMP , Project Life Cycle PLC , System Development Lifecycle SDLC , and DIRECTV IT Lifecycle principles at every stage of projects by creating subprojects, recommending Phase Two, Phase Three, and Phase Four accomplishments and deliverables, resolving conflicts, negotiating milestones, collaborating among two software vendors, infrastructure support, Legal Department management, and service support staff under enterprise implementation environment standards and constraints, and, writing and publishing handover documentation and guides.
• Wrote high level project definition report PDR document that includes project business objectives, key business assumptions and dependencies, make versus buy questionnaire, current and proposed business process flow, current and proposed system use case, current and proposed collaboration diagram, current and proposed high level design HLD , security impact, business data model, disaster recovery levels, user interface approach, potential systems solutions, data migration approach, test strategy, capital project appropriation, contact list, gap analysis, service level agreements, risk assessment, volume and growth estimates, functional requirements, usability questionnaire, reporting requirements, application interface diagram AID , standards compliance, technical and implementation standards, design approach, data conversion requirements, data retention requirements, business partner requirements, and project implementation plans , technical design specification TDS , and collaborated with IT Infrastructure, Thomson Reuters and Xpriori vendors to form a technical architecture diagram TAD . Interviewed and gathered requirements from business managers, software vendors and users. Completed Planview project portfolio requirements and documentation.
• Reverse-engineered and documented data models of Thomson Reuters IP Manager, PATS application, CPI, and other intellectual property databases.
• Wrote Crystal Reports Development Guide to assist the business in designing reports.
• Used UML logical, sequence, activity, state, collaboration, and class diagrams, Crystal Reports 2008, MS Visio, MS Project, MS SQL Server 2005, Clarity ePlan, Planview Project Portfolio Management, Thomson Reuters IP Manager 2.1, Xpriori XCM, ERWIN 7.3, and Embarcadero ER/Studio 8.0.3.
• Confidential For Cisco, managed IntelliShield development program and projects for acquisition transition and integration into corporate standards, procedures and governance.
• Applied Six Sigma DMAIC and continuous process improvement CPI principles to fine-tune enterprise business processes and save millions of dollars in manual processing, software licensing and development costs.
• Designed data architecture for the Intelligence Creation and Distribution ICD data store and information flow.
• Wrote business requirements documentation BRD and functional specifications documentation FSD for the Cisco Security Center CSC program and projects, successfully released to public at RSA Conference.
• Designed data architecture for the Intelligence Creation and Distribution ICD data store and information flow.
• Used UML XML, Agile, logical, sequence, activity, state, collaboration, and class diagrams, MS Visio, MS Project, MS SQL Server 2005, MS Access, Clarity, Planview Project Portfolio Management, and ERWIN 7.3
• Confidential For Countrywide Tax Services Corporation CTSC as business analyst, designed Program Management Office PMO process in collaboration with the CIO, SVP, VPs, and business analysts, which manages portfolios, programs, and projects from proposal, SOW, charter, prioritization, approval, budgeting, initiation, planning, execution, monitoring, closure, and project review.
• As a Project Manager and Enterprise Data Architect, responsible for the Enterprise Data Model EDM of CTSC as a third party tax service startup. As CTSC prepares to be spun off in 2 years, designed the EDM to support the future CTSC business model and held JAD sessions with the President, CIO and top management. With the EDM split up into several subject areas, managed the Agency, Customer, Service Master, Delinquency, Procurement and Property Database Subject Areas with three people in the Logical Data Model LDM team: a subject matter expert SME and 2 system analysts. Wrote business process flowcharts, use cases, activity, state and lifecycle diagrams, using UML and Visio.
• Designed Program Management Office PMO process in collaboration with the CIO, VPs, and business analysts, which manages portfolios, programs, and projects from proposal, SOW, charter, prioritization, approval, budgeting, initiation, planning, execution, monitoring, closure, and project review.
• Implemented Business Intelligence solutions via the integrated company portal. This includes an Executive Dashboard of company performance metrics in online, real-time graphs and reports, Financials Data Warehouse, System Performance Data Warehouse, Database Management Data Warehouse and Data Model Data Warehouse. Used SQL Server Reporting Services, Analysis Services and Data Transformation Services, Share Point Services, FrontPage, Excel and ERWIN.
• Audit databases and data models for compliance to approved controls, standards and procedures.
• While implementing the Enterprise Architecture framework, as the Enterprise Data Architecture governor and member of the Architecture Design Board ADB and Architecture Review Board ARB , wrote up and enforced Data Architecture Standards Checklist, Reference Guide and CTSC Data Architecture documents. Provided data modeling, business analysis, database administration and business process modeling expertise to development projects and managers. Wrote and designed contextual models, conceptual models, semantic data models, logical data models, physical data models, as well as installed databases over several applications such as National Directory Repository NDR , Tax Sale Tracking TST , Tax Exception Processing TSEUP , Tax Bill Tracking TBT , Application Management System AMS , and other projects.
• Designed, implemented and published a Portal to display the Enterprise Data Dictionary using ERWIN, Microsoft SQL Server Reporting Services, Microsoft Share Point Services and Microsoft .NET Framework Visual Studio.
• Assisted in the formulation of plan to handle and satisfy Sarbanes-Oxley SOX requirements.
• As SQL Server 2000 Application Database Administrator DBA , created tables, performed DB maintenance, and fixed database program bugs.
• Used UML, Zachman, Microsoft Data Architecture, Gartner Research and Troux Enterprise Architecture frameworks, All Fusion ERWIN data modeling tool, FASTER/SE like Six Sigma methodology, SQL Server Enterprise Manager, SQL Analyzer, TRANSACT-SQL and Reporting Services, AS/400 DB2 UDB, VISIO, Visual Studio, VSS, HTML in a .NET and Visual C environment, Lotus Notes Domino.