Data Ssis

Rambabu Gupta

SQL DEVELOPER (SSIS/ETL)

Gmail: **********@*****.***; 325-***-****

Visa: US Citizen

About Me

Data don’t lie because they are facts and dealing with facts without messing them is what I excel at. SQL environment has always guided and boosted me to elevate my skills to deal with the data, analyze them for various reporting purposes which eventually lead to making corporate decisions. Proud to be a part of it.

PROFESSIONAL SUMMARY:

•Over 5 years of Experience in SQL, Microsoft BI tools (SSIS, SSRS and SSAS).

•Conducted ETL development in the Netezza environment using standard design methodologies.

•Assessed the Netezza environment for implementation of the ETL solutions.

•Used Netezza SQL to maintain ETL frameworks and methodologies in use by the company.

•Collaborated with software architects to ensure alignment of the Netezza environment.

•Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning using Netezza Database.

•Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.

•Expertise in all stages of Software Development Life Cycle (SDLC) including requirements, Analysis and Design, implementation, integration and testing, deployment and post development maintenance in Agile Methodology.

•Expertise in SQL Server 2008 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.

•Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.

•Developed BI data mapping and BI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents using Power BI.

•Experience in developing SSIS packages to bring data from different databases to data warehouse tables.

•Knowledge of SSIS Including Data flow component, control flow component, SSIS Logging, SSIS Configuration, SSIS Security. SSIS Error handling

•Knowledge in SQL and My SQL Server databases including SQL Queries, joins, functions, trigger, store procedure.

•Performed activities such as Data Collection, Data Cleansing and Transformation, Data Profiling, verifying Data Quality & GAP Analysis.

•Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.

•Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2 and 2012.

•Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

•Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

•Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert

•Good knowledge in Tuning SQL queries & improving the performance of the Database.

• Strong complex reporting skills – complex Drill-Through, Discontinuous Crosstabs, Summary Reports.

•Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill down reports using SSRS.

•Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008)

•Expert in creating Parameterized Reports.

•Experience in deploying Reports to Report Server. Creating user interface on Report Server for the users to access reports on Report Manager.

•Hands on experience in Creating Star Schema and Snowflake Schemas.

•Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS:

Databases

MS SQL Server 2005/2008r2/2012, DB2, MySQL, Oracle.

Database Tools

Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS).

Reporting Tools

SQL Server Reporting Services (SSRS) 2012/2008/2005, SAP BW, Power BI (Power View, Power Pivot), Tableau

ETL Tools

SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BCP, SQL Server Analysis Services (SSAS)

Languages

SQL, T-SQL, MySQL

Web Technologies

Web Services, XML, HTML

Operating System

Windows 98 /2003/NT/XP/7, MS DOS

Applications

MS Visual Studio 2010, MS office2003/2007/2010, HTML/DHTML, XML, Microsoft Visual Studio

Protocols

HTTP, TCP/IP, FTP

Education

Bachelors in Business Studies, Tribhuvan University, Balkhu, Kathmandu, Nepal

Professional Experience

Providence Hospital, MSBI Developer, Mobile, AL Feb 2017-Current

Worked as MSBI in order to handle multiple data flows from various medical components departments and track down the supply of those components. Also, created SSIS packages based on the raw information received from various agencies and as per the BRD

Responsibilities:

Gathered user requirements and analyzed and designed software solution and database.

Extensively worked on full Software Development Life Cycle SDLC of the project from Database Design and Modeling to implementation and maintenance.

Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database

Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, etc. and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS.

Designed and Developed Complex SSIS Source to Intermediate Packages to load the data into Intermediate Databases

Developed Complex SSIS Parent-Child Packages for different Counties with Common Source to Intermediate rules.

SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.

Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.

Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.

Experience in performance tuning of SSIS Packages using row transformations.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.

Created complex Stored Procedures for validation process for loading data from the staging area to the product database in SQL 2008.

Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Experienced with SharePoint 2010 for sharing the files with the tasks issued.

Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS

Worked on Report generation using SQL Server Reporting Services SSRS that could be used to send information to Client.

Texas Instruments, SSIS Developer, Dallas, TX Apr 2015 – Jan 2017

Worked as an SQL/SSIS Developer during their data migration process. Used MAP operation to some extent to create Mapping Variables and Parameters. Worked with Database admins to configure connection to Oracle/SQL Databases and migrated DTS packages to SSIS packages

Responsibilities:

Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.

Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.

Created complex queries involving CTE’s, Sub-queries and Joins.

Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.

Created new database/tables to put in the extracted data and rebuild the relationship.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.

Created the SSIS /DTS packages and scheduled them using SQL Server agent.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Utilized event handling effectively to generate audits and logs for the generated SSIS packages.

Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

Deployed SSIS Packages from Dev/Staging/Production using Package Configurations

Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.

Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.

Created Subscriptions and Data-driven subscriptions using SSRS 2008.

Created Dashboards and Scorecards using Share Point Server 2007/2010

Performed Identification, analysis and resolved report defects within time scope and established development guidelines.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Regions Bank, SQL Developer, Tyler, TX May 2014 - Mar 2015

Worked as a SQL Developer by writing complex Stored Procedures, Triggers, Functions, Indexes, Views and involved in ETL package creation using SSIS. Played major role in maintaining various reports and active participation in all AGILE process including SDLC and STLC

Responsibilities:

Responsible for Installation, configuration, Troubleshooting, maintenance and monitoring of different environments of SQL Server.

Designed and Developed packages for system integration, product development and ongoing maintenance of the tables using SSIS.

Created SQL server objects like Indexes, Indexed Views, Stored Procedures (dynamic and static), effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions.

Collaborated with team members in writing test SQL scripts, performing tests and providing appropriate follow-up actions and documentation.

Developed MSSQL triggers, procedures, functions and packages for the various interfaces.

Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data to data warehouse databases and involved in Data cleansing in the data transfer.

Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling.

Developed Query for generating Drill Down and Drill Through reports in SSRS.

Designed Cubes with Star Schema using SQL Server Analysis Services (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).

Generated Tabular, Sub reports and Parameterized reports for the Business users.

Designed report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.

Involved in Performance Tuning to improve response time of Stored Procedures.

Created Time Dimensions on OLAP Cubes using SSAS.

Maintained Database Backups and Scheduled Jobs and Alerts involving with Administrator.

Contact this candidate