We provide IT Staff Augmentation Services!

Sr. Ms Bi/ssis/ssrs/sql Server Developer / Lead Resume

PA

SUMMARY:

  • 11+ years of Professional Experience in Design, Development, Implémentation and Migration using Confidential SQL Server 2000/2008/ R2/ 2012.
  • Hand - on experience on multiple databases like Oracle and MSSQL Sever.
  • Experience on Data Ware Housing tools like SQL BI
  • Exposure in Telecom, HealthCare, Sales and Insurance domains
  • Experience in Application / Production Support using C#, VB.Net and ASP.Net
  • Excellent skills in implementing ETL Packages using SSIS 2008 R2/2012.
  • Extensive experience in MS SQL Server 2012/2008/2008 R2/2005, Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
  • Highly proficient in the use of T-SQL for developing stored procedures, triggers, tables, user defined functions, relational database models and data integrity, SQL joins.
  • Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data and SQL server Integration Services.
  • Involved in designing and developing more than 100+ enterprise reports (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 2005/2008/2012 .
  • Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
  • Involved in Maintenance and Deployment of SSIS Packages.
  • Design, deployment and maintenance of various SSRS in SQL Server 2005/2008/2012 .
  • Proficient in implementing all transformations available on the SSIS toolbox.
  • Experience in creating master and child packages, package configurations and logging.
  • Excellent knowledge of using variables and expressions in packages.
  • Experience in writing C# scripts in script component task.
  • Migrated DTS packages to SSIS and modified using DTS editor wizard.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP and XML).

TECHNICAL SKILLS:

Operating Systems: Windows 8, 7, Windows Vista, Windows XP, Windows 2003, Unix, Linux

RDBMS/DBMS: MS-SQL Server 2012/2008R2/2005/2000, SQL Server Azure, Oracle, Sybase

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (SSIS/SSRS/SSAS),Reporting Services Configuration Tool, Data Transformation Services, SQL Server Profiler, SQL Server Agent

IDE Tools: SSDT 2012, Visual Studio 2017/2013/2010

Reporting Tools: LOGI Reporting Tool, SSRS, Excel Pivot, Excel Power Pivot, Microstrategy

Programming Languages: C#, VB.Net, ASP.Net and .Net Framework

Query Languages: T-SQL, PL/SQL

Business Tools: Word, Excel, Power Point, Outlook, Visio

Version Controlling: Confidential Team Foundation Server, VSS

Testing Tools: Confidential Test Suite (MTS)

Other Tools: JIRA

PROFESSIONAL EXPERIENCE:

Confidential, PA

Sr. MS BI/SSIS/SSRS/SQL Server Developer / Lead

Role & Responsibilities:

  • Converted the legacy sequential SQL job to parallel processing using SSIS and reduced the execution time to 50%
  • Worked on Data migration from SQL Server to Windows Azure cloud environment.
  • Converted existing legacy reports to Microstrategy Reports
  • Tuning the SQL Agent job and SSIS packages
  • Performance Tuning
  • Worked on the requirement involving C#, VB.Net and ASP.Net
  • Production Support
  • Bug fixing raised by QA and Clients
  • Troubleshooting and Fixed the bugs using c#, VB.Net, ASP.Net etc
  • Creating the SSIS packages for a smooth data flow across different servers
  • T-SQL coding for creating procedures and other database objects.
  • At the staging server, data was loaded from different sources like flat delimited text files, and Excel spreadsheets to the SQL Server database tables and from SQL server database to output flat files, pipe (|) delimited HL7 messages.
  • Extensively used store procedures and UDF functions such as scalar and inline functions for complex queries, Triggers, indexes involving multiple tables from different databases.
  • Worked on Evaluation of SSIS packages and did error handling.
  • Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
  • Designed, Created and deployed Reports into LOGI Reporting tool
  • Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting.
  • Interacted with the existing database developers and DBA to understand the existing schema.
  • Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
  • SQL Jobs monitoring and troubleshooting.

Environment: MS SQL Server 2012, MS SQL Server Integration Service, T-SQL, Windows 8, Visual Studio 2013, SSDT BI 2012, TFS, Logi Reporting Tool

Confidential, VA

Sr. MS BI/SSIS/SSRS/SQL Server Developer / Lead

Role & Responsibilities:

  • Converting functional requirements into technical specification document.
  • Analysis, Design, Coding, Testing, Deployment and Production support & Maintenance.
  • Preparing Unit Test cases and execution.
  • Working the benefit calculation of the products purchased under the Entitlement Management component
  • Creating the SSIS packages for a smooth data flow across different servers
  • T-sql coding for creating procedures and other database objects.
  • Extensively used store procedures and UDF functions such as scalar and inline functions for complex queries, Triggers, indexes involving multiple tables from different databases.
  • Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
  • Migrated SQL server 2000 DTS packages to 2008 SSIS packages.
  • Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting.
  • Interacted with Strategic Development Team, Business analyst and Nurse Managers to analyze business needs and developed technical specifications.
  • Interacted with the existing database developers and DBA to understand the existing schema.
  • Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
  • SQL Jobs monitoring and troubleshooting.

Environment: MS SQL Server 2012,2008 R2, MS SQL Server Integration Service, MS SQL Server Reporting Services, T-SQL, Windows 8, Visual Studio 2010/2012/2013

Confidential, WI

MS BI Developer/SSIS/SQL Server Developer

Role & Responsibilities:

  • Migrating the database from SQL Server R2
  • Migrating DTS packages to SSIS
  • Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Management Studio.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
  • Configure the SSIS Package for run time Parameters and Configuration file.
  • Created store procedures to calculate net return and Gross return of the Funds.
  • Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.
  • Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation.
  • Developed the Mailing Label Reports for the management by using the Crystal Reports.
  • Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
  • Creating dynamic Stored Procedures for Reporting in SSRS.
  • Maintained scheduling of subscription reports with the subscription report wizard.
  • Handling the errors during data moving and Sequencing the task as per requirements.
  • Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front end application.

Environment: MS SQL Server 2005/2012, MS SQL Server Integration Service, MS SQL Server Reporting Services, Windows XP.

Confidential, VA

MS BI Developer

Role & Responsibilities:

  • Working and Designing the Report in SSRS, Excel pivot and Excel Power pivot.
  • Designing the database objects like tables and stored procedures.
  • Writing the quires for reporting.
  • Developing SSIS ETL packages to pull data from different sources based on requirements and best practices.
  • Delivering tasks to schedule.
  • Accurately documenting all work in a timely manner
  • Interacted with business analyst, Development Team and Managers to analyze business needs and developed technical specifications.
  • Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, fuzzy lookups, and multicasting.
  • Created Standard, Couple Cross Tabs in Crystal reports for the Nurse Manager.
  • Created and developed Parameterized, Drill Down, sub and linked reports and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS).
  • Developed database objects such as Joins, Union All, Sub-Queries, procedures, Functions, Triggers, and Indexes using T-SQL, SQL Analyzer and SQL Server Management Studio.
  • Created various complex reports for the different department by using Crystal reports 10.
  • Data was loaded from different sources like flat delimited text files, CSV and Excel spreadsheets to the SQL Server database tables.
  • Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, Derived column, Slowly Changing Dimension mechanism in different environments.
  • Created staging environment in SQL 2008 for the data migration from different heterogeneous sources (CSV, Excel).

Environment: MS SQL Server 2012/2008R2, Excel Pivot, Power Pivot, MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Services, T-SQL, Visual Studio 2013/2010/2008, XML, TFS and SSMS.

Confidential, WA

Sr. SQL Developer

Role & Responsibilities:

  • Actively involved in different stages of Project Life Cycle.
  • Documented the data flow and the relationships between various entities.
  • Actively participated in gathering of User Requirement and System Specification.
  • Created new Database logical and Physical Design to fit the new business requirement and implemented the same using SQL Server.
  • Created Clustered and Non-Clustered Indexes for improved performance.
  • Created Tables, Views and Indexes on the Database, Roles and maintained Database Users.
  • Followed and maintained standards and best practices in database development.
  • Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
  • Provided assistance to development teams on Tuning Data, Indexes and Queries.
  • Data migration (import & export - BCP) from Text to SQL Server.
  • Developed new Stored Procedures, Functions, and Triggers.
  • Implemented Backup and Recovery of the databases.
  • Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: Windows 7, Server 2008, MS SQL Server 2008 R2, SQL BI-SSIS, Windows 2005 adv. server, Windows 2000/XP, MS SQL Server 2008, .NET, IIS, MS Visual Studio.

Confidential, WA

Sr. SQL Developer

Role & Responsibilities:

  • Monitored all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Using T-SQL statements, worked with DML and DDL for retrieval and modification of the data.
  • Created & used stored procedures for database transactions in SQL Server.
  • Developed backup & restore scripts for SQL Server as needed.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler and creating index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: Unix, Oracle 9i, SQL Server 2005, SSIS, Win 2000/XP, Toad, Query Analyzer, Windows server 2000, SQL server Profiler, T-SQL.

Confidential, WA

SQL Developer

Role & Responsibilities:

  • Developing the Data Validation framework in the Oracle Database and SQL Server.
  • Validating the data against some set of pre-defined rules.
  • Writing the code for stored procedures and functions to validate the data.
  • Creating the validation report at the end of each validation.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
  • Upload data in database by using SSIS & DTS package (Flat Files, HTML files and SQL Server).
  • Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
  • Data migration (import & export - BCP) from Text to SQL Server.
  • Created Triggers to enforce data and referential integrity.
  • Created and executed SSIS packages to populate data from the various data sources
  • Created packages for different data loading operations for many applications
  • Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
  • Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
  • To setup, implement, and maintain industry standards in database management.
  • Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: MS SQL server 2000, 2005, Unix, Oracle 9i, win 2003/xp, SSIS, Query Analyzer, Windows server 2000, SQL server Profiler, T-SQL, MS Access.

Hire Now