OBJECTIVE

Seeking challenging position in software development to contribute my knowledge for the growth of the company and self, also to improve my domain and technical expertise in Business Intelligence

SUMMARY

• IBM Cognos Certified Report Author and Modeler with over 7 years of experience in Database, Data Warehousing & Business Intelligence with over 6 years of experience in Enterprise Data Warehousing tools like Cognos and Ab Initio and Informatica
• Involved in Full Life-Cycle project activitiesfrom defining project roles and responsibilities, detailing project plans, requirements gathering and specification to implementation, testing and support
• Extensively worked on Relational Databases like Oracle, MS-SQL Server, DB2 and Teradata
• Experience with Dimensional Data Modeling and creating Star Schema/Snowflake Schema
• Experience in Data modeling using Erwin Data Modeler
• Experience in creating complex Stored Procedures,Tables,Views, Materialized Query tables,Indexes and SQL
• Strong experience in Architectural design for ETL and Reporting
• Experience with the Cognos 8/10 BI tools (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Transformer, TM1) as a Developer and Administrator
• Involved in Metadata modeling using Cognos Framework Manager, Cognos Transformer
• Implemented Security at different levels in Framework Manager and Cognos Connection
• Expertise in developing Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts, Maps, multi-query multi-prompt reports, burst reports) and Dashboards and Active Reports using Report studio
• Strong experience in best practices design and performance tuning
• Involved in theCognosAdministration Tasks like Creating Data source Connections, Publishing Packages, scheduling reports, User Creation, Assigning Security, Deployment of Packages and reports in different environments
• Created Multi Dimensional Cubes using the Cognos Transformer and created Powerplay Cubes.
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.
• Experience in the Migration of Cognos Applications fromImpromptu/CRN toCognos8 Environment and from Crystal Reports and Mainframe COBOL to Cognos 8 Environment.
• Experience in customizing reports using Java Scripts, knowledge of Unix Shell Scripting.
• Strong experience in ETL process including Data Quality, Source Systems Analysis, Business Rules Validation, Source to Target Mapping Design, Performance Tuning and High Volume Data Loads
• Experience in Ab Initio GDE,Ab Initio EME, Co>Operating System and interaction among these components
• Worked on Informatica Power Center tools like Designer, Workflow Manager and Workflow Monitor
• Ability to efficiently relate and transfer the domain challenges and requirement to the product solution
• Expertise in Architectural design, creating Technical, Functional and Non-Functional Requirement documents, High Level and Detailed Design Documents, User Guides and Technical Uptake documents
• Strong consulting and mentoring skillsin DW and BI space and demonstrated ability to learn new technologies
• Played the role of a Developer, Lead developer, Mentor, Business Analyst and Architect in various DW projects
• Decisive team player with the ability to meet deadlines, handle multiple tasks and flexible in work schedules
• POFESSIONAL CERTIFICATIONS
• IBM Cognos certified BI Author (IBM Certification)
• IBM Cognos certified Modeler (IBM Certification)
• Software Quality Foundation Certification (Infosys Certification)
• Ab Initio Certification (Infosys Certification)
• Teradata certification

TECHNICAL SKILLS

• Business Intelligence Tools
• Cognos 8 / 10: Framework Manager, Report Studio, Query Studio, Cognos Connection, Metric Designer, Metric Studio, Analysis studio and Event Studio, Transformer, TM1
• Ab Initio: Ab Initio Co>Operating System 2.14,15,16 GDE 1.14, 1.15, 1.16
• Informatica 9.1/8.5/7.1 Power Center Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor
• Data Modeler: Erwin 4.5/4.0/3.5
• Operating Systems
• Windows 7/VISTA/NT/XP/ME/2000/95/98, LINUX/UNIX
• Databases
• Oracle 11g/10g/9i/8i, DB2, MS-SQL Server 2000/2005, Teradata
• Programming Languages
• C, C++, Java, SQL, PL/SQL(Cursors, Stored Procedures, Triggers and Functions), Perl, PHP, UNIX Shell Scripting, HTML, XML
• Domain
• Banking, Retail, Insurance

EDUCATION DETAILS

Masters in Computer Science

PROFESSIONAL EXPERIENCE

Project: Customer Experience Management for Bank of America 02/2012 – 07/2012
Client:Confidential
Position: BI Consulting Engineer
Responsibilities: Worked in analyzing their social media, survey and chat responses from the customers of the products and providing insights to their customer satisfaction.

• In depth interaction with Client Architects, Project Manager, Subject Matter Experts, and Developers for solution implementation
• Responsible for the architectural design and detailed design of reporting and obtaining sign off from the business
• Involved in the Installation and Configuration of Cognos 10 BI tools and Framework Manager
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created data model using Erwin data modeler
• Created database layer, business layer and presentation layer, defining appropriate relationship between query subjects in Framework Manager
• Created Active Reports, List, Crosstab, Dashboard Reports and Drill-Through Reports using advanced reporting techniques in Cognos
• Created several burst reports using Cognos
• Performance tuning of reports at Reporting layer and Framework Manager Model layer
• Extensively worked on the complex prompt page design of various reports
• Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports in Query Studio
• Created ad hoc framework manager model and trained business users to work with the ad hoc package in Cognos Query Studio
• Created Test Plan and involved in test cases preparation and execution of the test plan
• Handled deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 10 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio), MS SQL Server, Erwin Data Modeler 4.5, Windows XP

Project: Customer Insight through Social Media 06/2011 - 01/2012
Client: Confidential
Position: BI Consulting Engineer
Responsibilities: Guthy Renker is one of the largest and most respected direct marketing companies in the world, with distribution in 61 countries. The goal of this project is to process the social media data and to gain business insights

• Involved in the entire project life cycle from analysis, installation, Report development, testing, production and end user support
• Working closely with the customer in identifying the data requirements for the reporting needs
• Analyzed the data sources and discussed with the business on data capture methods
• Actively participated in the Technical Architecture, Low level design, and High level design of the ETL processes and Reporting
• Discussion with the business regarding their analytical requirements
• Designing the cube as per business needs and creating them in TM1
• Worked on the Cognos Reports design obtained sign off on the report mock ups by the business users
• Responsible for settings up Cognos environment for development, testing and production
• Worked on addressing the various burst requirements of the user
• Provided security at different levels for Cognos reports and Framework model
• Created Cognos Framework Model and developed various active reports, drill through reports and scheduled reports
• Used JavaScript for certain validations to overcome the limitations in Cognos report studio
• Customized Cognos Connection Portal to personalize the homepage
• Extensively worked on the performance tuning of the reports
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Involved in deployment, production support activities and user training
• Modified Cognos Framework Manager model and reports to address requirement change requests and enhancement requests from the clients post production

Environment: Cognos 10 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio, Event Studio, TM1), SQL Developer, Windows

Project: Psychological Survey Statistics Reporting 09/2010 – 05/2011
Employer: Confidential, UNCG
Position: SAS Analyst/Developer
Responsibilities: Working with the Professor of Department of Statistics in analyzing the psychological survey data and carrying out the data mining using SAS Analytics

• Clear understanding of the analytical needs of the department and application design
• Analyze survey research data and interpret results
• Finding creative ways to accomplish requirements and deliver value without relying on existing product features, including implementing temporary extensions to the core product where necessary
• Loading survey data from flat files and other database into the database using ETL Kettle
• Modeling the data for two stage optional randomized response model
• Working with linear and non-linear modeling techniques in SAS
• Created new SAS programs for the RRT model
• Worked on the optimization of the existing SAS programs for RRT models
• Running SAS programs on various data survey data and comparing the results
• Worked on the simulation results of the RRT models
• Worked on the presentation of the new RRT model and simulation results
• Testing of the programs for accuracy with test data and training the department on the application

Environment: ETL Pentaho Kettle, SAS, SQL Server 2008, MS Access, Windows 7

Project: Relationship Profitability Management System 08/2009 – 08/2010

Client: Confidential
Position: DW Architect/ Lead Cognos Developer

Responsibilities:

Replaced the legacy obsolete Crystal COBOL reporting system with semantic metadata driven COGNOS layer by facilitating the analytical needs of the portfolio

• Responsible for the architectural design for ETL and Reporting
• Gathered Business requirements and designed functional and technical requirement and design documentation.
• Analyzing complex COBOL procedures and translating its logic into Cognos report design documents
• Analyzing the report logic and structure from Crystal reports and creating Report design documents
• Served as data modeler in enhancing the portfolio data model for future need
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
• Set up the Security at the package level, query subject level and the query item level
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
• Designed and developed the Framework Manager models and published into the Cognos connection
• Created Packages in Framework Manager by importing metadata from different data sources
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level
• Created various complex Active Reports, List, Crosstab, Charts and Dashboard Reports and Drill-Through Reports
• Performance tuning by writing DB2 procedures and importing it as data source and creating Native SQL in Framework Model Layer and also suggesting ETL changes for better performance of reports
• Creating custom calculations in Framework Manager layer to handle complex report logic shared by multiple reports
• Customized data by adding advanced prompts, Filters, Calculations, Summaries and Functions
• Writing VB scripts in Excel to validate the report output with database query results as a part of testing
• Creating test plan SQL scripts for validating data coming from Framework model and reports
• Developed Reports with Multiple Cognos Viewers and with multiple Cognos Reports Integrated onto a Single Page Report
• Collaborated with Business Leaders to share and gather Cognos Planning requirements
• Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports
• In depth interaction with Business and client architects for solution implementation
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities
• Designed few active reports based on the user requirements
• Trained users in using the Ad-hoc components of version 10 that is Business Insight and the Business Insight Advanced

Environment: Cognos10 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio), DB2, Ab Initio, Mainframes, Erwin data Modeler, Windows XP

Project: Risk Integrated Data Mart (IDM) 11/2008 – 07/2009
Client: Confidential
Position: DW Architect/Lead BI developer

Responsibilities:

Provided an integrated data mart which shall store all necessary information in order to produce SEC and FASB mandated regulatory disclosures, Call Report and a set of specialized SunTrust (STI) level reports across all lending portfolios.

• Clear interaction with the clients to determine the business drivers
• Responsible for ETL architectural design, design walkthrough to clients and developers
• Extensively worked on creating the data mart using Ab Initio GDE
• Worked extensively on Data profiling for understanding the data and creating mapping document
• Developed graph for population of the base fact from two major systems
• Developed various Ab Initio Graphs for data cleansing
• Parameterization of various graphs to reduce coding effect
• Used Different Ab Initio Components like Sort, Dedup, Rollup, Scan, Reformat, Join in Various Graphs
• Worked on components like run program and runsql components to run UNIX and SQL commands in Ab Initio
• Extensively worked on Partitioning and De-Partitioning components
• Worked on improving the performance of Ab Initio graphs by using various performance techniques
• Discussion about the data transport techniques, extract and load dependencies
• Design for Source System failures
• Development of Cognos Framework Manager Model, Transformer model, Cubes and complex dashboard reports, Drill up, drill down, drill though and Master Detail reports.
• Customized Cognos Connection according to the project specifications
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created SQL scripts to validate the data from the integrated data mart through Cognos reports
• Created Ad-hoc Framework Manager Model and trained users to work in Query Studio
• Worked on Quality Centre for QA related tasks
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 8.4(Framework Manager, Cognos Connection, Query Studio, Report Studio, Transformer), DB2, Ab Initio (GDE 1.14, Co>Operating System 2.14), Unix, Quality Centre, Windows XP

Project: UTAH Connection project 05/2008 – 11/2008
Client: Confidential
Position: Senior Data Warehouse Professional

Responsibilities: Provided an interim reporting solution in a span of two months to address the immediate report requirements of the clients when they wanted to analyze the success of their new SkyMiles launch.

• Clear interaction with Business users regarding the business requirements and reporting needs
• Analysis of the data for the data model and report requirements of the business
• Creating design documents for data model, reports and Framework Manager Model and obtaining sign off from business
• Creating test plan and SQL scripts for Cognos reports and Framework Manager model and obtaining sign off from business
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level
• Created various complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports
• Analyzing the performance requirements of the reports carrying out performance tuning by creating Materialized Query Tables, Views, Indexes and handling complex joins and logic a ETL level
• Creating jobs, scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Handling training sessions and demonstration of Cognos tools to End-users
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio), DB2, AbInitio, Mainframes, Windows XP

Project: Customer Relationship Management 06/2007 – 05/2008
Client:Confidential
Position: Senior Data Warehouse Professional

Responsibilities: Customer relationship Management System project is used for research on the new customers, potential customers and old customers and their engagement with the business and the new products. The project aimed at creating a data model for different modules and carrying out the research with the aid or Cognos reports.

• Worked closely with Business Users in understanding the domain challenges
• Responsible for converting functional requirements into technical specifications
• Translated complex concepts in ways that can be understood by a variety of audiences
• Extensively worked on creating data model for the project using Erwin
• Worked on metadata modeling in Cognos Framework manager to meet the report requirements
• Created complex dashboards, drill through reports, crosstab and chart reports with advanced reporting capabilities
• Worked in Cognos Job creation, scheduling, and troubleshooting
• Extensively worked on the performance requirements of the reports
• Worked on Complex SQL queries for data testing
• Worked as a mentor, assisting the team to gain expertise in Cognos
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 8(Framework Manager, Cognos Connection, Query Studio, Report Studio, Transformer), Erwin, SQL Server 2000, Excel, Windows XP

Project: CRM Cognos Upgrade 07/2006 -05/ 2007
Client: Confidential
Position: Data Warehouse / BI Developer

Responsibilities: Upgraded all the CRM applications of Blue Cross/Blue Shield from Impromptu reporting to Cognos version 8 reporting without loss of functionality

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.
• Understanding the migration requirements by analyzing the Impromptu reports and Catalog and creating design documents
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.
• Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Creating test plan and SQL scripts for Cognos reports and Framework Manager model and obtaining sign off from business
• Creating database layer and business layer, defining relationship between query subjects in Framework Manager and setting up the Security at the package level, query subject level and the query item level.
• Involved in building Multidimensional Cubes using Transformer
• Migrating all the impromptu reports to Cognos 8 with additional functionalities for better analysis
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Implementing the Hot File concept of Impromptu in Cognos version 8 reports using excel data source.
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection

Environment: Impromptu, Cognos 8(Framework Manager, Cognos Connection, Query Studio, Report Studio, Transformer), SQL Server 2000, Excel, Windows XP

Project: Sony SOX Compliance Reporting 02/2006 – 07/2006
Client: Confidential
Position: Data Warehouse/BI Lead Developer

Responsibilities: The goal of the project was to generate aggregate data to develop a set of Dashboard reports on Sony Group processes, controls and risks to prove their SOX compliance using the Open Pages and Cognos ReportNet.

• Enhanced the existing Framework Manager model for aggregate reporting
• Developed a set of Dashboard reports on Sony Group processes, controls and risks to prove their SOX compliance using the Open Pages and Cognos ReportNet.
• Designed & developed the reports for daily, weekly and monthly usage
• Created complex Dashboards reports and carried extensive testing of the same
• Analyzing the Framework Manager model and suggesting changes based on reporting needs
• Creating complex Dashboards reports and carried extensive testing of the same
• Implemented Drill-Through reports to provide users with more detailed information
• Worked on the complex prompt page design
• Used conditional formatting to highlight deviations in the data
• Used Query Studio for Ad-hoc Reporting
• Extensively worked on the performance tuning of the reports
• Worked on Quality Centre for QA related tasks
• Worked on Production Support and fixing report/package/data issues
• Knowledge transfer to support team with documentation of the entire application

Environment: Cognos ReportNet (Framework Manager, Cognos Connection, Query Studio, Report Studio), SQL Server 2000, Excel, Open Pages, Windows XP

Project: Cognos V7 to V8 migration for Amex 10/2005 – 01/2006
Client: Confidential
Position: Data Warehouse / BI Developer

Responsibilities: Migrated all the Credit Card reporting solution of the bank from Cognos version 7 to 8 without any loss of functionalities there by providing new BI features to Business Users

• Clear interaction with the business regarding the migration requirements and preparing Migration Process document
• Created Migration plan and obtained sign off from the business
• Migrated Framework Manager Models and Cognos Reports from Cognos Version 7 to version 8
• Created Stored Procedures and imported them as data source
• Worked on complex prompt page design as the part of enhancement
• Used JavaScript to achieve the functionalities, which were not available in the tool used which was a challenging task in the given project scope
• Worked on the critical security considerations of the users
• Involved in User Acceptance Testing and Conducted User training
• Provided role based access to database using Cognos Framework Manager

Environment: Cognos 7, Cognos 8(Framework Manager, Cognos Connection, Query Studio, Report Studio), SQL Server 2000, Excel, Windows XP