Sql Developer Resume
Redmond, WA
PROFESSIONAL SUMMARY:
- Microsoft Certified Business Intelligence Developer with 4 years of IT experience in development, analysis, design, testing, presentation and implementation experience using SQL Server 2012/2008R2/2008/2005, Oracle11g/10g/9i and SQL Server Data tools .
- Very good hands - on experience in development and implementation of Data Warehouse applications.
- Involved in all the stages of Software Development Life Cycle mainly in Database design, data access and development using MS SQL Server 2012/2008R2/2008, Oracle 11g/10g and Web Applications development.
- Extensive experience in designing, developing, and delivering business intelligence solutions using
- Strong data base experience in Oracle, SQL Server 2000, DB2 and Sybase . SQL Server Data tools or SQL Server Integration Services (SSIS) and Reporting Services (SSRS) .
- Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions .
- Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
- Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
- Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
- Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
- Experience with Scope scripting optimizations to improve performance of cosmos job.
- Must have strong experience with Microsoft SQL Servers programming and optimization, advanced knowledge of cosmos/Scope script.
- Performed Analysis of user and business requirements to create accounting applications using VB.NET.
- Coded SQL stored procedures and functions for use on Crystal Reports and VB.NET/VB.
- Debugged SQL troubleshooting and fixing bugs in Business Objects reports.
- Modified financial web applications using ASP.NET, C# with SQL server creating stored procedures
- Created GUI front end with data entry screens using C# and SQL server in the backend
- Wrote supporting routines in VB.NET for data processing including DTS for data feeds/database servers
- Designed Crystal Reports 9/10 enhancements and bug fixes, and configured version control system
- Performed migrations of existing applications to VB.NET from Visual Basic 6.
- Strong analytical skills with the ability to collect, organize and analyze information with attention to detail and accuracy.
- Proficient in writing advanced T SQL Server Queries, experience in DW concepts, report development, ETL development & tuning and data model development.
- Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
- Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
- Worked on Azure Data Factory, created pipelines, data sets and linked services for the team project.
- Expertise in creating Dashboards, Metrics, Rules and Goals, corporate/personal dashboards, Alerts.
- Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
- Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
- Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
- Experienced in creating Transformations and Mappings using Informatic Power center, Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets
- Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS) .
- Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
TECHNICAL SKILLS:
Operating Systems: Windows Vista Business / XP Pro. / 2003 / NT / 9.X
Programming: C#. Net, VB.Net, ASP, C, C++, ADO.NET, XML
Scripting Language: Java Script, VB Script, HTML, XML
Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , PL/SQL, Oracle 11g/8.0i, DB2 MS Access 2000/8.0. teradata.
SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Enterprise Manager, Import and Export Data wizard, SQL Server Business Development studio (BIDS).
ETL Tools: SQL Server Integration services (SSIS) 2005 and 2008 , Data Transformation Services (DTS)
Analytical Tools: SQL server Analysis Service (SSAS), Performance Point Server 2007.
Reporting Tools: SQL server Reporting Services (SSRS), Crystal Reports, Business Objects, OBIEE
Data Modeling Tools: Erwin, Visio, MS Access
Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2,
Visualization Tools: Tableau 8.1/8.0/7/0
Web server technology: IIS
Other Tools: MS Office, Crystal Reports XI, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host
Hardware: EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq Proliant 8000, 6500, 6000
PROFESSIONAL EXPERIENCE:
ConfidentialRedmond, WA
SQL Developer
Responsibilities:
- Experience with Scope scripting optimizations to improve performance of cosmos job.
- Experience with Microsoft SQL Servers programming and optimization, advanced knowledge of cosmos/Scope script.
- Strong analytical skills with the ability to collect, organize and analyze information with attention to detail and accuracy.
- Proficient in writing advanced T SQL Server Queries, experience in DW concepts, report development, ETL development & tuning and data model development.
- Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
- Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
- Performed daily database backup & restoration, monitored the performance of the Server.
- Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
- Worked on Azure Data Factory, created pipelines, data sets and linked services for the team project.
- Designed and developed tables, view, stored procedures and triggers in MS SQL Server.
- Developed classes in Business Layer and in Data Access Layer in C#.
- Used Custom Validations and User Validation to give access to registered users.
- Developed Business Logic classes for Transaction Module using Business Services.
- Created database objects using SQL Server including complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Created web application using C#, developed various interface webpages for incoming files for the Vendor Interfaces including service invoice, repair order, finance and insurance, vehicle inventory tracking, parts order using C# and job claims with stored procedures .
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Design, development and deployment of Vendor Interfaces for load testing and in production environment.
Environment: MS SQL Server 2008, Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad, text editor, C#.NET, ADO.NET, ASP.NET 3.5, VB.Net, MS Visio 2005, DTS, SQL Query Analyzer, Tera Data SQL Developer, Power BI SSIS/SSRS/SSAS.
ConfidentialTampa, FL
SQL BI Developer
Responsibilities:
- Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
- Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
- Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
- Designed and implemented Parameterized and cascading parameterized reports using SSRS.
- Created star schema in SSAS and developed SSRS reports based on the cube.
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
- Performed Analysis of user and business requirements to create accounting applications using VB.NET.
- Coded SQL stored procedures and functions for use on Crystal Reports and VB.NET/VB.
- Debugged SQL troubleshooting and fixing bugs in Business Objects reports.
- Modified financial web applications using ASP.NET, C# with SQL server creating stored procedures
- Created GUI front end with data entry screens using C# and SQL server in the backend
- Wrote supporting routines in VB.NET for data processing including DTS for data feeds/database servers
- Designed Crystal Reports 9/10 enhancements and bug fixes, and configured version control system
- Performed migrations of existing applications to VB.NET from Visual Basic 6.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
- Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
- Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data
- Creating complex SSIS packages using proper control and data flow elements.
- Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
- Performed Analysis of user and business requirements to create accounting applications using VB.NET.
- Coded SQL stored procedures and functions for use on Crystal Reports and VB.NET/VB.
- Debugged SQL troubleshooting and fixing bugs in Business Objects reports.
- Modified financial web applications using ASP.NET, C# with SQL server creating stored procedures
- Created GUI front end with data entry screens using C# and SQL server in the backend
- Wrote supporting routines in VB.NET for data processing including DTS for data feeds/database servers
- Designed Crystal Reports 9/10 enhancements and bug fixes, and configured version control system
- Performed migrations of existing applications to VB.NET from Visual Basic 6.
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
- Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
- Created custom data flow items for different SSIS packages using the VB.Net script.
- Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
- Involved in writing queries for Stored procedures, clustered and non-clustered indexes.
- Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
- Involved with business and functional people to collect and gather requirements
- Implemented Mock report layouts before the actual report implementation.
- Creating value prompts, Date & time prompts, Text box prompts, cascading prompts.
- Hide and Show the objects by using conditional blocks.
- Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Environment: MS SQL Server 2008, Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad, text editor, C#.NET, ADO.NET, ASP.NET 3.5, VB.Net, MS Visio 2005, DTS, SQL Query Analyzer, Tera Data SQL Developer, SSIS/SSRS/SSAS.
Confidential
SQL Server Developer / DBA
Responsibilities:
- Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
- Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
- Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
- Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
- Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
- Involved in writing T-SQL statements for retrieval of data.
- Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
- Performed daily database backup & restoration, monitored the performance of the Server.
- Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
- Designed and developed tables, view, stored procedures and triggers in MS SQL Server database on Windows NT platform.
- Designed and developed reports using Crystal Reports
Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000