SUMMARY:

Results oriented technology strategist that implements workable solutions, maximizes levels of performance. Solid management skills, with the capability to lead and motivate high performing teams forming cohesive team environments and maximizing individual performances. Demonstrated success implementing multiple sets of technologies and platforms as well as setting standards, procedures and process that improve business functionality. Capable of managing direct reports, teams of project based consultants during engagements, managing budgets as well as negotiating contracts.

TECHNICAL SKILLS:

Salesforce.com Applications & Infrastructure: Sales Cloud, Service Cloud, Data Loader, Force.com Explorer, Workbench, Force.com Eclipse IDE, Developer Console, Data.com, CRMFusion - Demand Tools, DupeBlocker, Salesforce1, Salesforce Mobile, Salesforce for Outlook, SOQL, Change Sets, Sandbox Management, Apex Classes, Apex Triggers, Visual Force Pages, Custom Settings, User and Profile Management, Role Hierarchy, Territory Hierarchy, Security Model, OWD Sharing Rules, Mobile Configurations, Salesforce Offline Edition, Data Integration, Person Accounts

Database Architecture, Development, ETL & BI: MS SQL Server 2016-6.5, Tableau, Domo, Transact-SQL, bcp, Stored Procedures, Triggers, Functions, Views, full text search, SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), SQL Server Data Tools (SSDT), Cubes, Cast Iron Systems, Talend, Oracle 10g/9i/8i, PL/SQL, MS Access, Sybase Power Designer, ERWIN, DB Artisan, TOAD, sqlldr, imp/exp, kshell/UNIX scripting

Application Architecture & Development: SalesForce.com, force.com, GIT, Angular, Visual Studio, TFS, VB.NET, C#, AJAX, TELERIK RadControls, Infragistics, .NET, ASP.NET, Typed Datasets, ASP, ADO.NET, JavaScript, HTML, XML, CSS, VBScript, Visual Basic, Java, Dreamweaver, FrontPage, MS Office, ODBC, JDBC, VSS

Networking & Hardware: TCP/IP, DNS, FTP, HTTP, SCP, SSH, putty, SSL, LAN, WAN, NAS, Server & Workstation Hardware

Operating Systems & Application Servers: Windows Server 2016/2012/08/03/00/ NT, Hyper-V, Windows 8/7/Vista/XP/ME/98/95, IIS 7/6/5, Mac, iOS, Sun Solaris UNIX, Red Hat Linux

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Management and ownership of all salesforce related SDLC phases for a multi - tenant environment shared across 4 separate business units consisting of Chicago Freight Car Leasing, Chicago Freight Rail Services, Union Leasing and Xced Aviation Services.
• Build full data integration sync process including scheduled jobs on hourly and nightly basis between salesforce and in house as well as third party databases. These processes leverage salesforce dataloader as well as internal web services for extracting, transforming and loading data to/from salesforce for integration into analytics data warehouse feeding tableau dashboards. Design new sandbox management and code deployment process as well as lead the data integration of in house systems data exposed across salesforce orgs.
• Migrate multiple internal processes from being managed via spreadsheets and email to fully shared environment within SFDC. One example includes inventory management for the Chicago Freight Car Leasing business which now manages all train car inventory with salesforce rather than within multiple spreadsheets in excel. The team now has instant visibility to car status, location, and movement for all train cars from and to customers, as well custom apex code for matching inventory when new opportunities arise. Additional process of Credit Assessment approvals for new customers and customers that have potential market risk, including approvals and notifications to C suite.
• Manage weekly meetings with designated business unit heads to gather new functionality requests and manage back log and status updates.

Confidential

Lead developer and business analyst

Responsibilities:

• Responsibilities include design and implementation of the solution including custom layouts, fields, record types and security model for account and contact management, as well as tasks and events. Additionally responsible for coordinating with several other developers, as well as requirements gathering sessions with end users, project charter, business requirements documentation and delivery.
• Enhance custom java application and salesforce web services to sync data from in house systems to salesforce and vice versa. Account supervision data includes PII data which is restricted to viewable in production only. Project was handed over in a non-working state with almost two years of development work having already been spent. Was able to resolve challenges within several months and the programs are currently running in the production environment.
• Responsible for the build out of custom objects, Apex controllers, Apex pages, Custom Settings on the salesforce org as well data loads and data cleansing from various vendor systems into the salesforce.com environments.
• Develop Visual Force pages and controllers in order to automate a customer matching process needed to sync two separate systems. End to end process leverages a nightly file transfer from vendor via sFTP, loads and cleanses the data via SSIS and loads into custom object via the salesforce command line DataLoader(CLIQ). The UI component consists of apex page and custom controller where the user is able to match an existing salesforce record to the other system and enable the syncing of the record. Leverages an external web service from Trillium Software to normalize the data as well as a JSON generator and parser to serialize and de-serialize the data sets all from within the controller in salesforce. In order to have high quality matching records returned to the user the matching algorithm leverages the Levenshtein distance algorithm when doing name comparisons and weighting.
• Enhancement of custom .NET executable utilized to update an internal advisor portal web site. Process connects to Salesforce web services on a schedule of every 15 minutes and pulls down updated information from standard and custom objects to be populated into the portal web site.
• Enhancement of a custom .NET application which maps PDF form signature coordinates to a database in order to make the forms enabled to sign via digital signature process.

Confidential

Responsibilities:

• Integrate specific in-house data to salesforce via custom visual force pages, custom apex classes via apex callouts and consuming JSON data objects from an external .NET web service.
• Act as architect and developer for entire implementation of a salesforce automation project, including all standard and custom object setup and configuration, security, role and profile models, as well as all workflows, email alerts and custom apex visual force development. Included salesforce1 implementation leveraged via iPad/iPhone by the internal sales team.
• Liaise directly with business for requirement gathering, prioritization and delivery schedules.
• Build integration processes for the data extraction salesforce customer account and contact data into in-house SQL Server data warehouse for analytics processing.
• Responsible for the build out of the Domo BI Reporting dashboards, financial dashboards and business trends.
• Management of the Domo environment including setup of source data, datasets, Domo Workbench scripts and scheduler.
• Delivery of SFDC enhancements including implementation of SFDC as the customer master.
• Ownership of QA and Production database deployments and support including all SSIS, SSAS and SQL Agent job schedules.
• Support and enhancement of several existing .NET in-house applications built in C# and VB.NET as well as creating new tables, stored procedures, views etc. as necessary.
• Integration and configuration of Act-On marketing automation leveraging the salesforce including installation and management of the AppExchange package.
• Integration and configuration of HubSpot marketing platform to implement automatic HubSpot lead creation and qualification into the salesforce org.

Confidential, Deerfield, IL

Systems Consultant & Manager

Responsibilities:

• Lead the phase 3 implementation of the Bio360 salesforce.com instance to work towards a one stop shop model. Built integrations for external applications and web sites. Integrated external reporting components including Cognos reports and SharePoint sites. Enhanced functionality for field sales programs components enabling a savings of over a million dollars paid to third party vendors annually. Integrated the call center Customer Interaction Center (CIC) VRU for customer screen pop in SFDC when routed a call. On-Board additional Market Access team and provide training as well as content and materials.
• Lead and manage a team of FTE’s and Consultants utilizing agile methodology to prioritize and deliver product backlog. Review all functional enhancements to ensure architectural soundness and plan deployment schedule.
• Subject matter expert for salesforce.com platform integration for custom Confidential mobile apps. Worked with multiple agencies on building customized sales aid iOS apps. Leveraged existing security model within SFDC for account management and enables activity tracking after sales reps completes detailing the healthcare provider.
• Manage user licenses, acquire additional as necessary via PO process and plan for future growth by interviewing key stakeholders. Work together with purchasing and supplier management on a 5 year SFDC license renewal.
• Salesforce developer and administrator, responsible for Salesforce.com UI and Custom Object development, data updates, Mobile configuration, user/profile creation, Record type creation, territory hierarchy setup and maintenance. Utilize Apex Data Loader for mass updates to specific records in SFDC as well deletes and reloads of updated data sets for custom objects.
• Lead the creation of custom tables and views which populate territory hierarchy, territory assignment rules as well as custom fields on Accounts object. Integration is done by building the SFDC data sets from an SQL server data store and upserts into SFDC org via Cast Iron Appliance.
• Creation of Custom Apex module allowing vendors to post files into our SFDC instance. During upload the file is parsed into custom objects and as well as being summarized and reported against. An email workflow then takes this summary and emails it to necessary sales team members to act on new leads. Using apex classes, apex components, email templates, custom settings, workflow and scheduled job for email delivery.
• Delivered the phase 2 of the Bio360 SFDC project, including custom module for scheduling speaker programs, enabling opportunities and populating records via Cast Iron based on business rules, implement route planning with Field Day and a custom forecasting module.
• Defined the process and coordinated the effort for cleanup of duplicate accounts from the org as well as Confidential system. Utilized CRMFusion - Demand tools for de-duplication as well as DupeBlocker to prevent user created duplicates.
• Lead an iPad pilot with the BioScience sales team. Educated and supported the users on the iPad during and post pilot. Setup a sharepoint site for organization of reference materials, suggested apps, frequent Q&A and surveys. Determined opportunities for cost savings including print, laptop replacement and Blackberry smart phone replacement. Engaged with multiple vendors for implementation of custom iPad apps builds for Sales team. Provided guidance on architecture and integration with Confidential 's SFDC environment. Full iPad sales team rollout in early 2012.
• Interface and data architect for phase 1 implementation salesforce.com CRM for Confidential BioScience commercial applications. Responsibility includes online component configuration, backend integration design, mobile configuration, offline desktop application and outlook integration. Implementation includes four separate US sales teams and their respective marketing and finance teams and overall Customer Operations team.
• Architect and lead the development of a new .Net web interface tool for loading files. Application loads data from user specified excel files and validates data is in the right formats and meets specific business criteria before it is loaded to data warehouse environment for reporting purposes. Responsible for full SDLC including leading development, design, system testing as well as application deployment and maintenance.
• Define new capabilities for Confidential CDIT application including in corporation of a dynamic UI and ensuring the application will support expandable provider datasets. Conceptualize dynamic mapping as well as dynamic validation to allow for quickly defining a new provider dataset and changing validations based on provider. Ensure design, code and standards are being adhered during review sessions with development team.
• Support & enhance multiple additional applications including a desktop application for Redistribution Testing(VB, SQL Server 2005 Express), Sales Forecasting web application(Apache Tomcat, Java, JSP), FiebaFreedomFighters web app(AJAX toolkit, Flash), Hierarchy Maintenance Application (HMA), Hospital Name Maintenance (HNM)

Senior Systems Analyst

Confidential

Responsibilities:

• Lead development of a .Net based the Customer Data Integration ( Confidential ) application dealing with Confidential and competitor data from Third party sources to enable building a Master Data Management architecture. The application encompasses loading datasets from various sources, validation processing, exception resolution, classification and quality matching of all customer records to populate a slowly changing dimension data warehouse. Work with on/offshore resources to ensure successful delivery of application on time with required functionality. Lead weekly code reviews, UI design reviews and ensure application coding standards are being implemented properly.
• Developed console based application to pull shipping information from UPS Quantum View web services. Data is pulled down from UPS in an XML format and then loaded via SSIS to SQL server backend database. Key implementation deliverables: XML Web service File retrieval, dynamic parameter based scheduling, kickoff from ETL or job scheduler, archiving and logging. Data was then integrated to the Customer Analytics data warehouse to provide business users with detailed snapshot and metrics of package deliveries.
• Support & enhance multiple applications including a desktop application for Redistribution Testing(VB, SQL Server 2005 Express), Sales Forecasting web application(Apache Tomcat, Java, JSP), FiebaFreedomFighters web app(AJAX toolkit, Flash), Hierarchy Maintenance Application (.Net, IIS, SQL Server 2005), Hospital Name Maintenance (.Net, IIS, SQL Server 2005).

Confidential, Deerfield, IL

Responsibilities:

• Developed and implemented a new .Net application (HNM) utilizing VB.Net in Visual Studio 2005, SQL Server 2005 and Telerik RadContols. Working with BI consultant designed functionality, and then created all .Net code, interfaces, DB tables and stored procedures as well as SSIS ETL which pulls in data and does fuzzy matching on redistribution data sets.
• Converted a Fat Client, Visual Basic 6 and SQL Server 2000 application into a .Net web application. Technologies implemented for new application consisted of VB.Net in Visual Studio 2005, SQL Server 2005 and Telerik RadContols.
• Collaborating on development with a Confidential employee, my specific duties included design and implementation of new database tables, stored procedures and functions along with development of .NET 2.0 and AJAX web front end.
• The application maintains hierarchies for various business segments within the company as well as integrating with data warehouse and feeding downstream Cognos reporting system. It consists of multiple environments, enables maintenance of leaf level data and allows management of hierarchy structures, branches as well as users and their permissions.

Confidential, Westchester, IL

Responsibilities:

• This project consisted of a complete redesign and conversion of existing systems. My specific responsibilities were to lead the conversion of hundreds of individual Fox Pro programs, databases and import/export processes to SQL Server 2005, Integration Services and VisualBasic.NET. These duties involve the accurate analysis of programs, design and development of SSIS packages, database tables, stored procedures and user defined functions. Development tasks were done via Visual Studio 2005 and MS SQL Management Studio both integrated with VSS 2005.
• This project consisted of making updates to custom software used to manage building inspections as well as creating new functionality for the corporate web site. Overall architecture utilizes Web Services written in C# and .Net and is hosted on IIS and SQL Server 2005. My specific responsibilities were to setup several new clients on the software, make changes to existing code for the fat client as well as changes to the reporting website.
• Infrastructure tasks completed included setup of a testing environment to mimic production and enable code change releases, setting up Google analytics on all corporate web pages, enabling capture of lead information through the websites.

Confidential, Schaumburg, IL

Database Management Architect

Responsibilities:

• Lead the design of the ePortal tool for managing 4 environments: test, qa, stage and production. A role based tool which allows administrators to manage environment settings including website URL’s, SSL cert expiration, configuration settings and campaign reporting. Allows quality assurance role to deploy, test and verify into each environment, allows project manager role to view real-time status of their projects, allows developer role to manage progress on projects and allows the business users to view reporting data on campaign performance.
• Manage a team of web and database developers and system engineers providing support for e-commerce initiatives. Involved in development of GEFA wide database standards for creation, deployment and management of enterprise wide databases. Lead onshore and offshore development teams in database design and adherence to database standards for table, index, view, stored procedure and general database strategies.
• Manage externally hosted infrastructure and vendor relationship including billing invoice review, URL monitoring, network changes, backup storage maintenance and SLA/RCA related issues. Taking over this function I was able to eliminate backup overage charges by minimizing our hard disk memory footprint and cost reduction of over 100K/yr.
• Interface with business, marketing and operations teams to gather input on project requirements. Manage projects utilizing Kintana/Mercury IT Governance(ITG) from beginning to completion including code reviews and stress testing applications. Act as gatekeeper for ITG change control process for deploying changes into environments.
• Support vast number of campaigns driving traffic and enrollments to sites via email marketing, pay per click, direct mail and SEO.

Managing Software Engineer

Confidential

Responsibilities:

• Design, development and maintenance of global enrollment database and processes that enable web sites to be co-branded and private labeled. These Internet sites are dynamically driven from the database including content, forms, quoting engines and provider search capabilities.
• Design, develop and maintain a data warehouse supporting tracking and reporting functions related to a wide variety of marketing campaigns including e-mail, direct mail, and television direct response. Database also tracks number of users logins, downloads occurring, number of enrollments based on campaign…etc.
• Maintain and support connectivity to and from web environments between mainframe and other legacy systems for billing, enrollment processing and member support services. Create and maintain ETL jobs for entire web/DB server farm using SQL Server -Data Transformation Services (DTS) and UNIX/Oracle scripts performing extracts and loads.
• Conversion of Respond customer service contact management application from MS Access file based system to SQL Server 2000 Client/Server architecture. This conversion significantly increased application and CSR performance.
• Designed and implemented a geo-locator that calculates distance between zip codes using latitude and longitude data. This solution provides real-time patient/doctor lookup within user specified range.

Database Developer / Administrator

Confidential

Responsibilities:

• Designed and implemented search capabilities for shop4.com using SQL Server Full-Text Search on a 500,000+ product database: Confidential. Redesigned data feeds for product updates on shop4.com and reduced the amount of data transfer from 2 gigabytes per day to approximately 1 megabyte daily.
• Designed and implemented a Full-Text Search for the employee directory residing on the company intranet server. Created textual search for all intranet content and documents using MS Index Server and IIS 5.0.
• Planned, created and executed a disaster recovery scenario for all production web sites.
• Creation and maintenance of SQL Server DTS packages for new and existing processes while supporting all production databases and web sites on a 24/7 basis.