Tech Lead Resume Philadelphia, PA - Hire IT People

SUMMARY

Over 19 years of experience in IT with expertise in Design, Implementation & Maintenance of OLTP & OLAP systems, Data & Technical Architecture, ETL processes, Business Intelligence, Enterprise Application Integration, Database and DWH administration.
Experience on AWS services like DBMS, CloudFormation, EC2, S3, Glacier, Redshift, Auto scaling, RDS, VPC, Route53, CloudWatch, CloudTrail, Config, IAM.
Strong DWH & ETL experience in Informatica Power Center development, design, process and best practices experience as ETL Architect, Lead and Developer.
Expertise in other DWH/BI tools includes Netezza (TwinFin, Striper & Mako), Informatica Power Connect for SAP R/3, InfoSphere Data Stage 7.0, Talend Open Studio 5.2.2, Hyperion Brio, Cognos Impromptu, MS Analysis Services, Business Objects XI, MS Visio 2007 and Erwin 3.5/4.1 and exposure to Hortonworks Hadoop.

TECHNICAL SKILLS

Databases: Netezza (TF-3, TF-6, Striper and Mako), Amazon Redshift, Amazon RDS, Oracle 11g/10g/9i, MS SQL Server 2016/2012/2008 R2, MySQL 4.0/5.0 and Teradata

ETL Tools: Informatica PowerCenter 10.x, 9.x, 8.x, 7.x/6.x/5.x, Power Connect, Power Exchange, InfoSphere Data Stage 7.0, Talend Open Studio.

Reporting Tools: Tableau, Cognos 10.x, QlikView, SQL Server Reporting Services, Pyramid Analytics and Crystal Reports.

Languages: SQL, PL/SQL, Pro *C, UNIX Shell Script, Java, C, HTML, XML, JSP.

Tools: ERwin, Power Designer, ER/Studio, Aqua Studio, SQL Server Data Tools, TOAD, Aginity Workbench, SQL Workbench, Management Studio/Enterprise Manager, DTS, SQL*Loader.

Methodologies: Data Warehouse design, Data Modeling, Logical and Physical Database design

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Tech Lead

Responsibilities:

Managed Chubb’s ATLAS Datawarehouse which is around 150 TB with many key tables over 10 billion records.
Lead for the project moving parts of Loss data from on-premise to the cloud. Cloud architecture was AWS with data lake in S3 and consumption mart in Redshift.
Responsibilities included data analysis, data model for raw and consumption layer in Redshift.
Experience in working with various AWS Services including EC2, VPC, IAM, Data Migration Service, Redshift, Schema Conversion, S3, CloudFront, Glacier, RDS, CloudWatch, CloudFormation, CloudTrail.
Plan, build and configure network infrastructure within VPC with public and private subnets, configure routing tables and internet gateway.
Performance Tuning the long running SQL’s from several hours to under an hour on both Netezza and Redshift.
Define Security Groups depending on access parameters provided.
Create IAM user accounts and role-based policies for access to AWS services.
Use CloudWatch to set alarms, auto-scaling groups, generate notifications, and respond to changes in AWS environments.
General application design, development and administration using Informatica, Netezza, Autosys and Qlikview.
Other Netezza activities include migration, stats update and reclaiming the space, backup and restoring databases.
Tech Lead for migration of Netezza servers from TF6 to Mako
Extensive Performance tuning to optimize the Informatica mapping, SQL Overrides, session, source and target performance by eliminating bottlenecks.
Exposure to Hortonworks Hadoop with pilot projects (POC) importing/exporting data using Sqoop, Hive, MapReduce and Pig.

Environment: Amazon Redshift, Netezza (TF-3, TF-6, Striper and Mako), Informatica Power Center 9.6, AWS Data Pipeline, S3, Oracle, Unix, Autosys, QlikView, Erwin, Tableau.

Confidential, Jersey City, NJ

Tech Lead/Architect

Responsibilities:

Developing complex mappings, Workflow/worklets, Database Connections
Entered metadata descriptions at both the transformation and port level in complex mappings
Extensive Performance tuning to optimize the mapping, session, source and target performance by eliminating bottlenecks

Environment: Informatica Power Center 8.x, Netezza (TF-6), Oracle, Informatica Power Center 9.x. Autosys, Cognos, Erwin, MS Project, Unix and SharePoint.

Confidential

Lead DWH Consultant

Responsibilities:

Designed the logical and the physical data model for the DataMart.
Capacity planning for the Datawarehouse.
Designed the staging procedure for dumping the full/incremental data into staging db.
Designed and deployed overall ETL strategy including SCD Type 6 logic.
Migrated from Informatica PowerCenter Repository version 6.1 to 8.1.
Implemented appropriate Error handling logic, data load methods and capturing invalid data from the source system for further data cleanup
Developing complex mappings, Workflow/worklets, Database Connections
Entered metadata descriptions at both the transformation and port level in complex mappings
Extensive Performance tuning to optimize the mapping, session, source and target performance by eliminating bottlenecks

Environment: Informatica Power Center 8.6, Netezza (TF-6), MS-SQL Server 2008, Informatica Power Centre 9.x, Control-M, Cognos, Erwin, MS Project, MS Visio, SVN framework.

We provide IT Staff Augmentation Services!

Tech Lead Resume

Philadelphia, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship