Resume

Sign in

Java Developer

Location:
United States
Salary:
60
Posted:
October 21, 2019

Contact this candidate

Resume:

Swarupa

adam5r@r.postjobfree.com

No Sponsorship required (EAD).

PROFESSIONAL SUMMARY:

•7+ years of overall Experience in Analysis, Design, development and implementation of Data warehousing using Informatica Power Center and Teradata.

Extensive experience in developing, maintaining and implementation of EDW, Data Marts, ODS and Data warehouse with Star schema and snowflake schema.

Proficient in Operational and Dimensional Modeling, ETL (Extract, Transform and Load) processes, OLAP (On-line Analytical Processing), dashboard designs and various other technologies.

Experience in problem management involving problem managers and RTB Teams.

Expertise on Service Now incidents, IMR (Incident Management Record), CMR (Change Management Records) process and management.

Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.

Expertise in fine-tuning the mapping and sessions by identifying the bottlenecks to improve the performance.

Followed and Implemented Best Practice methodologies,

Extensively used Informatica Designer for developing mappings, mapplets/Transformations, workflows and performed complex mappings based on user specifications

Strong experience in Scheduling jobs using AUTOSYS and using UNIX Shell Scripts.

Good knowledge of Teradata Architecture and Data Warehouse concepts and principles- Star schema, Snowflake, SCD, Surrogate keys, Normalization/De-normalization.

Extensively worked on EAI space to integrate, Extend and connect applications using TIBCO Business Works 5.x, TIB-ADB Adapter, TIB-EMS, TIBCO Administrator and TIBCO Designer.

Good Working Knowledge on Teradata architecture and loading utilities (BTEQ, FLOAD, MLOAD).

Worked on several pallets including Http, File, Ftp, General, etc..

Played the role of an offshore Team Lead for the Sub Advisor Workflow Process Improvement project. Was involved in the design of the new process, code review and training of offshore team members

Performing application and Technical upgrade for applications in the Investments domain. Unity Financial Reporting and Eagle Pace are a couple of applications to name a few.

Experience in Code Review, Testing, Debugging and Error handling of Informatica

Expertise in Production support, UAT support including error handling, system enhancements and fine tuning for performance improvement and also Skilled in Root cause Analysis and Problem solving skills.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, design, development, unit testing, systems integration and user acceptance testing and deployment.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business users, developers, teams across multiple disciplines.

TECHNICAL SKILL SET:

ETL – DW Tools

Informatica 9.x/8.x/7.x

Reporting Tools

Business Objects XIR2/6.5 (Supervisor, Designer, Business Objects), Unix .

Websphere Tools

IBM Web Sphere MQ.

Tibco Tools

TIBCO Business Works 5.6, TIBCO Runtime Agent 5.6.0, TIBCO Administrator 5.7, TIBCO Active Data base (ADB) adapter 5.5, TIBCO Hawk 4.7/4.8

Programming Languages

C, C++

Databases

MS SQL Server 2008/2005, Oracle 11g/10g/9i/8i, PL/SQL, MYSQL,TERADATA

UNIX Tools

Shell Script

GUI

Visual Basic 5.0/4.0, Excel, Power Point.

PROFESSIONAL EXPERIENCE:

Client: CVS Health, Richardson, TX Oct 2018 – Till date

Role: Sr. Informatica/Teradata Developer

Responsibilities:

Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.

Involved in Analyzing / building Teradata EDW using Teradata ETL utilities and Informatica.

Worked on flat files as sources, targets and lookups.

Prepare Analysis and Design Documents, Source to Target Mappings documents and Unit Test Case documents to get the code ready for production.

Deployment of Informatica components, Teradata Objects, Unix Scripts using Serena Dimensions a deployment tool.

Expertise with connected and unconnected transformations like look up, aggregator, Expression transformations.

Extensively used BTEQ’s to Load data from Land to Stage and Stage to Target.

Used PMCMD to start and abort sessions and tasks. Also, used INFACMD to track the status of the applications and automate the service notification emails.

Developed mappings/sessions/workflows using Informatica Power Center 9.6 for data loading. Developed mapping to load the data in slowly changing dimension (SCD).

Load data into Teradata from legacy systems and flat files using Multi-Load and Fast Load Utilities.

Used Informatica parameter files to filter the daily data from the source system.

Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.

Involved in Data Quality Analysis to determine the cleansing requirements.

Used various debugging techniques and informatica debugger tool to debug the mappings.

Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Responsible to provide resolutions for production incidents/failures, user requests and problem tasks.

Need to interact with business users, Tier 1, Tier 2 teams for project implementations and during release support.

Created User views for users to select only required columns for performance.

Responsible for scheduling the workflow based on the nightly load.

Environment: Informatica 10, Teradata 15.10, Oracle, UNIX, Maestro, Windows 7.

Client: UBS, Stamford, CT Jan 2017 – Sep 2018

Role: Sr. Informatica/Teradata Developer

Responsibilities:

Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.

Exclusively worked on the transformations like Aggregator– to get monthly, quarterly, Yearly claim aggregations, Connected & unconnected lookups .

Involved in Analyzing / building Teradata EDW using Teradata ETL utilities and Informatica.

Also, involved in tuning the mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.

Worked on flat files as sources, targets and lookups.

Expertise with connected and unconnected transformations like look up, Stored procedure, aggregator, Expression transformations.

Used PMCMD to start and abort sessions and tasks. Also, used INFACMD to track the status of the applications and also automate the service notification emails.

Executing Teradata commands to add more PERMANENT, Spool, and/or Temporary space to databases.

Implemented various optimization techniques in Aggregator, Lookup, and Joiner transformation.

Developed mappings/sessions using Informatica Power Center 9.6 / 9.5 for data loading. Developed mapping to load the data in slowly changing dimension (SCD).

Load data into Teradata from legacy systems and flat files using MultiLoad scripts and FastLoad scripts.

Used Informatica parameter files to filter the daily data from the source system.

Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.

Involved in Data Quality Analysis to determine the cleansing requirements.

Used various debugging techniques and informatica debugger tool to debug the mappings.

Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Created Oracle Stored Procedure to implement complex business logic for better performance.

Responsible to provide resolutions for production incidents/failures, user requests and problem tasks.

Need to interact with business users, L1, L2, Upstream and downstream applications and ensure the smooth functioning of the application

Created Materialized view for summary data to improve the query performance

Responsible for scheduling the workflow based on the nightly load.

Supported Oracle 10g databases running mission critical 24*7 systems.

Used PMCMD extensively to start, stop, schedule, and monitor informatica workflows.

Environment: Informatica 9.6/9.5, Teradata 15.10, Oracle, SQL Developer, UNIX, Autosys, ServiceNow, Windows 7.

Client: Vanguard, Malvern, PA Jul 2015 – Dec 2016

Role: ETL Developer

Responsibilities:

Extensively used ETL to load data from Oracle database, flat files to different target systems.

Expertise with connected and unconnected transformations like look up, Stored procedure, aggregator, Expression transformations.

Worked with the flat files in both the direct and indirect methods .

Used the techniques like Incremental aggregation, Incremental load and Constraint based loading for better performance.

Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.

Understand business process and draft technical design documents based on the functional documents.

Involved in the development of Informatica mappings and tuned the session for better performance by implementing the pre/post-load stored procedures for target optimization.

Used various Oracle Index techniques and partitioning concepts on databases to improve the query performance.

Worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.

Written Unix Scripts for event automation which included PMCMD to start the workflows.

Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.

Stopping and starting the Informatica servers.

Analysis and design of ETL processes.

Involved in loading huge volume of data from source to target.

Monitoring the logs in the Director and troubleshooting.

Used bulk load to insert huge volume of data into target

Created Test Plans for Unit Testing for designed jobs.

Environment: Informatica 9.1, Oracle 10g .

Company: Tata Consulting Services, Hyderabad Jan 2008 – Feb 2012

Project : Tata Teleservices Limited, Hyderabad Jan 2008 - Feb 20110

Role: Software Engineer

Responsibilities:

Implementation of changes in CRM-Billing interface for any functionality Change Requests

Developed Repos to reduce manual effort in rectifying CRM to BP rejects.

Worked on several pallets including JDBC, Http, File, Ftp, General, etc.

Designed the Starter processes and sub processes by using TIBCO BW.

Production Support and maintenance activities for the interface between CRM and Kenan FX Arbor BP (Billing Product).

Casual Analysis and providing permanent solutions to the critical billing problems identified

Provided quick resolution to the billing errors so as to ensure zero loss of revenue to the client.

Playing a key role in SLA compliance reporting & monitoring

Liaison with Solution Design and Development teams for resolution of critical production issues requiring design changes.

Given Sessions to all team members and new joiners on complete Billing system.

Identified potential problems due to CR rolled outs and suggested possible solution to mitigate the risk involved with rollouts.

Code review for production fixes.

Environment: TIBCO Business Works 5.6, TIBCO Runtime Agent 5.6.0, TIBCO Administrator 5.7, TIBCO Active Data base (ADB) adapter 5.5, TIBCO Hawk 4.7/4.8

Client: Clearing Corporation of India Ltd. (CCIL), Mumbai Mar 2010 – Feb 2012

Role: Assistant Systems Engineer

Responsibilities:

Worked as ETL Developer in the Team.

Responsible for the mapping and Workflows development.

Worked extensively with Teradata utilities –Fastload, Multiload, TPump to load huge amounts of data from flat files into Teradata database.

Used Informatica power center Extract, Transform and Load data into Data Warehouse from various sources like Oracle and flat files.

Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.

Responsible for the Code migration across the different test environments.

Responsible for the Defect Fixes in the test environment.

Did extensive requirement analysis on the new developments and enhancements

Attended several project meetings to discuss/Address the technical issues.

Environment: Informatica Power Center 8.1, Oracle 10i, Teradata, OS Unix.

EDUCATION

Bachelor of Technology: Electronics and communications, Nagarjuna Institute of Science & Technology –Telangana, India in 2006.



Contact this candidate