Data Analyst Resume Richmond, VA - Hire IT People

SUMMARY

Highly motivated and passionate Data Analyst and Programmer with demonstrated history of working in IT and marketing industry having 7 years in experience.
I love the challenges that each new project brings and have a passion for current emerging technologies like Data Analysis, Data Conversion, Data Validation, Data Profiling and Report Creation and working experience in Tableau, Teradata, AWS Redshift, AWS S3, Python, UNIX
Good experience in Developing Teradata SQL queries and using Utilities such As BTEQ.
Strong experience in using Excel and MS Access to dump the data and analyze based on Business needs.
Over to improve the query performance while pulling the data from large tables.
Experience in data analysis using Python (Pandas, NumPy).
Worked on standard Python libraries include boto3 to connect to AWS.
Experience in moving data to cloud platform like AWS (S3) and manipulate data using Redshift.
Worked on performance tuning and optimization to improve the efficiency in script Executions.
Good working experience loading Data Files in AWS Environment and Performed SQL. Testing on AWS redshift databases.
Exceptional ability to research, analyze and convey complex technical information to Diverse end - users at all levels. Solutions-driven strategist who consistently improves Efficiency, productivity and the bottom line.
Recognized for partnering with business leaders and technical teams to plan, integrate, document and execute complex project plans on time and on budget.

TECHNICAL SKILLS

BI Tools: Tableau, MicroStrategy10.2

ETL Tools: Informatica, SSIS, Alteryx Designer

Requirements Management: Microsoft Office (Word & Excel)

Database Technologies: Teradata, Oracle, SQL Server, DB2, Snowflake, AWS, Redshift, Data bricks

Scripting Languages: C, C++, HTML, SQL, PL/SQL, Python

Methodologies: Agile-Scrum

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Data Analyst

Responsibilities:

Worked in the Tech Risk as a Data Analyst. Facilitating data needs for various Risk assessments using various tools and technologies like Snowflake, Data bricks, AWS and Redshift.
Interacting with the Business users and understand and analyze their requirements and providing advanced analytical support for business operations.
Utilized spark SQL to load data from AWS S3 to snowflake tables using data bricks.
Converted extract transform and load jobs in Alteryx to Python.
Created SQL scripts in Snowflake database to ingest data and migrate data from User Schema to user Collaboration Space.
Conducting requirement gathering sessions with senior associate understand business needs and help contribute the daily stories.
Worked with development teams to analyze, develop and solve issues.
Worked with development team to develop dashboards, coding standards, and quality policies and procedures.
Participated in the continuous improvement efforts in enhancing dashboard performance and providing increased functionality.

Environment: Snowflake, Python, Microsoft Office (Word, Access, Excel, Outlook), Data Bricks, AWS S3

Confidential, McLean, VA

Data Analyst

Responsibilities:

Worked in the Enterprise Data Management (EDM) and Risk Team as a Senior Data Analyst.
Day-to-day responsibilities included strategizing key metrics around Data Governance and exploring the potential risks in the Enterprise Data setup across all the Lines of Business (LOB’S).
Communicated with the first line of defense / business and Data Management Advisors to mitigate potential risks.
Created customized dashboards using Tableau to track Data Lineage and Metadata for the business and technical datasets across second line of business.
Used Python scripts to load S3 and Snowflake (Tables, Views) metadata catalogued information to EDM reporting mart (Redshift) for Tableau reporting.
Created Tableau dashboards to show Data Quality for different metrics across Enterprise and Line of Business.
Created Bar graphs, Line graphs and heat maps in Tableau to show the percentage of Data Quality checks in each division/ Enterprise for Snowflake and AWS S3 datasets.
Created SQL and Python scripts to perform Data validations across different metrics in Redshift checked against metadata registrations (Nebula).
Created GitHub webpages for documentation using Sphinx.

Environment: AWS Redshift, Tableau, Snowflake, Python, Microsoft Office (Word, Access, Excel, Outlook)