EDW Migration, Development Lead Resume

SUMMARY

Seasoned and accomplished hands - on Lead Data Architect with extensive experience overseeing data architecture, ETL architecture, databases, database design, performance tuning, capacity management and reporting for various financial services organizations.
Strong experience in building, managing and working with global teams. In-depth understanding of enterprise-wide shared services offering.
Good understanding of managed services, meta data management, data masking, data warehousing, data federation, big data and AWS cloud technologies.

TECHNICAL SKILLS

Informatica PowerCenter/PowerExchange for Hive/HDFS/MQ/JMS/Web Services/DB2 CDC Pentaho; Informatica Big Data Management (BDM), Informatica Cloud (familiar)
Informatica Data Services (familiar); Informatica Metadata Manager; Cloudera Hadoop Distribution, Hive, Impala; HDFS, Oracle, SQL, PL/SQL; Cassandra
Vertica; Redshift; Snowflake (familiar); Python, PySpark; UNIX; Shell Scripting; MetaMatrix; AWS technologies including S3, EC2, VPC, SQS, Kinesis
Redshift; REST and Micro Services (familiar); Autosys/Control-M/ESP; JIRA, Confluence, MS Office.

PROFESSIONAL EXPERIENCE

Confidential

EDW Migration, Development Lead

Responsibilities:

Responsible for leading 6 offshore developers work and deliver the end product on the new platform
Resolved some of the performance issues caused due to change in data structures between Netezza and Sailfish
Made a case and presented to the client to move their Informatica platform to shared platform to reduce licensing costs

Confidential

SEC Modernization, Lead Data Architect

Responsibilities:

Managed technical team of 5 developers, produced the data architecture including selecting the right technologies viz., Vertica/Oracle DBs, Informatica/Pentaho, Linux.
Resolved critical performance issues on the 7 node Vertica Shared services and provided scalable solution.
Ensured collaboration among Operations, BAs and Technology teams to keep the project on track.
Proactively devised reconciliation process between various data touch points and corrected them ahead in time.
Implemented Agile processes and provided execute score cards on KPIs.
Mentored the development team through technical guidance.

Confidential, New York, NY

Team Lead/Data Integration Architect

Responsibilities:

Oversaw stability, performance and scalability of the Enterprise Informatica v861 shared farm.
Served as a single point of contact to 400+ firmwide developers for all their data integration issues.
Developed plan to migrate from Linux Suse 10 to RHEL 5.8 and upgraded to v951.
Proposed and implemented multiple capacity management solutions for various teams across organization.
Conducted trainings to the user-base on JMS/MQ real-time messaging, web services, deployments etc.
Proposed tens of Informatica product improvements in product design, features and reported tens of bugs in the product and got them fixed
Owned MetaMatrix shared/dedicated platforms.