Ojaswee Adhikari

PROFESSIONAL SUMMARY

Highly organized and enthusiastic professional having over 5+ years of experience in the field database design, database development and administration, data analysis, data modeling, data mapping, data visualization in diverse business domains.

Experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as SSIS.

Experience in SQL Server 2008/2012/2014/2016 database design, development, performance tuning, query optimization, data warehousing, and ETL processes.

Strong knowledge of database management writing complex SQL queries, stored procedures, various joins, cross/outer apply, group by, over partition by, cursors, merge, try/catch, dynamically generated scripts, triggers, common table expressions, scalar/table-valued functions, create/alter tables/columns, views, primary/foreign key constraints, and indexes.

Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.

Proficient experience as a Data Analyst in gathering data from various sources, data profiling, data definition, and loading data to the business warehouse.

Developed and optimized SSIS packages to extract data from various data sources such as excel, flat files, and OLEDB into SQL server with multiple transformations provided by SSIS such as multicast, data conversion, script task, derived column, merge, union all, file tasks, while, for each loop, and send email task.

Created dashboards, status reports, metrics, budget, schedules, alerts using SSRS to streamline processes & procedures.

Proficient in the development of effective dashboards and reports in Power BI, Tableau using visualizations by using actions, local and global filters as per the end-user requirement.

Experience in conceptual design, logical design, & physical design of data models, Star Schema/Snowflake modeling, FACTs & Dimensions tables using Erwin.

Experience in developing efficient Error handling methods for ETL mappings and workflows.

Experience in data analysis using Pandas, data visualization using Matplotlib.

Experience in Data analysis and Data presentation using advance excel functions like conditional Formating, cell formating, data sorting and filter, VLOOKUP, Pivot table and Pivot reporting, Macros, functions, advanced formulae, and advanced Charting to present the data.

Ability to work independently or as a member of a team, committed to meet deadlines with quality, and self-motivated to learn new technologies.

Have very strong analytical, problem-solving, and troubleshooting skills and able to adopt new situations and environments quickly.

TECHNICAL SKILLS:

Programming

Languages

SQL, T-SQL, PL/SQL, SAS, Python, VBA

Databases

MS SQL Server, Oracle, Teradata, PostgreSQL, MySQL, MS Access

Tools

SSMS, SSRS, SSIS, SSAS, Tableau, PowerBI, Visual Studio, Python, Control-m, Bitbucket, Git, MS Office, Microsoft SharePoint, JIRA, Erwin, MS Visio, Google Analytics, Adobe Analytics, Pandas, Matplotlib, Jupyter, Anaconda

Operating System

Windows XP/Vista/2007/2010, Windows Server 2003/2008/2012/2016, Linux.

PROFESSIONAL EXPERIENCE

JP Morgan Chase, Plano, TX

Data Analyst

Responsibilities:

June 2018 – Present

Participated in regular meetings with Product Management, Development Teams, and Clients to facilitate understanding, clarification, and implementation of product execution projects

Responsible for developing specifications for user interfaces, workflows, and resolving any conflicts with requirements between business and technology

Created dynamic SSRS reports (drill through, drop down, multi-parameterized, ad-hoc, sub-report, and link report) by using advanced expressions and custom codes. Maintaining existing reports based on the user requirements

Created advance Stored Procedures, Functions, Triggers, Tables, Indexes, Views, Joins, and T-SQL queries based on business needs and requirements

Create dynamic SSIS packages to load data from various sources (Flat file, Excel, FTP, SQL Server, Oracle, Teradata, Sybase, Informix, etc.) using variables, parameters, expressions as well as create loggings and error handlings

Design and create dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose

Created Dataflow Diagrams to indicate the flow of data from various source to the target system and the connection from which source we can get the required information in the future as well

Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries

Performed Data profiling to examine the pattern of data coming from existing source systems for collecting the statistics and information about the data

Performed statistical data analysis using Pandas

Performed data visualization and prepared technical reports using Matplotlib

Developed insightful dashboards that management used for well-informed business decisions

Published various kinds of interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers

Connected Tableau to various databases to establish live connections. Created schedules for incremental refreshes for data sources on the Tableau server

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports, and linked reports using SSRS

Tested applications and documented results and bugs including documentation of information useful in the debugging process

Epsilon, Boston, MA

Data Analyst

Responsibilities:

Feb 2016-May 2018

Collaborated with the data analytics team to understand their requirements and develop elegant solutions

Worked on developing complex reports using custom SQL scripts to extract and present data

Developed complex T-SQL scripts to develop Stored Procedures, Models, Functions, User Defined Functions, User profiles, Views, Facts, and Dimensions tables, Triggers for multiple applications

Used dimensional data modeling principles like Star / Snowflake schemas, De-normalized data structures, slowly changing dimension.

Optimized SQL performance, integrity, and security of the project’s databases/schemas. Contributed to the optimization of data management and query performance tuning

Assisted in the design, analysis, and development of relational databases and assist with data warehousing and modeling.

Involved in data gathering, data analysis framework involving data cleaning, processing, analysis, and visualization

Developed SQL queries using joins, functions, procedures, subqueries to automate tasks

Designed executive reports using an in-house tool, generating on-demand and scheduled reports for business analysis or management decision using SSRS

Designed, tested, and debugged custom queries using Microsoft T-SQL and SQL Reporting Services

Integrated and analyzed data from multiple homogeneous and heterogeneous sources using SSIS

Performed ongoing database maintenance functions, including data loads, data cleansing, matching, and reporting

Extracted and transformed data into the Staging Database and load data into the data warehouse to create fact table and dimension table

Performed data visualization and dashboard creation using Tableau

Created and manipulated various management reports in MS Excel for sales metrics using VLOOKUP and Pivot tables

Developed analysis of data, trends, and forecast to provide insights to an array of partners (marketing, sales, supply chain, affiliates)

Collected and statistically analyzed data (Correlation analysis, Hypothesis testing, Linear regression, ANOVA testing) using Excel. Automated analysis using Macros.

Created different Power Pivot reports as per the client requirement.

Collaborated with various levels of staff including senior management on numerous reporting initiatives

Monitored & analyzed ETL jobs to pull data from the source system to staging, then warehouse

Himalayan Bank Kathmandu, Nepal

Junior Data Analyst

Responsibilities:

Feb 2015 – Dec 2015

Accurately identified, extracted, and analyzed large volumes of data from different sources

Responsible for data extraction, cleaning, transforming, and integrating it

Involved in creating database objects like tables, views, procedures, triggers, functions using oracle SQL to provide definition, structure and maintain data efficiency

Developed SQL queries to create and modify Stored Procedures, Functions, Views for reporting/processing data

Performed tuning and troubleshooting of applications, modules, and reports to improve performance and minimize system resource constraints

Developed SQL queries to filter data within the Oracle database tables for logical data modeling

Analyzed, retrieved, and aggregated data from multiple centers to perform statistical analysis

Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.

Developed and maintained reports using relational databases as data sources for internal and external client reporting.

Involved in the process of loading data into SQL Server and creating Process Flow Diagrams using MS Visio

Conducted one-on-one sessions with business users to gather data warehouse requirements.

Performed detailed analysis to identify data trends through excel and BI tools

Performed calculations and created predictive and forecasting reports

Developed data visualizations, reports, and reporting dashboards for decision makers using Tableau.

Used advanced MS Excel to format and sort data, create pivot tables, used VLOOKUP, and other advanced Excel functions

Performed defect reporting and bug tracking using JIRA, also followed up with the development team to verify bug fixes and update on bug status

Authored User reference documents on all the deliverables created for future reference and conducted training sessions.

EDUCATION

Master of Science in Biomedical Engineering, Mississippi State University (MSSTATE), Starkville, MS

Contact this candidate