We provide IT Staff Augmentation Services!

Sql Developer/production Support Resume

Boca Raton, FloridA

PROFESSIONAL SUMMARY:

  • 7+ years of experience in database design, development and administration with MS SQL
  • Extensive experience in SQL service integration services (SSIS) for ETL (Extraction,Transformation and Loading), reporting services (SSRS) for creating different types ofreports and analysis services(SSAS) for design and development of complex cubes.
  • Excellent backend skills in creating SQL objects (Tables, Complex Stored Procedures,Effective Functions, Views, Indexes, Triggers, Rules) and SQL Performance Tuning tofacilitate efficient data manipulation and consistency.
  • Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema /Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
  • Development of Multi - dimensional Objects (Cubes, Dimensions) using Analysis Services (SSAS).
  • Excellent Transact- SQL / T-SQL programming skills with experience in developingSQL queries, sub queries using Joins, Aggregate functions and User defined functions.
  • Well versed with the knowledge of RDBMS, data warehousing (OLTP and OLAPsystems),System Development Life Cycle (SDLC), and Waterfall model.
  • Highly skilled in Data Modeling, Data Mining, Data Mapping, Table Normalization,Optimization and Tuning.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSISpackages using SQL Server Management Studio and Control-M Workload Automation tool.
  • Developed complex win forms using VB.Net and Oracle 12.1.
  • Developing distributed application using web services in vb.net
  • Excellent knowledge in dealing with Delegates, Assemblies, User Controls and Custom Controls in VB .Net
  • Experience in resolving complex issues and error handling in SSIS, Unit Tests and UserAcceptance Tests.
  • Proficient in writing SSIS script/script component task using c#, VB script forcustomized data manipulation of complex SSIS packages.
  • Microsoft COSMOS, SCOPE technologies for data/stream analysis.
  • Creating/maintaining scope scripts and jobs to generate daily stream file on COSMOS of evidence.
  • Expert in designing enterprise reports using reporting services (SSRS) like Dashboards,Tabular, Matrix, Drill down, Drill through, Sub reports and Ad-Hoc reporting. Createdmultiple value parameters, cascading prompts, dynamics reports.
  • Extensive experience in rendering reports, managing subscriptions, creating reports withreport builder, report snapshot and report cache.
  • Experience in providing SSRS server level, item level security and accessibility tovarious reports in multi-user environments.
  • Proficient in Database Installation, Configuration, Maintenance, Monitoring, Backup andDisaster Recovery procedures and Replication.
  • Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business Process Framework.
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.
  • Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).
  • Extensive experience in analysis, design, application programming on Oracle. Experience in database Backup & Recovery.
  • Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database.
  • Worked with Oracle DBA in migration project and supported oracle databases
  • Strength Finder’s top 5 strengths: Maximize, Achiever, Responsibility, Deliberative,and Strategic. Outstanding problem solving, analytical, technical leadership, communication, Time management skills and quick learning capability to new technologies.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Programming: T-SQL, PL-SQL, C, MYSQL

Database: MS SQL Server 2016/2012/2008 R2/2005/2000, MS Access

Reporting Tools: SQL Server Reporting Services (SSRS)MS Access, MS Excel, Crystal Reports.

Operating Systems: Windows 2008 R2, Windows NT 2000/2003 Server, Windows XP/7.

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, Florida

SQL Developer/Production Support

Responsibilities:

  • Collected business requirements from users and translated them as technical specs and design docs for development.
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business Process Framework.
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.
  • Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).
  • Extensive experience in analysis, design, application programming on Oracle. Experience in database Backup & Recovery.
  • Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database.
  • Worked with Oracle DBA in migration project and supported oracle databases
  • Views using T-SQL in Development and Production environment for SQL Server 2008.
  • Primary duties were to assess infrastructure, deployment, processes and validity of data in SQL Server 2014.
  • Created Quality Assurance stats reports using SSRS
  • Created SSIS packages for new projects utilizing Business Intelligence Development.
  • Writing complex Stored Procedures to meet the business requirements.
  • Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Report parameters included single valued parameters, multi-value parametersthat also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Worked on all types of report types like tables, charts, sub reports etc.
  • Used VB.Net to define and implement Business Logic Layer and Data Access Layer.
  • Created OOPs objects like Collections, Interfaces implementations using VB.Net Generics for extracting data
  • User interface screens developed using VB.NET.
  • Participated in the conversion of VB system into MVC VB based architecture
  • Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
  • Developed, monitored and deployed SSIS packages.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.
  • Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Environment: MS SQL Server 2008 Visual Studio , MS SQL Server 2000/2008R2/2016 SQL Integration Services, VB.net, SQL Query Analyzer, Import & Export Wizard.

Confidential, Charlotte, NC

MS SQL Server SSIS/ SSRS Developer

Responsibilities:

  • 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 SQL Server Integration Services (SSIS).
  • Created SQL Objects like Complex Stored procedure, trigger, functions, views and tables
  • Performance tuned Stored Procedures & long running queries by looking at query plans, IO Statistics, Joining Techniques and Indexes.
  • Modified various MDX Calculations in cube.
  • Created different roles for the security in cube.
  • Interacted with user groups for delivering Enterprise Reports using SSRS 2008 R2 reports for various reporting needs.
  • Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
  • Created static reports in Excel with Graphs and trends for month end.
  • Created partitions for various counties and designed aggregations (manual & usage based), relations and attribute hierarchies in the SSAS cubes.
  • Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business Process Framework.
  • Supporting VB.NET applications that support the engine assembly.
  • Created asynchronous VB.NET application that allowed editing downloading of information to PLCs. The application used Entity Framework for accessing the SQL database.
  • Upgraded VBA applications to VB.Net utilizing Visual Studio Tools for Office.
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.
  • Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).
  • Extensive experience in analysis, design, application programming on Oracle. Experience in database Backup & Recovery.
  • Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database.
  • Good Hands on experience writing Scope Scripts for Cosmos (Big Data) Azure Services and cloud services.
  • Converting unstructured streams in Cosmos (Raw Data which are in Binary form) to structured stream (readable stream) and performing required aggregation on that Data using scope studio by writing scope scripts
  • Worked with Oracle DBA in migration project and supported oracle databases
  • Created Dashboards, Score Cards and KPI's for various reporting needs.
  • Involved in testing the data with Business Analysts and testing team.
  • Interacted with end-users and customers during various phases of the Implementations (ETL, Reporting, Production Support, Enhancements and bug fixes).

Environment: MS SQL Server 2012/2008R2 SQL Integration Services 2012, MS SQL SSRS, SSIS, VB.net Windows 2003 Advanced Server.

Confidential

MS SQL Server Developer

Responsibilities:

  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Developed Custom Logging so user can know when a row is inserted in custom logging Table by every SSIS package that executes.
  • Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
  • Used SSIS packages to roll our data to Live Tables and to Processing Database.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012, Flat files etc.
  • Schedule Package using SQL Server Job for Daily/weekly/monthly basis.
  • Created SQL Server Reports based on the requirements using SSRS 2012.
  • Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using Microsoft SQL Server Reporting Services (SSRS).
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis.
  • Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked Extensively on ETL process using SSIS packages.
  • Experience in Developing, Deploying and MonitoringPackages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
  • Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
  • Developed the server side code using C#, VB.Net
  • Migrated the entire application from Version2 (ASP, VB Script) to Version3 (using Web Services, XSLT and VB.net)
  • Designed and developed web forms using ASP and VB Script
  • Created various Tabular and Matrix Reports using SSRS.
  • Created reports to retrieve data using Stored Proceduresthat accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports
  • Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
  • Strong Experience in developing reports using Query Studio & Report Studio.
  • Schedule, Monitor and control Access of users by creating groups.
  • Worked on for loading data from source to destination.
  • Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality

Environment: MS SQL Server 2008 Enterprise Edition, MS Access, DTS, Query Analyzer, BCP, SQL Profiler, VB.net, Erwin 4.1, Business Objects 6.5, Import & Export Data, Windows 2000 Server.

Confidential

SQL Server Developer

Responsibilities:

  • Designing the Databases, Developing Business Intelligence Analysis, Implementation and Reporting with Microsoft SQL Server 2005/2008/2008 R2/2012.
  • Use of Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformation secluding Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
  • Creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools
  • Creating SSIS Packages for uploading of different formats of files and databases into SQL Server Data Warehouse using SQL Server Integration Services.
  • Create Data Flow Diagrams, Data Mapping From Source To Stage And Stage To Target Mapping Documents Indicating The Source Tables, Columns, Data Types, Transformations Required And Business Rules To Be Applied.
  • Plan, Define and Design Data based on Business Requirements and provide documentation.
  • Create new Database objects like Procedures, Functions, Packages, Triggers, Indexes using T-SQL in development and production environment for SQL Server.
  • Migrating the Data from one environment to another.
  • Use of SQL Server Integration Services (SSIS) and Reporting Services (SSRS)
  • Performance Tuning, SQL Programming, Troubleshooting, SSIS/DTS Package Configuration, SSRS.

Environment: MS SQL Server 2005, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

Hire Now