SUMMARY

• 17 plus years of Full Software Development Life Cycle including 12 plus years of experience in Business Intelligence in Requirement Gathering, Design, Development, Deployment and production support of complex reporting solutions using Cognos Suite 10.2 / 8.4 / 8.2 / 7 x.
• Single resource in supporting design, development and maintenance of ICES and EBT Cognos Reports in Confidential, Medicaid applications, State of Indiana and meeting SLA Agreements.
• Worked as Team Lead and also played the role of Project Management for BI delivery.
• Single resource in converting the entire Cognos Suite reports from Impromptu version 7x to Web based version 8.
• Experience in Cognos ReportNet, Report Studio, Query Studio, Framework manager, Configuration in Cognos 8 and Cognos 10.2.
• Expertise in version upgrades, and execute project within timelines.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Drill through, Master - Detail and Cascading) and Dashboards using Report studio.
• Expert level in budilding dimensional models in Framework Manager, Cubes in Powerplay Transformer, making configuration changes, drill down and Drill thru reports, cubes using Analysis Studio.
• Worked extensively on transformer in creatingOLAP cubesand developed Power Play reports to be published in report net server
• Experience in Cognos SDK programs to support ICES and EBT batch reporting process.
• Production Support entire 24/7 to Confidential ICES and EBT reports.
• Experience in working with Microsoft SIS.
• Strong experience in PL/SQL, Query Optimization, SQL Server, Oracle and DB2.
• Active participant in team meetings.Excellent verbal, written communication and documentation skills.
• Prepared training material and gave end user training to the State of Indiana business users.
• 5 years of prior experience in design and development in Client/Server technology using Visual Studio .NET, Visual Basic.

TECHNICAL SKILLS

BI Tools: Cognos 10.2 / 8.4 / 7 Suite

ETL Tools: Microsoft SSIS

Databases: Oracle 11g / 10g / 9i / 8i, DB2, SQL Server 2000/2005/2008 , MS Access

Programming Languages: .Net C#, Java, Visual Basic, ASP, SQL, PL/SQL

Operating Systems: MS Windows 7 / XP / / 95, WinNT 4.0, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

Technical Lead

Responsibilities:

• Coordinate with Stake holders on requirements and version release updates.
• Written BRD’s and coordinate on approvals.
• Design and Develop PECOS Reports.
• Gather requirements for PECOS Enrollment Reports.
• Gather requirements for PECOS Revocation Reports.
• Modify the reports as per new requirements per the business rules.
• Generate SQL’s in Oracle to test the data.
• Data validation from Cognos SQL and Oracle SQL.

Environment: IBM Cognos 10.2, Oracle 11G.

Confidential

Technical Lead/Senior Programmer Analyst

Responsibilities:

• Worked as Team Lead and architect in planning and designing BI infrastructure.
• Design, Develop, and Maintain ICES and EBT medicaid reports for Family of Social Services Administration.
• Created packages in Framework Studio.
• Migrated entire ICES and EBT Cognos reports from version 7.x to 8.0, then to 8.2 and then to 8.4and currently to 10.2.
• Developed reports in Cognos 10.2 and 8.4.
• Developed ICES Chip Cubes in Analysis Studio.
• Created ICES Audit reports and submit to State on a monthly basis.
• Designed and implemented batch jobs using SDK written in Java to automate the process of PDF creation.
• Translated business requirements into technical documents.
• Worked on OLAP modelling and built multi dimensional cubes in Powerplay Transformer.
• Involved in testing and validating the reports.
• Expert in migrating the reports to newer version.
• Worked on performance tuning of the reports based on report queries generated at database level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework.
• Modeled metadat from DB2 datasource for use in Report Studio and Query Studio using Framework manager.
• Worked on SSIS for loading data from Text files into tables.
• Involved in meetings with State and Business users.

Environment: COGNOS 10.2/8.4 (Framework Manager, Analysis Studio, Cognos Configuration, Metadata Modeling, SDK, Query Studio, Report Studio), COGNOS 7x (COGNOS Impromptu Administrator, Server Administration, Power Prompts, PowerPlay Transformer, PowerPlay Connect, Configuration Manager, Cognos Script Editor), Java, Visual Interdev 2013/2008, ASP .Net, VB.Net, Oracle 8i/10G/11G, DB2, SSIS.

Confidential, RTP, NC

Senior Progrmmer Analyst

Responsibilities:

• Developed reports in Cognos Impromptu.
• Developed applications in VB.Net and ASP.Net
• Worked with almost all of the intrinsic and extrinsic controls.
• Developed class modules, Dll’s and used for multiple projects.
• Written new database triggers, PL/SQL procedures.
• Making new COM Components, Dll’s, versioning, and registering on the server.
• Develop Reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Cognos PowerPlay.
• Developed Cubes based on business requirements in Cognos.
• Written Functional Specifications Requirement documents

Environment: Cognos 7.3, .Net, Oracle 9i

Confidential, Farmington Hills, MI

Senior Developer

Responsibilities:

• Created Time Tracking Web application that keeps tracking all the applications across different levels at Confidential .
• Design Data Mart model with Erwin using Start Schema methodology
• Designed Drill through and Business trend reports using Cognos PowerPlay.
• Developed front end screens for Client Server using Visual Basic and Web Apps using ASP.
• Converting of ASP applications into ASP .Net

Environment: Visual Basic 6.0, ASP 3.0, ASP .Net, Visual Basic .Net, Oracle 8.i, SQL, PL/SQL, Visual Studio, Visual Interdev 6.0, HTML, DHTML, VB Script, Java Script, COM, XML, Visual SourceSafe, Datastage, Microsoft IIS 5.0, COGNOS, Unix, and Windows 2000

Confidential, Groton, CT

Programmer Analyst

Responsibilities:

• Designed and developed the user interface application using ASP 3.0, VB 6.0.
• Designed the screens using HTML.
• Wrote server side and client side validations for the Web Pages using Java Script and VB Script.
• Wrote complex front-end validations and stored procedures.
• Performed maintenance work on Visual Basic application for Project Code Database.
• Added enhancements as required and provided production support to ongoing scripts and PL/SQL Programs.
• Migrated data using Informatica from DB2 to Oracle database and also from SQL Server to Oracle database.
• Wrote multiple SQL queries to support data migration.
• Used cursors in PL/SQL Programs to store values in them.
• Designed and developed reports in Cognos.
• Wrote data base triggers like Pre Insert, Post Insert, and functions using PL/SQL.
• Wrote sequence numbers from backend for insertion of data from front-end.
• Used the Indexing concept for retrieving the data fast as we were working with millions and millions of rows.
• Involved in tuning queries for optimal performance.
• Testing of the application and writing Test Plans.
• Extensive usage of objects in Oracle 8i from one instance to another.
• Comparison and validating the outputted data.
• Worked with all the concepts of Primary Keys, Foreign Keys, and null validations.
• Maintained the integrity constraints between the data related to different tables.
• Documented the work completed with business rules involved and the logic used in PL/SQL procedures and database validations.

Environment: VB 6.0, ASP 3.0, Cognos, Informatica, Oracle 8.i, SQL, PL/SQL, Access, Visual Interdev, HTML, VB Script, Java Script, COM, MTS, Excel, Visual SourceSafe, DB2, SQL Server, Microsoft IIS 5.0 and Windows NT.

Confidential, RTP, NC

Senior Programmer Analyst

Responsibilities:

• Designed and developed front-end screens using Visual Basic 6.0.
• Development of front-end validations on forms and used extensively all the controls of Visual Basic like intrinsic and extrinsic controls.
• Developed and maintained ASP Web Applications.
• Wrote server side and client side validations for the Web Pages using VB Script and Java Script.
• Wrote excellent reusable functions in Java Script.
• Used different objects and components of ASP.
• Worked extensively on functions, arrays, date objects, passing values from one form to another.
• Worked extensively on Financial Applications Bonus Pay and Variable Pay in GSK CRS 2002.
• Done client side validations for text entry like restricting unusual characters, restricting decimals, and allowing only two/four decimals checking arithmetic and financial conditions on different text values.
• Developed own reusable functions and Active X Controls (. OCX), COM, exe’s, dll’s as per the requirement of the project.
• Done validations on Start Date and End Date. Allows entering date input in any format and displays output in DD-MON-YYYY format. Checks leap year validation, End Date being more than Start Date
• Involved in System Documentation.
• Worked with Complex Business Logic and delivering the work under deadlines.
• Developed Oracle DataBase for Human Resource Data Backbone of the Apollo Project, this combines the Human Resources and Payroll Systems of People Soft.
• Worked and handled entire database of gsk hrowner creating tables, indexes, and views.
• Created around 59 tables, indexes and views in GSK HROWNER.
• Documenting New Worker & HR Data Backbone System and integrating in the front-end as a hyperlink.

Confidential, OK

Programmer Analyst

Responsibilities:

• Developed front-ends applications using ASP for Intranet of Phillips Petroleum.
• Used Scripting Language Java Script and VB Script for client side validations.
• Used MTS to automate the transactions and for deployment of Active X controls.
• Implementing and deploying applications running entirely on server.
• Used control files while migrating the data from Flat files to tables.
• Worked extensively with implicit and explicit cursors in PL/ SQL.
• Involved in tuning the SQL, PL/SQL for a better performance in retrieval of data from database.
• Checking the indexes while writing SQL and PL/SQL so that data is retrieved fast as we were dealing with tables that had millions and millions of rows in it.
• Involved in trouble shooting of the application.
• Taken preventive measures while dealing with null values.
• Created complex reports using Crystal Reports 8.0 having parameter forms, formula columns.
• Worked interactively with users catering to their frequent changes on the requirements..

Environment: .Net, ASP, VB .Net, Visual Basic, Crystal Reports.

Confidential

Programmer Analyst

Environment: ASP, ASP .Net, Visual Basic 6.0, Oracle Reporting.

Responsibilities:

• Involved in design and development of Tax 2000 POS product that helps the business organization to make transactions from customers in this application as it facilitates automate tax filing as per the Government tax rules.
• Developed front end screens for Client Server using Visual Basic and Web Apps using ASP.
• Tables and triggers were written in Oracle.
• Converting of client server Visual Basic application into web ASP application.
• Designed reports using Oracle Reports.