SQL Developer Resume

SUMMARY

Over 6 years of good experience in MS SQL Server, Etl Developer in various fields like Hospital, energy, insurance and financial institutions with expertise in T - SQL, SSIS and SSRS.
3 years coding experience to migrate data from other conventional systems such as Oracle, Azure Sql Data Warehouse etc.
Capable of handling multiple tasks effectively both as an individual and as a team member. Good communication skills.
Hands on experience in designing data warehouse using star schema and snow flake schema.
Proficient in doing performance tuning in T-Sql using SQL server profiler and SSIS packages. Creating objects, function, stored procedures, index and views.
Expertise in developing SSIS Packages, configurations and using data transformations and deploying them on various production servers.
Expert in Data Conversion, Normalization and Data Modeling using Erwin Tools, Multi-Dimensional Modeling.
Highly skilled in writing Parameterized Queries for generating Tabular reports and Sub reports using global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008, 2012.
Proficient in configuring CISCO Routers and switching, Subnetting and operating Internetwork Operating System.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

Involved in the design of new schema, new tables, inner join and mappings, stored procedures, views, indexes using SQL Server 2012.
Created SSIS Packages by using transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate)
Participated in implementing the logical design to the physical design by creating tables and views.
Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
Responsible for creating the reports based on the requirements using SSRS 2017.
Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

Confidential

SQL Developer

Responsibilities:

The Main goal was implementing stored procedures and views. Entering Patient data, Pharmaceutical data in tables.
Designed SSIS packages to Extract data from different sources like SQL server 2012, MS Excel, Flat file, CSV and transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
Developed SSIS packages using for each loop in Control Flow to process all excel files within the folder, File System Task to move file into Archive folder. Processing and executing SQL task to insert transaction log data into the SQL table.
Provided design, implementation and maintenance for custom reports and quarterly reports as pie charts, bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task etc.

Confidential

SQL Developer

Responsibilities:

Main goal was creating new and existing clients in the database. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.