Arunteja Tammineni

• Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
• Carried out day-day-day duties accurately and efficiently.
• Demonstrated respect, friendliness and willingness to help wherever needed.
• Identified issues, analyzed information and provided solutions to problems.
• Exceeded goals through effective task prioritization and great work ethic.

Project Details

CRS (Common Reporting Standards)
Company : HSBC

Role : Cognos & Teradata Developer

Responsibilities:

• Generated reports and handled modeling as per user requirement.
• Created filters, prompts, calculations and determinants for efficient data retrieval and analysis.
• Proficient in Report building using Report Studio, and Analysis Studio.
• Created List, Crosstab and Drill-Through reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Deployed the reports from development environment to test environment.
• Active team player in the Project.
• Tested models and reports, from time to time to remove any inconsistencies. Responsible for Unit testing and System testing of the reports based on the specification.
• Reporting testing - creating test cases, scripts and executing them.
• Performed peer reviews of code and testing in order to detect and minimize application problems.

Project : PWM BIO Automation and Retirement

This project catered a leading bank in the US. The project planned on automating excel reports
which SMEs created manually. This also involves remapping the fields in existing reports. A few of the data sources were being sunset; consequently, the data was to be pulled from a new source
system (Data Lake).

Tools Used : IBM Cognos 10.1.1/10.2.2 Report Studio, Query Studio, Event Studio, Frame Work Manager, DB2,
Access DB., SQL Server 2008

Role : Developer

Key Responsibilities.

• Creating Reports for end users analysis
• Gathered and analyzed business requirements from users and business community.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating AdHoc Reports using Query Studio.
• Understanding existing business model and customer requirements
• Created Complex Reports using Lists, Crosstabs, charts, graphs and Images.
• Scheduled Reports through Jobs to get Daily, Weekly, Bi-Monthly and Monthly output of reports.
• Created filters, prompts, sub reports, provide drill through capabilities
• Deployed reporting objects from a development environment to test and then to production environments as per the process.
• Played team member role in team of 4 with effective communication, negotiation and client handling skills.
• Worked on Star Schema Database Design.
• Understanding stakeholder business requirement and efficiently translating it into technical application as finished product.
• Optimized over 20 Cognos reports, with execution times over 30 Minutes to execute within 2 minutes.
• Regular calls with stakeholders for requirement gathering, updates and discussions.
• Created estimations and project plans for development process.

Highlights:

• Mentored junior teammates through development and requirement gathering process on reporting, database and analytical front enabling them to get up to speed, Won many awards over my tenure at Infosys for optimization of critical reports, client satisfaction and for playing an Anchor in configuration management process of project respectively.
• Received numerous appreciations from Client and Onshore counterparts on accurate, efficient and optimal delivery.

Project Name : PWM BIO Reporting Organisation.

PWM BIO reporting project is an in-house data and reporting solution centre. Business users from the
Private Wealth and Management (Consumer) portfolio of an American Bank approach the team
with expansive reporting and data needs, like creation of reports, dashboards, enhancing existing items
and streamlining existing analysis and reporting process by optimization and automation
Role : Analyst, Developer & tester

Tools: Cognos 10.1.1/10.2.2 Report Studio, Query Studio, Event Studio, Frame Work Manager, DB2

• Requirement gathering process and client (user) interaction in order to extract and document accurate requirements in the form of Business Requirement Document (BRD).
• The Data mapping document and the BRDs created were then used by the ETL to retire the legacy data source and model the new source system in line with the business user requirement.
• Analysed the existing excel reports and created DB2 queries to test the data integrity and accuracy of the new source and then translated the queries into optimized cognos reports for the users.
• Analyse the Report requirements, such as joins needed, business logics involving complex calculations, report filters through business requirement document.
• Created metadata models, Namespaces, Folders, Query Subjects and Packages from Oracle data source using Cognos Framework Manager.
• Working with business users to design and develop reports.
• Supports business users on answering complex business questions via BI tools and ad-hoc queries.
• Developed advanced report Templates, List, cross Tab, Drill through, Master-Detail, Chart, Burst and complex reports which involved Multiple Prompts, Filters, multi-pages reports.Created Query Prompts, calculations, Conditions & Filters, Prompt Pages, Variables etc.
• Created Crosstab reports using cascading prompts, conditional formatting.
• Created complex reports using multiple queries.
• Organized data in reports by using filters, grouping, sorting, ranking, highlighted data.
• Worked with Quality Analysts to help them understand the system to meet all the required test cases to be verified before the code is migrated to subsequent environments QA, UAT and PROD.
• Analysis of code to constantly improve performance of code and handled various change requests.
• Automated 100+ manual excel reports to Cognos reports, while also streamlining the process. This project helped save the client tons of manual effort and consequently capital.
• Volunteered for Configuration Management (CM) process for six months, to verify whether the project performs as intended by identifying and documenting in sufficient detail to support the projection. Thus, facilitating reliability, extended life, reduced cost, risk and liability.