SUMMARY:

• Leveraging 25 years of overall Data Warehousing, Business Intelligence, and ETL Development experience, I seek to empower companies in the fullest use of their most valuable asset, their business data. Working in various industries: Health Care, Chemical, Mortgage, Education, Manufacturing and most recently the Banking Industry, I continue to utilize years of experience obtained through new and exciting technologies, projects, and team collaborations and apply that knowledge effectively to allow companies to succeed in achieving their mission critical objectives and project initiatives on time and budget.
• Extract Transform and Load (ETL) Technical Lead/Developer and Business Intelligence are my primary strengths as well as Database Architecture and Development but I firmly believe that communication and time management are of equal importance in achieving project success. Since a thorough understanding of Business Intelligence, Data Modeling, and SQL Languages are required in my field, architecture and normalization of raw data is of equal importance in the mining and source to target process. Coming from the Microsoft BI Stack development background, I am proactively taking a deep dive into other technologies such as Big Data, HDF Insight, Hadoop, Azure Blob and Azure Cloud. Working in both Agile and Waterfall environments allow me daily interactions with all members of the project team. From the Line of Business (LOB) contact, the business analysts, project managers, as well as technical staff, my excellent communication skills prove valuable in meeting deadlines ahead of schedule while maintaining attention to detail, data accuracy and proactive communications.

TECHNICAL SUMMARY:

• Visual Studio 2015 and 2012 utilizing Team Foundation Services and Database Projects
• SQL Server 2015/2012/ 20 08 R2 SSIS, Reporting Services 2012, SSIS, Analysis Services, DTS packages, jobs, stored procedures and views utilizing Transact - SQL. Sybase SQL
• Hive SQL/Azure Blob File Management/Azure Cloud SQL/HDInsight technologies
• BIML/SSIS Integration (Business Intelligence Markup Language)
• Understanding of full SDLC, concepts, and techniques
• Level of Effort techniques for project resource planning
• TFS project/deliverable/task management in an Agile and Waterfall environment
• SQL Server Object management and version control using Source Control
• Diagramming of Data Process Flows using Visio for review and approval by Architecture
• SQL Server migration projects utilizing SQL Compare for version controlling
• Project Management and coordination in an Agile and Waterfall environment
• Great communications skills with end users, technical staff, and management
• Systems analysis, design, and support of applications and reporting systems
• Source to Target mappings experience against many different source systems
• Consult with vendors/end users to create the best IS solutions for business requirements
• Oracle database administration, data modeling, and support for 7/8i/9i systems
• Oracle 7, 8i, 10g database administration and ETL/SQL development
• Unix system administrator for BSD, System V, and Sun Solaris
• Data interface - Unix shell scripting (all flavors of Unix)
• Conversion/Customization/Support of large-scale software applications
• End-user Training/Documentation of interfaces and systems
• Help Desk Support services for software, hardware, LAN, and phone systems

TECHNICAL SKILLS:

Databases: SQL Server 2015, 2012, 2008 R2, 2005 Architecture, Sybase SQL, Oracle 8i /9 i/10G, Informix

4GL, PL/SQL, SQL*Loader, MS Access 00/02, Progress, MySQL:

Languages: BIML, .Net C#, Transact-SQL, Bourne/Korn Shell, Working knowledge of Java, Visual Basic, VB .Net, and Perl

OS: Windows 10, Unix (SCO, Dynix, AIX, Solaris), Sun, IBM, Sequent, Wyse, Altos, 2003 Cygwin

Software: MS Office XP, Crystal Reports 9, FTP, GroupWise 6, Seagate Info 7 Mapinfo, MySQL, Citrix Metaframe, SQL Navigator, TOAD, CAST, Textpad, PeopleSoft 8 Installations, Visio, Outlook 2010, Nwadmin, DOS 6.22, HTML, Webtrends, Hyperion Analyzer, Cygwin, Source Safe, Trackit 6.5, Sales Logix, Epicor systems

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Developer

Responsibilities:

• ETL Development using Microsoft BI Stack 2015 and 2012
• Team Foundation Services Change Control process for Production Deployment fixes or enhancements.
• Effective time management on various high level projects
• Subject Matter Expert for various business applications and data source systems
• Ongoing production support and failure troubleshooting for various business applications and data source systems
• Mentor to Junior level developers and Business Analysts regarding system architecture
• Business Intelligence Markup Language (BIML) to generate SSIS packages from source files to Staging Databases. An efficient resolution to a labor intensive tasks
• Alteryx Software Development
• Database Architecture and Design
• Source to Target mapping projects for various data modeling methods
• TFS project level management (tracking of Deliverables and Tasks related to Agile/Waterfall projects)
• Azure SQL/Hive Table management and Blob storage scripting
• SSRS Development using 2015 and 2012
• Understanding of SDLC process from BRD, Dev, UAT and Production
• Maintain all SSIS and SQL objects in Team Foundation Services and SQL Source Control
• Apply “Best Practices and Standards” during ETL and development as well as Code Review process
• SQL data analysis during data profiling and discovery
• Creation of high level/low level technical design documents to line of business team and approving managers to ensure all requirements.
• Working in an Waterfall/Agile environments via a Scrum Master

Confidential

Senior Business Intelligence Developer

Responsibilities:

• Participate in requirements and design sessions as well as being responsible for the development of ETL logic to meet business requirements for reporting and analytic databases
• Design and architecture of flat data tables into Type 1 and 2 Fact/Dimension tables
• FTP/B2B expert using all forms of protocols and various security methods, i.e. key exchange, host key, and encrypt/decryption of files
• Analyze and translate functional specifications and change requests into technical specifications along with the development, testing and implementation of ETL program logic
• Analyze data sources, requirements and business rules, perform logical and physical data modeling, write prototype SQL to prove data transforms, write specs for ETL development, implement and test database design
• Design, develop, deploy, maintain, monitor, and tune SSIS ETL solutions to incrementally load Enterprise Data Warehouse and Enterprise reporting systems
• Ongoing production support and failure troubleshooting
• Develop logical and physical data models, metadata definitions and models, queries and reports
• Advises on detailed design for ETL and data allocation functions
• Collaborate with and mentor other team members
• Design and develop solutions that identify data issues and report errors for further analysis
• Helps build positive relationships between business users and IT staff
• Utilize industry best practices and generally accepted procedures

Confidential

Senior Consultant - Business Intelligence

Responsibilities:

• Lead development for ETL project using specifications provided by Data Architects
• Utilizing SSIS, VSS, and SQL Server 2012 to develop, test and validate source and destination data tables and related dimensions
• Apply “Best Practices” during ETL development
• Apply SQL Server 2012 enhancement to ETLs that eliminates the need to manage “Package Configurations”
• Manage and maintain “Source to Target” data mappings for assigned data sources and developed ETLs load processes to the staging server/database
• Documentation of ETL processes and best practices for later reference
• Development of C# RESTful web services connection script tasks

Confidential

ETL Developer/Database Architecture/Technical Lead

Responsibilities:

• Presentation of high level/low level design documents to line of business team and approving managers to ensure all requirements are met and a thorough understanding is established between the developer and the business team.
• Lead development for ETL project using specifications provided by Data Architect
• Utilizing SSIS, SSRS, VSS, and SQL Server 2005 to develop, test and validate source and destination data tables and related dimensions
• Maintain and support Executive Dashboard figures and troubleshoot discrepancies with row counts
• Maintain and support OLAP Cubes and Dimension tables as needed
• Migrate SQL Server 2000 DTS packages to SSIS 2005 to support OLAP Cubes and Dimensions as well as troubleshoot migration issues and syntax changes between SQL versions
• Apply “Best Practices” when developing ETL jobs
• Solutions architect for problematic ETL jobs, Legacy applications and stored procedures
• Technical Lead for Freddie Mac/Fannie Mae data integration projects with Confidential
• Data Architecture, field mapping, and validation for references to Legacy systems
• Create and maintain Business Continuity documents for all production ETL
• SQL Server 2005 database administration for 10 servers and 50 user ids.
• Mentor and train SQL Server developers on production processes and ETL best practices
• Perform code reviews and recommend SQL coding best practices
• Participate in enterprise wide server and database migrations
• Technical lead on many Bank related projects where progress is highly visible by the lines of business

Confidential

SQL Developer

Responsibilities:

• Lead migration of Sybase ETL process to SQL 2005 utilizing Transact-SQL, index creation and query optimization
• Created SQL testing scripts that validated tables with up to 53 column tables
• Designed and maintained Excel spreadsheet to show data anomalies between tables being validated.
• Worked with Business users to resolve data anomalies or provide explanation of why data violated business rules
• Documented and archived migration project to Visual Source Safe
• Created and maintained "Adhoc" reporting as needed using Sybase SQL and MS Access

Confidential

ETL Developer

Responsibilities:

• Development of DTS packages for 2000 and create associated scheduled jobs
• Create SSIS, Reporting Services Reports, Analysis Cubes using Visual Studio 2005
• Development of Cognos PowerPlay Cubes
• Maintenance of Windows Sharepoint Services modules
• ETL Interface Development using dynamic SQL code to build tables, update, insert, and delete statements as well as data warehouse fact and dimension table development
• Error handling development to capture defined and system errors in ETL Interface SQL code
• Configure and implement SQL Server mail to send alerts and job status to list of contacts
• Migrate and maintain MS Access databases to SQL Server as needed and support ODBC connections as required

Confidential

Database Administrator

Responsibilities:

• Responsible for the development and testing of matrix reports used by Radiology staff. The reports utilized SQL Server 2000 and 2005 stored procedures and views as well as Crystal Reports 9.
• Installed and maintained SQL Server 2005 Software and databases loaded on Windows 2003 server
• Support end users with multiple MS Access database projects, data conversions, and data mapping tasks.
• SQL Server 2000 database maintenance backup and restore databases, created backup jobs and DTS packages.
• Support end users with Excel pivot tables, and data manipulation functions utilizing SQL Server views.
• Design Unix based (Cygwin) scripts to handle special data manipulation requests such as splitting a 342 Mb file into smaller separate reports and use parameters to assign file names
• Maintain reports, views, stored procedures, and VB script in Microsoft Visual Source Safe
• Provide Application support to Radiology patient tracking system.
• Maintain data confidentiality standards, data retrieval, and encrypted transmissions per Sarbanes Oxley requirements

Confidential

SQL Developer

Responsibilities:

• Resolved year old server migration issues with SQL Server 2000 database environments within two weeks of employment. Required troubleshooting skills to identify issues with DTS packages and SQL Server architecture.
• Monitor data transfer jobs with 180 or more steps to ensure proper transmission of sales data from BackOffice system to SQL Server database. Requires extensive knowledge of Transact-SQL and stored procedures.
• Create, maintain, and modify OLAP Cubes and dimensions created by MS Analytical services
• Support end users with MySQL, Pivot table, and data manipulation functions within Excel
• Create, develop, and maintain system documentation on databases, data process flow, and IT related projects while keeping track utilizing Trackit software.
• Develop stored procedures and views to maintain a rolling four year sales/forecast/demand suite of reports utilized by Product Sourcing, Logistics, and Sales Management
• Maintain and modify web based applications using Visual Studio - VB, ASP, C# working knowledge
• Created and modify load routines from Unix to SQL Server via Progress scripting and ftp jobs.
• Installed and maintain Oracle 10g development database on Windows 2000 Server.

Confidential

Business Analyst

Responsibilities:

• Data mining and collection using Excel, Access, and SQL Server 2000
• Requirement gathering for reports, interface development, and data stream transfers
• Application support of Back office systems, accounting, and distribution systems - Epicor, SalesLogix
• Development of stored procedures and views to provide Crystal or custom reporting for end-users
• Manage and maintain access databases as needed by business
• Data conversion of invoice information from vendor and import into database for processing by accounting
• Setup, installation, and configuration of BackOffice systems for client and servers. - Epicor SalesLogix
• Development of custom Trackit reports using Transact-SQL, Excel and MS Query
• Developed ftp data transfer process utilizing MS Access and windows scheduled tasks to facilitate shipping invoice delivery and payment

Confidential

Internet Database Programmer

Responsibilities:

• Created Oracle 9i PL/SQL and SQL scripts to facilitate the Associate Portal weblog validation project
• Configured and supported Webtrends - OLAP Manager, Webhouse Builder and Reports Center
• Maintained weblog files stored on Sun Solaris Unix systems using FTP and shell scripts
• Contact person for Confidential support vendors NetIQ, Hyperion, and Quest technologies
• Created Oracle 9i PL/SQL as needed to facilitate data extractions and lists per Accounting requirements.
• Successfully resolved connectivity issues with WT OLAP Manager
• Created validation spreadsheets using Excel 2000 to show variances between Web Reports Center and Webhouse Webtrends applications. Also utilized SQL query code
• Created auto-update Excel spreadsheets to show month, weekly, and, daily counts of web logs loaded in Webtrends. Fully documented validation processes and issues resolved per Bank standards.
• Created MS Access 2000 reporting system to facilitate update and ad hoc data requests for Confidential .
• Fully documented MS Access 2000 reporting systems to allow non-technical staff to navigate within functions