We provide IT Staff Augmentation Services!

Data Analyst Resume

Richmond, VA

PROFESSIONAL SUMMARY:

  • Highly motivated and passionate Data Analyst and Programmer with demonstrated history of working in IT and marketing industry having around 6+ years in experience. Strong business development professional with a master’s degree in Information Systems from the Stratford University Richmond, VA. 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, Databricks

Scripting Languages: C, C++, HTML, SQL, PL/SQL, Python C++, C, JAVA, Python, SQL, PL/SQL, UNIX, LINUX.

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)

Confidential, Richmond, VA

Data Analyst

Responsibilities:

  • Built a framework using UNIX and PYTHON to validate data migrated from TERADATA to SNOWFLAKE.
  • Managed report to identify load delays in daily updated production tables.
  • Maintained reports to identify data issues between SNOWFLAKE and TERADATA and automated to produce daily, weekly reports or support teams.
  • Created, deployed and gave accessibility to databases on SQL servers.
  • Wrote optimized SQL queries to pull required data for further reporting.
  • Validated production data in Snowflake platform during activity of shifting operations from AWS East to server to AWS West in order to ensure compliance with government policies is met.
  • Involved in spinning up EC2 instances and adherence to rehydration policies/maintenance.
  • Co-ordinated with off-shore Support teams to report data inconsistencies.
  • Performed data manipulations and data validations for build reporting structure.
  • Contributed as first-hand responder to data quality issues slack channels and platforms.
  • Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
  • Designed and Developed various analytical reports from multiple data sources using Tableau Desktop.
  • Developed dashboards on Tableau to share insights on how delays affect performance and recommendations on customer.
  • Built a drill down Tableau dashboard to give a brief and detailed over view of card tables to customers.
  • Used VLOOKUP and pivot table functions in EXCEL.
  • Proficient working in loading data into staging tables via views.
  • Designed and developed weekly, monthly reports related to the financial partnership using Teradata SQL.

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

Confidential, Washington, DC

Data Analyst

Responsibilities:

  • Gathered Business Requirements from stake holders, interacted with the Users, Project Manager and IT teams to get a better understanding of the project goals.
  • Performed gap analysis of the data and reviewing the requirements.
  • Involved in defining the whole project life cycle, following agile methodology. Analyzed business requirements and segregated them into high level and low-level priorities.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Analyzed requirements for various reports, dashboards, scorecards and created the same using Tableau desktop server.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Responsible for the interactive experience of the site.
  • Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
  • Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer.
  • Performed Targeted user research to analyze customer requirements together with Product Management.
  • Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
  • Proficient working in loading data into staging tables via views.
  • Designed and developed weekly, monthly reports related to the marketing and financial departments using

Environment: Teradata SQL Assistant, Tableau, Microsoft Office (Word, Access, Excel, Outlook)

Confidential

Data Analyst

Responsibilities:

  • Worked with leadership teams to implement tracking and reporting of operations metrics across global programs.
  • Worked with large data sets, automate data extraction, built monitoring/reporting dashboards and high-value, automated Business Intelligence solutions (data warehousing and visualization).
  • Gathered Business Requirements, interacted with Users and SMEs to get a better understanding of the data.
  • Performed Data entry, data auditing, creating data reports & monitoring all data for accuracy.
  • Designed, developed and modified various Reports.
  • Created and presented dashboards to provide analytical insights into data to the client.
  • Translated requirement changes, analyzing, providing data driven insights into their impact on existing database structure as well as existing user data.
  • Worked primarily on SQL Server, creating Store Procedures, Functions, Triggers, Indexes and Views using T-SQL.

Environment: My Sql, SQL Server, MS Office Suite

Hire Now