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.
