Web Developer,resume Profile
UsA
Summary
- Managed several complex BI initiatives, including project planning, ROI calculations for budgeting, communication, and iterative development
- Participated in all phases of the data warehouse lifecycle including requirements gathering, testing, budget politics, and implementation
- Lead the process of system development, including planning efforts and monitoring systems development, coordination with other groups, review of deliverables and communicate status to stakeholders.
- Experience with SSIS, SSAS, SSRS on SQL Server 2005 through SQL Server 2012
- Able to analyze and propose solutions which take advantage of business and technical knowledge of complex issues
- Design and develop automated, scalable, and reliable ETL processes using SSIS and T-SQL
- Strong T-SQL performance tuning skills with a focus in query optimization, minimally logged operations, the set based processing methodology, and appropriate index design
- Utilize .Net CLR assemblies, PowerShell, and console applications to extend the possibilities of SQL Server
- Agile development and Scrum master experience in SCRUM environment
- Proven leadership experience from both military and civilian positions
Technical Expertise SQL Server 2000 / 2005 / 2008 / 2008 R2 / 2012, T-SQL, MDX, PowerPivot, PowerView, BIDS, MS Visual Studio 2008 / 2010, SSIS, SSRS, SSAS, Powershell, Sharepoint 2010, CLR, VB.Net, C , Team Foundation Server
Professional Experience
Confidential
Manager, Business Intelligence Systems
- Oversee all BI projects from start to completion
- Capture Business Requirements and Justification
- Architect solutions
Confidential
Data Warehouse Specialist II
BI Team Lead
- Accumulate business requisites from business stakeholders as well as work with other components of IT organization to fully understand source system information.
- Architect star schemas which are used to measure process KPIs.
- Build and process cubes and Tabular models which feed executive reports and dashboards.
- Design, develop, test, and deploy scalable ETLs for Microsoft Business Intelligence solutions.
- Support agile development processes for fluid distribution of data to the data warehouse.
- Participate in all parts of the BI development including data mart design, cube development, report/dashboard development, and ETL development.
Confidential
Database Administrator / Developer
- Administrated thousands of databases across 60 servers and multiple domains
- Build T-SQL, PowerShell, SSIS, and CLR assembly based procedures to process data, extend the database abilities, and perform routine administrative tasks
- Led efforts to get active directory properly configured so Kerberos delegation could be enabled, reducing users inherited permissions through linked servers
- Created, designed, developed, tested, and documented an SSIS framework used to fully automate customer data ETL while minimizing the need for package maintenance
- Conference with customers and other project team members to insure that the customer business rules get implemented correctly
- Batch process customer data to insure data is quickly loaded and processed as a set when possible
- Successfully migrated over 8000 projects from MS Project 2003 to MS Project 2007 then upgraded to MS Project 2010
- Reverse engineered Project Server Flex reports from a web application to SQL Server Reporting Services
- Designed and implemented a process to archive customer data from SAS storage to a cheaper SATA storage array to support customer reprint requests while keeping costs down
- Established performance baselines with performance counters and capacity analysis
- Provide support to other teams when database development or administration are required to meet customer service level agreements, increase uptime, or improve query performance
Confidential
Programmer Analyst
- Design and develop web based reports using Adobe Coldfusion and SQL Server 2000
- Coldfusion web development for Renweb School Management Software company
- Write various SSIS packages, CLR, and VBA procedures, to extract data from existing databases from various database types including Oracle, SQL Server, MySQL, Firebird, Filemaker Pro, Access, and various flat files and analyze, port, convert, and map, the data and all corresponding headings/titles accurately into CSV ETL , ODBC format
Confidential
Web Development Consultant
Worked with IT staff at Exact Software to troubleshoot and fix issues related to PHP using adodb library and MS SQL Server 2005 during East-West application integration.
Confidential
Webmaster
Designed and developed the College of Engineering website for Arkansas State University
Confidential
Web Developer
- Documented, designed, and developed OO PHP modules for e-commerce web applications
- Created software requirements specifications for several web applications
Confidential
Engineroom Supervisor
- Supervised 40-50 men including maintenance, QA, and operating the Engineroom, both at sea and in port. Responsible for ships propulsion, electricity, and water supply at sea.