We provide IT Staff Augmentation Services!

Sql Developer Resume

Reston, VA

OBJECTIVE:

Highly motivated in database and reporting technologies. Proficient in database development life cycle including data modeling, database coding, testing, and implementation and develop data visualizations/dashboards. And have a strong problem solving skill and can work independently and in group with good enthusiasm to learn from others.

SUMMERY

  • 5+ years of experience as SQL/BI Developer
  • Experience on planning, modeling, designing, developing, implementing, and maintaining Microsoft SQL Server 2008/2012/2014/2017 databases.
  • Experience in different phase of Software Development Life Cycle (SDLC).
  • Experienced in Installing, Upgrading and Configuring Microsoft SQL Server.
  • Experience in creating different reports, like Drill Down, Highlighted and Tabular reports.
  • Experience in Data modeling with MS Visio and Confidential.
  • Performed data cleansing using different transformations within SSIS packages.
  • Implemented OLAP Cubes, Facts and Dimensions for providing summarized and aggregate views of large set of data.
  • Extracted data using SSIS from OLTP to OLAP systems, identified various data sources and established the connections using SSIS and constructed data source view.
  • Implemented error and failure handlings within SSIS packages using event handlers, row redirects, check points, custom logs to monitor execution.
  • Experience at creating Package Level Security on SSIS.
  • Experience in Data migration, transformation, and integration.
  • Experience on developing Data Visualizations and Dashboards using Power BI and Tableau.
  • Experience in designing and implementing data warehouse and data mart using Microsoft SQL Server Integration Services(SSIS), Analysis Services(SSAS), Reporting Service(SSRS) 2008R 2/2012/2014/2017.
  • Improved the performance of reports by optimizing datasets, making use of report caching and snapshots
  • Designed and generated SSAS cubes for data analysis, deploying and processing SSAS objects.
  • Experience with Agile development methodologies.
  • Experience in T - SQL programming (DDL, DML, and DCL) skills like creating Stored Procedures, User Defined Functions, indexes, Views, Tables, Triggers and writing complex queries.
  • Experience on design data warehouse tables based on star/snowflake data modeling schema for data reporting and analytics.
  • Able to maintain current knowledge of relevant technology, programming skills, hardware, and applications.
  • Proven experience of effortlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
  • Good problem solving, judgment and decision making skill.

TECHNICAL SKILLS:

Languages, Scripting: T-SQL, PL/SQL, Python, Java script, Java, C#, HTML, XML, CSS

CMS: WordPress and Joomla

RDMS: SQL Server 2008/2012/2014/2016, Oracle 11g

BI: Power BI and Tableau

Networking: TCP/IP, LAN, WAN topologies, DNS, DHCP

Tools and Utilities: SSMS, SQL Server Enterprise Manager, Visual Studio, MS Dynamic 365

Database Integration tools: Ms SQL(SSIS), Kingswaysoft

Data Modelling tools: Erwin, Toad, LucidChart, Visio

Operating Systems: Windows

Virtualization: VMWare

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, Reston, VA

Responsibilities:

  • Creating CRUD inside Store Procedure for required table.
  • Scheduling Job that runs during the evening to update specific task using row by row level.
  • Maintaining Store Procedure on production or development level.
  • Create Transactional and Nested Transactional Store Procedure.
  • Improve the performance of a Store Procedure.
  • Using Merge Statement for Update, Delete, Insert on Target Table.
  • Review complex Store Procedure.
  • Participating with business analysis to gather requirements for design and implementation of database.
  • Used multiple join statements to retrieve data and update the table.
  • Work on upgrading databases and migrating data to different databases.
  • Experience in working in SCRUM/Agile development process model.
  • Worked closely with Quality Assurance and .Net Developers to identify and resolve issues.
  • Using SSIS to transfer data from heterogeneous source to targeted database.
  • Giving grant for specified user for Insert, Update, Delete, Select…
  • Creating indexes to reduce the running time for complex queries.
  • Normalize and De-Normalize of existing tables for faster query retrieval.
  • Create Databases, Tables, Views, Stored Procedures, Triggers, Functions and other T-SQL code to implement business rules.

Environment: - SQL Server 2017 Enterprise, Visual Studio(SSDT) 2017, Erwin9.2, Office 2016

SQL/BI Developer

Confidential, Fort Mill, SC

Responsibilities:

  • Designed and implemented tables, stored procedures views and functions.
  • Maintained SQL scripts, indexes and queries for analysis and reporting.
  • Analyze and develops a logical data model.
  • Edit scripts on SSIS using Visual Studio IDE( C#) to display popup message as we run SSIS packages.
  • Implemented Error Handling in SSIS packages and notified process results to various users and business units.
  • Perform data cleansing using different transformations within SSIS packages.
  • Designed and generated SSAS cubes for data analysis, deploying and processing SSAS objects.
  • Extracting data from OLTP to OLAP systems, identified various data sources and established the connections using SSIS and constructed data source view.
  • Created Visualizations, Dashboards with interactive views, trends and drill down on Tableau.
  • Performed data extraction, transformation, and loading (ETL) between heterogeneous sources using SSIS.
  • Deployed SSIS Package into production and scheduled SSIS jobs through SQL Server Agent.

Environment: : Tableau, MS SQL Server 2014, SQL Visual studio 2014, SSIS, SSRS, SSAS and MS Office , ERwin 9.2

SQL /ETL Developer

Confidential

Responsibilities:

  • Worked with business users and stakeholders to understand business processes, project requirements document
  • Responsible for enhancement of daily ETL Packages from excel files and OLE DB sources.
  • Designed and Developed ETL packages for data pipeline.
  • Demonstrated strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
  • Design application according to business requirements and used stored procedure, function, triggers to implement required functionalities.
  • Created complex SSIS packages which loaded multiple files using for each loop containers, and utilized a wide-variety of data transformations, including conditional splits, data conversions, derived column, merge joins, script components, etc.
  • Implemented Error Handling in SSIS packages and notified process results to various users and business units.
  • Created Visualization and Dashboard on Power BI
  • Created executive-level dashboards used by upper management to gauge sales performance on a daily, monthly, quarterly, and annual basis by product type and brand.
  • Identified problem areas performed troubleshooting when execution errors occurred and Deployed reports to Report Manager.

Environment: : MS SQL Server 2014, SQL Visual studio 2014, SSIS, SSRS, SSAS, Power BI, MS Office , ERwin 9.2

SQL Developer

Confidential

Responsibilities:

  • Involved in complete Software Development Lifecycle (SDLC).
  • Created complex SQL stored procedures, Triggers, Functions, Views, Indexes
  • Installed SQL Server Management tools using SQL Server Setup Program.
  • Participated with business analysis to gather requirements for design and implementation of database.
  • Used both System and User-Defined functions to enhance the functionality of T-SQL code.
  • Developed Dynamic SQL for user customizable queries to be answered by the SQL Server.
  • Created and deployed SSIS packages using various Transformations
  • Provided IT support, Network Installation(cabling), patch and crimp cables for small to medium companies.
  • Performed data cleansing and validation to figure out reportable data based on the requirements.

Environment: : Microsoft SQL Server 2008, Visual Studio2010, ERwin, T-SQL

Hire Now