Data Analyst Resume
Charleston, SC
SUMMARY
- Over 5 years of Information Technology industry experience in working wif Microsoft BI tools (SSIS/SSRS/SSAS) Microsoft SQL Server, and OLAP as SQL Developer.
- Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming and Retrospective.
- Experience in Business and Data Modeling/ Data Analysis, Data Architect, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, MDM, NoSQL and Metadata Management Services and Configuration Management.
- Experience in creating dashboards and charts/reports using Tableau and Power BI and proficient in Data collection, Data cleansing, Data modelling and interpretation of large data sets.
- Experience in converting Legacy Reports to Tableau dashboards connecting to SQL server.
- Expertise in Microsoft Integration Services like SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks). experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), and POWER BI.
- Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
- Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
- Extensive experience in creating complex SSIS packages, creating jobs, Alerts and schedule SSIS Packages using SQL Agent, migrating teh data from different legacy system to SQL using SSIS.
- Excellent in High Level Design of ETL DTS Packages &SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring and Fine - tuning ETL workflows in SSIS.
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Proficient in Database Query performance optimization, debugging and performance tuning using teh Query Analyzer, SQL Profiler and SQL Server Debugger.
- Demonstrated leadership abilities and teamwork skills as well as teh ability to accomplish tasks under minimal direction and supervision.
TECHNICAL SKILLS
RDBMS/Databases: MS SQL Server 2019/2017/ 2016/2014/2012 /2008 R2, Oracle 13c/12c/11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database.
BI Tools: Power BI Desktop, Einstein Analytics, SAP Business Objects, Tableau Desktop (2018.1.x/10.x/9.x/8.x), Tableau server (10.x/9.x/8.x), Workday, Reader, Online, Crystal reports, MS Excel, SSRS and Excel Power View
Development skills: T-SQL, PL/SQL, SSIS/SSRS/SSAS
Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Excel.
Design Technologies/Tools: Erwin, MS Visio, Rational Rose
SQL Server Tools: SQL server management Studio, BIDS, SQL server profiler, FTP, TOAD.
Cloud Services: Microsoft Azure, Confidential Web Services (AWS)
Data Knowledge History: Data Modelling, Data Mapping, Data transformation, Data Lineage and Data Catalogue
Operating Systems: Windows, UNIX
PROFESSIONAL EXPERIENCE:
Confidential, Charleston, SC
Data Analyst
Responsibilities:
- Worked on teh development of Tableau Dashboard reports for Key Performance Indicators for management.
- Created SSIS packaged and used Analysis Services processing task to update teh cube wif current data.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
- Implemented Drilldowns, Drill throughs, Bookmarks in Power BI to make teh dashboard TEMPeffective and clear understanding
- Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards.
- Created several SSIS packages using advanced tools to pull data from various data sources including flat files, MS-Access, Excel, SQL Server/Oracle databases, etc.
- Analyze and query multiple, complex databases and systems to produce analytic reports and databases. Create and edit databases, spreadsheets and other forms of healthcare payment data.
- Responsible for Troubleshooting Report Processing, Subscription, Delivery and Configuration
- Developed Query for generating drill down and drill through reports in SSRS.
- Responsible for maintaining, updating, and using full, differential and transaction log backups and restoring database.
- Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure teh completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
- Worked on all types of transformations that are available in Power BI query editor.
- Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression CTE.
- Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline teh proposed solution.
Environment: Power BI, SQL Server 2019, SSIS, SSRS, Tableau Desktop, MS Word, MS Excel, Visio, Share Point, Jira, SQL profiler, Windows.
Confidential, Raleigh, NC
Data Analyst/ BI Developer
Responsibilities:
- Created Technical design specification documents based on teh functional design documents and teh physical data model.
- Responsible for Migrate Data from multiple sources like flat file and Excel to Single SQL Server table.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Created and administrated workspaces for each project on Power BI service and published teh reports from Power BI Desktop to Power BI Services workspace
- Performed DAX (Data Analysis Expressions) & MDX functions for teh creation of calculations and measures in teh Tabular Mode & multi-dimensional Cubes.
- Extensively involved in Designing and Developing ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards
- Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building
- Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.
- Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
- Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement, cash flow by requests from business units
- Conduct extensive quality control and record-keeping procedures to ensure teh highest levels of data integrity.
- Manage and track end-user requests and troubleshoot Tableau issues.
- Responsible for accurately reporting on teh financial aspect of teh company's operations by rendering reports on daily / weekly / monthly base
Environment: Power BI Desktop, Power BI Service, Microsoft Azure Portal, Azure Data Factory (ADF), Mist power bi, SSIS, Tableau Desktop, MS SQL Server 2017, Management Studio (SSMS), ETL, Windows.
Confidential, Atlanta, GA
BI Developer
Responsibilities:
- Participated in daily scrum meeting wif team to discuss on teh challenges and development of teh project.
- Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.
- Designed and developed teh migration of Data Analytics to Power BI.
- Designed and developed teh dashboards, Scorecards and KPI’s in teh Power BI.
- Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.
- Implemented Direct Query, Imports Data and Live Connection modes.
- Teh apps and workspace and share across teh organization and individuals based on teh requirement.
- Created Dashboard and teh Content Pack for teh originations to get teh updated Power BI Reports. And added teh refresh time for each tile in teh dashboard.
- Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
- Create reports in Power BI preview portal utilizing teh SSAS Tabular Model via Analysis connector.
- Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to teh requirements.
- Objects Suite of tools (e.g. Crystal Reports, Web Intelligence Reports, Lumira Visualizations and OLAP queries).
- Tested teh ETL process for both before data validation and after data validation process. Tested teh messages published by ETL tool and data loaded into various databases
- Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
Environment: MS SQL Server 2014/2016, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), DAX, POWER BI, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel.