Responsibilities:• Participated in new development requests, enhancements, and project initiatives aimed at providing operational reporting and analytic solutions per business requirements. Worked closely with project teams to ensure that reporting needs are met in accordance with the enterprise strategic direction. • Participated in all phases of the SDLC (software development life-cycle) as they relate to Cognos BI reporting and development. • Assisted in the development and building of Framework Manager Models. Designed and developed advanced reports and dashboards using Report Studio.• Learned the business processes and data source systems for which reporting and analytic solutions were needed.• Analyzed, designed, built and tested reporting solutions based on business requirements.• Worked with IT and business counterparts to implement end-to-end BI solutions. This included gathering and documenting functional requirements, performing functional and performance testing, and facilitating User Acceptance Testing (UAT).• Managed production deployments of reporting solutions and provided the necessary training, documentation and support to encourage adoption of self-service BI solutions. • Performed testing and tuning activities, including strategies on how to leverage Cognos technologies (Report Authoring, Data / Dimensional modeling with Framework Manger, Cube building with Transformer, Event and Metric Studios) to improve service.• Provided input, recommendations, and resolutions for broad technical issues related to Cognos applications.• Played a backup role in administering the Cognos environment. This included daily production maintenance and support when needed. Maintained knowledge of established service level agreements and delivered support in a manner that meets and exceeds expectations. Supported business and data analysts as needed.

Responsibilities:• Lead a team of onshore and offshore developers, project managers and business analysts.• Ensure that projects are moving forward and being completed on time.• Facilitate weekly one on one meetings with team members to address any issues they may be encountering.Achievements:. Quality Service Award (06/2013). Annual award given to a select few individuals in the company for service above and beyond what is required.

Member of the Business Intelligence Team

Member of the Business Intelligence Team

·Team leader that used the SDLC to develop and implement complex Cognos reports that were utilized by internal and external customers. This included: requirements gathering, report sample design, ETL / metadata development, report creation, QA and follow up with requestor to ensure satisfaction.·Authored high volume / frequently used Report Studio and Query Studio reports that were viewed by over 13,000 users.·Types of reports include: Scorecards, dashboards, graphical, lists, crosstabs, benchmarking, Summary / Detail, etc. Most reports incorporated drill through and drill down capability as well as conditional formatting. Some reports combine data from several data sources (Data Warehouse, ODBC, flat files, etc.) ·Interfaced with VPs, corporate officers, account managers and clients to produce reports needed for company wide decisions.·Designed a security report that resulted in a quality recognition award and annual company savings of over $40,000.·Administrator to production Cognos environment. Maintained user security.Migrated reports and packages from development to production environment.Worked with help desk to troubleshoot user issues.Utilized HP Onboard Administrator / ILO to restart services on server if needed.·Used SQL Server and Framework Manager to develop metadata used for reporting. Assisted in design of star schema including relational and dimensional data.·ETL development included: SQL Server DTS and SSIS packages as well as Data Warehouse scripting.·Used SQL Server queries as well as Microsoft Access and ODBC connections to Data Warehouse tables to test report results.·Team leader in conversion of Microsoft Access reports to Cognos reports.·Trained and mentored other analysts as well as entire departments on how to create and run reports in the Cognos environment.·Recognized as “Top Talent” in last two performance appraisals.

· Designed intricate Microsoft access databases and reports based on client’s specifications.· Developed complex queries, tables, forms, reports and macros.· Created SQL queries to extract data from tandem tables (used as source data).· Utilized several data sources to import data into database (SQL Server, ODBC, flat files, csv files, excel spreadsheets, linked tables)· Maintained recurring reports on a weekly, monthly, quarterly and annual basis. This included running and delivering reports at each interval while developing new databases / reports.· Provided reports by agreed upon timeframe.· Delivered reports via email, CD, DVD, mail, FTP. Output formats included: excel, text files, pdf, stand alone access databases, word documents, data transfer.· Interfaced with account managers and account executives to satisfy the client’s reporting needs.· Team leader that trained newly hired Business System Analysts in report development and design.· Worked with team members to implement a Quality Improvement Suggestion that added an index to a Checking table. This resulted in a quality recognition award and annual company savings of over $20,000.

· Created SQL queries to extract data from company database.· Developed Microsoft Access reports for delivery to end users.· Communicated with account managers and clients to develop recurring and ad hoc Microsoft Access reports.· Employed several data sources to create reports for clients and internal users.· Gathered data for reports using Microsoft office, SQL and an “in house” web application.· Prioritized reports to ensure delivery at agreed time.· Documented step by step procedures to accompany reports. Procedures were required to ensure proper run of reports by other developers.· Learned business aspect of insurance and claims management.

· Worked as a QA analyst to test a laboratory software version upgrade.· Used knowledge of life sciences and computational technical skills to analyze report results.· Interfaced with developers to share found “bugs”.· Worked as a group to develop new testing procedures.· Participated in weekly meetings to share new testing techniques.