SHEHNA PARAYIL VIJAYAN

+1-309-***-****

Bloomington, IL

ad37h7@r.postjobfree.com

WorkPermit: H4EAD

PROFESSIONAL SUMMARY

** ***** ** ** ********** in Analysis, Design, Development, Data Modeling and implementation of Client/Server, Data Warehouse/Data Mart & Business Intelligence, Web applications in Insurance, Retail, Industrial, Healthcare, Automobile sectors

Over 10 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.X/8.x/7.x/6.x

Dimensional Data modeling experience using Data modeling tool Sybase Power designer modeling

Strong experience with business requirement analysis, source system analysis, Data Analysis

Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from/to various sources/targets like DB2, Oracle, Flat files, and XML files, Teradata, Sybase and MS SQL Server, SAP and MS SQL Server, Web Services and SAP Interfaces

Created UNIX Korn Shell scripts for Informatica post and pre-session operations

Hands on experience in tuning Informatica mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session

Hands on experience in scheduling jobs through Autosys and Tivoli.

Hands on writing Unix Shell & Autosys JIL scripts and PERL Scripts

Hands on experience in maintaining the code versions using Visual Source Safe.

Hands on working in Informatica Master Data management (MDM)

Proficient in writing complex Oracle SQL, Views, for database applications.

Done POC in AWS Glue/S3/Athena

Good Knowledge in AWS Cloud with S3, EC2, VPC, Elastic beanstalk, CloudTrail, Lambda, API, RDS, Glue, Athena, Snowflake, Redshift

Good knowledge in Informatica cloud (IICS). Done POC in IICS with cloud database

Good knowledge of Bigdata Hadoop, Pig & Hive

Good Knowledge in Reporting Tool Business Objects Reports XI and Crystal Report, PowerBI

Good knowledge in Informatica Data Quality (IDQ)

Good Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups

EDUCATION & CERTIFICATION

Master of Computer Applications in 2004, University of Madras, India

Bachelors in Physics in 2001, University of Madras, India

Informatica Certified Designer in 2008

Preparing for AWS Developer Associate Exam/ Snowflake Cloud certification

TECHNICAL SKILLS

SL#

NAME

DESCRIPTION

1

OS

UNIX, AIX 5.2, Windows 7/XP/2000/NT

2

ETL/Reporting

DTS in SQL Server/SSIS, Informatica PowerCenter 10x,9.6/8.X/7X, Business Objects XI, Tableau, Microstrategy, Microsoft PowerBI

3

Database

Oracle 10g/9i/8i, DB2, Teradata/ Netezza, MS-SQL Server 2000/2005,Redshift

5

Data Modeling

Sybase Power Designer 15.2

6

SQL Editor

PL/SQL Developer, TOAD for DB2

7

Scripts

UNIX Shell, PERL, Autosys JIL, JavaScript, Python

8

Scheduler

Autosys, Jenkins

9

Config & Mgmt

Visual source safe, Quality Center

10

Web Applications

ASP, VB .NET & ASP.NET, PHP, HTML

11

Cloud

AWS /Snowflake/ Informatica cloud (IICS)

WORK SUMMARY

Cognizant Technology Solutions (Client - Mercury Insurance), USA

ETL Tech Lead

Oct 2021 – 6th March 2024

Emp#id: 671678

Roles and Responsibilities

Support the Financial Data hub. ETL testing using SQL server SQL scripts

Report Data Analysis generating month/y/quarterly reports writing SQL scripts

Incident-Defect Analysis using SQL queries

Automated the existing manual process of Escheatment using ETL Informatica PC

Environment: Informatica PowerCenter 10x, AWS Redshit database, MS SqlServer, Db2, Tivoli Scheduler, UNIX, Jenkins, Jira, Microsoft PowerBI / Microstrategy Reporting tool, SAP Data Services

Infosys, (Northwestern Mutual, Wisconsin, USA)

Jan 2020 – Dec 2020

ETL Tech Consultant

Roles & Responsibilities

Support the General Ledger application

Data analysis/Data modelling/ development/testing of the financial application

Part of POC team migrating Informatica PC mappings to Informatica cloud

Environment: Informatica PowerCenter 10x, Informatica Intelligent Cloud services IICS, Oracle, UNIX, Autosys, PeopleSoft, Sybase Power Designer, J ira

CVS Pharma, Buffalo Grove, IL

Mar 2018 – July 2019

ETL Informatica Developer

Roles & Responsibilities

Data Analyst role understanding the Medicare/Medicaid process/flows of CVS Retail Data Warehouse

Ran reports using SQL scripts

Collaborate with core technical team inside and outside vendors for implementation

Involved in POC developing and testing the new functionality

Involved in the migration of informatica workflows from version 9.6 to version 10.2

Performed detailed Data Analysis to identify the root cause of production issues and provide solutions in the permanent schedule

Involved in creation of ETL mappings through Informatica PowerCenter /Testing/deployment

Co-ordinate with all the business users, SMEs and process owners to complete the activities of SDLC phases

Environment: Informatica PowerCenter 10x/9.6, Oracle 11g, UNIX, Flat Files, Control – M

Zurich North America, Schaumburg, IL (contractor from Cognizant Technology Solutions, USA)

Dec 2017- Mar 2018

Data Analyst/ETL Developer

Responsibilities

Involved in data analysis/code change analysis as part of the change request

Implement ETL code/Shell script change/SQL/Autosys JIL Script as per the change request

Co coordinating with offshore on the change request/Unit testing the ETL code done by the offshore team

Daily status updates given to the business on the code changes /testing

Environment: Informatica PowerCenter 9.6.1, AQT for Netezza, AQT for DB2, UNIX, Autosys

Deere & Company, Moline, IL (IBM India Pvt Ltd)

Jan 2011 – Jan 2014

Data Analyst/ETL developer

Responsibilities

Involved in translating business requirements to Technical specifications.

Involved in full project life cycle - from analysis to production implementation and support

Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.

Work as Data Modeler using the Sybase Power Designer to design the tables needed for the dashboard project. Developed the high-level design to map the data from source into the data mart tables

Develop the source to target mapping document for ETL development in Informatica PowerCenter

Perform system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data warehouse/ Data mart models according to the source to target mapping document

Assist business analysts/users in identifying data gap and data variances

Work with source system SMEs to identify the source data to be brought down to the Data mart

Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.

Create and execute unit test plans based on system and validation requirements Troubleshoot, optimize, and tune ETL processes

Applied the Teradata utilities of Multiload, Fastload, worked on B-teq script

Used Informatica Designer to design transformations, reusable transformation, mappings and Mapplets

Update the data dictionary on system data and mapping information

Responsible to create interactive Dash board reports as per the Business requirements.

Documented and maintained and ensured the process and quality of the system.

Environment: Sybase Power Designer 15.2, Informatica PowerCenter 9.1, DB2 9, Toad for DB2 4.5, Teradata 14.0, Flat Files, Quality Center, UNIX and ESP

Pfizer Data Services – S4 Operate, USA (IBM India Pvt Ltd)

Aug 2008 – Dec 2010

Senior ETL Developer (India location)

Responsibilities

Involved in translating business requirements to Technical specifications. Also performed Column Mapping & identifying the Business Rules for some of the requirements.

Involved in the Preparation of Detail Design Document (DDD).

Developed ETL jobs to extract information from disparate systems like SAP, DB2, Flat Files, Oracle, MS SQL and XML’s.

Involved in creating stage tables/mappings/ setting the trust level -HDD in Siperian for Customer Master system

Performed Source system study to load the Hierarchy Table. Created Multiple Mappings to load data from including mainframe data available in DB2 schema.

Worked extensively on Margin controlling system, which is rated as critical for Business and successfully loaded multiples tables as required for reports.

Extensively used Informatica to load data from DB2 and flat files into staging & loading area.

Performed various transformations, aggregations and ranking routines on the data to be stored in the Data Provisioning Mart

Used Informatica Designer to design transformations, reusable transformation, mappings and Mapplets.

Developed and modified existing Hierarchy Table to increase the level of granularity for BO reporting requirements.

Used Informatica workflow manager to create sessions and workflows for corresponding mappings.

Conducted unit testing and generated test case reports to ensure the expected Business Standards.

Documented the mappings and workflows & periodically updated the status of the work assigned to the system Owners.

Involved in identifying the performance Bottlenecks on source, target, mapping, session and successfully tuned them to increase session performance as wells as Oracle views.

Created mappings in designer to implement all different types of slowly changing dimensions.

Involved in the code reviews and bug fixing of mappings in production to increase the efficiency.

Documented and maintained and ensured the process and quality of the system

Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table

Environment: Informatica 8.1.1/8.6.1, Oracle, SQL Server, SHELL script, SIPERIAN tool (MDM), Autosys

AXA PPP Healthcare for UK

Aug 2006 - Jun 2008

ETL- Informatica Developer (India location)

Responsibilities

Involved in the ETL Design and Development of Informatica Mappings

Involved in Requirement Gathering, Analysis and Design for Loading the VSAM file in to SAP through Power Connect for SAP

Prepared Unit test Plans and System Test Plans

Created PERL scripts for Unzipping / Archiving source files and performing looping operations

Performed Unit testing and delivered the IDOC Status Report for each file posted to SAP conducted Informatica Power connect (SAP ALE IDoc methodology) training to the team

Tuning Informatica Mappings and Sessions for Optimum Performance.

Executed prototypes for ETL and Data Quality demonstrating their capabilities while training the team to use of the new platform.

Project management activities:

Adherence to quality process

Responsible for on time delivery

Ensuring Reusability and continuous learning

Experience in Unit testing and Integration Testing of different process in Data warehouse.

Quality Center is used to document test cases and test cases are executed in Quality center for each new release.

Environment: Informatica PowerCenter 7.1.3, Toad for Oracle, Quality Center, PERL script

CarbonOn Tech, India

Feb 2005 to Aug 2006

Software developer

Web Based Applications

CarbonOn Tech is a Web based development and Game Art + Game development outsourcing company based in India

Responsibilities

Studying existing functionality.

Involved in DB design. Creating web-based reports using ASP and Windows based report using VB.NET

Developed mappings using DTS to extract CSV files to SQL server DB

Developing the Stored Procedures

Performing code migration from Dev to Test Unit testing the modules.

Created Job package using DTS that sends emails periodically using SQL Server Job scheduler.

Import Excel Sheets to SQL-Server database using DTS mappings.

Development of stored procedures.

Written complex SQL using joins, sub queries and correlated sub queries.

Environment: ASP 2.0, SQL Server 2000, IIS and JavaScript, DTS (Microsoft Server ETL tool), ASP.NET 1.1, C#.NET (code behind), Microsoft Application Blocks (Data Access), DTS in SQL Server 2000, Microsoft Visual Studio.NET 2003, VB.Net Windows Forms, Crystal Reports, SQL Server 2000 (DTS)

Contact this candidate