Developer Data

Soumya Sangameswar

*** ********* **., *** ****, Wayne, PA-19087 • 484-***-**** • ac4dog@r.postjobfree.com

Career Snapshot

Worked as an Informatica developer for 4 years.

Worked on Informatica Power Center tool - Source Analyzer, Target & Mapping Designer and Transformation Developer.

Developed complex mappings using transformations like Expression, Aggregator, Filter, Lookups, XML, Joiner, Update Strategy, Router, Sorter, Union etc.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle and Flat files.

Worked on Informatica Power Center tool - Task Developer and Workflow Designer.

Worked on various workflow tasks like Session, Command, Email and Link tasks.

Developed PL/SQL stored procedures and triggers.

Used PLSQL developer tool to run SQL query to view and validate data loaded into the database and troubleshoot data issues.

Experienced in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Good knowledge of UNIX Shell Scripting.

Passed Salesforce Administration certification.

Good knowledge of Salesforce Apex and SOQL.

Excellent analytical, written, and oral communication skills.

Able to develop new projects from scratch.

Education

Master of Science in Computer Science, Villanova University, PA 2016-2017

Subjects: Algorithms, Multimedia Technologies, Game Design & Development, BigData using Python, UNIX & C

B.E. in Information Science & Engineering, BMS College of Engineering, India 2007-2011

Technical Skills

Programming Languages

C, C++, Java, SQL, PL/SQL, UNIX Shell Scripting, Lisp, Python, APEX, SOQL

Database

Oracle 11g, My SQL

Development Tool

Informatica Powercenter 9.1/9.5/9.6, Eclipse, TOAD, PL/SQL Developer, Salesforce

Operating System

Windows 98/2000/XP/Vista/7, Linux, UNIX

Source Control

GitHub

Methodologies

Waterfall

Scheduling Tools

UC4, TWS

Professional Experience

Tata Consultancy Services Ltd, India Sept 2011 - Feb 2015

Systems Engineer

Client: Swiss Reinsurance Company Dec 2013 – Feb 2015

Title : CYTRIC

Role : Informatica Developer

Environment : Informatica Power Center 9.1.0/9.6, Oracle 11g (PL/SQL), PL/SQL Developer, UNIX

Description : Cytric is the new travel management and booking system operated by iFAO in an outside Swiss Re data center in Frankfurt. The interfaces will contain User profile and cost center/project code synchronization mechanisms. It provides Interface database, which stores the user profile and cost center/project code data with an actual timestamp. It provides error handling in case of a logical (data driven) or technical error.

Development of ETL Mappings, Sessions and Workflows for data cleansing.

Used Informatica Transformation like Source Qualifier, Update Strategy, Normalizer, Router, Lookup, Joiner, Aggregator, Sorter, HTTP, XML etc. and all transformation properties.

Followed the required client security policies and required approvals to move the code from one environment to other.

Testing of mappings.

Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.

Performed complex defect fixes in various environments like UAT to ensure the proper delivery of the developed jobs into the production environment.

Used TWS scheduling tool to deploy jobs to various environment.

Attended daily status call with internal team and weekly calls with client and updated the status report.

Client: Swiss Reinsurance Company Jan 2013 – Nov 2013

Title : BAE

Role : Informatica Developer

Environment : Informatica Power Center 9.1.0/9.6, Oracle 11g (PL/SQL), PL/SQL Developer, UNIX

Description : BAE is an application that loads data into the Oracle database and generates reports that are used by the Chief Investment Officers at Swiss Reinsurance Company. It contains all the details about the feeds, reports and checks. Data is loaded from various source systems into DB and reports are generated. The feeds and reports are run every day as a batch job.

Analyze the functional specifications provided by the Data Architect and created technical specification documents for all the jobs.

Restructure the data jobs to enhance the performance and clarity of the job and also sent the exact data to the downstream systems.

Handle some of the data issues in the jobs, during the release of the project to send the appropriate correct data to the business users.

Perform deployment of project code through UC4 scheduler tool.

Work with the testers closely in determining both medium and high severity defects that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.

Client: Cisco Feb 2012 – Dec 2012

Title : Performance Metrics Central (PMC)

Role : Informatica Developer

Environment : Informatica Power Center 9.1.0, Oracle 11g, TOAD, Java

Description : Performance Metrics Central (PMC) is a one stop location for support performance metrics and indicators for Cisco certified partners who have a service relationship with Cisco.

Analyzing from the given requirement and creating Technical specification document.

Design and Development of mappings to populate the data from various systems to single data warehouse.

Development of workflows.

Checking Performance tuning of the developed mappings.

Preparation of impact analysis document.

Perform Code Review.

Perform Unit testing of the new enhancements and to ensure that other functionality is not getting hampered with new enhancements.

Interacting with team members for understanding functionality & discussing issues.

Drive accelerated defect closure and interaction with the Quality Assurance team for bug free deliverables.

Academic Projects

UNIX & C Summer, 2016

Shift Allocation for Students

Developed Shift allocation project using C programming in which students are used to allocate to various shifts for any particular job and the result of it is displayed in the HTML format using UNIX scripts.

Big Data using Python Fall, 2017

Mining Geotagged Photos from Flickr and Finding its Location on Map

https://github.com/soumya8888/big-data-python-class/tree/master/FinalProject

Developed project to organize a large collection of geotagged photos collected from Flickr to extract tourist’s point of attraction from cities using various python clustering algorithms and locating them on Google map.

Contact this candidate