Data Engineer BI ETL

SUMMARY

Experienced Database Engineer in the market for a challenging role to design, develop and administer using MSSQL products (SSIS, SSRS, SSAS), Data modeling and Bigdata (Hadoop, PIG, HIVE).

HIGHLIGHTS

Having 8+ years of IT experience in design, modeling, development, implementation of SQL Server 2008/2008R2/2012, Oracle.

Skilled in the use of SSMS, SSIS, SSRS, SSAS, Tableau and object-oriented programming.

Experienced in database administration.

Good knowledge in data modeling using ER Studio.

Good knowledge in programming languages like C#, Java

Good knowledge in Oracle PLSQL programming.

Well-versed with SQL, PL/SQL, Power BI, Exposure to Azure cloud platform

Having good expertise in scripting (Python, PowerShell, Batch, Perl).

Good knowledge in Azure and SAAS cloud environments.

Having good domain knowledge in Banking, HealthCare & Finance.

Good knowledge in Bigdata (Hadoop, PIG, HIVE, Sqoop, HBase)

Good knowledge in ITIL concepts.

WORK EXPERIENCE

Current Project Details: Item Bill of Material & Avengers APT

Client: INTEL :-(31/05/2019- To Current)

Role: Data Modeler

Solution Environment: HANA, SPEED Systems, Oracle, Teradata,BRM,BRE, MSSQL, SSAS, SSIS, Power BI, ETL, ER Studio

Team Size: 8

Item BOM is a master subject area in supply chain management system and it is an essential business area in INTEL where each product will be categorized efficiently. BOM involves various categories of items such as finished goods, supplier items, etc..

Application Development Team Lead 31/5/2018 – To Current

Accenture Hyderabad, Telangana

Gather business requirements and analyze them in to business entities by following hierarchy of conceptual to logical and then transform them to physical.

Create logical model diagrams using ER Studio.

Generate physical data models.

Reverse engineering of data models.

Design and build enterprise data warehouse models.

Maintain golden records and perform data quality checks using MDM.

Solution analysis of existing models and re-designs them to provide data integrity and consistency.

Collect and store data from heterogeneous data sources and build data marts on ad-hoc basis.

ETL transformations – data cleansing and mapping

Batch processing and script automation to simplify the existing processes.

Develop ETL packages using SSIS and then load the data to fact tables by creating SSAS cubes.

Handling bridge calls & retrospective meeting to meet client deadlines.

Technical Analyst 26/4/2018 – 30/03/2019

Seneca Global Technologies Hyderabad, Telangana

Collaborated with the Internal/Client BA’s in understanding the requirement and architect a data flow system.

Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP

Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Schedules Process.

Developed OLAP cubes by using SQL Server Analysis Services and defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, perspectives, roles.

Data modeling using Star & Snowflake models.

Incremental data load and cube processing.

Written complex stored procedures and T-SQL scripts.

Worked on tuning the queries and fixing the stored procedure to the data consistency.

Implemented error handling and automated notifications for mission critical packages in SSIS.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Worked on creating may ad-hoc and scheduled reports using SSRS.

Designed and Implemented ETL job restart ability using checkpoints and optimal package design techniques in SSIS.

SSIS package creation and data cleaning for import and export activities.

Create PowerShell scripts to automate manual data processing systems.

SSIS, SSRS, SSAS package design and development based on ad-hoc requests.

Senior Analyst 26/3/2014 – 07/01/2018

United Health Group Hyderabad, Telangana

Worked on agile methodology (Scrum and Kanban).

SSIS package creation and data cleaning for import and export activities.

Design and development of SQL code for new projects/ requirements.

Data modeling and design to perform extract, transform, load operations.

Performed database consistency check and administrative tasks.

Scheduled SSIS packages using various tools such as Task Scheduler, TWS, and Batches.

Enterprise data warehouse modeling design and implementation using SSAS.

SSAS Cube design and development.

Data visualization using the tools Tableau, Power BI.

Story cards, KPI’s, dashboard creation using various reporting and data visualization tools.

Data governance and analysis to meet customer requirements.

Data backup and recovery.

Deployment of SSIS packages on cloud and migrating them to various environments.

Designing and creating Cubes and process them.

Data cleaning and integrity checks while performing ETL operations.

SSRS report generation based on Business user’s requirement.

Data analysis and predictive forecasting by using historical data.

Design, Develop and deployment of SSRS reports.

Scheduling and subscription handling of SSRS reports, user access, role-based security setup for variety of Business users.

Data modeling and designing using various data models such as Star, snowflake, data vault, relational (RDBMS).

Creating logical data modeling and implementing them to convert into physical model.

Dimension creation, cube designing and cube population.

Cube Analysis and deployment.

Design complex data models to handle Big data.

Data Import and export to the archive locations per ad-hoc basis.

Monitoring of database health check including storage, logs, events, trace.

Database process documentation, standards, procedures, definitions for the dictionary (metadata) driven environment.

Access management such as roles, privileges, security.

Develop, manage and test the backup and recovery plans.

Collaboration with IT managers, developers to identify the needs and gaps if there are any.

Manage and secure the database by adopting disaster recovery plans.

Automation of manual process using PowerShell and Python scripting.

Scheduling tasks using Agent Schedule jobs, TWS, custom created scripts.

Agile driven data approach to maintain good data models.

Followed KANBAN methodology along with SCRUM to make process better and results oriented.

Handling War rooms and P1 tickets.

Service level ownership of My metrics (NICE vendor) application.

24/7 support by doing on-call activity to make sure the system is up and running.

Participated in Web and App development activities to support other Teams.

Acted as a resource manager to manage 7 team members.

Database Developer 16/08/2013 - 15/03/2014

Excellence Info net Ahmedabad, Gujarat

Via client requirements assessed and designed high level projects

SSIS package development with user requirements.

Created tested and coded modules that met client specifications and industry standards

Designed SSIS for data warehousing environment and automation of batch cycle

Troubleshooting issued related to SQL server

Agent job monitoring and deployment on various servers such as PROD, Stage,

Data import/export between different environments and sources like Oracle, SQL server, MySQL

Data mapping using flat files and raw files from the vendors.

Database performance tuning and updating statistics.

Software Specialist 06/02/2012-02/08/2013

eClinicalWorks Ahmedabad, Gujarat

Gather client requirements and create use cases for product development.

Production support for SQL development issues and on-call coverage.

Creating reports using SSRS and deploy them on to various servers’ dev, stage, prod.

SQL server query building and creating stored procedures.

Installing SQL server on multiple instances.

Make sure the data integrity by applying check constraints.

Certifications

MCSA Microsoft Certified Professional

Implementing a Data Warehouse with Microsoft SQL server 2012/2014

Administering Microsoft SQL server 2012/2014 databases

Querying Microsoft SQL server

Additional Skill Set

PowerShell, Batch scripting, Database Administration

Oracle & MSSQL Database administration

Tableau data visualization.

Power BI

Python Scripting.

PowerShell scripting.

Batch scripting.

JBOSS Administration.

Informatica (ETL).

Education

MSc(comp)

Master of Computer Science Acharya Nagarjuna University

Bachelor of Science Andhra University

(Photo)

RAJASEKHAR KOPPOLU

Mobile: (+91) -991-***-**** email: *********@*****.*** LinkedIn: linkedin.com/in/rkoppolu/

Contact this candidate