Chaitanya Kiran
P: 765-***-**** Email: *********.**********@*****.*** McKinney, TX
Experience Highlights:
16+ years of SDLC experience with 10+ years managing offshore/onshore teams as a Project Manager and Scrum Master.
Led the full project lifecycle, from requirements analysis, project planning, scheduling, resource management, execution, and closure.
Directed large-scale data projects in capital markets and investment banking (Order Entry, Derivatives, Fixed Income), ensuring successful product delivery.
Planned and executed releases, facilitating sprints, backlog grooming, and post-production support for Agile teams.
Managed real-time streaming applications and batch-style computing solutions using Spark, Databricks, Kafka, and Hive.
Extensive hands-on experience in Snowflake SQL Data Warehouse and backend data architectures using SQL Server, SSRS, and SSIS.
Built and led high-performing Agile teams, driving operational excellence across various frameworks (SAFe®, Scrum, Kanban).
Collaborated with C-level executives to gather requirements, prepare executive reports, and lead senior management steering committee meetings.
Developed effective communication channels for program status, change management & risk mitigation with both US and offshore teams.
Strong experience in cloud technologies (PaaS, SaaS, IaaS) and application development using C#.NET and VB.NET.
Supported 24x7 operations, troubleshooting production issues in real-time and leading the production support team.
Skills & Expertise:
Project Management: JIRA, SharePoint, MS Office Suite, Confluence, Offshore/Onshore Team Leadership
Capital Markets & Investment Banking: Order Entry, Fixed Income, Derivatives, OTC, Money Markets, FOREX
Real-time Streaming & Distributed Computing: Spark Streaming, Kafka, Databricks, MapReduce, Hive
Cloud Technologies: PaaS, SaaS, IaaS
Data Warehousing & Reporting: Snowflake SQL Data Warehouse, Microsoft SQL Server, SSRS, SSIS
Programming Languages: C#.NET, VB.NET
Tools & Methodologies: PMBOK, Agile, Waterfall, SAFe®, Scrum, Kanban, Sprint Planning, Scrum, Release Planning, Budget Management, Resource Allocation, Executive Reporting
Executive Collaboration: Business Case Development, Steering Committee Leadership, Stakeholder Communication
Program & Change Management: Dependency Management, Organizational Communications, Key Metrics, Dashboards,
Certifications:
Certified Scrum Master
Professional Scrum Master
Microsoft Certified Technology Specialist
PROFESSIONAL EXPERIENCE
IDENTOPIA, Dallas, TX July 2023 - Present
Lead Project Manager / Scrum Master
Managed multiple programs and workstreams, engaging cross-functional teams and engineers to set the pace for development and ensure timely delivery.
Developed project documentation, process maps, presentations, and tracking reports to provide stakeholders with detailed status updates on each project.
Performed data analysis and translated user data into actionable plans, providing recommendations to Product Leads, with a strong focus on quantitative analysis.
Ensured on-time, on-budget project delivery, taking full accountability for driving project outcomes and deliverables.
Facilitated Scrum/Kanban ceremonies including daily stand-ups, sprint planning, reviews, retrospectives, and demos to maintain development cadence.
Designed and managed processes for integrating data from various sources (on-premise and cloud) into SAP Data Sphere, ensuring seamless data flow.
Developed and executed test plans/scripts using Selenium and Python, ensuring thorough testing and quality assurance of applications.
Built custom frameworks on Snowflake to handle monitoring, exception handling, alerting, metering, and chargeback processes.
Managed JIRA boards and backlog, supporting efficient sprint execution and prioritization of tasks.
Updated risk and control matrices and process flow maps for middle office operations with enhanced reporting for OTC derivatives and fixed income securities.
Developed Business Process Procedures (BPPs) and led projects as both Project Manager and Developer in Sales, Distribution, Controlling, and Human Capital Management.
Facilitated cross-contract integration, ensuring cohesive development across multiple workstreams to deliver unified final products to customers.
Converted Hive/SQL queries into Spark transformations using Spark RDDs and Scala, improving data processing and performance.
Promoted transparency and information sharing, supporting internal and external communications to enhance team collaboration.
Managed parallel application development processes, overseeing project/product implementation in fast-paced environments.
Assisted teams in making appropriate commitments, through story selection and task definition, identifying and removing impediments.
Facilitated conflict resolution and ensured teams were focused on release goals, minimizing distractions and fostering productivity.
Empowered teams to self-organize and enhance productivity, ensuring each increment of functionality is releasable code.
Partnered with stakeholders and project sponsors, providing transparency on delivery progress, challenges, and risks.
Built an ETL framework for Data Migration from on-premise sources (Hadoop, Oracle) to AWS using Apache Airflow, Apache Sqoop, and Apache Spark (PySpark).
Represented teams at broader planning sessions (e.g., Scrum of Scrums), ensuring alignment with organizational goals.
Led scrum teams to improve collaboration and self-management, fostering healthy interactions both within teams and with external stakeholders.
Provided mentorship to junior Scrum Masters and served as Agile Coach for moderately complex teams, promoting Agile best practices.
Supported teams in using Agile planning and development tools (Azure DevOps, AWS DevOps), streamlining processes and improving project visibility.
CBRE, Dallas, TX Mar 2020 – June 2023
Technical Project Manager
Ensured the successful delivery of internal products, including Service Insight and ServiceNow frontend customizations.
Coached new Scrum teams, implementing and adapting SAFe/Scrum practices to meet project deliverables and execution timelines.
Conducted research on machine learning projects, utilizing Python and Scikit-learn for data analysis and predictive modeling.
Led the implementation of Snowflake cloud-based SaaS data warehouse, collaborating with a 9-member team using Waterfall for integration and Agile for visualizations.
Actively participated in SAFe Release Train and Big Room Planning sessions, aligning teams to achieve quarterly goals.
Managed technical resources and senior IT stakeholders to develop an EDI Matrix Map, reducing complexity in OTC operations.
Designed and implemented scalable data pipelines using Scala and Apache Spark, processing large datasets in distributed environments.
Developed SAP Business Process Procedures (BPPs) and configured training servers for lesson exercises to support system education.
Participated in Scrum of Scrums meetings, working to adhere to process improvements and cross-team collaboration.
Phased out Silverlight by using Azure App Services and ASP.NET pages for effective cross-browser compatibility.
Collaborated with the SOX compliance team, ensuring successful delivery of technology controls and adherence to SOX regulations.
Led multiple migration projects, including transitioning from VSS to Git, ensuring smooth migrations.
Implemented CI/CD processes, automating deployments to replace manual efforts and streamline release management.
Created and monitored project schedules, ensuring updates and clear communication with stakeholders.
Integrated SAP Data Sphere with advanced analytics tools, enabling comprehensive data analysis through SAP Analytics Cloud and third-party BI tools.
Developed Tableau dashboards to monitor and understand Snowflake account usage, enhancing data visibility.
Oversaw ERP architecture and development, managing PLM, GSM, PPM, MDM, and SD modules, including S4-HANA MM configuration.
Facilitated weekly status meetings, discussing progress and addressing any roadblocks to ensure project alignment.
Collaborated with Scrum Masters and RTEs to identify and resolve cross-team dependencies during Scrum of Scrums.
Maintained quality assurance across production stages, ensuring development standards were met.
Completed client-required documentation accurately and within deadlines to ensure compliance.
Acted as a front-line escalation point for executive leadership communications, resolving escalated issues promptly.
Facilitated and coached Agile ceremonies, ensuring teams adhered to best practices for sprint planning, reviews, and retrospectives.
Provided coaching on backlog refinement and relative sizing, improving team efficiency and task prioritization.
Microsoft, Dallas, TX Feb 2019 – Feb 2020
Engineer/Scrum Master
Planned and executed sprints, managing releases to ensure successful deployments within established timelines.
Facilitated Agile ceremonies, including daily stand-ups, backlog refinement, story sizing, sprint planning, sprint reviews, and retrospectives.
Managed product and sprint backlogs, overseeing sprint planning, release planning, and backlog grooming to prioritize tasks and meet project objectives.
Coordinated Scrum meetings and facilitated backlog grooming sessions to ensure continuous alignment with project goals.
Resolved impediments during sprint execution, shielding the team from distractions and scope changes to maintain productivity.
Worked extensively in Azure PaaS/IaaS environments, providing architectural guidance and support for cloud-based database solutions.
Served as SME for cloud products, managing client relationships through advisory services and technical expertise.
Ameriflight, Dallas, TX July 2017 – Jan 2019
Project Manager
Reported directly to the CTO, responsible for the successful implementation of high-complexity technical projects, ensuring alignment with organizational goals.
Collaborated with C-level executives, presenting project roadmaps and release plans to ensure strategic vision and project feasibility.
Managed all aspects of project lifecycle, including planning, documentation, testing, execution, budgeting, and timelines, ensuring projects were completed on time and within budget.
Developed ETL solutions using Spark SQL in Azure Databricks, processing large datasets to analyze customer usage patterns and derive actionable insights.
Utilized Python packages (Pandas, Datetime) to handle large-scale data effectively within data frames, optimizing data manipulation.
Managed project budgets and resource allocations, driving successful project outcomes while minimizing risk and cost overruns.
Created custom ETL pipelines from S3 to Kafka and Kafka to Snowflake, leveraging a custom framework to enhance data flow.
Performed risk analysis and managed project scope, ensuring any changes to schedule or requirements underwent review and approval.
Collaborated with cross-functional teams to manage inter-team dependencies and facilitated communication between onshore and offshore teams.
Tracked team velocity and communicated sprint and release progress, ensuring that project milestones were met efficiently.
Facilitated daily scrum meetings and implemented JIRA for tracking and managing Agile projects.
Created custom ETL scripts in PySpark and Scala using AWS Glue, enabling ad-hoc data transformations and exploratory data analysis.
Defined the "DONE" criteria by gathering input from the entire Scrum team, ensuring a shared understanding of project goals.
Led sprint planning, retrospectives, and sprint reviews, creating JIRA stories and grooming story requirements.
Managed release planning, resource allocation, and project schedules, ensuring successful product releases.
Trained teams in Scrum/Agile best practices, supporting the Product Owner with backlog grooming and prioritization.
Facilitated Scrum of Scrums and coordinated cross-team dependencies to ensure seamless integration and collaboration.
Demonstrated product features during UAT and gathered feedback to optimize the final product.
Provided regular sprint status updates to the Product Owner and stakeholders, ensuring transparent communication throughout the project lifecycle.
Cigna Healthcare, Bloomfield CT Nov 2016 – June 2017
Software Analyst
Developed and managed multiple web and mobile applications, enhancing user experience and functionality across platforms.
Created data processing solutions using Spark, Scala, and Python in Hadoop/Hive environments, leveraging Linux and Windows for big data resource management.
Engineered internal applications with C#.NET and SQL Server, optimizing business processes and enhancing operational efficiency.
Created, updated, and managed complex SQL Server stored procedures, ensuring high performance and reliability of database operations.
Analyzed Outbound Advanced Shipping Notices for compliance with retail partners, including Wal-Mart and K-Mart, in the OTC drug industry.
Optimized databases for increased traffic, performing SQL performance tuning through indexing and query optimization techniques.
Managed product issues daily, organizing and prioritizing tasks within the backlog to streamline project execution.
Maintained and updated the product backlog, documenting progress and tasks daily to ensure team alignment and transparency.
Utilized DHTML, JavaScript, and CSS to create dynamic input forms, enhancing user interactivity and experience based on user selections.
Planned and conducted quality control tests, ensuring all applications met end-user requirements and industry standards.
Conducted interviews with end users and team members to gather project requirements, ensuring alignment with business needs.
Created product backlogs in Agile, facilitating daily Scrum meetings to drive project progress and team collaboration.
International Technological University, Santa Clara, CA Jan 2016 – Nov 2016
Project Manager/Scrum Master
Facilitated the implementation of Agile methodologies to enhance team performance and project delivery.
Developed weekly program and portfolio status reports, presenting findings to key executives and stakeholders to ensure transparency and informed decision-making.
Established project processes and guidelines, utilizing tools such as JIRA, Confluence, ServiceNow, MS Project, and MS Office Suite to streamline project workflows.
Facilitated daily Scrum meetings, sprint planning, reviews, and retrospectives to promote team collaboration and continuous improvement.
Acted as an Agile coach for team members, product owners, stakeholders, and executives, fostering an environment of learning & growth.
Conducted meetings with product owners, business units, and cross-functional teams to align project objectives and ensure stakeholder engagement.
Assisted teams in making informed commitments through story selection, enhancing the accuracy of sprint planning.
Proactively contributed to the development and maintenance of team standards and best practices, ensuring high-quality deliverables.
Protected the team from overcommitment, effectively managing the backlog and prioritizing resolutions to ensure project success.
Engaged in continuous collaboration, driving process improvement initiatives to optimize efficiency and effectiveness.
Utilized Python in Spark to extract data from Snowflake and upload it to Salesforce on a daily basis, enhancing data flow and accessibility.
Participated in pre-sales activities, supporting business development efforts through project insights and technical expertise.
Conducted sprint planning sessions, collaborating with the entire Scrum team to ensure well-defined sprint goals and deliverables.
Resolved impediments raised by development teams, providing clarifications and support to both development and QA teams.
Provided weekly status updates to management and stakeholders, ensuring consistent communication regarding project progress.
Express Scripts, St. Louis, MO Sep 2014 – Dec 2015
Scrum Master
Actively participated in gathering Business Requirements and System Specification from system users.
Worked in the HCR (Health Care Reform) project.
Created environment and guided teams to self-organize.
Successfully migrated projects from Waterfall to Scrum.
Owned responsibility to manage dependencies between teams.
Assisted team with making appropriate commitments through story selection.
Participated pro-actively in developing and maintaining team standards.
Led multiple projects to completion with high stakeholder satisfaction.
Microsoft, Fargo, ND Apr 2013 – Sep 2014
Sr. Engineer (Dynamics GP Support)
Immediate requirement implementation & defect resolution from users, regression testing & closure
Performance tuning of the SSIS packages and source queries used within the packages
Imported various Sources, Targets and Transformations using transact-SQL Server
Migrating SQL Server 2000 databases into SQL Server 2008.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
Involved in development and implementation of SSIS on an enterprise level.
Monitored and modified Performance using execution plans and Index tuning.
Maintaining the database consistency with DBCC at regular intervals.
Marvin Composites, Fargo, ND Jan 2012 – Apr 2013
Software Developer
Contributed as a DBA and database developer in the creation of systems using VB.NET, enhancing application functionality.
Implemented immediate requirement changes and resolved user defects, ensuring regression testing and closure.
Automated and scheduled SQL Server jobs for daily snapshot loads, streamlining operations.
Managed imports from various sources, implementing transformations using Transact-SQL Server.
Led migration of SQL Server 2000 databases to SQL Server 2008, ensuring a smooth transition.
Analyzed and tuned complex SQL queries to optimize application and system performance using SQL Profiler and Query Analyzer.
Regularly rebuilt indexes to enhance database performance and concurrency.
Identified and resolved database performance issues, ensuring efficient operation under high loads.
Developed complex stored procedures and views to generate various drill-through, parameterized, and linked reports using SSRS.
Created complex stored procedures, SSIS packages, triggers, and tables, utilizing various SQL joins and statements to support application needs.
CML Media, LLC, Irvine, CA Jan 2011 – Dec 2011
Systems Analyst
Understand project requirements and target deliverables from technical documentation.
Gathered requirements from business analysts to develop physical database.
Immediate requirement implementation & defect resolution from users, regression testing & closure
Performance tuning of the SSIS packages and source queries used within the packages
Automation and scheduling of SQL server jobs for daily snapshot load
Imported various Sources, Targets and Transformations using transact-SQL Server
Involved in designing of data model of the database. Worked on T-SQL statements to get transactions in time.
Providing 24X7 supports for production databases.
Bourne Financial Group, LLC, San Jose, CA Oct 2009 – Dec 2010
Software Developer
T-SQL programming on SQL Server 2008 R2 Enterprise
Create service in C# utilizing web service to ADD/EDIT. /DELETE
Create SSIS service to pull team coverage data from web server and reconcile
Managed security SQL server auditing proxies, credentials and logins
Created documentation of current server configuration
Life Technologies, Carlsbad, CA Sep 2008 – Sep 2009
Business Analyst
Managed security audit for dev, testing, user testing and prod servers
Maintained, optimized and created development objects such as triggers, stored procedures, and views
Authored standards document for SQL naming conventions
EDUCATION
Master’s in Computer Science from International Technological University, San Jose, CA
Bachelor’s in information technology from Andhra University, AP, India