PROFESSIONAL EXPERIENCE:

Confidential
Brooklyn, NYMarch 2010 - Present
Senior Cognos BI Developer

• Cognos 8.4.1
• Working in: Report Studio; Query Studio; Event Studio; Analysis Studio
• Cognos Framework Manager
• Build and publish enterprise wide reporting packages for various business areas.
• Currently the Sr. Cognos BI Developer creating in-house reports as per business users request
• Develop the Platinum HRM Data Warehouse Star schema model, and worked closely with the ETL developer to load data into the data warehouse from several disparate data-sources.
• Cognos Connection Security Administrator: maintain the entire security scheme of the Cognos reporting environment by creating roles, providing access, and taking away access.
• Develop OLAP cubes for analytical reporting.
• Build Cognos Alerts that send alerts to report recipients whenever an event occurred.
• Databases: SQL Server/Oracle
• Maintain the entire Cognos report
• To accomplished all of this, I work closely with various business department head, such as Finance, Payroll, Benefits, the CEO, the VP of Operation, Human Resources, and many other report recipients
• Conduct in-house training of the Cognos environment to new and existing staff members.

Confidential, Greenville, SC May 2009 - February 2010
Senior Cognos Software Engineer

• Cognos 8.4, ReportNet
• Currently the Sr. Cognos Developer, working in Greenville SC, working closely with a team in Canada to implement the latest Cognos 8.4 application into their Work brain legacy system, a system that is used by the likes of Wal-Mart, JCPenny, Target, etc. Their Work brain system is currently using Reportnet 1.1
• I am the lead contact in Greenville, SC, working closely with INFOR's larger customers to address immediate problems the customers are having with the application, as it pertains to Cognos.

Confidential, Long Island, NY April 1 2009 - May 2009
Senior Cognos Developer (Contractor)

• Worked on provide the defense department contractor with the Cognos expertise to organized their current Cognos Impromptu 7 series reporting system
• Identified redundancy in their core reports
• Report tuning for better performance.
• Implemented better security scheme
• Introduced best practices

Confidential, NY, NY Feb 2003 - Feb 2009
Senior Business Intelligence Analyst using Cognos 8.3/Series 7/Framework Manager/Oracle database/OLAP
Using COGNOS 8.3

• Designed Usage reports that show online customer's content usage.
• Responsible for the design of the Data model using FRAMEWORK MANAGER.
• Responsible for the publishing of Packages to Report Studio
• Responsible for the design of all reports using Report Studio

Using COGNOS Series 7

• Managed and maintained a total web reporting architecture using the Cognos suite of applications that include PowerPlay reporting, the analytical analysis tool, and impromptu web, the reporting tool.
• Worked closely with Sales and Marketing, Legal Education, Finance, and other Wolters Kluwer internal user groups to provide complex reports and Meta data.
• Worked closely with VP of Operation and other Information Technology staffs, providing them with Meta data using Access, Excel and Cognos reporting tools.
• Designed web reports and cubes and published them to the Upfront Portal so report customers can view and download data as needed.
• Helped to maintain the Cognos production data warehouse.
• Worked closely with the Network Administrator to insure the smooth operation of the Cognos Reporting Servers.
• Wrote requirement and functional documentation for each project.
• Provided Training to users.
• Worked closely with Venders.

Oracle PL/SQL, Report SQL Programming:

• Wrote extremely complex SQL scripts used for complex reporting.
• Wrote/Maintained stored procedures, packages and functions that return critical information for front-end reporting applications.
• Performed data analysis on large amounts of data when necessary.

MSACCESS Programming

• Microsoft ACCESS development: Develop full life cycle application using MSACCESS; use for data mining, Reporting, data analysis
• Documentation

Confidential, Washington, NY April 1999 - Feb 2003
Sr. Programmer/Analyst

• Installed and administered a comprehensive Cognos reporting architecture
• Interacted with in-house business users to facilitate business requirements for OLAP reporting.
• Created multidimensional Cubes, Impromptu catalogs, Impromptu reports as per requirements; Create PowerPlay reports for Financial, Sales and Marketing, Clinical and Operations departments using the latest Cognos Business Intelligence tool;
• Used PowerPlay Enterprise server to register and published Cubes and PowerPlay reports to the upfront web portal to be used by in-house customer via the Intra-net.
• Created PowerPlay Marginal reports from current Data Warehousing database
• Provided training on the COGNOS SUITE of products to all users.
• Program our existing COGNOS SCHEDULER to automate the refresh of all cubes and reports
• Write technical and functional specifications.
• Complete documentation of the entire architecture.
• Oracle PL/SQL Developer for Crystal Reporting and Data loading, etc.
• Write/Maintain stored procedures, packages and functions that return critical information to a Crystal Report used in Crystal Enterprise reporting for in-house and outside customers.
• Write store procedures that adjudicate and load incoming customer data files as per data mapping requirements.
• Maintain data integrity in data warehouse.

EDUCATION:

• MS Computer Science
• BS Mechanical Engineering