Data Warehouse Developmen Resume Profile

SUMMARY

TECHNICAL KNOWLEDGE AND SKILLS

Databases: SQL Server 2012/2008R2/2008/2005/2000,MySQL 5.x
Languages: SQL, T-SQL,C , Perl, MDX
Data Model Tools: Visio, Embarcadero, SQL Server database diagram.
ETL/BI Tools: SSIS, SSRS, SSAS,SharePoint, Business Objects BO DataIntegrator and
Crystal Reports,Talend Open Studio, Amazon's ETL tool.
Amazon Cloud Svcs: Amazon EC2 with SQL Server DB, and Amazon RDSwith MySQL DB engine.
Knowledge of NoSQL databases DynamoDB, CouchDB, MongoDB.
WebAnalytics: Google's - Adwords and DoubleClick, Yahoo's andMSN's onlinereporting, and
Adobe's Omnitureonline marketing analytics.
Web Development: ASP.NET, CSS, HTML,XML, JavaScript, AJAX, SharePoint 2013/2010.
De Environment: VisualStudio Team Foundation, Visual Studio 2013/2010/2008. Linux, Ubuntu,
Windows, and Cloud Computing AWS-Amazon Web Services .
Version Control: GIT, Visual Studio Team Foundation Server TFS , Subversion SVN , and Perforce.
Code Review: Atlassian Crucible

PROFESSIONALEXPERIENCE

Confidential Database Developer

Code, design, and deploy data changes,modified databaseobjects and SSIS packages.
Collaborate with other developers to develop database structuresand automate database solutions.

Confidential Database/BI Engineer

Database/Data Warehouse Development:

Work with Senior Developers, Product/Project Managers in designing data model and processes for new projects and features to process data pulled from Microsoft Lync's databasesin supporting on-premise products, on-line and cloud products that uses Microsoft's cloud infrastructure.
BI Development:
Design ETL processes using SSIS to pull data from Microsoft Lync's databases and data files.
Expand existing cubes in SSAS by adding new measure groups and dimensions to support new analytical features, and design new reports in SSRS.
UI Development:
Design dashboards and reports with PerformancePoint Dashboard Designer in Microsoft's SharePoint.Added enhanced C custom code and scripts where SSRS and SharePoint's properties and featuresare not supported.

Confidential Software Development Engineer, Contractor/Database Engineer

Built databases, stored procedures, and ETL processes using MySQL, RDS with MySQL DB engine, SQL, AmazonETL tools to pull and processdata.

Wrote automated procedures to provide important data features for reporting of AWS Customer data, usage data of AWS cloud products.
Built database/data mart and stored procedures for internal reporting purposes.

Confidential Business Intelligence Developer, Contractor

ETL: CreatedETL processes to load global paid-search marketing data that extracted fromGoogle's Adwords, Yahoo's, MSN's reporting websites, and Adobe's Omniture online analytics. Then loaded these daily files from sftp server into data warehouse using SQL Server, SSIS, and T-SQL.
UI: Modified existing code and configurations to improve UI's functions of Reporting Services using Java Scripts and CSS.

Confidential Database Engineer, Contractor

Created and maintained SQL Server and OLAP servers using Amazon EC2 instances to support storage of new data warehouses and cubes in the cloud.
Defined and designed dimensions and fact tables in building new data warehouseswith requirementsand inputs from business users, Product Mangers and Technical Architect.
Developed ETL processes that updated the daily coming-in data extracted from Google's DoubleClick for Advertisers DFA for various advertisersusing T-SQL, SSIS, and Talend Open Source ETL tool. Built, optimized, and deployed cubes using SSAS for reporting and analysis purposes.

Confidential Programmer

Data Warehouse: Designed ETL processes using SQL Server, T-SQL, Business Object Data Integrator, and SSISto get the data-feed into Data Warehousein supporting company's analytic tools and international trading services.
Business Intelligence: Developeddashboard reports, graphs/distribution charts, and cubesusing T-SQL, SSRS and SSAS.
Web Development: Enhanced existing ASP.NET intranet websites by creating web pages written in C that is usedfor various reporting purposes andto monitor Data Warehouse data and processes.

Confidential Computer Software Engineer

Developed and maintained window-application solutions using Access, VB6,and SQL Server databases to support the company's Reverse Mortgage Loan Origination System, including retail, wholesale, and correspondents.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship