We provide IT Staff Augmentation Services!

Team Lead Resume

Pennington, NJ

EXPERIENCE SUMMARY

  • Result oriented Data Specialist and ETL Developer with more than 9 years of experience in the domain of Banking & Financial Services, Manufacturing, Telecom and Mass Media.
  • Certified Data Architect by MIT Professional education and Accenture
  • Experience of implementing end to end General Data Protection Regulation(GDPR) solution.
  • Developing end to end solution for California Consumer Privacy law.
  • Data Analysis and Code development experience in ETL technologies like Data Stage 9.1, DataStage 8.7, DataStage 8.1, Informatica MDM (Siperian), UNIX and creating reports and procedures using SQL and PL/SQL on Oracle database
  • Experience of working on Artificial Intelligence - Machine learning(AI-ML) driven data solutions like Data Discovery, Lineage, Data Veracity for variety of Data platforms.
  • Have acquired niche functional knowledge across GlAmerican Wealth Management - Investment, Portfolio Management, Retail Banking and GFCC Regulatory Reporting
  • Ardent Analyst with a flair for adapting quickly to dynamic business environments, skilled in adopting a pragmatic approach in improvising on solutions and resolving complex business issue
  • IBM Certified DataStage(ETL) Developer
  • Experience of working with Agile methodology

PROFESSIONAL EXPERIENCE

Team Lead

Confidential

Responsibilities:

  • Formulate and document the End to end Solution Architecture
  • Document and sign of implementation Plan - Phases of Development, Testing, QA Plan and Deployment
  • Evaluate readily available tools to ease implementation of compliance solution components and integrate them with custom built features
  • Optimization of Machine learning based tool for Data Discovery
  • Stakeholder interaction to evaluate current state of compliance and provide roadmap to help achieve complete compliance
  • Build capabilities for enterprises to support their regulatory mandate of Data Subject Rights
  • Build customized Dashboard for DPO, CISO, CDO for ongoing Governance

Data Quality Analysis and Reporting

Confidential, Pennington, NJ

Responsibilities:

  • Coordinated and facilitated extensive user interviews, brainstorming and JAD sessions with business partners and application users to gather requirements and strategize business alignment.
  • Collaborated closely with SMEs to devise the roll out strategy by identify core mapping requirements and prioritization of key features for the data portal
  • Developed crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support these functional specifications and features
  • Collaborated with management and external stakeholders to identify and implement changes to systems and processes to enhance the user experience by holding periodic review meetings
  • Used Agile methodology to iteratively interact with functional teams and users for finalizing the data models and reporting structures along with unit testing of the developed components
  • Designed and implemented ETL code for sourcing data from multiple data marts into the finalized data model.
  • Extensively used SQL and PL/SQL tuning techniques to improve the performance
  • Worked with DBA and Reporting team to generate Materialized View of the data warehouse and evaluation of performance gain
  • Configuration control and management
  • Performing integration of processes with existing batch cycles to ensure best utilization of DS servers
  • Responsible for developing and maintaining Automation Scripts (Unix Shell Scripts, PL/SQL) for daily refresh of the dashboards and for sending alerts in case of data spikes
  • Verifying the data quality based on different reports generated and raise defects when anomalies are identified
  • Data profiling and prototyping to confirm business requirements and expectations to IT Design and develop actionable intelligence to assist data analysis and Data remediation
  • Build platform for near real time actionable intelligence, fraud detection, privacy breach identification
  • Development and delivery of Dashboard and reports for Data Quality measurement and monitoring
  • Identify gaps in business and technical processes by establishing data pattern

Data Quality Analysis and Reporting

Confidential, Pennington, NJ

Responsibilities:

  • Understanding Business requirements based on SAD, BRD & HLDs
  • Conduct workshops and walkthroughs with business representatives and address risks/limitations and design mitigation strategy.
  • Documentation of end to end processes to analyze the impact of functionality implementation on existing application functionality
  • Testing the design and develop the ETL mappings, UNIX Scripts, Oracle procedures per the need of Project
  • Performing unit testing of the developed components and Review of test plan documents and assist during SIT/UAT testing phase
  • Optimizing the code and performance improvements of Oracle queries, ETL mappings etc.
  • Working with data governance to rectify any issue and mitigate the risks
  • Quality assurance activities
  • Configuration control and management
  • Analyzing Job Runs / Data Updates
  • Performing integration of processes and batch cycles functions to reduce timings and enhance utilization of machines
  • Responsible for developing and maintaining AutoSys (JILS), Automation Scripts (Unix Shell Scripts, PL/SQL)
  • Verifying the data quality based on different reports generated and writes fixes to solve the data anomalies
  • Provide domain training to new members in the team
  • Provision of Adhoc Production Report for Business partners

Module Leader - DataStage Developer

Confidential

Pennington, NJResponsibilities:

  • Formulate and document the End to end Migration Plan - Phases of implantation, Testing and QA Plan
  • Coordinate the migration project with offshore team
  • Review the code changes and testing efforts required as part of migration
  • Optimization in existing jobs for performance improvement
  • Developing the ETL mappings, Unix scripts, Oracle SPs for optimization
  • Combining of complex jobs to allow faster processing
  • Redesigning of Server jobs to suit parallel processing
  • Test review & Quality assurance activities

Programmer - DataStage Developer/ Support

Confidential

Responsibilities:

  • Working on Production L3 support and enhancement initiatives
  • Work involved, defect resolution in batch failures, problem reporting, change control, automation and impact analysis in case of issues/ delays. Ensured SLAs were met and serve as point of escalation.
  • Reconstruction of job sequences by logical reordering of jobs
  • Tools/Technologies involved - Datastage, Autosys, Unix, Siperian MDM
  • Enhancement work involved exposure to CFF, XML and Flat file stages in DS
  • Creation of Unix scripts for better performance by parallel thread processing
  • Identified manual processing deficiencies, and instituted automation techniques which reduced manual labor and increased work flow efficiency.

Hire Now