Junior SQL Server Developer Resume

OBJECTIVE

With over two years of IT Experience specifically as SQL and BI Developer, SQL Server Database Administration, I am looking to work as SQL and Business Intelligence Developer in a technology - oriented company where I can demonstrate my caliber and technical abilities to design, test, and deploy SQL and BI solutions as well as provide solutions to data analytic issues.

TECHNICAL SKILLS

Languages and Scripting: Microsoft SQL Server, MySQL, T-SQL

BI and Data Analytics Tools: Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Services Analysis (SSAS), Power BI

Tools: and Utilities: Microsoft SQL Server Management Studio, SQL Server Enterprise Manager, Visual Studio

Data Modeling tools: ERWIN, Visio, Draw.io, Lucid Chart, Toad

Data Visualization and Analytics tools: Power BI, and Microsoft Excel

Office Tools: Microsoft office Word, Excel, Power Point; Open Office and Google Docs

PROFESSIONAL EXPERIENCE

Junior SQL Server Developer

Confidential

Responsibilities:

Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic.
Streamlined the reporting process through tuning SQL and automated the daily reporting process.
Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
Experience in Extracting Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS.
Performed data extraction to and from various sources including MySQL, SQL Server 2012/2014, CSV, Excel, and Text file from Client servers.
Worked with Data Analysts to create and maintain new database tables.
Developed and rendered monthly, weekly, and daily reports as per the requirement and gave roles, user access concerning security in Report Manager.
Created reports with SQL Server Reporting Services
Built interactive designs and dashboards with Power BI desktop
Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown, Drill-through, matrix features in MS SSRS 2012.
Firsthand Experience on Various SQL Server Services like integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
Working very closely with the data quality team in identifying and resolving issues related to data quality raised by lines of business users.
Developed visualizations, reporting and dashboard creation with Power BI and deployed those visualizations to Power BI Servers
Worked with business and IT team members to prepare and translate business requirements into technical solutions in transactional database design.

Junior BI /SQL Developer

Confidential

Responsibilities:

Developed SSRS reports, SSIS integration packages, SSAS analysis cubes using Microsoft SSDT and Power BI
Performed GAP analysis comparing the Business Content & reporting/modeling requirements.
Converted existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
Created and maintained stored procedures, views, triggers, and constraints to implement the database consistency and integrity.
Performed all development activities required for delivery of BI solutions including ETL, data modeling, SSAS cube development, solution deployment and maintenance.
Developing customized reports using SSRS and scheduled daily and weekly reports.
Create spreadsheet reports using Excel (Pivot Tables, vlookups)
Participated in query optimization, performance tuning and knowledge sharing activities.
Translated project requirements into functional and non-functional specifications for BI reports and applications.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship