ANTON RAPHAEL

• Having 7+ years of IT experience & 5+ years of industry experience in the development and im-plementation of business requirements with SQL Server 2016/2014/2012/2008/2005.
• Experience in database programming and optimisation of ETL strategies using SSIS/SSRS. Ca-pable of developing/supporting Business/Web Applications using Visual Basic, Database de-signing using SQL Server 2000/2005/2008/2012.
• Experience in Extraction, Transformation and Loading (ETL) in SQL Server databases.
• Experience in supporting multiple production database servers.
• Experienced in designing relationship databases using entity relationship diagrams.
• Expert in creating complex stored procedures, and queries for the application team and for the end users based on business requirements.
• Expert in T-SQL PL/ SQL coding, testing functions, ad-hoc SQL queries, views, triggers, cur-sors, data types, indexes, and system tables.
• Worked with lots of data by creating spreadsheets in MS EXCEL.
• Excellent knowledge & experience in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined datatypes, effective functions, cursors and indexes using T-SQL.
• Experience in T-SQL, SSIS, SSRS, BI suite, Reporting and Analytics and knowledge in OLAP.
• Excellent experience in migrating DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2008, 2014, and SSIS packages.
• Experience in MS SQL Server Installation, Configuration, Performance Tuning, client/server connectivity, building servers, troubleshooting, clustering, query optimisation, backup/re-covery, running Database Consistency Checks using DBCC and troubleshooting on large da-tabases and maintaining, supporting, monitoring production and test environments.
• Having good communication and interpersonal skills, hardworking, dedicated at work and result oriented as an individual and in a team.

HTC GLOBAL SERVICES, Bangalore, Karnataka, Database Developer Lead - Stanford Graduate School of Business (GSB), 10/01/24, Present, Designed, developed, and maintained SQL Server databases and PL/SQL & T-SQL code (procedures, triggers, views) to support business-critical applications., Applied advanced database design principles, data modeling & normalization to build efficient and reliable data structures., Integrated data from multiple sources into SQL databases, ensuring consistency, accuracy, and integrity., Optimized complex SQL queries and improved database performance for faster data retrieval and processing., Documented database designs, configurations, and processes to ensure compliance and facilitate knowledge sharing., Collaborated directly with business stakeholders and end users across geographies to gather requirements and provide timely solutions., Managed source code and database changes using GitHub/Bitbucket for version control., Actively contributed across all stages of the SDLC-from requirements gathering to deployment., Worked closely with teams on Informatica ETL processes as an additional capability., Ensured clear communication, status reporting, and alignment with client expectations while maintaining a positive and professional approach. Alliance Bernstein, New York, New York, Software Specialist, 07/01/23, 12/31/23, As a key contributor to the COMPASS and CO-PILOT initiatives, our team is dedicated to developing powerful software systems that equip investors with the tools and insights needed to make strategic decisions., Leveraging data from diverse sources, we employ advanced data analysis techniques, proficient report generation, and seamless integration with other systems used by the investment bank and its esteemed clients., These projects act as transformative engines for one of the industry's leading investment banks., At Nuware Systems LLP, we work under the ALLIANCE BERNSTEIN TEAM, which has three divisions namely, Sales, Trading and research., AllianceBernstein (AB) is a leading global investment management firm that offers high-quality research and diversified investment services to institutional investors, individuals, and private wealth clients in major world markets., Under the Sales division, our core focus lies in Salesforce Customer Relationship Management (CRM), where we demonstrate our technical prowess., Within this domain, we handle two Salesforce CRM instances: COMPASS and CO-PILOT., Our responsibilities encompass intricate database design utilizing SQL, ensuring optimal performance, and delivering sophisticated report generation and management through industry-leading tools such as SSRS and PowerBI. HTC GLOBAL SERVICES, Bangalore, Karnataka, Database Developer, 08/01/20, 06/30/23, Understanding business requirements to set functional specifications for reporting applications., Gathers and prepares data from multiple sources to support information analytics., Handling SQL development, triggers, indexes, views & T-SQL., Work-related to Relational databases, and dimensional data modelling., Work-related to monitoring and performance tuning., To understand and work on the Agile process. First American India, Santa Ana, California, Database Developer, 11/01/19, 05/31/20, Involved in the development of the SSIS packages & writing stored procedures for enforcing the business rules., Worked with the developing team in upgrading several SSIS packages from the testing environment to the live environment., Involved in low-level design for new enhancements., Analyzing the requirement and freezing the best design to approach solutions., Performance improvement techniques., Handled status calls with the on-site team., Involved in troubleshooting existing code & issues., Developed backup and restore scripts for SQL Server., Installed and configured SQL Server 2005 with the latest service packs., Created database objects like tables, views, indexes, stored procedures, triggers, and user-defined functions., Written T-SQL queries for the retrieval of the data., Developed administrative tasks of SQL Server of performing daily Backup and Recovery procedures. Kern Family Health Care, Bakersfield, California, Database Developer, 01/01/19, 08/31/19, 90% development and 10% admin., Advanced T-SQL development, stored procedures, functions., Designing, creating, or modifying database tables, indexes, constraints, links, stored procedures, and functions., Establishing standards for data integrity in the KHS data warehouse through data reconciliation techniques, data analysis, or ETL design issues., SQL Server tuning and optimization., Microsoft SQL Server administration., T-SQL, stored procedure/function development, and SSIS. American Red Cross, Fairfax, Virginia, MSBI Developer [SSIS, SSRS], 03/01/18, 01/31/19, Database design and development on MS SQL 2008., Development using MS SQL Reporting Services, SSIS/DTS packages and SSAS Tabular/Cubes., Preparing system design documentation., Participating in project meetings and review sessions during various phases of the SDLC., Collaborating with other application and database engineers for design and development activities., Performing unit testing and collaborating with test engineers on their testing activities., Working closely with the business customer to ensure that the business requirements are met.

• +919025637358
• +1 2029301783