PROFESSIONAL SUMMARY:

• IT Consultant - Business Intelligence professional with 11+ years of diverse experience inDatabase/SQL, Cognos Olap cube development and Dashboard Manager for fortune 500 firms. I have both the business and technical skillsets needed for end to end BI development and testing ofmanysoftwareproducts and have been a vital team member in many complex and successful implementations. I’m experienced with agile methodologies, offshore system resources, and all phases of the software production implementation life cycle and have extensive experience working in a fast paced deadline driven environment.
• IT Consultant At United Healthcare, Cigna, Hartford Steam Boiler and Confidential I quickly became an integral, key managerial member of the team. I’ve received written recognition and accolades for going above and beyond what is regularity expected of my job duties, working weekends and after hours when called upon. Became the relied upon, go to SME (Subject Matter Expert) for some of the business intelligence Cognos Cube data applications I designed.
• Insurance Consultant Background with manager connections and access
• BI Developer/ Business Analyst, Data analytics, Dashboard Business Intelligence Development, Olap Cubes, Reporting
• Functional Design requirements, Systems Analysis, Use Cases
• Data Analysis, SOX compliance, Data Governance,
• SQL Bteq, Database Table Loads, FTP, Views, Indexes, Table Optimization
• SQL Reporting, Cognos, Tableau, Qlikview, SAS Enterprise, PowerBI, Pentaho, Hyperion, Report Studio, Analysis Studio, Query Studio, Transformer
• Microsoft Office, Access, Excel, Outlook, Power Point
• Cognos Framework Manager and Admin.
• Systems Development Life Cycle
• Agile methodology, scrums, sprints, stand ups
• Documenting, Visio
• 4GL programming, Focus, SAS, SQL
• Requirements Gathering facilitation skills
• “Customer Focused” SQL Database design, Prototype Table Builds/ Views
• Advanced Clarity, MS Office, Sharepoint user
• SQL Server, Oracle, Teradata SQL, Performance Monitor SQL
• SQL Database, DataMart Builds, Monitor Databases, Database Security, Referential Integrity, DBA Skills
• Oracle, Teradata SQL, Performance Monitor SQL
• Data warehouses/ datamarts
• ETL tool Abinitio Data Science, Data dictionary, ETL
• Data analysis, trending /dashboards
• Star Schema designs
• Business Intelligence Solutions
• MS analysis services, Cubes, MDX
• Autosys, subversion
• UNIX shell scripts, Ftp, SQL, Bteq
• Offshore resource integration

PROFESSIONAL EXPERIENCE:

Confidential

FREELANCE CONSULTANT

• Placing skilled IT positions in 100’s of exciting new positions in the Hartford CT area.
• Managed my own self-initiative and team to create multiple own autonomous Health Care Web Sites. Web Site builds - Actively self-taught myself Web design.
• Adept at all Social Media sites, LinkedIn, Facebook, Google marketing, recruiting and much more.

IT CONSULTANT

Confidential (Bloomfield,CT)

Responsibilities:

• For my recent contract with Cigna I worked as a key technical business analyst. I reversed engineered existing Hyperion code of over 1000 Insurance reports that needed to be converted from Hyperion to SQL Database Tables, SQL Views, SQL Database optimization, SQL Reporting, Cognos, Tableau and/or SAS enterprise reports. Hyperion is being phased out at Cigna so all the reports were to be converted asap based on highest impact and priority.
• Responsible for data moves between the old Hyperion database to the new SQL Reporting Datamart. Data was reformatted and moved into star Schema, multiple lookup and SQL summary tables loaded. Met with customer to DBA performance tune the SQL database, building indexes, and collecting stats.
• I met with several business teams and performed deep dives into the code and created basic functional design specs. Also worked closely with India offshore teams to get them up to speed and integrated.
• As a “technical” BI Analyst I helped all the teams out with their report conversions, much of the technical coding that they could not figure out, I coded for them.
• To automate the reports, I met with the internal Admin teams and Production support technical teams to create the “prototype” ESP scheduling bat scripts. I shared all these prototype ESP scripts with the teams and trained them in how to use. From there they could clone what I did and build out.
• Overall on this contract, I worked as a highly technical business analyst and a BI developer to help expedite all of the report conversions. I supported the business teams, fixing the defects the found, coding complex reports for them, shared screen training, and recommending what they should do.
• In prior IT contracts I was the main BI developer but here I worked as a business analyst with all the technical skills of a developer. So, I can really do both, collect and define specs, and then even actually code and build out fast track prototypes to demo and provide support for multiple business teams
• Carefully planned and organized documents, defects, time reporting, in Agile, MS Office, Clarity and Sharepoint
• All in all, I played a key role here at Cigna with expediting the report conversions as I interacted with the Vendor consultants, the business teams, the managers, the IT admins. and shared my recommendations and experience

IT CONSULTANT

Confidential (Hartford,CT)

Responsibilities:

• For my recent contract with Confidential I worked as a manager/lead in the Fraud Identification department. Currently hundreds of millions of dollars are being lost due to provider and insured healthcare fraud, duplicate claims, inflated reporting +, on a yearly basis. I worked to help identify the prevailing trends, the suspect claims, to create visual TREND dashboards, and to report on the entire recovery and reimbursement initiative.
• Involved in the managerial day to day Business decision making, development, and regression checkout of all the reporting tools.
• I have managerial insight and a wonderful variety and diverse set of IT transferable experience in all Dashboard Engineering Tools, including SQL DBA database design and table and view build, Microsoft Access, FTP, Bulk Datamoves, Automated Scripts, Bteq, Datamart/ Data reporting, Customer Focus design, COGNOS, SAS ENTERPRISE, TABLEAU, MS POWER BI. It is of extreme benefit to know what can be done to maximize all the dashboard features to realize the full potential of your business.
• I am technical manager and very familiar with all the major Database products including SQL, Oracle, Teradata, Sql Server, Star Schema design, BTEQ scripting, Database optimizing & tuning, SQL access, admin. Security, graphical ETL Tool Abinitio
• I was a key member of the role out of the Healthcare Fraud Database and Dashboard to monitor fraud in healthcare. I am very hands on and experienced in the Development and Technical side, so I was personally involved in all the managerial design decisions, customizations, and enhancements.
• We worked in a fully Agile environment, with morning stand-ups, user stories, and 2 week sprints. I coordinated closely with the project manager and BA to fully engage in the business needs and to relay and further explain them to the offshore QA team if needed.
• I was keenly aware and involved in the Administration and Security of the customer faced, Secure, Dashboard Tools, automated forms for Role based requests, Forms for access, Business justification, HIPPA Field masking and Lockdown of BI tools when needed
• Managed and maintained numerousvisual Claim, Analyst Driven, Interactive Dashboardswith drill-thru capabilities, with various charts and views, and tables using global and local Filters.
• Worked closely with offshore QA resources and system analysts to resolve all data accuracy and reporting defects. Developed numerous mandatory SOX compliance reports.
• Most of all, I was well liked by the Team and they were all hard workers and we were all fully committed to meeting the deadlines. My contract was extended 2 times

IT CONSULTANT

Confidential (Bloomfield,CT)

Responsibilities:

• 6 month contract working in the ALM Reporting Department supporting HP Quality Center analysis. Developed Complex dashboard reports / metrics based on Excel specs to monitor the success of all Cigna company project releases, including test plan analysis, defect burn down rate, Plan vs. Actuals, and planning/ implementation success rates.
• Experience inreporting and custom SQL Data Analytics, Microsoft Access, Excel, and also Cognos reporting in the Banking,Financial,Pharmaceutical, Insurancedomains.
• Incorporated a QA offshore team to drive the business needs at a fast pace and to insure the quality of all product version releases. Worked off hours to be available as needed to accommodate any offshore need
• Developed numerousReports, Interactive Dashboardswith drill-down capabilities, with various charts and views, and tables using global and local Filters. Worked in a semi-Agile environment, with morning stand-ups, user stories and daily Kanban board reviews.
• At Cigna I coded and revised Oracle SQL queries to cross compare reports to insure data integrity and accuracy. Defect results were logged in ALM.
• Worked closely with offshore QA resources to resolve all data accuracy and compliance reporting defects.

IT CONSULTANT

Confidential (Hartford,CT)

Responsibilities:

• My 8 month contract was with Hartford Steam Boiler as a Cognos Consultant. My contract was extended 2+ times.
• Actively worked in the HSB Claims Reporting Department supporting the new Guidewire Claim processing conversion. Fully re-coded and QA tested 85+ Operational Cognos reports to run off a new SQL Server Database. The Cognos report changes also included Catalog revisions, adding in new tables, reworking the data item joins, and publishing the changes out to Dev, Qa and Prod.
• Re-coded all the Cognos reports and I added in many new flexible prompts, drill-thru’s and additional features to enhance the usability and functionality of the reports.
• Worked closely with the Cognos Administrator, Business Customers and QA to get all 85+ Cognos reports approved, signed off and published.

IT CONSULTANT

Confidential

Responsibilities:

• Worked under a 12 month contract with Confidential as a full time Cognos 10 Consultant. My contract was extended 3 times.
• Designed and coded approximately 115 complex Government Sox Compliance Cognos 10 prompt and graph reports, created dashboards, framework models, and much more.
• I quickly became a key member in the overall success of this highly complex project, working closely with management, the database designers and QA testers to coordinate and to ensure the project success.
• One of the main challenges was designing the reports in parallel while the actual database was being created, so we did not have good testing data while coding
• As a key team member, I worked many extra hours, way above and beyond, to meet the tight deadlines. There were over 200 unique sub-reports.
• Worked closely with offshore QA, on the phone, sharing screens, sometimes 5+ hours per day, to fully ensure that the reports balanced back to the source I-Series data.
• Once this QA testing phase was 100% signed off, I then spent much of my time working directly with LOB, business managers, to complete the final testing phase.
• Became the SME, and offered suggestions on new approaches in utilities and processes to make the datamart and reporting functionality more reliable and efficient.
• I also worked closely with offshore India on my off-hours, night-time and early morning, to align and coordinate project timelines and tasks to be sure the project kept moving forward and to ensure time and resources were being spent and utilized efficiently.

Confidential (Hartford,CT)

SQL, AGILE DEVELOPMENT

Responsibilities:

• Designed & created & published ModelsusingFramework manager for insightful business decisions & trend analysis
• Developed new star schema Transformer Data Cubes and reports to monitor premium dollar trends, Losses and retention ratios. The reports were rolled out to all the Traveler’s regional reporting offices throughout the USA
• Used Teradata SQL to extract from data marts and data warehouse.
• Developedcross tab, list, chart and complex reports with multiple promptsand conditional formatting in report studio.
• Continued process improvements/enhancements and data integrity with emphasis on deploying to the defined production staging areas, Test, QA, Prod.
• Created Autosys run procs to schedule and run the cube applications in production
• Created Visio Process Flow Diagrams for to document complex enhancements to my trending systems, defining the data flow, scope, constraints, and inherent risks for each change.
• Worked closely with LOB to create Impromptu reports to meet their requirements
• Integrated and fully cross trained the India offshore contingency.
• Worked identifying Cube data trends and integrating new thought paradigms including building out the emerging Telematics and Segmentation initiatives at Travelers.
• Accepted responsibility for the UNIX Shell Script, TERADATA SQL - BTEQ based controllable income production system, incorporated process improvements &reliability gains.
• Improved SQL Query performance by using TERADATA SQL Performance Monitor
• Continued to supported the changing and influx of new server based, object oriented technologies. Attended training and had the opportunity to learn and work on a variety of cutting edge projects some of which utilized Teradata SQL, Microsft Sql server cubes, Datamart builds, Star Schema modeling, Unix, Visio
• Designed cubes using MS Analysis services and MDX to address reporting needs.

Confidential (Hartford,CT)

TERADATA SQL, DATA MODELING

Responsibilities:

• Trained in new “Server-based” technologies including Teradata SQL, Abinitio and Unix
• Analyzed and defined the highly complex specs to reverse engineer the Legacy systems and replace with the new server based platforms.
• Became an integral part of a huge, multi-year ETL effort to convert Legacy data to a relational data warehousing and datamart design including data mapping and business rules. Used Data Modeling analysis to create Star Schema datamarts.
• Personally supported a strategic outside marketing vendor initiative, gathering the business specs and designing a new “One to One” system that pulled data from various complex sources in multiple formats and combined all the data into a single, coherent, FTP transportable data repository.

Confidential

DATA TREND ANALYSIS

Responsibilities:

• Immersed exposure to the actuarial department including pricing and rate making, predictive modeling, complex MI intensive apps.
• Worked hand and hand with the business, actuarial partners, to define new MI ad hoc requirements
• Provided the actuarial departments with time critical cat loss reports, data trending, and predictive exposure reports
• Utilized Cognos Impromtu, 4gl Focus, SAS and array based APL to help define future reserving requirements and pricing trends
• Automated time intensive, manual procedures with Macros for which I was given a recognition award.