Sr. Business Technical Analyst Resume
Oakbrook, IL
SUMMARY
- Experienced Business Analyst with deep knowledge in Business Process Analysis, Data Analysis, Integration Analyst, System Analysis, IT support and Business Process Modeling (BPM).
- Demonstrated experience gathering requirements for an application development project in both Agile and Waterfall methodologies.
- Experience in Multiple Domains - Finance, Digital Marketing, Point of Sale, Mobile, Finance, Healthcare, Pharmaceutical (PBM), Medical Insurance Products and Plans, E-commerce, Retail, Order Management and distribution (logistics).
- Experience in Hybrid Mobile - iOS and Android Platforms for both Mobile & Tablets.
- Worked as a Jr. Scrum Master.
- Created project timeline documents and managed resources and deliverables by creating RACI Matrices.
- Ran Daily stand up meetings and updated burn down chart on weekly basis.
- Worked to remove constraints and blockers reported by the team.
- Experience in writing requirements for SOA based applications, Content Management Systems (Magento, AEM & Word Press), Data warehousing, Reporting, ETL, API, Webservices (RESTful) and CRM - Salesforce & Pardot Email/ Social Marketing App Center.
- Expert in creating requirements artifacts like Business & Functional Requirements Documents, Product and Sprint backlogs, user stories, use cases, gap analysis, impact analysis, change management/ request documents etc.
- Worked closely with the UI/ UX team and created wireframes.
- Wrote testing deliverables like Test Plans, Test cases, Traceability matrix etc.
- Participated in both System and User Acceptance Testing and managed defects.
- Wrote SQL queries to validate data and familiar with data science techniques.
- Experience in compliance of SOX, PCI and HIPAA guidelines.
- Worked as Tier 1 and Tier 2 IT support for organizations like BCBS, Red Bull and Fidelity.
- Strong knowledge of data and dimensional modeling.
- Worked with off shore teams.
TECHNICAL SKILLS
Methodologies: Agile SCRUM, SDLC
Modeling Tools: MS Visio, Edraw, Balsamiq, Axure
Reporting tools: Excel, Power BI
Testing Tools: Quality Center, ALM, JIRA, TFS
Repositories: SharePoint, Confluence (wiki)
Packages: MS Office, MS Project, MS Reporting Services
Languages: SQL
Operating Environments\Systems: Windows 2003 Server, Windows 2008 Server R2, Windows Server 2012, Windows XP, Windows 7, Windows 8/10 and Mac OS Xv10.0.
Ticketing Software: Service Now, Service center manager console, Numara Footprint, Team Track, Remedy and Serena service manager
Security: Ccleaner, Malware bytes anti malware, Forefront, Symantec, McAfee.
Databases: SQL Server, Oracle Server. SQL Programing language, Squirrel, Amazon Redshift
Data Science: Beginner knowledge of R programing language
PROFESSIONAL EXPERIENCE
Confidential, Oakbrook, IL
Sr. Business Technical Analyst
Responsibilities:
- Work with IT product leadership to determine design approach, cost estimation, setting technical direction, enhance business processes, and identify required resources to execute the deliverables
- As a technical BA, I do lot of data analysis that involveswriting complex SQL queries to support ad-hoc reporting requests in the Redshift environment
- Well versed in analytics and reporting tools like Excel, Power BI, Tableau and Alteryx to build dashboards and reports to share insights with business stakeholders.
- Providesubject matter expertise to other teams, analyze thechange requests to determine feasibility in relation to existing technical requirements, process and data models validations.
- Ensure the solution design meets the prioritized business and non-functional requirements from data perspectives.
- Triage and remediates defects with Quality Management System team, this involves daily interaction with development staff (on and off shore)
- Maintain CIM Confluence repository for cross functional teams collaboration. Coordinates activities and manage tasks through JIRA, and oversee deployment processes across different markets in EU and Asia.
- Createdbusiness requirements documents and Project planning in MS Project.
- Create and execute through UAT plans to support business requirements.
- Created RACI matrices
- Created Work break down structures
- Managed resources and Budgets
- Managed risks and constraint
- Experience of enforcing privacy and regulatory compliance for customer data, including compliance in campaign subscriptions within Adobe campaign manager.
Confidential, Hoffman Estates, IL
Sr. Business Analyst/Integration Analyst
Responsibilities:
- Worked with the Cross Functional Business teams to understand the current SHC functionalities and changes in the Business Process Model during the transition to SHO.
- Created AS-IS and TO-BE Process models and worked with the stakeholders and SMEs to Re-engineer the processes.
- Worked with the functional ERP Business Leads understand the constraints of NetSuite ERP Suite and tweaked the business processes to align with the constraints.
- Created Business and Functional requirements documents documenting the use cases for each actor in the process and the exception paths.
- Created the documentation for the Configuration work in NetSuite.
- Worked with a Team of NetSuite experts to create workflows within NetSuite.
- Created Integration documents like data flow diagrams, E-R Diagrams, data mapping documents etc.
- Documented the changes from source systems and procedures.
- Defined the error processes and transformation rules during data transfer.
- Wrote requirements and altered webservices JSON and XML scripts for data transfer during integration.
- Took data transferred from SHO via XML files and did analysis on it in excel.
- Wrote SQL Queries for Data validation in Squirrel.
- Worked with the Testing Team to triage issues.
Confidential, Chicago, IL
Business Analyst/ Data Analyst
Responsibilities:
- Met with business to understand their needs.
- Worked with the business stakeholders to under AS-IS processes and systems.
- Created Gap and Impact Analysis documentation.
- Created flowcharts and work flow diagrams using Visio.
- Created Functional Requirements Document (FRD) with functional and nonfunctional requirements.
- Created wireframes in Axure and added them to the FRD.
- Created Use Case documents and worked closely with the UX team to finalize wireframes of the UI.
- Wrote down requirements for CMS modules and worked with UI/UX team and content strategist to finalize things based on taxonomy and localization evaluations.
- Wrote requirements for the workflows for editing and publishing of pages/ templates and assets in Magento CMS.
- Created detailed workflows.
- Gathered reporting requirements from Business users and studied their existing system.
- Created excel mock ups and used Pivot tables and v-lookup to sort data.
- Created reports mock ups with sample data and expected values.
- Conveyed Reporting requirements to the BI Developer using comprehensive documentation and wireframes.
- Documented Reporting Requirements (facts, dimensions, excel mock ups) and performed Data Analysis (pivot Tables, v look ups))
- Post design sessions, wrote web services requirements for the integration points identified in the system.
- Used SQL queries to get data extracts to analyze data.
- Studied primary and foreign keys within the relational databases to create mapping documents.
- Worked with Solutions architect and Data Design Engineer to create Data Mapping documents.
- Created Reporting Requirements Document.
- Worked on creating Excel mock ups for the reports developers.
- Wrote detailed test plans and wrote test cases.
- Worked with the testers to identify defects in HPQC and assigned them to the developers.
- Wrote simple SQL queries to test data.
- Maintained the defects dashboard in HP Quality Center for the release, and ran reports for each defect scrub call to give status on % Open, % closed, % Assigned, % Fixed, % Ready For Retest.
- Managed the defect cycle from open to close.
- Created Training Assessment needs Document.
- Gave post-production support to users.
- Worked with off-shore development and QA resources.
Confidential, Eagan, MN
Reporting Analyst
Responsibilities:
- Ran Daily stand up meetings and updated burn down chart on release basis.
- Managed Risk log and created mitigation plan to manage the risks.
- Facilitated requirements gathering workshops and review sessions.
- Analyzed and documentedbusinessprocesses and flows.
- Created Business Requirements document and wrote detailed use cases based on the requirements.
- Made sure all requirements were compliant with HIPAA, HIE and other Company Compliance Policies.
- Helped breakdown the functionality into logical releases so that development can be done.
- Brought myself up to speed on pharmaceutical terms and compliances such as e.g. ePrescribing
- Performed Gap analysis and impact analysis on any changes that were being suggested by business.
- Worked closely with the Solutions Architect in design sessions including report design planning including full reference architecture from data integration, through semantic layer and reporting.
- Worked with the developers in clarifying requirements.
- Wrote test cases and helped out QA Analyst during SIT.
- Did Demos for the business at the each of each 6 week release cycle.
- Coordinated UAT and helped in defect management and triaging issues.
- Created training documents.
Confidential - Chicago, IL
Business Analyst/ Jr. Scrum Master
Responsibilities:
- Created project timeline documents and managed resources and deliverables by creating RACI Matrices.
- Facilitated Planning sprints, poker planning sessions, Sprint kick off meetings, demo and retrospective meetings.
- Ran Daily stand up meetings and updated burn down chart on weekly basis.
- Worked to remove constraints and blockers reported by the team.
- Met with the Business/ Product owner to develop User stories.
- Created Product backlog & worked with the product owner to prioritize the product backlog.
- Worked with the Product Owner to hash out detailed Acceptance Criteria for user stories.
- Worked with UI/ UX team to create templates.
- Worked with UI/UX team to create email campaign templates based on the branding requirements.
- Worked with the business PO to finalize KPIs for reporting/ analytics.
- Facilitated Sprint Planning meetings to detail out the work estimation time.
- Lead Daily stand up meetings and updated the burn down chart.
- Worked to ensure that all requirements are PCI compliant.
- Maintained Test case/ Acceptance Criteria documentation.
- Lead the bi-weekly Sprint Review meetings.
- Tracked project status using JIRA / scrum board.
- Tracked defects using JIRA
- Wrote SQL queries for data validation, data retrieval and data analysis.
- Was involved in getting requirements for Adobe Test &Target, A/B Testing and working with the vendor to set up the Test and Target.
- Performed Browser Testing Test Sessions in Atlassian Capture for JIRA.
- Wrote write-ups for Sprint Retrospective meetings.
Confidential, Chicago, IL
Sr. Business Analyst
Responsibilities:
- Worked in all stages of SDLC - waterfall.
- Conducted review meetings with Business partners and discussed issues with development team
- Analyzedbusiness needs, created and developed new functionality to meet real time data integration that facilitated decision making
- Analyzed and assessed theSystemsandbusiness processes.
- Performedrequirement analysis, developed all theuse casesandworkflows.
- Developed processflow diagramsand worked closely with offsite application development partner to vendor to define project scope document
- DevelopedData Mappingdocumentsandscoping documents.
- Created Business Rules to sort transactions types.
- Streamlined clerical work processes and mapped to the automated system.
- Created many differenttest userswith various entitlements to be able to test the application’s various functionalities that vary with different entitlements.
- TestedXML scriptsfor web services testing.
- Setuptest transactionsusing developer’s help and wroteSQL queries, to be able to test the application’s new enhancements to reporting.
- Worked with Technology Lead to scrub all out alldefectsencountered intest case execution.
Confidential, Schaumburg, IL
IT Operations Manager
Responsibilities:
- Provide IT end user and exclusive support to department heads and executives.
- SLA and KPI management, reporting and escalations
- IT Project implementations support and communication planning.
- Server health monitoring and reporting.
- Worked with end users and clients finding and identifying defects utilizing best practices and effective techniques.
- Implemented the use of Key Performance Indicator report to evaluate Service Desk performance.
- Trained and prepared new employees with ITIL Foundation.
- Developed and implemented formal training program to support both the application and the customer.
- Assessed in incident occurrence and process, provided support and best practices.
- Created and published information of changes and its implementation.
- Support the network environment via Citrix App server.
- Desktop Imaging using SCCM Console.