SUMMARY:

• CRM Black belt certified (CRM Administration) and active CRM User Group member and Qlikview User Group Member
• BI Analyst and Data Analyst in client/server, web & database applications.
• Currently working as, a Business Intelligence Analyst on MS Dynamics CRM & Qlikview & responsible for Business/Data Analysis, Customizations, Requirements Gathering, & Application configuration & Project Delivery.
• Expertise in Qlikview Administration, User Support & Production Support, CRM Administration, Training End Users before and after Migration.
• Write Technical Documents and Training manuals and train the end Users.
• Build and deploy reports using Qlikview BI Tool and monitor Qlik Server.
• Knowledge of SAP tables and Transactions to extract Data into Excel.
• Knowledge of SQL Queries, DTS, Data Validations and Data Mapping.
• Worked on Data Analysis tools like SAP Cransoft, Grand Central, BST etc.

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. Microsoft Dynamics CRM, Salesforce, Microsoft Dynamics SL, Scribe,

Project Management:  MS Project, I Graphix, Visio 2000, and Sybase Power Designer 9 One Note, Field Connect, Field Access, MS Office 365, Dell Kace

Database:  MS Access, SQL 2008, Oracle, DB2, Grand Central, Armor, Salesforce, Erwin, Documentum, Model N, Remedy.

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

Operating Systems:  Windows 8/10.

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

PROFESSIONAL EXPERIENCE:

Confidential

BI Analyst/CRM Admin/Qlikview Admin

Responsibilities:

• Work on Microsoft Dynamics CRM 2013 Customizations and generate dashboards using CRM.
• Familiar using Social Media Marketing and very much excited & looking forward to see the Sales Productivity using CRM Social in CRM 2015 & 2016.
• Monitor the Server environment; Grant User access to different levels of Report users to Applications based on Security/Entitlements through CRM.
• Administer and Analyze Data in Salesforce to migrate to Microsoft CRM
• Continuously act as point of contact for the business users and train the end users before & after Migration from CRM 2011 to CRM 2013 and evaluating how the capabilities of CRM 2015 can be leveraged to drive business value .
• Maintain existing application systems and respond to problems (through Dell Kace - Case Management) to ensure the technology solutions remain effective & efficient in meeting business needs.
• Install, build, configure & customize applications in Qlikview version 10 & 11.
• Responsible for Emergency Break Fixes & Emergency Incidents on Servers.
• Administer Field Connect & help salesman setup & work on service contracts.
• Build companywide report applications in Qlikview, Configure & administer Qlikview Desktop, Qlikview Server, IIS Server & Qlikview publisher.
• Manage Qlikview Access point security, deploy reports and schedule QVW reloads on server and troubleshoot report errors and Task failures.

Confidential, NJ

Sr. Business Systems Analyst

• Work on Database updates, Org Loads, Load New Tests and New Admins in SQL Server Test, Development and Production Environments.
• Gather business requirements and Application Interface Specifications.
• Write FRD, BRD, and AI Specification Documents
• Analyze and document new & existing workflows/processes and procedures.
• Research and resolve the Production data issues and attend CAB Meetings and production support meetings with the business.
• Run and Analyze CRM reports on daily basis and work on Annual Changes on Admin Windows & Tests.
• Conduct business area analysis and document requirements regarding user community's business intelligence needs.
• Analyze database and Tables Structure and document Consolidation of Metadata from various sources into CRM. 
• Work with developers to translate requirements into technical specifications
• Function as a liaison between business users and technical staff.
• Work on AIDI Updates and Admin Windows and Test Changes.
• Gather and document business requirements and Edit Existing Functional Requirements Documents in Power Designer.
• Document the process of the Data updates in all the environments.

Confidential, PA 

Sr. Business Data Analyst

• Analyze Data for Transparency Data Operations Reporting team as per the regulations of Sunshine Act for the State and Federal Reporting.
• Document the process of Analysis for the Data Audits/Data Research Team.
• Check the Data Mappings in Production environment and Cognos DataMart Packages which is in line with the I Log Business Processing rules.
• Run queries using Oracle PL SQL Developer 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, NY

Sr. BI Analyst -Team Lead

• Development lead and Project Support for the companywide Reporting applications using Qlikview.
• Continuously act as point of contact for the business users and ensure adequate collaboration throughout all projects.
• Maintain existing application systems and respond to problems to ensure the technology solutions remain effective & efficient in meeting business needs.
• Install, build, configure & customize applications in Qlikview v9, 10 & 11.
• Grant User access to different levels of Report users to Applications based on Security/Entitlements through Remedy Process.
• Responsible for Change Management Processes, raising CMs /Ops/ Emergency Break Fixes, Emergency Incidents on Servers through Remedy.
• Generate reports using QlikView, configure & administer Qlikview Desktop, Qlikview Server, IIS Server, publisher & Qlikview Management Console.
• Administer TFS 2015 to automate the software delivery process, so the team to track actions, transaction and project info like requirements, tasks, bugs, source code and build and test results.
• Experience in managing Access point security, deploy reports and schedule QVW reloads on server and troubleshooting errors and failures
• Monitor the Server environment; actively participate in Testing and code reviews, Training End users, Demos and Presentation of the Reports.
• Investigate helpdesk incidents & resolve recovery actions for assigned incidents using Remedy Tickets and Change Management system.
• Act as prime support for Production issues and resolve, document and communicate the same with Business users.
• Communicate and consult with the business users and other application development staff and IT staff in providing bug fixes and enhancements to existing application solutions.  

Confidential, Warren, NJ

Business Data Analyst

• Analyze Data for Expense Management Reporting Applications.
• Design, develop and implement technical solutions for customers from the stage of POC to introducing new solutions through business processes.
• Gather requirements & Generate QlikView reports to analyze data from multiple data sources like Oracle, SQL, Access, Excel, SharePoint, etc.,
• Develop, test, and implement new dashboard reports and modify, test and implement existing reports based on multiple data sources.
• Upload/deploy Qlikview Applications on the Server (Version 9 & 10).
• Develop PTS-W Timesheet Applications in Qlikview (Version 10).
• Build GFTS IT Risk & Control Financial Review Reports in Qlikview.
• Generate reports to track GFTS Expenses, to check Budgets and Forecasts
• Knowledge of 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 files to appropriate user groups, etc.

Confidential, Philadelphia, PA

Business Analyst/Data Analyst

• Knowledge of UI design with QlikView to develop easy to use applications & create expressions using Qlikview sheet objects, functions & Set Analysis.
• Gather data with various tools like Access, Excel, templates, Online Surveys, meetings, Phone interviews etc., to build Portfolio Databases.
• Review QlikView error logs and provide daily production support.
• Write SQL queries and DTS Packages to analyze, cleanse and migrate Customer Profile data from Excel to SQL Server DB.
• Check the Databases and remove the Lincoln Financials data from Delaware Investments which is to be migrated to Macquarie Systems.
• Identify the reports that belong to Delaware Investments and Check-in into Optec System, a repository to store Reports in the form of Optical Images.
• Resolve Data issues, incomplete data, errors and duplicates.

Confidential, PA

Business Analyst/Data Analyst

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