Resume

Sign in

Data Developer

Location:
Arlington, VA
Posted:
January 26, 2021

Contact this candidate

Resume:

PROFESSIONAL SUMMARY:

Over *+ years of extensive work experience as a SQL Server Developer and in-depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies.

Experience in design, development, coding, and testing of business and commercial applications in MSSQL Server 2017/2016/2014/2012, Visual studio, .NET Script, Windows 8/10.

Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.

Over 6 years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2012/2014/2016/2019.

Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.

Experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and to improve performance.

Experience with Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2012.

Good Experience with SSAS OLAP Cubes and Data Mining.

Over 5 years of experience in Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Execute SQL Task, Data Flow Task and union all.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

High achievement record in process quality improvement and efficient data solutions management

Experience in extracting and transforming data using Import/Export wizard, Bulk Insert, Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Work with the database developers, software developers and Development Lead, to architect and implement new features and solutions for customers

Work with development and IT teams to troubleshoot data or performance problems

Collaborate with developers, project managers and business analysts in conceptualizing and developing new software applications and enhancements

Review, discuss and work within agreed timescales and feedback to project managers any variances arising as tasks are performed

Develops and supports database architecture and development to create and enhance the Enterprise Applications

Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.

Exposure in using Team Foundation Server (TFS) as a source control, source repository and project tracking solution.

Developed several Ad-hoc reports according to the customer requirement and the Cubes using SSAS and MDX.

Developed complex Stored Procedures and views to generate various Drill-through, Drill through reports, parameterized reports and linked reports using SSRS.

Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012/2014.

Good knowledge on latest BI tools like Tableau.

Deployed and generated reports on to the server using the Report Builder 3.0 tool in Report Manager.

Experience working in Agile environment by facilitating exercises such as sprint planning and team leading standups.

Enact delivery upon completion of projects and ensure that delivery adheres to agile practices maintained by the company.

Experience in problem solving, detail oriented, multitasking, Possesses a strong sense of responsibility and teamwork with a track record of dependability.

Excellent written and verbal communication skills.

Team player with a strong analytical, technical, interpersonal, and self-motivated skills

Client: Segue Technologies Inc, Arlington, VA

Sr. SQL Developer

Jan 2019 – Present

Responsibilities:

Create Entity Relationship (ER) Diagrams to the proposed database.

Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Work with the database developers, software developers and Development Lead, to architect and implement new features and solutions for customers.

Develops and supports database architecture and development to create and enhance the Enterprise Applications.

Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions as per the requirements.

Be aware of potential blocking, deadlocking and write code to avoid those situations.

Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.

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

Develop mapping specifications, Source to target mappings and ETL development.

Develop the workflow and dataflow of SSIS ETL processes to support many different file structures and business processes

Perform tasks related to performance tuning of ETL jobs

Data loading workflow design and custom enrichment development using leading ETL tools

Researched and designed and implemented scalable applications for information identifications, extraction, analysis, retrieval, and indexing.

Created SSRS reports having multiple Parameters and cascading parameters, Navigation to a sub reports and created bookmarks when report is exported to PDF or EXCEL File.

Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.

Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.

Responsible to build Reports for different Markets and ADHOC reports as per request.

Documented Back out Implementation Plan for all the work done and created the CMD files.

Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages.

Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Worked with Oracle Application database to pull Claims, Providers, and Members information for various reports and extracts.

Provided 24/7 Production Support for the maintenance & scheduling of reports.

Oversaw software developers’ progress on applications and applied principles of agile methodologies to keep project on track.

Tracked progress of project by maintaining constant communication with senior management staff within client’s company and internally.

Environment: SQL Server 2017/2014, MS Azure, Tableau, Report Builder 3.0, Business Intelligence Studio (SSIS, SSRS), Agile Project Management tool, #.NET, T SQL, Linux and Windows Server environments, MS Excel.

Client: Keurig – Reading, MA

SQL Developer

Sep 2017 – Dec 2018

Responsibilities:

Develops and supports database architecture and development to create and enhance the Enterprise Applications

Analyzed queries performance with SQL query analyzer, optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.

Work with the database developers, software developers and Development Lead, to architect and implement new features and solutions for customers.

Participate in development and creation of Data warehouses.

Create cubes in SQL Server Analysis Services.

Performance tuning of database systems.

Develops and supports database architecture and development to create and enhance the Enterprise Applications

Work with development and IT teams to troubleshoot data or performance problems

Collaborate with developers, project managers and business analysts in conceptualizing and developing new software applications and enhancements

Installed and configured SQL Server 2008, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) which were highly efficient to monitor the central console and SQL Server instances and detecting problems before affecting transaction of online users.

Participated in to design ETL architecture and processes records from different locations, and successfully met challenges of extremely high volume of data.

Responsible for generating different types of daily and weekly Reports based on specifications and user's requirements using SSRS

Documented all the work and all the process of integration and reporting services for further references.

Applied basic management principles to tasks in for better optimize time management and achieve goals.

Environment: SQL Server 2014/2016, SSIS, SSRS, Microsoft Operation Manager, SQL Query Analyzer, ODBC, Agile Project Management tool, VBScript, Windows 2000/XP/7, MDX.

Client: Driscoll’s - Watsonville, CA

SQL Developer

Jan 2016 – Aug 2017

Responsibilities:

Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.

Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.

Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008.

Used Team Foundation Server and Visual Source Safe as a version control tool.

Developed logical queries to not triggering email limit error for ETL batch jobs.

Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010, Team Foundation Server (TFS), MS VISIO, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft Office SharePoint Server

Client: Verizon - Dallas, TX

SQL Developer

Feb 2014 – Nov 2015

Responsibilities:

Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.

Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.

Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Troubleshooting performance issues and fine-tuning queries and stored procedures.

Involved in testing and debugging stored procedures.

Designed, built, and tested SSAS Cubes on SQL Server.

Created Excel workbooks to enable Cube (SSAS) access for business users.

Process the cubes (SSAS), partitions as and when required.

Writing the DAX statements for Cube

Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations

Use package configuration to migrate SSIS package from one environment to other

Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.

Prepared the complete data mapping for all the migrated jobs using SSIS

Designing Visualizations in Tableau 9.2

Environment: MS SQL Server 2008/2012, SSIS, SSAS, TFS, Windows 2003/2008, Deployment Wizard, Visual Studio 2010, MS Excel 2007, Tableau, C#, ASP .Net.

TECHNICAL SKILLS:

Databases: SQL Server 2008/2012/2014/2017, Access, MySQL, Oracle 10g, 11g, 12c.

BI Tools: SSIS, SSAS, SSRS, Power BI

Operating Systems: Windows Server 2007, 2010, 2013, Windows 8/10/NT/XP/Professional, MS-DOS, Red Hat Linux

Version Control: TFS/GIT/SVN

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, MS Access.

EDUCATION:

Bachelor’s Degree: Engineering Haramaya University



Contact this candidate