Technology Analyst Resume
SUMMARY:
- Technology Analyst with 7 years of experience.
- Expertise in Confidential ETL Web Services, Python and Java programming.
- Possess good skills in Redshift Performance Tuning, Design Pattern, Data Structures and Algorithms.
- Experienced in development of ETL, web services and automation.
TECHNICAL SKILLS:
Confidential Web Services: Lambda, EMR, Redshift, Aurora, Athena, S3, Data Pipeline, Redshift Spectrum, EC2 Container Service, DynamoDB, CloudWatch, SNS, Kinesis
Apache Tools: Hadoop, Spark, Kafka, Samza, Zookeeper, Tomcat, Hive
ETL/Reporting Tool: Informatica, Tableau, Business Objects
Programming Language/Framework: Python, Java, Spring, Boto3 (for AWS integration) Design Pattern, Data Structures and Algorithm Development
Web Designer Tools: AngularJS, NodeJS, HTML, CSS, Javascript, jQuery, Bootstrap, AJAX, JSP
PROFESSIONAL EXPERIENCE:
Confidential
Responsibilities:
- Salesforce team transfers user activity data in text file format to EC2 instance. Data is then streamed to S3 through Kafka.
- Lambda is used to trigger the pipeline to load the data into Aurora database as and when the files are received in S3.
Confidential
Responsibilities:
- Developed Informatica Mapping and Bash Shell Scripting is used to pull data from various source. Redwood is used to schedule the jobs.
- S3 is used as Data Lake for AWS services.
- Aurora DB is used for tracking the status of the jobs in AWS.
- PySpark is used to develop EMR jobs to process ETL with huge volume of data and to load it into Redshift.
- AWS jobs are scheduled in Data Pipeline. CloudWatch and SNS Alarm are used to monitor any failure in data pipeline jobs.
Confidential
Environment: Data Migration from Netezza to Redshift.
Responsibilities:
- Category Management data is migrated from Netezza to reserved Redshift cluster.
- Performed SQL optimization in the scripts to suit columnar database and reduced overall run time significantly.
- Optimized Redshift WLM settings to suit reporting and ETL demands.
- Developed Informatica mappings and bash shell scripts to load data in Redshift.
- Developed Informatica ETL jobs to load data from DB2, SQL Server to Netezza.
- Scheduled the Informatica jobs in Control - M scheduler.
Confidential
Responsibilities:
- Involved in UI development and design of entire application.
- Lead the team in developing the application from scratch.
- WinAD Access Management to dashboard.
- Business Object scheduled report status can be monitored in single page.
- Monitoring checklist page provides the list of tasks to be taken care on a specific day. Each task displays the list of common issues and resolution easing monitoring activities for new team members.
- Responsive site.
- Themes interchangeable from backend.
- Mobile-first design
Confidential
Environment: To be integrated with Core Banking routed via Finacle Integrator.
Responsibilities:
- Involved in development of the online remittances module.
- Have successfully integrated with core banking.
- Extended End-to-End support from EBanking to Core Banking at onsite.
- Lead the team in successful integration testing and fixed all the critical issues with the integration at SIT level itself.
Confidential
Responsibilities:
- Third Party Integration for Security Device validation.
- Web page designing and back-end development for the Transaction signing functionality.
Confidential
Responsibilities:
- User Interface change for the Bill payment module
- Development of Telecom Bill Payment module.