Lopamudra Jena

ETL Teradata Senior Developer

Fremont, CA 94538

ac3nys@r.postjobfree.com

408-***-****

• 8 years of exciting and challenging experience in IT industry, techno functional leadership the Data Warehousing involving Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation (SDLC).

• Hands on experience in Informatica Power Center, Teradata RDBMS using Fast Load, MLOAD, TPT, Fast Export, Teradata SQL Assistant and BTEQ experience.

• Hands on experience in requirement gathering, functional specification preparation, analysis, application design, testing, implementation and maintenance.

• SQL and Teradata experience includes data modeling, stored procedures, functions, indexes, SQL Loader, exception handling and performance tuning.

• Direct interaction with Business, often at the highest level, to understand the reporting needs and challenges to work on creating techno-functional solution.

• Experience in building data models, UDM, MDM screens and Business Objects dashboards and other reporting tool to provide data insights to business users.

• Extensively proficiency on data analysis, report analysis and troubleshooting in multiple projects.

• Knowledge of ETL Tools like storm and Informatica(power center designer) for extraction of data from different source system Oracle,SAP,BW,PD2,PMW2,Merlin to EDW.

• Proficiency in preparing unit test cases, unit testing, system integration testing and support to business acceptance testing

• Working know how of processing of large sets of OLAP structured, semi-structured and unstructured data and supporting systems application architecture.

• Understanding of business rules and collaborating with stakeholders to perform source-to-target data mapping.

• Extensive knowledge of industry best practices for software development and documentation and quality assurance.

• Expertise in data research/analysis with a focus on data quality and consistency.

• Adaptability to new tools like Teradata decision expert(TDE) and OBIEE Authorized to work in the US for any employer

Work Experience

Senior ETL Developer with PG&E

Cognizant Technology Solutions - San Ramon, CA

July 2017 to Present

• Interacts with business users and client to understand the requirements to fill the gap between technical and business teams.

• Preparing the technical mapping sheet, functional spec, gap analysis, design document, data modeling sheet, test cases document for streamlining the existing process of deliverable.

• Cross coordination with CDW team/CCNB to understand requirement.

• Working on an interesting Teradata concept temporal which gives the capability to convert all the targeted tables to SCD2 with minimal ETL changes.

• Working with downstream team (EI) to write the Teradata API queries using temporal functionality.

• There were many challenges and limitation in converting Teradata target table to temporal and loading through Informatica. I worked on those challenges and converted the ETL mappings as necessary to have zero defect UAT.

• Learned the energy and utility domain in no time and acknowledged by clients in a small span of time. Senior ETL Developer with Cummins

Cognizant Technology Solutions - Columbus, IN

August 2016 to June 2017

• Interacts with business users and client to understand the requirements to fill the gap between technical and business teams.

• Preparing the technical mapping sheet, functional spec, gap analysis, test cases document for streamlining the existing process of deliverable.

• Cross coordination with ERP Oracle team to understand requirement and sync up with Noetix reports.

• Follow up with oracle BOLT and CORE teams(source) to understand the complex logic and check the feasibility of solution to be implemented in ETL( Cummins warehouse)

• Prototype report preparation and fill in the accurate expected data (close to 80%) to ensure we are achieving the functional requirements proposed by business.

• Quickly adapted the finance account payable (AP) module of Cummins,grain and complexity of data based on which AP reports are built

• Learned new tool Teradata Decision Expert (TDE) and started development in 15 days.

• Tuning the query to have improved performance for OBIII queries and testing the OBIII report across Noetix report

• Developed Payment Inquiry module and invoices on hold module.

• Implementation of reports in production and follow Cummins process of cut-over, sanity testing, fixing the post- production issue.

• Daily activity to find the Root Cause Analysis for Logical Integrity Validation (LIV) between Oracle and Cummins warehouse for PO, INVOICE, RECEIPT, SHIPMENT, ERROR tables(both for AP and AR modules)

• Working with team of 9 people from offshore on various modules along with my own development work.

• Started learning spark and python.

• Involved in internal organization activity

ETL Lead Developer with Apple

Infosys Limited - Sunnyvale, CA

January 2015 to August 2016

• Interacted with business users and client to understand the requirements to fill the gap between technical and business teams.

• Created standard reports, dashboards and other components by analyzing the data in the data warehouse by leveraging the Business Intelligence tools.

• Introduced the UDM screen for financial operation expense cost center attribute which helped users to upload the attributes of cost center using online screen instead of manual process through APS support which in return reduced the

APS manual intervention completely.

• Coordinated tasks with cross-functional teams and performed project estimation, project roadmap and risk analysis for the delivery of projects.

• Documented the user manual and system architecture diagram for the applications, which minimized the customer’s IT, dependency by 30%.

• Optimized the INFA process by converting them into more advanced process STORM that would fasten the processing of data from IOP system (Non EDW) to EDW resulting SLA improvement by 25%.

• Implemented business requirements using ETL tools like INFA, Storm, and Teradata and provided data to downstream team adhering to the SLA and D2P process.

• Fine tuned the Teradata queries and automated the process to achieve the SLA between all the systems within 30 minutes.

• Automated the validation script to test the data between core and semantic layer, resulting in a 50% increase in support efficiency. Designed the use case diagram for this new process and trained the team.

• Migrated the data using NPARC from one data center to another data center resulting in greater use of this tool and a significant increase in user base from 5,000 to 30,000 in the next year.

• Presented comparative studies between Business Object and Essbase reporting tools for our application to Apple business to ensure the best practices were implemented in our project.

• Evaluated the end-to-end data processing of STF Forecast system to improve the SLA by 45 minutes by changing EAI polling logic, making trigger based EDW job and changing the TD procedure, which optimized multiple downstream applications.

• Analyzed and solved P1 tickets and closed them within SLA during primary support. Technology Analyst with Apple

Infosys Limited - Bangalore, Karnataka

November 2009 to December 2014

• Understood the complete flow of Master Data Management system to customize the HMS hierarchy to traverse the custom groups to their lowest level, which can be reportable across all kind of transaction data in GRID Sell Thru and BBB reporting.

• Led the team for backend and UI related tasks.

• Designed and developed dashboards in BOBJ Reporting Tool.

• Strategized the enhancement and performance tuning of the code as per the business requirement.

• Strategized periodic evaluation of KPI using Quarterly Business Review (QBR) reports and helped improve the turnaround time of the team from 3 to 2 days.

• Customized interactive BI dashboard using Excel VBA to easily visualize complex data, thereby improving incident management system software.

• Often appreciated for creating project reports/documents by onsite and client manager. Education

Bachelor's in Engineering

Biju Pattnaik University Of Technology

2005 to 2009

Skills

Data Analysis (4 years), Business Analysis (3 years), ETL Developer (7 years), Teradata (8 years) Links

https://www.linkedin.com/in/lopa072

Certifications/Licenses

Teradata Basics v12

Additional Information

Technical Skills:

• Programming and Scripting Languages: SQL, Java, JavaScript, Shell Script, Unix, Linux

• Databases: Teradata 14/15, PL/SQL, Oracle,Teradata Decision Expert

• Domain: Business Intelligence (GBI Finance), Marketing

• Config Management: SVN, Gitlab, IBM Clear Case

• Reporting & Analytics tools: Autosys, Excel, SQL Workbench, SQL Loader, Business Object, Oracle SQL Developer, Toad

Contact this candidate