SUMMARY:

• 6.5 years of IT Experience and 1 years internship in Design and development of relational database applications, Data Warehouse/BI Applications. Business Intelligence Reporting, Enterprise reporting, design development, Performance Tuning, Application Development and product support on various platforms.
• Experienced in Designing Project plans and activity planning, delivery presentations.
• Experienced in Designing the Report and ETL specifications.
• Experienced in Managing the system implementation, deployment and resolution.
• Working through the Risk Management, Recovery planning, data recovery and disaster recovery plans for mission critical applications.
• Worked with industry leaders - Cullen/Frost Confidential, Confidential, and Hallmark Card, and GE healthcare across various business operations. Experience in financial and core banking domains.
• More than 5 years of experience on Trade, Finance and Banking BI domain, Framework Manager, Report Studio, Query Studio, Event studio, Metric Studio, Transformer and COGNOS Connection 8 and also cognos SDK.
• Extensive experience on Reportnet and Cognos Architect, COGNOS Series 7, Impromptu, PowerPlay Transformer, IWR, PowerPlay web reports, Access Manager, Upfront,Visualizer.
• Extensive Experience in Upgradation from Report net to Cognos 8.
• Informatica 8.1.1 power centre repository, integration services, Designer, workflow and workflow monitor.
• Extensive experience in developing Dashboard reports, Scorecards, drill-through reports
• Extensive Experience in Scheduling & Deployment of the Reports
• Strong Experience in Data Governance, Data Modelling(E-R diagrams, relational and multidimensional OLAP models), Data Mapping and Data Loading techniques with Erwin, Visio, Informatica.
• Strong experience in Metadata Best practices in BI domain.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Extensive Experience in Analysis and Development of BI Environments in Organizations.
• Extensive experience in developing scalable enterprise applications according to the user needs which serves Retail and Financial and Banking instruments - for BI users.
• Extensive experience for BI reports needs in Trade, financial and banking reports. Reports needs for Earnings-per-share, Price/Equity, Price/Book Value metrics scorecards/reports . Reports needs for tracing new account opening by a portfolio Officer in deposits, brokerage, credit cards and mortgage, promotions and cross sales reports, commercial lending reports, Fraud reports, Compliance reports as per Bank Secrecy act, Governance Reports.
• Sound knowledge of the Complete Software Development Life Cycle (SDLC).
• Good experience in Healthcare Retail business using Selectica Technology (online product marketing and selling, Promotions, Bulk buy, Group Buy sales reports region wise and salesmen wise, Product cost- pricing, discounting, Target realisation and standard margin reports, bonus calculation reports for sales representatives).
• Strong experience in client Interaction, understanding Business Applications, Business Data Flow and Data Relations.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modelling, developing BI Database Schemas like Star Schema, Snowflake Schema and constellation used in Relational, Dimensional and Multidimensional Cubes modelling.
• Working with Informatica mappings for Slowly changing dimensions, Cubes and different datasources and targets.
• Expertise in Selectica Model builder, Pricer Adminstrator, Selectica XML pages.
• Extensive Experience in Teradata, Oracle, SQL Server & MS-Access for Data Extraction.
• Extensive experience in working on Teradata, Oracle 8i/9i/10g, SQL Server & Toad.
• Exceptional analytical and problem solving skills, Ability to communicate effectively at all levels of the development process.
• Good team player with excellent communication skills.

TECHNICAL SKILLS:

• BI Domain, Cognos series 7, Cognos 8.1 and 8.3
• Report Studio, Framework Manager, Query Studio, Event Studio, Metric Studio, transformer and Cognos Administration, Cognos SDK
• Reportnet, Cognos Architect, Impromptu, PowerPlay Transformer, IWR, PowerPlay web reports, Access Manager, Upfront,Visualizer, ~ 6 years
• Visio, Erwin ~ 2 years
• TOAD, SQL Loader, SQL*Plus, BTEQ, Fast Load, Teradata Query man (Teradata SQL Assistant)~ 5 years
• Mercury Test Director(Quality Centre) and Autosys ~ 5 years
• Metadata Management ~ 5 years

PROFESSIONAL EXPERIENCE:

Confidential

BI Cognos Archtiect and BI Analyst, Module lead

• Working through model designs of banking environment. Enhancing the exiting model for consolidation.
• Using Informatica, Unix and Autosys environment for redesigning the mappings.
• Creating dimensional model and cubes, working with slowly changing dimensions
• Conducting BI Requirement gathering sessions
• Writing BI Report Specifications and Design documents.
• Working with E-R Models and designing new schema for reports. Also, creating Dimensional Model over relational OLAP model.
• Documenting Lineage for existing and new reports and cubes
• Documenting reports retention and history requirements
• Designing new schema and views based on new consolidated model.
• Implementing Metadata Best Practices.
• Building new cubes over the exiting schema and exiting cubes.
• Involved in the process of installing and configuring Of Cognos 8.3
• Involved in the Deployment of packages and migrations of the reports across DEV, QA and Production environments.
• Designed Star Schema groupings using Framework Manager
• Suggesting BI report bursting methodologies
• Suggesting on scheduling methodologies for reports in cognos (such using time based and event based scheduling)
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Providing Naming Standardization for Reports, Packages, Models and Query Subjects.
• Performance tuning for existing BI reports.
• Estimation and Providing Business value suggestions regarding new BI requirements.
• Re - Directing the existing reports to new tables and sources.
• Creating new advance reports (Master - detail, Drill- through, Customised reports and dashboards)
• Re-modelling work on existing models to bring a new standard across every project models in BI environment.
• Offshore - onshore co-ordination.

Environment: Informatica 8.1.1 and BI Teradata environment, Cognos Impromptu, Cognos 8.3 framework Manager, Query Studio, Report Studio, Transformer, Cognos Adminsitrator, Event Studio and Metric Studio, COGNOS Series 7, Impromptu, PowerPlay Transformer, IWR and Reportnet. ERWIN, Visio, Metadata analysis tools, Teradata SQL Assistant and SQL Server, Oracle 10g. Windows and Win CVS. UNIX, Autosys and Test Director

Confidential,Jacksonville,FL

BI Cognos developer and analyst, Module Lead

• Project planning and WBS design for the data-ware house project.
• Activity planning and time sheet status reporting for management.
• Impact and risk analysis on the integration of Confidential and countrywide data warehouse for upstream and downstream systems.
• Working a recovery plans. Involving in drill for recovery and disaster recovery for data warehouse applications.
• Analysing and writing user reports requirements.
• Analysing Enterprise Entity- relationship data models and physical schemas, working with user groups, drawing data lineage for report metadata usages.
• Worked in defining the data governance model, history retention, securities for various authors and analysis users.
• Developing the new schema, relation - normalised ODS, and de-normalised relation OLAP systems.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship
• Created Drill-Through reports to provide users with more detailed information.
• Involved in the Deployment of packages and migrations of the reports across DEV, QA and Production environments.
• Involved in testing the reports and also scripts with test director.
• Fine-tuned SQL queries and reports for performance.
• Having a well balanced understanding of BI- Business relationships & functionality and also getting Sign off from users by doing Users Acceptance testing (UAT).
• Offshore - onshore co-ordination.

Environment: BI teradata environment, COGNOS Series 7 framework Manager and Reportnet, Cognos 8.1 framework Manager, Query Studio, Report Studio, Transformer, Cognos Adminsitrator, Event Studio and Metric Studio, Schedule Management. ERWIN, Visio, Metadata analysis tools, Teradata SQL Assistant and SQL Server. Windows and Win CVS. Mercury Test Director, Informatica

Confidential

BI-Cognos Report Developer, Team member

• Created Packages in Framework Manger and published them on cognos connection for BI report users.
• Creating Enterprise reports based on BI-Report requirement templates.
• Was involved several cross tab, list reports, Master detail reports.
• Drill Through reports and Burst reports.
• Created complex BI-reports which involved multiple pages, multiple prompts and alternate
• Applying filters and prompts that are predefined
• Generated Reports with Conditional Blocking and Conditional Formatting.
• Created Models by using Impromptu Query Definition (IQD) in Power Play Transformer.
• Developed Many Dashboards and Scorecard.
• Developed Report Studio reports with multiple select and cascading prompts.
• Extensively used conditional layouts to run reports in PDF and CSV modes as for user requirements
• Performed comprehensive Unit testing by comparing the cognos reports against the database using sql in Toad and documented the same.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Involved in the Deployment of packages and migrations of the reports across DEV, QA and Production environments.

Environment: COGNOS Series 7 framework Manager and Reportnet, Cognos 8.1 framework Manager, Query Studio, Report Studio, Transformer, Cognos Adminsitrator, Event Studio and Metric Studio, Schedule Management. ErWIN, Visio, Metadata analysis tools, Teradat and Sybase IQ. Windows and Win CVS. Mercury Test Director, informatica and Mainframes.

Confidential

Oracle Database, Selectica and JAVA Web developer, Team member

• Using Model builder and selectica price application for product data upload.
• Validation with Bill of Material.
• Coding for new and existing healthcare requirements on Sale work bench using Java and selectica XML.
• Oracle database design and enhancements.
• Designing the Confirguration, Pricer and Quoter Sales UI using Selectica and Java scripts.
• Designing and developing functionalities of contract management.
• Preparation of Unit Test Cases for Functional testing, Navigation Testing and implementation.
• Preparation of System Test Cases and Implementation.

Environment: Oracle, JSP, HTML, Guidepost, toad, Selectica Price Application, Windows and Win CVS. Mercury Test Director