SUMMARY

• CRM Black belt certified (CRM Administration) and active CRM User Group member and Qlikview User Group Member.
• Business Analyst/ BI Analyst in client/server, web & database applications.
• Application support, Data Analysis, Customizations, Requirements Gathering, & Application configuration & Project Delivery.
• Expertise in Qlikview and CRM Administration, Production Support, Write Technical Documents & Training manuals to train the end users.
• Build/Deploy reports in PowerBI, Qlikview BI Tool, monitor Qlikview Server environment, & administer user’s access.
• Knowledge of SQL Queries, DTS, SAP tables and Transactions to extract Data into Excel.
• Data Analysis, Validation and Mapping with 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, Sales force, Microsoft Dynamics SL, Scribe

Project Management: MS Project, I Graphix, Visio 2000, Sybase Power Designer, Agile,OneNote, Field Connect, Field Access, MS Office 365, Dell Kace

Database: MS Access, SQL 2008, Oracle, DB2, Grand Central, Armor, Sales force, Erwin, Documentum, Model N, Siebel, Remedy, PowerBI

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, PA

CRM Administrator

Responsibilities:

• Build and publish and maintain Monthly, KPI and company wide reports Using PowerBI.
• Responsible for CRM system administration, data management, and the development and maintenance of business solutions related to Turn - Key Health’s Microsoft 365 solutions including CRM.
• Interact with members of the Turn-Key Health leadership team and network customers and also serves as the liaison between our external vendors and internal departments.
• Manage Microsoft Dynamics CRM application and related Microsoft solutions.
• Customize and maintain our Microsoft Dynamics CRM platform, including user setup and maintenance, role hierarchy, profiles & permissions, security, page layouts, objects, fields, workflows and data management and data linkages to other source systems.
• Perform imports and exports of data from the application as requested.
• Assist with the development of training materials and user documentation.
• Support users by troubleshooting and resolving issues related to reports, dashboards, Views, access/visibility, system errors, feature requests data quality and other general questions related to the system.
• Monitor system usage & acceptance & create business solutions on identified user needs.
• Translate business needs into technical requirements for system enhancements through user feedback and observations.
• Collaborate to develop improved operational efficiencies and analytics.
• Develop and generate reporting and analytics for internal and external use.
• Identify and understand customer business situations and needs and effectively/precisely and address those needs.
• Able to roadmap Microsoft Dynamics projects and plan for complex situations, additions and issues that may arise.
• Manage relationships with outside service providers and vendors.
• Data management - Experience extracting, transforming, and loading large volumes of data in CRM.
• Ability to work autonomously and in teams in a rapidly changing environment
• Strong interpersonal skills, with focus on attentive customer service, exercising good judgment.

Confidential, PA

BI Analyst

Responsibilities:

• Conduct business area meetings, analyze and document the requirements regarding user community's business intelligence needs.
• Administer and Analyze Data in Sales force to migrate to Microsoft Dynamics CRM and analyze Data Mappings for the same.
• Work with salesman on bidding projects & setup processes for the same in CRM
• Continuously act as point of contact for the Customer service/Help Desk/Production Support needs and train the end users before & after Migration and evaluate how the capabilities of CRM can be leveraged to drive business value.
• Work on CRM Customizations and generate dashboards using CRM.
• Train and motivate the users to use the Social Media Sales and Marketing and very much excited & looking forward to see the Sales Productivity using CRM Social.
• Monitor the 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 - Case Management) to ensure the technology solutions remain effective & efficient in meeting Customer Service needs.
• Administer Field Connect & help salesman setup & work on scheduled service contracts in Microsoft Dynamics SL and CRM.
• Work with Developers to build, Publish and Monitor companywide Qlikview reporting

Confidential, Princeton, NJ

Business Systems Analyst

Responsibilities:

• Gather and Document business requirementsand Application Interface Specifications.
• Analyze and document new & existing workflows/processes of the Data updates in test and production environments.
• 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 into technical specifications, write Test Cases and support users through UAT.

Confidential, PA

Business Analyst

Responsibilities:

• Check the Data Mappings in Production environment & Cognos Data Mart Packages which is in line with the I Log Business Process rules.
• Document requirements gathering process 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.
• Work with Audits team on the accuracyof CMS Reports to be posted on web as per the guidelines of the Physician Payment Sunshine Act.

Confidential, Jersey City, NJ

Qlikview Developer/BI Analyst

Responsibilities:

• Development lead and Project Support for the companywide Reporting applications.
• Continuously act as point of contact for the business users and Qlikview Applications.
• Maintain existing application systems & respond to problems to ensure technology solutions remain effective & efficient for business needs.
• Install, build, configure & customize applications in Qlikview.
• Grant User access to different levels of Report users to Applications based on Security/Entitlements through Process Management in Remedy
• Responsible for Change Management Processes, raising CMs /Ops/ Emergency Break Fixes, Emergency Incidents on Servers in Remedy.
• Generate reports using QlikView, configure & administer Qlikview Desktop, Qlikview Server, IIS Server, publisher & QMC.
• Administer TFS 2015 to automate the software delivery process, so the team tracks the actions, transactions, requirements, tasks, bugs, source code and build and test and document the results.
• Experience in managing Access point security, deploy reports and schedule QVW reloads on server and troubleshooting 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 & setup & monitor incidents via Change Management system.
• Support Production issues, resolve, document & communicate the same with Business.
• Communicate and consult with the business users and other application development staff and IT staff in providing bug fixes and enhancements to the existing application solutions.

Confidential, Warren, NJ

Business Analyst

Responsibilities:

• Analyze Data for Expense Management Reporting Applications.
• Design, develop and implement technical solutions for customers from the stage of POC to introducing new solutions with 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, 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 the files to appropriate user groups, etc.

Confidential, PA

Business Analyst

Responsibilities:

• 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 & DTS Packages to analyze, cleanse & 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 reports that belong to Delaware Investments & Check-in into Optec System, a repository to store Reports in Optical Image form.
• Resolve Data issues, incomplete data, errors and duplicates.

Confidential, OH

Business Analyst/Lead Data Quality Analyst

Responsibilities:

• Help remove duplicates, address incomplete data and missing fields to data owners 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 to remove errors and duplicates.
• Analyze Data via reports based on SAP Control Sheets and previous BRDs and document the findings.
• Generate error reports and escalate errors to the team members of SAP Customer Team.

Confidential, NY

Business Analyst

Responsibilities:

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

Confidential, PA

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 Material Master Data Reporting Team.
• Check and import SAP Material 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.

Confidential, PA

Business Analyst/Data Analyst

Responsibilities:

• 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 for SAP Data Quality Team
• 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. & transfer to SQL Server by DTS.

Confidential, Princeton, NJ

Business Analyst/Data Analyst

Responsibilities:

• Extract and Analyze Customer Historical Data, Customer Orders, Products, Price History from SAP, Model N (Contract Management & Compliance) and document the process.
• Gather Requirements and write business requirement documents.
• Provide management with required reporting and analysis as needed.
• Check data mapping 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.