NetSuite:- Deliver a custom journal approval workflow designed to allow delegations of approvals, resubmit a rejected journal with corrections- NetSuite implementations across both for-profit and non-profit clients - Order to cash process, Expense module, grant management, asset management, suite analytics, administration, etc.- Strongpoint implementation with audit controls and Change request maintenance- Integrate ServiceNow with Strongpoint and NetSuite- Create exemptions and update Change management policies to make the NetSuite environment SOX compliant- Update roles, permissions and user-access to remove violations based on Employee access- Designed and implemented custom reports in NetSuite to provide actionable insights and performance metrics to the business.- Created real-time dashboards to display key metrics and KPIs, providing quick and easy visualization of business data.- Customized reports and dashboards to meet the unique requirements of the business.EPM:- Gather requirements, discuss budget strategy and assist with configuration of NetSuite planning and budgeting tool for the various department heads to enter budgets and approve them on a monthly basis· Assist with month end close process automation in NetSuite and build consolidated ad-hoc reports to assist the Finace/Audit teams.· Configure NSPB Sync SuiteApp to maintain data integrity between NetSuite and NSPB through custom saved searchesBusiness Intelligence:- Leverage Business Intelligence tools to enhance the existing data framework of organizations with reporting and advanced data modeling- Tableau reports, server administration, Tableau prep/Alteryx workflows- Snowflake, Incorta cloud Data cloud migration - Analyzed data within reports and dashboards to identify trends, highlight areas for improvement, and make recommendations for action.- Shared reports and dashboards with relevant stakeholders within the business, including executives, managers, and department heads.

- Aid in automation of existing Business intelligence processes - Convert legacy reports in excel to Power BI reports for self-service analytics - Design efficient workflows to process blue tickets (emergency orders) and derive key metrics on goal objectives met.- Identify a way to track cost per leak repairs by merging financial and work order data

- Implement Row Level Security (RLS) in the existing Tableau architecture- Optimize existing dashboards to improve performance and reduce maintenance cycle- Gather requirements from stakeholders to create stories in JIRA that correspond to the data related set of tasks with story points in an Agile environment - Convert and update dashboards from OBIEE to Tableau self service analytical dashboards - Create Data flows using Tableau Prep/Alteryx and feed the Extract files into Tableau desktop- Design and implement an integrated data model for an enterprise application with more than 2000 users using Alteryx- Lead the effort in design of security model to enable security across application universe

- Implement NetSuite CRM modules for an Education based SaaS company in the DC area- NetSuite Administration - Define roles and permissions, publish dashboards, Monitor performance, Manage territories- Enable SuiteAnalytics - Build saved searches, ad-hoc reports, Workbooks to visualize NetSuite data- Build Consolidated Balance sheet, income statement and Cash flow reports for multi-level subsidiaries in Power BI using NetSuite ODBC- Export NetSuite data to BI tools like Tableau and Power BI to build additional executive dashboards- Build advanced html/PDF templates for transaction and other record types in NetSuite- Item Demand and Supply plans using native NetSuite- Suite Billing administration : creation of subscription plans, price books, enable billing features, configure accounting preferences

• Work with different stakeholders to get monthly ad hoc reports from Excel converted to fully functioning reports in Tableau and Business Objects.• Document requirements and maintain the project schedule for various analytic projects.• Present analytic findings and recommend solutions to clients using Tableau dashboards as the medium.• Develop tableau dashboards for a federal client in DC mainly assisting in the conversion of Spotfire reports to Tableau 10 dashboards.• Administrate the performance of old Tableau dashboards and improve performance through the usage of Custom SQL queries.• Blend and refine data for easier dashboard creation and maintenance.

•Designed, developed and delivered an SSRS report to capture the monthly goals of the operations team. This report had a user adoption rate of 95% and has become the most run report at AvalonBay just after a month of its release.•Develop Enterprise level dashboards for the Operations team using Business Intelligence tools like Dundas BI, Power BI and Tableau 10•Support the Enterprise Data-warehouse team in development, testing and deployment of dashboards from Dev and Test to Production environment.• Make recommendations based on insights and trends gained from analytical dashboards using various slicers.• Feasibility analysis of BI Tools - Tableau, Qlik Sense, Logi Analytics, Power BI, Dundas BI, Dundas Dashboard for Enterprise level dashboard development.• Lead the BI team in developing data driven subscriptions using Microsoft SSRS.• Use Power BI to develop self service analytic dashboards for Senior Executives to slice and dice data using various filters. • Blend data from various sources like Sales force, Excel files and SQL Server tables to create reports in Power BI and Tableau.• Author deployment and maintenance plans for the release of new dashboards into the production environment.

•Solicit requirements through weekly sprint planning sessions and design advanced Dashboards in Tableau 9.2• Revamp existing dashboards used in analyzing performance metrics of the youth enrolled at DYRS based on stakeholders requirements• Manage daily reports and identity the KPIs in improvising existing datasets• Collaborate with the client facing teams to analyze the data statistics on a weekly basis.• Reviewed existing datasets to identify for outliers, missing values and other data entry errors.Define specification, design and build of Tableau Desktop reports and dashboards • Installation, set up and administration of Tableau Server• Training designers, analysts and end uses in Tableau Desktop and Tableau Server software• Responsible for best practice implementation of Tableau workbooks for Tableau 9.0 migration• Created Drilldown, Drill through, parameterized and linked reports. Generated these reports on a daily and weekly basis as per the client requirements • Integrate data from various database sources like Access, Microsoft SQL Server, Excel and text files using Power Pivot feature of Excel.• Use Data Cubes to analyze data through excel by creating pivot charts and universal filters to incorporate OLAP operations like slice, dice, pivot and drill down.

• Developed dashboards in Tableau 9.1 for analyzing budget spent on TV ads for Political campaigns• Worked with Developers and Business Analysts in requirements gathering by attending sprint planning sessions and translating them to technical specifications. • Transform unstructured data in JSON format from tvarchive.org to structured data in CSV files using Java – Extract, Clean, Transform, Load (ETL) and load the data into Tableau Server for data and business analysis.• Developed a TV mentions Dashboard for tracking the number of TV mentions for each Presidential candidate on networks like CNN, Fox and MSNBC. Developed a program in java to retrieve the data from Tv-archive.org• Re-engineering optimal tableau dashboards against Amazon AWS infrastructure • Use SQL queries to create a view to join various tables in Microsoft SQL Server before incorporating into Tableau desktop.

• Explained the core essence of Microsoft Excel, Access, Visio, Word and HTML to a class of 45 students in an undergraduate course in the business school at GWU.• Assisted the Professor with lessons by conducting lab sessions and preparing handouts.• Evaluated homework, tests, and lab work and also hold office hours to ensure students understand course concepts along with their practical application.

• Graduate Assistant under Professor Christine Fruehwirth for the course - Career Management Strategy. • Advising Undergraduate Students on analyzing their Career Options through self assessments, Resume Correction and Cover letter Preparation. • Monitoring student Assignment submissions and Grading, Class Participation.

• Gathered requirements and prioritized them by conducting stakeholder interviews and surveys.• Remodeled complex medical data in MySQL tables to simple visualizations in Tableau 8.2 to help the sales team with refining their marketing approach.• Predict trends in Adwords through tableau dashboards via data from Google Analytics to estimate the daily budget to invest in Google Ads to promote the website, www.voyagermed.com on daily basis.• Authored Test Cases to help the QA commit the build after testing.• Collaborated with the developers to design a dynamic algorithm to retrieve the list of doctors on the website after a search is queried on the website. It was based on a variety of factors like Years of experience, College, location, average procedure cost, Hospitals affiliated of the Doctor.• Inspected the database to find outliers, missing values, typos and other data entry errors.

• Motivated and trained interns to learn python to develop scripts for effectively handling Comma Separated value (CSV) files. This aided in the development of cost effective company tools. • Analyzed a methodology called Credit Default Swap and prepared presentations for senior managers to understand several business aspects of it. This clarified certain doubts during Product development phase. • Designed and developed a tool in Java for automatic truncation of excessive decimals in CSV files consisting of millions of records. This tool reduced manual input by 50% thereby increasing productivity and saving time. • Emphasized on presenting reports in Tableau instead of plain excel analysis for client meetings. This stimulated the client's involvement in product development meetings. • Programmed using python a tool for comparing CSV files from test/production environment. This resulted in CSV files with thousands of records being compared in less than 2 seconds improving test automation by 80%.•Test Case Authoring and Regression maintenance for Web based, Desktop applications along with Database testing.

• Developed a Radio Frequency Identification Device (RFID) based student attendance system using Java Swing, Microsoft Access, RFID hardware driver, Netbeans 6.9.1 and was successfully able to integrate it into the college attendance system.• Experimented with mobile message notifications to notify parents about students having attendance less than the minimum acceptable percentage by integrating Mobile APIs into the existing system.• Gathered requirements and assigned work splitting into SDLC phases using JIRA as the tracking tool.• This project was awarded the best Software/Hardware integration work for the year 2013 and was patented by the college.

Accomplishments:• Developed a tool for automating manual process of Shipment Manifest Files.• Used Java, MS Access, JDBC-ODBC and NetBeans 6.8