Koteswara Singamsetty Email & Phone Number

Singapore

Singapore

Singapore

Working along with Group BI vision and leading report/dashboard design and development activities.Creating and using metadata repositories to improve reporting capabilities and reduce development time and efforts.Managing mentoring global (developer) teams and improving resource utilization.Exploring and extending (Yellowfin) tool capabilities and preparing user guides.Enabling self-service reporting suites and improving ROI on BI tools.Preparing user guide documents and training business users.Conceptualize and program custom ETL process.Analyze and architect and build data mart for CRM team.Define and simplify report development release management process. Communicating effectively with globally spread team (China/India)Validating BI tools and identifying gaps.Designing and developing Interactive dashboards for management teams.

Singapore

Overseeing team workload and do work prioritization.Communicate effectively with distributed teams and do golden handshake.Advise and implement data model design for HR Data mart.Consolidate and integrate multiple databases and provide better framework.Understand report requirements and create function spec and mock-ups.Perform data profiling task, identify data anomalies and provide solutions.Help user to identify better report tools and do Proof of Concepts on reporting tools.Work on daily work allocation and work on Change Request (CR) priorities for quality deliverables.Validate reports and ETL jobs.Create document repositories.

Participate in gathering requirements and creating report design specs.Create report mock-ups and dummy data for report creation.Designed and developed data mart for generating proper KPI.Data warehouse design, implementation and training.Understand application frameworks and help team in understanding them.Supporting internal applications like Spectra CRM, SalesForce.com and HP Service Center.Perform data analysis and provide solutions to teams.Co-ordinate and improve communications with global team.Generate reports using different Business intelligence tools like MS SQL Server Reporting Services, SAP Business Objects, and Business Intelligence Reporting Tool (BIRT)Create complex Business Objects universes and manage Business Objects environment for Enterprise Server Management.Conducting performance checks regularly and tuning SQL queries and reports.Designed and created ETL mapping using SQL Server Integration Services (SSIS).Manage ETL jobs and perform data quality.Prepare test cases, produce dummy data and perform code review.Perform QA and manage user expectations.Prioritize of work and leading team to success.Plan and manage report deployments.Managing Business Objects Servers and perform Back-up.Create best practice, how-to-use documents.

Understanding Preparing design document for ETL and reporting requirements. Implementation of ETL design using Datastage and BO universe design Creating Crystal /Business Objects reports, Universes and resolving related issues.Administering BO server, managing ETL and reporting specification documents. Extracting and transforming data using Datastage.Assisting project manager in project plan and risk analysis, WBS and escalations.Validating reports against requirements. Work delegation and status tracking Conduct SIT/UAT and migrating reports to Production. Preparing test case templates, test quality documents and reviewing report test casesReview resources performance and providing feedback regularly. Creating backups of reports and CMS regularly.

Gathering requirements and implementing requirements as reports. Creating PnL and Audit reports using Business Objects technology.Created advanced reports using scope of analysis, nested prompts, drill-down.Participating and managing SIT/UAT for reporting needs. Resolving Universe problem and tuning the universe.Deployment of components and reports.Creating oracle procedures and packages when needed.Interacting with users and resolving issues.

Designed/Created Reports and User Interface. Creating Templates and created Ad-hoc reports to test data. Creating PTRs (Program Technical Requirements) Deploying reports over the Web and on OnDemand Internet Client. Reviewing, validating, Analyzing and testing the actual results with expected results and Manual Testing. User Training and Creating User Docs.

Mca, Computer

M.C.A, Computers