Biplab Adhikary
Data Analyst @Central Bank
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Central Bank
Jefferson City, MO, US
Performed data cleaning and designed layouts and specifications for user-facing reports, providing a comprehensive Metadata Management solution from start to finish.• Driving insights and data-driven decisions that increased revenue by 15%.• Utilized advanced SQL and Power BI expertise to transform complex data into engaging visual stories, fostering data-driven decisions and amplifying project outcomes.• Oversaw Key Performance Indicators (KPIs), enhancing event KPI management through parameter optimization and report generation.• Ensured PCI-DSS compliance through meticulous data analysis, enhancing cardholder data security.• Led the development of a high-volume data warehousing project, improving data processing speed by 50% through optimization of PL/SQL procedures and functions.• Managed the SWIFT messaging service to facilitate financial communications, including letters of credit, payments, and securities transactions among global member banks.• Created Azure SQL Database, performed monitoring and restoring of Azure SQL Database. Performed migration of Microsoft SQL Server to Azure SQL database.• Transformed reporting procedures through the adoption of automated reporting systems, cutting down manual efforts by 40% while greatly enhancing the accuracy and promptness of reports. Created tailored dashboards and reports to offer leadership immediate access to critical financial data.• Utilized sophisticated Excel features such as VLOOKUP, Pivot Tables, graphs, and both analytical and statistical toolkits.• Specialized in ingesting data into cloud platforms such as AWS and Snowflake, and utilizing Denodo for data virtualization. • Collaborated with the Cash Management Division and Compliance Office to assess Anti Money Laundering (AML) regulations and implemented Positive Pay services to mitigate check fraud risks.• Conducted comprehensive performance tuning, leading to a 20% improvement in overall database performance and user satisfaction.
EDUCATION
The City University of New York
Bachelor of Technology - BTech
ABOUT BIPLAB ADHIKARY
As a Data Analyst and Engineer, I am a US citizen eligible for projects requiring security clearance, where US citizenship is a prerequisite. With over 8 years of IT expertise and diverse industry experience, I delivered exceptional data analysis and database development solutions across multiple sectors including Pharmaceuticals, Defense and Space Manufacturing, Federal and State Government, Public Sector, Aviation, Airlines, Technology, Transportation, Logistics, Healthcare, Business Intelligence BI, Finance and Banking, Higher Education, Entertainment, E-commerce, Retail, Hospitality, Computer Games, Marketing, United States Department of Defense DoD, Manufacturing, Digital Marketing, Supply Chain, Energy, Utilities, Telecommunications, and more.I have experience with data warehouses, including Amazon AWS Redshift, Google BigQuery, Microsoft Azure Synapse Analytics, Snowflake, nCINO, Oracle Cloud Infrastructure Data Warehouse, SAP Data Warehouse Cloud, IBM Db2 Warehouse on Cloud, Teradata Vantage Cloud, Cloudera Data Warehouse, Alibaba Cloud MaxCompute, and Exasol. Additionally, I am experienced in RDBMS technologies such as Oracle Database, Microsoft SQL Server, IBM Db2, MySQL, PostgreSQL, SAP HANA, Amazon Aurora, Azure SQL Database, and Google Cloud SQL.I am proficient in SQL, Excel, Tableau, Power BI, Oracle Database Engineering, Agile methodologies, SDLC, PL/SQL, and other tools and techniques. My career has spanned work with data warehouses including Amazon AWS Redshift, Google BigQuery, and others, and RDBMS technologies like Oracle Database, Microsoft SQL Server, and more. My hands-on experience also extends to managing the SWIFT messaging service for global financial communications.I hold a Bachelor of Technology in Computer Systems Technology from The City University of New York, alongside multiple certifications such as Oracle Database SQL Certified Expert and Telling Stories with Data. Dedicated to contributing through W-2 employment, either as a contractor or in a full-time role, I am passionate about building collaborative success and ensuring mutual commitment in all my professional engagements. I am also open to relocation anywhere in the USA to meet the needs of dynamic and innovative teams.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.