Nitesh Majji

*** ********* **, **** *******, NJ 08520 669-***-**** ac4cr8@r.postjobfree.com

Nitesh Majji LinkedIn

SUMMARY

Interested in challenging opportunities.

3+ years of experience in various domains.

Experienced in Business Intelligence reporting and Data analytics. Worked on relational databases and big data.

Experienced working with huge datasets, Data Quality Management, Data Warehousing and using ETL tools and SSRS, SSIS, SSAS, Power BI.

Observed trends and patterns to derive actionable insights from large data sets. Automated the healthcare reporting and visualization.

Worked in Facebook on Ad Insights, Page Insights, Reach & Frequency, Audience Insights and Mobile feeds ads. Reporting on sales performance. Modelling bug reports and creating KPIs on customer insights.

Strong ability to debug customer problems and analyze large data sets and taking decisions driven by data using Tableau, Power BI, R, SQL, macros, pivot tables, excel and access.

Experience with Data Science & Machine learning statistical modelling techniques methodologies such as regression, clustering prediction, and exploratory data analysis. Hands-on experience on using Google analytics.

Assisted Product Managers to create Work Breakdown Structures (WBS), A/B Testing, Project timelines.

Good at gathering requirements, modelling and debugging. Strong analytical and problem-solving skills to translate business requirements into working solutions.

Configured and structured sales processes, payments, Ad hoc reporting and Quote to cash process through Steel Brick app on Salesforce.

Excellent in preparing UML diagrams - Use cases, Activity diagrams, Sequence diagrams, Data Flow diagram and Process Flow diagram using modeling tools.

Passionate about data science, marketing, sales process, gap analysis, user stories and feedback.

EDUCATION

Master of Science in Engineering Management

Jan 2014-Dec 2015

San Jose State University

Bachelors of Technology in Electronics & Telecommunication

July 2009-May 2013

National Institute of Technology Raipur, India

Skills:

Software Skills: C, R: dplyr,ggplot, Python: Numpy, pandas, VBA, SAS

Databases: MySQL, MS SQL, Mongo DB, IBM DB2, Azure SQL

Methodology: AGILE, SCRUM

Management Skills: Lean, Six Sigma, DMAIC, DICE, PFEP, FMEA.

Creative Skills: Adobe Photoshop, Final Cut, InDesign, Adobe Premiere Pro, After Effects.

Tools: PowerBI, Tableau, Sisense, SSRS, SSIS, SSAS, MS visual studio, Google analytics, Ad words, Facebook Analytics, Marketo, Microsoft Visio, Microsoft Office, Advance Excel, Access, Power point, Access, Facebook products and tools, Salesforce modules, Jira, Outlook, IOS, Android, Mac OS 10, Windows 7.

Certifications:

Six Sigma Green Belt (Lean, Six Sigma, DMAIC)

PROFESSIONAL EXPERI ENCE

Business Intelligence Specialist at Pension Pro,

Harrisburg, PA June 2017 – Present

Ran complex ad hoc reports on schedule and provides data analysis prior to delivery to senior leadership. Designed reports for TPA clients from plan sponsor needs to distributions.

Created views, Stored procedures, indexes and tables. Query tuning and database maintenance.

Structured Embedded Power BI reporting in a multi-tenant environment and configured security.

Maintained databases, ensures integrity of data, and remains current on applicable business functions and technology tools like Power BI, Sisense, Tableau, SSRS.

Evaluate existing BI applications/environments and perform appropriate troubleshooting as necessary. Assisted in configuring Azure SQL data warehouse.

Data modelling on relational databases and data warehousing. Creating effective data cubes in elastic cube manager and maintaining the multitenant security duties.

Integrated data from different data sources like Mongo DB, SQL server in SSIS. Aid in developing data roadmaps for new product launches and evolving business needs.

Expert on SQL Server scripting, performance tuning and Data warehousing techniques.

Analyzed data to help us build more robust Customer Segmentation and created Customer Engagement reporting and modeling using elastic cube designs.

Strategic Data Analyst at Santa Cruz Community Health Center,

Santa Cruz, CA Sept 2016 – April 2017

Created reports using various tools R/Python scripting, Tableau and SQL to extract data from existing databases in support of strategic goals and Performance Improvement and monitoring.

Automated reports using R scripts for building predictive models. Provided data and reporting support and assistance across all facilities and departments. Solving analytical problems using predictive modelling and clustering.

Data validation, database maintenance and reviewing data sets to identify gaps in performance.

Strong experience in ETL, SSRS Reporting services and BI tools. Optimizing reporting process and integrations.

Maintained work plan of reports to run daily, weekly, monthly, quarterly, or yearly.

Documented methodology to allow for better understanding and modification of R code repositories in GIT hub.

Supported doing grant reporting by developing quality financial and clinical data reports using Data Science and machine learning.

Collaborated with stakeholders on data validity and generating insights from raw data.

Identified and researches viable methods of collecting data to support performance improvement, grant development, and fiscal reporting that align with identified needs. Produces or trains staff in developing these reports (informatics).

Product Analyst at Facebook

Menlo Park, CA Jan 2016- June 2016

Improved search quality, investigate and rate search results. A/B testing and identifying trends in raw customer data.

Execute SEO & SEM performance reports and incident analysis of customer issues. Created insightful automated dashboards and data visualizations to track key business metrics.

Worked on cross-functional initiatives and other Facebook products and internal business applications. Worked on third party tracking tools- Google analytics, Omniture, Web trends.

Created productivity, sales and operational reports and dashboards on Tableau.

Performed analyses on sales data sets to extract actionable insights that will help drive decisions across the company using excel macros, SQL.

Documenting and ad hoc reporting requirements, test scripts, user stories, user guides and findings based on your research.

Followed high-level instructions to provide support and develop knowledge within a product group. Investigated the advertising bugs triage process.

Developed deep knowledge and specialize in Facebook advertising product support groups.

Head of Products like Insights (Ads, Audience & Pages), Ad creative, Content and rendering.

Business Analyst at Wilco Source

San Jose, CA July 2015- Dec 2015

Gathered business requirements from customers and analyzed the data.

Worked on Salesforce CRM, CPQ & Marketing tools like Steel Brick, Marketo. Configuration of Products, Sales Processes, Approval process, Quote to cash process and testing the data.

Writing SQL queries to pull the data and managing large data sets.

Writing complex joins, case statements, query optimization and data visualization.

SDLC, Salesforce reporting, Workflow analysis and Impact analysis.

Maintain, troubleshoot data issues in tableau reports and dashboards.

Helped with critical data cleanup items such as data consolidation and removal of the Expandable managed package. Revenue planning and forecasting using charts, pivot tables, macros, VLOOKUP’s.

Documented use cases, test scenarios, Process diagrams & test scripts.

Played lead role in UAT’s and in deployment and gave sales support after the implementation.

Cognizant Technology Solutions as Programmer Analyst

Chennai, India July 2013-Dec 2013

Worked for Lloyd’s Bank Group. Solved business problems.

Managed metadata and data mining using ETL, SQL. Worked in Agile and Scrum environment. Helped in data extraction and debugging.

Allocated work to others documentation and scheduled meetings.

Contact this candidate