SUMMARY

• Over all 8 years 5 months of experience in Programming, Analyzing, Designing, Testing, integration and deployment of enterprise architecture based components and business applications.
• Has 6 years 8 months of experience in Design, Development, Maintenance and Production Support of Business Intelligence Applications.
• Strong Experience in Financial, Insurance and Health Care Domains.
• Strong work experience of Agile and Waterfall methodologies.
• Extensively worked wif Business Team and Functional Team to review business requirements, and Functional clarifications.
• Keeps abreast of new technologies and industry best design techniques and introduces them into teh team’s design practices.
• Participated in teh planning process wif teh Component coordinators to understand BI capabilities, requested by teh business partners and begin defining initial designs prior to project activation which are based on teh results of conducted data analysis.
• Identifies teh data available, including teh proper sourcing of missing data for BI applications.
• Collaborate wif data teh Data Designer for mapping sources and target
• Collaborate wif teh business analyst, data designers, to reflect meta data strategy.
• Participate in teh detailed design activities and ensures specifications are built cohesively and support teh high - level data design.
• Coordinated and conducted various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.
• Interacted wif cross functional teams in order to meet business goals.
• Estimated teh time required for teh development and planned for teh team activities.
• Conducted multiple sessions wif management, end users for open and pending issues and for customizing reports, fixing teh errors in teh data as a part of production support.
• Provided key project inputs by working wif Business/Functional Team and developers in defining several functional and technical issues of project and system requirements.
• Excellent experience in working wif Business team by reviewing teh requirements and developing Poof of Concepts using different set of BI tools and explain business team teh usability, ability and functionality of teh these BI tools.
• Experience wif Data Warehouse Concepts, Methodologies, ODS, Data Warehouse, Datamarts, Star and Snow Flake Schemas.
• Good Experience on BI Tools (Framework Manager, Transformer Cubes, Report Studio, Query Studio, Analysis Studio, Dashboards)
• Good Knowledge on other BI Tools(QlikView, Tableau, SSIS, SSAS, SSRS)
• Good Experience in Created DMR and Relational Model in Framework Manager.
• Good Experience in creating plans and models to fit teh business needs using Cognos Planning.
• Well-versed in developing multi-dimensional cubes and analyzing Power play Transformer.
• Experience wif Data Warehouse Concepts, Methodologies, on ODS, Data Warehouse, Datamarts, Star and Snow Flake Schemas.
• Worked wif large Databases in Data warehousing, OLAP data sources, Data Marts and ETL (Extract Transform and Load) process.
• Database Programming experience using Oracle 10g/9.x/8.x/7.x/, MS SQL Server, DB2, PL/SQL, SQL, SQL Loader, TOAD, PL/SQL Developer and Benthic Gloden.
• Expertise in preparing Test Plans, Cases & Scripts based on system specifications and A&D documents.
• Expertise in Regression, System, Integration, Functional and Performance Testing.
• Participated in various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.
• Provided key project inputs by working wif users and developers in defining several functional and technical issues of project and system requirements.
• Work independently wif business analysts to gather teh requirements.
• Excellent communication and administration skills, highly motivated and wif an aptitude for success and able to work in a team environment wif minimum supervising.

TECHNICAL SKILLS

BI Tools: Cognos BI10.1, 8.x (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio PowerPlay Transformer, /Data Manager), QlikView, Tableau, SSIS, SSAS, SSRS, Crystal Reports

OLAP Tools: Cognos Transformer

ETL Tools: Informatica Power center 9.1, 7.1.

Languages: SQL, PL/SQL, C, C++, Java, SQL, HTML, and XML

Web Technologies: Microsoft.NET Framework, HTML, DHTML, XML, CSS, Java Script, VBScript.

Databases: Oracle 11g/10g/9i/8.x/7.x/,DB2, Sybase, MS SQL Server and MS Access.

Servers: Web Sphere 6.0, BEA Web Logic 8.0,JBoss and Tomcat

Other Tools: CVS,VSS, Microsoft Project, Microsoft Visio.PeregrineHP Service Manager. MS VISIO 2010.

Operating Systems: MS DOS, WinNT/2000/7, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Cognos Developer

Responsibilities:

• Interacted wif cross functional teams in order to meet business goals.
• Worked and involved on multiple projects and delivered in time.
• Implemented project using Agile and Waterfall methodologies.
• Keeps abreast of new technologies and industry best design techniques and introduces them into teh team’s design practices.
• Develops and maintains a data inventory for teh DW and other BI data ass stewarded by Enterprise Data Practices.
• Identifies teh data available, including teh proper sourcing of missing data for BI applications.
• Collaborate wif data teh Data Designer for mapping sources and target
• Collaborate wif teh business analyst, data designers, to reflect meta data strategy.
• Participate in teh detailed design activities and ensures specifications are built cohesively and support teh high-level data design.
• Created Application Diagram for Sales and Service data warehouse to build Contact Center Dashboards
• Designed Physical Application diagrams to model Cubes and Cognos Reporting Applications.
• Created teh Prototypes report development and database validation.
• Designed Auto flow charts and worked wif control-M team in scheduling these jobs.
• Designed wireframes and developed component specs for details design document.
• Provided key project inputs by working wif Business/Functional Team and developers in defining several functional and technical issues of project and system requirements.
• Estimated teh time required for teh development and planned for teh team activities.
• Prepared Technical Documents by reviewing BRDs.
• Worked in Framework Manager to create Models using different data sources, and publishing packages to Cognos connections as per reporting requirements.
• Created DMR and Relational Model in Framework Manager.
• Modeled STAR schema in Framework Manager for better performance.
• Applied AD Securities on Object level, Folder level, Package level and Report level.
• Developed Dynamic Cubes and DR Models using Transformer OLAP Cubes considering source as Framework Manager package and Relational Reports.
• Created Parameter mappings for Row level Securities using Macros.
• Applied Bridge Tables and Determinants on Queries to get accurate data.
• Designed and implemented Cognos Cubes using Microsoft OLAP services, Cognos Transformer, and Power Play to facilitate executive, management and end user Ad hock reporting.
• Created multidimensional cubes using Framework manager Packages as data sources in Transformer.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Developed many Complex Reports as List, Cross tab, Drill through, Master-Detail, Chart using Report Studio.
• Worked wif Business team in developing POCs based on business requirements.
• Extensive experience in BI Tools (Cognos Reports, Dashboards, and Cubes).
• Experience in developing Drill up and Drill throw reports using Cognos Report Studio.
• Good work experience on Cognos Admin activities and in resolving teh Environment and Application issues.
• Developed complex prompt pages for multiple user groups.
• Worked on HTML code using JavaScript coding for Prompt validations and Image controls. Responsibilities as a Business Analyst included regularly updating teh Test Plan and uploading on Confluence for sharing wif teh team and management.
• Worked as a Business Analyst as well as a Test Lead and developed quality test cases, test scripts and test plans in Test Link, based on product requirements, functional and technical design.
• Maintained project documents and shared important links and tutorials, etc wif teh team using SharePoint.
• Collaborated and provided support to teh team by creating project announcements, team member tasks and alerts using SharePoint.
• Executed functional tests in teh QA environment prior to teh QAT process and logged tickets for bugs detected.
• Facilitated teh QA Test process by assigning test cases to teh QA test plan in various builds, assigned test cases to teh QA testers, and established contact wif teh testers.
• Facilitated teh QAT process by providing guidance and support to teh QA testers wif test tools, test scripts and teh execution process.
• Maintained constant communication wif teh testers by assisting teh Project Manager in conducting Daily Bug Review meetings during and after teh QA Test process.
• Created test scripts for regression tests, smoke tests and UAT using Test Link.
• Provided Test Status by creating a Bug Summary Report and a Test Progress Summary spreadsheet on a daily basis during teh QAT process.
• Created, assigned, and maintained tickets in JIRA for bugs and defects.
• Participated in Data Validation process in QAT by developing spreadsheets wif data from teh reports in QA
• Worked 24/7 as on call support.

Environment: Cognos 10.2/10.1 /8.4/7.4 , Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Power Play Transformer, LDAP, Cristal Reports, Informatica, DB2, Oracle, Windows 7/2003 server, VISIO 2010, UNIX, SharePoint, Confluence, JIRA, Test Link, RUP, OBIEE and Clarity

Confidential, Houston, TX

Cognos Developer

Responsibilities:

• Extensively worked Business Team and Functional Team to review business requirements, and Functional clarifications.
• Coordinated and conducted various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.
• Interacted wif cross functional teams in order to meet business goals.
• Provided key project inputs by working wif Business/Functional Team and developers in defining several functional and technical issues of project and system requirements.
• Estimated teh time required for teh development and planned for teh team activities.
• Conducted multiple sessions wif management, end users for open and pending issues and for customizing reports, fixing teh errors in teh data as a part of production support.
• Provided key project inputs by working wif users and developers in defining several functional and technical issues of project and system requirements.
• Played a key role in teh planning, testing, and implementing system enhancements and conversions.
• Build data flows and process flows to interpret teh data flow from teh downstream level to teh upstream level.
• Prepared Technical Documents by reviewing BRDs.
• Responsible for creating and maintaining all testing documentation including test cases, test scripts, and test task lists.
• Trained and provided KT to users a modified and existing system flow and to log teh issues to correct support groups.
• Created customized, Complex reports in Cognos Report Studio and Ad-hoc reports in Query Studio.
• Responsible for teh daily, weekly, monthly, Quarterly and Year End Reports for business needs.
• Worked in Framework Manager to create Models using different data sources, and publishing packages to Cognos connections as per reporting requirements.
• Created DMR and Relational Model in Framework Manager.
• Created plans and models to fit as per business needs using Cognos Planning.
• Designed and implemented Data Cubes using Microsoft OLAP services, Cognos Impromptu, and Power Play to facilitate executive, management and end user reporting.
• Created multidimensional cubes using impromptu’s Query Definition in PowerPlay Transformer.
• Developed Power Play cubes which involved model definition in Transformer, used multiple queries, Calculated Measures, Customized cube and Optimized Cube creation time.
• Created Dashboards in Report Studio involving a mixture of data coming from both teh database and Power play cubes.
• Developed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio.
• Integrated many reports wif teh Metrics studio.
• Designed reports wif Cascading Prompts, Filters, and Calculations.
• Created complex package reports using conditional blocking / conditional formatting / conditional layouts as per business requirements.
• Implemented Security filters at Package level, Object level, Data level.
• Developed Master detail reports, Multi query and Multi page master reports as per BRD (Business Requirement Document).
• Worked on Power Play dimensional cubes.
• Worked on complete SDLC from Extraction, Transformation and Loading (ETL) of data using Informatica.
• Analyzed and validated teh report and performing data analysis by writing complex SQLs.
• Monitored data quality, resolving problem data issues, and ensuring timely updates.
• Involved in deployments of Packages and Reports to different environments.
• Developed many UNIX scripts to FTP teh files and provide permission to users.
• Administrated Cognos portal and specified user roles, permissions using LDAP.
• Responsible for handling and maintaining Cognos Content Store, Content Administration and backup related issues of teh Cognos content store.
• Developed Batch process for Report automation process in Unix.
• Coordination for Integration testing, UAT, UTC and smoke tests and resolving teh support issues.
• Working wif different client teams to support Reporting issues and enhancing teh existing reports.
• Developed Technical Specification documents for all newly developed and modified processes.
• Fixed many Production issues, and Bugs using RMT's (Request Management Tool) and coordinated wif Admin team in migrations.
• Worked 24/7 as on call support.

Environment: Cognos 8.4/8.3, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Planning, Cognos Power Play Transformer, LDAP, XML, Informatica, MS SQL Server 2005, Oracle, DB2, JAVA/J2EE, Windows 2003 server and Unix.

Confidential

Sr. Cognos Developer

Responsibilities:

• Developed theComplex ADR catalog, Set up joins.
• Developed150 reportsalong wif teh team by following teh industry standards for formatting.
• Developed teh complex State Group Cube wif teh Structure teh Users wanted Transformer.
• Designed and Developed most complex Reportnamed Monitoringand supported it.
• Maintainedthe access manger structure from Development to QA to Production.
• Interacted wif teh users to gather teh Powerplay requirements for Cubes. Developed teh standard Powerplay reports.
• Interviewed business community to identify business, data, and delivery requirements.
• Designed models inFramework Manager.
• Updated & administered teh security privileges at object level and data level for teh user profiles in Framework Manager.
• Worked wif Complex reports inReport Studiousingmaster-detail relationship, drill through, burst options,cascading options andprompts depending on user requirements.
• Created reports usingcascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio.
• Created reports containing multiple data containers likeList, Cross-tab and Repeater tables.
• Createddashboardsfor a managerial overview wif drill up and drill down capabilities.
• Created models inTransformer, built cubes and published cubes to Power Play server.
• Scheduled reports usingCognos schedulerand emailed to various recipients as required.
• Worked on TOAD for Oracle database systems for creation of Adhoc queries and for improving various performance issues.
• Experience wiforacleas teh target for teh data marts.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.
• Trained End users to operate teh reports.
• Involved in monitoringData stagejobs/processes and generating reports after successful job scheduling.
• Tuned performance ofData stagesessions for large data files by increasing block size, data cache size, sequence buffer length, and target based commit interval.
• Optimized and modified teh triggers, complex store functions, procedures, user base data type.

Environment: Cognos8.2, Transformer 8.3, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 RTM SDK.

Confidential

Programmer Analyst

Responsibilities:

• Involved in Business Analysis, Design and Development.
• Performed Normalization and Logical Database Design.
• Created Stored Procedures, Functions, and Packages to manipulate teh database and to apply teh business logic according to teh user specifications.
• Involved in hard coding of SQL & PL/SQL scripts.
• I did Performance tuning for rapid execution of SQL & PL/SQL Scripts.
• Developed GUI interface in Java using Applets, HTML, JDBC and JavaScript.
• Created Stored Procedures, Functions, Packages, Triggers, Tables, Views and Synonyms.
• Accessed data from teh database using RDO Controls and Remote Data objects.
• Created teh VB Forms for Data Capturing using Active X Data Objects.
• Created Active X DLL's using Class Builder Utility and generated different Crystal Reports.
• Generated lot of Crystal Reports.

Environment: Oracle 7.3/8.0, PL/SQL 8.0, SQL Server, Sybase, Visual Basic 5.0/ 6.0, JAVA, JSP, Crystal Reports and Windows NT