TECHNICAL COMPETENCIES:

RDBMS: SQL Server, Teradata, DB2, Oracle, MySQL

Big Data: Apache Hadoop (Cloudera)

Analysis Tools: SAS, Hive, Qlikview, Pig, Toad, SSMS, SSAS

ETL: AbInitio, SSIS, Sqoop (E&L)

Visualization Tools: SAS, SSRS, Qlikview, PowerPivot

Languages: T - SQL, PostgreSQL, MySQL, PL/SQL, SAS, PIG, HQL

EXPERIENCE:

Data Engineer

Confidential, Hartford, CT

Responsibilities:

• Utilize query tools and SAS to provide data cleaning, preparation and analysis to Medical Research Teams in order to facility predictive modeling and data exploration projects.
• Medical and Pharmaceutical Subject Matter Expert in support of Medical Research Team’s predictive modeling, statistical analysis and fraud research.
• Prototype Microsoft BI Solutions (SSRS, SharePoint) as new BI resource to Claims Business Intelligence & Analytics Department.
• Support BI and big data exploration to further the "right-size" initiative for data delivery.
• Write ETL scripts to populate and transform data from disparate data sources into an agreed upon destination data source.
• Lead initiative in organizing and standing-up department’s data engineering group.
• Plan and execute strategy for new medical data warehouse.
• Provide strategic support to Sr. Director in streamlining departmental processes, work flow, and resource management.

Reporting Analyst

Confidential, Middletown, CT

Responsibilities:

• Authored complex stored procedures, views, functions and scripts to support development team and leadership data analytics needs.
• Rebuilt, expanded and improved all legacy reports on new reporting platform using SSRS 2008 R2.
• Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide.
• Assisted Controller and Accounting Team with research and data analysis
• Directly supported Finance, Marketing, Client Services, Sales, Confidential departments as well as executive leadership teams and CEO.
• Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
• Facilitated migration of data between legacy database and new database
• Audited databases pre and post migration
• Guided and mentored junior staff and provided expertise to software development team.

Sr. Financial Analyst

Confidential, Hartford, CT

Responsibilities:

• Provided production support and enhancement development for the SI&T Finance project costing and allocation tool (MPWR).
• Maintained and monitored financial databases and base tables.
• Provided SME Support for MPWR Tool users.
• Authored and optimized complex views, stored procedures, functions and scripts to support internal applications.
• Designed, developed, maintained, implemented and supported SQL server development and production efforts.
• Facilitated forecast activities within the MPWR tool including batch processing, monitoring, and balancing.
• Assisted Controllers and Central Team with research and data analysis
• Facilitated month end financial close activities within the MPWR tool
• Researched and implemented database products.

Informatics Clinical Data Analyst

Confidential, Farmington, CT

Responsibilities:

• Developed, designed and deployed all adhoc and production reports utilized by both medical practices and corporate customers using SSRS and SharePoint 2007.
• Utilized fluency in t-SQL to create, edit and optimize views, stored procedures, and functions in multiple relational databases.
• Created and provided concise user documentation for company applications and policies.
• Monitored industry trends and acted as lead for departmental technical goals and advancements.
• Developed company dashboards to integrate with SharePoint sites and provide users with one-stop shopping for reporting.
• Worked with Clinical Operations and Practice Management relative to clinical integrity of processes and data.
• Administrator of company SharePoint site, reporting portals, dashboards, and security.
• Performed rigorous QA procedures to ensure validity of all reports and data output by the department.
• Adhered to all HIPAA confidentiality guidelines to ensure patient information security and company standards.
• Troubleshot helpdesk issues regarding report functionality and Informatics applications.
• Worked directly with high level senior management to meet business needs.

Technical Data Analyst

Confidential, Windsor, CT

Responsibilities:

• Responsible for all daily, weekly and monthly production and adhoc reports and any required changes.
• Provided data analysis and performed QA on data received from multiple data sources.
• Collaborated with management, developers, and engineers in the design and development of reports.
• Researched and documented business purposes for reports to gather the appropriate requirements for their creation and future enhancements.
• Performed quality assurance checks to ensure consistency and accuracy of all reporting.
• Provided hotline application support to advisors, managers, and engineers.
• Provided desktop support to the hotline and departmental staff.
• Ranked top performer in annual reviews across all colleagues for the IS department.
• Traveled nationally as the lead for the deployment of new call center applications and phone systems and provided training on the process changes for the national call center staff.

Technical Editor

Confidential, Windsor, CT

Responsibilities:

• Edited to standards technical advice documents submitted by technicians and engineers.
• Created and edited technical bulletins for the field.
• Provided training on applications to staff and management (VRM, Onyx, DocRecord, inContact).
• Created training materials and instructions specific to department applications and procedures.
• Administrated and maintained the VRM ( Confidential Vacation Manager) application for the call center, IS, QA and engineering departments.
• Administrated and maintained the UserVoice application for the Confidential .
• Created and deployed instructional videos using Adobe Captivate.
• Administration and creation of instructional materials pertaining to inContact phone systems applications.
• Created and edited official letters on behalf of the Confidential .
• Provided desktop support to Confidential and the field.

Project Manager

Confidential, East Hartford, CT

Responsibilities:

• Specialized in Japanese projects within the biomedical and pharmaceutical industry.
• Managed the translation projects of Fortune 50 and Fortune 500 clients.
• Responsible for the reacquisition of two Fortune 500 clients.
• Edited the translation of drug studies, new drug applications, case report forms, adverse event reports, marketing materials, etc. to accommodate ever changing FDA standards.
• Taught informational pharmaceutical courses to the project management, formatting and sales departments.
• Provided advertising copy directed toward a pharmaceutical and biomedical audience.
• Managed the productivity of freelance translators and resolved client requests and concerns.
• Managed and mentored new project managers.