PROFESSIONAL SUMMARY

• BI developer with 5+ years of experience in software development and support.
• Hands on with Confidential BI tools like SSMS, SSRS, SSIS, SSAS and Power BI.
• Experience with SQL Server, Confidential BI Stack, Teradata, Informatica, Oracle and Tidal.
• Proficient in ETL (Extract - Transform - Load) using SSIS and Informatica.
• Developed tabular cubes to enable self-service BI using Power BI.
• Strong understanding of data warehousing concepts and database fundamentals.
• Key areas of work include ETL, performance tuning, indexing, reporting and cubes.
• Self-driven and motivated but also enjoy working in AGILE SCRUM environment.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, T-SQL, MDX, DAX.

Databases: SQL Server (2008, 2012, 2016), Oracle, Teradata, Informatica, MS Access.

Tools: / Technologies: Power BI, SSMS, SSIS, SSRS, SSAS, Informatica (power-center, designer, repository and monitor), Tidal, Toad, Tidal, WinSCP, Unix, Visual Studio, BIDS, TFS, VSTF, Power BI, Excel, Power Query, Power View, DAX, JIRA, Git-hub.

EXPERIENCE / PROJECTS

Confidential

BI Developer, Seattle WA

Responsibilities:

• Part of the Azure migration team responsible for execution and validation of all assets.
• Worked on the development and support of the end to end BI system across the company.
• Touched all areas of the pipeline starting from data ingestion all the way to multiple reporting systems.
• Migrated reports built on inhouse technology (a.k.a. “blue-reporting”) to Power Bi reports.
• Provided domain and technical expertise to the team developing the “new Enterprise Datawarehouse” (EDW).
• Developed SQL views for reporting as well as necessary data models and Power BI reports.
• Supported DBA activities like managing availability groups and linked servers with “on call” support.
• Helped optimization of existing SQL jobs and SSIS packages to improve performance of reports.
• Worked in a very dynamic environment supporting multiple projects simultaneously.
• Helped with hiring of new candidates, including conducting interviews and onboarding new members.
• Used Azure, SQL Server, T-SQL, SSIS, SSAS, Power BI, Blue-reporting, Excel, Power Query and Power Pivot.

Technical Data Analyst

Confidential, Redmond WA

Responsibilities:

• Worked on the WWIS (Worldwide Inside Sales) team that generates leads from internal resources.
• Development of Excel reports, report refresh and troubleshooting when necessary.
• Administering Azure environment. E.g. create and manage servers, storage pools, users, access, etc.
• ETL monitoring, troubleshooting failures and reprocessing as necessary.
• Configuration of database email and setup notifications on success and failure of SQL jobs.
• Programmatically audit SQL jobs and raise email notifications if runtime is higher than average.
• Optimization of existing SQL jobs and SSIS packages to improve run time.
• Worked with very large datasets for ad hoc reporting and analysis for the Demand Forecasting team.
• Fixed bugs and made enhancements to Power BI reports and data models.
• Used Azure, SQL Server, T-SQL, SSIS, SSAS, Power BI, TFS, Excel, Power Query and Power Pivot.

Consulting BI Developer

Confidential, Redmond WA

Responsibilities:

• Worked on the finance BI reporting system called “ Confidential ”. The system ran daily ETLs ingesting data from 15 different source systems.
• My responsibility involved implementing business Confidential in the BI ETL pipeline. This was mostly in the form of SQL Server stored procedures.
• Periodically also required troubleshooting and bug fixing data issues.
• Another important task involved educating stakeholders with data related questions ranging from writing SQL queries to understanding business domain.
• Used SQL Server, T-SQL, SQL BI Stack, SSMS, SSRS, SSIS, SSAS, TFS and Visual Studio.
• We ran weekly sprints and used TFS for tracking.

BI Consultant

Confidential, Bothell WA

Responsibilities:

• Worked on the pre-production engineering team responsible for code review, database deployment and production validation.
• This required code integration from multiple distributed feature development teams. It was a high-pressure work environment with very short deadlines.
• Troubleshoot and debug failures during integration and deployment.
• Design, develop and / or troubleshoot ETL (Extract Transform Load) packages using Informatica or SSIS 2010 for enforcing dataflow criteria and batch data processing.
• Create and refresh SSAS cubes. Build reports using the cubes.
• Prepare database deployment scripts; perform code reviews and test complex application Confidential .
• Wrote complex queries, joins, CTE (Common table expression) and sub queries in SQL Server 2012.
• Create, schedule & monitor ETL jobs In Tidal and troubleshoot failures.
• Used SQL Server, SQL BI Stack, SSMS, SSRS, SSIS, SSAS, Informatica, TIDAL Enterprise Scheduler, Teradata, TOAD, WinSCP, Unix, Accureve, Oracle, HP Quality Centre (QC).
• Typically delivered on a biweekly release schedule using QC for tracking.

Confidential

Software Engineer

Responsibilities:

• Actively involved in analysis and design of application framework base classes for operational services (windows and web) using SOA architecture.
• Implementation of domain-driven database design for OLTP applications. Wrote CRUD (create, read, update, delete) stored procedures and UDF for OLTP databases.
• Participate in data modeling and database design sessions.
• Create reports in SSRS (Reporting Services) for analytical and statistical reports using chart controls, filters, interactive sorting, SQL parameters, etc.
• Responsible for database deployment scripts, code reviews and testing complex application Confidential .
• Design and develop ETL (Extract Transform Load) packages using SSIS (Integration Services) 2005/2008 for data transformation.
• Develop multi-dimensional objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Design and develop Database Access Layer (DAL) using Entity Framework, .NET and LINQ (C#).
• Participate in SQL performance & tuning, data modeling, schema building, data components implementation, data analysis and data migration for OLTP.
• Led production support team for legacy applications and coordinate with functional teams including Program, Operations, Testing and Tier 2 teams for functional support and deployments.
• Sql Server, SSIS, SSRS, SSAS, C#, .NET, LINQ, WCF, ASP.Net, ADO.Net, QTP, Fogbugz.