Senior Data Analyst with 7 years experience available. Open to relocate.
PROFESIONAL SUMMARY:
· Over 7+ years of experience as a Data Analyst in Banking, and financial organizations with proficiency in Business Requirement Gathering, Business Process Flow, Quality assurance, Data analysis, Data modeling, and Business Intelligence (BI) reporting.
· Strong knowledge of SDLC methodologies like Agile/Scrum and Waterfall.
· Experience creating tables, queries, reports with Microsoft Access, Tableau SQL,
Crystal Reports as data analytics or troubleshooting tools
· Hands-on experience in Data Visualization tools Crystal Reports and Tableau.
· Experience creating complex Reports & Dashboards (KPIs) for Business Leaders, Dynamic Dashboards for Sales users, and Service users.
· Proficient using Import wizard and Data Loader.
· Experience developing Datasets, Lenses and Dashboards in Einstein Analytics.
· Perform daily, weekly, and monthly analysis – publish / present findings, maintain dashboards and identify deficiencies and potential areas for improvement.
Technical skills:
Relational Database
MySQL 5.5, MS SQL Server 2008/2012, MS Access
Cloud Technologies
Microsoft Azure, S3
Data Visualization
Tableau, Tableau CRM, Power BI, SQL Server Reporting Services (SSRS), Excel Reports
Operating System
Windows, Linux, Mac OS
Professional Experience:
Data Analyst
Forefront Corp – Fair Haven, NJ April 2021 – Till now
- Experience creating complex Reports & Dashboards (KPIs) for Business Leaders, Dynamic Dashboards for Sales users, and Service users.
- Experience creating Apps, Custom Objects, Custom fields, Record Types, Page layouts, compact page layouts and various other components as per the client and application requirements.
- Experience in migrating from Salesforce classic UI to Lightning Experience.
- Proficient using Import wizard and Data Loader.
- Experience developing Wave Apps, Datasets, Lenses and Dashboards in Einstein Analytics.
- Created Object-Level Security (Profiles & Permissions Sets), Record-Level Security (OWD, Sharing Rules, Manual Sharing and Role Hierarchy based on Organization role hierarchy) and Field-Level Security.
- Customized standard Salesforce Applications created custom Applications, Custom Objects, Fields, Record Types, Page Layouts, and Search Layouts to organize Fields, Custom Links, Related Lists, and other components on a record detail and edit pages.
- Created Lightning Processes, Workflow rules, complex multi-step Approval Processes, Visual Workflows and Triggers to automate business processes related to Accounts, Opportunities, cases, and other standard & custom objects.
- Designed, Created, and scheduled Standard Business Reports & Dashboards (KPIs).
Salesforce CRM Analyst
ADP – Pasadena, CA February 2018 – March 2021
- Creation and management of dashboard, reports, forms, templates, and layouts within Salesforce
- Maintain all objects, layouts, fields, etc. to keep CRM current and user friendly.
- Integrate data from multiple sources and systems to generate routine or ad hoc reports.
- Understand and provide configuration level support for Salesforce.com applications including report creation and mobile enablement.
- Basic data import and export using Salesforce.com data loader and wizards.
- Experience with development of formulas and advanced formulas and object linking.
- Well versed with SQL or SOQL and Excel
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Ability to work independently, as well as collaboratively within Salesforce support team and across business units.
Data Analyst
Southern California Edison – Rosemead, CA April 2017 – February 2018
Responsibilities:
· Contributed to team effort of designing numerous simple to complex T-SQL statements, stored procedures with parameters to query Sales Force database according to business requirements.
· Evaluated table relationships to determine the most efficient query designs to return requested results.
· Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
· Restricted data for users using Row level security and User filters.
· Developed Tableau visualizations and dashboards using Tableau Desktop.
· Developed Tableau workbooks from multiple data sources using Data Blending.
· Designed and performed Data Import/Export, Data Conversions, Data Cleansing and worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.
· Used MS Excel in extracting data from text files, saved queries or databases, used automatic outlining, inserted subtotals, created advanced filters.
· Reverse-Engineered the existing database structure to understand the existing data models so that any changes incorporate would synchronize with current model.
Data Analyst
Ally Insurance, Michigan, US July 2015 – April 2017
· Involved with Business Analysts team in preparing functional specifications and changing them into technical specifications.
· Gathered, reviewed business requirements and analyzed data sources from Excel, SQL for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
· Created test reports, optimized slow running reports, monitored performance of reports and took corrective action to improve and reconcile discrepancies between the expectations of clients and information presented in their reports.
· Developed and maintains data models and data dictionaries, data maps and other artifacts across the organization, including the conceptual and physical models, as well as metadata repository.
· Created pivot tables and charts using MS Excel worksheet data and external resources, modified pivot tables, sorted items, grouped data, refreshed, and formatted pivot table.
· Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
· Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
· Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps and Gantt charts.
Data Analyst
Genpact – Hyderabad, India November 2013 – February 2015
Responsibilities:
· Involved in gathering data from a different team, along with business intelligence team to provide reports, coordinating the deliverables, gathering and documenting the requirements.
· Used Python in data acquisition, wrangling, cleansing, and preparation for analysis.
· Performed in-depth analysis of data and prepared daily reports by using SQL, MS Excel, Share Point.
- Responsible for identifying reports from predecessor systems that are not used or are no longer needed based on the functionality of the new system
- Develops and maintains the master list of reports to be produced by the new system while minimizing duplication of reports
· Experience in creating dashboards using the programs: Power BI, Tableau and SSRS
· Generated Heat maps to identify the risk and flaws in the business.
· Developed and produced a dashboard, key performance indicators and monitor organization.
Data Analyst
Bharat Dynamics Limited – Hyderabad, India August 2012 – August 2013
Responsibilities:
· Conducted requirements gathering and specification as part of the formal implementation change request process.
· Collecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platform
· Created and established the FS database including versioned tables, table maintenance events, structures, indexes, view clusters, transactions and transports.
· Validated the reports to make sure all the data is populated as per requirements in production environment.
· Involved in checking the logs for the production jobs and monitor the data loading.
· Prepared Defect Report as per severity and Priority
· Analyzed Test specifications and written Manual Test cases for Black Box Testing
Education
Master of Science, Computer Science
California State Polytechnic University, Pomona, California
Bachelor of Technology, Electronics and Communication Engineering
Jawaharlal Nehru Technological University, India
Sincerely,
Nikhil Ramagiri | Team Lead - Sales
666 Plainsboro Rd, Suite #1116, Plainsboro, New Jersey 08536
