Data Modeling Analyst Resume
PROFESSIONAL SUMMARY:
- I have worked across traditional boundaries in Information Technology, embracing my passion for listening and teaching with a focus on helping those who use technology in an organization to work more productively and efficiently.
- My experience spans over twenty - five years in all facets of Information Technology, across non-profit to commercial environments, for pre-IPO to Fortune 500 Companies. I have been recognized for delivering leading edge solutions and consistent meet complex business requirements.
- I have gaining successive proficiencies in mainframes, client-server environments, Internet and cloud-based IT.
- I have hands-on expertise process improvement, software development, data management, and the disciplines of creating facilities that power reliable and scalable applications.
- I have provided clients and employers with data quality excellence and innovation in data management, software implementation, and compliance in the Information Technology, healthcare, telecommunication, insurance, finance and manufacturing industries.
- I have built and implemented applications and system while managed teams of database architects, network engineers, and end-user support specialists and developers.
- I have mastered technologies from operating systems (Windows and Mac) to application development, and integration.
- I am a trained individual whose role is to over-see the business process analysis and execute the collection, elicitation, and recording of business requirements for more and better strategic project developments.
- The job description of this position entails evaluating and analyzing activities on a large scale, and streaming of projects and programs with an understanding of the business needs so as to be able to intuitively shape and craft business solutions to meet the desired results.
- As a Lead/Senior Business Analyst I served as an intermediary between the executive and business unit with regards to the company’s top priority projects. This also requires me to work closely with senior business heads in the development and execution of program strategy, and also facilitates negotiations and settling of conflicting priorities that may arise between parties involved.
- In my position, as a Lead/Senior Business System Analyst I am required to help identify solutions to business priorities by working with Developers, Program Manager, Project Managers and Architecture team members in order to ensure that the project meets Business Requirement.
- Also as a Lead/Senior Business System Analyst I creating and carrying out test plans according to client region specification on specific projects, and confirming that all codes for custom projects are duly implemented for effective operation. Create Implementation plans, oversee the warranty time period, train support staff and act as tier three support staff for production issues.
PROJECT RELATED COMPETENCIES:
- Understands the business issues and data challenges of IT and Business Partners organization and industry.
- Identifies organization's strengths and weaknesses and suggests areas of improvement.
- Critically evaluates information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
- Successfully engages in multiple initiatives simultaneously.
- Develops functional specifications and system design specifications for client engagements.
- Applies the full life-cycle development management (business requirements, functional requirements, use cases, design, development, testing, and implementation) in both large projects as well as significant segments of large complex projects.
- Leads testing efforts.
- Assimilates new information and responds to ad-hoc requests, ensuring that issues are identified, tracked, reported and resolved in a timely manner.
- Works with organization personnel to identify required changes.
- Communicates needed changes to development team.
- Assists in enforcement of project deadlines and schedules.
- Takes input from supervisor and appropriately and accurately applies comments/feedback.
- Communicates and applies project standards.
- Manages resources in accordance with project schedule.
- Consistently delivers high-quality services to the organization.
- Understands the components of running a fiscally successful project.
CAREER PATH CORE COMPETENCIES
- Proactively communicates and collaborates with external and internal customers and stakeholders to analyze information needs and functional requirements by documenting them in functional and business requirements documents.
- Uses meeting management techniques to gather requirements, plan team meeting agendas, manage time frames, and conduct meeting activities.
- Develops requirements for specifications according to standard templates, using natural/business language.
- Organizes and conducts informative, well-organized presentations.
- Manages the handling of difficult and/or sensitive information tactfully and in accordance with necessary protocols (ITAR standards).
- Maintains and increases professional and technical knowledge by attending workshops, reviewing professional publications and establishing internal and external networks.
- Develops and analyzes strategies to improve the effectiveness and efficiency of existing systems.
- Utilizes information technology techniques that improve systems performance, interoperability, and customer satisfaction such as data integration, non-duplication of data sources, data query optimization, and recognition of data or application complexities which may require the involvement of central IT and/or other business analysts.
- Possesses understanding in the areas of application programming, database and system design.
- Understands Internet, Intranet, Extranet and client/server architectures.
- Understands the way in which legacy and web-based systems interface with each other.
- Identifies critical issues with ease.
- Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems.
- Pushes creative thinking beyond the boundaries of existing industry practices and client mindsets.
- Generates enthusiasm and trust among team members.
- Proactively seeks opportunities to serve in leadership roles by providing direction and support to less experienced analysts to orient them and increase their understanding of complex business analysis functions and industry requirements.
- Challenges others to develop as leaders while serving as a role model.
- Manages the process of innovative change.
- Collaborates with developers and subject matter experts to establish the technical vision and analyzes tradeoffs between usability and performance needs.
- Coordinates technical and user testing, plans and coordinates deployment, and designs appropriate measures to report on success of client/user acceptance testing.
- Facilitates effective team interaction.
- Acknowledges and appreciates each team member's contributions.
- Develops relationships with organization personnel that foster IT/business partner ties.
- Communicates effectively with personnel to identify needs and evaluate alternative business solutions with project management.
- Continually seeks opportunities to increase customer satisfaction and deepen IT/business partner relationships.
- Manages business partner expectations effectively.
- Conducts effective progress evaluations in a timely manner.
- Mentors those with less experience through informal channels.
- Seeks and participates in development opportunities above and beyond training required by us.
- Trains other innovators through both formal and informal training programs.
- Suggests areas for improvement in internal processes along with possible solutions.
- Leads internal teams and task forces.
- Manages new software launches and upgrades.
HIGH TECH CORE COMPETENCIES:
Management Skills: Operations/Portfolio Management ~ Conflict resolution ~ Diverse knowledge of providing effective business strategies and solutions ~ Project and Program Management ~ Business Knowledge ~ Technical & Production Support ~ Information Systems Management ~ Vendor Relations & Management ~ Business Process Development ~ Staff Mentoring & Supervision ~ Coaching & Training ~ Cost & Resource estimates ~ Process Improvement ~ communicator ambassador ~ Ability To Self-Evaluate ~ Excellent communication skills ~ Excellent presentation skills ~ Adapt Quickly ~ Strong willed ~ A Creative Artist ~ Problem Solver And Initiator ~ Exquisite attention to detail ~ Innovative & Creative ~ Take Charge and Lead ~ Project Life Cycle Management ~ Risk Management ~ Team Management ~ Measuring Project Velocity ~ Good multi-tasker ~ Organization ~ Developing & Implementing Standards ~ Developing & Implementing Procedures ~ Supervise & Development Team Members ~ Release Management ~ Internal Audit & Sox compliance
Solution / Application Architecture: Service-Oriented Architecture ~ Business Process Mapping ~ Software Development Life cycle ~ Business Process Modeling ~ Process Analysis & Redesign ~ Application system development ~ Implementation ~ integration development ~ infrastructure development ~ ERP Module implementation ~ System & Application Development ~ reverse-engineering architectures from existing structures ~ Exemplary general IT knowledge (applications development, testing, deployment, operations, documentation, standards, best practices, security, hardware, networking, OS, DBMS, middleware, etc.) ~ Experience with interaction with legacy systems and phased application integration ~ Certify Solutions
Senior Business Analyst: Client facing Business Analyst ~ System Development Life Cycle (SDLC) ~ Waterfall ~ Project Lead ($0.25 million in value and 6 months or more in duration) ~ Requirements Gathering (RRDs)~ Functional Documentation ~ Technical Documentation ~ Data Migration/Mapping ~ Use Cases ~ User stories ~ Version Control ~ Test Cases ~ Test Plans ~ Training Materials ~ Training ~ Integration Plans ~ Implementation Plans ~ Business & Systems Solutions ~ Inter-/Intra Organizational ~ Stakeholder Communications ~ Liaison ~ GAP Analyst and review ~ Functional and Technical Requirement Review ~ Business Analysis (BRDs) ~ Technical Solution Design (TSDs) ~ Change Control Management ~ Models AS-IS and TO-BE processes ~ Develops and executes test strategies, plans, scenarios, and tracks resolution to identified defects ~ uses analytical skills to identify root cause ~ Request for Information Docs (RIDs) ~ Scope Statement Specification ~ Wireframes and Other Visual Documentation ~ Information or Data Model Documentation ~ Requirement traceability matrix (RTM) ~ Functional requirement specification (FRS) ~ Functional Specification Document (FSD) ~ System requirement specification (SRS) ~ System Requirement Document (SRD) ~ User Interface Requirements Document (UIRD) ~ Technical Requirements Document (TRD) ~ Software Requirements Specification (SRS) ~ facilitating sessions (10 to 20 people on shore/off shore) ~ Process/Application Re-engineering ~ Exploratory Prototypes ~ Develop Solutions and Assets for forthcoming and in-flight projects ~ Security ~ Project/program management over multiple lifecycles ~ Data and System Integration Experience resolution ~ Digital Communications ~ Time Management ~ Self-Motivations ~ Independence ~ Organization ~ Mentoring Junior Business Analyst
ERP Applications: Oracle R12 (GL, AP, AR, Cash Management, P2P, Assets, Time and Labor, HRMS) ~ PeopleSoft (HCM, LMS, Travel & Expenses, AP, GL, AR) ~ BaaN (Financials, Manufacturing, Warehouse)
Development Languages: Oracle SQL ~ DB2 SQL ~ VBScript ~ 4 GL ~ MS SQL Server 2000 ~ MS SQL Server 2005/2008 ~ SSIS ~ SSAS ~ SSRS ~MS SQL Server ~ Oracle ~ DB2 ~ queries.
Data Architect/Data Management: Data Management ~ Database Modeling & Design (conceptual, logical, physical) ~ ETL ~ Data Modeling ~ Data warehouse ~ Real-Time Database Management ~ abstracting elements of information and relations to develop alternative unified database models ~ working with application developers to understand physical IDE limitations ~ Focus on scalability, maintainability, performance and modularity ~ Expertise in the Unified Modeling Language (UML) for constructing, and documenting the artifacts of software systems ~ Data Integration ~ Data Profiling ~ Data Standardization ~ Relational Database Management System ~ Relational Database Programming ~ Data Conversion / Migration Projects ~ Data Mapping ~ Develop Stored Procedures ~ Data Relationships ~ Data Cardinality ~ Data Laws & Regulations ~ Data Governance ~ Data Profiling ~ Data Quality and Cleansing ~ Master Data Management ~ Security ~ Metadata ~ Master Data Governance ~ Enterprise Data Quality ~ Enterprise Data Strategy ~ Enterprise Data Integration.
Operating Systems: Windows Server ~ Unix ~ HP ~ Vax
Software Applications: Crystal Reports ~ MS Office ~ Visio ~ MS Access ~ MS Project ~ ADP ~ Salesforce ~ Goldmine ~ JIRA ~ HEAT ~ Confluence ~ vehicle telematics ~ CRM Implementation Projects
Cloud base Applications: Fusion HCM Talent Management ~ Smart Sheets
Additional Technical Expertise: Robotics ~ Application Development ~ SAAS ~ Mobil Apps ~ Lockboxes ~ ETF ~ Ewires ~ experienced designer experienced coder ~ UAT and SIT Testing ~ test plans EDI ~ IVR ~ Waterfall ~ Rapid Development ~ Agile ~ Team Foundation Server (TFS) ~ Access Management ~ SAS ~ OLAP ~ Business Objects
Function expertise: Warehouse ~ Supply Chain ~ Human Resources ~ Finance ~ Automotive ~ Telecommunications ~ Manufacturing ~ Logistics ~ Payroll ~ Offender Management (Jail) ~ Loan Systems (Canadian Indian Affairs) ~ Investment Management ~ Fund Management ~ Point of Sales (POC) ~ Manufacturing (Automotive, Parts Suppliers, etc.) ~ Subject Matter Expert for 1 or more software solutions and processes ~ Health Care
PROFESSIONAL EXPERIENCE:
Confidential
Data Modeling Analyst
Responsibilities:
- Serve as a Trusted Advisor, drive conversations Enterprise Architects and Business Stakeholders armed with best practices for enterprise architecture functions such as Security, Performance, Requirements Analysis and Application Governance.
- Contribute to a program vision while advising and articulating program/project strategies on enabling technologies.
- Provide guidance on functional solution architecture & design, application and integration development best practices, enterprise architecture standards, environment management, and testing.
- Troubleshoot implementation issues and demonstrate ability to drive to successful resolution.
- Lead the evaluation of business and technical requirements from a senior level.
- Review and correct project/program direction, approach and key artifacts to keep programs on track and solutions extendable and maintainable going forward.
- Identification and pro-active management of risk areas and commitment to seeing an issue through to complete resolution.
- Negotiate solutions to complex problems with both the organization and third-party partners.
- Build relationships with business partners, internal and external, and contributing to broader goals and growth beyond the scope of a single customer engagement. Play the role of liaison between business stakeholders and technical experts.
- Identifying the key issues and weaknesses of a set of problems the organization is dealing them;
- Converting those problems into requirements for the technological side of activities;
- Identifying technological or tech-related solutions to those issues; this is often achieved through a fair amount of research, sometimes the topics of that research may be so far from the initial problem that they may even seem out of place.
Application Architect
Confidential
Responsibilities:
- Recommendations for new technologies based upon business value drivers and return on investment and then drives this new technologies towards exploitation and then to implementation if it fits for the organization and project.
- Establishes overall architecture vision for the platform and ensures specific components are appropriately designed and leveraged; contributes to the holistic vision of Enterprise Architecture.
- Understands the construction of platform architecture components and then overseeing the architecture solution design into production.
- Coordinates all platform-level conceptual architecture components (e.g., data architecture, application architecture, technical architecture).
- Defines, communicates and drives security architecture design and monitors compliance to enterprise-level architectural standards.
- Defines systems, technical and application architectures for new strategic initiatives; develops and maintains an architectural blueprint and evolutionary roadmap that defines and communicates the strategic direction for these architectures in support of business and technical strategies; able to explain how the roadmap maintains and delivers cost effectiveness, business value, and competitiveness.
Confidential, Louisville, KY
Sr. Business Analyst Consultant/Solution Architect
Responsibilities:
- As a Sr. Business Analyst for the Customer Experience team working on the Customer Journey Optimization project. This project will drive improvements and make recommendations to Confidential 's senior leaders by collecting large sets of data, build metrics and business cases. This includes providing ad-hoc analysis, data extraction/cleansing, reporting, and development/maintenance of dashboard, scorecards, reports, web pages etc. by working in closely with the Customer Experience Team (Salesforce, IVR, Data warehouse, and web data).
- As a Sr. Business Analyst for the project to create a Humanalytics Knowledge Portal within the Consumer Knowledge Repository.
- As a Sr. Business Analyst I build and maintain relationships with business partners (business and technical) to gain an understanding of current and future project scope to define and finalize scope and objectives of technical initiatives.
- As a Sr. Business Analyst my job is to define detailed and concise functional and non-functional requirements; use case scenarios based upon high level and detail requirements to ensure that the end product will meet standards for security, performance and usability of the business for both enterprise and local initiatives.
- Provide Access Management for various projects to ensure that security roles were created and assigned according to Confidential ’s Security, SOX and HIPPA Procedures.
- Act as the Master Data Management Solution Architect in analyzing, modeled big-data sets and developed conceptual model to handle velocity and variety of big data while enforcing data management process across the enterprise. Designed logical and physical model and implemented in DB2 / Oracle / MS SQL Server environment.
- As a Master Data Management Solution Architect I worked to establish and maintain common business rules, data definitions and usage, and transform data into actionable information of data to support an enterprise vision.
- As a Sr. Business Analyst I am part of all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms and working with application architects, developers, QA, and other technical team members to drive successful technical solutions.
- Perform as a Data Analyst in processing, cleaning, transforming and delivered data conversion product from end-to-end data conversion processes.
- Working on a various project as the Security Business Analyst.
Confidential, Carmel, Indiana
Client Engagement Manager
Responsibilities:
- Conducted weekly meetings with our Development Team, QA Team, and End Users to ensure performance efficiency and to discuss our Open Requests.
- Serve as the point of accountability to client for program delivery, database and architect Support and expertise.
- Monitoring of operational production performance and intervention as needed to insure on time, high quality delivery to client.
- Validate scope, conducting project kickoff and hold discussions with stakeholders.
- Conduct weekly and monthly status reports internally and to the client as needed; at key project milestones and provide project status reports on the effectiveness of the engagement against the baseline plan.
- Review, monitor, manage and approve consultant and partner billable hours and expenses on a weekly basis.
- Define in advance and secure sign-off on the acceptance criteria for project deliverables, work with the team to establish delivery dates for and oversee the review of client deliverables to ensure they meet all client acceptance criteria.
- Provide technical oversight for projects and provide Project Management expertise where required.
- Coordinate internal team member activities so that their deliverables are seamlessly integrated and delivered on a timely basis.
- Works with the Account Manager to proactively identify/recommend actions for net-new revenue opportunities and to drive growth within the client.
- Managed team of 7 consultants (1 on site, 3 in North America, 3 in India)
- Perform as a Data Analyst and Master Data Management Solution Architect by delivered data conversion product and complete end-to-end data conversion processes.
- Provide Access Management for this project to ensure that security roles were created and assigned according to client’s Security Procedures.
Confidential, Carmel, Indiana
Sr. Business System Analyst - HR and Finance Projects
Responsibilities:
- Managed direct relationship with third party vendors and off-shore development teams, created communication channel, and project’s review for management.
- Act as the database SME and provide data and solution architecture within the various applications.
- Interviewing business units, stakeholders and technical leaders to gather and clarify business requirements.
- Led planning meetings, JAD sessions (Joint Application Design), analysis development, test inspections, and other project meetings throughout product life cycle.
- Led the Development improvement regarding Invoicing OCR for Oracle ERP Purchase-to-Payment process.
- Led the implementation of the Vertex taxing software engine, enabling proper tax collecting, and reporting and order placement.
- Implement the use of Credit Card payment to various vendors.
- Lead BA on various projects such as Ewire, ETF, and Credit Card processing projects that will increase CNO’s Customer experience, processing cash payments by the customers.
- Perform as a Master Data Management Solution Architect by Design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
- Perform as a Data Analyst by creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
- Implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
- Perform as a Master Data Management Solution Architect by enforced data management processes across the enterprise (part of People, Process, Technology pillars)
- As an Sr. Business Analyst I am part of all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms.
Confidential, Columbus, Indiana
Sr. IT Business Analyst
Responsibilities:
- Successfully implemented Oracle Fusion HCM Core HR and Talent globally (13 languages, 192 Countries) to 18,000 managers as part of the company's IPO and future growth needs.
- Implemented change control process to migrate changes to production reducing downtime. Documented the process as part of Sarbanes-Oxley (SOX) ITGC process.
- Lead a 3-person development team in successfully implemented integration between Oracle Fusion Potential information to Oracle HR.
- Gather requirements, write functional (MD050), (BR.030) and (BP080) document and technical (MD070), (BR.100) document, provide recommendations for user. Documenting business requirements, Data design and process re-engineering to fit with the Oracle system Prototype new business processes, Design legacy data conversion, Configure applications and Create test scenarios.
- Three cycles of testing performed: System Integration Test (SIT), User Acceptance Test (UAT) and Final Acceptance Test (FAT).
- Supported all go-live activities
- Perform as a Data Analyst and Master Data Management Solution Architect by designing and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
- Was responsible for Access Management for this project to ensure that security roles were created and assigned according to SOX and Confidential Security Procedures.
- Perform as a Data Analyst and Master Data Management Solution Architect by delivered data conversion product and complete end-to-end data conversion processes.
Sr. IT Business System Analyst Consultant
Confidential
Responsibilities:
- Gathered, analyzed, processed and data flow diagramming for medium to complex business processes.
- Accountable for demonstrating basic knowledge of analysis techniques and standards and set analysis standards.
- Efficiently used and applied Standard Development Life Cycle methods and industry best practices.
- Worked with developers, database administrators and data architect and made sure that data quality around business decisions is maintained.
- Provided guidance to business customers in the creation of system test plans, test cases and assisted in testing.
- Documented and maintained current and future state departmental business processes.
- Efficiently used powerful auditing, reporting tools and systems to ensure customers are compliant with ever-changing state and federal regulations.
- Perform as a Data Analyst in developed model to maintain business integrity, data quality and injected various data languages (translation) for analytics
- Organized and analyzed big data (financial, images, products, customers) and developed various business capabilities
- Implemented a process to take strategy to roadmap and design development activities.
- Responsible for delivering customer information systems across North America and Canada.
- Perform as the Master Data Management Solution Architect by directly worked with client to develop data management solution that includes master data management, enterprise data warehouse, and business intelligence.
- Interfaced with client business executives and IT team and delivered enterprise communication plan.
- Perform as the Master Data Management Solution Architect by designed logical and physical model and implemented in Oracle and MS SQL Server environment.
- Perform as the Master Data Management Solution Architect by enforced data management processes across the enterprise (part of People, Process, and Technology pillars).
- Perform as a Data Analyst and Master Data Management Solution Architect by delivered data conversion product and complete end-to-end data conversion processes.
- With some clients I was responsible for Access Management for a number of systems both off the shelf and customer made to ensure SOX and Security procedures are met and followed
- As a Sr. Business Analyst I am part of all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms and working with application architects, developers, QA, and other technical team members to drive successful technical solutions.
Confidential, Irving, Texas
Sole Business Analyst
Responsibilities:
- Responsible for gathering, and documenting all Business Requirements around reservations for events such as conferences, meetings, Jamborees and High Adventure Treks for units and individuals.
- Assigned to development of Medical Treatment system to be used to log visits to health centers; track allergies and medications; collect vital signs during treatment; record data points about injuries; record exam notes, diagnosis, discharge notes and instructions, as well as sending notifications to scout leaders.
- Also Junior Project Manager responsible for monitoring project tasks and the work of the project team; reporting project status to stakeholders; alerting project manager of delays or obstacles; creating project presentations; coaching the project team; and coordinating communication between the different entities involved in projects.
Confidential, Richardson, Texas
Business AnalystResponsibilities:
- Involved in various Confidential CRM Dynamics projects for the following functional areas: Sales, Charitable Donations (E-Commerce), Charitable Events, and Marketing; Opportunities, Campaigns, and Donations.
- Gathered business requirements, create wireframes and Visio data and process flows used in the creation and improvement of various fund raising activities and charitable events such as Heart Walk.
- Worked with development for both mobile apps and system modifications to implement required changes.
Confidential, Houston, Texas
Business AnalystResponsibilities:
- Supported backlog and billing worksheet cleanup, data clean up, data conversion, and data positioning.
- Updated PS contract lines and details with information for new and old fields.
- Tested new PeopleSoft systems functionally and verify that the conversion of data was successful.
- Wrote and modified Query Manager Queries for conversion and other query reports.
