AMITHA RUDRA

Email: adbjmp@r.postjobfree.com

Contact #: 719-***-****

Immigration Status: U.S Citizen – Eligible for Security Clearance.

Onsite: Delaware, Maryland, Pennsylvania

Remote: Open

No Third Parties.

Professional Summary:

IT Professional with 9+ years’ experience in analysis, design, solution development, maintenance, implementation, testing and delivery of various applications in Data Warehousing and reporting in Finance and Manufacturing sectors. Consistently meet or exceed goals and objectives by striving to improve processes and procedures following Waterfall and Agile Scrum best practices. ETL developer specializes in utilizing IBM DataStage, Oracle PL/SQL and Unix Scripting to design, build and maintain MDM, Data Warehouses, Data Marts, File Feeds. Possess the ability to analyze and understand complicated sets of data, with the ability to present results in either a technical or nontechnical fashion as needed. Knowledge on Power BI to build reports and Dashboards from Oracle DB, SQL Server DB, MS Excel and AWS S3 Flat files. Exposure to Snowflake cloud Data warehouse, Redshift, Amazon S3, Hadoop Ecosystem HDFS, MapReduce, HBase, Hive. Good Team Player and Possess good communication and inter-personal skills, able to adapt quickly to new applications and languages.

Education:

BS, Mechanical Engineering from CBIT, INDIA

Certification:

Oracle PL/SQL Developer Certified Associate.

Technical Skills:

ETL Tools: IBM Information Server 9.1/8.1 (DataStage 9.1/8.1), Ascential DataStage 7.5.1/7.1, Oracle Warehouse Builder 10g R2 (OWB)

Modeling Tools: Erwin.

Languages: SQL, PL/SQL, Shell scripting and Java Basics.

BI: Power BI

Operating Systems: Sun Solaris, IBM AIX, Windows NT/2000/XP, Linux.

Scheduling tools: Control-M

Version Control tools: Wincvs.

Database Tools: TOAD, Quest SQL Navigator, PL/SQL Developer, DB Visualizer, SQL Workbench.

Applications: Visual Studio, MS Office.

Data Platforms: Oracle 11g/10g/9i/8i, SQL Server 2014/2016, AWS Redshift and Snowflake.

Others: MS Office Applications, MS Visio, CA Unicenter, Mercury Quality Center, Rally, AWS S3

Knowledge of Hadoop Ecosystem

Professional Expérience:

Client: Barclays, DE

Jul’13 – Jan’19

Project: CCAR

Role: Sr Application Developer (ETL).

Involved in data gathering exercise across multiple functions of the Bank and built the ETL processes to gather data from multiple database/warehouse systems and published into DataMart in an organized and uniform format for querying data across the entire business to support Comprehensive Capital Analysis and Review by Business and auditors.

Created IBM DataStage jobs and Oracle PL/SQL packages to load DataMart to provide insights into the business.

Generated documentation, such as data mapping and data dictionary.

Utilized Shell Scripting for better file handling, validation and notification.

Mentored junior developers in development and implementation of ETL processes and its best practices.

Managed the partnership with cross functional teams around data modeling, data mappings, data validation. Provide continuous enhancement and review of MDM matching rules, data quality and validation processes to support Finance critical KPI’s.

Develop, optimize and support DataStage MDM ETL processes for data extraction, transformations and loading of data.

Define, configure and optimize various MDM processes including landing, staging, base objects, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages using Oracle PL/SQL and DataStage.

Modeled and Created Tables with Sort and Distribution keys in AWS redshift.

Developed ETL interfaces to read and write data from or to AWS S3 and AWS Redshift database.

Monitored Redshift queries performance in AWS console.

Project: Octon

Role: Application Developer (ETL).

Key member of Project Octon and Involved in requirements gathering, Design and building a repository out of ASP and Pricing DataMart to support building reports for Barclays UK in a timely fashion.

Lead story writing sessions with an aim of decomposing the scope into epics, user stories and acceptance criteria with product owners, which further helped the scrum team to groom, plan and deliver stories.

Developed business (BFD) and technical process (TFD) flows using MS Visio.

Used Rally for Features and User story management.

Modeled and Created Tables.

Created IBM DataStage jobs and Oracle PL/SQL packages to load data into Octon tables.

Scheduled jobs taking dependency flow into consideration.

Analyze and Utilize data from external and internal systems/applications to properly class MDM data components (Customer, Account level).

Project: ReEval and PAR BI

Role: Application Developer (ETL).

Built multiple ETL processes to support the regulatory project to review the customer pricing every six months for delinquent accounts or penalized accounts and adjust the pricing based on the market rate at a point in time on customer accounts and build the data repository to support BI and enable visualization so that Business can review and audit.

Analyzed the data for TBAL bucket level pricing and DG mapping.

Extensively involved in data profiling and identified the Facts and Dimensions to fulfill reporting requirements needs for Marketing, Customer Delivery and Legal team and build the DataMart which helped to review the health of ReEval and Fulfillment process.

Used Oracle PL/SQL, Unix Scripting to build the ETL process for DG mapping and standard batch process for application of price changes in TSYS.

Built the reconciliation process at TBAL level for Price changes.

Extensively tested the process as its highly impactful and sensitive to customers as its related to price changes.

Project: Pricing Datamart

Role: Application Developer (ETL).

Played a key role in implementing Pricing DataMart project for Finance Business to support Comprehensive and robust reporting at account level and term balance bucket level pricing.

Involved in project level requirements gathering sessions with Business users and worked with BA to understand business requirements and translated them into technical specifications.

Worked on Design Documents with technical specifications, SIT plan and run books in support of application builds.

Developed Multiple ETL processes to gather the data, apply business logic and publish the data into Oracle database tables.

Developed Multiple shell scripts to trigger the ETL process, send out job status notifications.

Worked with Scheduling team to schedule the jobs in Control M scheduler.

Client: Barclays, DE

Jan’11 – Jul’12

Project : Partner Compensation

Role: Application Developer (ETL).

Supported finance applications Account Segment and Profitability (ASP) and Partner Compensation. ASP is the primary source of data for financial analytics across the Barclays Bank which provides business standard definitions and calculations of financial metrics and accurate, clear, and granular view of account level and partner level profitability. Lead story writing sessions with an aim of decomposing the scope into epics, user stories and acceptance criteria with product owners, which further helped the scrum team to groom, plan and deliver stories.

Developed business and technical process flows using MS Visio.

Used Rally for Features and User story management.

Used SQL Loader and UNIX shell scripting to load flat files into oracle database tables

Project PODS Framework

Role: Application Developer (ETL).

Part of the core Dev in Partnership team and played an integral part of building the common frameworks to support any partner file feeds. The frameworks are built to primary reduce the level of development effort for file feeds to partners and speed up the project delivery to partners.

Project : Partner File Feeds

Role: Application Developer (ETL).

Supported Partnership team in sending out the Enrollment, Awards and Rewards file feeds to partners. Used IBM DataStage to develop ETL process to extract the partner related data from Oracle database tables, applied business transformation and write the files into an outgoing folder on Unix server from where the files are pushed to partners using SFTP.

Client: Department of Labor, DC

Apr' 10 – Aug' 10

Role: Data warehouse Developer.

Built a small DataMart for TAA program. The TAA program at DOL helps workers who have lost their jobs as a result of foreign trade. The TAA program offers a variety of benefits and services to eligible workers, including job training, income support, job search and relocation allowances, a tax credit to help pay the costs of health insurance, and a wage supplement to certain reemployed trade-affected workers 50 years of age and older.

Client: Micron Technology, ID

Nov' 08 – Feb' 10

Role: ETL Developer.

The project at Micron mainly involved in building a SSDW (Sales and Supply Data Warehouse) and BI.Micron uses reports from these warehouses to handle sales and supply across all its locations.

Imported data from Oracle, SQL Server, Excel to Power BI using Direct and Import mode to generate reports.

Built ETL process using SSIS.

Generated computed tables in Power BI by using Dax.

Published Power BI Reports, Scheduled refresh and Made Power BI Dashboards available through Web UI

Contact this candidate