We provide IT Staff Augmentation Services!

Msbi/ Sql Developer Resume

Plano, TX

SUMMARY

  • Experienced in developing T - SQL (DDL, DML) and in developing and deploying packages within SSIS.
  • Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views and Triggers.
  • Experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Microsoft SQL Server 2012/2008R2, SSIS, SSRS and SSAS.
  • Experience in Query tuning and performance tuning using SQL Profiler, Clustered and Non-Clustered indexes on tables for faster query retrieval as DBA role.
  • Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Extensive knowledge in RDBMS concepts, logical/physical data models, indexes and data integration routines.
  • Involved in all phases of Software Development Life Cycle (SDLC): analyze, design, implementation, testing and maintenance.
  • Knowledge in Performance Tuning, Query Optimization and maintaining database systems using SQL Profiler and Database Engine Tuning Advisor.
  • Experience in migration of Data from Excel, Flat files, Oracle RDBMS to MS SQL Server by using MS SQL Server DTS and SSIS packages/tasks.
  • Able to install, upgrade and configure Microsoft SQL Server and Oracle Databases.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills.
  • Able to manage changing responsibilities and deliver time critical projects on schedule.
  • Strategic vision, analytic, imaginative and procreativity ability to formulate and validate solutions.
  • Excellent verbal & oral communication, analytical and inter personal skills to learn new ideas.

TECHNICAL SKILLS

  • Netezza
  • SQL Server 2008 R2
  • BIDS
  • NZSQL
  • PL-SQL
  • SSIS
  • SSAS
  • SSRS
  • Tableau
  • HP Quality Center
  • Workload Automation
  • Linux
  • .Net framework
  • Windows XP.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

MSBI/ SQL Developer

Responsibilities:

  • Created SSIS packages to load data from numerous sources to the application database.
  • Designed stored procedures, tables, cursors, joins by using T-SQL.
  • Assisted daily for troubleshooting and nightly processes.
  • Troubleshoot daily for any failure in nightly processes and executions.
  • Assisted other teams for loading data with various environments and also created numerous stored procedures for other team members.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Assisted the team in building a brand new data warehouse for de-identifying data project for all PHI and HIPAA regulated data.
  • Optimized the database by creating various clustered and non-clustered indexes.
  • Performed Logging and Error handling in SSIS and T-SQL.
  • Updated T-SQL scripts after testing within the development environment.
  • Worked closely with Business Analysts to update specifications and requirements.
  • Assisted Business Analysts to create user stories before every sprint.
  • CreatedLogins, users & rolesand involved in DailyUser Maintenance.
  • CreatedDatabase Maintenance jobsto performfull & transactionlog Backupsand scheduled them with the SQL Server agent job scheduler.
  • Worked as a leader in many scrum meetings, retrospective meetings and daily meetings in order to build a strong communication bridge between various project team members.
  • Created SSRS report as per service request.
  • Worked with Index and Performance tuning SQL Queries.
  • Used various transformations like Data conversion, Conditional Split, Derived column, file system task, row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task and so on.

Environment: SQL Server 2012 R2, SQL Server 2012, Visual Studio 2010/2012(Data Tools), SSIS, SSRS, TFS, .Net Framework, Windows 8.

Confidential, Irving, TX

MS BI Developer

Responsibilities:

  • Successfully installed configurationandmaintenanceof the new systems across all environments(Development, Test & Production).
  • CreatedLogins, users & rolesand involved in DailyUser Maintenance.
  • CreatedDatabase Maintenance jobsto performfull & transactionlog Backupsand scheduled them with the SQL Server agent job scheduler.
  • Set upTransactionalReplicationbetween serversand troubleshootthe issues
  • Monitored databasegrowthactivities& Troubleshoot Transaction LogIssue.
  • Created and configured mirroring in case ofDisaster Recovery problems.
  • Installation on clustered environments and createdclustered and non- clustered indexes
  • Worked closely with theProjectteam in clarification of requirements and communicated the same to theoffshore team.
  • Performedweekly status informationon all the projects to Project Manager.
  • Worked withPerformance Tuning/Query tuning, execution plans, traceflags and SQLProfiler.
  • Successfully Installed Service packsto all environments.
  • As a part of the DBAteam providing24/7 production support tothe clients
  • Providing Design, Architecture & Engineeringsupport as well as on-call support for SQL Serverdatabases and servers using SQL Server2000, 2005,2008 R2 and 2012
  • PerformingDB backups, restores, clean-up & DB maintenance activitiesin a largelike log file monitoring, statistics update, performance tuning, disaster recovery
  • Planned and monitored new SQL Serverimplementations, server-to-servermigrations, andupgrades, including database definition, structure, documentation,andlong-term hardwareandstorage requirement.
  • Developed complexStoredProcedures, triggers, tables, and viewsand other SQL joins and statements for applications by using T-SQL.
  • Created a variety ofProject Dashboardsfor different managements within FRO.
  • Performedaggregations, averageson various groups ofdaily, weekly and monthly datatodisplay theprogressofeach ProjectwithinFRO (Financial Reporting Operations) onweekly and monthly dashboards.
  • Convertedexisting Excel templates into SSRS reportsto migrate the reporting model to SQL ServerReporting Services. Also made sure that the SSRS reports wereconsistent with the previous Excel layoutsto avoid any issues while uploading the monthly reports to the Gran Central database.
  • DevelopedSub-reportsandDashboardsusingGauges and Chartsto add more detail to the report.
  • Built complexAd Hoc,Standard ReportsusingSSRSand worked with tuning the large complex reports on SQL Server Database.
  • CreatedData drivenSubscriptions toautomatethe process ofstoring copies of hundreds of parameterized monthly reports to the server.

Environment: SQL Server 2008 R2, BIDS, DB2, SSIS, SSRS, Win SQL, HP QA Tool, Change Man, Control-M, .Net Framework, Windows XP

Confidential, Fort Lauderdale, Florida

SQL Server Developer

Responsibilities:

  • Developed stored procedure to load data from legacy to the application for 10 years of data.
  • Developed complexStoredProcedures, tables, cursors, numerous SQL joins and statements for applications by using T-SQL.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Converted data type from legacy to the production (application) as required.
  • Extensively used mapping logic and data model to map data from legacy system to the production (application).
  • Created and managed SSIS packages and Control Flow tasks to load some preliminary tables for the main ETL process.
  • Extensively used cursors and temp tables to load each row from legacy to application database.
  • Designed error log tables for all the developers in order to catch errors during any kind of loading data.
  • Created stored procedures for all the developers to disable and enable constraints within each database as needed by the developers.
  • Created functions in order to convert data type for any complex conversion process for the development team.
  • Identified the causes of slow running of T-SQL queries for the development team.
  • Optimized the database by creating various clustered and non-clustered indexes.
  • Performed Logging and Error handling in SSIS and T-SQL.
  • Updated T-SQL scripts after testing within the development environment.
  • Tested converted data in the development, integration and application environment on daily basis.
  • Performed optimization techniques-normalization and indexing ensure the completeness of batch processes, scripts and processes.
  • Assisted Business Analyst to test data and GUI according the specifications and technical requirements.
  • Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
  • Performed weekly dry runs for the development environment for all the data converted. Dry runs are done in development, integration, testing and production environment.
  • Worked closely with Business Analysts to understand the legacy system data in order to convert them correctly for the application to work properly.

Environment: Netezza, SQL Server 2008 R2, BIDS, NZSQL, PL-SQL, SSIS, SSAS, SSRS, Tableau, HP Quality Center, Workload Automation, Linux, .Net framework, Windows XP.

Hire Now