As a Sr. ETL Developer I am responsible for the following:

• Quickly understand the business requirement, existing ETL solution and propose solution.
• Created HLD, LLD & source to target mapping for ETL development.
• Build, test and deploy database objects, ETL jobs, SQL procedures/scripts.
• Modification of Database Objects, Procedures, Views and Functions as per business need.
• To analyze and accommodate changes in client requirements, after performing impact analysis and effort estimation. Build and test changes in development as well as in UAT environment before production deployment.
• Allocating task to junior team members. If anything new comes to project keep entire team updated in terms of new requirement and enhancements.
• Lead, mentor and help off-shore team member to overcome challenges and achieve milestones.
• To manage and ensure that the project schedules are adhered to as per the client specifications and deliveries are as per the time and quality standards.
• Communication with the Onsite team & solving technical problems.

Yardi Voyager is a web-based, fully integrated end-to-end platform with mobile access for larger portfolios to manage operations, execute leasing, run analytics, and provide innovative resident, tenant, and investor services.

With a solution and best-of-breed product suite designed for every real estate market including commercial (office, retail, industrial), multifamily, affordable, senior, public and military housing, Voyager helps you meet all your property management and accounting needs using a single database to run your entire business

Responsibility:

As a Sr. Programmer I was responsible for the following:

• Quickly learn existing product extensively.
• Work with BA to understand the business requirement, existing ETL solution and propose solution.
• Create source to target mapping, technical design documents and get client approvals.
• Independently develop database objects, ETL jobs, SQL procedures/scripts.
• Perform unit testing and fix any data or performance issues.
• Frequently modify the solution based on changes in the requirement and ensure data accuracy.
• Create deployment scripts to migrate solution in UAT and PROD environments.
• Interacting with business users for business knowledge, demos and UAT.
• Support the warranty period till completion.

Description:

Citi offer a wide range of services to assist customers in meeting their total needs. Balance Sheet Exception Reporting is an application which is being used by Citi for controlling and monitoring the cash breaks and Trades. Complete business revolves around this application because all activities starting from vendor, to customer happens in it. Major activities are to monitor the cash breaks and the day today transactions of consumer and lot more other activities.

Responsibility:

As a Data Analyst I was responsible for the following:

• Quickly learn the half built system from the old developer along with little documented business process.
• Create ETL Job in Talend for various data loads and extracts from different types of sources like Oracle, Text, CSV flat files, Excel to destinations like Oracle, Text, CSV flat files, Excel. Involved in Talend Data quality assessment and optimizing existing workflows.
• Involved in gathering the requirements with the line of business along with the application manager, technical discussions for analyzing the same, working with various stakeholders for the deployments starting lower environments till production.
• Providing technical support by fixing defects since from the development phase till production.
• Raise JIRA for various business requirements and get on track for the development of same.
• Have been working on several change requests for the modules from development till they are moved to the production environment.
• Involved in Database and ETL code deployment on UAT/PROD using Hermes as an Integrator.
• Involved in feed processing through UNIX using Putty and Tectia for ETL validation.
• Working as team on Production issues and make ensure that the issue is resolved as early as possible.

Cigna (NYSE: CI) is a global health service company dedicated to helping people improve their health, well-being and sense of security. All products and services are provided exclusively through operating subsidiaries of Cigna Corporation, including Connecticut General Life Insurance Company, Cigna Health and Life Insurance Company, Life Insurance Company of North America and Cigna Life Insurance Company of New York. Such products and services include an integrated suite of health services, such as medical, dental, behavioral health, pharmacy and vision care benefits, and other related products including group disability, life, and accident coverage.

Responsibility:

As an ETL Developer I was responsible for the following:

• Analyzing and understanding the requirements and designs given by the client team.
• Build test and deploy database objects, ETL packages, SQL procedures/scripts.
• Read extracted data from raw files, which are present in format such as .txt. Using SSIS packages.
• Automat entire solutions for extraction of data from various servers using SSIS Package and MS SQL Server Agent Services.
• To manage and ensure that the project schedules are adhered to as per the client specifications and deliveries are as per the time and quality standards
• Develop SSIS packages using For Each Loop, Lookup, Derived Columns, Condition Split, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to export data from flat files and SQL Server to data warehouse.
• T-SQL coding and testing: functions, views, triggers, stored procedures etc.
• Been part of project life cycle right from requirements gathering to Go Live.
• Deploying the SSIS Packages from development server to production server.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.