Team Lead Resume
3.00/5 (Submit Your Rating)
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.