Shashank Singh

Dynamic Team Lead and Senior Analyst at Iris Software with expertise in T-SQL and ETL pipelines. Spearheaded the migration of legacy systems, achieving a 96% reduction in report execution time. Adept at optimizing data models and fostering collaboration across teams to deliver impactful insights and solutions.

DataStore (DSE), NAB, Iris Software, 07/01/23, Present, MS SQL 2019, SSIS, SSRS, AWS, PowerBI, Jenkins, Redshift, PySpark, Team Lead/Senior Analyst, The DataStore (DSE) project focuses on maintaining and enhancing a data warehouse supporting critical custodian customer data. It integrates multiple applications to deliver seamless analytics, reporting, and compliance for business operations., Led the design and development of scalable ETL pipelines using SSIS to support enterprise-level data integration and reporting., Designed and optimized data models and schema structures in Redshift, ensuring performance and alignment with business reporting needs., Integrated AWS S3 for scalable storage, ensuring efficient data ingestion and retrieval., Developed and maintained SQL database objects, including stored procedures, views, and functions, ensuring high performance and reliability., Configured and optimized SSRS reports, enabling enterprise-wide access to actionable insights., Utilized Infrastructure as Code (IaC) practices to modify and replace deprecated Jenkins plugins, ensuring compatibility and reducing operational risks., Managed the data warehouse, ensuring high availability and performance by resolving critical ETL job failures within SLAs., Led the EPM Tool Migration, replacing legacy MS Access systems with scalable SSIS-integrated solutions., Enhanced Finance Ledger Reports on Oracle, achieving a 96% reduction in execution time., Delivered dynamic SSRS reports and automated real-time dashboards using Power BI, streamlining decision-making processes. Loyalty V 15.1 Groups and Reward, Aristocrat, 01/01/22, 07/31/23, MS SQL 2019, Technical Lead, Loyalty is a backend data management system for tracking user information, promotions, profit and loss, transport, and hospitality within the casino gaming ecosystem. The project supports data-driven decision-making and operational efficiency by providing reliable and optimized data solutions., Developed and maintained database solutions to manage user data, promotions, and profit/loss metrics., Optimized bulk data processing tasks, including transactions and expiration processes, to improve system performance., Designed and implemented stored procedures, views, and triggers to handle business-critical operations., Supported agile development processes by delivering Product Backlog Items (PBIs) and performing integration testing., Conducted code reviews to maintain code quality and mentored team members to enhance their technical skills., Streamlined data handling for bulk expirations, improving system responsiveness and reducing processing time., Optimized legacy processes like transport management to enhance efficiency and user experience. PACE2, Tata Consultancy Services, PepsiCo, 11/01/20, 01/31/22, MS SQL 2012, SSDT 2015, Developer, The PACE2 project involved upgrading the SAMNA application from version V5 to V8 to align with evolving business requirements for PepsiCo India. The upgrade required significant modifications to database structures, ETL pipelines, and reporting systems to ensure compatibility and scalability., Redesigned database tables and optimized existing stored procedures and SSIS packages to align with the upgraded application architecture., Designed and developed the structure of the peripheral applications., Developed new SSRS reports to support enhanced data reporting needs, including sales, master data, and target reports., Conducted detailed analysis of existing systems and implemented solutions to ensure smooth version migration., Collaborated with cross-functional teams to test and deploy changes without disrupting ongoing business operations., Ensured data integrity and performance through rigorous testing and optimization., Successfully migrated the SAMNA application to V8, ensuring compatibility and operational continuity. Data warehouse and SAMNA, Tata Consultancy Services, PepsiCo, 02/01/18, 11/30/20, MS SQL 2012, SSDT 2015, Developer/Support, This project focused on building and maintaining a centralized data warehouse for PepsiCo India to support advanced reporting and analytics. The warehouse housed transactional and promotional data collected from various systems, enabling multiple teams to derive insights. Daily ETL processes were implemented to transfer data from OLTP to OLAP systems, ensuring timely and accurate data availability for business needs., Designed and developed ETL pipelines using SSIS to transfer data from transactional systems to the data warehouse., Developed and optimized SSAS Tabular Models to enhance analytical capabilities and improve reporting efficiency., Developed SSRS reports to provide actionable insights into sales, promotions, and transactional data., Monitored ETL processes to ensure timely data availability and resolved pipeline failures to maintain SLA compliance., Provided support to end-users by troubleshooting and resolving issues related to data and reporting., Designed and implemented stored procedures for archiving activity, purging old data to a separate database, and freeing up space in the primary database, improving system performance. PepsiCo Managed Services, Tata Consultancy Services, PepsiCo (India), 07/01/16, 01/31/18, Visual Studio 2010, MS SQL 2012, BIDS, Developer, The SAMNA system served as the central backend solution for PepsiCo India, managing all master data, transaction data, and sales and promotion information. Data was ingested from multiple sources, including SAP, which provided primary sales invoices. The system acted as the backbone for PepsiCo India’s operations, with various in-house applications like Proline utilizing its data to design and implement nationwide promotions. SAMNA also supported other critical applications, ensuring seamless data flow for analytics, reporting, and operational needs., Designed and maintained SQL Server database objects such as stored procedures, views, and functions to support business-critical operations., Created and enhanced SSRS reports for accurate and actionable insights across sales, promotions, and transactional data., Provided 24x7 support for ETL failures, ensuring timely resolution and maintaining high data availability., Collaborated directly with distributors, customers, and internal teams to gather requirements and deliver tailored solutions., Designed and documented solutions based on direct client interactions to address business needs effectively., Delivered GST-compliant reporting solutions by modifying tax calculations and restructuring table designs., Optimized a critical C# application handling bulk uploads via Excel, significantly improving processing efficiency and reliability.