Easwaran Arumugam Email & Phone Number

Herndon, Va, Us

Reston, Virginia, United States

United States

United States

United States

• Understanding and identifying testing scope based on Solution specifications & Requirement documents.• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.• Created and Developed Reports and Graphs using ALM.• Validating data newly created profile shapes by cross verifying with existing profile shapes using SQL server• Developed data quality test plans and manually executed ETL and BI test cases.• Worked in Waterfall Methodology.• Designed and kept track of Requirement Traceability Matrix• Involved in Integrating, Functional System Testing, for the entire Data Warehousing Application.• Extensively used Informatica tool for extraction, transformation and loading process.• Used Clear Quest for defect tracking. • Performed data quality analysis using advanced SQL skills.• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Chennai Area, India

• Analyzing the specifications provided by the clients and Developing specification documents for Report as per the client requirement.• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and assigned security rules to them in Framework Manager• The specific role involved in creation of metadata layer in Framework Manager, publishing packages to Cognos Server and creating reports using Report Studio• Involved in the Cognos Administration using Cognos Connection for Data source.• Creation Designed Reports using most of the Report studio features like Conditional Formatting, Master-detail, Drill Through, Conditional Page layout, Sections, page Breaks, Prompt pages and Conditional Variables, calculations, HTML items.• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query Reports.• Used prompts, filters, calculations, conditional variables, multiple queries for data extraction in reports.• Used Union, Union all, Intersection for creating queries.• Knowledge in writing with HTML/Java Script in Cognos report studio reports as per the requirements• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports• Validated the report results with the source data and deployed the reports to production environment.

Chennai Area, India

• Understanding reporting requirements and creating technical design document for reports • Interacted with Business Analysts to identify the Business Intelligence and security requirements • Developed Business view of the data (Metadata Models) with Namespaces, Folders, Query Subjects and Query Items in Framework Manager.• Built relationships between query subjects, which represent the logical structure of the business and the user requirements.• Built complex/summary query subjects, reusable filters and calculations based on relational data sources.• Developed Complex Reports in Report Studio, ad hoc reports in Query Studio as per the requirements• Created simple list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions.• Created Prompts and Cascading Prompts pages in Report studio.• Used Conditional blocks/variables and associated them with queries to show data only when the conditions were satisfied.• Worked on summary reports and detail reports.• Peer reviewed design and code of other developers, prepared defects list and modified design documents and code as per the defects list.• Created test case/plan for the reports.

Chennai Area, India

Involving in phase meetings for gathering report requirements and functional document reviewsInstallation and Configuration of the Cognos 8.4 multi server environmentInvolved in gathering the user requirements from end users and worked on designing the Metadata Models in Framework Manager and published them to the Cognos connection for the report authors.Authored list, crosstab and chart reports using some unique functionalities of report studio.Developed some custom report templates based on user requirements.Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts. Designed reports which involve drill down, drill up and drill through functionalities in report studio.Developed some analysis reports using analysis studio and defined some Drill-Through Definitions to report studio reports.Created dash board types of reports in report studioResponsible for troubleshooting Cognos BI Server issues.Involving in Production support for the Cognos applicationReviewing deliverables of peer/team member and coordinating with OffshoreInvolved in the event handling process using the Event Studio.

Noida, Uttar Pradesh, India