Ts - Software Engineer - Bangalore, KA, India

Nuthan Ts

Bangalore, KA, India


Software Engineer


I have totally 3.7 years of experience on Informatica,Cognos,WebFocus and Oracle SQL/PLSQL.

Work History

Software Engineer

ETL Tools: Informatica Tool

From January 2013

• Language: SQL, PL/SQL
• RDBMS: Oracle 9i, 10g
• Scripting: Unix
• ETL Tools: Informatica Tool
• Scheduling Tool: Control-M

This Project deals with the Operational Data. Operational Data is used for operational reporting. Operational reporting is the result of manually defining and combining information across two legacy organizations. While this has served as a bridge for the merged organizations, the inefficiencies and inaccuracies associated with manual reporting - along with the continuing clarifications of business needs within the new CenturyLink - demands the need for centralized data mart/tables in order to efficiently and effectively manage the business.
The new data mart proposed is CCDW (Combined Company Data Warehouse). CCDW requires additional enhancements to realize its end-state vision of supporting the business in measuring operational performance within CenturyLink. In order for CCDW to be usable by the business, it needs to have a complete view of all legacy operating performance measurement categories including Service Order/Provisioning, Repair, Dispatch, Common Dimensions.
L-C (Legacy-Centurylink) has processes in place which extract performance related metrics from various L-C source systems. The data is consolidated in the L-C DWPRD environment and integrated into L-C's Integrated Reporting Data Mart (IRDM).L-Q (Legacy-Qwest) currently has a diverse set of metrics reporting capability, however, the metrics are spread across various systems.
Roles & Responsibilities:-

1. Involved in Gathering the requirements and also helped the Analyst to baseline the requirement.
2. Did a complete design for this project.
3. I am the APOC for this project.
4. I worked closely with Clients for this project to make sure we deliver with a good quality and I got many appreciation and spot award for my work.
5. Also implemented SCD types with fallout logic.
6. Also did a design to move data from CDMT to Integration layer and from there to Department...

Info Assist, Quick Data

WebFocus Developer Studio

From March 2012

Report Painter, Composer (layout), Advanced Graph Assistant,
SQL Report Wizard
• Scheduling Tool: Report Caster

PRISM (IPTV) is a key product for CenturyLink. Sales, order, implementation and support metrics are key to managing the business. The PRISM Datamart provides access to PRISM data from disparate sub-systems, which in turn support a variety of business management reports.
Client Base is referred as follows:-
i. Market Analysts (Primary Customer/Owner)
ii. Regional management
iii. Customer Support
iv. Marketing
v. Finance
vi. Content Provisioning
The Webfocus reports are developed for the below metrics:- i. Ad hoc querying (#1 priority)
ii. Daily reports:
iii. Order Metrics
iv. SLA
v. STB Activation Inventory
vi. Weekly reports (scheduled):
vii. Provisioning Metrics
viii. Monthly reports (scheduled):
ix. Support Metrics
x. Finance Metrics
Roles & Responsibilities:-
1. I have developed nearly 30 Webfocus reports for L-Q and L-CTL Prism application.
2. I have also developed Dashboards using Webfocus composer and info assist tools, which was
appreciated by Management.
3. I had given Webfocus training across the organization.
4. I have developed Webfocus reports using Procedure viewer, Report painter, SQL Report Wizard,
Advanced Graph Assistant and Text Editor tools.
5. I have learnt and implemented few reports using Webfocus Quick Data.
6. I have reduced the PDF output file size to <50% of its original size using Focus commands.
7. I have used run in background mode to run some of the big reports, which saves lot of our time.
8. I have used Report Caster to schedule my reports.
9. I have used "Library" to schedule and send out a mail alert after report completes.
10. I had performed SFTP of reports to some other server.
11. I had also developed some of the Active reports in Webfocus.
12. I had also designed HTML page using HTML composer.

Project #4. Actuate2Cognos (Qwest-CenturyLink USA) - IBM Cognos

Software Engineer

Qwest Telecom Software Services Pvt. Ltd

From September 2010

Work Experience

Hands on experience in end to end development which includes Requirement Reviews, Analysis, Impact Analysis, Design, Coding, Artifact Reviews, Peer Reviews, Implementation, Unit Testing, Documentation. Assisting system testers and business analysts for performing System Test, Regression Test and UAT. Pre production and Post production Analysis with validations.

CenturyLink (Qwest) Technologies India Pvt. Ltd.
Project #1. Performance Analysis System (Qwest-CenturyLink USA) - Informatica
Operational Readiness:-

ETL Tools: Informatica Tool

September 2010 - November 2012

• Language: SQL, PL/SQL
• RDBMS: Oracle 9i, 10g
• Scripting: Unix
• ETL Tools: Informatica Tool
• Scheduling Tool: Control-M

This project provides a means of CDI to send certain data elements from the Billing System Account Receivable feeds to accomplish data augmentation for the Billing Account invoice data. Generally, CDI is adding customer identifiers [MCID, QCID, et al], adding Sales Rep and associated data, adding product and financial data for the billing account, and determining/adding customer segmentation information.

Roles & Responsibilities:-
1. Involved in developing mapping to populate data from various systems to the single data
2. To process the flat files, I have created the Config files, this will be stored as a .parm in the Config
3. Involved in parameter files generation for all the staging mappings.
4. Extensively worked with most of the transformations.
5. I have developed few scripts to extract data from CDI file and create DATA and Control file, export
table data to file and to perform FTP.
6. Involved in Unit test case preparation and performing Unit Testing.
7. I have also prepared TBD (Team Based Development).

Project #3. PRISM (Qwest-CenturyLink USA) - WebFocus

Cognos8 , cognos10, IBM Cognos Life Cycle Manager


September 2010 - March 2012

LCM) and Fair Knowledge on Framework Manager
• Scheduling Tool: Cognos Scheduler

Company was using Actuate as one of Business Intelligence tool for more than 15 applications both Internal and External applications. Later they decided to migrate from Actuate to Cognos in which all the Actuate Reports were replaced with new Cognos reports which provides the same functionalities as actuate reports.

Roles & Responsibilities:-
1. I was involved in Converting applications like JAADU, SHIELD, EZWARP, CEC, NFMS Phase1 and 2, and OSPWEB with full ownership.
2. I have gather the requirements by analyzing the Actuate report and I was involved in Requirement
gathering, design, coding and Unit testing of the reports.
3. I have used to develop the reports and I use to schedule it based on the user request.
4. I have developed nearly 30 to 35 Cognos reports.
5. I was involved in upgrading from Cognos8 to Cognos10.
6. I have used IBM Cognos Life Cycle Manager (Cognos LCM) and created a document on it.
7. I worked on Production Issues as well.

Software Engineer

carried out following activities in the above mentioned projects:

• Involved in Analysis, Requirement Reviews, Design (LLD/HLD), Coding, Testing (Unit Test/System Test/UAT), Implementation, Including Documentation (Best Practices, User Manual and Lesson Learnt)
• Interaction with Team members to know the complete flow of the project and enhancing the business knowledge on the product.
• Interaction with Testing team to devise strategy for a comfortable test environment.
• Involved in applying the CMMI process for the project.
• Participated in Review & Walkthroughs.
• Performing self review of my developed components/Artifacts.
• Co-ordinating with onshore team to understand the functional/techinical gap if any thing found during the requirement walkthrough.
• Assisting the testing team during their functional, system and regression testing.
• Supporting the Users during the UAT and helping them to understand the techincal flow and clarifying the gaps if any.
• Doing the end to end verification before delivering to the next phase.

Qualifications & Certifications

Visveswaraya Technological University

Marimalappa Pre-University College

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?