We provide IT Staff Augmentation Services!

Senior Business Insights Analyst Resume

Bellevue, WA

SUMMARY:

  • Certificate in Data Science from University of Washington
  • 14 years of experience in the IT/software field as a data engineer, business insights/system/data analyst, ETL architect and developer role
  • Experience on Azure, Big Data Platform, Hadoop, Hive
  • Experience working with statistical analysis tools like R
  • Worked in Agile and Full Life Cycle Implementations

TECHNICAL SKILLS:

Statistical tool: R

Big Data Platforms: Hortonworks, Cloudera, Azure

ETL Tools: Azure Data Factory (ADF), Informatica

Database applications: Teradata, Oracle, SQL Server, Azure DB Adobe Report Suite, Adobe Analytics

Programming Languages: PL/SQL Knowledge about Unix Shell scripting,Rally, Jira, Remedy, Visual Source Safe, XPlanner, Bugzilla, Sharepoint and Mercury Quality Center, Advanced Excel Functions

PROFESSIONAL EXPERIENCE:

Senior Business Insights Analyst

Confidential, Bellevue, WA

Responsibilities:

  • Analysis of data and derive insights for business casing for web & app product managers
  • Do research projects by exploring data using SQL and R and finding new opportunities
  • Query data from Hadoop and relational databases (Teradata, MS SQL server). Demonstrated strong competency and comfort working with and analyzing large sets of data.
  • Construct executive level presentations to communicate complex analytical findings in a clear, concise, and decision impacting manner

Technology Used: Azure, ADF, SQL Server, PowerBI

Senior Data Engineer

Confidential, Redmond, WA

Responsibilities:

  • Analysis of the data from various source and define their relationships
  • Develop the backend model and entities
  • Create ADF to move data from on - premises database/files to Azure
  • Correlate data from various sources and summarize the data to derive meaningful insights

Technology Used: Azure, ADF, SQL Server, PowerBI, Azure DB, Kusto

Senior Data Engineer

Confidential, Redmond, WA

Responsibilities:

  • Lead the development team, shipping completed work items
  • Participate in Business Outcomes in redefinition some of the KPIs that the team measures
  • Preparing Onboarding Handbook for SWEs for onboarding to FiPS store
  • Communicate status in well written structure
  • Work in Sprints, Agile/SCRUM methodology

Technology Used: Oracle 11g, Unix, Informatica 8.6, OBIEE, Excel Pivot

Data Engineer

Confidential, Seattle, WA

Responsibilities:

  • Performing key reconciliations to ensure complete, accurate, and timely financial reporting.
  • Created complex sql queries to extract and report on the data
  • High level of interaction and synergy with Global Finance Systems
  • Created Excel pivot tables to summarize, analyze and present the data to business users
  • Communicate findings in well written structure and propose solutions
  • Work in Sprints, Agile/SCRUM methodology

Technology Used: Adobe (Omniture) Analytics, Hortonworks HDP 2.1, Tableau 8.1, Rally, SQL Server 2012, Informatica 9.5, Informatica 9.1, Oracle 11g, Teradata 13.10, Unix, Aster 5.1

Data Analyst

Confidential, Bellevue, WA

Responsibilities:

  • Participate in KPI (Key Performance Indicators) requirement discussions and transformed them into technical specification for developers
  • Hands-on experience on big data platform (Hive QL, Hadoop, HCatalog), on ETL tools like Informatica, on Reporting tools like Tableau
  • Perform data analysis to interpret big data and search for different patterns in order to discover new insights.
  • Drive the collection of new data and the refinement of existing data sources.
  • Summarize written findings, publicize results in form of Excel reports, Power Point Presentation and Word Document
  • Support management and business with insightful and clear analyses using the techniques; data mining; as well as explaining, creating, and testing data in order to provide a concise and clear report
  • Provide timely and accurate status to business and help resolve issues.
  • Exposure to Agile/SCRUM methodology
  • Presented business team the funnel visualization on Tableau for web tracking, presented capabilities by integrated various data sources like which channels drives visitors to tmo website and which keywords were most successful.
  • Data governance and monitoring data quality.

Technology Used: Informatica 8, Oracle 10g, Siebel 8, UNIX Scripts, Informix, Autosys

Lead ETL Consultant

Confidential, Denver, CO

Responsibilities:

  • Involved in the entire life cycle of the project.
  • Participated in requirement meetings and transformed requirements into design documents, like mapping the data attributes from Legacy systems to new system for Data.
  • Developed Informatica mappings, reusable sessions, workflows and Siebel EIM Process.
  • Developed Oracle Stored Procedure.
  • Created Unix shell scripts to perform elementary file processing.
  • Worked together with the offshore team and answered requirement and technical questions.
  • Performed data cleanup and participated in performance tuning
  • Supported UAT Users by quickly fixing bugs
  • Provided post production tier-1 support.
  • Performed data analysis to investigate any data issues reported by business users.

Technology Used: Informatica 8, Facets 4.31, ODS, Oracle 10g, UNIX Scripts

Senior ETL Consultant

Confidential, Denver, CO

Responsibilities:

  • Designed and implemented Informatica mapping and workflows, Oracle Functions and Packages.
  • Performed data cleansing, data profiling and data transformation.
  • Created Unix shell scripts to perform file processing and execution of Informatica workflow
  • Prepared Unit Test Cases and documented test results.
  • Documented Release information and versioned the database objects, ETL components in Harvest
  • Provided Production release support
  • Worked with client to troubleshoot data issues that arise.

Technology Used: Datastage 7.5.2, Facets 4.31, Sybase, MS SQL Server 2000, Unix Scripts

ETL Consultant

Confidential, Portland, OR

Responsibilities:

  • Involved in Requirement Gathering, Design, Code, testing and user support
  • Designed and developed Datastage jobs to load Benefit Description System SQL Server tables from Facets 4.31
  • Developed SQL Server and Sybase stored procedures.
  • Versioned the database objects, ETL components in Harvest
  • Implemented alerts to Plan Admin for missing benefit information and group information.
  • Involved in support for Integrated and User Acceptance test.

Technology Used: Informatica, Oracle 9i, Unix, Business Objects Reporting

System Analyst/Developer

Confidential, St Louis, MO

Responsibilities:

  • Developed Informatica workflows for extracting data from mainframe legacy source system into to finance Datamart data mart.
  • Troubleshooting, bug fixes and modification of existing functionality.
  • Provided on call production support.

Technology Used: UNIX, Sybase Stored Procedure, MicroFocus COBOL

Developer

Confidential, Dayton, OH

Responsibilities:

  • Development, Maintenance and enhancement for stored procedures in Billing and Invoice application.
  • Responsible for analysis of the system and gather intricate details to assist in defining the PowerInvoice system.
  • Played a major role in quality assurance activities.
  • Prepared reports for the defects that occurred during the various phases of project life cycle

Technology Used: PL1, COBOL, DB2

Hire Now