VENKATA BHARAT V.

CHEKURI

SUMMARY:
 Over 8 + years of experience as a Business Analyst performing Business requirements modeling,
risk analysis, Software validation and development of Web Based, and Client/ Server applications in
diverse.
 Strong analytical, problem- solving and communication skills with particular emphasis on clear,
detailed Business Requirements Documentation and Functional Specifications Documentation,
planning, Business process Change Management, as well as reports for management.
 Experience in all phases of Software Development Life Cycle (SDLC) including Business
Requirements gathering, Design, Business process flows, Business process modelling, Analysis, and
Documentation using Waterfall and Agile (Scrum) methodologies.
 Expertise in Organising formal interviews, surveys, questionnaire, and Joint Application
Development (JAD), Joint Requirement Planning (JRP) sessions with the Subject Matter Experts
(SME's) & Stakeholders of the projects for project definition, analyse requirements, creating
prototypes, user interface.
 Experience in conducting Gap Analysis, SIPOC Analysis , Kano Analysis ,User Acceptance Testing
(UAT), SWOT analysis, Cost Benefit analysis, ROI Analysis, Data flow diagrams, Entity Relation
diagrams, Developing Business Process Re-Engineering ,Process Modelling and Requirement
Traceability Matrix (RTM). 
 Exposure in analysing detailed finance and accounting processes to identify improvement
opportunities in internal and external reporting
 Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality,
Data Governance and Master Data management (MDM).
 Expertise in creating financial and quantitative models using Visual Basic programs, VBA macros,
and SQL.
 Experience in the utilization of relational databases: Oracle, Microsoft SQL and fulfills tasks
associated with data collection, DB creation, and DB review.
 Strong leadership and coordination skills; ability to prioritize and take decisive action using good
judgment.
 Extensive exposure to Rational Unified Process (RUP) methodology including UML
 Proficient in Test Planning, Test Preparation, Test Execution, Issue Resolution Report Generation
using IT/database systems
 Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS),
SQL Server Reporting Services (SSRS)

EXPERIENCE:
Sr. Business Analyst/Product Owner
Cytel Inc, Cambridge, MA Oct 2018 – Till Date
 Working as a Business Analyst and Product Owner working on company applications like East SaaS,
ACES (Access Control Execution System), Flex Randomizer, Statistical Workbench etc.
 Assisting Project Manager in analyzing and documenting Business Requirements for Cytel customer
portal effort.
 Writing initial key requirements for portal like create user name, registration form, cookie policies,
authentication, password requirements, subscription model, training etc.
 Writing use cases, workflows in the form of epics and user stories etc. for Cytel customer portal.
 Create documentation for clients, including PowerPoint presentations and Visio workflows
regarding Functional & Technical requirements, design, training, etc.
 Working on Statistical workbench application as Business Analyst and project Manager writing UI/
UX requirements.
 Communicating effectively with business and development teams to draft product's functional
requirements like screen, interface, and GUI designs.
 Writing UI Requirements for Dashboard, My Projects, Search, Advance search, Workflows
interfaces for SWB.
 Creating Statistical workbench application prototype using Axure RP 8 application.
 Writing prototype code in Axure RP 8 for login, dashboard, My Projects, Search etc.
 Work with development team to plan sprints and resolve issues that block development.
 Defining two week sprint for development prioritizing stories to be implemented.
 Writing detailed user stories with accurate Acceptance criteria’s and support it with the necessary
technical documentation.
 Write test plans for individual features of the SWB application and draft the necessary test cases.
 Coordinate user acceptance testing and providing feedback to the development team.
 Writing and defining Platform-agnostic development in JavaScript, C++, C# .Net Core allows
deployment to Windows, Mac and Linux hosts.
 Working on ACES, Flex Randomizer as business analyst and product owner working on next version
releases.
 Maintaining product backlog for both applications and prioritizing based on customer/business
value
 Documenting all known bugs from previous releases and writing users stores to Kanban board.
 Participate in project planning and involve all the stake holders as required.
 Managing issue log for all the applications and document them accordingly.
 Schedule and hold status meetings with stake holders and update the project statuses.

Sr. Business Analyst

Trac Intermodal, Princeton, NJ Mar 2018 – Oct 2018
 Worked as a Business Analyst collecting and analyzing the reporting requirements and transferring
the same knowledge to development team.
 Working with business units like Operations, Finance, Business Planning & Analysis, Billing teams to
analyze requirements and document them.
 Working as a liaison between business Units and development team with responsibility for assessing
customer business needs and documenting detailed business requirements and report specifications.
 Documenting the acquired results of analysis and workflows as well as obtaining sign-off from the
appropriate client.
 Creating training material using PowerPoints and Microsoft word on how to use reporting services.
 Assisted in decommissioning old reporting services LogiXML, Web focus and moving them to
AtScale cubes, SSRS Reports, API’s and Power Bi Dashboards.
 Performing GAP analysis on Old Legacy cubes and update the requirements accordingly.
 Reporting found gaps during analysis to the Project manager and product owners.
 Analyzed old MS Access databases and documented technical specifications and translated them into
system level requirements.
 Working with applications like EZBook (Bookings), EBM (Event & Billing Management), Oracle EBS
teams in understanding their applications and translate the data feeds and sources into technical
writing for the development team.
 Writing epics and user stories to reflect the deliverables of the sprint on Jira assisting scrum master.
 Assisted the product owner in prioritizing the requirements and translate them into sprint
deliverables.
 Create and maintain Requirements Traceability Matrix (RTM) to track process validation.
 Communicating effectively with external clients and internal teams to deliver product's functional
requirements like screen, interface, and GUI designs.
 Designing and executing the test scripts and test scenarios.
 Coordinating with the groups of business unit who test, validate, evaluate new applications and
functions, and determine issues in services and software.
 Managing any change requests related to the working project plans daily to meet the agreed
deadlines.
 Coordinate tools for process management and ensure that data cycle guidelines are adhered to.
 Guide and teach business and IT partners in data best practice and its use in business processes and
decision making.
 Assisted the project manager in maintaining project tasks in alignment with the company’s Go-Live
initiative.

Sr. Business Analyst

BNY Mellon, New York City, NY Aug 2017 – Feb 2018
 Worked as a Business/ Data Integration analyst for Pershing (BNY subsidiary) performing
Business/data analysis and BI reporting for their financial information with strict regulatory code.
 Gather and document Business requirements to determine appropriate methodology to manage
expenses for companies’ financial year.
 Organize formal interviews with Key stakeholders to determine the project scope & definition.
 Planned and managed the project using waterfall methodology
 Update Project Dashboard on excel on a monthly basis to update the senior management
 Designing dashboards in Microsoft Excel using Visual Basic programming and VBA macros.
 Maintain and execute costing models within ABM and worked with teams within the project to
analyze results
 Perform gap analysis to define cubes with in SAS ABM for Visual Analytics module.
 Assist manger in assigning user roles (security) in SAS ABM for business user groups using RACI.
 Build Process flows to determine data flow from cost elements in each stages of the ABM Model.
 Act as a liaison between business staff and technical staff to articulate needs, issues and concerns.
 Exercise business intelligence data governance. Perform backup and restorations. Architected,
constructed, and deployed complex business intelligence reports, scorecards, and dashboards.
 Created user stories, use cases, functional specifications, security role metrics, user acceptance
criteria, and configuration specifications.
 Created multiple surveys as part of the business requirements as well as for Business Impact
analysis, Risk analysis.
 Work with Product Engineering team and other Quality Assurance Engineers to identify,
reproduce/troubleshoot defects and documented them.
 Prepare process flows, data flow diagrams using MS Visio. Designed data mapping for source to
target system, defined the data dictionary and dependencies.
 Analyze data warehouse project database requirements from the users in terms of the dimensions
they want to measure and the facts for which the dimensions need to be analyzed.
 Assisted (as an SME) in Developing and writing IT Disaster Recovery Policy and Standards
documents.
 Provide risk-related SOP's for IT infrastructure in relation to low/high level security events.
 Created a business continuity plan for the current project to assess the potential threats involved.
 Moreover, I also authored functional requirements documents [FRD] by interacting with
development team for improving client’s legacy system.
 Assisted team’s DR Manager’s efforts of infrastructure, server, and applications recovery plans for
SAS ABM.
 Received training on extensive SAS ABM & other applications training as part of the project scope.

Business/Data Analyst
Genentech Inc., San Francisco, CA Jun 2017 – Aug 2017
 Worked as a Project coordinator and Data Profiling Analyst for defining and profiling of key data
assets managed in Development Sciences
 Provided Business analysis of identifying business needs and determining solutions to business
problems. SIPOC analysis, Process maps, Provide Requirement and functional Analysis.
 Drafted UML Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Workflow
Diagrams using MS Visio.
 Organized JAD sessions to establish the specific data needs and reporting requirements for data
mart deployments.
 Worked on extraction, analysis, cleansing and transformation of claims data per stipulated
business rules using proficient data cleansing and profiling tools.
 Responsible for gathering and assessing business information needs and preparing system
requirements, report requirements.
 Involved in various phases of Software Development Life Cycle (SDLC) including analysis, design,
testing, implementation and maintenance.
 Assisted in creating and maintaining business data dictionary with the usage pattern and data
profiling for all builds, data interfaces and reports.
 Performed analyses, development & evaluation of data mining in a data warehouse environment
which includes data design, database architecture, data profiling, metadata repository creation.
 Created inventory and profile key data assets through the full data life cycle
 Performed data risk assessment on data through the full data life cycle.
 Acted as SME for their Disaster recovery plan efforts as part of the project scope.
 Generated Ad hoc reports using various SAS procedures and Macro based on business case
 Created SQL database objects, Crystal Reports and documented the Business requirement
documents (BRD), System requirement document (SRD), and produced the Data flow diagrams
(DFD), Bus Matrix and Requirement Traceability Matrix.

Sr. IT Business Analyst

Ellucian, Fairfax, VA Oct 2016 – May 2017
 Worked as an Implementation Coordinator and Business Analyst for Ellucian’s Dynamics CRM
migration and AppDynamics efforts.
 Assisting project manager in defining the project, managing project roles & managing versions
using MS Project. Created Project Charter, Work Breakdown Structure, and Gantt Charts for the
MS Dynamics CRM migration efforts
 Lead the team’s effort to implement AppDynamics for CRM applications, servers.
 Created documentation for clients, including PowerPoint presentations and Visio workflows
regarding Functional & Technical requirements, design, training, process reengineering, etc.
 Analysed the functional and technical enhancements and limitations of the solution to avoid
potential issues.
 Coordinating with Business Owners and Software development team in defining the solution.
 Used RAD & Prototyping methodology extensively along with Six-Sigma concepts to ensure quality
service.
 Gave weekly presentations to Executive Sponsor and stakeholders and the rest of the business team
 Responsible for customization and migration of Dynamics CRM applications and latest system
upgrades.
 Assisted in customization of MS Dynamics CRM system, based on the created functional
requirements of the client and use of out-of-the-box features, required configuration and
customization for various functionalities and requirements.
 Responsible for customization & migration of Dynamics CRM applications & system upgrades.
 Performed the data migrations to the CRM database using Scribe
 Maintaining effective user relationship by performing front-line support of MS Dynamics CRM
 Assisted in mining data from the SQL database that was used in several significant presentations.
 Creating documentation for clients, including PowerPoint presentations and Visio workflows
regarding Functional and Technical requirements, design, training, process reengineering, etc.
 Providing AWS cost optimization techniques based on AWS pricing model.
 Developed dynamics reports using Microsoft Dynamics CRM reporting interface and SSRS (SQL
2008 R2 engine) deployed it on the CRM that were used in the application depending on roles.
 Performed administrator tasks like backup, restore, maintenance of databases, creating security
roles, sharing of records across teams etc.
 Gathered the right information associated business impact analysis
 Perform Risk Analysis on existing CRM Systems and determining possible risks associated.
 Conducted IT-Security standards/compliance assessments
 Used excel templates for data imports to and from Dynamics CRM.
 Worked on querying SQL 2008 database for customer production issue resolutions.
 Developed detailed recommendations for mitigating findings and process improvement projects
 Worked on dashboards in Microsoft Dynamics CRM. Surveyed variety of users to develop
customized dashboards according to their security roles.
 Performed administrator tasks like backup, restore, maintenance of databases, creating security
roles, sharing of records across teams etc.
 Created and performed BIA Surveys with multiple clients to better under the risks involved
 Facilitated multiple Dynamics CRM Demos to clients and colleagues to illustrate many automation
features of Dynamics that can help reduce cost and increase productivity.
 Assisted IT Manager in Performing Third Party Vendor Assessments for internal IT Services.
 Used Rational Rose and MS Visio for effective visual representation of Use Cases

IT Business Analyst
Sheridan Healthcare, Sunrise, FL Dec 2015 – Sept 2016
 Worked as Project Coordinator and Business Analyst for Enterprise Applications team primarily
working on Kronos Workforce, Oracle Hyperion Financial Management, Lawson ERP, Vistar
contracting & credentialing Applications, MS Dynamics CRM.
 Involved in analyzing, business requirement gathering, planning, & deploying solutions in support
of corporate strategies & business initiatives.
 Facilitated communication between organizations in aligning the needs of the business with
capabilities delivered by IT
 Lead the implementation effort of AppDynamics for Kronos, Hyperion, Vistar, Lawson, MS
Dynamics CRM for application and server monitoring.
 Lead the groups Data Masking Project for all the Enterprise applications for HIPAA & ePHI
Compliance.
 Ensured Enterprise applications, logical access, and environments comply with SOX and respond
to internal and external Audit requests
 Project Coordinator for ITSM (IT Service Management) Project to create new Service desk for
Enterprise Applications. Played a key role in defining the CMDB, RACI Matrix, Use Cases, Work
Flows, Business requirements documents & Service Catalogs for each Enterprise Application.
 Performed SWOT Analysis before new project implementations.
 Worked as business analyst for Enterprise Applications Team for Kronos Workforce Central 7.3
including other Kronos activities for 500+ employees across 15+ divisions with diverse and
segregated use of systems.
 Evaluated user needs and recommend best practices to implement new or improved Kronos
Functionality.
 Performed Gap Analysis of the processes to identify and validate requirements.
 Created project plans for all multiple Kronos related projects using MS Project to monitor and
track tasks and resources.
 Train teams and management on Microsoft Dynamics CRM applications and functions for new
business processes
 Collected existing infrastructure information including Active Directory, SQL server, Reporting
Server instance for implementation of New Kronos 8.1, MS Dynamics CRM 2013.
 Evaluated user needs for, recommend best practices, and developed new Kronos Connect
interfaces, conducted internal/UAT testing, schedule interfaces to run via Windows Scheduler if
required; write, test, and deployed related Windows BAT files.
 Implemented solutions to all Enterprise Applications by scheduling change control (SLDC),
accommodating IT Resources and working closely with vendor support.
 Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by
working with the Hyperion team along with business managers.
 Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP
environment.
 Performed Third Party Vendor Assessments against existing contracts with Kronos, Vistar, iCIMS
 Audited Enterprise Applications systems based on security standards & IT Protocols.
 Acted as a liaison between various IT groups on information security related topics.
 Translated business requirements into IT systems solutions to Data application.
 Drive and promote SharePoint capabilities and features to improve and increase customer
efficiency in using SharePoint.
 Assisted in Creating custom SharePoint solutions that use SharePoint Designer Workflows,
InfoPath forms, JavaScript, and web service calls
 Ensured all Service Desk requests/incidents were resolved within SLA limits; ensured all project
deliverables, internal client and external client expectations were met; communicated
transparently both vertically and horizontally
 Created Quarterly reports on all service incidents for all enterprise applications on excel
 Designed and wrote IT Disaster Recovery Policy and Standards documents
 Identified a business need, problem, or opportunity, defined the nature of the solution that meets
the need and justified the investment necessary to deliver the solution
 Collaborated with business customers and QA team to create test plans, analyze test cases, identify
issues and escalate them to appropriate teams.
 Evaluated the work effort to complete requirements and UAT testing to provide project estimates,
project plans, business impact analysis and project charters
 Worked directly with team members from business sectors & the applications development team
 Received training on ITIL Foundation for ITSM Project.
 Received training on AppDynamics which includes administrative training, Application
configuration training, creation of dashboard & reports.

Investment Analyst
National Securities, Miami, FL. Sept 2015 – Nov 2015

 Conducted research report and making recommendations on the equity market

 Conducted extensive research on investment strategies
 Compiled and documented reports for organization's meetings and conferences
 Interacted with clients daily and answered their queries while giving information about different
products and services
 Prospecting new Clientele and pitching market recommendations.
 IPO prospectuses and meeting with newly underwritten clients.
 Searched the market for investment opportunities, reported to manager and back office.
 Analyzed ROI and risks for investment portfolio from databases.
 Back tested investment portfolios audited with investment regulations.
 Gathered financial data and statistics and prepared monthly report to suggest investments and
build effective financial models
 Generated annual reports on liquidity, financial status and data assessment for the bank
 Interpreted past and current financial data, examined trends, and determined investment
opportunities
 Ensured all data files and client records on the intranet are current and revised on a timely basis

IT Analyst
2M Companies Inc. Dallas, TX. Jan 2015 - Aug 2015

 Analyzed and prepared company’s IT-Budget for fiscal year 2015 along with the IT Manager and
presented a PowerPoint presentation it to the CEO.
 Assisted the IT Manager in maintaining the overall IT Infrastructure of 50-user office.
 Conducted On-Boarding for new employees and provided them with Orientation on IT Policies and
Procedures.
 Implemented Enterprise password management solutions focusing on Active Directory / LDAP
Integration, Role-based access control & user groups, Password ownership & sharing Agentless
remote password synchronization, backup & disaster recovery, password management
 Analyzed and documented company’s technology management and determined optimal solutions
for future IT purchases.
 Implemented data strategies on IT Inventory and generated monthly, quarterly reports on
inventory, expenditure etc. on excel and other analytic report generating tools.
 Conducted market research on various product developments generated reports on implementing
new technologies within the organization.
 Updated and maintained Avaya VoIP phone and voice mail system.
 Analyzed and documented functional and technical requirements for current projects on IT
security, cloud solutions, inventory management applications.
 Troubleshoot issues with equipment like servers, computers and printers and Technical support.
 Ensured compliance of Information Technology Security Policies and utilized vulnerability tools
 Data entry and server-based storage documentation maintenance
 Evaluation of new systems, software, services and processed optimizing for analyzing cost,
implementation effort & security
 Performing business and data analysis activities for the implementation of new business
applications.
 Gathering, analyzing and documenting functional and technical requirements for new projects,
enhancements to existing solutions and production issues reported by end users.

Linux Administrator/Web Developer

SMU COX Technology Dallas, TX Oct 2013 – Dec 2014
 Provided on-going administration and Tier1 support for Ubuntu Linux Servers for Cox School of
Business.
 Serve as the administrator for SMU Cox School of Business Websites Which include Dedicated
website of the Business School, Faculty Blogs, Cox School Blogs and Alumni Site.
 Administrator for Faculty Directory & Academic Information Management System.
 Maintained SMU Cox websites using open source enterprise portal Liferay.
 Proactively implemented web governance analytics ‘Site improve’ for quality assurance of the all
existing SMU COX Websites.
 Performed LAMP configurations and deployments, Basic network adapter configuration.
 Handling and Solving Issues sent to The Cox Web Ticketing System.
 Assist in documenting & maintaining IT Security policies and procedures.
 Assist in creating monitoring scripts, configuring servers and services, Patch Management.
 Providing Hardware & Software deployments, Web & Tech support to the SMU COX Patrons.
 Created Data Reports on Excel for Sales force Project for LYLE School, which was presented in the
Dept. for approval.

SEO Analyst
GenY Medium (P) Ltd, Hyderabad, India. July 2012 – Aug 2013
 Helped improve client's web page landing by using Search Engine Optimization tools
 Hands on experience on SEO Tools like Moz Pro, Woo rank, Google Webmaster tools, Google
Analytics, Google AdSense.
 Created email templates for client monthly subscription to help with email marketing.
 Supported the company’s social media marketing strategy by providing insights on daily activity on
their clients Facebook pages.
 Assist with the IT team to monitor web services and make them more efficient.
 Supported and maintained various reporting and analysis needs for performance-based businesses.

IT Developer/Analyst
Sci-Tech Patent Art Services (P) Ltd, Hyderabad, India. Oct 2011 – June 2012
 Designed & created web-based applications using PHP, JavaScript, HTML, and CSS with Oracle
database.
 Maintain existing code by solving bugs, building enhancements to company’s website based on the
written technical and functional requirements.
 Designed GUI screens using usability and design principles.
 Worked change requests (CRs) analysis and performed impact analysis of CRs.
 Created multiple websites by using SharePoint as requested by managers.
 Implemented Java server-side logic using Tomcat, Jboss, and WebLogic.
 Assisted in the deployment process of the applications on the server side.
 Developed, implemented, and troubleshot complex code in VBA Access to retrieve data from Oracle
and DB2 databases.
 Assisted in implementing underlying database object to support front-end & back-end applications.
 Analyzed data; validated data accuracy and presented data in a user-friendly format.
 Developed various types of SQL queries (union, update, append etc.) used by management to obtain
vital statistical information.
 Managing the help desk, troubleshooting PC and connectivity issues and software installation.
 Generated reports on excel about issues received at IT Helpdesk in order to help management
 Helped in reducing the number of helpdesk tickets by 40% by performing and documenting the
Root cause analysis.
 Coached/ mentored employees across teams and provided technical assistance as needed.
 Working knowledge of TCP/IP protocols, troubleshoot network related issues.
 Involved in the configuration of SSL to provide internet.

Manager
APBC Print Providers (P) Ltd., Hyderabad India. April 2010 – Sept 2011
 Coordinated 56 channel partners, largely print media houses on day-to-day basis.
 Lead the company’s credit management strategy to ensure effective cash flow from partner.
 Devised and executed the strategy to compete effectively against competitors with low cost print
solutions; helped improve annual sales by 20% for the company through this initiative”
 Carry out market research to explore new markets and product promotion.
 Analyze Reports on Inventory, Sales and accounts by using business software tools, Tally ERP.
 Generate regional market research reports on major Technova Brand products in the market.

TECHNICAL SKILLS:
Project Methodologies: Agile, Waterfall, Scrum, Lean, RAD, Six-Sigma.
Operating Systems: Windows 98/XP/7/8 , Mac OS X, UNIX, Linux.
Languages: SQL, T-SQL, UML, HTML, CSS, XML, JavaScript, jQuery, VB Script, XML, Shell Script,
Databases: MS SQL Server, Oracle 8i, MS Access SQL Profiler, SQL Server Management Studio
ETL and Reporting Tools: Crystal Reports, Excel, MS BI, SQL Server Integration Services (SSIS),
SQL Server Reporting Services (SSRS), Tableau, MS Excel.
Document Management: MS SharePoint 2007, 2010, 2013
Quality Assurance Tools: Selenium, QTP.
Performance/Server Monitoring Tools: AppDynamics, Solar winds, Manage Engine Op Manager.
Project Management Tools: MS Project, MS Visual Studio, JIRA, Wrike, Slack
Processes: ISO, Six Sigma, CMMI SIPOC Analysis, RACI,ROI Analysis,Gap Analysis, Use Case
Modelling & Analysis, Business Environment and Market Research Analysis
Other Tools: Microsoft Dynamics CRM 2011, 2013, 2015 and 2016.VB Script, Active Directory,
Exchange Server, SharePoint, Outlook Client, MS Visio, MS Office (Word, Excel, Access, PowerPoint)

ACADEMICS:
Bachelor of Technology in Information Technology JNT University, Hyderabad, India.