LENAMIKA

Data Analyst

Charlotte, NC

Email: ad1ooi@r.postjobfree.com

Ph: +1-603-***-****

Professional Summary:

Results driven professional with 10+ years of full-lifecycle software development projects.

Able to quickly understand the goals of the business and break complex issues into manageable components.

Broad experience in developing IT Solutions for business requirements, functional / technical specifications, and Code Components.

Experience in Power BI Desktop, Report Service, Gateway Connectors, Data Models, Relationships, Publishing / Updates to Apps Workspaces, Data On-Demand Refreshes, Scheduling, Testing and Deployment.

Involved in developing, maintaining, and supporting operational reports, dashboards and scorecards solutions using MS Power BI. Experience in Framework Manager, Data Models, Relationships, Table / View Creations, Publishing / Updates to Apps Workspaces, On-Demand Data Refreshes, Scheduling, Testing and Deployment.

High level MS Power BI admin knowledge, custom visuals, and cloud computing environments

Experience in developing, implementing, documenting, monitoring and maintain the data ETL process in various industries like Financial, Health Care, etc.

Proficient in creating multiple kinds of data visualization dashboards.

Complete understanding in all facets of Software Development Life Cycle (SDLC)

Expertise in Power BI Desktop, Power BI Service, Power BI Pro, Power BI Mobile.

Skilled in creating and developing BI Dashboards into rich look for better understanding.

Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.

Involved in publishing Power BI Desktop reports to the Power BI service.

Designed reports in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cubes, SQL Server Integration Services (SSIS), and Power BI.

Cognos reports and framework development.

Created Data Visualizations rich reports using Cognos, Tableau and Power BI as BI tools.

To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, and CSV files to the data warehouse.

Database development for both OLTP and OLAP systems using MS SQL Server

Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 10 desktop/Server.

Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.

Disaster Recovery setup, including Backup Primary setup and configuration.

Used Chrome Developer tool and other testing tool to do the debug.

Experience in Designing, developing and testing various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases

Played an instrumental role in Migration Data from Excel, Flat file, OLE DB using DTS, SSIS and other ETL Tools.

Developed various complex reports from different data sources such as SQL Database and Cubes by using Reporting tools like (SSRS) and expert in fine tuning the reports; Created many Drill through and Drill Down reports.

Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.

Experienced in creating, designing, processing of cubes using SSAS.

Very good experience on Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, partitions, facts, dimension tables using MS Analysis Services.

Responsible for Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.

Hands on experience with Data Modeling tool like Microsoft Visio, ERWIN.

Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.

Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Experience with healthcare, finance, accounting metadata and flat file from different vendors and analyzing by using different research methodology to use business logic and reasoning to identify the strengths and weaknesses of alternative solutions and applying appropriate logic to specific problems.

Key strengths include problem-solving skills, attention to detail, multitasking, and the ability to build effective business relationships, even during times of high stress deployments.

Equipped with an excellent work ethic; possesses a keen sense of responsibility and teamwork with a record of accomplishment and dependability.

Expert in creating several types of complex reports using SSRS (SQL server reporting services).

Education :

Bachelor of engineering in Electronics and communication engineering SETHU College of Engineering (Autonomous) - Anna University, Tamilnadu - 2013.

Skills:

BI Tools

Power BI, Power Apps, Power BI, and Power Automate/Flow, Power Bi desktop, Power Bi report builder, Power Bi report Server, Power Bi Mobile Apps, Power Bi SASS, Power Query editor, SharePoint 2019/16/13, Tableau Desktop v2019.1, Tableau online, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services (SSIS)

Databases

MS SQL Server, Azure, MS Access, MySQL.

Data Modeling

ER/Studio 3.5/4.0, Erwin 4.1

Languages

T-SQL, MS-SQL, MySQL, Java, Python, HTML, CSS, XML

OS

Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools

Microsoft Teams, Microsoft Project, Microsoft Office, Microsoft Excel

SQL Server Tools

SQL Server Integration Services (SSAS), Enterprise Manager, Business Intelligence Development Studio (BIDS)

Operating systems

Windows 9X/2000/XP/10, MS-Dos, MacOS

Other Applications

Excel, MS Office Suite

Professional Experience

Charles Schwab, Manchester, NH

Sr. Data Analyst June -21 to Present

Responsibilities:

Retrieve and collect data from various sources, databases, or APIs using Python.

Clean and pre-process raw data to make it suitable for analysis.

Perform exploratory data analysis (EDA) using Python libraries (e.g., Pandas, NumPy) to gain insights into the data.

Generate summary statistics, visualizations, and other descriptive analyses.

Apply statistical techniques to analyze patterns and trends in data.

Build basic predictive models or apply machine learning algorithms for simple forecasting or classification tasks.

Write and maintain Python scripts for data manipulation, analysis, and visualization.

Understand and use Python libraries relevant to data analysis, such as Matplotlib, Seaborn, and Scikit-learn.

Create reports and dashboards summarizing key findings using tools like Jupiter Notebooks or other reporting libraries.

Communicate results effectively to non-technical stakeholders.

Document data analysis processes, assumptions, and methodologies.

Maintain clear and organized code documentation for future reference.

Collaborate with cross-functional teams, including data scientists, business analysts, and software developers.

Communicate effectively with team members to understand project requirements and goals.

Conduct basic quality checks on data to ensure accuracy and reliability.

Implement data validation and verification procedures.

Identify and troubleshoot data-related issues.

Propose and implement solutions to improve data quality and analysis efficiency.

Stay updated on the latest trends and best practices in data analysis and Python programming.

Seek opportunities for professional development and training.

Follow coding standards and best practices to ensure consistency and maintainability of code.

Participate in code reviews to improve code quality.

Manage and prioritize tasks effectively to meet deadlines and project milestones.

Seek guidance from supervisors when needed.

Technologies: Tableau Desktop v2019.1, MS Office Suite, SQL Server, PL/SQL, MS Excel. SQL Server, SQL Server Management Studio (SSMS), Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, SSIS, Business Intelligence Development Studio (BIDS), TFS, Azure Analysis services (AAS) and Power BI

Banner Health, Phoenix, AZ

Sr.Power BI Developer/ Data analyst Aug2019–May 2021

Responsibilities:

Creating Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors using SQL Server Management Studio.

Creating User Defined Functions, Views to store data into appropriate tables as and when data arrives.

Created indexes to the tables that have least updates to improve the query performance.

Utilizing Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Implementing Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View.

Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring.

Creating database design documentation at architectural and functional level.

Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.

Recommend new strategies and architecture to enhance efficiency of data systems.

Plan, manage and track database and SQL procedures system changes.

Create tasks, sessions etc. in the workflow manager and monitored them in the workflow monitor.

Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.

Extensively used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Working with mappings to dynamically generate parameter files used by other mappings.

Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.

Documented the mappings used in ETL processes including the Unit testing and technical document of the mappings for future reference.

Designed and developed the SSIS packages to extract, transform, load (ETL) the data into Target and generate outbound files for various vendor by using SSIS.

Technologies: SQL Server 2016/ 2014/2012/2008, Power BI, Visual studio 2015/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint, MS .Net Framework code, ERP, CRM software, Widows server 2012.

Penske Logistics, PA

Sr.Power BI Developer Aug 2017 – July 2019

Responsibilities:

Developed reports to visually explore data and create an interactive Excel and Power BI report.

Using a Query editor in Power BI performed certain operations like fetching data from data sources (Excel, Spreadsheets, SharePoint lists, and cloud-based data repositories).

Created analytical reports and provided valuable and relevant business insights for internal and external clients.

Designed and developed visualizations using Power BI Desktop with charts, graphs, and maps; built interactive dashboards with data drill-down into specific insights with filters, parameters, and actions.

Created and maintained data models using DAX (Data Analysis Expressions) to calculate key performance indicators (KPIs) and implement business logic.

Designed and implemented Migration strategies to migrate the data from Google Drive to SharePoint Online using the Sharegate tool.

Successfully planned, organized, and launch the projects that I was involved in into production with quality testing and release permissions to power users.

Involved in a project in designing, building, and testing solutions in the Power App Platform and then transported solutions from the development environment and PROD environment.

Experience on SharePoint Online like creating sites, Lists, Document libraries, Alerts, Site templates, and List templates.

Having knowledge and experience on SharePoint Online like external sharing capabilities.

Technologies: Power BI Desktop, Power BI Service, Power Query, Power Apps, Power Automate, Power Apps Portal, Power Virtual Agent, Office 365 SharePoint Online, Sharegate tool, Business Process flow, MySQL, MS Office.

CSS corps, India

Power BI/Data Analyst June 2013 – Jan 2017

Responsibilities:

Analyzed the Business Requirements Specification, System Requirements Specification, and User Interface Specification documents.

Involved in setting up different configuration environments for compatibility testing and manual testing.

Performed ad-hoc, Functional, Regression, Integration, and Compatibility Testing of Web-based Applications.

Prepared Test Cases with the complete description of requirements, uploaded test cases and reported results to the JIRA. Conducted cross-browser testing in Chrome, Firefox, Internet Explorer, MS Edge, and Safari in Windows and macOS.

Experienced in an agile environment with frequently changing environments and feature sets.

Designed test cases and conducted test results per schedule to meet necessary testing requirements and updates in the testing repository.

Wrote and executed SQL queries to retrieve data from the database using MySQL.

Analyzed software defects and reported them via the JIRA defect tracking tool.

Technologies: Power BI Desktop, Power BI Service, Power Query, Power Apps, Power Automate, Power Apps Portal, Power Virtual Agent, Office 365 SharePoint Online, Sharegate tool, Business Process flow, MySQL, MS Office.

Contact this candidate