** * ****** ****** ***** vihar
Gurgaon - 122001
DATA ENGINEER-SENIOR BI/MSBI/AMAZON REDSHIFT/ AMAZON S3/AWS GLUE DEVELOPER
"Diligent professional with 6 + year of experience and proven knowledge of database development, database design, ETL solution, and programming.Skilled in Amazon redshift, Amazon S3, AWS Glue, CloudFormation, MSBI, SQL Server Reporting Services
(SSRS), SSRS, SQL, and SQL Server Integration Services (SSIS), Data Modeling, Data Extraction Transformation, and Load, OLAP and OLTP DB systems, python and Pyspark”
electronics and communication, Bachelor of Engineering / Bachelor of Technology, Graduated, August 2012 Faculty of science and Technology
ICFAI University – Marks 7.6 [CGPA]
June 2018 - Current
SENIOR BI DEVELOPER
Worked as senior BI Developer, Individual contributor role to Provide ETL, database and DWH solution for different business pain- points. Our stakeholder included Marketing, sales, and client services. Experience in various ETL tools/technologies (SSIS, aws Glue). Architecting data warehousing and relational databases. Designed aws ecosystem for redshift data warehousing. Provisioning, configuring and managing on-prem and cloud infrastructure in AWS. Relational databases - SQL Server 2008R2/2012/2016, PostgreSQL, Redshift. Worked Aws cloud data warehouse Redshift 1.0
Created IAM Roles for different aws services.
Understanding and implementation of aws VPC, security group and WLM in redshift cluster. Created, configured and managed redshift cluster using aws service catalog and aws console. Managing various aws services using aws console and SDKs. Designing and implementation of the hybrid architecture of on-prem and aws databases(redshift). Aggressive problem diagnosis and creative problem-solving skills Template design in SSIS for the organization to follow standards. Experience in Design, Development, debugging, Implementation of ETL using SSIS (SQL Server Integration Services, aws glue).
Various reporting tools such as SSRS and aws quicksight used Amazon S3 for cloud storage.
Experience in writing T-SQL queries Stored Procedures, Functions, Triggers, SQL Query, Indexes. Experience on T-SQL Performance Optimization
Creation, execution, and monitoring of SQL Jobs, $U Jobs Various development/collaboration tools such as Jira, version one. Getting data from different digital platforms like Facebook, AdWords, LinkedIn, Bing, twitter and integrated data points for analysis.
Getting data from different web API using C#, Python and used them for data integration and analysis. Worked closely with data science, insight and reporting team. Coding, Unit testing, SIT, and UAT support
January 2016 - June 2018
The Project is easyJet BI project, top airlines company in Europe. Dealing with data analysis and reporting of customer payments, finance, Data warehouse.EasyJet sends the details of bookings done through Credit Cards to Payment Service Providers (PSPs) for its validation and settlement, which then PSP send to their respective Acquirer’s/ Merchant’s bank for settlement. We worked around this data for financial reporting and reconciliation of payments and settlements. Cubes and reports were ending platform for business users.
Designing and development of ETL system, data modeling and data integration using SSIS. Analyzing BRD and creating design TAD and TDS, development, and release as per the requirements Creation of quality document –RTM, review records, maintaining Jira, UTC, assumption, and queries. Direct interaction with the client for the requirement. Writing Stored Procedure, inline queries, function using SQL Server 2008, 2012,2016 Creating packages (SSIS) Using Business Intelligence 2008,2012,2016 Creating Reports (SSRS) Using Business Intelligence 2008 Encryption, decryption of files across the system. SQL Query performance optimization.
Creation, execution, and monitoring of SQL Jobs, $U Jobs Various development/collaboration tools such as Jira, version one. Production fixes.
Coding, Unit testing, SIT, and UAT support
Architecture and flow diagram Design on draw.io and Visio. Worked on various POC on AWS Cloud Data warehouse redshift. Writing script task and script component using C# to extract data from APIs and 3rd part sources. Implementation of 2nd type SCD in DWH.
Worked on both OLAP and OLTP Databases.
Involved in build implementation, technical support & Production Support for project release. Log work and project management using Jira.
Created HR data for workday from raw information to support workday configurations using macros and excel. Proving status updates to team, project managers and stakeholders. Managing and helping new team members for KT.
Worked on confluence and wiki form technical documentation. Maintaining Component tracker for further release documents Unit test planning/designing & Unit Test result reporting June 2013 - December 2015
Worked on project ATLAS. Atlas works between CGX/UI and EDW Datawarehouse. Atlas’s main task is to identify the correct member based on the configuration which is available in Atlas and send that identified member information to Rules. Rules process that member and send the response back to Atlas. These responses are in the form of Referral, Note, Task, Alert, and Messages. Once Atlas receives the response it stores these responses and routes that to the downstream application like CGX, PGX, Avality, and Humana.Com. Atlas mainly involves automating the manual process which is available in Humana and accommodates new process start by Humana to process the members
Responsible for creating design and requirement analysis. Writing Stored Procedure using SQL, Function, Triggers, Indexes, SQL Job Creation Creating packages (SSIS) Using Business Intelligence 200*-****-**** Creating packages (SSRS) Using Business Intelligence 200*-****-**** Database design, data Modeling, and data integrations. C# Code for different Layer of Application, WCF and rest services. Coding, Unit testing, SIT, and UAT support
Analyzing and designing Database as per the requirements Involved in build implementation, technical support & Production Support for project release Maintaining Component tracker for further release documents Unit test planning/designing & Unit Test result reporting COMPUTER PROFICIENCY
Software/ Tools: SQL Server, PGAdmin, SSIS, Informatica, SSRS, MSBI suit, Visual studio, PyCharm, notebook, workbench, Redgate, Visio, draw.io, MS Team Foundation Server 2008, 2010,2012, MS Office 2013 (Word, PowerPoint& Excel), Univiewer Console, Jira, confluence, version one.
Reporting and visualization: SSRS awareness of quick view and Gainsight CRM: Salesforce
Programming Languages: C#, Python.
Databases: MS SQL, PostgreSQL, Redshift.
Aws Cloud services: Redshift clusters, amazon S3, aws glue, IAM Role, VPC, EC2, CloudWatch, CloudFormation, aws service catalog, SNS.
Birthday: September 13, 1990
Marital Status: Single
I, Suraj Kumar, hereby declare that the information contained herein is true and correct to the best of my knowledge and belief. Suraj Kumar Gurgaon, Haryana