SUMMARY:

• Data Analyst/Business Intelligence Analyst with over six years of experience, skilled in extracting, interpreting, and analyzing data in a fast - paced environment.
• Proficient knowledge in relational database, business intelligence, analytics and database administration.
• Excellent understanding of business operations and analytics tools for effectively analyses of data.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2014, 2012, Oracle 12c, 11g, MySQL, MS Access

Programming Languages: Oracle SQL, T-SQL, PL/SQL, UNIX Shell Scripts

BI/Web Analytics Tools: Tableau, QlikView/Qlik Sense, Power BI, SSRS, Excel, Google Analytics

PROFESSIONAL EXPERIENCE:

Data Analytics Specialist

Confidential - Kent, WA

• Worked collaboratively with cross functional teams to translate particular business questions into actionable insights that inform decision making.
• Gathered business requirements and created functional specifications for analytics application.
• Extracted, transformed, and loaded (ETL) from multiple data sources using SSIS. Utilized Microsoft Data Services (MDS) to clean, scrub, and standardize the data to ensure the data is clean and well organized before they can be used as data sets for analytics application.
• Built and maintain a scalable data infrastructure (ETLs, data warehouses, views, etc.) that integrates disparate, user-level data sets into a unified view to make analytics easy and effective for all Confidential employees.
• Produced dashboards, Storytelling, KPIs, ROIs, and other business metrics using Tableau and QlikView, clearly and effectively present insights, trends, patterns hidden inside data to internal stakeholders and customers.
• Pulled data from multiple data sources using T-SQL, identified the right metrics needed, developed Confidential hoc reports requested by Stakeholders and external customers.
• Collaborated with multi-channels marketing managers to help them launching multiple marketing initiatives, produced Confidential -hoc and other type of highly visual reports as requested.
• Worked with developers, IT to develop a comprehensive security plan to safeguard the data and prevent unauthorized users from access, implemented backup & recovery plans to be sure zero data loss.
• Investigated the irregularity of the data and worked with Business Analyst, Developer to fix it before it become major issues, ensured data quality and governance and provided support to the entire analytics team.

Data Analyst

Confidential - Bothell, WA

• Worked in a production and test environment to design, develop and maintain the Premier Control Center, a java based e-commerce application that helps business customers, large and small to monitor and manage their products and services.
• Partnered with Business Analysts to write business and functional requirements for new and existing applications need to be improved and updated; designed and built logical data model using ER diagram.
• Developed standard and Confidential hoc reports using T-SQL, SSRS and presented to Product Manager and Executives.
• Performed systems and UAT testing, in collaboration with development and production team to ensure the systems meet with requirements in term of efficiency and performance.
• Designed and developed methodologies and procedures to carry out effective analysis, provided training to the end-users on the new systems implemented.

Data Analyst

Confidential - Washington DC

• Worked as a contractor for Pipeline and Hazardous Material Safety Administration. My responsibilities were to extract the data from oracle database using SQL to create Confidential hoc and other type of reports responded to FOIA (Freedom of Information Act) requests.
• Utilized T-SQL, Tableau to build highly visual dashboards to discover insights, trends, and presented them to the Stakeholders and Government Officials.
• Managed database objects for data analysis team, including tables, views, material views, schemas, functions, stored procedures, packages, created new underlying based tables and views to support development team.
• Participated in the maintenance of data architecture, data management, such as data sourcing, data mapping, data dictionaries and data element naming standards.
• Performed systems and UAT testing, in collaboration with development and production team to ensure the systems meet with requirements in term of efficiency and performance.

Data Analyst/DBA

Confidential - Oakton, VA

• Worked as a subcontractor for AT&T Government Solution to design, develop and maintain mission critical databases for various government agencies in Washington DC area.
• Extracted, Transformed, and Loaded multiple data sources into a data warehouse using SSIS. This historical database designed mainly for reporting and analytic purpose.
• Created new and maintained existing database objects such as Tables, Views, Synonyms, PL/SQL Store Procedures, Triggers, Packages.
• Gathered systems reporting requirement from various government agencies to develop user specification and test requirements

QA/Data Analyst

Confidential - Germantown, MD

Responsibilities:

• Collaborated with Engineers and Technicians on improving the quality of the E-ZPass program in the State of New Jersey and State of New York, which was an electronic toll collection system.
• Accessed into Lane Controllers and Oracle database using SQL commands and scripts running on UNIX platform to monitor lanes condition and notified Engineers and Technicians in the field if problems occurred.
• Performed data analysis on raw data fetched from lane controller and gave suggestions, recommendation to Developers and QA Analysts on how to improve the quality of the images.