Project Manager Data
Resume:
Radha Subramanian
http://www.linkedin.com/profile/edit?trk=hb_tab_pro_top
• Demonstrated increasing responsibility in Data Warehouse design and
implementation, Business Intelligence, Enterprise Data Management and
Systems Integration ETL Architecture, Enterprise and Dimensional modeling.
• Successfully delivered end-to-end projects spanning multiple releases for a
multitude of DW/BI applications across industry verticals with a variety of tools.
• As a DW Tech Lead, responsible for following
o Develop & Review Data model and architecture
o Involve in designing and developing mock user interface
o Make the basic ETL architectural rules and regulations
• Involved in different projects and played different roles such as Delivery lead,
Project lead and Technical Lead. Has managed multiple projects both hands-on
and hands-off. Experienced in leading teams upwards of 9 to 15 team members
across functions and levels of experience and has worked with customer POCs.
• Highly self-motivated with an ability to drive similar behavior from team. Focused
on grooming junior team members and with emphasis on succession planning.
• Strong management abilities while leading technology teams on large projects.
Successful in intense and demanding environments experiencing rapid change
through internal growth, acquisition, and revitalization.
TECHNICAL SKILLS
Informatica 9.5, Castiron 5.6,SAS DI
Data Integration Tool
OBIEE, Micro strategy 9.0
Reporting & Analytics
Tools
Oracle, Teradata
Databases
Erwin
Data Modeling
Office Professional (Word, Visio, Excel, PowerPoint, Access, Outlook)
Productivity Tool
UNIX shell scripting, Teradata SQL, Teradata utilities, PL/SQL,SOQL,APEX, Apex
Other technical
data loader
proficiencies
P R O J E C T D E TA I L S
Infosys Ltd – San Jose, CA [Dec 2012 - Present]
Client: Cisco Systems
Role: I.T. Engineer
Responsibilities:
• Functional and technical expertise in LSS Supply chain management system
(SCM) –Plan and Deliver track.
• Extensive experience in EDW data modeling, preparing for Logical and physical
data modeling sessions, ETL Architecting, Spec writing and developing ETL
mapping.
• Led BI development team with onsite, offshore developers. Responsibilities
include business user engagement to gather requirements, data modeling,
architecture, timelines for tasks, technical solutions for data movement,
development progress monitoring, QA and support transition
• End to End project execution from requirement gathering to delivery of the code
• Onsite Delivery Lead - Managed the requirements analysis, Design, SIT and
Delivery phases. Close interaction with Business Analysts, Business Users and
Client POC’S and IT Project Manager
• Interfaced with business users - to drive requirement gathering and with source
systems - achieve cross platform System Integration.
• Good experience in writing SQL Queries, performance tuning of SQL queries,
creating adhoc reports, on demand SQL data reports, identifying the problem
and troubleshooting. Experience in ability to work across Microsoft and UNIX
platforms.
• As a Technical Project Lead, responsible for delivery ownership involving
o Business Requirement Gathering and Analysis
o Play a progressively larger role in managing delivery of the onsite and off-
shore model projects
o Build System Architecture, high Level and low level design
o Help other members of the business intelligence team and execute work
with reference to ETL
Paypal – San Jose, CA [Jul 2009 –Nov 2012]
Role: Member of Technical Staff
Responsibilities:
• Project executions using Agile Methodology since Jan 2012.
• Proficiency in SFDC Administrative tasks like creating Profiles, Roles, Users, Page
Layouts, Email Services, Approvals, Workflows, Reports, Dashboards, Tasks and
Events
• Extensive experience in analyzing business requirements, entity relationships
and converting to Salesforce custom objects, lookup relationships, junction
objects, master-detail relationships
• Experience in migrating data from legacy systems to Salesforce using Apex
Data Loader.
• Extensive experience in data migration and integration using Data Loader
• Responsible for end to end data migration from Salesforce.com to EDW and
EDW to Salesforce using ETL tools like Informatica/Castiron.
• EDW data modeling, preparing physical data models, ETL Architecting, Spec
writing and developing ETL mapping.
• Led BI development team with onsite, offshore developers. Responsibilities
include business user engagement to gather requirements, data modeling,
architecture, timelines for tasks, technical solutions for data movement,
development progress monitoring, agile processes for application development,
QA and support transition
• Architected and developed data marts (POS - Point of Sale Dashboard, PET -
Product Experience Tracker, C2.0 - PayPal webpage re-design) to capture metrics
about customer adoption of new features, average response time of clicks, API
calls made etc., Leveraged expertise in Teradata Cost Based Optimizer (collect
statistics) and Explain Plan to identify potential bottlenecks with queries
including skewed redistributions, join order and defined indexing strategies
(primary, secondary and aggregate). Recognized for delivery in complex projects
through Excellence awards.
• Physical data modeling deliverables for complex data marts (POS, PET, C2.0)
using Castiron and Informatica (staging, work and target structures)
• Data movement solutions from Flat /CSV/XML files using BTEQ, FastExport,
Multiload, FastLoad utilities, TPT (Teradata Parallel Transporter); Oracle database
using Golden Gate; Informatica push down optimization techniques.
• Best practices on application delivery including development standards, code
reviews, support management, jobs monitoring (debug and resolve failures
through support tickets process), test case (unit, integration, user acceptance)
development and knowledge sharing with offshore team.
• Performance tuning - More than 1 million CPU seconds savings by tuning various
queries related to web logs (Cal and Omniture), 0.6 million CPU seconds/week on
P1 queries (using Join indexes), and overall query performance improvement by
40% in multiple situations.
• Created the data model using for each subject area and accommodate the
model with EDW data model.
• Designed the Informatica mapping guidelines to handle the huge volume of
data. Performance tuning of source query and Informatica mapping.
• Worked with Business Users to analyze the business process and made
necessary changes to schema objects to cater their reporting needs.
• Lead the 15 member team combined onsite and off-shore and aggressively
managed personnel across all departments
Environment:
ETL : Informatica, Castiron
Database : Teradata
Platform : Unix
Data Model : Erwin
Development Methodology : Agile/iterative
Other Technical profeiciencies : Apex data loader, Unix shell
scripting,Apex
CSC Inc, San Jose, CA [Dec 2005 – Jul 2009]
Role: Sr. Software engineer
Responsibilities:
• Onsite consultant for client (Paypal)
• Extracted source data using SQL query to analyzed the different APD products
data based on the requirement and defined the system integration
specifications.
• Prepared the requirement document, mock up reports and test plan for the
functional testing
• Interfaced with business users - to drive requirement gathering and with source
systems - achieve cross platform System Integration.
• Acted as liaison for offshore delivery, responsible for driving resource planning,
work allocation and issue resolution and effort estimation for projects in the
pipeline.
• Reviewed various BRD, SRS and Technical design document.
• Designed and implemented ETL framework to run the SQL program dynamically.
Environment:
ETL : Informatica, Castiron
Database : Unix
Data Model : Erwin
Cisco Systems, San Jose, CA [March 2004 –Dec2005]
Role: Sr. Software engineer
Responsibilities:
• Responsible for technical and system integration support for delivery of multiple
data marts and reports. Monitored various ETL jobs, performed DB operation as
application DBA.
• Performed as Data warehouse and ERP programmer analyst, delivering high
performance technical solutions.
• Gathered end user requirements for ERP customizations, prepared functional
specifications, analyzed logical data models, generated technical design
documents, created physical objects, developed ETL, performed code migration,
test plans and job scheduling activities.
• Oracle ERP (11i) implementation customizations to support Quote to Cash
functionalities such as customer data and order imports, customer validation
(scrubbing using 3rd party software)
• Led onsite project implementation team of 5.
• Delivery of data mart to support web log information analysis from Clickstream
including data movement using Informatica transformations (router, joiner,
sequence generator, expression, lookups), maplets/mappings/workflows,
analytical reporting using OBIEE, testing with Test Director, code migration with
Kintana and performance optimizations using Tkprof and Explain Plan.
• Implemented Star schema design to support the aggregated call center data and
build the cube for analysis.
• Design and implemented survey scoring model data mart and integrated with
call center data.
• Drove system performance turning, effort estimation for future initiatives.
Standardized production support processes to streamline maintenance activity.
• Implemented multiple releases in quick succession; addressed existing
performance issues.
Environment:
ETL : Informatica 8.1
Database : Oracle, PL/SQL
Reporting Tool : OBIEE
Development Methodology : SDLC
Dark well Microsystems, Chennai, India [Jan 1998– Jun 2003]
Role: Software Engineer
Responsibilities:
• Worked for clients including Spel, Micropack
• Provided consulting services on Oracle ERP and data mart implementations.
Responsible for end to end coordination and interaction with business users to
implement customizations
• Work activities included writing technical documents and test plans, designing
and developing custom objects, testing and supporting.
• Performed Oracle ERP customizations using Stored Procedures, Oracle Forms and
Oracle Reports
• Delivered Status reports to steering committee
• Developed and implemented projects using Informatica and Oracle
Contact this candidate