SQL / ETL Developer
Ph. #: 813-***-****
4+ years of experience in IT with Database applications and Business Intelligence Design & development, and Data Analysis in Production, Development, Testing and Staging Environments.
Expertise in MS SQL Server 2016/2014, MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS).
Experience in designing, developing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.
Experience in providing Logging, Error handling by using Event Handler.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Skilled in developing SSAS Cubes, Dimensions, Facts and data source views, SSAS-Data Mining Models and Deploying, Processing SSAS objects, and Creating named calculations and named queries.
Good experience with SSRS through deploying reports, creating report schedules and subscriptions, managing and securing reports.
Developed Power BI reports from multiple data Sources.
Skilled in SQL Server Reporting Services (SSRS 2014/2012) in generating complex reports in cascaded reports, parameterized reports and Ad-Hoc reports.
Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions (UDF’s), Cursors and Indexes using T-SQL.
Expertise in SQL Server and T-SQL (DDL and DML) in constructing Tables, Indexes, Stored procedures, Views, Normalization techniques on database Tables.
Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.
Expertise in writing Sub-Queries and Joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.
Expertise in defining the business process flow and gathering business requirements.
Experience working in Agile and Waterfall methodologies in SDLC
Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2016/2014.
Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box.
MS SQL server 2016/2014/2012, My SQL
BIDS/SSDT, SSIS, SSAS, SSRS.
MS SQL Server Reporting Services 2014/2012/2008R2, SSRS, MS Excel, Tableau, Power BI.
SQL Server Tools
SSMS, Query Analyzer, SQL server profiler, SQL Server Agent.
Data Modeling Tools
Erwin tool, Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).
MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio
Windows 10/8/7/XP/Vista, MS-DOS, UNIX, LINUX.
HTML, XML, Microsoft.NET framework, Visual Studio.
Anthem Inc. Norfolk VA April 2019–Present
SQL / ETL Developer
Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
Installed SQL Server 2014 and Management tools using SQL Server Setup Program and upgraded existing databases from SQL Server 2012.
Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.
Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.
Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.
Designed, processed and partitioned cubes using SSAS.
Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Writing various T-SQL queries, Stored Procedures and used them to build packages.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server 2008 reporting services.
Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking. Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through reports using the ROLAP/MOLAP as sources.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
Worked in agile methodology, participated in daily scrum meetings.
Environment: Agile, SQL Server 2014, SSIS, SSAS, SSRS, Share point, Oracle, MDX, MS Office 2007, ER Win, T-SQL, Windows Server 2008.
Vodafone (VTM), Sandy Hook, CT July 2018– March 2019
SQL / ETL Developer
Roles & Responsibilities:
Actively participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.
Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
Designed SSIS Packages to perform the extract, transfer, and load (ETL) operations with existing data into SQL Server through OLTP database from different data sources.
Worked with SSIS Data flow task, Transformations, For-loop containers and Fuzzy Lookups, Data conversion and configured data in slowly changing dimension.
Worked with team to Develop and Extend the OLAP Cubes, Dimensions and data source view.
Designed and implement Data Mart, Facts, Dimensions and OLAP Cubes using dimensional modeling standards in SQL Server 2012 that maintained data.
Worked in the complete Data Warehouse development life cycle and actively supported business users for change requests during the project development.
Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
Developed several drill down and drill through reports using SSRS as needed by clients.
Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements
Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
Environment: SQL Server 2014, SSIS, SSAS, SSRS, visual studio, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN and Windows10.
Fluent Grid, India Oct 2015 – Mar 2017
Involved in understanding Business requirement document and developing Technical Design specification documents for multiple interfaces.
Identified various source systems for data feeds.
Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
Designed and developed jobs for loading data to star schema.
Extracted Data using SSIS from DB2, and flat files, Excel transformations.
Populate the data warehouse. Worked on SSIS to remove duplicate records with data standardization.
Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
Created various Jobs, Alerts and Events, Created Backups for databases and automated the process. Assisted in building dimensional cubes with SQL Server Analysis Services (SSAS) and building multiple calculated members, KPI’s for user perspectives.
Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements using T-SQL for different applications.
Managed index and optimized queries using execution plan.
Created and integrated user defined functions and stored procedures for reporting purposes.
Involved in the Analysis of the Report Data, Developed and Deployed Reports on to the Reporting Server. Wrote and integrated stored procedures to generate the reports.
Created Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server.
Environment: SQL Server 2012/2008 R2, T-SQL, PL-SQL, SSIS, SSAS, Power Pivot, MS Access, SharePoint server, Windows 8/7.
EDUCATION: Bachelors of Technology in Electronics & Communication Engineering, Jawaharlal Technological University, India