Technical Business Analyst Resume Profile
3.00/5 (Submit Your Rating)
SUMMARY:
- Business Analyst with 6 years' experience working in entire Software Development Lifecycle SDLC in a very fast paced environment using traditional Waterfall, Agile and hybrid methodologies
- Adept at coordinating and following up in simultaneous high profile projects ranging from Confidential with cross functional teams in a global environment
- Proficient Scrum practitioner in various capacities- Scrum Master, Product owner, Business Analyst and tester
- Familiar with JavaScript, XML, HTTP, Java, C , ASP
- Experienced in financial services, recruitment, real estate and advertising industries
EXPERTISE:
|
|
TECHNICAL SKILLS:
- Databases : SQL Server 2008/2012, Oracle 11g, MS Access
- Programming : PL/SQL, T-SQL
- Reporting/ Data visualization : Crystal Reports 10.0, MicroStrategy, Tableau
- CRM : Salesforce, MS Dynamics
- Project Management Tools : MS Project, Confluence, Bugzilla, JIRA, LANDesk, TFS, Footprints
- Database Modeling Tools : Erwin
- Modeling Tools : Rational Rose, Jude, Balsamiq, Microsoft Visio
STRENGTHS:
- Project Management
- Scrum
- SharePoint
- Charles River software
- Saleforce.com
- Conduct weekly change control meetings:
- SQL
- BUSINESS ANALYSIS
- Worked extensively in writing Confidential. Used UML modeling and drew use case diagrams, class diagrams and sequence diagrams using Jude
- Process flow diagrams, data flow diagrams, mock ups, wireframes etc.. for several projects using Balsamiq, MS Visio
- I am very comfortable asking questions and finding out the process. I can facilitate meetings and also sit with user and follow their day to day activities to get a better understanding of the process
- Database modeling and database design
- Worked on several projects in my Masters working on Database modeling and database design using Erwin tool
- Experience in crystal reports, Yardi software, Microstartegy. Also have very basic understanding of Tableau
- I facilitate/ conduct this meeting for the infrastructure, Peoplesoft, RecruitMax development team to make sure all the Requests for Changes are approved before they start working on it following Sarbanes-Oxley Compliance
- I have worked extensively on Salesfore.com. Please see the updated resume for the projects
- Was the only business analyst for the implementation of Charles River software trading and investment software . I worked on the project from start to roll out and also provided production support
- I have worked on SharePoint web portal as part of my Masters projects
- I have both CSM and CSPO certifications and also have worked extensively in Scrum teams
- I have managed one for Investment Model Management Project 85k and Document Management System 1.3M project. Listed out PM activities I did in the resume
PROFESSIONAL EXPERIENCE :
Confidential
Technical Business Analyst
Responsibilities:
- Document Management System is a highly complex a 1.3M enterprise wide system that utilizes Oracle Universal Content Management System, Oracle Fusion Middleware, Weblogic server
- Manage and lead the end to end analysis, design and write requirements, workflows and business rules.
- Coordinate and follow up with off shore development team, USA web development team, graphic designers for the Health Information Management HIM Portal that integrates with DMS
- Develop mockups using Balsamiq for UI/UX to help graphic designers
- Recruitmax integration with PeopleSoft
- RMAX is an end to end recruitment web application built using ColdFusion, JavaScript and SQL Server
- Coordinate with Europe, USA users to gather requirements for Recruitmax
- Write functional requirements document FRD for new and enhancement requests to payroll and invoice modules
- Work with Product Owner and Regional Vice Presidents to prioritize requirements
- Conduct requirements elicitation sessions and maintain the product backlog- writing requirements as user stories, tasks in JIRA
- Analyze business processes for new acquisitions, and be the testing lead for conversions from various other front office systems to Recruitmax
- Write test cases and perform integration testing. Conduct User Acceptance Test whenever required
- Make sure the impediments are addressed immediately and escalate issues if need be
- Track bugs and hotfixes in LANDesk and Bugzilla
- Maintain project related change control and worked with infrastructure team for deployment and go live
- Provide post live production support and train the users as needed
- Develop stored procedures for data validation on Oracle SQL developer
Confidential
Business Analyst
Responsibilities:
- Conducted and facilitated team meetings to capture various business teams' business process and covert to Salesforce workflows for the roll out of Confidential
- Extracted data from Confidential and loaded data to Salesforce.com using data loader and Informatica
- Build reports, workflows and set up case types in Salesforce.com
- Lead the design and development of workflows for portfolio management, trade order management and execution and post trade settlement for Confidential software implementation from discovery to implementation phase
- Confidential integrations with other trading systems
- Developed functional specifications for the Orion Advisor trading application integration with Confidential
- Laserfiche Implementation and Filenet to Laserfiche migration
- Performed gap analysis, identified the pain points and missing functionalities and wrote the requirements for the solution for Laserfiche implementation project
- Made sure that all the existing files and associated meta data was captured and migrated from Filenet to Laserfiche migration
- Hosted Call Center Cost Benefit Analysis
- Performed cost benefit analysis when evaluating buy a new Salesforce integrated hosted call center solution
- Evaluated the current call center software, analyzed and made a list of all the problems call center employees were facing.
- Drew process flows of Sales and call center teams for the TO BE process
- Make sure these features existed in the solutions being considered
- Evaluated three systems before zeroing in on InContact
Other responsibilities
- Analyzed and wrote specifications BRD for using a single interface with multiple external data sources for Account Receivables AR , Account Payables AP and Billing departments that helped them in their month end process
- Conducted JAD sessions and requirements elicitation sessions using various techniques One- One interviews, team meeting facilitation and job shadowing
- Wrote concise, normalized and functional requirements along with Process Flow Diagrams, Data Flow, Use Case and Use case diagrams depending on the project need using MS Visio
- Helped bridge the communication gap between the business teams and software development teams
- Successfully established a hybrid of Scrum and Waterfall methodology for software development
- Tracked issues and bugs in Team Foundation Server. Used MS Project and TFS are project management tools
- Developed SQL queries for ad hoc requests on SQL Server Management Studio 2012 and Tableau
Accomplishments:
- Developed the project proposal and specifications for Confidential. Our team won the Best Idea in the Operations Efficiency Program. Promoted to Project Manager role to manage Investment Model Management Project
- Managed and successfully launched the project within the given budget 85K and on time 7 months
- Lead and coordinated with 16 member cross functional team on the design, analysis and implementation of the IMM web portal along with the Salesforce integration
- Communicated and tracked the progress of the project timelines effectively
- Mitigated impediments and made sure project is on schedule and on budget meeting the requirements
- Conducted User Acceptance Testing
- Maintained project related change control and worked with infrastructure team for deployment and go live
- Worked with marketing team to launch the project
Confidential
Crystal Reports Developer
Responsibilities:
- Developed PL/SQL queries per user requirements to create reports
- Created reports and sub reports using Crystal Reports on SQL Server 2005
- Developed formulae, headers, filters for the reports
- Integrated Crystal Reports interactively with the Yardi front-end
- Conduct user acceptance testing and get feedback
Confidential
Business Analyst
Responsibilities:
- Met with HR team to understand their day to day processes and facilitated brainstorming sessions to come up with requirements for SAP HR Module
- Developed user stories per requirements and was responsible for maintaining requirements traceability matrix
- Developed SQL queries to generate reports for HR team
- Worked on business contingency plan during disaster recovery