Architect/Team Lead Resume

SUMMARY

Seeking a position which fully utilizes my technical and functional skills and provides me the opportunities to explore and handle new challenges that offers security and professional growth while being resourceful, innovative and flexible.
Having 11.5+ years of total IT experience in the Development and designing of Data warehousing and Business Intelligence solutions for Utility, Telecom domain and finance domain.
Experience in designing high performance scalable Data model & Data lake in Data Warehouse environment.
Expertise in Data Ingestion pipelines using Python, various ETL Tools and Snowflake.
Intelligently design data models for optimal storage and retrieval
Design Data Analytics and Data Quality dashboards in visualization tool.
Expertise in using Informatica tool as middleware application by calling multiple web services from Infromatica workflow and exposing informatica workflow as webservice.
Experience in working as a onsite coordinator in client interfacing role in multiple countries.
Experience in working with Informatica Bigdata Management (BDM) edition.
Experience in developing and troubleshooting in Informatica PowerCenter 9.x and Oracle SQL - PL/SQL.
Extensively involved in optimization & tuning of the code written in Python, SQL & Informatica.
Sound knowledge and experience in working in Agile(SDLC) methodology.
As a member of Data Warehousing and Business Intelligence Team, responsible for writing technical specifications for developer, Oracle SQL-PL/SQL and Informatica development, and mentoring. Reviewing existing Oracle SQL-PL/SQL processes to develop and supervise a plan to implement Oracle SQL-PL/SQL best practices.
Ability to easily grasp new concepts. Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, capable of working efficiently under pressure.
Excellent written and verbal communication skills including presentation creation.

TECHNICAL SKILLS

ETL Tools: Informatica IICS, Informatica PowerCenter 8.6.1/9.1.0/9.6.1/10.0

Databases: Snowflake, Oracle 10g/9i/8i ( SQL & PL/SQL)

Language: Python

Operating Systems: Windows 2000/ NT/ XP

Packages: MS OFFICE (MS Word, MS Excel, MS Access) 2007/2003, MS VISIO.

Business Areas: Telecom and Order Management System.

PROFESSIONAL EXPERIENCE

Confidential

Architect/Team Lead

Responsibilities:

Prepare functional requirement document by performing requirement Analysis and Interaction with business users to understand the business requirement.
Being an onsite coordinator, synch up between onsite and offshore teams to meet the deliverable timelines.
Performed POC for functional requirement wherever required.
Prepare High/Low Level Design Document for the proposed solution and get sign off for all deliverables from client’s respective team.
Sound knowledge and experience on different phases of Agile/ITUP(IT Unified Process) software development life cycle (SDLC) including analysis, design, development and testing.
Leading the Design and Development activities for Oracle SQL-PL/SQL, ETL and Unix Shell scripting.
Performance Tuning and optimization of Oracle Query/Procedures.
Created Reusable Common objects for the team to maintain the Common Code. Ex: Common Procedure and Function.
Maintained Audit table which stores records that doesn’t meet the conditions.
Performed integration testing for developed components.
Prepared Build manifest, Run books for moving code to Production.
Responsible for preparing migration strategy document.
Maintain/check-in all the deliverable documents in Jira/Bit Bucket rational tool.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship