Sathish Kaniganahalli Ramareddy
Prosper,TX
Summary
Accomplished Information Technology professional with over 15 years of experience specializing in Production Support Management and Data Analytics Engineering. Proven expertise in project management, client communication, and expectation management, supported by a robust educational foundation with a PG in Data Science and Business Analytics from the University of Texas at Austin (through Great Learning). Extensive domain knowledge in Capital Markets and Hedge Fund Services, coupled with proficiency in a wide range of RDBMS and NoSQL databases, cloud services on AWS and Azure, and data visualization tools such as Power BI and SAP BO. Recognized for strategic planning capabilities, risk analysis, and leadership of high-performance teams to deliver critical projects with minimal service interruptions while adhering to ITIL methodologies for incident and change management.
Managerial professional with proven record of streamlining processes and leading high-performing teams. Known for strong analytical skills and commitment to achieving results. Teams rely on collaborative leadership and adaptability to changing needs.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Manager Technology
Publicis Sapient
10.2017 - Current
- Ensure that production services meet or exceed internally and externally prescribed SLAs and OLAs, with a focus on performance, availability, and incident/problem resolution.
- Manage and role model the support team’s incident response including proactive communication of progress and expectation management
- Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details
- Assists in design and development of data collection strategies, aggregation, analysis, and reporting to ensure data integrity and enhance information value
- Perform Root cause analysis and lead problem management efforts identifying causes of recurring issues. Coordinate with cross-functional teams to recommend technology and implement permanent solutions.
- Processing large amounts of structured and unstructured data, including integrating data from multiple sources.
- Wrote python scripts to parse XML documents and load the data in database.
- Validating data from Sybase IQ to Snowflake to make sure data matches.
- Optimized Snowflake data warehouse query performance by 30% through the implementation of materialized views and strategic clustering.
- Engineered real-time data pipelines integrating Snowflake and Kafka, cutting data latency
- Integrated Snowflake with third-party data sources and APIs, increasing the data consistency
- Conducted data quality checks and implemented validation processes, reducing data discrepancies
- Implemented Snowflake's Time Travel and Fail-safe features, enhancing data recovery options and reducing downtime
- Built robust data ingestion frameworks using Snowpipe, improving data availability
- Create new Procedures, Triggers and Functions for pulling the reports from Database.
- Maintained and optimized SQL queries in the data lake, reducing query run time and efficiently pull information for large reports.
- Work with BI tools like PowerBI to Create interactive dashboards
- Monitoring the progress of projects to ensure that deadlines are met and quality standards are maintained
- Lead efforts to continuously monitor the production application and infrastructure environment
- Ensures success of all production release and deployment activities
- Accomplished multiple tasks within established timeframes.
- Cross-trained existing employees to maximize team agility and performance.
- Controlled costs to keep business operating within budget and increase profits.
- Developed a strong company culture focused on employee engagement, collaboration, and continuous learning opportunities.
- Built high-performing teams through effective recruitment, onboarding, and talent development initiatives.
- Mentored junior team members for career advancement, fostering a pipeline of future leaders within the organization.
- Led cross-functional teams to achieve project goals, fostering collaboration and innovation.
Lead Consultant
CVS Health
10.2016 - 10.2017
- Provide resolution to Application issues in a time bound fashion to ensure Business Continuity
- Identifies root causes of reoccurring problems and implements solutions in accordance with sop.
- Document internal procedures and monitoring daily reports and errors for both transformations and data communication connections.
- Create new Procedures, Triggers and Functions for pulling the reports from Database.
- Tuning Procedures used by Application UI and improve performance.
- Provide scenarios for automated scripts and tactical solutions for functional and non-functional issues.
- Modified, maintained and developed the PL/SQL codes to develop new enhancements.
- Meeting with clients, Onsite coordinator and developers for debug session and defect resolution
- Involve in Bug Fixing and Defect Verification
Lead Consultant
Morgan Stanley
10.2013 - 09.2016
- Analyze and Gather the differences between existing (MSPA2) and MSPA3 application.
- Assist in the development, design and implementation of Application Reporting Database. Serve as member of a project team or as an individual contributor or as a Lead when assigned.
- Automate the process to Transform and Load the backdated data into MSPA3 reporting Database.
- Reconcile Data and get signoff from Business for Backdated Load of all clients.
- Create new Procedures, Triggers and Functions for pulling the reports from Database.
- Tuning Procedures used by Application UI and improve performance.
- Identify and Fixing bugs in application flow.
- Identifying risks proactively and proposing solutions to resolve them
- Getting reports verified from Crystal Reports template team after migration
- Responsible for tracking of trouble tickets and resolution of escalated support incidents
- Addressing the issues raised by the users and providing relevant information to them as needed
- Coordinate with customers to resolve technical support issues
- Monitor queues, batch jobs and application errors
- Utilize technical expertise to manage multiple assignments, to assure timely and cost-effect objectives delivery.
- Coordinate development activities, evaluate and report performance of project.
- Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
Application Developer
Metropolitan Regional Information System
05.2012 - 09.2012
- Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
- Involved in data modeling team for identifying tables and relations between them
- Updating functional specification document related to Database
- Writing Complex SQL queries and KT on Database objects to Front End Development team.
Application Developer
J P Morgan Chase
09.2011 - 05.2012
- Developed, modified and maintained the PL/SQL codes to develop new enhancements.
- Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
- Wrote code for database applications.
- Used ASP.NET, JavaScript and SQL Server to develop new applications.
- Collaborated with cross-functional teams to design and develop high-quality applications for various industries.
- Developed custom solutions for clients based on their unique business requirements and objectives.
- Optimized application performance through rigorous analysis of system bottlenecks and implementing targeted solutions.
- Worked closely with clients throughout the development process to gather feedback, ensuring that final products met their expectations.
- Collaborated with multidisciplinary teams to design and implement new technology features.
- Contributed to the successful completion of numerous projects, meeting deadlines and adhering to budget constraints.
Application Developer
IBM
12.2010 - 09.2011
- Provide technical support for NRM
- Responsible for tracking of trouble tickets and resolution of escalated support incidents.
- Answers technical support queries and implements fixes for application problems.
- Built complex queries using SQL and wrote stored procedures using PL/SQL
- Modified, maintained and developed the PL/SQL codes to develop new enhancements.
- Create and maintain the documentation to support the team and business.
- Generated reports from the database using PL/SQL and SQL.
- Extensively used for all and bulk collect to fetch large volumes of data from table.
- Debugging and Fixing Production Data.
Application Developer
Bank of Montreal
10.2010 - 11.2010
- Writing the Test Scripts which makes quality deliverables
- Reviewing the Test Scripts and documenting comments in ReviewLogs
- Attending Team discussion whenever necessary, which helps team to get more insight
- Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
Application Developer
Capgemini
06.2008 - 09.2010
- Provide technical support for Lawson PSA
- Modified, maintained and developed the PL/SQL codes to develop new enhancements.
- Modified, maintained and developed the Report Files with the help of Crystal Reports.
- Coordinate with customers to resolve technical support issues.
- Responsibilities as an oracle developer include management of the queries, enhancement and support service issues.
- Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
- Work on cross-functional teams to proactively address support issues.
- Writing and executing Test Conditions and Test Scripts which makes qualitydeliverables
- Attending Team discussion whenever necessary, which helps team to get more insight
- Project Quality Lead.
- Generate reports from the database using PL/SQL and SQL.
Education
PG Program - Data Science And Business Analytics
The University of Texas, Austin
12.2022
Bachelor’s Degree - Engineering (Information Science)
University Visvesvaraya College of Engineering - Bangalore University
Bangalore, India06.2008
Skills
- Operating Systems: Unix, Windows
- Cloud Technologies: Snowflake, SnowSQL, Snowpipe, AWS, Azure
- Prog Languages: PL/SQL, Python, Perl and Unix Scripting, PySpark, Pandas
- Databases: Snowflake, DB2, Oracle, Sybase, SQL Server, MySQL, MongoDB
- Tools: Toad, SQL Developer, DB Artisan, VSS, Perforce, Tortoise SVN, Git, Confluence, Jira, Service Now, Putty, Control-M, Tidal, Autosys, Kafka, IBM MQ, Azure DevOps
- Reporting Tools: Oracle Forms and Reports, Crystal Report, Power BI
- Domain Knowledge: Health Care, Investment Banking, Hedge Fund Services
- Team leadership
- Time management
- Decision-making
- Complex Problem-solving
- Project management
- Project planning
- Data analysis
- Effective communication
- Problem resolution
- Multitasking
Certification
- Oracle: 1Z0-007 Introduction to Oracle9i: SQL
- Oracle: 1Z0-147 Program with PL/SQL
- ITIL v3 Foundation Exam
- AWS Certified Cloud Practitioner
- Snowflake from Udemy
Languages
English
Full Professional
Timeline
Manager Technology
Publicis Sapient
10.2017 - Current
Lead Consultant
CVS Health
10.2016 - 10.2017
Lead Consultant
Morgan Stanley
10.2013 - 09.2016
Application Developer
Metropolitan Regional Information System
05.2012 - 09.2012
Application Developer
J P Morgan Chase
09.2011 - 05.2012
Application Developer
IBM
12.2010 - 09.2011
Application Developer
Bank of Montreal
10.2010 - 11.2010
Application Developer
Capgemini
06.2008 - 09.2010
PG Program - Data Science And Business Analytics
The University of Texas, Austin
Bachelor’s Degree - Engineering (Information Science)
University Visvesvaraya College of Engineering - Bangalore University
Similar Profiles
AMIT GUPTAAMIT GUPTA
Senior Manager - Agile Program Management at Publicis SapientSenior Manager - Agile Program Management at Publicis Sapient
Sugandha RajSugandha Raj
Product Owner at Publicis SapientProduct Owner at Publicis Sapient
Tushar KaushikTushar Kaushik
Specialist Infrastructure at Publicis Sapient Groupe LtdSpecialist Infrastructure at Publicis Sapient Groupe Ltd
Janette GoeserJanette Goeser
Senior Designer (Video) at Publicis SapientSenior Designer (Video) at Publicis Sapient
Mia FreemanMia Freeman
Cheer Coach Volunteer at Prosper Youth Sports AssociationCheer Coach Volunteer at Prosper Youth Sports Association