SUMMARY

• 10 plus years of IT industry experience spanning over a number of challenging projects and wide exposure  and Java/J2EE technologies with expertise in Analysis, Design, and Development of Applications in different Business Intelligence Environments with emphasis on generation of Complex Reports using data warehouses and Business Intelligence reporting tools.
• Develop and administer Self - Service Business Intelligence Applications
• Define Semantic Layers and Repositories to Support Reporting and administration. Develop Framework Manager Models (Layers, Joins, Prompts, Filters and Calculations.
• Strong experience in Cognos 10.1.1/8.4, ReportNet1.1 Administration, Cognos Connection, Business Insight, Business Insight Advanced, Query Studio, Analysis Studio, Report Studio and Framework Manager
• Develop custom dashboards, scorecards and other visualization solutions. 
• Good experience in Business Insight and Business Insight advance.
• Design and Develop Transformer Models, Building Cubes.
• Installing Configuring Cognos servers in distributed environments.
• Experience in Data Migration Process between different versions.
• Experience with Scheduling, Report Bursting and delivery via email.
• Experience in multidimensional data analysis using Power Cubes, Star  and  used in Relational, Dimensional and Multidimensional Database.
• Create BI applications that address financial management, compliance, profitability and cost management. 
• Integrate Key Performance Indicators metrics for  frameworks which support organizational strategies and objectives.
• Expertise in using performance tuning, optimization techniques and in writing, analyzing and executing SQL queries.
• Experience in leading and managing teams. Handled multiple roles Team Lead, System Engineer, Software Developer, and Support Engineer.

TECHNICAL SKILLS

BI/OLAP : Cognos 10.1.1/8.4/8.3/8.2/8.1 , Cognos Administration, Cognos Connection, Business Insight, Business Insight Advanced, Report Studio, Query Studio, Analysis Studio, Metric Studio, Frame Work Manager, Impromptu, Cognos PowerPlay, Cognos Connection, Cognos EPM Framework, Cognos IWR administration, Cognos Transformer.

Languages : Java/J2EE, UML (Unified Modeling Language), ASP (Active Server Pages).

Operating Systems : DOS, Windows, UNIX, Solaris, zLinux

Technologies: JSP(Java Server Pages), Servlets, EJBs (Entity Java Beans), XML, Hibernate, Component Modeling, Swing, JSF(Java Server Faces), (Rich Client Platform)RCP, Apache BeanUtils, Log4j, Maven, Apache Tomcat, Web-services, Jfree Charts, ChartDirector, iBatis, WebSphere MQ, AJAX

Development Tools: Eclipse 3.0, RSA (Rational Software Architect), RAD, WSAD.

Application Servers: WebSphere Application Server (WAS 7), Pramati 4.1, Apache Tomcat.

Databases: MS Access, Oracle 8i, IBM DB2 Version 8.1.7, PL/SQL, SQL Server.

Frameworks: SOA, Spring, MVC (Model View Controller), Struts and Apache Commons Logging.

Testing Technologies: JUnit and JTest

Configuration Management: Rational Clear Case, Rational Clear Quest, Rational Portfolio Management.

PROFESSIONAL EXPERIENCE

Confidential, NY 

Sr Architect

Responsibilities

• Develop new Cognos Reports and maintain existing reports in the Crime Data Warehouse and in Real time crime center develop and maintain framework manager models and transformer cubes using two different  Version Environments BI 8.2 and 8.4.
• Configure Cognos Servers on  Operating System.
• Deploy  reports to production environment.
• Administration of Go Mobile environment which is used by in-fields officers to run  reports on their blackberry and window mobile devices.
• Developed complex reports with Report Studio using Cascading Prompts, Customized Filters, Java Scripts, Set Operators and Conditional formatting.
• Used different types of Aggregate and Rollup Aggregate functions (including specialized calculated functions) to display detail and summarized values at different grouped levels.

Environment: IBM WAS, JXplorer,  Cognos BI 8.2/8.4/10, Cognos transformer 7, Cognos Framework Manager,  Db2, Java Scripts, LDAP, Linux, zLinux, AQT (Advance Query Tool), Bugzilla (Issue Tracker), Linux, humming bird, Winscp.

Confidential, Austin TX 

 Programmer Analyst

Responsibilities

• Managed requirements and scope in coordination with various members of senior management, identified use cases and present demo reports and dashboard to the management.
• Prepared low level design documents for several requirements for the team. Prepared reports and dashboards for helping the management to understand what exactly can be done to track and plan budget.
• Developed database and extracted data from the forecast model resides in excel sheets and loaded it from excel sheets to MySql database using open source ETL tool. Created web reports and dashboards using various Charts libraries and JSP. Also involved in understanding and creation of various dimension and cubes in Cognos Analyst tool to create plan and publish the same to the web using Cognos Contributor to be accessed by various managers. Created financial reports using  BI by extracting data from various database sources. Involved in database modeling for reports using Cognos Framework Manager. Used Dimensional modeling (DMR) and Snow flake  modeling technique to develop models.

Environment: Java, JSP, Servlets, Eclipse, Cognos BI 8.3, Cognos Planning 8.3/8.4, Cognos Framework Manager, MYSql, ChartDirector, iBatis, Jfree Charts, Kettle, Webservices.

System Engineer

Responsibilities

• Managed requirements and scope in coordination with client and SMEs, baseline use cases and thereafter be among the primary points of contact for implemented functionality. Own requirements traceability matrix during the entire course of implementation.
• Used Work-Breakdown-Structure  approach as well as Ball-Park Estimates in sizing the various requirements.
• Managed end to end delivery of large units of application functionality in an iterative lifecycle project involving a model driven, component based architecture.
• Prepared low level design documents for several requirements for the development team. Prepared class diagrams, sequence diagrams, context diagrams.

Environment: Java, EJB2.0, UML, Rational Software Architect(extension of WSAD), Rational Clear Case, Rational Clear Quest, DB2, JTest, JUnits, and Hibernate (O/R mapping tool), Bean Utils, Springs, Apache BeanUtils, Apache Commons Logging, WAS 5.1. Maven (build tool), Component Modelling