Phone: +91-9884824970
Email: bvjeys@gmail.com
VIJAYANARAYANAN B
Career Statement:
A challenging career in development or support projects where I can develop my skills and contribute the same to the company.
Technical Expertise:
|
Domain |
Data Warehousing |
|
Tools |
Informatica Power Center, Toad, SQL Developer |
|
Scripting Language |
SQL, PL/SQL |
|
Database |
Oracle 9i, 10G, 11G |
|
Operating System |
Windows XP, Unix |
Experience summary:
|
Total IT experience |
9 years |
|
Informatica ETL Developer |
5 years |
|
Oracle SQL, PL/SQL |
4 years |
Star of the Month Award – Nov 2012
Best Reviewer Award (Astra Zeneca MDM Remediation Project)
Innovator Award – 2011
Certifications:
Oracle Certified Professional (OCP)
Informatica Certified Specialist (ICS)
Employment History:
May 2014 – Present | Tata Consultancy Services | Chennai, India
-------------------------------------------------------------------------------------------------------
Assistant Consultant
Currently working for Barclays client(Investment Banking) as a Team Lead for the ADSU BAU project
Involved in understanding the business requirements with the Business Analyst and do technical analysis from my end to proceed with the development
Preparing the development, testing estimations and sharing it with client
Developing Informatica mappings, mapplets, reusable transformation
Worked in development, unit testing and Integration testing
Worked in monitoring the UAT jobs daily and fixing the failure before moving the jobs to production
Every quarter there will be a release and I have involved in deploying the enhancements in production environment and monitoring it for failures
Will be coordinating with the source system like SunGard(GMI, Ransys) to get the source files delivered in an agreed format
Will be coordinating with the reporting team to give a proper handshake once the informatica load gets completed to enable them generate the report
Work with the QC team to get the testing approvals done once I complete the development
Coordinated with the DBA Team to get the DB refresh done in UAT with the production data before each and every development cycle starts
PROJECT: ADSU (Agency Derivatives Services Unification)
Agency Derivatives Services Unification (ADSU) is the latest strategic initiative undertaken in Futures world to on board OTC trade processing and reporting. This is being done to remove the redundant pieces of infrastructure/architecture which performs the similar functions but for the different asset classes’ i.e. F&O and OTC swaps and to integrate & tie up together the similar across both the asset classes.
The OTC products under consideration as
Interest Rate Swap(IRS)
Credit Default Swap(CDS)
Non Deliverable Forward FX Swaps(NDF FX)
Platform & Technology:
Informatica 9.1, Oracle 11g, Autosys scheduler, UNIX, Perforce Version controller
April 2010 – May 2014 | Cognizant Technology Solutions | Chennai, India
-------------------------------------------------------------------------------------------------------
Associate – Projects
Worked for client - Astra Zeneca, to develop RA Central (Resource Allocation Central) system with INFORMATICA 9.1, ORACLE 11g and UNIX
Lead the Astra Zeneca MDM remediation development project modules - Product Master and Territory Master
Completed the project Modules on-time and got the Best Reviewer Award, Star of the Month Award
Worked for the client Ingersoll Rand – Trane Cooling Systems as a developer in setting up of sites for the clients through TIS (Trane Intelligence Services)
Worked on the development of INFORMATICA ETL load activities
Involved in monitoring of the ETL load process and rectifying the issue tickets
Got Innovator of the Month Award for automation of a manual process with spreadsheet Macro
Involved in the Project Quality Auditing for my projects
PROJECT: AZ Canada Optimal Targeting Remediation
Synopsis:
The project is to enable Astrazeneca implement a new “Target Master” for all Sales and Service channels at AZC.
The current Optimal Targeting (OT) solution provides a means for setting and tracking detailing activity targets for the Primary Care, Primary Specialty, and Specialty Care sales reps in Canada. Each district/territory is provided a spreadsheet that contains a list of customers identified in their territory. That list describes the historical detailing activity for each customer, ratings based on the number of prescriptions written by that customer (and the percentage of those that are AstraZeneca Brands) and recommendations, based on market analysis, for the level of activity that should occur during the current year.
AstraZeneca is considering building a new version of the OT solution with the following expected benefits:
Enable more frequent updates to the targeting plans. The current solution involves distribution and collection of the spreadsheets, which limits the frequency with which the data can be collected and distributed to the teams
Reduce the number of manual processes involved in the optimal targeting process. Currently, the process involves a great deal of manual ETL activity and management processes.
Create a Targeting Master that will store centrally all AZC Customer Targeting data, across all channels, which will include targets, customer ratings, and customer/employee metadata, (i.e., Account Management, Product Leads). The Targeting Master will publish this data to other AZC systems, specifically EDW.
Be integrated where possible with AZC Master Data Solutions to streamline processes and duplication of effort.
Ability to target and rate non-physician customers in the new process.
EDW is getting remediated to accommodate the changes made to the existing system and load the data into EDW.
Platform & Technology:
Oracle 11g, Unix, Informatica 9.1, Oracle SQL, PL/SQL
PROJECT: AZ Canada MDM Remediation
AstraZeneca had implemented a Master data Management system to provide consistent dimension data. As a downstream system, Enterprise Data Warehouse (EDW) had to be modified to reflect the data from the MDM. Existing systems were supposed
to be cut off post remediation.
Platform & Technology:
Oracle 11g, Unix, Informatica 9.1, Oracle SQL, PL/SQL
PROJECT: IR – TIS – Development
TIS is a software application that collects and analyzes data from around 10000 monitored customer facilities. Facilities which are located across all the zones in the US are equipped with Tracer Summit building automation systems to collect records every 5 to 15 minutes from each equipment. TIS generates charts, reports, and notifications derived from that data after performing analytic calculations and sends to Business users periodically Trane-TIS loads transactional data collected from equipments across facilities into Warehouse tables (Dimension and Facts). Analytic calculations are performed on warehouse data and metrics required for charts, reports and notifications are populated into WH.
Platform & Technology:
Oracle 10g, Unix, Informatica 9.1, Oracle SQL, PL/SQL
March 2008 – February 2010 | Ericsson India Pvt Ltd. | Chennai, India
-------------------------------------------------------------------------------------------------------
Software Engineer – Charging System
Worked as a developer for the Charging system
Developed Oracle Packages for the ETL Process
Have done Product Customization for customers – Saudi Telecom, Mobilini, Indonesia Telecom
Involved in resolving the High priority TR’s (Tickets Raised) within the stipulated time
Exported and Imported the data in the development environment to mirror it and test the developed procedures and packages before moving the development to production
Trained new resources in the Team in ORACLE SQL and PL/SQL
Product: Ericsson Charging System (CS) – Charging Data Reporting System
Ericsson Charging System is designed to enable real-time charging of voice, SMS, MMS, content services and applications deployed in the operator-controlled domain.
The
Charging System is the evolution of Ericsson Prepaid System, but is
now also targeting post-paid subscribers. With the Charging System
you can charge for your applications, services and content in
real-time and reach all subscribers, no matter if they are pre- or
post-paid.
Charging Data Reporting System (CRS):
Charging Data Reporting System (CRS) is a charging data toolbox that collects, enriches and correlates charging information from multiple sources for storage in the system. This charging data point is accessible online for Customer Care (usage and account history). Data Marts are used to report on the aggregated enriched data and to speed up the reporting performance. Standard audit and financial reports are provided; more reports can be created using the Business Objects reporting environment. CRS is the base for three features: Usage and Account History, Enriched Data Exports and Enriched Reporting.
Platform & Technology:
Oracle 10g, Sun Solaris 10, Clear Case Tool, Oracle PL/SQL
December 2006 – February 2008 | Hexaware Technologies Ltd | Chennai, India
-------------------------------------------------------------------------------------------------------
Software Engineer – Eagle Pace & Star
Developed/Modified Shell Scripts and Oracle SQL Scripts for the client product Eagle Investment Systems – Pace and Star
Responsible for the upgrade and New release of Eagle Pace and Star
Will perform reconciliation between upgraded and Installed versions to analyze and fix-up the issue
As a developer I do perform unit testing by dropping and recreate the Oracle users to test the privileges for the installed or upgraded version
Conducted walk-in drive for recruiting experienced candidates
Gave project training to the newly recruited persons in the team to get adapted to the project
PROJECT: EAGLE
Every year Eagle Investment Systems go for a new release, up-gradation of Eagle PACE and STAR involves creating/modifying shell and sql scripts to run against the Oracle Server database. It also involves testing for the installation of the correct versions in the PACE and Engine and to check if the engines start successfully after the installation.
Reconciliation between Install and Upgrade 8.0 is undertaken at regular periods, analyzed and Issues fixed.
Platform & Technology:
Eagle STAR panels, PACE Database, Shell scripts, Oracle 9i, Sun Solaris 2.8
November 2005 – December 2006 | SQL Star International Ltd | Chennai, India
-------------------------------------------------------------------------------------------------------
Consultant - Oracle SQL, PL/SQL, Oracle Forms and Reports Trainer
Completed Oracle Certificated Professional (OCP)
Conducted class room trainings in Oracle SQL and PL/SQL for Hexaware Technologies, Wipro Technologies, Infosys
Conducted class room trainings in Oracle Forms and Reports for Ashok Leyland
Education:
Graduation:
2001 - 2005
B Tech – Information Technology
Sree Sastha Institute of Engineering and Technology
Anna University
Chennai, India
Higher Secondary:
2000 – 2001
K.R.M.M Higher Secondary School
Chennai, India
Matriculation:
1998 – 1999
K.R.M.M Higher Secondary School
Chennai, India
Short Courses:
Completed class room trainings in Informatica 9.1, Oracle SQL, PL/SQL, Oracle Forms and Reports, Oracle PL/SQL Best Practices.
Hobbies and interests:
Attending Swimming and Playing Badminton with my office colleagues