Candidates About

Priya Kidambi

Professional summary

·         8+ years of IT experience involving data analysis, data governance and modeling, ETL and reporting for large scale Enterprise Data Warehousing.

·         Experienced in data warehousing in wealth and asset management, Banking, Insurance and healthcare domains.

·         Extensively worked on data consumption layer- Finance, Wealth, Risk & Compliance, Audit etc.

·         Worked on Banking Source Systems like DPS,LNS,ARX,RAS,NFS,NIS and Money movement types-Cash,check,cashier checks,ATM,FX at Teller etc.

·         Design queries in Cloudera Hadoop Impala and create Hive tables and views for reporting.

·         Experienced in driving presentations to executives on data semantics, corporate glossary establishment.

·         Experienced in enhancing both OLTP (relational) and OLAP (dimensional) data models (ER and dimensional) for database platforms such as Oracle, Teradata, SQL Server, and DB2 using Inmon and Kimball methodologies.

·         Exposure to NoSQL & Big Data Technologies such Hadoop stack - HDFS, Pig, Hive, Mongo dB, HBASE.

·         Experienced in developing Information Governance Catalogue (IGC), creating business terms, defining data domains, categories and hierarchies, data quality dimensions, Information Governance rules and policies.

Skillset

Work History

Data Governance Analyst/Tech lead                                                                          March 2017- Present

The Northern Trust Company,Chicago IL

Project summary: Involved in source system and data security evaluation for AML and Risk compliance standpoints. Developed business process models documented business rules, metadata etc. for all the internal and external data sources coming into Hadoop Data Lake, Data warehouse and AML reporting layer. Driven the solution to make sources compliant by addressing identified gaps in data and process flows. Attempted resolving data inconsistencies and gaps among several data platforms through data remediation.

·         Conducted source system discovery sessions with data stewards, data owners, business owners, data custodians and appropriate stakeholders to delineate business processes and functional relationships among corresponding data entities and attributes.

·         Designed and implemented workflow for data catalog to identify critical data elements and relevant metadata in collaboration with business partners, data governance stakeholders.

·         Created and maintained data inventory, business glossary, business rules, process registry, data flow diagrams (lineage) and associated documentation requirements.

·         Utilize data wrangling, data matching and ETL techniques to explore variety of data sources, gain data expertise and create datasets to support advanced modeling and Business Intelligence reports.

·         Analyzed and evaluated data / information gathered from multiple sources and reconcile / address conflicts or business issues.

·         Discovered process gaps leading to potentially fraudulent transaction patterns across systems in collaboration with AML global compliance teams and Risk management teams.

·         Extensively researched internal and external sources to assist with creation of new data policies and standards, corporate data glossary and dictionaries.

·         Involved in designing ETL flows for data comparison among source system, MDM (Master data management), Enterprise data platform, and Reference Data Store, Data Lake and AML engine.

·         Orchestrated a team of 7 to conduct initial data acquisition, business rule based profiling and data loads, data comparisons for further analysis.

·         Identified touch points in process flows for data encryption till data lands in the data lake.

·         Designed and enhanced periodic reports demonstrating program activities.

·         Made recommendations for measuring and to improve efficiency of data governance, operational control processes, and compliance activities.

·         Assisted in data cleanup and remediation projects.

Environment: Hadoop stack - Impala, Hue, Hive, IBM Info Analyzer (business rules and profiling), IBM Information Governance Catalog, IBM DataStage (ETL), IBM Info sphere (MDM), IBM DB2, and Oracle.

Data Analyst/Data Modeler                                                                              Sep 2016 - March 2017

Kaiser Permanente, San Francisco Bay Area

Project summary: Assessed gaps in asset inventory counts and identified metadata useful in accurate tracking and reporting of corporate assets. Performed and physicalized data model changes, while assisting in other data modeling duties.

·         Conducted data discovery sessions with SMEs to identify data and/or metadata of business value to be captured and reported.

·         Worked closely with the data architects to determine modeling efforts.

·         Enhanced conceptual data models, logical data models and physical data models using CA Erwin for the Asset Management subject area.

·         Reviewed data model changes with the project team to ensure requirements are met.

·         Involved in syncing operational database changes across data warehouse and data marts.

·         Collaborate with the data architects for data model management and version control.

·         Improved reporting performance using database objects such as sequences, indexes on new data elements to improve reporting performance.

·         Involved in ETL mapping and data lineage development efforts.

·         Involved in reviewing standards and best practices around data modeling efforts and metadata publishing and management.

·         Collaborated with the BI teams to enhance reporting data structures.

Environment: Oracle 11g/ 10g, Teradata, CA Erwin r9.6,Altreyx, Informatica Developer 9.5.1, MS office, Visio, MS Access, Business objects, Enterprise Metadata repository, Splunk.

Data Analyst                                                                                                      Feb 2016 - Aug 2016

HSBC, New York

·         Documented data requirements, process flows and data lineage etc.

·         Assisted in ETL mapping and data lineage development in collaboration with ETL developers.

·         Worked with Data Governance, Data Quality and Master Data Management teams to understand the established standards, build metadata.

·         Acquired attribute level metadata and data dictionary from SMEs and coordinated with Data Governance team to develop and enhance business glossary.

·         Incorporated data cleanup measures as part of discovered production data defect fixes.

·         Partnered with ETL teams and SMEs to streamline source system data flows into BI layers.

·         Performed High Level and detailed data profiling on various metadata and Null value profiling to discover data anomalies and assess data quality on dimensions such as consistency, accuracy, completeness etc.

Environment: Oracle 11g/ 10g, DB2, CA Erwin r9.6, Informatica Developer 8.1.1, MS office, Visio, HP Asset Manager.

Data Analyst/Modeler                                                                                        Jan 2015 - Dec 2015

Progressive Insurance, Cleveland OH -

·         Gathered requirements and interacted with Subject Matter Experts to identify and understand legacy system data and document modeling gaps between current and future state of BI data.

·         Participated in system analysis and use case modeling to identify business processes that needed modeling support.

·         Designed logical and physical models for projects involving Auto and Property Policies.

·         Designed new dimensional models and modified existing dimensional models for advanced analytics, integrating new operational systems and reporting.

·         Collaborated with DBAs to identify and document data modeling constraints for different databases as part of modeling standard revision.

·         Conducted walkthroughs of operational data models, data flows into downstream systems and data mapping with business users to discover data attribution that was of BI value.

·         Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents, to conform attributes across the warehouse.

·         Modeled snapshot and aggregate facts for periodic reporting and trending analysis.

Environment: Oracle 11g/ 10g, DB2, Embarcadero ER Studio, Informatica Developer 8.1.1, MS office, Excel, Visio, Access, Enterprise Metadata repository.

Feb 2009 - Jul 2014

General Electric/TCS, Bangalore –Jr. Data Modeler/BI developer

Jr. Data Modeler (Jun 2011 - Jul 2014)

·         Reverse engineered existing data sources to generate data models for source system analysis.

·         Created subject specific conceptual models based on logical models and assisted in model walkthroughs.

·         Synchronized data models with metadata from database, accounting for constraints, sample values etc.

·         Created and involved in validating logical model based on new business requirements and business rules.

·         Mapped the source data to re-engineered physical data model using mapping documents.

·         Collaborated with data architects to develop ETL mapping specs and transformation logic for loading data marts and report building.

·         Created DDL scripts using Forward Engineering in CA Erwin and assisted in database implementation.

·         Coordinated with DBAs for SQL query tuning and optimization for faster data retrieval into reports.

BI Developer (Feb 2009- May 2011)

·         Single-handedly developed data migration methodology from legacy data management system to Agile PLM system.

·         Involved in complete SQL Server Integration Services (SSIS) life cycle in building and deploying packages in Development and Production environments to import and export data from MS Excel, SQL Server and flat files.

·         Involved in daily batch loads (full & incremental) into Staging and ODS areas, troubleshooting issues and event and error handling using (SSIS).

·         Configured data loads into slowly changing dimensions using Slowly Changing Dimension wizard in SSIS.

·         Used various transformations in SSIS Data Flow, Control Flow using for loop Containers and Fuzzy Lookups etc.

·         Developed complex reports such as Parameterized reports, ad-hoc reports, Drill Down, Drill through, reports in SSRS.

Environment: Oracle 11g/ 10g, DB2, SQL Server 2008, CA Erwin r7.0, Informatica Developer 8.1.1, MS office, Excel, Visio, Access, SSIS, SSRS, IBM DataStage.

Education

University of Illinois, IL - Masters in Management Information Systems (2015)

SPM University, India    - Master of Computer Applications (2009)

Recognitions

·         Six Sigma Green Belt Certified Professional-2013

·         Sun Certified Java Programmer- 2009

·         Employee of the Month - thrice in TCS

·         Received client appreciation for the best performance at Northern Trust for discovering functional bug that caused data mismatch, prevented AML from monitoring potentially fraudulent transactions.