Sivakrishna Thottempudi
Aubrey
Summary
Experienced with creating comprehensive data architecture strategies that align with business objectives. Utilizes advanced data modeling techniques and architectural frameworks to enhance system efficiency and reliability. Track record of optimizing data management practices, ensuring seamless data integration, and supporting data-driven decision-making.
Overview
13
13
years of professional experience
Work History
Data Architect
Western Alliance Bank
08.2021 - Current
- Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.
- Led the migration of legacy systems to modern platforms, minimizing downtime and ensuring smooth transitions for endusers.
- Delivered actionable insights through advanced analytics and reporting tools, empowering decision-makers to make data-driven choices.
- Developed a robust data quality management framework, increasing the accuracy and reliability of enterprise-wide information assets.
- Developed comprehensive data models, ensuring alignment with organizational goals and industry best practices.
- Spearheaded efforts in metadata management, enabling accurate tracking of information assets across the organization.
- Managed multiple complex projects simultaneously, delivering high-quality results within established timelines and budgets.
- Streamlined data storage and retrieval processes for improved productivity with optimized database structures.
- Resolved complex technical challenges by leveraging deep expertise in SQL programming languages and relational databases platforms such as Oracle or Microsoft SQL Server.
- Mentored junior team members in advanced concepts related to enterprise data architecture, fostering a culture of continuous learning and professional growth.
- Designed custom ETL processes to facilitate seamless integration between disparate systems, improving overall operational efficiency.
- Provided expert guidance on data governance policies, contributing to the establishment of a secure and compliant data environment.
- Optimized query performance through effective indexing techniques, reducing response times and improving user satisfaction.
- Evaluated emerging technologies in the field of enterprise data management, recommending innovative solutions that aligned with business objectives.
- Championed best practices in data warehousing methodologies, driving consistency across multiple development initiatives.
- Conducted regular audits of data systems, ensuring compliance with established security standards and regulatory requirements.
- Established strong relationships with stakeholders at all levels of the organization, facilitating clear communication channels for project updates and issue resolution.
- Implemented robust backup and recovery strategies, safeguarding critical business information from potential loss or damage.
- Enhanced data management efficiency by designing and implementing enterprise-level data architecture solutions.
- Conducted thorough assessments of current database environments, identifying areas for improvement and recommending strategic enhancements.
- Created multi-site system architecture plans to reduce redundancy across entire organization.
- Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
- Generated customized architecture specifically optimized for several database technologies.
- Authored full Center of Enablement (CoE) design plan optimized for governance and performance metrics sought by client.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Established and secured enterprise-wide data analytics structures.
- Incorporated cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
- Managed identification, protection and use of data assets.
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
- Verified isolation of data to specific geographic borders to comply with national and international data transmission laws and regulations.
- Designed data models for complex analysis needs.
- Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
- Developed and delivered business information solutions.
- Complied with regulatory guidelines such as [Type] in design architecture, ensuring adherence to strict privacy and security laws.
- Employed Software-as-a-Service (SaaS) and Platform-as-a-Service ( PaaS) products to reduce initial outlay in systems purchasing [Number]%.
- Created sets of pre-fabricated systems architecture models for deployment at multiple facilities across enterprise-class organizations.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
- Planned and installed upgrades of database management system software to enhance database performance.
- Documented and communicated database schemas using accepted notations.
Platform Engineer
T.Row Price
05.2016 - 07.2021
- Enhanced platform performance by optimizing infrastructure and implementing automation tools.
- Championed best practices in code quality through code reviews, refactoring initiatives, and documentation efforts.
- Addressed performance bottlenecks by conducting thorough profiling and analysis of system components.
- Facilitated seamless deployments by designing an efficient release management process aligned with business objectives.
- Evaluated new technologies for potential adoption into the platform ecosystem, ensuring a cutting-edge tech stack.
- Contributed to the development of microservices architecture for enhanced modularity and flexibility.
- Collaborated on cross-functional teams to drive platform improvements and deliver business value.
- Designed resilient systems that maintained high availability during peak usage periods.
- Ensured a smooth transition during major platform upgrades by meticulously planning rollouts, testing thoroughly, and providing post-deployment support when needed.
- Streamlined development workflows by integrating continuous integration and delivery practices.
- Developed custom tools and scripts to automate routine tasks, boosting team productivity.
- Increased system reliability with proactive monitoring and timely issue resolution.
- Played an integral role in architecting scalable solutions that supported growing user bases while maintaining optimal performance levels.
- Spearheaded migration efforts to cloud-based infrastructure, resulting in improved scalability and cost savings.
- Provided technical leadership, mentoring junior engineers, and fostering a culture of knowledge-sharing within the team.
- Partnered with stakeholders to gather requirements and translate them into actionable engineering tasks.
- Reduced deployment time for applications through efficient configuration management processes.
- Leveraged containerization technology for streamlined application packaging and distribution across environments.
- Established metrics-driven culture, utilizing key performance indicators to guide decision-making in platform operations.
- Implemented security best practices, safeguarding sensitive data and minimizing vulnerabilities.
- Led engineering teams to successfully complete projects on time and within budget.
- Developed high-quality engineering designs and plans to meet industry standards.
- Analyzed and interpreted data to identify trends and recommend improvements.
- Collaborated with other departments to facilitate successful project completion.
- Documented and developed engineering procedures and processes.
- Developed and maintained relationships with suppliers to facilitate quality and timely delivery of materials.
- Implemented automated systems to improve accuracy and efficiency of engineering processes.
- Created detailed reports on engineering activities and findings.
- Trained and mentored junior engineers, providing guidance and direction.
- Assisted in developing cost-effective solutions to engineering problems.
- Verified construction documentation to meet client requirements and vision.
- Analyzed and interpreted customer requirements to develop engineering solutions.
- Conducted technical evaluations of engineering designs and test results.
- Developed comprehensive engineering documents for all projects.
- Developed and implemented procedures to verify compliance with engineering standards.
- Monitored and evaluated engineering performance to recommend improvements.
- Designed and implemented quality control processes to facilitate customer satisfaction.
- Implemented new strategies to reduce costs and improve efficiency of engineering team.
- Conducted research to identify and evaluate new technologies and concepts.
- Performed complex calculations to analyze and optimize engineering processes.
Informatica Administrator
Tech Mahindra
08.2012 - 04.2016
- Led training sessions for new team members on Informatica tools usage, instilling confidence in their ability to manage the platform.
- Supported business users with ad-hoc data requests, ensuring accurate information was provided in a timely manner.
- Implemented effective version control strategies for better management of code changes and releases.
- Contributed to organizational success with swift issue resolution during critical incidents involving the Informatica platform.
- Supported continuous improvement efforts by proactively identifying areas for process enhancement and implementing changes accordingly.
- Improved overall ETL performance with thorough testing, tuning, and optimization of PowerCenter components.
- Conducted regular audits of Informatica repositories to ensure adherence to established naming conventions and coding standards.
- Resolved critical production issues with timely troubleshooting and root cause analysis.
- Collaborated with cross-functional teams to ensure seamless data integration across enterprise systems.
- Provided expert guidance on Informatica best practices during project design phases, ensuring optimal solutions were implemented from the start.
- Enabled efficient code migration between environments by utilizing deployment groups and repository manager utilities effectively.
- Maintained a secure Informatica environment by implementing user access controls and adhering to best practices for data governance.
- Streamlined reporting processes by automating manual tasks using PowerCenter Scheduler functionalities.
- Simplified complex ETL processes through the creation of reusable mappings, mapplets, and transformation logic.
- Developed custom transformations as needed for unique business requirements.
- Ensured data quality by designing and implementing data validation rules within Informatica workflows.
- Reduced system downtime by proactively monitoring Informatica jobs and addressing potential issues promptly.
- Assisted in capacity planning efforts by analyzing resource utilization trends and recommending appropriate infrastructure upgrades when needed.
- Enhanced Informatica performance by optimizing workflows, sessions, and mapping configurations.
- Documented technical specifications for all developed ETL processes to facilitate knowledge sharing among team members.
- Prepared technical design documents and specifications for [Use].
- Collaborated with business analysts to understand and define requirements.
- Identified, troubleshot and corrected bugs and bottlenecks.
- Implemented business logic parameters for model execution.
- Developed mappings, workflows and tasks using [Software].
- Created and updated database designs and data models.
- Set up and controlled user access levels across databases to protect important data.
- Modified databases to meet needs and goals determined during planning process.
- Conducted tests to identify issues and make necessary modifications.
- Implemented security measures to protect vital business data.
- Installed and configured middleware in Linux and Windows environments.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Implemented BI solution framework for business intelligence projects.
Education
Bachelors - Computer Science
Prakasam Engineering College
Kandukur 05-2011
Skills
- Azure Data factory
- ADLS
- Synapse
- Informatica
- Power BI
- Tableau
- Databricks
- Profisee
Timeline
Data Architect
Western Alliance Bank
08.2021 - Current
Platform Engineer
T.Row Price
05.2016 - 07.2021
Informatica Administrator
Tech Mahindra
08.2012 - 04.2016
Bachelors - Computer Science
Prakasam Engineering College
Similar Profiles
Frank Gracia IIIFrank Gracia III
Preferred Bank Advisor at Western Alliance Bank (Alliance Bank of Arizona & Bridge Bank)Preferred Bank Advisor at Western Alliance Bank (Alliance Bank of Arizona & Bridge Bank)
Diego RiveraDiego Rivera
Preferred Banking Advisor at Western Alliance BankPreferred Banking Advisor at Western Alliance Bank
Carla D. McGheeCarla D. McGhee
Sr. Preferred Banking Advisor at Western Alliance BankSr. Preferred Banking Advisor at Western Alliance Bank