TECHNICAL SKILLS

Languages: ASP, ASP.NET, JAVA, JSP, C#, Visual Basic.NET, Perl, Javascript, VBScript, XML, BIML, R, Salesforce Apex.

Databases: SQL Server 2016,SSIS,SSAS,SSRS, Cassandra,Oracle, PL/SQL, DB2, Teradata and Access, MongoDB, PostgresSQL.

Servers: Apache, Netscape SuiteSpot, Microsoft IIS, and Java Web Server.

Development OS: WinNT/95/98, UNIX Solaris, SGI, Linux, OS/2.

Tools: CORBA, ADO, IBM Visual Age for Java, Symantec Café, Lotus Notes, HTML, SQL, Visio, HomeSite, MS Source Safe, WebTrends, SilverStream, Cold Fusion, Crystal Reports, COGNOS, Peoplesoft, Business Objects, Kalido Modeler. Adobe Campaign, Varigence MIST. R Studio. Salesforce, Jenkins, Confluence, Jira, Mongo Compass,RMS RiskLink, AIR. Altryx.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Technical Architect

Responsibilities:

• Responsible for the maintenance and administration of Ryan Specialty Groups catastrophe modeling technology infrastructure and implementation of data strategy including proper architecting of data storage systems, management of data intake and workflow, integration of data from independent systems / sources, and performance tuning of the environment for optimal efficiency.
• Managing catastrophe modeling technical team, vendor relationships, contracts, and licensing.
• Liaise between RSG Enterprise Data and IT Infrastructure teams to leverage corporate resources in the delivery of data analysis to companies.
• Deploy, administer, performance test, tune, and troubleshoot RMS Risk Link and AIR Touchstone distributed application environment
• Managing automation and efficiency of catastrophe modeling data workflow including data intake, staging, analysis, warehousing, consolidation, and reporting leveraging Microsoft SQL Server ETL tools.
• Responsible for RMS and Verisk AIR catastrophe modeling application vendor management including regular interaction with vendors to review operational performance of applications and environment, coordinate contract renewals working with procurement and business team, manage application upgrades, and attend vendor training to ensure RSG’s implementation of modeling capabilities are optimized and in line with industry practice.
• Support catastrophe model change management efforts through model testing and validation efforts with an emphasis on evaluating change impact and performing deep - dive analysis where needed.
• Develop and implement data warehousing strategy (disk and memory resources, data schema / naming conventions, integration with RSG’s Enterprise data strategy, archiving, etc.)
• Organize/deliver user training and Dev/Ops Management and support.

Confidential, Chicago, IL

Software Engineer

Responsibilities:

• Currently the Data Architect for the WRB Data Interchange, supporting Salesforce Sales Cloud and Marketing Cloud applications utilizing a variety of SQL Server Databases.
• Managing the development operations of 11 distinct client data architectures and infrastructures.
• Also working as a project lead for new Salesforce initiatives as they are incorporated into the Data Interchange.
• Consulting on various Salesforce development and administration initiatives.
• Developed all ETL Processes to pull in data from disparate systems.
• Provided primary on-call support of production and test systems.

Confidential, Elgin, IL

Business Intelligence Developer/Architect

Responsibilities:

• Was the Architect for the Annuity section of the Protective Enterprise Data Warehouse
• Completed about 150 SSIS Packages utilizing ETL techniques from a variety of sources to load data
• Worked with multi Terabyte SQL Server, DB2 and TeraData Databases.
• Act as a project lead for new BI initiatives as they are incorporated into the Enterprise Data Warehouse.
• Work with Enterprise Data Architects to model attributes into business domain context.
• Strategically manage assigned data entities\domains across the enterprise
• Ensure high levels of data quality, integrity, availability and privacy using the Microsoft stack
• Analyze complex business issues and design technology solutions.
• Develop the technical framework for project solutions.
• Create and maintain quality documentation for technical and non-technical staff.
• Coordinate testing and implementation of technology solutions using SQL Server Integration Services, ETL and Analysis Services..
• Advocate the strategic perspective for Attribute usage and in corporation, providing perspective to the BI Leads as they address tactical solutions.
• Work directly with Data Architects, Developers, Data Stewards, and Data Analysts on data requirements and Quality Assurance.
• Am also a member of the BI Management Team
• Define, govern, and model all attributes, rules, and data objects for the EDW
• Currently training junior team members on Microsoft SQL Server Technologies.

Confidential, Chicago, IL

Application Architect/Consultant

Responsibilities:

• Was the lead developer of the E-Solutions Metrics Team.
• Am the Primary database administrator maintaining production, testing and development environments using SQL Server 2012.
• Completed conversion of data mart from SQL Server 2005 to SQL Server 2012.
• Created an enterprise Data Mart utilizing VB.Net, SQL Server Stored Procedures and Triggers.
• Was a lead on the Enterprise Report Interface Portal application and developed about 3/4 of the total application.
• Maintained other various legacy VB Applications and components used for data collection and analysis of metrics.
• Constructed over 1200 Stored Procedures for various web and Data Mining applications.
• Completed conversion of VB based report repository to use Cognos reporting.
• Completed ETL and other Transformations for a variety of Medical groups.