SQL ETL Developer/BI Architect Resume

SUMMARY:

Accomplished IT Leader with a keen understanding of teh Information Technology arena with ability to leverage lessons learned with best business practices.
Successful record of consistently employing professional/technical skills to design, install manage, and maintain high quality, cost - effective, advanced information systems and networks.
A highly analytical thinker with talent for identifying, analyzing, improving, and transforming complex work processes into streamlined, automated tasks.
Success in managing user expectations with excellent communication and personal interaction skills.

TECHNICAL SKILLS:

Office Productivity and SAS: SharePoint, MS-Project, MS-Office Suites, MS Visio, MS Streets & Trips, MS Access, IBM SPSS Modeler, IBM DB2, IBM IOC, IBM Data Studio, MS IIS, VBA

Programming Languages: PL/SQL, T-SQL, MySQL, C++, C#, Java J2EE, JavaScript, XML, JSP Servlets, XHTML, AJAX, SOAP, DOS, Basic, Visual Basic, dotNet, Linux, Java Beans, Easylanguage.

PROFESSIONAL EXPERIENCE:

Confidential, Huntersville, NC

SQL ETL Developer/BI Architect

Responsibilities:

Developed C# script task SSIS parallel processing package for converting 100K+ MS Access databases to SQL Server
Optimized queries, tables and stored procedures using execution plan analysis, indexes, partitions and file groups.
Created multi-level dynamic SQL scripts.
Designed and implemented dual function data warehouse with SSAS.
Installed and integrated Hadoop cluster. Queried Hadoop using Map Reduce, Hive and Pig.
Installed configured, backed up and maintained MS SQL Server servers. Established and maintained different types of SQL Server licensing configurations.
Set up and configured NetApp SAN and migrated databases from stand-alone servers to virtual servers
Set-up and configured Tableau and used Tableau for formatting dashboards and reports.
Created template using dynamic SQL for creating databases with multiple partition schemes, partitions and file groups
Upgraded all existing 2008R2 SQL Servers to SQL Server 2012.
Created KPI and other reports using Tableau, Excel, Power BI, SSRS and Report Builder.
Completed MS Dynamics CRM to Salesforce transition project in 90 days saving $100k.

Confidential, Charlotte, NC

Data Analyst / Database Developer

Responsibilities:

Automated integration of all company project data and financial spread sheets into PortView bubble graph application using advanced Excel formulas and VBA.
Analysis of business units and design and implemented SQL Server database.

Confidential, Charlotte, NC

SQL DBA / Data Warehouse Developer

Responsibilities:

Designed and prototyped applications for real estate investors. Wrote user manuals and test scripts, designed help screens and implemented User Acceptance Testing (UAT)
Managed 18 coders and designers to develop, test and implement applications for secure online usage utilizing Agile Methodology with some aspects of SCRUM.
Starting from flat files, scrubbed and configured data. Created ER Diagrams and normalized 234 columns of information in 11 tables, 3 dimension tables and a fact table.
Loaded data into SQL Server, normalized tables, and created warehouse using advanced T-SQL programming, triggers, calculated columns, indexing, stored procedures, views and other features.
Performed and automated ETL with SQL Server BIDS, Excel, Potter's Wheel and SSIS.
Identified 120,000 unique addresses and created table of GPS coordinates utilizing Google Maps API and alternate XML formatted GPX file source.
Designed and created real estate data warehouse, containing over 1M records of MLS listings.
Used SSAS (SQL Server Analysis Service) for aggregation, building cubes and modeling algorithms and data mining.
Applied derived value algorithms to OLAP Cubes for predictive modeling of neighborhoods and property valuations for providing detailed answers to management issues and inquiries.
Used SSRS (SQL Reporting Service) with Report Builder for presentation of data.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship