SWAGATIKA SARANGI
*** ** *** **** *** Apartments, Apt #247
Hillsboro, OR – 97123
Phone: 352-***-**** acxmg7@r.postjobfree.com
SUMMARY
Experienced project manager offering 8 years of success contributing to all phases of diverse technology domain ranging across: IT, Telecommunication, Oil & Gas, Sporting goods, Consulting, Restaurant & Education domain.
Business strategist; with planning, managing, acquiring multimillion-dollar projects aligning business goals with cutting-edge technology solutions to enhance process improvements and competitive advantage.
Dual Major in Business Intelligence Analytics & Supply Chain Management under Masters’ in Information Systems & Operations Management, with prior experience in programming languages.
Certified MDM Senior Consultant supporting as Scrum Master/Senior Business/Data/Web analyst with expertise in the following areas: Master Data Management (MDM), PeopleSoft and Salesforce.Com.
Extensive experience in Implementation and Upgrades of projects along with Idea conceptualization for various business processes.
Expertise in Software Development Life Cycle (SDLC) including Waterfall Model and Agile Methodologies and ability to meet or exceed budgetary targets.
Excellent facilitation skills in writing Business Requirements Document (BRD), Functional Specifications Design (FSD), Use Case Specifications, Systems Requirements Specifications (SRS), conducting Walkthroughs, Surveys, Joint Application Design (JAD) sessions.
Well-versed in collecting and analyzing project metrics data and connecting with Scrum Master, Product Owner and Scrum Team to identify and incorporate corrective actions when needed.
Excellent facilitation skills in conducting Walkthroughs, Surveys, Joint Application Design (JAD) sessions.
SKILLS
EIM Tools : Informatica MDM Multi Domain Edition, Informatica Data Director, Hierarchy Manager
Other Packages : R, SPSS, Tableau, Force.com & Big Machines Platform 12,PeopleSoft ERP Tools 8.49, Toad 9.1
Programming Language : People Code, SQL
Databases : Oracle, MS SQL server
Office Tools : Gantt Charts, Jira, Kanban Boards, Microsoft Word/Excel/Project, Requirement Traceability Matrix
Data Modeling Tools : Microsoft Visio
Operating Systems : Windows, Linux
PROFFESIONAL MEMBERSHIPS & CERTIFICATIONS
Awards / Activities / Affiliations:
MDM Hub 9.x Certified Developer Specialist
Informatica Data Quality 9.x Developer Specialist
Salesforce.com Certified Force.com Developer (DEV-401)
Data scientist’s toolbox ‘R’ Certified specialist
Masters National Swimming Championship 2012, India: National Medal, Silver
Membership:
Member, Project Management Institute: Pursuing Certified Associate in Project Management (CAPM) certification
Member, Association for Information System, UF Chapter
EXPERIENCE
MDM Implementation: J B Hunt Transport Services, Inc. June 2016 – Now
Overview:
J B Hunt’s MDM team involves in Customer and Location Master Data implementation from its various source systems like CCI, Screen 21, and business systems. MDM team is committed to deliver consolidated customer and address data providing leverage in comparison to its old mainframe source systems. The purpose of MDM team is to deliver customer and location master data all combined in one system and CCI replacement.
Responsibilities:
• Leading teams across broad technical, financial and business disciplines of Master Data Management.
• Focusing on business objectives and tracked progress to ensure project milestones are completed on time, on budget and with the desired results.
• Mentoring team in variety of business requirements and data gathering tool including SSIS, SSAS, to gather, analyze data, and create predictive models.
• Leading team in implementation of MDM using Microsoft MDS and Profisee.
• Mitigating risk factors through careful analysis of financial and statistical data.
• Prototyping and implementing a comprehensive approach that entails the full usage of SSIS for data profiling, cleansing, normalization, data quality and finally data mining.
• Assisting the team in business requirements via Metric Decomposition – methodology for documenting required metrics and dimensions.
• Providing architectural consulting and leading team in analysis of SSIS cubes for best functional scenarios.
• Establishing and managing the internal Project Intake and Change Management Process for all Customer dependent projects.
Environment: MDS, Oracle 11g, SQL Server, Microsoft Project, SSIS, SSAS, Gantt Charts
Informatica MDM Implementation & Support: Nike, Inc. Feb 2016 – June 2016
Overview:
Nike’s Customer Master Data domain involves in collecting store and customer related information from external sources like salesforce and internal siterra domain and availing all useful cleansed master customer data and further involving in report generation. Nike’s Master Data team is solely devoted to delivering golden records from SFDC Connect source system and supply it to downstream system. Project involved large-scale initiatives including the transition of MDM in-house programs to new platforms and further systems upgradation to Customer Cloud 360.
Responsibilities:
• Led design and multinational rollout of robust, scalable and secure customer master data management for Customer.
• Ensured that the project deliverables are on time, within budget and at the required level of quality.
• Scheduled and facilitated sprint planning, daily stand-up, sprint demo and sprint retrospective meetings.
• Defined roadmap and gathering requirements across a multi-domain MDM implementation.
• Instructed the team to create clear and concise epics/stories.
• Facilitated Scrum calls for offshore teams in India.
• Managed timelines for customer project while communicating with all key stakeholders.
• Identified master data, reference data and finding golden record for the customer data.
• Managed User Acceptance Testing and Quality Assurance for Vendor Master Data.
Environment: Jira, Informatica MDM 10.0, Oracle 11g, SQL Server, Microsoft Project, Gantt Charts
Master Data Implementation & Support: Bloomin’ Brands, Inc. Dec 2015 – Feb 2016
Overview:
Bloomin’ Brands, Inc., headquartered in Tampa, FL is one of the world's largest casual dining companies with approximately 100,000 Team Members and close to 1,500 restaurants throughout 48 states. This firm is using MDM for aggregating almost 8 million customers and distributors information in a single location, which is in various source systems of that organization. The main goal of the project was to implement lean management Failure Mode Effect Analysis (FMEA) as well as implement MDM solution to identify Single customer master across. This customer information is useful for faster decision making of approval process of lead and various decision-makings across the organization.
Responsibilities:
Led scrum calls and weekly interactions with ‘C’ level employees and product owners.
Authored and successfully presented proposal to executive team to save $2M per year.
Understood and document the current As-Is business process flows.
Determined the high level to-be business processes and conduct conference room pilot workshops.
Developed FMEA (Failure Mode and Effects Analysis) models, Process flow, and Production control plan.
Facilitated lean deployment and value stream transformation while responsible for gathering user Business requirements and translating and system specifications.
Organized open-window remote sessions and questionnaires with teams across nation.
Instructed core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the EIM team.
Facilitated the functional as well as technical requirement gathering.
Environment: Microsoft MDS, Jira, SQL Developer, MS Project
Informatica MDM Implementation & Support: Selective Insurance Co. Nov 2014 –Dec 2015
Overview:
Selective Insurance, headquartered in Branchville, NJ is the leading Insurance Company. This firm is using MDM for aggregating almost 8 million customers and distributors information in a single location, which is in various source systems of that organization. The main goal of the project was to identify Single customer master across the enterprise. This customer information is useful for faster decision making of approval process of lead and various decision-makings across the organization.
Responsibilities:
Determined the high level to-be business processes and conduct conference room pilot workshops.
Identified Reports, Interfaces, Customizations and Extensions.
Created functional and technical specifications based on Fit-Gap document.
Prepared configuration and data conversion templates.
Built Time and match and merge Rules, design and solution for data Integration.
Prepared SIT Scenarios, review the test results and resolve integration issues.
Facilitated the functional testing for acceptance with the customer.
Indulged in Go Live support, Post Go Live warranty support in compliance with Service level agreement.
Prepared Transition plan and conduct knowledge transfer sessions to support team.
Installed and Configured Informatica MDM hub on Jboss application server.
Involved in the brain storming sessions for deciding the data model with Solution and Data Architect.
Configured Address Doctor by doing the changes in the configuration files on the hub server.
Created the landing tables, base tables and staging tables as per the data model.
Upgraded MDM 9.7.1 to MDM 10.0.
Environment: Informatica MDM 9.7.1, Jboss, Oracle 11g, SQL Server, Microsoft Project.
Data Analyst: IT Department of University of Florida (UFIT), Gainesville, FL Jan 2014 - Nov 2014
Overview:
University of Florida IT department delivers streamlined real time data across students, IT staff, peer institutions, vendors, federal and state staff frequently. Informatica cloud project helps in finding the master data among UF identification number while keeping all history records alive. Accessibility projects at the UFIT helps university deliver data to its end users in a consistent format.
Responsibilities:
Monitored client expectations through client Involvement and Communication throughout the project.
Created client and stakeholders’ awareness on the benefits and risks associated with the project.
Organized Joint Application Development (JAD) with clients and the IT group to gather requirements to re-engineer the existing process.
Analyzed Business requirement document and Technical design document against requirements.
Involved in review the Business Requirements with Business and Regulatory team.
Extracted data from different sources like Oracle, flat files, XML loaded into DWH Prepared Test SQL Scripts to Test ETL Transformation logic.
Environment: Informatica Cloud, Informatica Power Center 9.1/8.6.1/8.1.1, MS SQL Server 2012, Soap UI, HTML Editor, Oracle 10g/9i, Toad 9.0.1
General Electric Energy, Hyderabad, India Mar 2010 - Dec 2012
Overview:
GE Energy used Salesforce.com extensively with 5K+ users, 2K+Partners, and growing number of Customers.GE Big machines Inc. platform team was one of the verticals with an aggressive growth and ambitious plans.
The platform team was the first to upgrade to new version of Big machines to support the customers and clients with new seamless proposal generation. Platform team delivered Partner Community, Customer Community, Closed Loop Quoting, Technical Support (Service), 3 CPQ products etc. on SFDC.
Responsibilities:
Worked on stakeholder Analysis to recognize key success points for project and communicated effectively with the right stakeholders.
Acted as a liaison between stakeholders (system users and clients), to efficiently deliver and serve lines of business.
Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
Determined the requirements of the new project & modified Big Machine’s Product Lines, PFF Proposals and Commerce workflow.
Worked on configuration (Rules, Layouts, and Recommended Items etc.).
Designed Proposal Layout templates using Document Engine, PFF and coded in BML, XML & XSL.
Managed the lifecycle of code development, from ideation to sprints to deployment.
Environment: Big Machines Version 12.0 (CPQ Tool), PFF, SQL Developer, TOAD 9.1
Member, Development Team MTNL Aug 2009 – Nov 2010
Overview:
MTNL’s aspiring GSM and CDMA rolled out their non-functional requirements and benchmarks. A core team was formed to cater to the new requirements and benchmarks across all the functionalities deployed in the MTNL CCBS Implementation. The team tuned and reworked all major transactional pages, queries and logic and rolled out the changes and improvements following an agile methodology, with shorter release cycles.
Responsibilities:
Gathered requirements from old sprints, and created new functional requirement document (FRD).
Helped in writing specified technical requirement document in collaboration with developers and testers.
Created Design Documentation in specific to system specifications including user interfaces, performance requirements.
Involved in Performance Measurement of bulk conversion (prepaid to postpaid) through application engines to determine if it is meeting the timelines.
Worked in order capture module and developed requirement communication for the database.
Created quotes, business objects and supported my efforts in Order Management.
Developed interfaces with CRM, Billing, Provisioning & document management system.
Managed prioritizing Defects/Bugs and writing new Business Requirements to resolve them.
Co-ordinated with other application areas during integration testing and deployment.
Co-ordinated with offshore during development and testing of Applications.
Performed SQL reviews using performance tuning tools when development is complete.
Identified risks, issues and changes needed.
Environment: People Tools 8.49/8.50, SQL Developer, TOAD 9.1.
EDUCATION
Masters of Science in Information Systems and Operations Management, University of Florida - Hough Graduate School of Business, Gainesville, FL [Graduated in May, 2015]
Bachelors of Technology in Electronics & Telecommunication Engineering, Biju Patnaik University of Technology Rourkela, Orissa, India [Graduated in August, 2009]