Srinivas Reddy D
Hyderabad
Summary
13 years of IT expertise with proficiency in SAS, SQL, AWS, GCP, Tableau, Appian, Python, and Power BI. Developed SAS, SQL, CICD processes and managed job workflow scheduling with Autosys. Certified Professional Google Cloud Data Engineer with strong technical and architectural solution development skills. Skilled in problem-solving, decision-making, and adapting to new technologies.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Sr Developer and Tech lead
CITI Bank
01.2020 - Current
- We receive non-automated files from stakeholders in various formats, many of which contain complex Excel formulas and require manual intervention. These inputs are not standardized and cannot be processed directly through automated systems. Once the files are received, we analyze and convert the manual processes into a fully automated end-to-end solution using technology supervision tools such as SAS and Tableau. The developed code is then migrated to Bitbucket, which serves as the version control repository to ensure proper code management and traceability. After deployment, Autosys picks up the code from Bitbucket and schedules the jobs to run automatically. This eliminates manual intervention, ensures consistent execution, improves efficiency, and enhances reliability of the overall process.
- Gathered and analyzed business requirements from users, including required input files, to initiate development activities.
- Reviewed incoming files and defined accurate timelines for delivery of mini-projects.
- Collaborated closely with cross-functional teams to ensure solutions were developed in alignment with business objectives.
- Engaged with business and functional owners to conduct high-level review sessions, translating business cases, vision, and action plans into executable deliverables.
- Trained team members on technology supervision tools such as SAS and Bitbucket, ensuring adherence to development and version control standards.
- Monitored team progress by tracking development activities and timelines to ensure on-time delivery.
- Created and managed JIRA stories, ensuring timely closure and sprint commitments.
- Prepared User Acceptance Testing (UAT) documentation and documented current process procedures for each EUC, including effort estimation and delivery timelines.
- Actively performed Scrum Master responsibilities, facilitating agile ceremonies, and supporting sprint execution.
- Generated validated output datasets through SAS jobs, which were consumed by Tableau to create interactive dashboards aligned with client business requirements.
Sr SAS developer and Tech Lead
Fairstone
06.2017 - 12.2019
- A loan analysis and reporting application is currently running in mainframe with SAS jobs. The final reporting is being used by for various analysis and new business opportunities. Right now, whole infrastructures are being migrated to AWS. In which some of the SAS jobs are being converted to AWS EMR jobs.
- Migrating SAS jobs from Legacy Mainframes system to AWS cloud environment by setting data warehouse in redshift and prepare the jobs to executable in SAS on Linux servers.
- Understand the current and SAS jobs and Workflows in Mainframes.
- Prepared High-Level solution design and presented to Business/Client during planning phase. e.g. Detailed Solution Architecture document, Migration strategy document, technical specification document Involved in creating.
- Implementing a solution for Fairstone Financials Inc, Canada to migrate Analytic and reporting model from Mainframe to AWS Cloud data warehouse.
- Technologies with Hands-on experience: Amazon web services Redshift Data warehouse, S3, Code Commit, EMR HDFS, Hive, Python 3.1 etc.
- Interact with clients for collecting high level user requirements and prepare project plan.
- Analyze, calculate, and provide efforts required for each phase.
- Handle Code versions using AWS Code Commit-Git code versioning tool in cloud.
- Review code in the team to ensure accuracy, completeness, and quality of the deliverable. Prepare Functional and Technical design Specifications, Deployment checklist for each release.
- Provide functional and technical guidance to new team members and train with Technical and Functional knowledge.
- Working knowledge on AWS Redshift, Data modeler and AWS Elastic Map Reduce (EMR) Python Developer. Contribute in end-to-end solution of code development on AWS platform.
- Schedule jobs using JAMS scheduler.
- Conversion of SAS Jobs from Mainframes to AWS Cloud.
- Migrated the 12 years of Mainframes data to AWS S3 Cloud.
- Leading Canadian Bank
SAS Developer
Capital One
08.2012 - 05.2017
- Back-office analytics team handles how many cases were opened for non-phone channels in different process by a credit card customer. Analysis was done on why the case is opened. Forecast on how many cases will come in and gets closed every day and assign respective FTE to work on them. Recently, to make better process and case handling system, we have analyzed and identified that change is needed in internal target completion date for few queues. Most of it depends on how customer complaints come in and gets solved. To and for adjustment of target completion date will be done every time when needed to improve the process.
- Understanding Business Requirement Documents.
- Pull the required data from the Database using SAS to do further Analysis.
- Developed reports for various modules using SAS and Mainframes.
- Involved in performance tweaking of some reports.
- Had a good interaction with Unit managers to understand data.
- Involved to solve Many Adhoc requests and Bug fixing issues.
- Tested data, graph, mapping, and calculations for QlikView reports.
Education
Advance post-graduation Diploma - Clinical Research and Management
CREMA
Bangalore01.2010
BSc - Biotechnology
Osmania University
01.2008
Skills
- SAS
- SQL
- Tableau
- Appian
- AWS
- GCP Cloud
- Python
- Power BI
- AWS cloud migration
- Bitbucket version control
- Tableau visualization
Personal Information
Total Experience: 13+ years
Certification
Professional Google Cloud Data Engineer.
Timeline
Sr Developer and Tech lead
CITI Bank
01.2020 - Current
Sr SAS developer and Tech Lead
Fairstone
06.2017 - 12.2019
SAS Developer
Capital One
08.2012 - 05.2017
Advance post-graduation Diploma - Clinical Research and Management
CREMA
BSc - Biotechnology
Osmania University