Preethi

Sr. Data Analyst

ad3g6k@r.postjobfree.com

737-***-****

PROFILE SUMMARY:

Data analyst 7+ years of experience with proficiency in multiple tools and having knowledge in the Business, pharmaceutical and biological sciences in the healthcare and software industry and a passion for working within teams to find solutions to problems.

Top performing Data Analyst, Business intelligence analyst with extensive experience in developing business initiatives, Software development life cycle, portfolio management, client management and relationship management.

I am proficient in SQL, Power BI, ETL/ SSSIS, Data Analytics, Excel, Dataflow, Azure Data Factory, Tableau, and Python at large scale enterprise environments.

Excellent analysis and SQL skills, and experience with product SDLC, quality management and Excel.

Ability to work with various types and stages of Software Development Life cycle processes including Analysis, Design, Development, Testing and Implementation.

Extensive experience in M-Scripting to manipulate the data coming from the data sources like Relational SQL databases by using several functions like split column and assigning variables to the M-scripts whenever necessary.

Knowledge in all types of Database migrations with all the versions of SQL server.

Proficiency in R and Python, with an emphasis on data manipulation and visualization.

Experience in developing SSRS reports -Parameterized Reports, linked reports, sub reports by Region, Year, Quarter, Month and week.

Skilled in using collections in Python for Manipulating and looping through different user defined objects.

Worked with Confidential Power BI, DAX expressions, Power View and Power Query integrated with share point.

Extract, Cleanse, and combine data from multiple sources and systems using R and Python.

Experience in creating views, Constraints, Triggers, Joins, cursors, Temp table, Table variable Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.

Proficient in applying advanced analytical methods and data -driven strategies to extract valuable insights from diverse data sources.

Enthusiastic about staying updated with industry trends and continuously expanding skills in data analysis and visualization.

Worked with informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion etc.

Experienced in transforming business requirements into analytical models, designing algorithms, building models, developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data.

Created Unix shell scripts for informatica post and pre session operations, database.

Strong experience in Software Development Life Cycle (SDLC) including Requirements Analysis, and design.

Expertise in transforming business requirements into analytical models, building models, designing algorithms developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data.

Core Competencies:

Performance Management

Client Relations and Retention Analysis

Project Management

Training and Development

Analytical, Critical thinking, Problem Solving

Area Of Expertise:

Data Manipulation

Data cleaning

Data Validation

Data Analysis

SQL

Tableau

Excel

MS Office.

Technical Skills:

Analytical tools

Microsoft Excel, SQL, Python, R and Tableau, Power BI, SPSS, SAS, MATLAB.

Languages

SQL, Python, R, Java script, HTML.

Front end tools

Visible Analyst, Lotus Notes, Microsoft project

Document Management

TFS Document, Share point, Ultra Edit

Operating Systems

Windows, UNIX (HP-UX, Solaris, AIX), Linux

EDUCATION:

Bachelor of Technology – Information Technology, India.

PROFESSIONAL EXPERIENCE

WALGREENS June 2022 to present

Deerfield, IL

Sr. DATA ANALYST

Designed and developed algorithms, data points and analysis requirements.

Monitored and maintained data warehouses integration for various business functions.

Performed various pharmacy operational activities with a strong commitment to accuracy, efficiency and service quality.

Generated embedded standard reports and executed automated updating of various reports.

Updated BI database functions and implemented new SAAS tools.

Identifying and documenting internal and external data sources.

Using Blending created complex workbooks and Dashboards by connecting to multiple data sources.

Collaborating with various teams to identify data requirements and develop solutions for business needs.

Identifying opportunities for process improvement and efficiency through data analysis.

Assisting in the development and implementation of data collection methodologies.

Identifying and resolving data quality issues, such as missing values, outliers, and inconsistencies, to ensure the data is accurate.

Data Cleaning, preparation and statistical Analysis using R and Python programming.

Analyzed data reporting issues, Designed, developed and tested an interactive Tableau story as a presentation deck for an enterprise level IT leaders meeting.

Created dataflows and extracted datasets from multiple sources into Power BI Desktop.

Worked on Power BI performance optimization using performance Analyzer and DAX studio.

Create comprehensive reports and dashboards using data visualization tools to present findings to stakeholders and management.

Ensure compliance with data governance and data privacy regulations in all data related activities.

Develop and maintain key performance indicators (KPIs)to track business performance and measure the effectiveness and strategies.

Apply predictive modeling and forecasting techniques to identify future trends and opportunities.

Manage data repositories and databases, ensuring data accuracy, integrity, and security.

Utilize statistical methods and machine learning techniques to discover valuable information from complex data sets.

Provide actionable insights and recommendations based on data analysis to support strategic business initiatives and optimize processes.

Collect, clean, and analyze large datasets to identify trends, patterns, and insights that support business decisions.

Identify areas for process improvement within the pharmacy workflow to enhance efficiency and reduce errors.

Analyze inventory data to optimize stock levels, reduce waste, and ensure the availability of essential medications.

Evaluate medication adherence rates and implement strategies to improve patient compliance with prescribed therapies.

Environment: Informatica 9.0.1, Oracle 11g, google analytics, Informatica ILM, Erwin, T-SQL, OLTP, AWS, PL/SQL, OLAP, Teradata, SQL, ETL, SAS, SSRS, MS Excel 200, Informatica Power Exchange.

Citi Group Oct 2019-May 2022

Irving, TX

Business system Analyst

Designed complex reports to validate market exceptions related to daily processes using Microsoft Azure and Power BI.

Created, documented, and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

Identified best practices and recommended enhancements to communicate metrics through dashboards and coordinated with the business team on additional data marts to support dashboard reporting, including coordination of data validation with business users.

Importing data into MS Access tables and creating reports using SQL/VBA, SRS, SSRS.

Collaborated with teams to integrate systems, created visualizations, and reports for requested projects, and developed and updated technical documentation.

Lead the creation and publication of KPI’s and dashboards/metrics that are timely, insightful, and automated by working cross-functionally with multiple departments; identify opportunities for improvement with functional leaders.

Responsible for creating and structuring critical financial analysis models such as break-even analyses, volume/rate/mix analyses, and scenario modeling and SAS programmable edit checks to assist data monitoring, document, and report data issue to Data Management with supervision.

Assist with the month end close process including COGS entries and preparation of the monthly reporting package.

Analyzed available data, worked with business users to gather specifications for data and report requirements, identified data sources to extract business information for reporting purposes, and identified and recommended best sources for building reports.

Formatted and combined data to create high-level dashboard reports in Tableau.

Importing Reports to Excel and applying lookup tables and complex formulas for analysis

Designed, built and deployed data, financial and accounting BI solutions utilizing Excel, Power BI and Tableau (e.g., reporting tools).

Provide day-to-day FP&A support to the functional leaders of the business.

Build reports and interactive dashboards leveraging Microsoft Azure and Power BI.

Employed ETL process in DataStage in accordance with Business Requirements.

Experience using enterprise financial software to analyze costs and trends.

Develop and maintain financial models to analyze cost, margin, and profitability.

Provide the primary financial support to annual operating plan development and periodic quarterly forecasts.

Imported and shared large data sets and files in SharePoint and Salesforce.

Used MS Excel to develop tables, apply formats, lookup tables, pivot tables and formulas for easy access and analysis.

Evaluated and improved existing BI systems developed and executed database queries and conducted analysis.

Environment: Informatica Qliksense 2.24, Qlikview, Power Centre 9.1, Qlikview, Qliksense 2.24, informatica Schedulers, Tableau 2020.2, Anaconda 2021.05, Google analytics, Adobe Analytics, Jupyter Notebook Python 3.3, Excel 2013, UNIX, MS Excel 2007, SQL server 8, HP Quality Center 10.

AXA Insurance, Hyderabad India. June 2017- Aug 2019

Data Analyst

Designed complex reports to monitor and analyze system processes associated with daily data sets.

Performed T-SQL development with MS-SQL Server along with performance tuning experience related to reporting queries required.

Created and maintained a MS Access Database for data storage, reporting and monthly, quarterly, and yearly analysis.

Knowledge of data warehouse techniques, methods, logging, and dimensional modeling.

Analyzed business/data requirements, estimate, and performed data preparation.

Designed and developed business intelligence and data analytical reports to deliver insights to business through data using Tableau.

Daily problem-solving, documentation, communication, and interpersonal skills with ability to manage time and projects, worked within multiple (Technical/Business) environments, and provided training to end users.

Gathered, extracted manipulated, analyzed and modeled data using analytical and statistical tools including SSAS, SSIS and Tableau.

Identified new sources of data and methods to improve data collection, analysis and reporting.

Led the collection, analysis, and reporting of data to meet needs.

Managed Data Content by researching existing Data Flow Diagrams, Data Stores, Data Models, Data Qualification and Standardization rules, and Systems Documentation Maintained Stored Procedure Documentation Standards across the team of developers.

Converted MS-Word documents and Excel tables into SAS Datasets.

Compiled and formatted raw data in MS Excel, pivot tables, lookup tables and advanced formulas Automated the reporting elements in multiple systems and prepared the data for analysis using Microsoft Excel and Microsoft Access.

Transforms Business requests into data deliverables to include data models, data mappings and data transformation rules.

Interpret data, analyze results using statistical techniques and provide ongoing reports. Manage data warehouse initiatives, agile user stories and data warehouse documentation.

Develop and implement data analyses, data collection systems and other strategies that optimize statistical efficiency and quality.

Contributed to the development of project plans for data deliverables and supports development team throughout project lifecycle including during test phase, research test issues, and data content.

Depict moderately complex to complex ideas, issues, and data designs to varied audiences.

Assists with moderately complex problem resolution related to data design and or model.

Acquired data from primary or secondary data sources and maintain databases/data systems.

Identify, analyze, and interpret trends or patterns in complex data sets.

Developing SAS procedures, Macros, Preparing Data, Producing Reports, SAS Formats, SAS Functions.

Filter and clean data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.

Worked with management to prioritize business and information needs.

Environment: Erwin, Informatica 9.0.1, Oracle 11g, Google analytics, Informatica ILM, SQL, ETL, SAS, SSRS, AWS, PL/SQL, OLAP, Teradata, MS Excel 2007, T-SQL, OLTP.

Pago Analytics, Hyderabad India Feb 2016 – May 2017

Data Analyst Intern

Created complex and efficient SQL queries to pull data from SQL server.

Created reports/visualizations in Power BI using Power Query, DAX Functions, visuals (Charts, Graphs, KPIs, Maps, Gauges, Matrix, etc.) and developed insightful dashboards.

Worked collaboratively with various campaign media team members.

Created Dataflows and extracted datasets from multiple sources into Power BI Desktop.

Compiled large volumes of unstructured data from social media campaigns and built master records on Excel (Pivot table analysis, V Lookup, Index & Match Lookups, H Lookup, X Lookup, Moving Average, etc.).

Prepared ad hoc analytical reports and performance insights.

Created database objects like tables, views, procedures, triggers, functions in T-SQL.

Worked on Power BI performance optimization using Performance Analyzer and DAX Studio.

Worked on LOD analysis, aggregations, filters, parameters, hierarchies, sets, groups, bins, joins, and blending in Tableau.

Created perspectives, roles, measures, and KPIs in Tabular model based on the end user requirements and deploying to the Analysis Services Instance.

Worked on LOD analysis, aggregations, filters, parameters, hierarchies, sets, groups, bins, joins, and blending in Tableau.

Created and automated SSIS Packages from the Visual Studio to Integration Services Catalogs for job Scheduling and query execution.

Worked on row-level security, dynamic and parameterized filtering.

Worked on SQL query optimization using indexes and execution plan.

Used Python libraries (Matplotlib, NumPy, SciPy, Pandas, Scikit-Learn) to import, cleanse and

visualize data.

Environment: BI Data Quality, SQL, PL/SQL, UAT, ETL, SQL QUERIES.

Contact this candidate