We provide IT Staff Augmentation Services!

Sr. Business Technical Analyst Resume

4.00 Rating

Oakbrook, IL


  • 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.


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


Confidential, Oakbrook, IL

Sr. Business Technical Analyst


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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.

We'd love your feedback!