PROFESSIONAL SUMMARY:

• Senior Business Systems Analyst with experience in Business Applications design, system improvement, quality assurance, and implementation.
• Strong analytical and problem - solving skills with attention to details and accuracy.
• Perceived as a great communicator, highly positive, motivated, and committed team player with proven success in coaching and mentoring associates
• Sharp analytical, interpersonal, communications and problem-solving skills coupled with Business and Technical Domain Knowledge
• Expertise in project management, process improvement, and resource allocation
• Strong interpersonal skills with the ability to work effectively with local and offshore team members and excellent leadership skills
• Trained and managed offshore teams in multiple projects
• Expertise in assessing the level of effort required to complete a project and staying within my estimate’s range.
• Understanding of SOA, Webservice, HTTP, XSD, XSLT and JSON.
• Experienced working in various domains and systems such as eCommerce, Retail and Customer merchandising, Media, Manufacturing, CRM, CMS and Mobile Apps Android and IOS and understanding of BI Business Intelligence System.
• Ability to prioritize and run multiple tasks simultaneously
• Experience in Oracle query performance tuning and query optimization techniques.
• Beginner level knowledge of NOSQL databases such as MongoDB, Cassandra and Amazon Redshift and PostgreSQL.
• In-depth knowledge of web services, service-oriented architecture (SOA), ETL, data warehouse and business intelligence (BI) concepts, Master Data Management, Metadata Management and Data Quality Management.
• Expert in complex data collection and analysis activities using advanced SQL, RDBMS knowledge across database platforms such as Oracle, DB2 and Datawarehouse - Teradata
• Business Analyst and PMO coordinator in new GIS application.
• Business analyst and PMO coordinator in preventive maintenance application.
• Strong Experience in Enterprise System Interface and Integration analysis with good knowledge of SQL, beginner level knowledge PL/SQL s: Google Analytics, Apache Hadoop level 2-big data academy-IBM, Apache Spark level 2- big data academy-IBM

TECHNICAL SKILLS:

SDLC Methodologies: Agile-Scrum, Waterfall-Scrum Hybrid, Waterfall, XP, SAFE, Kanban.

Project management: MS Office, JIRA, Rally, Confluence, HP ALM, TFS, Version one

Modeling tools: MS Visio, Mock Up Screens, Rational Rose, Balsamiq

ETL: IBM Data Stage, SAP bods, AWS glue, AWS Athena

Reporting tools: IBM Cognos, Tableau, SSRS, MS office Suite, MS Excel, power BI

Big data: Hadoop, HDFS, Hive, Pig, Sqoop, Flume, Kafka, MapReduce, Spark

Testing tools: HP QC, HP QTP, Selenium, Soap UI

Languages: HTML, CSS, JAVA, XML, XSD, SQL, SOAP, REST, JSON, C, C++

Databases: Relational DB--MySQL, MS access, oracle, Enterprise DB- oracle DB, MS SQL server, IBM DB2, NoSQL DB Cassandra, MongoDB

Data Warehousing concepts: Data Modelling, Data Mart, OLTP, OLAP, Slicing/Dicing, Drill Up/ Drill Down, Pivot, Informatica

Cloud based tools: Cloudera EDH, Informatica cloud, oracle cloud, AWS, Microsoft Azure, SFDC

Operating systems: Windows- 10, 8, 7, xp, Linux- cloudera, ubuntu, Red hat, oracle enterprise Linux

PROFESSIONAL EXPERIENCE:

Confidential, MI

Business Analyst

Responsibilities:

• Collecting and rationalizing user stories from global stakeholders
• Bridging the gap between end users/stakeholders and delivery teams
• Prioritizing platform backlog or user stories for delivery teams
• Ensuring product quality for end users based on user story acceptance
• Ensuring that end users have the necessary and support materials in place to effectively use the product
• Reporting product status/health to the Product Owner
• Ensuring overall user experience for end users
• Understanding the business needs of our customers
• Playing supporting roles in Project team issue resolution, Dependency management, Product design discussions, Epic planning o Agile ceremonies: backlog grooming, sprint planning, etc.
• Collaborating cross-functionally with Information Technology specialists as well as other key stakeholders, as needed, to assure systems meet business unit needs

Confidential

Delivery owner/ Business analyst

Responsibilities:

• Participated in Gap Analysis to identify gaps in existing account management experience Globally and to identify the requirements for the changes in the proposed system.
• Interviewed various product owners, digital delivery managers, analysts to gather business requirements, wants/ needs concerning the project and documented the requirements on confluence.
• Conducted research on ongoing hybris/ Ecommerce website implementations to identify the existing Account management capabilities
• Lead data modeling and research indicatives for the development of business requirements.
• Performed data analysis with high complexity in support of ad-hoc reporting, customer requests.
• Significantly contributing in UX development that may positively influence improvements in the Account management experience.
• Worked closely with product, UX and business team to build applications, research and align Confidential business goals through front end development and UX
• Conducted research, documented and report new features / functionality to the product/ux manager
• Formulated Data analytics questions for Project infographics/dashboard by closely working with Data science Team
• Lead 3 analysts in the data analysis and requirements elicitation for the implementation of Global account management capability across all the existing solutions
• Collaborated with enterprise Analytics Team to Identify KPI’s for new Product applicable to Global audience/ users
• Facilitated daily stand-up, while enforcing time boxes, responding to the impediments, tracking issues and aligning the cadence planning with all the other teams. facilitated sprint checkup during mid sprint, to review the acceptance criteria for the committed product backlog items

Environment: Agile-scrum cadence and Kanban model, Jira, confluence, Tableau, MS-Visio, MongoDB, Okta, AWS (EMR, EC2, S3, ELB, GLUE, ATHENA), AS400, Hybris global implementations

Confidential, Roanoke, VA

Business System Analyst

Responsibilities:

• Formulated and defined systems scope and objectives based on both user needs and IT perspective, was the single voice to business while representing IT
• Devised and modified procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
• Performed analysis of business and user needs, documentation of requirements, and translation into proper system requirement specifications.
• Partnered with IT Project Managers and Business stakeholders to identify business goals, document current state business/technical processes and data flows, document future state processes and data flows, document gap analysis between current state and future state
• Lead requirements gathering, analysis and verification to write requirement statements that are complete, consistent, concise, accurate, traceable, and verifiable
• Integrated and implemented MDM, business intelligence BI and data warehousing DW / EDW solutions.
• Acted as interim Scrum Master when needed.
• Identified impacted business and IT areas, seek appropriate representatives across the teams, and lead discussions to identify issues, impacts, possible solutions and project estimates
• Partnered with Tech team to understand and document current system functions and limitations
• Partnered with Technical and Architecture resources to design possible, feasible solutions, leveraging current assets as appropriate and consistent with the broader enterprise direction
• Lead discussions and design sessions involving the appropriate resources in decisions concerning UIs, data flows, data integrity, data integration, system integrations, business process reengineering and project phasing.
• Facilitated discussions on IAM architecture and designs to build Identity and Access Management solutions to support and advance the effectiveness and efficiency of client operations, personnel and customers
• Participated in defining architecture and process standards for the identity management platform contribute to ongoing evolution and development of IAM strategies responsible for project planning, directing and controlling the resources and efforts of the assigned functional team to accomplish the delivery of the final product working hand in hand with other project leads under the guidance of the PMO Sr. Executive and Program Manager.
• Assists with integration of IAM systems with in-house and third-party applications for provisioning, identity authentication and developing connectors between IAM tools and system resources
• Ensured clarity between business and IT to ensure that IT knows what needs to be built and the business agrees the solution meets the need
• Partnered with Technical, QA and Business to verify the solution solves business needs and functions as agreed
• Reported project status and progress to IT senior management as well as PMO.
• Used Altova XML Spy and Map Force tools to generate the XSLT by graphical mapping of upstream and downstream system XSD files, to generate sample xml data, validating the xml files and troubleshooting ESB transformation issues during SIT.

Environment: Scrum Hybrid, Jira Microsoft Excel, Microsoft Word, Microsoft Power Point, Power BI, Devops, MS-Visio Google, Mulesoft, MDM, MongoDB, EMR (Hadoop, Map Reduce, HBase, Sqoop), AWS (EMR, EC2, S3, ELB, GLUE, ATHENA). IBM Data stage, UC4, SAP bods

Confidential, Boston, MA

Business System Analyst

Responsibilities:

• This product uses the data mining, machine learning and information extraction techniques. Worked on documenting machine learning algorithms for .
• Integrated CRM and IVR which allowed the IVR system to recognize a phone number, pull up the relevant account information, address the caller by first name, and already have immediate access to past Information the caller might be inquiring about.
• Created Mock Up screens and Wireframes using Balsamiq for client verification.
• Work closely with the web application development team to ensure proper integration between mobile application and web application.
• Wrote test cases, test plans, and test scenarios and traceability matrices used by the Quality team for User Acceptance Testing (UAT).
• Worked on analysis of Datasets related to banking, Hands on Experience on Linux systems, documentation of the day to day tasks.
• Performed data entry and reconciliation as well as back end data systems maintenance work using MDM tools Informatica and SQL language programming.
• Helped the team in Identified and addressed data issues that affect data integrity using MDM standards.
• Assisted in Implementing Single Sign On (SSO) and configuring multiple authentication schemes and authorization plugins based on the requirement.
• Interfaced with PMO and ensured that PMO prescribed methodology SDM is in enforced and all artifacts/documents are produced in each phase of the development life cycle
• Worked closely with the Hadoop implementation team in installing CDH production cluster, commissioning & decommissioning of data node. Experimented to dump the data from MySQL to HDFS using Sqoop.
• Used MuleSoft management console to monitor the request and response payload, assisted in providing documents for Write mule flows to call other webservices.
• Involved in validation of HTTP requests and response of UI server, Web server by using MuleSoft ESB, also validated the Serialization and Parsing of XML documents and JSON documents Confidential each tier.
• Gathered requirements to integrate diverse data sources from different modules with MuleSoft ESB
• Strong experience in writing and creating XML, XHTML, XML Schema XSD’s, XML Parsers like SAX and DOM.

Environment: Waterfall-Scrum Hybrid, Rally, Microsoft Excel, Microsoft Word, Microsoft Power Point, HTML5, CSS3, Tableau, Devops, Informatica, Balsamiq, MS-Visio, MS- Project, HPQC, HP ALM Google Analytics Big Data (Hadoop, Map Reduce, HBase, Sqoop).

Confidential, Philadelphia, PA

Business System Analyst

Responsibilities:

• Elicited requirements on web applications, Dashboards, business logics, and types of data and reports from different business owners, stakeholders, and development teams by facilitating interviews, brainstorming, focus groups, requirement workshops and JAD sessions.
• Experience in performing Business Process Analysis, involved in application redesigning and enhancements and GAP analysis, creating Business Process Models.
• Business Process Re-engineering (BPR), Business process optimization and process mapping.
• Experience in coordinating JAD/RAD sessions for gathering requirements, data and process models, Report Layouts.
• Worked with the team to develop, document and demonstrate standards, tools and best practices for IAM integrations on web-based, client-based and other applications that have a built-in internal security module.
• Reviewed and analyzed Business Requirements Document (BRD), Functional Requirement Document (FRD) and helped transforming them into a complete System Requirement Specification (SRS) to enable all the stakeholders to accurately understand requirements.
• Documented business rules and transformation rules for transferring data from RDBMS to HDFS using Apache Scoop. Used Apache Flume to collect and ingest log files, web service log, touch click data, location-based data and social media data into HDFS.
• Assisted Hadoop administration by performing node cluster operations using zookeeper in fine tuning applications and systems for higher performance and throughput.
• Gathered requirements, developed solution, managed application development, and data conversion and initialization across multiple environments Master Data Management (MDM).
• Collaborate with UI/UX, API and System teams to support development initiatives Knowledge of JSON involved.
• Implemented SSO across E-Business Suite, OID and OAM.
• I represented Data analysis/ BI group in the task force formed to formulate PMO processes, procedures and analytical Information System development methodology
• Involved in website design using .NET technology, HTML and CSS
• Used Jenkins for automating the continuous integration of the components on a regular basis.

Environment: Waterfall-Scrum Hybrid, JIRA, Confluence, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, HTML5, CSS3, Tableau, Devops, google analytics Informatica MDM, HP ALM MS-Visio, MS- Project, HPQC

Confidential, Olympia, WA

Business System Analyst

Responsibilities:

• Analysis, ETL design and ETL implementation of new Data Mart for Financial reporting system.
• As part of the PMO I was responsible for capturing and documenting any issues, concerns and next steps for the corrective action.
• Made certain all team members were using the correct standardized documentation templates.
• As part of the PMO working as a business analyst oversaw the pipeline releases as they were rolled out. If there were delays the PMO would set up meetings to discuss the plan to establish a new deadline for the release issues to be corrected to the satisfaction of the client.
• Conducted data profiling activities such as data clean up and data scrubbing to improve data quality.
• Used control flow tasks like for loop container, for each loop container, sequence container, execute SQL task and data flow task. Creating package configurations, loggings, check points and break points in SSIS.
• Assisted in Writing PL/SQL programs on Oracle Database. Performed performance tuning.
• Designed and developed all use cases and UML models using MS Visio and created Use Case diagrams, Sequence diagrams, Activity diagrams and class diagrams
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Used ETL to map data and integrate data from different sources to DW using SSIS.
• Imported/exported data in to the ERP system tables (data conversion). I loaded data into the mandatory table of major modules.
• Assisted architects in creating data hub with Bus architecture.
• Maintained constant communication with the testers by assisting the Project Manager in conducting Daily Defect Review meetings during and after the QA Test process.
• Experience in creating and executing test plans for functional tests, QA tests, regression tests, smoke tests and UAT.
• Participated in Data Validation process in QAT by developing spreadsheets with data from the reports in QA.

Environment: Scrum-Waterfall (Hybrid), MS Office Suite, Windows, SSIS, SSMS, SQL Server.

Confidential

Business System Analyst

Responsibilities:

• Identified technology components, data flows, possible interfaces, and affected Lines of Business based on high-level process description or scenarios to understand assessment scope.
• Identified inconsistencies and gaps within the business process description and collaborated with stakeholders to clarify and simplify complex processes.
• Created an assessment plan according to the recommended practices of the organization so that activities and milestones of the assessment team can be measured against the goals of the plan.
• Produced the compliance report indicating the level of PCI DSS compliance by the business process.
• Involved in the process of Use Case creation for Payment Credit Card (PCI Compliance).
• Acted as a Liaison between the Business and Technical team.
• Conducted analysis while gathering requirements from the Legacy system to Web Application.
• Created Business Requirements Document.
• Created Functional Document based on Business Requirements Document.
• Determined business processes and system requirements by conducting meetings with key subject matter experts.
• Designed business processes using UML diagrams. Thoroughly analyzed the business processes and created Use cases.
• Gathered Information for Forms Catalog for the E-commerce project.
• Created UML diagrams using Visio. Converted functional specifications into process flows using MS Visio and converted them into use cases.

Environment: Waterfall, rational requisite Pro, rational rose, HP QC, MS project, MS visio, MSSQL server, SharePoint, MS office.