Pradeep Dayala
Phone: +1-614-***-****
Email: adhzev@r.postjobfree.com
Summary
12+ Years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
Worked extensively in data extract, transformation, loading, integration in support of enterprise data infrastructures – data warehouse using Informatica 10.2.0, Python ETL Tool, Actimize AIS/RCM on UNIX, major domains include Anti Money Laundering (AML), Employee Trade Surveillance (Compliance).
Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2, Teradata.
Proficient in analyzing and translating business requirements to technical requirements and architecture.
Proficiency in data ETL workflows with programming/scripting languages such as Python Analyzed and processed complex data sets using advanced querying, visualization and analytics tools.
Executed software projects for Banking/Finance, Telecom Billing and Insurance domain.
Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2,Teradata, SQL Server Databases.
Skill Set
ETL Tool : Informatica 10.2.0, 9.x, Python, Actimize AIS/RCM
Functional Modules : Finance, Banking AML/Compliance, Insurance, Telecom Data Warehousing
RDBMS : Oracle, Teradata, Netezza, SQL Server.
Languages : Oracle SQL/PL SQL, Python, UNIX Shell Scripting.
BI Tools : Tableau,.
O/S : UNIX, Windows.
Job Schedulers : Control-M, Autosys, CronTab.
Version Control : SVN Version Control, BitBucket, GitHub, Artifactory, JIRA.
Other tools : Python, Hadoop, Hive, Impala. Spark, AIS 4.1.2, RCM 5.8.
Professional Experience
Current Project: DBFeeds Transaction Monitoring–Anti Money Laundering (AML)/ Employee Trade Surveillance (Compliance)
Client: Deutsche Bank, New York
Duration: June 2015 – till date
Role: Solution Architect / ETL Consultant
Environment : Informatica 10.2,Python, Spark, Hadoop, Hive, Impala, Tableau, NICE Actimize AIS 4.1.2, RCM 5.8, Oracle 11g, UNIX, Control-M, uDeploy, JIRA, JAMA, Artifactory, GitHub, HP QC
Responsibilities:
Creation of custom ETL Informatica 10.2 Process for data load and model data filtering/Alert generation.
Developed ETL programs using Informatica to implement the business requirements.
Job scheduling using Control-M for running the ETL & AIS processes.
Custom coding for NICE Actimize AIS/RCM(Risk Case Manager), Investigation and Case Management
Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
Scenario customization and maintenance of watch list.
Pre and post session assignment variables were used to pass the variable values from one session to other.
Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
Implementation of slowly changing dimensions ( SCD Type 2 ) for Reference data maintained.
Handle adhoc request for Production data analysis using SQL/PL-SQL
Review existing Code and help team with Performance tuning for ETL Jobs.
Support Business users BI report regeneration.
Help data scientists and business analysts optimize productionized Hive SQL queries.
Design and Develop framework for converting existing Informatica PowerCenter mappings/workflow to PySpark(Python and Spark) Jobs.
Project: Citi Bank - Genesis
Duration: Jan 2014 – June 2015
Employer: IBM India PVT LTD
Role: ETL Analyst
Environment: Informatica 9.6 /Ab-Intio, UNIX, Teradata, Netezza
Citi Bank’s Genesis project is an Enterprise data warehouse combining financial balances with contract, position and balances data for corporate financial, risk, global compliance and regulatory reporting.
Project: ICDW Wave 4
Duration: - Aug 2012 – Dec 2014
Role: Sr ETL Developer
Employer: IBM India PVT LTD
Environment: Informatica 9.1 (ETL Tool), UNIX, Teradata v14, DB2, Control-M
JPMC-Wave 4: JPMC has decided to go for IBM Banking Framework model, in this process of migration. It has been assigned to us to implement the Business Banking and Mortgage Banking Data in the IBM BDW frameworks. We need to migrate or load the data of different SORs into Staging, Integration and Semantic layers respectively.
Project: Atlas Markel EDW
Role: Sr ETL Developer
Employer: IBM India PVT LTD
Duration: June 2011 – July 2012
Environment: Informatica 9.1, UNIX, SQL Server 2008, HP Quality Center.
IBM has worked with Markel to use IIW (IBM Insurance Warehouse) for developing a release-based approach to the development of a consolidated data store (CDS) and an actuarial data mart (ADM) to support Reserving and IBNR, and application integration to support month end financial close.
Project: EDW (Enterprise Data Warehouse)
Role: ETL Developer
Duration Oct 2010 – May 2011
Employer: AMDOCS India PVT LTD
Environment: Informatica 8.6, HP-UX, Oracle 10g
EDW (Enterprise Data warehouse) is called next generation Data Warehouse project is carried out for BELL (Canada), Bell is one of the leading Telecommunication and wireless Service provider in Canadian market Place. This module creates Business Intelligence data using Informatica ETL tool. The information extracted by EDW is used by the client for strategic planning.
Project Credit Risk Management
Role: ETL Developer
Employer: AMDOCS India PVT LTD
Duration: March 2009 – Sep 2010
Environment: Informatica 8.6, HP-UX, Oracle 10g, SQL Server.
Amdocs’ Credit Risk Management is an analytical solution - based on Amdocs Business Insight Generator (BIG) - that is aimed at minimizing delinquency (entering collection) and non-payment risk (and eventually debt write off) caused by customers that do not pay their bills. The results of this system are risk scores and patterns that provide insight on customers’ payment behavior and profiling.
Project: Score Cards
Role: ETL Developer
Employer: AMDOCS India PVT LTD
Duration: July 2008 – Feb 2009
Environment: Informatica 7.1.3, Oracle 10g, SQL Server, UNIX.
The Balanced Scorecard helps companies guide their business by using a set of financial and non-financial measurements such as customer loyalty, quality, and revenue and employee knowledge.
Project: HDFC EDW
Duration: Jan 2008 – June 2008
Role: ETL Developer
Environment: Informatica 9.1 (ETL Tool), HP-Unix, Oracle 10g, Netezza
HDFC EDW project is an enterprise-wide data warehouse development assignment for largest housing loan provider bank in the world - HDFC. Their existing system REVELEUS is running from past 10+ years along with some other code pieces in SAS, batch scripts etc., on Windows. We are working to replace REVELEUS with Informatica 9.1 (PowerCenter and PowerExhange) and Netezza database using IBM's existing BDW (Banking Data warehouse model), which is more like ODS and a DWH fitting exactly into HDFC's EDW requirement.
Project: ATS
Duration: Oct 2006 – Dec 2007,
Role: C/C++ Developer
Employer : ECIL Rapiscan and Softpath systems INC
Air Traffic Control (ATC) is an automated Air Traffic Control system (Flight Data Processing System).
Education:
MCA(Masters in Computers Applications) from Osmania University College of Engineering (campus) – 2006, Hyderabad.
BCA(Bachelors in Computers Applications) from Osmania University – 2003, Hyderabad.
References: Available upon requests