We provide IT Staff Augmentation Services!

It - Technology Lead Resume

Redmond, WA

SUMMARY:

  • Experienced professional in the IT/software field as a Confidential, data engineer, business insights/system/data analyst, ETL architect and BI developer role
  • Certificate in Data Science from University of Washington
  • Exposure to Agile/SCRUM methodology

TECHNICAL SKILLS:

Statistical tool: R

Big Data Platforms: Hortonworks, Cloudera, Azure

ETL Tools: Azure Data Factory (ADF), Informatica

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

PROFESSIONAL EXPERIENCE:

IT - Technology Lead

Confidential, Redmond, WA

Responsibilities:

  • Worked on building ADF CHEF XMLs that would create ADF pipeline on deploying.
  • Wrote USQLs to load data into Azure Data Store.
  • Unit Testing thru Gherkins scenario testing on Visual Studio, and test each dataset for Extract and Merge Scenario into Data Lake Store.

Technology Used: Hadoop, Teradata, R, Oracle, SQL Server

Tool: Used: Adobe Analytics, Excel, PowerPoint

Senior Business Insights Analyst

Confidential, Bellevue, WA

Responsibilities:

  • Analysis of data and derive insights for business casing for web & app product managers to drive improvements.
  • Using site analytics tools (Adobe Analytics) to gain insights
  • Construct executive level presentations to communicate complex analytical findings in a clear, concise, and decision impacting manner.
  • 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) and stitching data to tell a story.

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

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

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
  • Created Excel pivot tables to summarize, analyze and present the data to business users
  • Communicate findings in well written structure and propose solutions

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
  • Drive the collection of new data and the refinement of existing data sources.
  • Support management and business with insightful and clear analyses using the techniques; data mining; as well as explaining, creating, and providing a concise and clear report.
  • Provide timely and accurate status to business and help resolve issues.

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

Lead ETL Consultant

Confidential, Denver, CO

Responsibilities:

  • I was the lead ETL consultant on Data Migration in Siebel Ticketing System.
  • My role was to load large amount of data for different entities like accounts, products, asset and their agreements into Siebel EIM tables from various systems like SAP, Nortel, Remedy, Ubiquity and Maestro thru Informatica ETL jobs.

Hire Now