Archana Nair 704-***-****

ETL/Java/Database Developer

Archana Nair is a skilled IT Professional whose expertise is in Database, ETL and Java development. With her solid experience in development she has provided system support, designed, coded and tested applications, analyzed for solutions using various tools/technologies such as Oracle, Informatica, Teradata, Java/J2EE Perl, Shell Scripts, and SQL in an Agile environment to meet project deadlines.

●6+ years of experience working in IT industry

●Worked in End to End Implementation applications using Informatica, Oracle, SQL, Teradata, Java/J2EE,Shell script,Perl script

●Involved in detailed Analysis, design, development, maintenance and upgrading systems to support business operations.

●Involved in Preparing HLD,LLD, Test cases, Test Plan and Estimations

●Good working experience with Informatica Power Center transformations like Joiner, Router, Update Strategy, connected and unconnected lookups, Expression, Sorter, Filter, Union, Normalizer, etc. Also worked with varied sources and targets like relational tables, flat files etc. Aware of the basic administrative tasks with Integration Service, Repository Manager

●Worked on various Informatica lookup caches like static, dynamic and persistent

●Created several Mapplets and their associated Mappings, Sessions, and Workflows using Power Center tools (Designer, Work Flow Manager, Monitor, and Repository Manager).

●Performed query optimization (Explain plans, Collect statistics, Primary and Secondary indexes)

●Ensured optimal performance of Teradata views by appropriately choosing the indexes of the underlying tables that are part of the view definition

●Implemented multiple performance tuning techniques like compression and statistics collection to improve the Teradata view performance.

●Extensive experience with Stored procedures

●Good hands on for BTEQ, MLOAD and FLOAD Teradata scripts

●Experienced in Performance and tuning of the ETL and complex SQL queries

●Created and Used Workflow Variables, Session Parameters and Mapping Parameters

●Experience in Creating Tables, Views, Indexes, Synonyms, Constraints, Procedures, Shell Scripting

●Experience in Maintenance/Support/Release Management for Java projects

●Experience in implementation of SOA architecture.

●Experience in Java and J2EE frame works like struts and spring .

●Experience in coding using technologies like JSP, AJAX, Java, Javascript .

●Knowledge in Java itextpdf & Jfreechart.

●Experience in WebLogic Administration with deployments & trouble shooting in Production Environment for Business critical application

●Versatile and dependable; able to learn new tools and processes quickly, adapt easily to new priorities and environments, and complete projects on time.

●Strong communication, interpersonal, and organizational skills that support strengths as both independent contributor and team leader

●Experience in all phases of software development life cycle that includes Requirements Analysis, Design, and Development, testing, implementation, maintenance and post production support / analysis

●Proficient in understanding business processes/requirements, translating them into technical specifications, performing gap analysis and producing design and technical documentation and mapping specifications

●Experience working on Onshore/Offshore delivery Model

Database

Oracle 9i/10g/11g, Teradata,V2R12/14, SQL Server 2000, MySql,Tandem Nonstop SQL

ETL Tools

Informatica 8.x, 9.x

Programming

Java 1.5, J2EE, Autonomy, JavaScript, PL/SQL, HTML

Modeling Tools

Toad,IBM Data Studio

Operating Systems

WINDOWS 98/2000/NT/XP, Linux and UNIX

App/ Web Servers

BEA Weblogic (IIS) 8.1 /9.i

Testing tools

Quality Center

Bachelor of Technology in Information Technology, University College of Engineering, India (2006)

Brain Bench Certification in SQL

Sun Certified Java Programmer SCJP

Period: 01/04/2016 to Present

Employer: Unicon Intl

Role: Application Developer

Client: Nationwide;Columbus,OH

Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation

Involved in creating Functional/Technical documents from the Business requirements

Involved in creation of wrapper classes for the existing legacy system as part of the upgrade initiative for the existing application

Worked in Agile Development methodology

Worked on SQR(Structured Query Reporting) scripts as part of application upgrade

Responsible for Shell script upgrade

Responsible for conversion from oraperl to dbi API for perl scripts

Resposible for Harvest to Github conversion for multiple applications.

Worked with Oracle sources and targets

Responsible for conversion of existing C code to Informatica as part of application migration.

Built ETL logic using most of the Informatica Power Center transformations to validate the business rules

Created Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data

Worked with Source Analyzer, Target Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse

Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing

Created Parameter files to pass database connections, parameter entries for source and target

Completed the scheduling of Informatica Jobs and Informatica code Migration

Responsible for Unit testing for the application

Responsible for application migration to different environments

Worked with cross functional teams to resolve the issues

Worked on creating Disaster Recovery Plans and testing that out in North and East Data Centers

Created SQL Queries for Oracle database to validate the data in both source and target

Databases.

Used SQL quesries to troubleshoot database issues

Performed root cause analysis and resolved complex issues

Involved in creation of instructional documents for Release Management and support process

Involved in resolution of Production issues co-ordinating with different teams

Period: 05/12 to 08/12

Employer: Amalgam Technologies Inc

Role: Programmer Analyst

Client: Limited Brands; Columbus, OH

Coordinated with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality

Involved in Java conversion project for reporting

Used itextpdf and Jfreechart api as part of conversion project.

Worked on complex ETL logic using most of the Informatica Power Center transformations to validate the business rules

Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data

Worked with Source Analyzer, Target Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse

Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing

Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic

Implemented slowly changing dimensions & fact loads to meet the business requirements

Implemented Target Load Plan and Pre Session and Post Session Scripts

Created Parameter files to pass database connections, parameter entries for source and target

Completed the scheduling of Informatica Jobs and Informatica code Migration

Worked with Oracle sources and involved in developing Oracle Stored procedures

Developed Shell script to send email attachments,archival of files, creating list file

Performed Data validation by writing SQL queries against source database that resides in SQL Server

Worked on various lookup caches like static, dynamic and persistent

Used the debugger in Informatica to test the mapping and fix the mappings

Created SQL Queries for Oracle/Teradata to validate the data in both source and target databases

Used SQL queries to troubleshoot database issues

Created test cases and test scripts to validate data

Conducted a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed

Involved in planning & coordinating release schedule for each environment

Promoted code fix through each environments & fixing related issues

Provided troubleshooting techniques and fixed issues identified in different environments

Worked with production support team on resolving performance issue for application

Reviewed the detail level design and ensure that the IT standards are followed

Tuned the performance of complex Informatica mappings and database

Worked on partitioning of fact tables

Worked with cross functional teams to resolve the issues

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows

Performed data validations and analysis on Oracle database

Performed performance tuning for Oracle and Teradata

Created instructional deployment documents

Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code

Performed root cause analysis and resolved complex issues

Prepared the recovery process in case of workflow failure due to database issues or network issues

Involved in warranty support and knowledge transfer of each asset after production implementation

Provided status report to management for the application

Involved in ad-hoc testing of the application before handing over the environment to different teams

Period: 06/11 to 05/12

Employer: Amalgam Technologies Inc

Role: Programmer Analyst

Client: TIAA-CREF; Charlotte, NC

Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders

Worked on Informatica Performance Optimization using Push down Optimization and Partition of Sessions

Worked in Agile Development methodology

Performed query optimization (Explain plans, Collect statistics, Primary and Secondary indexes)

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues

Created SQL Queries to validate the data in both source and target databases.

Worked extensively on Optimization of Oracle Stored procedures

Wrote several Teradata MLOAD and FLOAD scripts to do one time loads

Involved in Performance testing

Provided Release Management in Production and Pre Production Environments

Involved in Bug fixing

Used Quality Center to keep track of the Defects and Issues

Used the debugger in Informatica to test the mapping and fix the mappings

Provided the Scheduling of Informatica Jobs, and code Migration

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows

Performed data validations between source system and target DataMart by writing SQL queries for different databases like Oracle, Teradata

Used SQL to troubleshoot database issues

Performed performance tuning for Oracle and Teradata

Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code

Performed root cause analysis and resolved complex issues

Involved in calls with clients to discuss defects and worked with them to resolve it

Ensured optimal performance of Teradata views by appropriately choosing the indexes of the underlying tables that are part of the view definition

Implemented multiple performance tuning techniques like compression and statistics collection to improve the Teradata view performance

Built model tables, complex views for the presentation layer, UPI, NUPI, USI and NUSI in Teradata, as part of enhancements

Prepared the recovery process in case of workflow failure due to database issues or network issues

Conducted a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed

Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document

Involved in the creation and usage of SharePoint based knowledge Base solutions

Involved in creation of instructional documents for Release Management and support process

Designed and performed all activities related to migration of ETL components between environments during development and deployment (E.g. Dev to SIT, SIT to UAT and UAT to PROD repositories)

Period: 01/11 to 06/11

Employer: Amalgam Technologies Inc

Role: Programmer Analyst

Client: USFood Services (USF); Chicago, IL

Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation

Interpreted and comprehend business/data requirements from upstream processes

Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity

Created and documented source-to-target mappings and ETL specifications

Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables

Created scripts for FTPing files, data manipulation and validations

Checked for missing data, negatives and consistency and completed field-by-field data verifications for source and target data consistency

Created slowly changing dimensions tables to meet the business requirements

Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows

Worked with different sources like Oracle, Teradata, SQL Server

Performed performance tuning for Oracle and Teradata

Created sql queries to validate source and target

Used SQL to troubleshoot database issues

Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document

Involved in the defect analysis call for UAT environment along with users

Involved in the creation and usage of SharePoint based knowledge Base solutions

Developed workflows using Task Developer, Worklet Designer, and Workflow Designer in Workflow manager and monitored the results using Workflow Monitor

Prepared Stored Procedures for dropping and recreating Indexes before and after data loads

Prepared the UNIX Shell Scripts to process the file uploads

Worked on the AUTOSYS scheduling tool and prepared AUTOSYS JIL code for scheduling

Worked in production support of application, involving resolution of issues and implementing to production

Involved in calls with clients to discuss defects and worked with them to resolve it

Involved in creation of instructional documents for Release Management and support process

Period: 04/07 to 11/09

Employer: Wipro Technologies Ltd

Role: Project Engineer

Client: GlaxoSmithkline (GSK); India

Designed in MVC model using Spring framework

Involved in Configuration Management activities

Involved in Configuration of Autonomy IDOL Server

Involved in configuring HTTP & File System Fetch components (which include spider & crawling configurations)

Conducted performance tuning of IDOL Server Components

Involved in designing and implementing Service Oriented Architecture

Involved in creating Web services and Clients to invoke Webservices

Involved in coding using technologies like JSP, AJAX, Java, Javascript

Extensively used JavaScript to perform the client-side validations

Implemented logging using Log4j

Used SVN as the Version control tool

Involved in gathering requirements and mapping of the data attributes identified from different source systems which were in Oracle, Teradata, SQL Server, CSV FILES and Mainframe (Data was fed into the data warehouse where it was used by end users to check for data audit compliance)

Used to implement the Change Data Capture logic by slowly changing dimension Type 2

Developed Informatica mappings to extract source data from various data sources like SQL Server, Oracle, and other databases

Loaded the data into the Oracle Operational Data Store

Created/Used SQL queries to validate source and target data

Used SQL to troubleshoot database issues

Informatica Power Center was used to implement the business logics on the incoming data and finally load to the data mart

Used Power Exchange when the source data was from mainframe

Created UNIX shell scripts which were invoked from pre and post session command tasks for updating the parameter file for each session

Involved in the creation and usage of SharePoint based knowledge Base solutions

Involved in creation of instructional documents for Post Production Support Process for the indexing modules

Involved in calls/screen shares with clients to discuss defects and worked with them to resolve it

Period: 11/06 to 03/07

Employer: Wipro Technologies Ltd

Role: Project Engineer

Client: Royal Dutch Shell; India

Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders

Completed Java Application Support/Maintenance

Fixed Tickets assigned based on the priority level

Involved in minor code fixes and enhancements

Monitored availability and performance of the application

Responsible for application availability and outage calls during Outage of the application

Responsible for Weblogic Administration which involves configuration & maintenance of Weblogic Server

Involved in Configuration Management for Production and 4 pre-production Environments

Prepared business requirement document (BRD) for the implementation

Responsible for Release Management Activities(Deployment of new releases of the application to the application server, trouble shooting in case of any failure in deployment, avoiding any sort of outages due to the deployment of new version)

Provided deployment configuration of the Environments in order to make sure the rollout to be successful

Worked on Weblogic scripting tool(WLST) for monitor weblogic server instances

Performance Tuning in case of any performance degradation

Responsible for IIS Administration which hosts our Application thin clients (website)

Configured Secure Sockets Layer, generating Private Key, Digital Certificate

Responsible for VeriSign SSL weblogic certificate renewal on regular interval using Keytool Application that comes with JDK

Worked also involves weekly DB activities such as export and Database refresh processes & SQL querying for troubleshooting in Oracle database.

Took initiative to test the Disaster Recovery Plan testing which involves Configuring of Back up Admin server & switch over for Admin server

Involved in calls/screen shares with clients to discuss defects and worked with them to resolve it

Involved in creation of instructional documents for Release Management and Application Monitoring

Honored with “Thanks a Zillion award" for overall outstanding performance & dedication towards the project in 2008 from Wipro Technologies Ltd

Honored with “Feather In My Cap” performance Award for streamlining Release Management process in 2009 from Wipro Technologies Ltd

Contact this candidate