SUMMARY:

To expand and strengthen the range and diversity of my technical experiences as a Sr. Server Developer/BI Developer while providing leadership for cutting edge technological solutions.

TECHNICAL SKILLS:

• MCITP SQL Server DBA (70 - 443, 70-444), MCTS SQL Server 2005(70-431), 2012 (70-461), MCTS Sharepoint Configuration(70-630), Microsoft Dynamics CRM 2011 Customization and Configuration (MB2-866)
• Working towards SQL Server 2012 MCSE - BI (Completed 70-461 so far)
• SQL Server 2005: SSIS, SSAS, SSRS. SQL Server 2008: SSIS, SSRS. SQL Server 2012: MOSS 2007, PPS 2007. SQL Server 2014, SQL Server 2016
• Strong Microsoft Office Suite Skills (Word, Excel, PowerPoint, Access, Visio, Outlook, Infopath)
• C#\ADO.net (Visual Studio 2005)\VBA scripting.
• Experienced within various approaches to the SDLC, i.e. Waterfall, Agile methologies, SCRUM techniques among others; versioning within Microsoft Office applications, TortoiseSVN, Perforce, TFS
• Windows Server 2003/2008/2012
• Crystal Reports

EXPERIENCE:

Confidential, CYPRESS, CA

Sr. SQL Server Developer

Responsibilities:

• SSRS/Power BI/Dashboards for Marketing, Manufacturing clients.
• ETL/ SSIS/ Data Transformations
• Database Administration, maintenance, performance tuning, system health evaluation, optimization

Confidential

Configuration Product Specialist - Experlogix/Dynamics AX Developer

Responsibilities:

• Worked extensively with Products team to identify, fully understand, document and integrate Body Armor product line into Dynamics AX 2012 R3 / Experlogix v8.0.0.16
• Worked closely with Customer Service team to customize Experlogix GUI for different series of released products and product variants in order to create and process sales orders, new product variants, etc. as with Supply Chain/Ops team to ensure all configuration-related product design supports the production process
• SQL Server 2012 backend support/administration tasks for Dynamics AX 2012 R3 and Experlogix databases
• Developed SOP training material for all configuration-related activities.
• Assisted with training and support for the Products and Customer Care Teams as related to configurations.
• Along with other IT project managers, developed and implemented project management processes and methodologies to ensure projects are delivered on time, within budget, adhere to standards and meet customer expectations.
• Provided business analysis, and recommended best course of action focusing on business process first, technology second.
• Set up procedures and testing methods to insure the ongoing accuracy of data maintained within all applications.
• Acted as liaison between the organization and application vendors as required for implementation, problem resolution, application upgrades and bug fixes.

Confidential, ROCKLIN, CA

Sr. SQL Server Developer

Responsibilities:

• Contructed/Tested ETL batch processes for federal compliance (FCC) with user registrations and other processes.
• Created backend procedures, triggers and other database objects for web application development involving multiple internal applications utilizing SQL Server and MySQL to integrate several diverse legacy applications with current development/expansion of systems/upgrade, migration and consolidation of SQL Server 2012/2014 databases for licensing concerns.
• Worked closely with DBA team to validate and maintain system health, troubleshoot error notifications, ensure data quality and perform ad hoc queries/performance tuning adjustments as necessary.
• Database administration tasks such as backups, restores, implementation of security policy, replication, additional oversight as necessary
• Created and administered JIRA and Confluence: issues/tickets/requirements/documentation, scripts, etc. for Agile development, code promotion between environments
• SSIS ETL Processes/SSRS reports/CouchBase Server/Power BI/Subversion

Confidential, SAN FRANCISCO, CA

Database Engineer

Responsibilities:

• Compilation/Validation of financial statements for well over 50 major financial institutions, 8TB of data.
• ETL batch processes, web application development for several financial products utilizing SQL Server and other script processes to integrate bank financial statement data.
• Worked closely with Credit Research team to validate success of processes, data quality and perform ad hoc research/adjustments as necessary.
• Database administration tasks, optimization, performance tuning, oversight as necessary
• SSIS ETL Processes/SSRS reports/SSAS data marts/warehouses/Power BI/Perforce

Confidential, SACRAMENTO, CA

SQL Server Developer

Responsibilities:

• Integrations development: Scheduled ETL between Dynamics CRM and other systems including Dynamics AX, Dynamics NAV, Dynamics GP, Goldmine, Sage CRM, Sage MAS 500, and custom designed databases utilizing SSIS, Scribe, Dynamics Connector among other methods.
• BI/Reports Development: dashboards/reports/charts/gauges utilizing CRM Fetch XML, TSQL and OLAP datasources.
• Customization of Dynamics CRM components for client and demo CRM 2011/2013/2015 On-Premise and Online.
• DBA Support, optimization, security administration, upgrade/migration support for client SQL Server instances including backup and maintenance plans, high availability, modification of existing processes as necessary.
• Adherence to SDLC, Agile Methodology, Source Control/Creation of documentation/Client interactions/support as necessary

Confidential

BI\Reports Developer

Responsibilities:

• Developed, validated and published SSDT 2012 (TSQL stored procedures/VB) dashboards/reports/charts/gauges supporting Customer Support, Operations, and Sales teams for FootPrints CRM system, Datawarehouses.
• Performed data cleansing, wrote ETL SSIS packages where required.

Confidential, RANCHO CORDOVA, CA

SQL Server Report Writer

Responsibilities:

• Developed, validated and published Dynamics AX and external SSRS (TSQL stored procedures/VB) reports/charts/gauges in these areas:
• Sales
• Operations
• Purchasing
• Inventory Management
• Finance
• Field Service
• Security Keys/Audit
• Documented user requirements, detailed technical specifications, test proofs where necessary
• Research existing reports libraries for redundant reporting / usable objects.
• Ad hoc TSQL, data analysis as necessary to validate application changes, quality of data
• Adherence to SDLC
• Designed innovative reporting approaches to meet technical requirements.
• Worked in a team environment to understand business needs and Customized Dynamics AX 2009 database, Customized Hitachi Field Service Database, other databases as requested.

Confidential, Parsippany, NJ

Contract Trainer - Staff SQL Server Developer

Responsibilities:

• Implemented numerous database configurations utilizing SQL Server 2000, 2005, 2008, 2012.
• Backend development work on windows/web applications throughout each phase of the SDLC.
• 6+ years experience authoring, deploying and managing reports using SQL Server Reporting Services 2005/2008/SQL Server Data Tools 2012 for aggregation and visualization of company survey application results, Goldmine CRM, and grading/testing application results. Experience with implementation and SSRS configuration issues involving account and object permissions, utilization of various report servers and report manager.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS) including subscriptions, conditional formatting, charts, sparklines, data bars, gauges, drill-down reports, hyperlinks, cascading and multivalued parameters as well as deployment to Microsoft Office Sharepoint Server (MOSS), and PerformancePoint Server 2007.
• Supervised project weeks (involving Service Broker, SSRS, SSMS, SSIS, XML) for as many as 20 participants
• Experience with queries involving self joins, correlated subqueries and XML (Xquery, XPath, OPEN XML, FOR XML) techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options (CTE’s/APPLY/temporary, derived tables/table variables/UDF’s/etc.), and indexing strategies.
• Used C# to define and implement CLR stored procedures and functions.
• Developed backup and recovery plans based on the data availability requirements, and potential impact of data loss after considering several different backup and recovery strategies.
• Upgrade of SQL Server 2005 databases to 2008, 2008 R2
• Designed and configured database maintenance plans to meet business needs.
• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads against various databases and utilized the SQL Server Profiler tool to monitor the performance of SQL Server.
• Implemented database mirroring and replication for various databases.
• Experienced with SQL Server data partitioning techniques to better manage large tables, tables with varying access patterns, and within Multiple-CPU environments that can take advantage of parallel processing.
• Familiar with employing Service Brokers, enabling HTTP support and establishing Notification Services.
• Coordinated project grading and TA availability for each of the major program tracks.
• Offered various technical assistance (SQLServer/router/Polycom/VS2005 configurations) as an evening technical support contact.

Confidential, Sacramento, Ca

SQL Server Developer

Responsibilities:

• Created SSRS 2008 R2 reports/charts/gauges for Microsoft Dynamics 4.0/2011 CRM solutions according to lengthy specifications
• Clients include Federal Agencies, CA Dept. of Financial Institutions, Confidential, and others.
• Provided complex report data via required standards/XML schema
• Example of one report provided - over 20 pages regardless of font/data - 28 separate datasets:
• Maintained part-time relationship providing SSRS solutions after late 9/2011

Confidential, Los Angeles, CA

Developer/Programmer

Responsibilities:

• Created PHP/MySQL based secure ETL solution for MySQL-based Web Portal to SAP and vice versa
• Extracted Ecommerce orders from Magento Web Portal, imported price and inventory updates from SAP.

Confidential, Folsom, CA

Application Developer

Responsibilities:

• Worked on a team providing support during development of an inbound shipment data visibility and transportation cost mapping reporting application.
• TSQL, SSIS, SSRS, Team Foundation Server.

Confidential, Folsom, CA

Data Analyst

Responsibilities:

• Daily formal and adhoc reports for business teams via TSQL against 220+ table Confidential database, batch job monitoring and validation of EDW Extracts/data transformations/backups and restores/SSIS packages/SQL Server Agent jobs.
• Level 3 production end user support for close & reporting application with SQL Server backend/account reconciliation tools.
• Ensured/validated data quality/compliance through defined Sarbanes-Oxley control processes.
• Various general development tasks designing reports, stored procedures, tables, scripts, SSIS packages.
• Adhered to ITIL framework best practices for incident, problem, change management in BMC Remedy/SAP Solman.
• Assisted with AssureNET financial compliance application upgrade migration/testing plans, cases, defect logging and troubleshooting/User acceptance testing (utilizing HP Quality Center).

Confidential, Los Angeles, CA

Developer/Programmer

Responsibilities:

• Consultant for several company produced websites utilizing the LAMP platform and others utilizing C#/.Net/ASP.Net/ADO.Net web applications with a SQL Server 2005 Express Edition backend.
• Involved in creative concepts/writing for various campaigns.

Confidential, San Francisco, CA

Training Specialist

Responsibilities:

• Conducted training sessions nationwide at various Cendant Hospitality locations (100% travel required).
• Configured hotel software applications (Foxpro/Server 2003/XP Professional), conducted hardware installations and offered live technical support.
• Partnered with other team members and management to provide standard and consistent training, quality and completion of installation projects.
• Intermediary and point of contact between project management teams, vendors and clients.

Confidential, Tracy, CA

General Manager

Responsibilities:

• Actively managed employee relations, training, payroll, maintenance expenditures and supervision.
• Occupancy Growth of 5.8% for first full year on location (3/04-2/05), 111 rooms total.
• Total Revenue growth 7.0% for first full year.
• Ranked number one in region (92 motels) for 2004 on customer service complaint index (Rating of 1.21% was a 4.24% improvement over last year; index is based on corporate complaints per 10,000 rooms sold).
• Awarded silver medal for six straight months of excellent customer satisfaction survey results
• Controlled daily accounting, purchasing and receiving.
• Utilized financial statements for forecasting, budgeting, marketing, inventory and staffing.