Company Name
Tata Consultancy Services(GE Capital) @
Education:
Bachelor of Engineering @
Rajiv Gandhi Prodyogiki Vishwavidyalaya
About:
● 8 years of experience in business intelligence & data warehouse in capacity as data architect, business analyst, project leader and ETL & database developer
● Expertise in OLTP & OLAP systems, data marts, ODS, enterprise DWH, relational and dimensional modeling
● Hands on experience in big data tools & technologies like Hadoop, HDFS, MapReduce, Pig, Hive,
● 8 years of experience in business intelligence & data warehouse in capacity as data architect, business analyst, project leader and ETL & database developer
● Expertise in OLTP & OLAP systems, data marts, ODS, enterprise DWH, relational and dimensional modeling
● Hands on experience in big data tools & technologies like Hadoop, HDFS, MapReduce, Pig, Hive, MongoDB, Cassandra and Python
● Strong analytical & problem solving ability, excellent communication skills, ability to lead and an attitude to learn new technologies
Specialties: End to End execution of BI Projects, Data Warehousing, ETL Developer, Data Architect
Assistant Consultant @ Enterprise Data Architect
● Architected a compliance and regulatory project by understanding data in the source systems and devised a solution to cater to FDIC compliance requirements. Managed and mentored a team of 12 members
● Designed and implemented a touchless application for extracting originations and opportunities data from OLTP based Siebel CRM and merging into enterprise data warehouse(3NF) for deal flow analysis purpose. Wrote QVD’s to support multiple Qlikview dashboards based on this application
● Increased data availability by converting time consuming, manual ad-hoc data load processes to automated one by creating data upload interface. This helped reduce production support effort by 30% From October 2013 to September 2014 (1 year) IT Analyst @ ETL Project Lead
● Developed and designed a solution for calculating calibrated GE capital ratings based on various AAA rating given for a party to check health of associative party. Built Access Layers (ERISK, IRIS) for risk reporting
● Enhanced and supported application for sending handful of parties for mastering to third party system(UCM) and replicate master and child customer relationship back to EDW warehouse
● Developed an auditing application to perform data audits, capture and warn generation of data load for AAA consistency application, which helped support team to find issues in timely fashion From October 2010 to September 2013 (3 years) United StatesAssistant System Engineer @ Developer & Module Lead GE Capital (TCS), Mumbai, India Jan07–Feb10
● Conceptualized and implemented a solution (similar to a 20% project) for immediate risk data upload which brought down the report availability from 8 hours to 30 min. Later front end based application was built to facilitate aggregate submission catering to the whole enterprise
● Developed and tuned SQL queries/Informatica mappings to extract, transform and load the data from various sources like Teradata, Oracle and flat files into EDW data warehouse
● Automated monthly load in Teradata by creating scripts, reducing manual efforts by 90% and cycle run time by 70%. Wrote audit application to check data for referential integrity and do sanity checks From September 2006 to September 2011 (5 years 1 month) Mumbai Area, India
Database and Data Analytics @ UCSC Silicon Valley Extension From 2015 to 2015 Bachelor of Engineering, Computer Science @ Rajiv Gandhi Prodyogiki Vishwavidyalaya From 2002 to 2006 Rekha Tapdiya is skilled in: Informatica, Data Warehousing, Requirements Analysis, Oracle, SQL, Unix Shell Scripting, PL/SQL, Business Intelligence, ETL, Unix, Teradata, Business Objects, DB2, Design Patterns, SDLC
Looking for a different
Rekha Tapdiya?
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension