BHRIGU ANEJA

Cell: 510-***-**** Address: San Jose, CA 95110 E-Mail: aczx9i@r.postjobfree.com

Professional Summary:

Experienced in BI, Data Analysis with over six years of combined experience working in the career field of Data/ Statistical Analysis including Data Analytics, Business Analysis, and Database Design.

Extensive Reporting Analytics experiences for various clients in different domains.

Strong background in client interaction and working with end-users to Design, Analyze, and create customized reports using SAS, Microsoft Access, MS Excel, Tableau, Cognos and QlikView.

Strong background in organizational and time management skills, as well as demonstrating the ability to exercise discretion, tact, judgment, and diplomacy, and is also, is willing to accept and abide by corporate values, goals, and objectives.

Understanding in creating databases, users, tables, triggers, macros, views, stored procedures and functions, packages, joins and hash indexes in Teradata.

Experience working with testers and QA Engineers. Worked on QualityCenter, JIRA, IBM Clear Quest and Bugzilla.

Knowledge about automation testing using Selenium WebDriver/Grid and TestNG.

Familiarity with Big Data concepts including, Hadoop MapReduce, Hive, Pig and Spark.

Vast experience working as a data analyst understanding data structures.

Alteryx, Lithium, Google Cloud (Big Query), Amazon Web Services (AWS), Microsoft Azure and Google Analytics. Strong understanding of cloud concepts like public and private clouds, IaaS, SaaS, PaaS.

Incident ticketing experience for technical assistance solicitation.

Education:

Certification in Data Analysis, University of California, Santa Cruz December 2016

Masters in Information Technology, Panjab University May 2014

Bachelors in Information Technology, Sikkim Manipal University March 2012

Technical Skills:

Windows OS, Macintosh OS, Ubuntu, Linux

Advanced MS Office competency - Excel (functions like V, H lookup, pivot table, charting or graphing, among other visualizations), Word, PPT, Publisher, and Outlook Visio (Flow charts) and MS Projects Office 365

PL/SQL (Data extraction) basic query language including different joins

Programming in Perl and Shell Scipts, JavaScript, HTML, XML, MS Excel, R, SAS, Dot net, Visual Basics, Java and Python

Expertise in wrangling data using python (pandas, NumPy, SciPy), for SQL and NoSQL based databases.

Knowledge of inferential and descriptive statistics, statistical modeling and experimental design, A/B testing, machine learning concepts like supervised, unsupervised and reinforcement learning.

Data Visualization and Communication: Tableau, PowerBI, QlikView, R(ggplot), Python (matplotlib) and OBIEE

CRM tools: Salesforce Analytics, Reporting tools: Cognos and SAP Business Objects (Crystal Reports)

Proficiency in different Project Management and Business Analysis Methodologies (Waterfall and Agile Scrum)

Know-how of SAP Business Suite Applications

Financial Modelling using MS Excel and SPSS.

Professional Experience:

Second Harvest Food Bank of San Mateo and Santa Clara Counties July 2016 – Dec 2016

Data Analyst/Volunteer

Assisting the Development Operations manager in assessing, analyzing, documenting and revising reports.

Performing SQL queries in Microsoft Access and Excel.

Creating new Raiser’s Edge reports and Crystal Reports.

Reporting donations and using Excel dashboards and Power BI.

Environment: Excel, Microsoft Access, Crystal Reports, Raisers Edge, SQL Server 2012, Office 365, PL/SQL, Windows, Power BI

IBM India Pvt. Ltd, Gurgaon, India July 2014 – March 2015

Business/Data Analyst (Senior Practitioner)

Involved proactively with Business Intelligence (B.I) Dept. to collect, clean, develop / validate, implement, and report data gathered.

Assisted B.I team using pivot tables, PowerPivot, Vlookup and Hlookup.

Gathered and tracked data used for the financial analysis for Bank of America while maintaining flow and transformation.

Worked on Electronic Healthcare Record (EHR) system for an Oregon based health provider to manage big data in related to insurance, Medicare, Medicaid, diagnosis, and hospital admissions. Understanding Of CPT, ICD codes, EPIC and EHR systems, and various EDI transaction sets.

Acted as the liaison between business end users and technical teams (IVR Architecture/Development teams)

Worked with the IMAC (IT Infrastructure / Hardware Asset Management) team and general customer data (online) analysis related activities at GAP Inc.

Demonstrated leadership and ability to deliver results with minimal supervision

Created functional specifications and design requirements for integration of current Wholesale Management System with Dealer Loan System to meet business requirements.

Extracted and maintained data count using database tools including PL/SQL Developer and MS Excel

Wrote SQL queries and stored procedures, facilitated data normalization and creating joins.

Good knowledge of designing, deploying and operating highly available, scalable and fault tolerant systems using Amazon Web Services

Utilized web technology troubleshooting skills in HTTP, XML, FTP and SFTP.

Experience in writing and testing out both SOAP and REST services using SOAP UI, Postman and Rest Assured.

Calculated and developed risk models using R, SAS, Excel and SPSS.

Maintained data consistency by removing, filtering and sorting errors

Analyzing, messaging the data and extracting the data from different sources and designing the reports as needed by the stakeholders and also discuss about duplication, and trash data to understand the source and reduce the irrelevant data to be part of the reports that would impact the results or the quality of the reports.

Wrote adhoc queries for moving data from HDFS to HIVE to analyze data using HIVE QL.

Implemented solutions using a wide variety of server and client technologies including MS Excel, Microsoft Access, SQL Server (SSIS, SSRS, SSAS), SAP HANA.

Prepared daily and monthly management updates: collections productivity analysis, scheduling adherence reporting and operations matrix

Utilizing Excel, created a PivotTable report to analyze collection data OLAP

Environment: Toad, Cognos, JIRA, Business Objects (Crystal Reports), Office 365, MySQL, SAP ERP, SPSS, SQL Server 2012, MS Excel, Microsoft Access, PL/SQL, Oracle, OBIEE

Anandmay Engineers and Consultants Pvt. Ltd. Apr 2007 – May 2012

Reporting Data Analyst

Interpret and break down accumulated data in a straightforward and concise manner to facilitate efficient use for end users

Preparing weekly and monthly reports including profit and loss, open orders, sell-through, invoicing, booking, shipping, surplus availability, production, gross margin, cash forecast, warehouse valuation, etc.

Liaise with company executives and department managers to establish project requirements and collaborate with other members of the IT team to ensure users' needs are met promptly. Created BRDs and PRDs with the supervision of project manager, QA and systems analyst.

Frequently preparing ad-hoc reports using Microsoft Access and Excel

Providing efficient technical support during and after implementation for EDI configuration

Resolving EDI issues relating to requirements for processing of incoming and outgoing transactions

Ensuring successful integration and automated establishment/shipping of retail and wholesale Internet orders in the system

Utilizing effectively CRM systems like SAP CRM and Salesforce CRM, SRM systems like SAP Enterprise Buyer (SAP EBP) and SAP Supplier Self-Services (SAP SUS) and SAP ERP.

Designed Excel and Tableau dashboards for higher management reports, and other data visualization reports as per needs of the user to measure KPI.

Experience with SharePoint and Confluence to collaborate with other team members and clients.

Data Analysis using QlikView, Tableau software to analyze financial data

Reconciling accuracy of data in the system

Working on SQL queries in Microsoft Access based on management’s requirements/expectations and ensuring timely project delivery for small to medium database projects and assignments

Working with the business to do UAT. Acted as an SME and worked with the testing team.

Environment: Microsoft Excel and Access, Query Analyzer, SharePoint, Office 365, Tableau, MySQL, SQL Server 2005/2008, PL/SQL, Oracle, UNIX, Windows

Contact this candidate