Sql Server Business Intelligence

CINI THOMAS

E-Mail : ad5c02@r.postjobfree.com

Mobile : +1-763-***-****/+1-763-***-****

Maple Valley, WA

Experience Summary

** ***** ** ********** ** database designing, development, administration, performance tuning, business intelligence, reporting and testing using MS SQL Server, Oracle, Teradata, Sybase, DB2, Snowflake, MySQL and PostgreSQL.

MS SQL Server (Versions: 2000, 2005, 2008, 2012, 2014, 2017, 2019)

Expertise in Stored procedures, Functions, Triggers, Indexes, User-defined functions, Common Table Expressions (CTE) and Views.

Expertise in SQL Profiler, Performance Monitor, Performance Tuning, Query Optimization, Dynamic Management Views (DMV), Tuning advisor and Database Consistency Checks.

Expertise in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting.

Experience in Clustering, Always-On, Replication, Log Shipping and Database Mirroring.

Experience in database creation, backups/recovery, user/schema creation, SQL Server agent jobs and space management.

Experience in DTS and SQL Server Integration Services (SSIS) / ETL technologies.

Knowledge in building data cubes by implementing SQL Server OLAP services in SSAS, Microsoft Power BI.

Knowledge in SSAS tabular model with partitions, created measures using DAX functions, MDX.

Good understanding of data warehousing, dimensional data modeling and schemas such as star, snowflake schema.

Good knowledge of entity relationship diagram (ERD) and data modelling.

Knowledge on all types of report types like tables, matrix, charts, sub reports, Dashboards, Linked Reports, Drilldown, Drill through, Matrix Parameterized reports etc.

Expertise in Microsoft Azure SQL PaaS, Azure SQL (IAAS), Azure data factory.

Expertise in Kusto queries.

Teradata

Experience in database designing, creating views and writing SQL queries.

Experience in creating reports using advanced techniques like rank, row number.

Oracle

Experience in PL-SQL creating stored procedures, functions and packages.

Ab initio

Experience in ETL tool for developing graphs.

Delphi

Experience in Business Application Development involving Design, Development and Testing of large commercial applications.

Others

Expertise in Snowflake.

Expertise in PostgreSQL, Cosmos and MySQL databases

Expertise in collaborating with teams to test and deploy modules to production.

Expertise in creating user stories, tasks and bug tickets.

Expertise in documenting business, technical and functional analysis and database best practices.

Exposure in working closely with the design team in creating mockups, wireframes and workflows.

Expertise in report generation using Crystal Reports and Fast Reports.

Experience in version controlling tools like TFS, VSS and GIT.

Experience with Service-Oriented Architecture, SDLC, Agile Development practices, sprint planning and daily scrum meetings.

Strong expertise in Object Oriented Programming (OOPS) concepts like Encapsulation, Inheritance, Polymorphism and Data Abstraction.

Experience in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Good leadership qualities and experience in mentoring junior database developers on complex SQL related development and troubleshooting tasks.

Excellent analytical, interpersonal and communication skills.

Expertise in planning, prioritizing tasks based on business requirements.

Self-learner and pursues training and development opportunities, shares knowledge with others.

Expertise in PowerShell.

Educational Qualification

Master’s degree in computer applications, Bharathiyar University, India

Bachelor of Science in Physics, MG University, India

Certifications

MCTS - Microsoft Certified Technology Specialist 70-433

1Z0-1072-22 - Oracle Cloud Infrastructure 2022 Architect Associate

Technical Skills

Databases : MS SQL Server (2000, 2005, 2008, 2012, 2014,2019), Oracle, Teradata, Sybase, DB2, PostgreSQL, MS Access, Cosmos, Snowflake, MySQL.

Programming Languages : Ab Initio, DELPHI, ASP.NET, C#, HTML, REST.

Reporting Tools : Crystal Reports, Fast Reports.

Version Management : Visual Source Safe, TFS

Operating Systems : Windows XP/2K, Windows 7, Windows 8, Windows 10, UNIX, MVS.

Professional Experience

August 2022- Till Date : Solution Engineer Level 3(DBA/DBE)

Zones, LLC, USA.

April 2021-Aug 2022 : Database Administrator/Database Developer.

EagleView, USA.

July 2020 – April 2021 : Senior Engineer

Mindtree, USA.

Oct 2010 – Jul 2015 : Application Developer

IBM India Pvt. Ltd, India.

May 2007 – Sep 2010 : Software Developer

Gemini Software Solutions Pvt. Ltd, India.

Oct 2005 – Apr 2007 : Software Developer.

M/s Geojit Info Fin Technologies, India.

Experience Details

1. Zones, LLC August 2022– Till Date

Project : Multiple Database Projects

Role : Database Administrator/Database Developer/Database SME

Zones is a global provider of comprehensive IT services and solutions, reaching 100-plus countries and employing 2,000-plus people worldwide.

Roles & Responsibilities:

Manage database instances in Azure/AWS.

Designed and developed ETL processes using SSIS packages as per business requirements.

Managed OLTP/OLAP (data warehouses) systems.

Trouble shooting and fine-tuning of databases for its performance.

Developing TSQL Scripts (Functions, Stored Procedures, Triggers and Views)

Installing, configuring, managing, upgrading, migrating, monitoring, and troubleshooting SQL server.

Configure and manage high availability and disaster recovery options.

Configure Availability Groups (AG), Transactional Replication and Fail over cluster.

Supported database creation, backups/restore/recovery, user/schema creation, SQL Server agent jobs and space management.

Migrated SSIS Packages to new AD service. Created / modified SSIS packages as per business requirements.

Created/modified existing SSRS reports. Also migrated SSIS reports to new AD server.

Created Power BI reports using PostgreSQL/Smartsheet.

Optimized the Aurora PostgreSQL usage and helped reduce costs.

2. EagleView April 2021– August 2022

Project : All EagleView Projects

Role : Database Administrator/Database Developer

EagleView is a technology provider of aerial imagery, data analytics and geographic information system solutions.

Roles & Responsibilities:

Manage database instances in AWS.

Installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server.

Configure and manage availability groups.

Support database creation, backups/recovery, user/schema creation, SQL Server agent jobs and space management.

Add/modify existing SSIS packages in SQL Server Integration Services (SSIS) / ETL which load data from production database (SQL Server/PostgreSQL) to data warehouse.

Create/Modify and fix the databases jobs.

Create or modify existing SSRS reports.

Encrypt the databases and install certificates in all servers.

Create a minimal data scrub database for application team and Support application team for monthly release.

Work on help desk ticket which created by any team for database support (Database Access to database unavailability)

Create Power BI reports using Snowflake/SQL Server.

3. Mindtree, USA. Jul 2020 – April 2021

Project : Azure SQL DB, Microsoft

Role : Senior Engineer

Working as Azure SQL technical engineer/administrator for Microsoft Azure platform.

Roles & Responsibilities:

Support Microsoft Azure customers to resolve critical and complex technical issues on Azure SQL database by doing analysis / research / troubleshooting.

Analyze data using Kusto queries.

Do root cause analysis for issues and communicate back to customers by collecting relevant facts and investigating the problem.

Empower customers to find information and trouble shoot issues at their end.

Document technical aspects and research to help trouble shoot issues faster and educate team.

Collaborate with other teams while performing as a primary technical resource for support and complaint investigation activities.

4. IBM India Pvt. Ltd, Bangalore, India. Oct 2010 – Jul 2015

Project : BAS, Ericsson, Sweden.

Role : SQL Server DBA.

BAS is an Ericsson database supporting team, which supports around 25 applications and most of them are mission critical. Most of the applications have high availability options like clustering, replication and log shipping. As the DBA team is scattered across various locations (Philippines, Hyderabad and Bangalore) we interact with other teams on a daily basis for closing tickets and for resolving issues. Also, the job involves 24/7 on call support.

Roles & Responsibilities:

Installing, configuring, upgrading and managing of SQL Server.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Trouble shooting and fine-tuning of databases for its performance.

Verified query plans and gave suggestions for performance improvement.

Optimized code and improved efficiency in databases including index creation, re-indexing, updating statistics using SQL Profiler. Re-compiling stored Procedures and adding scheduled jobs to re-index and update statistics in databases.

Deployed new code base release to UAT, DEV and Production Environments.

Optimized and Automated SQL Server Administration (Configuring SQL Mail, Optimizing SQL Server Agent, Managing Operators, managing all maintenance Jobs and Deploying DTS Packages and administration).

Automated Administrative Tasks (Command-Line Utilities and working with DBCC commands)

Clustering, Replication, Log Shipping and Database Mirroring.

Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and Index Tuning Wizards.

Resolved locking and blocking issues.

Automation of administrative tasks like creating jobs, schedules, alerts using SQL and event notifications using Database Mail

Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility.

Created ETL Process Consisting of SSIS Packages, Stored procedures and SQL Agent jobs.

Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.

Spreading huge tables to different file groups to achieve maximum performance.

Query tuning based on High CPU, Memory and Logical reads and writes.

Supporting Huge Databases, Troubleshooting the problems.

Tools/Technologies: SQL SERVER (2005, 2008, 2008 R2, 2012)

Project : VERDI, Ericsson, Sweden.

Role : SQL Server Developer.

Verdi is the Ericsson proposal which supports the Sales and Marketing process and provides input to the Supply process. The purpose of Verdi is to optimize the Sales and Marketing and the supply processes by enabling access to correct information (product data, configuration support and prices) in a user-friendly way. Also speed up and facilitate the proposal process by storing information for a specific proposal in a common database.

Roles & Responsibilities:

Database designing, creation of numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).

Creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers (DDL & DML) to facilitate efficient data manipulation and data consistency.

Created PowerShell scripts for automation tasks.

Query analysis, tuning, performance monitoring/troubleshooting using SQL Profiler and DMV's, execution plans review, index coverage and SQL server statistics analysis.

Working knowledge of XML parsing and interfacing with T-SQL.

Used TFS (Team Foundation Server) for source code maintenance.

Done manual testing, Unit testing, Integration testing and System testing.

Played the role of a mentor in SQL Server to my teammates.

Helped in recruiting SQL resources for the project and given KT and guidance in SQL functionalities.

Worked in Sybase for populating data to Verdi from another application.

Taken part in the go live activities and involved in document preparation.

Created System Design Specification document (SDS) for ECP-Verdi integration project.

Tools/Technologies: SQL SERVER 2008 R2, Windows XP

Project : VSIGHT, Vodafone, UK.

Role : Application Developer (Teradata/Ab Initio).

VSIGHT is a new strategic BI application for Vodafone. The project will replace existing multiple, distributed, inconsistent information layers and large numbers of organically grown, individually focused reports with a common, clearly documented presentation layer providing a single trusted view of the truth, together with a set of rationalised reports that will enable information consumers to self-serve the key business intelligence that they need with less reliance on the BI team to provide them with information.

Analysts and report developers will benefit from easier, quicker access to well understood, simply structured information, allowing them to better focus on developing sophisticated analytics and reporting with less need to drop down to the core EDW Data Layer.

Roles & Responsibilities:

Database designing, creating views and writing SQL queries in Teradata.

Created graphs in Ab Initio.

Created complex queries using Inner Join, Outer join in Teradata.

Developed reports using Teradata advanced techniques like rank, row number.

Created test cases and did Unit testing, Integration testing and System testing for modules coded.

Provided technical support to team members and conducted knowledge sessions on project requirements, design and SQL coding standards to the team.

Create low level design document for the project.

Tools/Technologies: Ab Initio, Teradata, UNIX

Project : CUSTOMER PORTFOLIO OPTIMIZATION, Best Buy, USA.

Role : DB2 Developer.

The purpose of this application suite is to efficiently invest the marketing capital of the retailer into the intersection of customer groups and media types. This application uses mathematical techniques to provide the Chief Marketing Officer a way to articulate and align the marketing strategies of the firm into budget decisions on which customers to invest in, which media to buy, and what the revenue consequences are of taking those decisions.

Roles & Responsibilities:

Created 36 complex DB2 SQL Queries for the creation of Feature vectors in DB2. (Feature Vectors (FV) are composite metrics that are derived from data warehouse fields using ETL codes that have been developed based on client business requirement logics. Feature Vectors can be used as tracking metrics at individual customer level to trend behavior. The main use of Feature Vectors is to develop multidimensional customer clusters and profiles for campaign targeting and promoting input optimization.)

Migrated the ETL codes to two different technologies of Blue stack which are SPSS and SQL-DB2. (The original ETL codes were developed in Speakeasy.)

Converted ETL codes to DB2 and tested the Output with Speak Easy and SPSS outputs.

Created technical document for CPO project.

Used rational Portfolio for managing files in this project.

Tools/Technologies: DB2, Windows XP

5. Gemini Software Solutions Pvt. Ltd, Kerala, India. May 2007 – Sep 2010

Project : AGENCYNOW, S5 UK.

Role : Application Developer (Delphi/SQL Server)/SQL Server DBA.

AgencyNow is a powerful application to manage ship call information like call details, arrival information, sailing information, register and track services / tasks, cargo details, crew movement and cash to master details. Additionally, the system facilitates generation of various port documents and forms / receipts / reports. The system also provides various alerts / reminders that help the agents to be alerted / reminded of services / tasks to be performed.

AgencyNow is a boon for every shipping agency. It is in one sentence, a centralized repository of shipping information. AgencyNow stores all operations & D/A information related to and required by a shipping agency. AgencyNow brings order and efficiency to the Creation, Communication, Reporting, and Storage of this data.

Roles & Responsibilities:

Application development and coding in Delphi 5 and SQL server.

Optimized the performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary with Profiler and Execution Plans.

Developed complex stored procedures, queries, triggers, tables, user functions and views.

Involved in Installing, configuring, upgrading and managing SQL Server.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Created reports using Fast Reports.

Created a complex dynamic SQL query for Key performance indicator reports which are used for validating their performance and getting bonuses.

Created DTS packages.

Prepared Test Cases & doing unit testing.

Involved in live activities.

Tools/Technologies: DELPHI 5, SQL server 2000, Windows XP

Project : AGENCYWORLD, S5 UK.

Role : Application Developer (Delphi/SQL Server) /SQL Server DBA

Agency World is a web-based application that will provide accurate call related information to Principals, Agents, Chatterers, and Owners around the world. Agency World is an extension of AgencyNow on the web. The data displayed in Agency World is the one captured in AgencyNow. You can also add additional information using Agency World.

Agency World is used to view standard call related information like time sheet, jobs, services, disbursement account details, estimated costs, crew and cargo Details, letter of protest etc. Additionally, the application also facilitates vessel principals, agents and owners to add services, view the estimated cost, advance collected and the actual amount for each job.

Roles & Responsibilities:

Application development and coding using ASP .net and SQL Server.

Database designing, writing stored procedures, triggers, views and functions.

Created reports using Crystal Reports.

Prepared Test Cases & doing unit testing.

Being a part of deployment of different servers.

Tools/Technologies: ASP.net, SQL server 2000, Windows XP

6. Geojit Finance Ltd, Kerala, India. Oct 2005 – Apr 2007

Project : GFSL, GIT Back Office, GEOJIT, India.

Role : Application Developer (Delphi/SQL Server)

This application is working on a client server model. This system mainly handles accounts, trading, depository, clearing etc. This software is made for the Head Office for the effective management and smooth handling of the functioning of each of the departments of Geojit Financial Services Ltd, Geojit Commodities Ltd and Geojit Credits Ltd.

Roles & Responsibilities:

Application development and coding.

Created indexes, constraints and rules on database objects to improve the database performance to get the best out of it.

Writing stored procedures, triggers, views and functions.

Created reports using Fast Reports.

Prepared Test Cases & doing unit testing.

Tools/Technologies: DELPHI 5, SQL server 2000, Windows XP

Project : CENTRALIZATION OF GEOJIT BACK OFFICE, GEOJIT, India.

Role : Application Developer (Delphi/SQL Server)

Involved in upgrading of old client/server version to multi-tier technology. Less time consumption, fast and easy access of data are the main advantages of the new version. Centralization of the Branch Back Office System is done in the three-tire technology using the DLL, application server etc.

It is working at more than 400 branches throughout India and can handle the entire load at the market time. It will give maximum performance even if more than 1000 users access a single module at the same time. Data security and the module rights handling as per the users is one of the advantages of this new system.

Roles & Responsibilities:

Application development and coding.

Used SQL Indexes for improving query performance, lower storage and maintenance cost.

Writing stored procedures, triggers, views and functions.

Created reports using Fast Reports.

Prepared Test Cases & doing unit testing.

Tools/Technologies: DELPHI 5, SQL server 2000, Windows XP

Project : PAYROLL SYSTEM, GEOJIT, India.

Role : Application Developer (Delphi/SQL Server)

Payroll application helps the user to keep track of Employee information and salary generation. The system has functionalities like registration of employee, leave calculation, leave return settlement, Transaction deduction/Payments, Final settlement/End of Service, Pay slip generation, Month End processing and generation of many other reports.

This application uses a large number of back-end procedures/functions that improves performance and aids reuse of functionalities between modules. The system generates extensive management reports and government reports using a third-party programmable reporting tool (Fast Report). These reports are also exported to MSWord and EXCEL using OLE Automation.

Roles & Responsibilities:

Maintenance/Enhancements of the Payroll application for the new Client.

Developed new modules as per client request.

Prepared Test Cases & doing unit testing.

Developed new stored procedures, functions, views, triggers & Reports (Fast Report tool)

Tools/Technologies: DELPHI 5, SQL server 2000, Windows XP

Contact this candidate