Pim/mdm Business Systems Analyst Resume
Chicago, IL
SKILL AND ABILITIES:
Eliciting Project Requirements
Master Data Management
Product Information Management
Research & Engineering Development
Business Intelligence
Statistical Analysis
Project Planning and Procurement
Risk/Impact Assessment
Quality Assurance (QA) Testing
Validate Functionality
Test Case Management
Gap Analysis, Automation
Product Management/Development
Stakeholder Relationship/Engagement
Supply Chain Management (SCM)
Project Management
Change Management
Technical Integration
Customer Retention
Critical Thinking
Data Mapping
Process Modeling
Data Visualizations
TECHNICAL SKILLS:
Database: SQL Server 2012, Postgres, T - SQL, BDMS, PL/SQL, Oracle
Data Modeling: MS Visio, Bizagi, ARIS
Reporting Services: (SSRS, Report Builder, Report Manager, Report Server), Crystal Reports, Spotfire, Tamarac
Collaboration Tools: SharePoint, CRM, JIRA, Version One, AWS / Oracle Cloud
BI Tools: Power BI, Tableau, QlikView, BIDS, SSDT, QuickSight
Testing Tools: Selenium, HP QC, ALM, Cucumber, JIRA, ServiceNow
SDLC: Agile, Scrum, Kanban, XP, SAFE, Waterfall, and Spiral
Source Control: Team Foundation Server (TFS), Salesforce (SFDC), GIT, WinSCP
Applications: VMware, MS Office (Word, Excel, PowerPoint, Project), SAP, RUP Workbench, Salesforce, SAS, Rational Requisite Pro, Confluence, Adobe, Slack
Web Designing: HTML5/CSS3, XML, JavaScript, JQuery, JSON, ASP.NET
Programming Languages: C, C++, Visual Basic, Java, Python, R
Operating Systems: Linux, Windows, iOS
PROFESSIONAL EXPERIENCE:
Confidential, Chicago, IL
PIM/MDM Business Systems Analyst
Responsibilities:
- Designed and built workflows and custom portal components to enhance data governance and quality of product data solutions in Stibo STEP platform
- Documented business requirements and lead requirement walk - throughs with key stakeholders using various methods (user stories, team demos, sprint planning, review meetings, and backlog refinement sessions) Implemented upgrades and Change Management plans based on MDM strategy, along with Risk Assessment and Mitigation Collaborated with Project Managers, Technical Leads, and Business Users to ensure Agile business acceptance
- Developed testing plan for End-to-End testing and wrote detailed test cases for UAT
- Created the allocation impact and deep dive analysis reports in the PIM system
- Developed the current state analysis of the PIM system and business reports
- Implemented automated testing tools and programs addressing areas including testing impacts, software scenarios, regression testing, negative testing, and performance testing
- Owned complete responsibility for Product Lifecycle Management application and its capability roadmap Drove and documented the transformational and deployment program plans for PIM systems
- Designed the schema, metadata, and application architecture for external systems such as eComm, ERP, CRM, and third-party systems
- Mapped the legacy database with the current MDM/PIM system Fostered bi-directional communication between the IT organization and the business-aligned teams, communicating plans, projects, and priorities across the organization.
Confidential
Sr. Business Analyst
Responsibilities:
- Individually handled 10+ knowledge communities for our US client, each with multiple stakeholders
- Applied advanced knowledge of business analysis concepts, principles, and elicitation techniques to gather, document, and manage business requirements for complex and visible Opex and Capex projects
- Developed knowledgebase documentation and transition of ownership of 500+ artifacts and processes to maintain under new policies
- Reduced churn rate by 2% through applying split testing to inactive user notifications to improve user retention
- Created ad - hoc Metrics Reports and Dashboards for data analysis of KPIs using SharePoint and Advanced Excel
- Pulled more than 2GB data through ETL process and extracted customer behavior information with SQL scripts from various data centers.
Confidential
Content Development Analyst/Project Manager
Responsibilities:
- Enhanced raw technical content received from the authors
- Served as an SME to various IT technologies and pedagogy development
- Defined and wrote scope, use cases, test cases, system specifications, and performed detailed software testing
- Slashed benefits administration costs 30% by negotiating pricing with authors, while ensuring the enhancements of royalties
- Dealt with authors of various nationalities and provided mentorship, coaching, and leadership to develop knowledge and skills to meet needs in customer lifetime value
- Researched for competitive benchmarking and cost benefit analysis
- Conducted SWOT analysis based on management requirements, recommended ERP Kingdee Systems to replace the old system, saving up to $20K per month and enhancing usability.
Confidential
Business Systems Analyst
Responsibilities:
- Designed the business requirement collection approach based on the project scope and Agile methodology
- Interacted with different risk management, disaster recovery, and analytic groups to get the requirements for the systems
- Worked extensively with the QA team for designing test plan and test cases for User Acceptance Testing
- Provide task - based reports and evaluated team SLAs
- Produced traceability matrix by tracking, managing and tracing all requirements in JIRA
- Facilitated JAD sessions with business users and technical teams to document current configuration
- Designed the UI by activity diagrams, class, and sequence diagrams using Rational Rose.
Confidential
Software Engineer Intern
Responsibilities:
- Developed webpages using HTML5, XHTML, CSS 2/3, and JavaScript
- Developed rich Internet applications using Google Analytics
- Used jQuery to make the code interact with the JS functions
- Designed/documented REST/HTTP APIs, including JSON data formats and versioning strategy
- Increased database performance by MySQL configuration changes
- Created reports and documents using Microsoft Office Suite and BI Reporting Tools.