System Analyst at Hansa Customer Equity Pvt. Ltd.
Email: email@example.com ~ Phone: +91-994*******
B.Tech graduated with 2+ years of Experience in Data Warehousing, Data Integration, ETL and Data quality Management. Currently associated with Hansa Customer Equity Pvt. Ltd. as System Analyst and skilled in Amazon Redshift, MS-SQL server, SSIS, SSRS, TalendOpen, Tableau.
Microsoft Power BI
Data quality assurance processes
Possess over 2+ year of experience in MS-SQL Server and Amazon Redshift database development and Integration.
Strong knowledge in writing complex SQL queries, Stored Procedures, Functions.
Amazon Redshift Cluster space management and performance tracking.
Basic knowledge in Oracle database (11g).
Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008 R2/2010/2012.
Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on TalendOpen, Tableau and Microsoft BI.
Experience in maintenance and Administration of SSIS and TalendOpen by creating Jobs, Alerts and Mails, scheduled Packages using SQL Server Agent.
Worked on Complex data and analytical request.
Excellent in High Level Design of ETL & SSIS Packages for integrating data using OLE DB and ODBC connection from heterogeneous sources like (CSV, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports also Deployed.
Bachelors of degree in Electronics and Communication Engineering at Silicon Institute of Technology, Bhubaneswar.
System Analyst, 10/2015 to Current
Hansa Customer Equity Pvt. Ltd. - Bangalore
Worked for retail clients like Landmark Group, Raymond and Westside.
Used Amazon S3 to load data from different sources to Redshift DB.
Used columnar Encoding to reduce space of table, which leads us to solve the problem of Disk Full error.
Created Database users and assigned user privileges for Database Security.
Build ETLs for table size and performance tracking.
Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
Implemented End to End automation for data transformation using of SQL Server Integration Services (SSIS) and TalendOpen.
Worked on Data Extraction for Campaigns and Ad-hoc Requests.
Experience on writing Stored Procedures for Reports (SSRS 2008 R2).
Deployed and maintained live Tablue Dashboards.
Implemented SSIS and TalendOpen ETL tools to improve data transformation speed.
Participated in requirements meetings and data mapping sessions to understand business needs.
Conducted two knowledge sharing sessions per quarterly to capture “Lessons Learned” and streamline the product improvement process.
Published dashboards using Tablue.
Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
Worked on De-duplication and Reorganization of data to get high accuracy and generates Reconciliation Reports.
Modified and improved existing databases to reduce processing time.
Made recommendations on business intelligence tools to speed up data transformation.
Awarded with the Hawkeye for excellence in automating manual process using integrating tools.
I hereby declare that the above provided information is true to best of my knowledge and belief.
Place : Bangalore Vendu Shekhar