TECHNICAL SKILLS

• AWS, Amazon EC2, VPC, EMR and S3 Cloud Infrastructure, Microsoft Azure and Google’s BigQuery Cloud Platforms
• Microsoft Windows OS Platforms, Unix and Linux systems.
• SQL Server Business Intelligence Development Studio (SSIS, SSRS, & SSAS) and Data Warehouse design.
• High level of Proficiency with Relational Database Systems (RDBMS) Including MS SQL Server, MySQL, Amazon RDS and Redshift, Teradata and other MPP database platforms.
• C#, Java, Windows Powershell, Python, Ruby on Rails, Perl, Hadoop Hive Query Language.
• Excellent problem solving skills.
• Excellent business and technical communication skills, diverse experience working with cross - functional and remote teams.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue WA

Senior Consultant (BI and Data Applications)

• Designed and developed data integration pipelines across multiple data warehouse platforms and APIs including MS SQL Server, Amazon Redshift, MapReduce Clusters with Hadoop and Qubole, and Google's BigQuery platform.
• Designed and developed tools and solutions for Extraction, Transfer and Loading (ETL) of large volumes of data with great throughput using various data integrations platforms including Talend Open Studio suite, MS SSIS, SnapLogic data Integration platform, Python, Spark, Java, Ruby and Hive query scripts.
• Designed and developed application and integration of data between relational data management platforms and file based data storage systems including Amazon S3, HDFS, CSV, JSON, XML and YAML.
• Designed and developed data models, data dictionaries and OLAP cubes for data aggregation, summarization and presentation.
• Designed and developed application data integration architecture solutions and services using enterprise integration technologies (ESB) spanning business processes, systems, hardware, operating systems, applications and networking environments and platforms.
• Worked on projects and collaborated across multiple remote teams using agile development methodologies and tools including Microsoft TFS, JIRA and Confluence.

Confidential, Washington DC

Senior Consultant (Data Architecture)

• Designed and Developed Enterprise Reporting User Interface for all VA clinics nationwide, using Java based components and JasperReport. Also Implemented Resource Management Report and Dashboard.
• Performed proof of concept and proposed open source software solutions for acquiring, storing and presenting Clinical Schedule Data and Resource Management Reporting.
• Designed Data Elements and Data Model for Clinical Scheduler Application using CSV, JSON, XML and YAML data structures.
• Designed and developed Clinical Resource Management Report Templates using JasperReport BI and Reporting Tools.
• Worked on projects and collaborated across multiple remote teams using agile development methodologies and tools using JIRA and Confluence.

Confidential, Seattle WA

Senior BI Consultant

• Performed data migration and integration between MS SQL Server, MySql and other MPP platforms including Amazon Redshift and Google’s BigQuery cloud platform.
• Developed ETL pipelines for very large data sources, data mapping and validation components with SSIS packages, Talend open studio and other data processing languages like Java, Perl and Python.
• Performed data solutions architecture executing various projects to acquire and integrate data from disparate applications and APIs into a central data hub using the Amazon AWS cloud services infrastructure including RDS, S3 and EMR and Redshift running on EC2 and VPC Cloud infrastructure.
• Designed and developed new data warehouse, OLAP cubes in SSAS and implemented performance enhancement on existing cubes to meet customers’ business needs.
• Developed data presentation components based on best practice methodologies, and utilizing Tableau, Microsoft Excel, SSRS.
• Worked on projects and collaborated across multiple remote teams using agile development methodologies and tools using JIRA and Confluence.
• Performed sustained engineering on existing data warehouse systems and worked with the operations engineering team to implement business intelligence best practices.

Confidential, Chicago IL

Senior BI Consultant

• Validated architectural strategies/design of enterprise data integration applications using Amazon Redshift, Hadoop clusters and other Amazon Cloud components for optimal performance.
• Reviewed and provided recommendations as to the most applicable ETL tools to use with Amazon Redshift systems.
• Worked with application architects on identifying best tools/strategies in regards to the migrating of data applications from existing databases, Hadoop Clusters, XML, JSON and Amazon S3.
• Provide recommendations on workflow management, scheduling and co - ordination tools.

Clearwire Corporation, Kirkland WA

Data Platform Consultant

• Data Integration and ETL between various data sources running on platforms including SQL Server and MySql.
• Developed data mapping and validation components with SSIS packages and SQL stored procedures and perform logical design and data modelling.
• Review performance of existing Data warehouse system and provide recommendations to implement for better performance.
• Designed and developed processes and tools to extract data and load into OLAP databases from various data sources including Zenoss, Share point, ProClarity and Excel.
• Lead team efforts to implement automated processes for creating datasets and mapping data elements to corresponding groups and hierarchy.
• Managed vendor relationships, cross team collaboration on data inter-exchange and the BI systems data quality improvement initiatives.
• Developed data sets and multi-dimensional data objects for integrations into the enterprise data warehouse and business intelligence reports for Cognos, Crystal Reports and Micro strategy BI platforms.

Confidential, Redmond WA USA

Senior Program Manager (Business Intelligence)

• Developed and deployed integration database applications to Microsoft azure cloud platforms.
• Performed enterprise level data warehouse design and modelling, integration and extraction of business data using SSIS with multiple data sources including Excel, SQL Server databases, MS Excel & Access, XML, Proclarity, SAP (Cognos) systems.
• Developed and maintained the systems performance monitoring data warehouse for the global online division.
• Maintain Business Systems functionality and integrity during the period of rapid growth from 50GB to 4TB by employing database and data warehouse maintenance best practices.
• Worked with Internal customers to collect, analyze, interpret and present complex business data.
• Performed risk assessment & mitigation plans for key service/product releases such as Windows OCA.

Data Systems Engineering

• Performed key engineering role in the design and implementation of the change management database (CMDB) system based on MS SQL Server 2000, Data Transformation Service (DTS) & SMS.
• Completed project work on the design and development of web content management and publishing application (Atlantis v2.0) for the MSN EMEA organization using IIS, SQL Server 7.0 & MS Message queuing service (MSMQ).
• Developed customized scripts and applications to support the SMS deployment using VB Script & T-SQL queries.
• Worked on shipping progressive releases of the tools applications suite, pre-release product cycles and post release sustained engineering of the internal tools applications suite.
• Drove collaboration with the Windows Live ops security team to develop mitigating solutions to potential security vulnerabilities, thus helping the organization to meet a key requirement of the US government security audit.
• Collaborated with the architecture, design and test teams throughout the complete product development life cycle.

Confidential

Senior Project Consultant

• Successfully served as the lead project engineer in the design and deployment of the organization's internal web services performance and monitoring data warehouse system using highly effective data gathering and collection and reporting techniques.
• Developed and maintained enterprise systems availability and performance monitoring data warehouse systems using SQL Server 2000, DTS and SQL stored procedures.
• Provided Tier2/3 level support of the internal tools and platform for the investment banking division.
• Authored paper on recommendations for future operating systems platform upgrade and presented to the IT group executives and leadership team.