SUMMARY:

• Business Systems Analyst with 10yrs of experience in technical and functional roles for Ecommerce, Confidential Suite of data tools, Web - frontend applications, Content Management, Statistical analysis, Business Intelligence, Big Data and Data Warehousing.
• Worked on environments involving web services, XML, MS Dynamics, Quality Center, HTML and CSS, Java script, CQ5, Web product catalog, Sterling, ATG, UPM, and HANA, SAP, Open Text ECM, SOA Architecture, Java, SSMS, Informatica

PROFESSIONAL EXPERIENCE:

Confidential

Business Program Manager

Responsibilities:

• Evaluating existing system roadmap and Sprint backlog
• Coordinating with the team in India on implementation and delivery
• Communicate status updates to Stakeholders and Leadership
• Develop an end to end plan for project team to ensure delivery
• Conduct Sprint backlog meetings and associated workshops
• Developed data profiling inputs for BI team to evaluate for Profitability reporting
• Reviewed existing data model and provided analysis for future data model design on SSMS
• Utilized SQL Server capabilities for data analysis and query building
• Provided SQL query input to the Pre-UAT Team with detailed knowledge on resulting report generated
• Provide source to target mapping of data from the old database to the new
• Evaluated existing reports to ensure consistency and data integrity in new reports

Sr. Functional Analyst

Responsibilities:

• Write functional specification documentation for the Vendors regarding product templates, fragments and rules and conditions
• Worked on Exadata architecture to develop a strategy of data load across the extended consumer profile systems.
• Established trust relationships through services that mandated entities and attributes, and discussed future trust relationships within Informatica IDS.
• Collaborated with the Data Architect for term alignment processes and procedures to get data definitions approved for Data warehousing based on SQL
• Developed test data for UAT Testing & managed test calls for triaging and resolving bug issues
• Authored requirements around developing cubes for HR team for employee applications
• Coordinated communications with technical teams for requirements in cube development
• Establish business partnerships with technical teams for future maintenance and management of software
• Coordinate implementation of Open text Stream server product for different HTML and XML outputs
• Conduct gap analysis of existing document management system with nearly 350 different documents and 13 templates
• Designed the storage system for ECM team for data warehouse management and for reporting SQL
• Developed rules based on available attributes in XSD and mapped it to source systems
• Worked with Middleware to evaluate the configuration changes required for storage of new documents
• Designed the migration specifications for Content Server storage application ui nique to Content Server

Sr. Business Systems Analyst

Responsibilities:

• Evaluated systems and applications needed for integration of the project including Saleforce.com products
• Project involved working with Market on sharebuilder application to integrate financially advised product offerings on desktop application, mobile application including Andriod and iOS devices
• Established alliances across the cross functional teams to coordinate work with vendors and internal middleware applications.
• Prepared the Business requirement documentation, Data flows and System inventory for analysis of digital integrations
• Established test accounts across systems in production for testing
• Evaluated database structures by running SQL queries across two backend systems to assess process flows and establish integration points
• Developed Wireframes using Snagit 11.4 to display requirements and functionality changes
• Evaluated data from customer feedback surveys and Web2.0 analytics to propose new products
• Authored business requirements from product managers and system SMES
• Worked at an enterprise level for UAT testing and At a system level as a product owner during Agile projects
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Developing and maintaining test methodology and test strategies for projects.
• Wrote and monitored high level scenarios and detail test scripts and upload them in to QC.
• Assign test scripts to test team and individual, coordinating the work of test teams and monitoring their performance.
• Following up any outstanding open test risks / issues.
• Compiling test metrics, burn down chart, Defect report for management.

Functional Analyst

Responsibilities:

• Work hand in hand with the BI Architect and the BSA to generate functional specifications for the BO universe
• Develop Financial Reports such as: AR roll forward report, Bad Debt report, Aging reports(consigned inventory and revenue) using Business Objects universe
• Conducted Source to target data mapping by running SQL queries on Source systems
• Evaluate Big Data for reporting inconsistencies and generate Cohorts based on this
• Tested and assessed data load issues using Business Objects
• Support the Data Architect during data modeling by generating a conceptual design model
• Managed projects ranging from a cap assessment of 2.5 to 9.1M, ranging from 6 months to 2 years
• Developed the ability to seamlessly breakdown projects and manage them without missing core business requirements
• Generate adhoc reports, mockups and metrics for the business to identify accurate data elements
• Work on existing reports to conduct impact analysis of data elements on systems
• Evaluate the performance of a report after requirements are fulfilled
• Provide process maps, work flow diagrams and use cases for reporting needs
• Develop workflow diagrams to display a transfer of data across various different source systems
• Manage ambiguity between source systems and business owners to provide clear cut deliverables
• Analyze existing data from source systems and business requirements and recommend reporting activities, data refresh and best data source system

Data Integration Analyst

Responsibilities:

• Developed the Customer Master Data Model (Logical Data model)from start and enhanced pieces based on requirements from Business for their Data Warehousing purposes
• Created UMLs under the Architect lead and the technical architect for analyzing data conversion across data bases.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Gained buy-in from business partners for the new data architecture and support during architecture reviews.
• Used SQL Server, specifically SSMS for generating the model and populating data.
• Analyzed Baan ERP specific data to evaluate business needs and rectify issues related to Data Conversion.
• Used Mercury Service Center for requirement analysis.
• Generated the Cut-Over plan or the go-live plan for team and negotiate roadmap with corresponding teams.
• Worked alongside Business Analysts to ensure and approve the new design, business rules and triggers are accurately documented in the BRDs.

Sr. Business Analyst

Responsibilities:

• Author high level requirements with stakeholders and business teams.
• Created user stories based on the high-level specifications.
• Implemented the Sterling OMS for Nike Plus customers for instant purchase that worked hand in hand with ATG until only Sterling OMS was implemented on both ends
• Gathered business requirements by conducting detailed interviews with business users, stakeholders, SSC, Customer delivery and Care team by using program management technics.
• Conducted GAP analysis to understand the shortcomings of the paper based process and evaluated the benefits of the new system.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Created wireframes, mockups and storyboards to better understand of ecommerce web experience and process flow
• Created JIRA tickets for tasks across teams and within the team.
• Organized Sprint planning sessions with key stakeholders.
• Developed acceptance criteria for federated write-back across systems through Informatica IDS services.
• Developed use cases based on business consultant input, and collaborated with development for changes on enhancements.
• Developed the consumer dashboard wireframe using Visio for Pilot Testing
• Analyzed ER relationships of source systems across Nike Digital database framework, and identified joins related to different Nike consumer attributes through internal and third party framework.
• Authored the data dictionary and inventory for the entire project.
• Developed the Conceptual Data Model (Logical data model) for reference between the ETL team and the business team.
• Identified the source systems and analyzed the current source systems to determine which attribute would most like fall in which database.
• Worked alongside the Project Manager to establish the resources (resource estimation exercise) required from Informatica on-site for Nike.
• Communicated data attributes to stakeholders and collaborated efforts to develop a concrete understanding of Nike consumers with the business consultant.
• Provided direction and mentorship to the Data Modeler over analysis of data and to develop the consumer data model for Nike that would reside in IDS.

System Analyst

Responsibilities:

• Conducted interviews for business requirement gathering (BRD) from three primary focus groups, including sales, finance, and other internal teams.
• Organized scrum meetings for the team and reported the burn-down chart to key stakeholders.
• Developed the data flow diagrams to observe the flow of information across the ETL processing.
• Created an ER diagram to explain the work flow of information for the technical team as a part of the functional specifications.
• Worked with the business to develop mockups for requirements regarding the business intelligence reports.
• Developed Use Case Diagrams, Activity Diagrams, and Sequence Diagram using MS Visio.
• Utilized UML and source-to-target mapping to cause a clarified understanding of the project and the ETL process, and worked alongside the ETL development team to sort out issues and maintain a consistent completion of stories in JIRA.
• Updated all the data sources-specific documents and the business documents on SharePoint.
• Worked as the liaison between the development and the business team, and provided separate updates for both.

Business Analyst

Responsibilities:

• Worked with the Subject Matter Experts (SMEs) to generate business requirement documents (BRDs) that included basic goals of the new enhancements and series of expected call to actions.
• Developed Gap analysis based on focus groups and interviews to ensure accuracy in expectations of SMEs.
• Worked with the sales group to gather business requirements around the sales attributes that needed to be added on their position records.
• Analyzed Google analytics data and developed reports for the business team to gauge on potential growth of new features and risks.
• Developed FSDs based on BRDs, and communicated these to the development team.
• Researched previous documents and evaluated the Business Objects Interface to see the projected requirements of the project.
• Utilized the extraction process to the fullest to identify data sources for dimensions and measures that complimented the requirements based on the functional specifications.
• Gained experience in segmenting data for traffic coming from other websites.
• Managed scope changes in the same area based on customizations required by Sales.
• Created workflow processes and set up different events and members who need notifications using SharePoint and MS Project, as needed.
• Coordinated with data warehouse team and business intelligence team to streamline data.

Business System Analyst

Responsibilities:

• Managed the integration (Informatica) to implementation of Salesforce.com with the other in-house systems, including the master data management application.
• Successfully implemented a data governance program that help achieve the master data management strategy for the company spanning commercial, operation, IT, and marketing departments.
• Wrote RFPs and evaluated proposals.
• Led the vendor engagement team and managed vendor resources.
• Successfully resolved key issues with various vendors during various phases of procurement management, and ensured SLAs were clearly signed prior the beginning of the project.
• Led technical staff, service, and production support operations.
• Led various task forces to implement the Agile methodology of software development company-wide, including tools like Scrum chart, templates, and rules of engagement and mentoring.
• Produced quality results in a fast-paced environment by using tools like Gantt charts, SharePoint, and MS Project
• Supported daily operations including system monitoring, troubleshooting, configuration and release management, defect and issue tracking, incident management, and data analysis and reporting.
• Collaborated closely with business users and other IT groups to deliver integrated solutions to the supported business functions.
• Developed standards and procedures for maintenance and development of systems, data queries, and reporting using SQL and PL/SQL.
• Developed a new process and helped the marketing team to choose a new system.
• Interacted with the domain-specific sectors of the business to help enable technology decisions.