Professional Summary

• Over 15 years of IT experience in wide range of distributed technologies and platforms in various domain like business intelligence, warranty, service, aerospace defense, healthcare, telecom and manufacturing. Extensive knowledge in complete SDLC, OOA/OOD, design Patterns, etc.
• Over 5 years of experience in the field of Business Intelligence and Data Warehouse.
• Over 5 year of experience in Cognos8.x including 8.3 8.4 with Analysis Studio, Report Studio, Query Studio, FrameWork Manager, Server installation, Server configuration and Server administration.
• Over 3 year of hands on experience in Cognos8.x including 8.3 8.4 SDK integration with enterprise J2EE application deployed on Tomcat, Websphere6.x and JBoss application servers.
• Over 4 years of extensive experience in Cognos EP Series7 Tools such as Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Analysis Tools such as Transformer PowerPlay7.x/6.x, Cognos Visualizer, Access Manager.
• Expertise in OLAP/OLTP engines, Analysis and E-R modeling, developing database schemas Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Expertise in report authoring in Cognos8.x using Report Studio, Analysis Studio and Query Studio.
• Experience in complex modeling in Cognos using Framework Manager and Transformer.
• Involved in installation, configuration and performance tuning of Cognos components and servers.
• Extensive hands-on 12 years experience in Java/J2EE enterprise projects/products using DB2, Oracle and MySql databases, deployed on Websphere, JBoss, Oracle application servers using latest technologies like Hibernate, Spring, Maven, Xdoclet, Struts, Soap, Xml and Uml.
• Successfully implemented many project by employing trends in PM methodologies, earned value project management, total quality management and Six sigma.
• Team player with effective interpersonal communication and exceptional analytical, problem solving and leadership skills. Professional experience working with multiple clients, team members and top executives.
• Demonstrated proactive approach in leading and mentoring team members to maximize level of productivity.

Technical Skills:

• Cognos BI Suite: Cognos8.x BI: Framework manager, Analysis Studio, Report Studio, Query Studio, Metric studio, Event Studio, Cognos Connection, Cognos Configuration.
• ReportNet1.1 MR1/MR2 : Cognos connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler
• Cognos7.x/6.x: Cognos Impromptu administrator, Impromptu User, Impromptu Web reports, powerplay, transformer, powerplay User, powerplay web reports, powerplay enterprise server, upfront administration, access manager, configuration manager, scheduler.
• ETL: ETL: Pentaho Kettle3.x, Cognos Decision Stream, Informatica.
• Web Servers: Microsoft ISS, IBM Http Server, Java Web Sever.
• Java: Java1.4/1.5, J2ee1.4: Ejb, Jndi, Jdbc, Jsp, Servlets, Rmi, Soap, Xml, Jms.
• Application Servers: Websphere6.x, Oracle10.x, Jboss, Weblogic, Cognos8.x, Broadvision.
• Databases: Oracle9i/10g, DB2, MySql, Sql Server, TM1, MS-Access, Hibernate3.x.
• Operating Systems: Unix, Linux, Sun Solaris, MVS/ESA, OS/390, Windows 9i/ME/2000/NT/XP.
• Tools: RSA, RAD, Eclipse, Jbuilder, Forte, RUP, UML, Junit, Drool, QuickRules, Struts, ClearCase, SVN, PCVS, MKS, Rational Suite, Toad, XML, Actuate, Corba, Perl, Xslt, DOM/SAX, Project.
• Modeling Tools: RSA, UML, MS-Visio.
• Front End: Ajax, ActiveWidgets, html, JavaScript, CSS, Awt, Swing, Applet.
• Languages: C, C , Visual Basic, Pl/Sql, Cobol, Cics, Pl/1, Jcl, Focus, File Aid, TSO/ISPF.
• Methodology: RUP, Agile, eXtreme.

Professional Experience

Confidential

Role: Sr. Technical Leader/Technical Manager

Responsibilities:

• Gather and analyze requirements directly from the business user.
• Involve in Installation and configuration of Cognos8.x and ReportNet1.1MR2 and its components.
• Create data sources in Cognos connection and published packages to be accessed by Report Studio, Analysis Studio and Query Studio.
• Involve in migration of reports, catalogs and models from Cognos7, ReportNet1.1 to Cognos8.x.
• Publish packages to the portal to be accessed by Analysis Studio and Report Studio.
• Create multiple complex reports in Cognos8.x using Framework Manager model and components like Report Studio, Query Studio, Cognos Connection. Create multiple Standard List, Crosstab and Master Detail reports.
• Integrate various customized prompts, conditional variables in the report and designed multi-List reports operated by choice prompts adding flexibility to the report.
• Incorporate complex calculations, filters in the model and use them in report for faster performance.
• Develop drill down, drill-through and burst reports, prompt pages, conditional variables using Report Studio.
• Schedule reports through Schedule Management and integrated enterprise application.
• Train users in Query Studio and provide sample reports for understanding the Report layouts and functionality.
• Involve in functional testing, user acceptance sessions and deployment to test and production environments.
• Investigate join issues in the FrameWork Model. Work with data modeler to resolve report functionality issues.
• Translate requirement into technical artifacts for warranty products and Service Intelligence. Design Service Intelligence product. Design and develop workqueue, package, applicability, SEL, workset warranty modules.
• Integrate Cognos8.x using SDK for reports with all products like iWarranty, iService, and iParts. Design and develop Cognos engine to support Cognos integration. Develop interfaces to run Cognos reports, schedule reports and launch Cognos components from inside products using custom authentication single-sign-on SSO .
• Lead a Cognos team for installation, monitoring, modeling, and designing reports. Setup Cognos with enterprise application servers. Assign user privileges using Cognos Connection.
• Deploy application on Windows, Linux, AIX and Solaris platforms.
• Discuss and prepare strategies for making Service business intelligence and warranty products with CEO.
• Acquire and manage onsite and off-shore teams, mentor team personal, provide technical leadership, help in resolving outstanding issues, review and appraise individual performance, delegate work to tech leads and ensure timely delivery and implementation of all scheduled activities within the set constraints and finally manage team conflicts. Triage change requests and defects with clients on regular basis.
• Prepare various analytical documents Pareto Chart, Cause and Effect etc to identify and assist in prioritizing various activities to better utilize available resources. Analyze risks, and prepare risk/response plan, plan for contingency, management reserve and document lessons learned.
• In addition to ongoing operational activities, spearheaded development of various medium sized projects from start to the closure with both onsite and off-shore teams. Prepare contact SOW, Scope Statement, Project plan, schedule network diagram, resource leveling, cost and time estimation and Perform Alternative analysis.
• Meet stakeholders for presentation, technical discussions and progress review. Resolve conflicts amongst different integration teams. Coordinate with clients, teams on work allocation, action items and status review.

Environment: Cognos8.3, Cognos8.4, SDK, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Content Administration, Configuration Manager, Content Manger, IIS Web Server, IBM Http Web Server, Cognos7, Pentaho Kettle3.x, Java1.5, J2ee1.4, Websphere6.x, Oracle AS, Jboss, RSA, RAD, Wsad, Hibernate3.x, Struts, Xdoclet, Xml, Soap, Junit, Clear Case, SVN, Rational Suite, Quickbase, MS-Project, Visio, Sql-plus, Toad, Ant, Maven, DB2, Oracle10g, TM1, MySql, Windows, Linux, Solaris and AIX.

Confidential

Role: Project Leader/ Technical manager Consultant

Responsibilities:

• Understood the business process via requirement gathering, conducted feasibility study, studied possibilities outside the technical framework for optimum solution, prepared project estimation/statement of work, prepared business charter, project plan, resource planning, control project execution, System design review using prototype or mock ups.
• Designed logical and physical schema using hibernate, java beans and ER diagrams. Created relational database tables, analyzed and recommended tables and SQL for performance improvement.
• Worked with users in designing UI, addressed issues in new components, worked with off-shore to develop new components, performed code review and prepared/reviewed test plans etc.
• Created data source connection, user-groups and assigned user privileges using Cognos Connection.
• Led a team to created simple and complex reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, master-detail, tables, charts, filters, prompts, various calculations and joins using tabular sets and tabular models.
• Scheduled, bursted and distributed reports via email and fax.
• Worked extensively with drill down, slice and dice and changed displays in Cognos PowerPlay.
• Organized accessed data sources into Transformer Models, Dimensional Maps, and developed Power Cubes, which can be changed in many ways to Slice and Dice and Drill-through data for further multi-dimensional analysis. Created and published packages using Framework Manager.
• Created dimension maps for transformer, established all dimension hierarchies, designed special categories, calculated measure and special time category, created subsets, group calculations, rank, currency conversions.
• Developed List, Cross Tab and Drill Through reports with filters, calculations, predefined conditions, prompts, group, associations, sort, summarizing data, functions, frames and styles for creating business reports.
• Integrated Castle reports with Cognos SDK to generate on-demand, schedule and burst.
• Mentored onsite and off-shore personnel on OOA, OOD, application architecture, quality assurance, quality control and testing methodologies. Performed assessments of resources and provided feedback as needed.
• Designed and developed framework for all the modules of Castle for web, business and persistent layer.
• Designed and developed My Work, My Group, Search and FAA-8100 screens. Designed and developed most of the admin programs. Developed interfaces for Boeing Communication System. Developed Junit classes.
• Deployed application on Windows, Linux, AIX and Solaris platforms.
• Monitored application performance. Recommended and implemented solutions for performance improvement.
• Managed the functional delivery by coordinating with both IT and business groups.
• Developed work breakdown structures, activity lists and activity duration estimates
• Tracked change requests, issues and risks, provided impact analysis and ensured implementations on time.
• Worked with teams to resolve conflicts and develop most agreeable resolution to project level issues.
• Planned and communicated implementation activities for system releases, builds and patches.
• Environment: COGNOS8, ReportNet 1.1 Framework Manager, Report Studio, Query Studio, Cognos Connection , COGNOS 7.3 Impromptu Administrator, PowerPlay, Transformer, PowerPlay Enterprise Server, Access Manager , SDK, Java1.4, J2ee, Oracle10.x AS, Websphere5.1, Jboss, Hibernate3.0, Struts, Xdoclet, Xml, Soap, Junit, Clear Case, CVS, Visio, Sql-plus, Toad, Maven, MySql, Wsad, MyEclipse, Oracle10g, SharePoint, MSProject, Windows, Linux, Solaris, AIX.

Confidential

Role: Senior Developer Consultant

Responsibilities:

• Translated requirement into technical artifacts for Eligibility determination.
• Designed and developed framework and business classes for business and persistent layer.
• Developed Session beans for all use cases of functional areas.
• Developed utility programs to fix bad code and log analysis to track performance issue.
• Reviewed application code, reports queries and raised defects for quality assurance.
• Recommended and implemented solutions for performance improvement.
• Published coding standards and guidelines for developers to follow.
• Trained developers to follow best coding practices.
• Developed process flow diagrams, templates and guidelines.

Environment: Java1.4, J2ee1.3, Oracle9i, Wsad5.1.2, Xml, Junit, Clear Case, Websphere5.1, Rational Suite, Pl/Sql developer, Eclipse, Cognos Reportnet1.1, Cognos Impromptu administrator 7.1/7.3, Windows 2000, Linux and Aix.

Confidential

Role: Project Leader

Responsibilities:

• Worked with business to understand their functional needs in the new system. Defined use cases, designed class diagrams, dataflow and process flow diagrams, worked with various teams to get buy-in new system.
• Translated requirement into technical artifacts for IC client and server and YourERecruiter's use cases, object model for job order, client and user using MVC architecture.
• Designed and developed client, server and common packages. Developed Junit classes for testing all components. Fixed patches for current and enhanced for future version of IC suite. Lead ICTC offshore team.
• Developed and implemented controller with ActionServlet, Action, ActionForm and Struts-config.xml using Jakarta-strusts1.1. Designed and developed auto form resume filtering, job order creation and processing, registration and scoring engine.
• Managed and supervised installation/configuration/migration and performance tuning.
• Compiled testing status reports and communicated system readiness.
• Conducted user trainings on new or changed system functionality.
• Worked with business users and project team to resolve requirements/technical issues.
• Coordinated management appraisals, reviewed project feedback, and documented lessons learned.
• Participated in project closure activities.

Environment: Java1.4, J2ee1.3, Oracle, MySql, Wsad, Eclipse, Struts, Xml, Junit, ClearCase, Cvs, Ant, DOM, SAX, MS-Project, Db2, Tomcat, Jrun and Websphere.

Confidential

Role: Web Developer

Responsibilities:

• Analyzed business requirements and translated into technical artifacts including use cases, object model, sequence diagrams, using MVC architecture.
• Designed and developed frameworks for AltaVista Search Engine implementation, Resume upload, Exception Handling EJB/Servlet/JSP communication.
• Designed and deployed EJBs and Servlets to implement AltaVista Search Engine. Designed and developed full-fledge highlight functionality for keywords having wildcards. Added statistic programs for recruiters.
• Led the design, development and implementation effort for the AMS project and developed new reports for salespeople and DBO rollup.
• Performed configuration, migration and performance tuning.

Environment: Java, J2ee, Ejb, Jdbc, Jsp, Servlets, JavaBeans, Xml, Rational Rose, Actuate, Jbuilder, Dhtml, Uml, Pl/Sql, JavaScript, iPlanet SunOne and Oracle 8i/9i.

Confidential

Role: Senior Programmer Consultant

Responsibilities:

• Analyzed business requirements and translated into technical artifacts, object model and user interfaces.
• Built a transaction-processing framework for Claims, Provider and Recipient.
• Designed and developed Claims, Recipient and Provider subsystems. Led a team in design and development of reports for all subsystems including TPL, and Buy-In.
• Worked with other team to help them setup batch and online mainframe jobs.

Environment: Java, Ejb, Jdbc, Jsp, Servlets, JavaBeans, Websphere, Focus, DB2 and Oracle 8i/9i.

Confidential

Role: Senior Developer Consultant

Responsibilities:

• Designed and developed framework for configured, non-configured orders.
• Developed new programs for loader. Added new Price Element Codes for all orders.
• Developed new control programs to setup cabling jobs to run Loader for Data Check module.

Environment: Java, Servlet, Jdbc, Swing, Oracle, Websphere, Cobol, Pl/1, db2, Jcl, Cics, DB2, Windows, MVS.

Confidential

Role: Senior Programmer

Responsibilities:

• Senior Programmer in Mainframe and Open System area. Performed analysis, code construction and testing.
• Designed and developed the framework for Utility and Library program.
• Developed new utility programs to prevent datasets from being migrated.
• Enhanced POMS system by completing Customer Service Requests CSR and by introducing new programs.
• Conducted code reviews, con-calls and mentored junior programmers.

Environment: C, C , Visual Basic, MS-Access, Unix, Windows, Cobol, Pl/1, Jcl, Cics, Db2, Vsam, File-Aid, TSO/ISPF, Clist, Rexx, IBM OS/390, and MVS.