Shridhar Balan

About Shridhar Balan

Senior Data Architect & BI/DW Analyst/Developer (not withstanding other titles) with a stellar history of building top class diverse business solutions. Snowflake Certified Advanced Architect. My love and passion for database technologies (SnowSQL, T-SQL especially) offsets any other career choice, and keeps me both excited and grounded. My forte is understanding business, outlining strategic vision with roadmap, and judicious use of DW principles and technology in providing effective solutions, including analysis, design, development, implementation, optimization and support. Extensive and comprehensive experience in full life cycle of systems in North America and India. Thought leadership with published technical articles (see PUBLICATIONS). SKILLS/ SPECIALTIES• Applications: Commercial Real Estate, Residential Sub-Prime Mortgage, Personal Lending, Health Care, Banking, Foreign Exchange Operations, Public Transportation, Accounting. • Platforms: Snowflake (Enterprise), StreamSets (Control Hub), Salesforce, Microsoft Technologies (SQL2016, SSAS, SSIS, Excel, TFS, Power BI), Postgres, Oracle, Sybase, Windows, AS400, UNIX, Business Objects, PowerBuilder, Informatica, Ingres, Watcom, Cobol. Strong T-SQL Skills.• Third Party Systems: Commercial Loan Servicing (Strategy, Enterprise); Commercial Loan Accounting (CTI, Yardi); Financials (XleratorDB).• “Can-Do” attitude with terrific communication and interpersonal skills. Proven team player. Adept in both IT space and business space. Ability to take complex problems, distill them and create optimized business solutions. Operate at different levels (high level to trenches) per team needs.PUBLICATIONS (Microsoft SQL Server Professional, Pinnacle Publications)- please see attached PDFs below as no URL links are available• Time-Series Snapshots • Complex Multiple Choice Tests • Identifying “Holes”• Finding Continuous Regions in a Data Set • Tip: Test Question• Do You Know Where Your Quartiles Are? • Bitmapping and Error Handling

Experience

1. Vice President (Data Architect - Snowflake)

   Northern Trust

   May 2022 — Present

Education

• National Institute of Technology, Tiruchirappalli

  Bachelor of Science - BS, Electrical and Electronics Engineering