We provide IT Staff Augmentation Services!

Sql Developer/ssis Resume

Brentwood, NY

SUMMARY

  • About 5+ years of IT experience SQL Server Suite of products(SSIS/SSRS/SSAS) and involved in all phases ofSoftware Development Life Cycle from gathering requirement, development, implementation, testing and support.
  • Extensive experience in writing Data Definition Language(DDL), Data Manipulation Language(DML), Stored Procedures, Triggers, Views and Functions in complex T - SQL queries.
  • Utilized various DBCC commands to ensure the database consistency.
  • Applied various Isolation Levels to lock the table rows from updating while it is being read by the specific user.
  • Used Performance Monitor/Profiler to solvedead locks/long running queries.
  • Created complex SSIS Packages in SQL SERVER 2012/2008R2/2008/2005 for Data Migration and Transformation to and from SQL, SQL Azure, Oracle, SAP ABAP, Flat files, Excel Sheets using SSIS.
  • Used Report Manager to assign roles, permissions and to create report schedules.
  • Experience withAd-HocreportingusingReport Builderin SSRS for daily reports.
  • Highly experienced in creating Tabular Reports, Matrix Reports and distributed reports in multiple formats using SSRS.
  • Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS),BULK INSERT,DTSImport/Export utility, andBulk Copy Program(BCP).
  • Highly Experienced in configuration of report server and report manager for scheduling, give permissions to different level of users in SSRS.
  • Knowledge of SQL Server Analysis Service (SSAS), Cubes, Dimension, Multidimensional Expressions (MDX) queries.
  • Highly experienced with SSIS package configuration to deploy packages to different environment such as UAT or Production.
  • Expert in High Level Design of ETL Package for integrating data from different databases (Oracle, DB2, and MS Access) and data conversion process experience with strong ETL skill.Expert in dealing with Alerts, Operators and Jobs through SQL Server Agent.
  • Assisted in restoring and updating the production database into development and QA environment for testing various stages of monitoring the queries.
  • Proficient in data loads, database integration/conversions, performance tuning and optimization.
  • Experience in both agile and waterfall methodologies.
  • Has experience in driving and maintain the scrums/ sprints.

TECHNICAL SKILLS

Languages: C#

Client &Server Side Scripting: ASP.NET 3.0/3.5/4.0, JavaScript, MDX, DAX

Web Technologies: ASP.NET, HTML, XSLT, XPATH

Reporting Client tools: MS SQL Server Reporting Services(SSRS), Tableau

IDEs: SQL Server Management Studio (SSMS), SSDT, SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010 Team Edition and 2012 Professional Edition.

Versioning: Team Foundation Server (TFS), Perforce

Operating Systems: Windows/Server, UNIX, MS - DOS

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, NY

SQL Developer/SSIS

Responsibilities:

  • PerformedServer installationand configuration usingSQL Server 2014.
  • UtilizedT-SQLon a daily basis in creating customs view for data and business analysis.
  • Developed complex merged scripts to match up the records that reside in two different databases.
  • Have created In-Memory staging tables to provide high performance data availability for ETL package execution process.
  • Writing complex SQL queries using tablejoins (inner and outer), temporary tables, and table variables.
  • Worked on accounts based on the equity, Stocks and bonds to generate stored procedure that populates data on 1099 forms for each of their clients or any individual based on account and CUSIP Number.
  • Created views for reports which were generated in ASP.NET.
  • Extensively worked withSSIStool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split,Lookup, Aggregator,Multicastand Derived Column.
  • Worked with various XML data and worked on creatingETL packageswith loading all package in loop and loading them in SQL server.
  • Design database Backup and Restoration Strategy i.e. Database Backups and Sql Server Agent jobs.
  • Worked and setup High-Availability as part Disaster Recovery Strategy for the Databases i.e. Database Mirroring, database clustering and Log Shipping and Disaster Recovery Plan.
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS).
  • Worked with Slowly Changing Dimension transformation (SCD) task to load the data in fact and dimension table.
  • Have performed package configuration for SSIS package to make it executable in any environment such as Production, UAT or Testing.
  • Worked with BA in creating mapping document based on business requirements, source to destination schema mapping along with the ETL logic and created design documents.
  • DefinedIndexes, Views, Constraints and Triggers toimplement business rules.
  • Involved extensively in creating database diagrams through MS Visio based on the requirements presented by BA.
  • Experience troubleshooting and resolving database issues. Debugging, identifying bugs and driving them to closure by working closely with the development team.
  • Utilized Visual Studio in creating and deploying database projects.

Environment: MS SQL Server 2014, Visual Studio 2013,Perforce, MS SQL Server 2008R2, 2012 MS SQL Integration Services 2008R2,2012, ASP.NET, T-SQL, Telerik Code Converter, Microsoft Visio, SQL profiler, MySQL.

Confidential, Newtown, PA

SQL Developer/SSIS/SSRS

Responsibilities:

  • DefinedIndexes, Views, Constraints and Triggers toimplement business rules.
  • Writing dynamic SQL queries using views, Common Table Expression (CTE), temporary tables, and table variables to produce temporary result set.
  • Utilized various DBCC commands to ensure the database consistency.
  • Applied various Isolation Levels to lock the table rows from updating.
  • Experience trouble shooting and resolving database issues. Debugging, identifying bugs and driving them to closure by working closely with the development team.
  • Experience in working highly complex data to create view, Dynamic Stored Procedure and temporary table to make data available for reporting and analysis purpose.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task, and others in order to generate underlying data for the reports and to export cleaned data.
  • Created indexes, optimizedSQLqueries and alter joins to improve the performance Scheduled the SSIS packages and Jobs.
  • Created many summary reports and rollup reports.
  • Developed many Tabular Reports, Matrix Reports, and Drill down Reports using SQL Server Reporting Services (SSRS).
  • Defined High Level Data Architecture for ETL & BI Solutions & Framework Design, Prototyping, ETL Loading Strategy Definition, Datastage, Data Governance & RDBMS standards definition and enforcement, Definition of Datastage Best Practices & Coding Standards.
  • Analyze user requirements, functional and technical specifications,preparing test plans.
  • Configured SSIS Package properties through XML file, Environment Variable, SQL Server table entries and deployed them to different environment such as Testing or UAT.
  • Developed Scheduled Jobs to automate the packages.
  • ImplementedEvent Handlersand Error HandlinginSSISpackages and notified process results to various user communities.
  • Experience with back up, restore, and recovery models.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Involved indesigning reportsanddeliveringthem by any of the delivery methods likestandard subscriptions,data-driven subscription,URL accessetc.
  • Deployed the generated reports directly on the client’s workstation.

Environment: SQL SERVER 2012, SQL Azure, Oracle, SSIS, SSRS, Erwin, Visual Studio 2012/2010, ASP.NET, T SQL, C#, PowerShell, XML, Team Foundation Server.

Confidential, Basking Ridge, NJ

SQL Server / SSIS Developer

Responsibilities:

  • DefinedIndexes, Views, Constraints and Triggers toimplement business rules.
  • Created complex and dynamic SQL queries using tablejoins (inner and outer), Stored Procedure and functions.
  • UtilizedT-SQLon a daily basis in creating customs view for data and business analysis.
  • Created package with different data sources (SQL Server, Flat Files, Excel files,etc.) and loaded the data into target tables by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
  • Successfully deployedSSISPackage into Production environment and usedPackage configuration to export various package properties to make package environment independent.
  • Developed Scheduled Jobs to automate the packages.
  • ImplementedEvent Handlersand Error HandlinginSSISpackages and notified process results to various user communities.
  • Worked extensively on investment model, equity data to retrieve valuable information through SQL queries (Complex Views, Dynamic Stored Procedures) and make valuable data available for reporting.
  • Worked with creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
  • Monitoringexecution plansto enhance the performance of the queries.
  • Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
  • Developed indexed views, complex stored procedures, effective triggers, and useful functionsto facilitateefficient data manipulation and consistent data storage.
  • Designing, developing, implementing, and maintaining reporting frameworks.
  • Created emailsubscriptionsfordata driven reportsby using Report Manager.
  • BuiltSSRSreports from various heterogeneous sources like SQL Server, Oracle.
  • Creating Parameterized Reports, Drill down, Drill through, Sub-reports usingSQL Server Reporting Services 2008.
  • CreatingAd-hocreports using Report Builder.
  • Done front end ASP.Net application bridging to the back-end Database systems.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition, SSIS, T-SQL, SSRS, C#, ASP.Net, Oracle 9i, Visual Studio, TFS.

Confidential

SQL Server Developer

Responsibilities:

  • Understanding of data modeling fundamentals and techniques.
  • Installation and configuration of SQL Server database.
  • Creation of databases & objects like tables, views, stores procedures and triggers.
  • Utilized various DBCC commands to ensure the database consistency.
  • Applied various Isolation Levels to lock the table rows from updating while it is being read by the specific user.
  • Performed database back-up and restore database to stand by server as part of disaster recovery plan (Log Shipping).
  • Migration of different versions of databases.
  • Performance analysis of SQL Server databases using SQL profiler.
  • Worked extensively on data transformation services (DTS) for transferring data between discrete data Source.
  • Worked extensively on SQL & Stored Procedures programming.
  • Worked extensively on BCP utilities for bulk data & image file uploading.
  • Developed quality assurance strategy and test plans.

Environment: SQL Server 2000, SQL Profiler, Data Transformation Services, and T-SQL.

Hire Now