SUMMARY

• Business Analyst/Data Analyst in client/server, web and database applications.
• Support implementations, software upgrades, configuration, change management, content management, production support in Healthcare and financial domains.
• Participate in design reviews, security, Interface, user acceptance testing (UAT), end user training, for multiple applications on varying platforms.
• Write/Execute test plans/test scripts, SQL queries, requirements mappings, Training manuals, validate Data and resolve defects in Agile environment.
• CRM black belt certified (CRM Administration) and active CRM user group member and Qlikview User Group Member and good experience with Onshore/Offshore model.
• Knowledge in Qlikview administration, user access and monitor Qlikview Server environment, user support and training end users before and after Migration
• Build and deploy reports using Qlikview BI tool, Application support, Data Analysis, customizations and project delivery.
• Ability to manage multiple projects independently and as part of a team while interacting with all levels of staff in compliance and validation environment with 21 CFR Part 11 guidelines and agile requirements.
• Build and deploy reports using Qlikview BI tool and provide production support.
• Gather and document requirements, training manuals, enhancements, business process improvements, and training the end users.

TECHNICAL SKILLS

Web Development: .NET, ASP, VBScript, Visual Interdev, VBA, JavaScript, Bobby, Dream weaver, Visual Studio, VSS, Documentum, Optec, Clear case, Speaker Forum, Sunshine, I Log. Confidential Dynamics CRM, Salesforce, Confidential Dynamics SL, Scribe

Project Management: MS Project, IGraphix, Visio 2000, Sybase Power Designer, Agile, HPQC ALM, OneNote, Field Connect, Field Access, MS Office 365, Dell Kace

Database: MS Access, SQL 2008, Confidential, DB2, Grand Central, Armor, Sales force, Erwin, Documentum, Model N, Siebel, Remedy, Power BI

Reporting: MS Dynamics SL, Excel, Access, Crystal Reports, Qlikview

Operating Systems/ Servers: Windows 2008/2012, IIS, & BST Server, Grand Central.

PROFESSIONAL EXPERIENCE

Data Product Owner

Confidential

Responsibilities:

• Accountable for Product Data road Map and develop user stories with the help of the team.
• Write test plans and acceptance criteria for stories for Migration of Data from Siebel to CRM and run stories grooming sessions through daily meetings.
• Conduct business partner meetings and serve as the bridge between business and technology teams to ensure business needs are met.
• Gather and document Data requirements from internal and external vendors and Maintain traceability matrix to track requirements
• Analyze ETL processes, Data elements and mappings, translate technical changes to business value and facilitate communication with various stakeholders
• Conduct end user training, end - to-end impact analysis, design reviews, test case reviews, to ensure that the business vision, goals and requirements are met
• Able to administer CRM and make basic form field changes, advance find views, and pick list and Reporting and UI changes within the system.
• Experience leading people & managing vendors/contractors & Offshore Developers and Testers.
• Create, review, and update financial and Operational dashboards in CRM & Visio flow diagrams

Sr. Business Analyst

Confidential

Responsibilities:

• Gather and document business requirements, work with business to design and develop test scenarios, test plans/ test scripts and dataflow diagrams/process flowcharts using Visio.
• Act as srum master when needed and conduct team collab data meetings in JIRA and Agile environments
• Collaborate with architecture and execution teams to comeup with features
• Extract Data from Siebel, work on mappings comparing against source and target data tables/fields - ETL
• Conduct Daily Scrum meetings and Team meetings to track progress in agile environment.
• Monitor Prod Support, Administer tickets & SSL Certs in Service Now for Change Management Activities in agile environment.
• Generate reports using Qlikview and analyze Data for internal use and train report end users.
• Gather server data and SSL Certs info and feed into Service Now and follow up on validations and installations.
• Document project requirements, Servers details, elevation tasks and Data migration tasks.
• Document and track progress of the findings of UAT test scenarios and help resolve the Prod Support issues using Jira tickets.
• Work with Onshore/Offshore Developers in Agile environment and perform user acceptance testing at every iteration as it develops through the lifecycle.

Confidential

Business Analyst

Responsibilities:

• Customize, Monitor and administer CRM system, including user setup, system usage,
• Maintenance, role hierarchy, security, page layouts, objects, fields, workflows/Process and data management of other source systems and Project Documentations and User training materials.
• Build, publish and maintain Monthly, KPI and company wide reports with CRM and Power BI ( Confidential Office 365 Integration).
• Integrate CRM Confidential tracking Application with the enterprise EMR tool and the website through real-time HL7 and HIPAA Compliant data exchanges.
• Interact with members of the Turn-Key Health Master Data management and operations team and network customers and serve as the liaison between the internal teams & external vendors.
• Analyze Sales and Marketing Data in Sales force and generate reports on the same.
• Analyze and publish Content to check FDA published final regulations implementing the PDMA (21 CFR Part 203) and 21 CFR Part 11 and Co-ordinate meetings between Onshore/Offshore Developers and Business and Technology Team.
• Write and store the documents in SharePoint to streamline the management and Data access.
• Perform UAT, Data imports, Validation and exports of data to target database as required.
• Write/Administer Documentation of negotiating contract and vendor agreements.
• Support users by training, troubleshooting and resolving issues related to reports, dashboards, Views, access/visibility, system errors, feature requests, data quality and other general questions.
• System enhancements from user feedback and observations to improve operational efficiencies.
• Identify and understand customer business needs and address the same effectively.
• Work autonomously and in teams to manage relationships with service providers.

Confidential

CRM Business Analyst

Responsibilities:

• Project: Re-architecture of Siebel Service Desk (NYC311) for the City of New York, using MS Dynamics 365.
• Gather Requirements from Various Vendors and New York City Departments and Write User Stories/Test Scripts for the project.
• Work on Customization and configuration of Unified Service Desk Application.
• Meet with Business Users to understand their needs and provide solutions accordingly.
• Configure/Automate Service Level Agreements (SLA) in CRM and track the SLAs in reporting to make sure the Service Requests and Incidents are managed as per the timelines.
• Generate reports in CRM Advance find for the management and users for Data Analysis
• Write Test cases and perform User Acceptance Testing to ensure the development work and Conduct meetings with offshore developers with agile approach to provide flexibility to accommodate the requirements and priorities of the business.
• Administer TFS 2015 to automate the requirements, so the team tracks the actions, transactions, tasks, bugs, source code and build, test and document the results.

Confidential

Business Analyst

Responsibilities:

• Train and motivate the Salesmen to use the Social Media like LinkedIn, Twitter, CRM Social, through CRM Sales and Marketing application to increase the Sales Productivity
• Link Office 365 - OneNote files with Dynamics CRM records which include everything from text notes the users have on a sales lead to voice memos or pictures they have for an open opportunity.
• Build/administer Email templates for campaigns and marketing Events management.
• Administer the Confidential Office 365 portal which provides a single sign-on experience for Dynamics 365 Customer Engagement (on-premises) Integration
• Conduct business area meetings; analyze user needs, work on CRM Customizations and reports.
• Create HTML Email templates and configure emails with Mail Chimp for email marketing.
• Administer and Analyze Order to Cash Data in Sales force and Invoicing Data in MS Dynamics Solomon to migrate to Confidential Dynamics CRM and analyze Data Mappings for the same.
• Work with salesmen on bidding the Service projects & setup ETL process/Workflows for the same in CRM and Coordinate the work with offshore team.
• Continuously act as point of contact for the Customer service/Help Desk/Production Support needs, Perform UAT and train the end users before & after Migration and evaluate and explain how the capabilities of CRM can be leveraged to drive business value.
• Monitor the Qlikview Server environment; Grant User access to different levels of Report users to Applications based on Security/Entitlements in CRM
• Maintain existing application systems and respond to problems through Dell Kace - Change Management tool to ensure that technology solutions remain effective and efficient in meeting Customer Service needs.
• Administer Field Connect and help salesmen setup and work on scheduled service contracts in Confidential Dynamics Solomon and CRM.
• Verify that all product and eligible Service accounts comply with contract requirements.

Confidential

Business Systems Analyst

Responsibilities:

• Gather and Document business requirements and Application Interface Specifications.
• Analyze and document new & existing workflows/processes of the Data updates in test and production environments and support users through UAT.
• Research and resolve the Production data issues and attend CAB Change Management & production support meetings with the business.
• Run and Analyze reports on daily basis and work on Annual Changes on Admin Windows.
• Analyze database tables & document Consolidation of Metadata from various sources.
• Work with developers to translate requirements, write Test Cases and Project Flow Diagrams.

Confidential

Business Analyst

Responsibilities:

• Gather and document requirements for the Data Audits/Data Research Team using the Speaker Forum, related to the Speaker Events to adhere to the National and State reporting requirements and Use of Electronic Records and Electronic Signatures in Clinical Investigations Under 21 CFR Part 203 and 21 CFR Part 11.
• Analyze Data for Transparency Data Operations Reporting team as per the regulations of Sunshine Act for the State and Federal Reporting.
• Work on Data Mappings in Production environment and Cognos DataMart Packages which is in line with the I Log Business Processing rules.
• Run SQL queries on the Global Spend Data to recognize and disclose reportable interactions with US HCPs and HCOs.
• Check and co-ordinate with the signed and completed Quarterly Attestation documents sent from the Source Senior leaders are complete and accurate.
• Provide the reporting capability using Qlikview to be compliant to state and federal Sunshine regulations for payment /samples disclosures, and provide the functionality to adhere to the PDMA regulations accountability.
• Research data on the Spend Grid using the Speaker Forum, related to the Speaker Events to adhere to the National and State reporting requirements.
• Work with Audits team on the accuracy of the CMS Reports to be posted on web as per the guidelines of the Physician Payment Sunshine Act.

Confidential

Qlikview Developer/BI Analyst

Responsibilities:

• Development lead and Project Support for the companywide Qlikview Reporting applications.
• Grant User access to different levels of Report users to Applications based on Security/Entitlements through Process Management in Remedy.
• Responsible for Change Management, ETL Processes, raising CMs /Ops/ Emergency Break Fixes, Emergency Incidents on Servers in Remedy.
• Generate reports, configure & administer Qlik Desktop, Qlik Server, IIS Server, publisher & QMC.
• Manage Access point security, deploy reports and schedule QVW reloads on server.
• Perform UAT, Mentor Junior developers and Co-ordinate Testing activities with Onshore/Offshore Developers and troubleshoot errors & failures
• Monitor the Server environment; actively participate in Testing and code reviews, Training End users, Demos & Presentation of the Reports.
• Investigate & resolve recovery actions for assigned helpdesk tickets in Remedy, Support
• Production issues, and document and communicate the same with Business users.

Confidential, Warren

Business Analyst

Responsibilities:

• Analyze Data in Qlikview for Expense Management Reporting Applications.
• Gather requirements & Generate QlikView reports to analyze data from multiple data sources like Confidential, SQL, Access, Excel, SharePoint, etc.,
• Develop, test, and implement new reports and, test and modify the existing ones as needed.
• Deploy Qlikview Apps on the Server (Version 9 & 10) and Develop PTS-W Timesheet Applications and GFTS IT Risk & Control Financial Review Reports to track Expenses, Budgets and Forecasts
• Qlikview Security/Administration; Add/Delete Users, create folder hierarchy, assign users to folders specific to projects, Administer and monitor QV server using QMC, Move Apps/Qvw files manually to publish (Access point), and Distribute Qvw the files to appropriate user groups, etc.

Confidential

Business Analyst

Responsibilities:

• Gather data with various tools like Access, Excel, Email templates fort campaigns, Online Surveys, meetings, Phone interviews etc., to build Portfolio Databases.
• Review Qlikview Reports error logs and provide daily production support.
• Write SQL queries & DTS Packages to analyze Data issues, incomplete data, errors and duplicates and document the findings.
• Cleanse & migrate Customer Profile data from Excel to SQL Server DB.
• Query the Databases and identify the Lincoln Financials data from Delaware Investments which is to be migrated to Macquarie Systems.
• Identify reports that belong to Delaware Investments & Check-in into Optec System, a repository to store Reports in Optical Image form.

SAP Data Quality Analyst

Responsibilities:

• Work with Data product owners to remove duplicates, address incomplete data and missing fields to ensure Data Quality for data Migration.
• Create several Views and Queries in SQL Server and register them in SAP Cransoft and work with Data architects in MDM team to remove errors & duplicates.
• Analyze and modify existing rules and reports based on SAP Control Sheets and previous BRDs and document the findings.
• Generate error reports and escalate errors to Master Data Management Team.

Business Analyst

Responsibilities:

• Write Technical Design documents for Data Quality testing & reporting for Data Operations Team
• Work with the BI analysts and analyze the web clickstream and statistical data as well as tele Marketing data for campaign effectiveness reporting.
• Liaison between the business side and Database team during data uploads and driving it through the development stage and Write Traceability Matrix to ensure requirements through each stage of the requirements gathering process for BI Data Reporting team.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Generate, test and modify SAP Information Reports and error Reports.
• Gather requirements and document data elements and data definitions spread across the network for SAP Customer Master Data Reporting Team.
• Check and import SAP Customer Master Data and Pricing Data into Excel and then to Data Staging Warehouse (DSW) by SQL DTS Packages.
• Create several Views and Queries in SQL Server and register them in SAP Back Office Cranberry for Data analysis and pperform extensive UAT testing to validate business and system functionality.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Document & validate Global Data Definitions using existing documents for MDM.
• Gather requirements from various Data providers in different countries and ensure data is delivered in required format, at scheduled time for Customer Master Data Management Team
• Help extract data from the source system into BW system by BDC scripts.
• Download Customer Data from SAP into Excel/Flat files using different SAP transactions like SE16, SE30, etc. & transfer to SQL Server by DTS.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Extract and Analyze Customer Master Data (wholesalers, GPOs, IDNs, Specialty wholesalers and distributors), Customer Orders, Products, Pricing History, Contracts, Rebates, Special Offers and Terms and Conditions in Model N (Contract Management & Compliance) in HP ALM.
• Manage all aspects of contracts including analyzing terms and conditions to appropriately set up contracts, contract amendments and contract discount structures.
• Gather Requirements, conduct meetings and write business requirements documents.
• Involve in UAT Testing and provide management with required reporting and analysis as needed.
• Present, develop, and manage clinical change management program Documents
• Write scripts, Check data mappings and modify existing DTS Packages in SAP Cransoft.
• Write SQL procedures operating on the BOA Data Stage Warehouse to extract transform or export data between the source and target systems/data sets.

Confidential

Business Analyst

Responsibilities:

• Work with data architects to migrate data from Excel forms & Application and Business.
• Compliance Questionnaires to SQL Server database for Citi - CIG Information Security.
• Analyze Data with SQL Queries and Check Source/Target Data Mappings.
• Automate Data access with Excel VBA and Java Scripts in Citi Grand Central Database.
• Write SQL queries to consolidate the data spread across the networks into Data Dictionaries, and Gather, Analyze & Document requirements of the Data feeds from various sources.
• Build Databases & Process Reengineer with Erwin, draw flow charts in Visio.
• Create tables, views, and list boxes so users can view and customize ad-hoc reports in SOLAR and support Crystal Reports user-training sessions.

Business Analyst/Report Analyst

Responsibilities:

• Convert Accounting/Tax reports from BST Enterprise to Crystal Reports.
• Develop, maintain and support companywide Visual Basic and ASP-based intranet applications.
• Import data dumped from the Mainframe COBOL VAX System to Excel and then Export to SQL Server by DTS and ActiveX scripts and write training manuals to train the end users of reports.