*+ years of total IT experience as a Data Analyst in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co-ordination and interpersonal skills for leadership.
Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Configuration Management.
Proficient in Python Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modelling and Data visualization using Python and Tableau.
Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
Experience in development of T-SQL, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
Expertise in analysis, design and implementation of data warehousing applications using Tableau, Teradata, Google Analytics, Informatica, MS SQL Server, Oracle, and MySQL.
Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
Knowledge in Business Intelligence tools like Business Objects, Cognos and OBIEE.
Experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.
Good experience of using Python libraries like Panda, NumPy, SciPy, Scikit-learn, Plotly, Matplotlib, Seaborn and NLTK.
Experience with Data Analytics, Data Reporting, Ad-hoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.
Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
Good Experience with creating UML diagrams using Rational Rose and MS Visio.
Good Experience of using Source and Version Control Systems like Jira, GitHub and SVN.
Good experience with Data Analysis - Data collection, Data transformation and Data loading using different ETL systems like SSIS, SSRS and Informatica.
Experience in creating complex reports in Power BI (List reports, Crosstab reports, Drill through reports, Sub reports and Cascading prompts).
Experience in creating functional/technical specifications, data design documents based on the requirements.
Strong team building and conflict resolution abilities with excellent communication skills. Ability to establish clear and effective communication with team members, managers and internal/ external stakeholders.
Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.
Master of Science in Information Systems
New Jersey Institute of Technology, NJ
CompuGain, PA - Data Analyst Jan 2020 – Current
Created functional specification documents and spreadsheets that includes the data mapping & data analysis from different sources and coordinate with the development team for data conversion.
Optimize SQL queries performance, integrity, and security of the project’s databases/schemas.
Contribute to the optimization of data management and performance tuning.
Develop and execute test plans to validate that application meets technical specifications.
Build complex SQL queries to perform data masking and encryption techniques form one data source to another to ensure data security.
Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project and business stakeholders throughout the project life cycle.
Supporting the data warehouse in identifying and revising reporting requirements.
Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
Humana, NJ – Data Analyst Apr 2019 to Dec 2019
Gathered business requirements, performed gap analyses, conducted project management tasks, and performed quality assurance tasks in agile environment as a part of scrum team.
Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
Worked in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python libraries.
Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Teradata, Oracle, SQL Server).
Created reports and dashboards, by using Tableau to explain and communicate data insights, significant features, models scores and performance of new recommendation system to both technical and business teams.
Predicted customers preference based on order history to maximize sales efficiency using logistic regression.
Developed Key Performance Indicators and scorecards to monitor product sales and operations of vendors and fulfillment centers.
Worked with different teams to gain insights about the data concepts behind the business.
Used JIRA for bug fixing and version control.
VIVMA, India – Data Analyst Jan 2015 to Nov 2017
Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document (SRD), Data Dictionary, Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, and Sequence diagrams.
Contributed in ensuring all implementations consistent with Software Development Lifecycle (SDLC) standards.
Supported customer service department and increased customers' positive feedback rate from 88% to 94%.
Devised and initiated new initiatives that helped the company address issues like establishing a knowledge center, automating process to log issues and system bugs, and improving experiences.
Performed ad-hoc requests for clients using Excel and customized SQL queries to extract and format requested information.
Worked with cross-departmental teams to implement new systems and upgrades.
Created interactive Tableau dashboards to visualize and facilitate data driven decisions by business stakeholders.
Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
Created Tableau dashboards using heat maps, stack bars, lines, area charts, scattered plots, geographical maps using show me functionality.
Create Views and stored procedure to be consumed by SharePoint dashboard, Excel dashboard, and Power BI dashboard.
Develop processes and procedures for data mapping, compliance and statement validation.
Used GitHub as a Project Management tool.
Location: Jersey City, NJ Mobile: 201-***-**** Email: firstname.lastname@example.org