SUMMARY

• Skilled Computer Science graduate with concentration on Data Analytics, Data Visualization & Machine Learning, holding a Masters’ degree with a demonstrated history of 5+ years of successful IT experience in Business Intelligence, Data Analytics and Process Improvement, including expertise in Operations Management.
• Experienced with Databases, Report design, Data Visualization and Business Intelligence tools like Tableau Online, SSRS and Microsoft Power BI.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence teams.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Veri cation and identifying data mismatch.
• Knowledge of statistical concepts such as regressions, prediction modelling, time series, Bayesian methods, clustering, etc., to analyse data and provide insights.
• Well versed and certified in Python Libraries such as Numpy, Pandas, SciPy, Matplotlib, Seaborn, Machine Learning with Scikit - Learn and Neural Networks.
• Created dashboards in line with the analytical uniformity using the advanced analysis of Tableau Desktop and organizing dashboard views and objects.
• Hands on experience with creating solution driven Dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Line Charts, Scatter Plots and Histograms in Tableau Desktop.
• Created various interactive customized dashboards by using actions and presenting stories in Tableau based on user needs and business requirement.
• Proficient in designing and developing ETL objects using Informatica PowerCenter with various transformations such as Joiner, Aggregate, Expression, SQL, Lookup, Filter, etc.
• Experienced in analyzing PL/SQL, Procedures/Functions, Triggers, and Packages on database (RDBMS) packages like MS SQL Server, DbVisualizer, Teradata.
• Strong experience of working across geographies, leading tasks and teams to work on business intelligence and operations initiatives, focused on optimization solutions across multiple organizations, functions and platforms.
• Experience gathering customer requirements, writing user stories and partnering with developers to ensure full understanding of internal/external customer needs.
• Software Development Life Cycle (SDLC) experience including Requirements Analysis, Design and Development as per Agile Methodologies.
• Experienced as a Business Analyst for data warehouse with a good knowledge and expertise on SDLC.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, and User Defined Functions.
• Excellent knowledge in preparing required project documentation, tracking, and reporting regularly on the status of projects to all project stakeholders.
• Self-motivated, organized, hardworking, detail-oriented, quick learner, resilient, team player and structured with expertise in programming and data analytics.
• Excellent written and oral communication skills, team spirit with strong analytical & problem-solving abilities.

TECHNICAL SKILLS

Languages: Python, R, SQL, Java, JavaScript

Database/ Tools: Teradata, Db Visualizer, MS SQL Server 2012, MS Access, SQL Server Management Studio

Methodologies: Agile, Scrum and Waterfall

Libraries: Scikit-learn, NumPy, Pandas, Matplotlib, Seaborn

Scripting Languages: UNIX, HTML

Reporting Tools: Tableau 10.x Desktop, Server and Online, Microsoft Power BI.

Data Visualization: Tableau, Microsoft Power BI

Machine Learning: Regression, Clustering, SVM, Decision trees, Classification, etc.

Big data Framework: Amazon EC2, S3 and EMR

ETL/Data Warehouse Tools: Talend, Teradata, Informatica, Redshift

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Business Intelligence Analyst

Responsibilities:

• Worked closely with marketing and operations teams to build and analyze listener behavior reports.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Created multiple visualization reports and dashboards using Tableau Desktop.
• Developed various Complex SQL Queries, Views for Generating Reports.
• Automated ETL process for moving data from landing zone to data warehouse by integrating workflows
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Converted existing BO reports to tableau dashboards.
• Leveraged advanced features of Tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Created different KPI using calculated key figures and parameters.
• Developed Tableau data visualizations using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Implemented data blending to blend related data from different data sources
• Involved in integrating data from various online and offline sources to build data insights
• Worked on creating sessions and workflows on Informatica.
• Automated different workflows, which are initiated manually with Python scripts and Unix shell scripting.
• Deployed AWS components on S3 buckets in Production and on Talend EC2 servers.
• Worked on and executed queries to validate data after every activity on Teradata SQL and Db Visualizer.
• Generated various reports to track the efficiency of the process and to find opportunities for automation.
• Migrated code successfully between environments like Dev, QA, Prod and deployed dashboards on Tableau effectively.
• Prepared Dashboards using calculations, Parameters, Trend Lines, Aggregate Functions, Filters in Tableau.
• Involved in various stages of data preparation for model training and inferencing.
• Updated knowledge and skills regularly through in-house and external courses on different platforms.
• Completed many hands-on courses and learning paths on Python, MS Excel, SQL, Statistics, Data Visualization, Machine Learning, Artificial Intelligence, etc. as a part of Analytics and Insights training.

Environment: Tableau, SQL, Unix, Python, Teradata SQL Assistant, Db Visualizer, Informatica, AWS S3, Talend, Putty, ServiceNow, Jira, Tidal Automation Software, MS Excel.

Confidential, Arlington, VA

Data Analyst

Responsibilities:

• Involved in all phases of data acquisition, data collection, data cleaning, model development, model validation, and visualization to deliver data science solutions.
• Worked closely with marketing and product teams to build customer behavior analytics- tracking customer engagement, churn prediction models and Lifetime-Value models.
• Performed data management projects and fulfilled ad-hoc requests according to user specifications by utilizing data management tools like Python, SQL, and Google Sheets.
• Worked exclusively for Strategy & Planning, People Operations, and Budgeting.
• Automated Quarterly reports and Budgets forecast model for People Operations using SQL and Tableau.
• Organized, extrapolated, and disseminated data across departments, used for drawing conclusions about the success of current methods and policies.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Developed a dashboard to track Remote On-Boarding during COVID and Client Management using python scripts, SQL, and Tableau Server
• Extracted data from Google Analytics and generated SEM reports to support effective campaigns
• Generated campaign analytic reports, quarterly reports, and web analytic reports
• Experience working with data scripting such as SQL, R, Python.
• Experience with reporting tools such as Power BI, Business Objects, Tableau, etc.
• Experience with automated data quality processing and techniques.
• Involved in requirement gathering, technical design, development, testing and implementation of BI Analytics needs.
• Actively involved in developing T-SQL queries for implementing Stored Procedures, Functions, Indexes and Views for different tasks.
• Performed T-SQL query optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables.
• Collaborating with data engineers and operation team to implement ETL process, wrote and optimized SQL queries to perform data extraction to fit the analytical requirements
• Wrote advanced SQL queries and scripts to create standard and ad-hoc reports for senior managers
• Experience in Business and Data Analysis, Database design, Data mapping, Data mining, Data Profiling, Data Migration and Data Integration.
• Involved in migration projects to migrate data from data warehouses among Redshift, Talend, Informatica and Teradata.
• Understanding of Data Warehousing and ETL/ELT architecture from a consumer point of view
• Developed and tuned Stored Procedures for optimum performance that are used in the daily data processing.

Environment: Tableau Desktop 10.x,9.x, SQL Server 2014, Python 3.x, R, SSAS, AWS, ETL, Oracle, Alteryx, Informatica, Teradata, MS Excel, Origin, Agile Scrum

Confidential

Associate Software Engineer

Responsibilities:

• Proficiency in Healthcare application, batch and claim processing.
• Meticulously worked on JavaScript, Angular, Facets tool, SQL Server and ServiceNow.
• Wrote queries on SQL Server for database objects containing functions, triggers and stored procedures.
• Acquired strong programming skills in Java using web-based technologies like Spring MVC.
• Implementing web-based systems and contributing diverse modules to the company’s primary systems.
• Participated in breakdown and planning of module structures and project deliverables.
• Instrumental in the diverse stages of the software development lifecycle, including requirements gathering and analysis, systems design, development, and testing.
• Utilized diverse development methodologies throughout the SDLC, including test-driven development.
• Interacted effectively with the system analysts, business users for design & requirement clarifications.
• Participated in the daily Scrum and other scrum ceremonies to produce quality deliverables within time.
• Designed the frontend using Angular.js, HTML5, CSS3, JavaScript, Ajax, jQuery, JSP and Spring Libraries.
• Carried out the jQuery based Ajax implementations and performed client and server-side validations.
• Created user-friendly GUI interface and Web pages using HTML and CSS3, Bootstrap and Angular JS.
• Developed web components using Confidential pattern under Spring framework.
• Developed Spring Controller classes, Service classes, Repository classes and configured XML file for Spring.
• Designed, developed, and maintained the data layer using Hibernate.
• Worked on file handling using Perl and shell scripting alongside the frontend development.
• Generated one-run scripts for data loading and processing.
• Troubleshot and fixed incidents and problem tickets on customer requests.
• Applied fixes and automated jobs by writing scripts efficiently to avoid manual misses.
• Assisted during data migrations between environments.
• Ensured smooth workflow during critical production abends, incident and problem tickets.
• Simultaneously delivered Knowledge Transfer sessions successfully.
• Underwent training on MEAN Stack and developed proficiency on Angular, Node JS, JavaScript, TypeScript and MongoDB.

Environment: Angular, Node JS, JavaScript, HTML5, jQuery, SQL, Java, Spring MVC, Eclipse, Perl, Visual Studio, SQL Server, JSON, ServiceNow, Agile.

Confidential

BI/Data Analyst

Responsibilities:

• Automated processes by writing scripts and creating jobs on Tidal Automation software.
• Documented the Business Requirement Document to get a better understanding of client's business processes of the projects using the agile methodology.
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Worked on creating sessions and workflows on Informatica while monitoring and handling the failures.
• Wrote and executed shell scripts efficiently in Unix servers to post the files to multiple vendors.
• Worked on the Teradata stored procedures and functions to load data to tables.
• Worked with senior business analysts, interpreted business requirements that users looked to dashboards to answer, and created server-based Tableau dashboards with automatic updates.
• Made responsible for Document Management, used SharePoint and integration to Office365 and organized project and program documents from BRDs, FSD and Change Control implementation.
• Identified the source and target tables and developed reports using Tableau, Power BI, MS Access, Excel (VBA, Macros), and R.
• Worked with cross-functional teams to support JIRA in ways that will help them improve their business process.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Developed and reviewed SQL queries with use of join clauses in Tableau desktop to validate static and dynamic data for data validation.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the Agile and the waterfall.

Environment: SQL, UNIX, SQL Server, Tableau, Informatica, Putty, Tidal Automation Software, Python, Agile methodology, JIRA, Visio, MS office.