Data Analyst Resume Dallas TX - Hire IT People

OBJECTIVE

To acquire a position dat affords me teh opportunity to bring my technical expertise, problem solving skills and willingness to learn to make an organization successful.
Expertise in coordinating & managing requirements gathering phase, design phase, build phase, testing phase and postproduction support phase.
Expertise in managing various project phase, communications and documentation following PLC (Project Life Cycle) based on corporate methodologies.
Proficient wif SQL code.
Expert in create and manage report in Power BI, Tableau and Google studio
Strong IT experience and noledge related hardware and software.
Good noledge of VBA
Excellent Information Technology literacy, wif strong experience in using Excel (including VBA) and other data management systems for complex data analysis
Excellent attention to detail for providing accurate documentation and quality reports to agreed deadlines
Basic proficiency wif Linux/Unix OS and utilities
Strong analytical skills, able to interpret performance data and communicate recommendations
Good noledge and understanding of data administration
Strong analytical skills wif teh ability to collect, organise, analyse and disseminate significant amounts of information wif attention to detail and accuracy
Strong Excel - creating pivot tables, vlookups, pulling data monthly & quarterly, creating dashboards
Hands on experience wif AWS Informatica 10.2, Tableau 2020 and Snowflake.

PROFESSIONAL EXPERIENCE

Confidential - Dallas TX

Data Analyst

Responsibilities:

Created ad-hoc complex SQL queries for teh team.
Performed DML and DDL operation as per business requirements.
Great experience wif Power BI tool, created several reports from scratch for teh Sales team and Production team and also created KPI reports for teh clients like AT&T and T-Mobile and Managers
Expertise in creating Power BI reports from importing Direct Query and Live data from several data sources
Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
Created ETL process in Informatica Designer 10.2 to import customer Avro file from AWS s3 bucket and matched wif internal data in PostgreSQL database and export cleaned data to Snowflake table to use for teh Power BI and tableau reporting.
Used Control M for scheduling informatica jobs
Expert in Python Pandas and NumPy libraries for analysis customer raw data and insert data directly to Snowflake table using snowflake connector in python script.
Worked on Tableau 2020.1 to modified existing reports as per business.
Expertise in scheduling refresh and troubleshooting refresh issues wif Power BI and tableau report
Used Azure reporting services to upload and download reports
Create Power View Reports in MS Excel using data from workbook and external sources
Create Tabular and Matrix Reports, and integrated charts into dashboard for spot analysis and trends. Also generated ad-hoc reports, summary reports/sub-reports for scorecards based on requirements.
Used R tool for statistical computing and web scraping

Confidential - Irving TX

Data Analyst

Responsibilities:

Involved in requirements gathering, analysis, design and development of new database for one of teh telecom clients.
MDX query development.
Performed data reconciliation procedures to confirm completeness of data extract
Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and Functions.
Used DDL and DML for writing triggers, stored procedures and data manipulation.
Tuned SQL statements (Using Indexes) and Involved in tuning teh database.
Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
Created Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
Responsible for General Database Administration, Query Performance Tuning.
Prepared final data analysis results sets or output files

Confidential, Denton TX

Corporate Consultant

Responsibilities:

Corporate Bookkeeping Services
Consulting and Advising on Business Technologies
Advising on Risk Management
Consulting on Resource Management and Procurements
Cost Control and Variance Analysis

We provide IT Staff Augmentation Services!

Data Analyst Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship