ANTON
Texas
Summary
Having 9+ years of IT experience and 5+ years of industry experience in the development and implementation of business requirements with SQL Server 2016/2014/2012/2008/2005. Experience in database programming and optimisation of ETL strategies using SSIS/SSRS. Capable of developing/supporting Business/Web Applications using Visual Basic, Database 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 the end users based on business requirements. Expert in T-SQL PL/ SQL coding, testing functions, ad-hoc SQL queries, views, triggers, cursors, data types, indexes, and system tables. Worked with lots of data by creating spreadsheets in MS EXCEL. Excellent knowledge & and 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, back- up/ recovery, running Database Consistency Checks using DBCC and troubleshooting on large databases 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. Systematic Database Developer with [Number] years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems. Efficient Database Developer with broad knowledge of high-availability SQL Server solutions. Adaptable professional with background in improving workflow processes, creating database objects and overseeing security tasks. Driven Database Developer with [Number] years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments. Efficient Database Developer with broad knowledge of high-availability SQL Server solutions. Adaptable professional with background in improving workflow processes, creating database objects and overseeing security tasks. Efficient Database Developer with broad knowledge of high-availability SQL Server solutions. Adaptable professional with background in improving workflow processes, creating database objects and overseeing security tasks.
Overview
8
8
years of professional experience
Work History
Software Specialist
Alliance Bernstein
7 2023 - Current
- 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
- ALLIANCE BERNSTEIN TEAM 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.
Database Developer SALESFORCE PROJECT
First American
08.2020 - 06.2023
- 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.
Database Developer
TESCO
11.2019 - 05.2020
- Tesco is a British multinational grocery and general merchandise retailer with headquarters in Welwyn Garden City, Hertfordshire, England, and the United Kingdom
- It is the third-largest retailer in the world measured by gross revenues and the ninth-largest retailer in the world measured by revenues
- It has shops in seven countries across Asia and Europe and it is the market leader in groceries in the UK, Slovakia, Hungary, Czechoslovakia, Poland, Malaysia and Thailand
- Project: Product Induction Product Induction is an ETL process responsible for uploading product information, range information, price information and promotion information into TESCO UK, ROI and wine grocery online websites
- The project is based on SSIS, .NET and SQL 2012
- Product Induction consumes the input data like product/price/promotions etc
- From various upstream like ODS & SH CR
- It persists in the integration database, refines it and exports it to Sonetto
- Sonetto is a third-party application used for enriching products with promotions
- Business users also use this application to manage their data
- Post the sonetto processing, the data is loaded into the product database.
Database developer
Kern Family Health Care
01.2019 - 08.2019
- Kern Family Health Care (KFHC) is the local health plan for Medi-Cal managed care in Kern County, Bakersfield, California
- This program pays for a variety of medical services for children and adults with limited income and resources
- KFHC provides health services to Medi-Cal beneficiaries in Kern County
- It is dedicated to improving the health status of our members through an integrated, managed healthcare delivery system
- PROJECT: 2D Database Profiling Management Program
MSBI developer [SSIS, SSRS]
American Red Cross
03.2018 - 01.2019
- American Red Cross is a humanitarian non-profit organization that provides emergency assistance, disaster relief, and disaster preparedness education in the United States
- It is the designated US affiliate of the International Federation of Red Cross and Red Crescent Societies and the United States moved to the national Red Cross and Red Crescent Movement
- PROJECT: Disaster Services Automated Reporting System (DSARS)
MSBI Developer
Clutchpoint LLC
07.2016 - 03.2018
- Excellent knowledge & experience in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User-defined data types, effective functions, cursors and indexes using T-SQL
- Demonstrable knowledgeable experience with Oracle SQL, and PL/SQL development
- Experience working in the deployment of cubes, OLAP & XMLA
- Developed tools using Python, shell scripting, and XML to automate tasks
- Well-experienced in data modelling & data migration from Oracle to SQL
- Create Tables, Indexes, Sequences, Constraints, Synonyms, and Partitions, Range and List partitions.
Education
Masters in Computer Information Systems -
University of Central Missouri
Missouri 01.2015 - 1 2016
Bachelor of Engineering - Electronics & Communication Engineering
Anna University
India 08.2009 - 1 2013
Skills
Windows Server 2003/2008/2008R2 and Windows XP/Vista/7
T-SQL
SQL Server Management Studio, ETL Tools, and OLAP
SQL SERVER 2005/2008 R2/2014/2012, MS-Access, MS EXCEL
Projects
Alliance Bernstein, New York, New York, 07/01/2023, Present, Software Specialist, AllianceBernstein(AB) is a distinguished multinational corporation headquartered in New York and New Jersey, having an impressive 28-year tenure in the industry. With a focus on the investment banking sector, it has established itself as a leader in delivering high-quality solutions. The offshore development team in Bengaluru, India has been operational since 2006, showcasing their expertise and commitment to excellence. The current endeavours encompass a range of cutting-edge projects, including CARRS (Commission & Revenue Reporting System), COMPASS (named after its 360-degree reference), and COPILOT., 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. ALLIANCE BERNSTEIN TEAM 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. First American, Santa Ana, California, 08/01/2020, 06/01/2023, Database Developer SALESFORCE PROJECT, First American is an American financial services company which provides title insurance & settlement services to the real estate & mortgage industries. The company issues title insurance for a transaction which happens while doing business with the company. The charge is applied to the title insurance based on the property value. The company uses Salesforce which deals with sales representatives for customer relationship maintenance. The broker contacts the sales representatives from the company to do business with the company. To handle all this data management of customer history, customer names, customer address details & all kinds of transactions, in the backend development, everything involved with managing the database will be the primary duty, whilst the dot-net and UI will be handled by a separate team., 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. TESCO, United Kingdom, United Kingdom, 11/01/2019, 05/01/2020, Database Developer, Tesco is a British multinational grocery and general merchandise retailer with headquarters in Welwyn Garden City, Hertfordshire, England, and the United Kingdom. It is the third-largest retailer in the world measured by gross revenues and the ninth-largest retailer in the world measured by revenues. It has shops in seven countries across Asia and Europe and it is the market leader in groceries in the UK, Slovakia, Hungary, Czechoslovakia, Poland, Malaysia and Thailand., Project: Product Induction. Product Induction is an ETL process responsible for uploading product information, range information, price information and promotion information into TESCO UK, ROI and wine grocery online websites. The project is based on SSIS, .NET and SQL 2012. Product Induction consumes the input data like product/price/promotions etc. from various upstream like ODS & SH CR. It persists in the integration database, refines it and exports it to Sonetto. Sonetto is a third-party application used for enriching products with promotions. Business users also use this application to manage their data. Post the sonetto processing, the data is loaded into the product database. Kern Family Health Care, Bakersfield, California, 01/01/2019, 08/01/2019, Database developer, Kern Family Health Care (KFHC) is the local health plan for Medi-Cal managed care in Kern County, Bakersfield, California. This program pays for a variety of medical services for children and adults with limited income and resources. KFHC provides health services to Medi-Cal beneficiaries in Kern County. It is dedicated to improving the health status of our members through an integrated, managed healthcare delivery system., PROJECT: 2D Database Profiling Management Program. RESPONSIBILITIES: 90% development and 10% admin. Advanced T-SQL development, stored procedures, and 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, 03/01/2018, 01/01/2019, MSBI developer [SSIS, SSRS], American Red Cross is a humanitarian non-profit organization that provides emergency assistance, disaster relief, and disaster preparedness education in the United States. It is the designated US affiliate of the International Federation of Red Cross and Red Crescent Societies and the United States moved to the national Red Cross and Red Crescent Movement., PROJECT: Disaster Services Automated Reporting System (DSARS). The Disaster Services Automated Reporting System (DSARS) is a Web-based tool that is used in all chapters, regions and disaster relief operations to report incidents, disaster operations, damage assessments, and disaster operations control form 5266 reports. It has a survey about all the disasters happening all around North America. As a back-end database developer, I develop, manage and control the database which stores all the requisite details about the disaster which we get as input from the user end. Clutchpoint LLC, Herndon, Virginia, 07/01/2016, 03/01/2018, MSBI Developer, Excellent knowledge & experience in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User-defined data types, effective functions, cursors and indexes using T-SQL. Demonstrable knowledgeable experience with Oracle SQL, and PL/SQL development. Experience working in the deployment of cubes, OLAP & XMLA. Developed tools using Python, shell scripting, and XML to automate tasks. Well-experienced in data modelling & data migration from Oracle to SQL. Create Tables, Indexes, Sequences, Constraints, Synonyms, and Partitions, Range and List partitions. Worked on SSIS package documentation, source, archive, and Stage path mapping. Develop the Exception handling process and audit process for each ETL package. Developing SQL code such as writing complex queries, user-defined functions etc. Monitor and SQL profiler and tune queries and procedures to boost database performance. Creating Packages in SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, and SCD to load data into the Database. Involved in creating proxy accounts and Scheduling Jobs to execute SSIS packages. Responsible for creating database objects like tables, Store Procedures, and Functions using T-SQL to provide structure to store data and to maintain the database efficiently. Created and managed Interactivity Financials SSRS reports, Parameterised, Linked, Drill-down, Drill through reports.
Timeline
Database Developer SALESFORCE PROJECT
First American
08.2020 - 06.2023
Database Developer
TESCO
11.2019 - 05.2020
Database developer
Kern Family Health Care
01.2019 - 08.2019
MSBI developer [SSIS, SSRS]
American Red Cross
03.2018 - 01.2019
MSBI Developer
Clutchpoint LLC
07.2016 - 03.2018
Masters in Computer Information Systems -
University of Central Missouri
01.2015 - 1 2016
Bachelor of Engineering - Electronics & Communication Engineering
Anna University
08.2009 - 1 2013
Software Specialist
Alliance Bernstein
7 2023 - Current
Similar Profiles
SHAILESH ZAGADESHAILESH ZAGADE
Associate Vice President/Senior Automation Engineer at ALLIANCE BERNSTEINAssociate Vice President/Senior Automation Engineer at ALLIANCE BERNSTEIN
IKSHVANKU J. AGRAWALIKSHVANKU J. AGRAWAL
Operations Associate at Alliance BernsteinOperations Associate at Alliance Bernstein
Vivek KapurVivek Kapur
IT Project Manager at Alliance BernsteinIT Project Manager at Alliance Bernstein
Mike BuenoMike Bueno
Sales Associate at Omni Beauty StoresSales Associate at Omni Beauty Stores
Ton OdenTon Oden
Administrative Assistant at BWI CompaniesAdministrative Assistant at BWI Companies