We provide IT Staff Augmentation Services!

Msbi/t-sql Developer Resume

White Plains, Ny

SUMMARY:

  • Has been working as MS SQL Application/Data Warehouse developer with experience of 8+ years in development, analysis, administration, database migrations, reporting analysis and data base maintenance.
  • Expertise in the implementation of MS SQL Server 2000/ 2005/2008/2012 /2014/2016 Infrastructure.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
  • Expertise in using SQL reporting tools with SQL Server 2000, SQL Server 2005 and SQL Server 2008/2012/2014/2016.
  • Deploy/Design OLAP cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTE’s, Cursors, Views, Indexes, Triggers and Functions.
  • Possess good knowledge on UNIX and Hadoop Echo Systems (Hive).
  • Experienced working on Claims Data & Claims Reporting.
  • Experienced working on Crystal Reports for Data Warehouse applications.
  • Experienced working on Tax processing system for BI applications as a Team Lead.
  • Experienced working on HRIS Payroll OLTP Databases for ETL operations.
  • Experienced in Using Facets UMI Web Service to load or update Pharmacy Prior Authorization data into Facets.
  • Experienced in using Team Foundation Server (TFS) as Repository for Reports by deploying them on to it using Visual Studio 2012.
  • Experienced working on Oracle to SQL Server migration.
  • Experienced working on migrating claims data from Oracle Premia to HSP (Health Solutions Plus) MediTrack.
  • Experienced in writing C# code for Implementing ETL operations.
  • Expertise in developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of the products to various developments.
  • Good knowledge of configuration management concepts, release management, changes management concepts, Industry standards and best practices.
  • Migrating and Tuning SQL scripts, indexes, stored procedures and views Fine tuning and optimization of SQL queries and Stored procedures using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updated statistics
  • Several years of innovative and resourceful work with strong administration, analysis, design, development, testing, presentation and implementation experience using SQL Server Databases, Windows 7/8/ NT/ 2000/2003/2008/2008 R2/2012/2012R2/2016 and Windows XP.

TECHNICAL SKILLS:

Language: SQL, PL/SQL, My SQL, Transact SQL, JAVA, VBA, Teradata SQL Assistant

Tools: SQL SERVER 2000/ 2005/2008/2012 /2014/2016, SQL Enterprise Manager, SQL Server Data Tools, SQL Profiler, Hive, Query Analyzer, TFS, ERWIN, Analysis Manager DTS Import/Export Wizard, Tableau, SSIS, SQL Reporting Services (SSRS), Tortoise SVN, BO, JIRA, SAP BO Crystal software, Redgate

Applications: Microsoft Office, Excel, Adobe Photoshop, Acrobat reader /writer, PUTTY

OS: Windows NT/ 95/98/2000/2003/2008 R2/2012R2/2016/XP/7/8, Unix

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

MSBI/T-SQL Developer

Responsibilities:

  • Designed multiple stored procedures for the report data sources.
  • Designed, developed various SSRS reports for PayPal PDE data which involves Merchant Transactions and Merchant Actives.
  • Interacted with the business users to gather information about the report.
  • Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, CTE’s, Views, Constraints, Cursors with best execution plan in SSMS to implement the business logic for PayPal PDE process.
  • Worked on Report Migration to move SSRS reports from Argus Environment to PayPal PDE environment.
  • All RDL files have been downloaded from Argus environment and re-configured in BI and re-uploaded to PayPal PDE environment and changed the data sources accordingly before Go-live
  • Designed ETL SSIS packages involving PayPal business logic to generate CSV files for Merchant Transactions and Merchant Actives PayPal PDE data.
  • Used WinSCP client to transfer CSV files to SFTP Server.
  • Designed a data pattern such that the data moves from PayPal PDE to Hadoop File System through SFTP Server
  • Scheduled and monitored these data pull jobs via UC4 job scheduler.
  • Created databases, tables, views on Hive to load Merchant Insights and MIS PayPal PDE data into Hadoop File System.
  • Created process on Impala Hive that copies data between two clusters using distcp tool and used MSCK statements to populate Merchant Transaction tables on Hive.
  • Used PuTTY application to access UNIX terminal from Windows operating system.
  • Created automation scripts using Unix Shell Scripting to move data into Hadoop File System.
  • Used SVN Tortoise as the S ource C ontrol R epository for PayPal PDE data.
  • Experienced in writing Queries using Teradata SQL Assistant to load data into PayPal LookAhead Application.
  • Worked on Data Validation to check whether the PayPal data pulled from different sources has the expected values in a given domain.
  • Assisting Data Quality team in writing queries using Teradata SQL Assistant to check quality of the data.
  • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned tasks.
  • Experienced working on production support during code deployment.
  • Reviewed many T-SQL issues using management studio for better performance and working on performance tuning for slow running queries using Profiler.
  • Experienced in writing UAT scripts for code deployment on Development, Staging, and Production environments.

Environment: SQL Server 2008R 2/2012/2014/2016, SSRS 2014, SSIS 2014, T-SQL, Hive .13, Hadoop, PuTTY, UNIX, Teradata SQL Assistant, WinSCP, Windows 7, SQL Server Data Tools

Confidential, Linthicum Heights, MD

SQL BI Developer/ Analyst

Responsibilities:

  • Loading large volume of raw claims data involving CPT codes, member, and provider data from Oracle 11g to SQL server 2014 staging tables.
  • Developed cross functional systems to ensure consistency across claims during this migration.
  • Writing various stored procedures to convert raw claims header, details, diagnosis data to move to HSP system.
  • Designed ETL SSIS packages to generate CSV files for each header, details, and diagnosis files for various Healthcare plans.
  • Experienced in uploading Claims data for various healthcare plans into HSP MediTrac system for client purpose.
  • Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, Triggers, CTE’s, Views, Constraints with best execution plan in SSMS to implement the business logic for loading claims to HSP MediTrac system.
  • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
  • Used TFS (Team Foundation Server) as the source control repository.
  • Worked on performance tuning of slow running queries.
  • Experienced in using the HSP Web Service to look for Claims data for Database applications.
  • Experienced in Loading CPT (Current Procedural Terminology) codes from SQL Server staging tables to Conversion tables using SSIS packages.
  • Interacted with the business users to gather information to design reports on Claims data for various healthcare plans.
  • Worked on SSMA tool with which the raw data has been pulled into SQL tables from Oracle tables.

Environment: SQL Server 2014, SSRS 2014, SSIS 2014, SAP BO Crystal Software, SharePoint 2013, Excel, T-SQL, Windows 7, SQL Server Data Tools, Visual Studio 2016

Confidential, Herndon, VA

SQL Database Specialist/ Analyst

Responsibilities:

  • Created various T-SQL scripts for RDBMS applications of CMS Obama care project.
  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, Triggers, CTE’s, Views, Constraints with best execution plan in SSMS to implement the business logic for Call Center Processing (CPC) tools to enroll customers for the best health care insurance plan.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and scheduling the packages in the environment (Development, Staging, and Production).
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
  • Involved in writing complex SQL code for delivering Daily and Weekly Deceased Consumer extracts to Client using SSIS packages for SQL Database and also involved in designing and scheduling ETL packages to copy Client files from one location to another location to Initiate EFT (Electronic File Transfer) process.
  • Monitor the SQL server Agent jobs and fix the jobs on failure.
  • Involved in developing various Sub Reports, Drill down, Parameterized reports using SQL Server Reporting Services (SSRS) for sending Daily and Weekly reports to CMS for Health Insurance data for deceased customers.
  • Involved in monitoring and tuning report performance by analyzing the execution plan of the report and also involved in deployment and unit testing of requested Reports.
  • Involved in scheduling reports to run hourly, daily, weekly, monthly based on the data to be reviewed by the users.
  • Used Redgate SQL Compare to compare SQL Server Schemas.
  • Created email subscriptions for data driven reports by using Report Manager.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Experienced in writing Stored Procedures for inconsistencies extract related to health care insurance enrollment process to prepare OC (Office of Communication) files to CMS weekly and provide Good Faith Extension to the eligible customers by sending Notices.
  • Involved in creating SharePoint list on SharePoint 2013 site from an Excel Spreadsheet. Used SharePoint as a Repository.
  • Experienced in loading data into CPC Training Environment using ETL packages to train ESW workers on how to use CPC tools.
  • Experienced in writing UAT scripts for code deployment on Development, Staging, and Production environments.
  • Experienced working on production support during code deployment.
  • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
  • Successfully implemented database connectivity from front end.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.
  • Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
  • Involved in creating backups and restore of the databases.

Environment: SQL Server 2014, SSRS 2014, SSIS 2014, SharePoint 2013, Excel, Redgate, T-SQL, Windows 7, SQL Server Data Tools, Visual Studio 2010

Confidential, Richmond, VA

SQL Server Developer/ SSIS/SSRS Developer

Responsibilities:

  • Created T-SQL scripts for RDBMS applications of VCU-Health System.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
  • Experienced in writing Stored Procedures for ETL Operations.
  • Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation.
  • Experienced in loading HRIS Payroll data into relational database using ETL tool.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Experienced working on performance tuning of slow running queries that update the HRIS system.
  • Worked on Development and P roduction S upport for various databases, DTS and SSIS 2012 packages.
  • Managed SSIS and DTS packages quality assurance.
  • Monitor the SQL Server Agent Jobs and fix the jobs on failure.
  • Experienced in using Ultipro BackOffice tool for accessing data for BI applications.
  • Interacted with the business users to gather information about the report.
  • Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012).
  • Designed multiple stored procedures for the Report data sources.
  • Designed, developed various custom reports for the product.
  • Experienced in accessing data from SaaS environment for BI applications.
  • Used IBM Lotus Notes for file sharing, feeds, email for HRIS data applications.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Develop cross validation rules to ensure mapping accuracy.
  • Designed, analyzed and upgraded databases.
  • Experienced in migrating database objects from SQL 2012 to 2014 environment.
  • Provide regular project updates to Information Analysts and management as needed.
  • Communicate issues, risks, and concerns proactively to management.
  • Worked with business users to understand metric definitions, presentation, and usage needs.
  • Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
  • Created and maintained User’s Security Permissions and Migration of the database objects from one server to another server.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Environment: SQL Server 2014/2012, SSRS 2012, SSIS 2012, Excel, IBM Lotus Notes, T-SQL, Windows 2000/XP, SQL Server DataTools, Visual Studio 2010, Saas, UltiproBackoffice

Confidential, Virginia Beach, VA

SQL Server Developer/ SSIS/SSRS Developer

Responsibilities:

  • Created T-SQL scripts for RDBMS applications.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
  • Written SQL queries to generate Letter/Fax templates to members and providers with the fields that populate from the internal database.
  • Uploaded Letter/Fax Templates to Dev, QA & Prod using Pharmacy Prior Authorization tool by determining Source and Template keys by using SQL queries.
  • Used JIRA to capture, organize team’s issues and to follow team activity during QA and Prod Deployment.
  • Used SVN Tortoise as the S ource C ontrol R epository.
  • Experienced in writing Stored Procedures for ETL Operations.
  • Experienced in loading data into relational database using ETL tool.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Experienced working on performance tuning on slow running queries.
  • Development and production support for various databases, DTS and SSIS 2012 packages.
  • Experienced in loading/updating the Prior Authorization data into Facets.
  • Experienced in using the Facets UMI Web Service to look for Prior Authorization data for Database applications.
  • Experienced in Loading ICD-9 and ICD-10 codes from Excel files to SQL Server tables.
  • Managed SSIS and DTS packages quality assurance.
  • Monitor the Tidal Scheduler Jobs and fix the jobs on failure.
  • Interacted with the business users to gather information about the report.
  • Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012).
  • Designed multiple stored procedures for the Report data sources.
  • Designed, developed various custom R eports for the product.
  • Involved in monitoring system performance by using SQL Profiler, Database Engine Tuning Advisor, and Windows performance monitor, Event Viewer, Dynamic Management Views, and Resource Governor to achieve better performance.
  • Experienced in writing UAT scripts for code deployment.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Designed, analyzed and upgraded databases.
  • Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
  • Created and maintained User’s Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Environment: SQL Server 2012, SSRS 2012, SSIS 2012, Tidal, TortoiseSVN, Excel, T-SQL, Windows 2000/XP, Visual studio, JIRA

Confidential, Jefferson City, MO

SSRS Developer-Team Lead

Responsibilities:

  • Designed multiple stored procedures for the report data sources.
  • Designed, developed various custom reports for the product.
  • Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services.
  • Interacted with the business users to gather information about the report.
  • Used TFS as the source control repository. Checked-in/checked out all the report projects from TFS.
  • Experienced working on production support during code deployment.
  • Conducted training session/demo to other users. Showed them how to create reports, projects and related.
  • Reviewed many T-SQL issues using management studio for better performance and working on performance tuning for slow running queries using Profiler.
  • Maintenance of security standards, facilitate requirements and gathering meetings with clients.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Designed Graphical and Tablix reports using SSRS.
  • Experienced working on Tableau Software for designing Dashboards and deploying them onto TFS.
  • Experienced Deploying Database Objects using Visual Studio 2012.
  • Created SSRS reports based on PowerPivot, PowerView and published onto SharePoint.
  • Designed Reports which take data from Teradata database.
  • Extensively used VB Scripts for Report development.
  • Schedule and resolve the issues during the BI development.
  • Programmed SQL Server 2008 Reporting Services using Microsoft Visual Studio 2008.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Created monthly reports using reporting wizard with Visual Studio.
  • Assign Reports to Report Folders in SQL Reporting Services.
  • Involved in Scheduling backups and maintenance.
  • Optimized SQL queries for improved performance and availability.
  • Reorganize database structures as needed, automate procedures at regular intervals.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
  • Used Redgate SQL Data Compare to deploy database changes.
  • Designed, analyzed and upgraded databases.
  • Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
  • Successfully implemented database connectivity from front end.
  • Actively participated in interacting with different departments regarding their access to the database system and creating views to facilitate the same.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.
  • Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.

Environment: SQL Server 2005/2008/2012, SSRS, TFS, PowerPivot, Excel, Tableau, Redgate,Visual Studio 2012, T-SQL, PL/SQL, MS Access, SSRS Windows 2000/XP, Visual studio2005.

Confidential, Tinley Park, IL

SQL Server Developer/ BI Developer

Responsibilities:

  • Experienced in writing Stored Procedures for RDBMS applications.
  • Experienced in loading data into relational database using ETL tool.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
  • Experienced working on Object-Relational Mapping (ORM) for RDBMS applications.
  • Maintenance of security standards, facilitate requirements and gathering meetings with clients.
  • Created Stored Procedures for report processing.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Experienced working with MS SQL Server 2005 Service Broker for Database applications.
  • Experienced in writing C# code for Implementing ETL operations.
  • Experienced in designing Data warehouse applications.
  • Experienced working on XML for web applications.
  • Experienced in using BO for Universe designing and reporting.
  • Experienced in writing PL/SQL code for Implementing ETL operations.
  • Generated various reports according to business requirements using Reporting Services.
  • Experienced in developing Graphical and Tablix reports using SSRS.
  • Created SSRS reports based on PowerPivot and published onto SharePoint.
  • Experienced in writing Unix Shell Scripts.
  • Experienced in using VB Scripts for Report development.
  • Experienced in working on logical and physical data modeling.
  • Used Informatica tool for extracting the source data and loading it into the target after applying the required transformation.
  • Update the SSRS reports with different location and period hierarchy.
  • Development and production support for various databases, DTS and SSIS packages.
  • Managed SSIS and DTS packages quality assurance.
  • Monitor the SQL server Agent jobs and fix the jobs on failure.
  • Experienced in writing My SQL code for Data warehousing applications to manipulate data in SQL Azure database.
  • Schedule and resolve the issues during the BI development of data warehouse operations.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
  • Experienced working on CRM(Customer Relationship Management) for Business Applications.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Experienced working on QA testing.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures
  • Programmed SQL Server 2008 Reporting Services using Microsoft Visual Studio 2005.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Created monthly reports using reporting wizard with Visual Studio
  • Experienced working on DB2 database for ETL operations. Moved database objects from DB2 to SQL Server Database.
  • Assign Reports to Report Folders in SQL Reporting Services
  • Involved in Scheduling backups and maintenance.
  • Create backups and restore of the databases.
  • Used data conversions to convert different data types
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
  • Optimized SQL queries for improved performance and availability
  • Reorganize database structures as needed, automate procedures at regular intervals.
  • Creating and Maintaining all types of Backups and recovery strategies and set up jobs
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training
  • Designed, analyzed and upgraded databases.
  • Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
  • Successfully implemented database connectivity from front end
  • Used VBA for BI applications.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Performed analysis as per business requirements using SSAS
  • Deploy/Design OLAP cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Actively participated in interacting with different departments regarding their access to the database system and creating views to facilitate the same.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.
  • Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.

Environment: SQL Server 2005/2008/2012, Reporting Services, BO, Excel, TSQL, ASP.NET, PL/SQL, MS Access, SSIS, SSRS, SSAS, Windows 2000/XP, Visual studio2005

Confidential, St Louis, MO

SQL Server Developer/ Data Warehouse Developer

Responsibilities:

  • Created T-SQL scripts for RDBMS applications.
  • Experienced in Warehouse Management System in controlling the movement and storage of materials within a warehouse.
  • Experienced in using Data Marts as a repository for BI applications.
  • Experienced in loading data into relational database using ETL tool.
  • Generated various reports according to business requirements using crystal reports.
  • Design and create the tables, store procedures, triggers, indexes basing on requirements.
  • Experienced working on XML for web applications.
  • Experienced working with offshore team.
  • Experienced in using BO for Universe designing and reporting.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Experienced in writing PL/SQL code for Implementing ETL operations.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
  • Used Informatica tool for extracting the source data and loading it into the target after applying the required transformation.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Resolve the issues during the BI development of data warehouse operations.
  • Maintenance of security standards, facilitate requirements and gathering meetings with clients.
  • Created Stored Procedures for report processing.
  • Experienced working with MS SQL Server 2005 Service Broker for Database applications.
  • Created reports with complex calculation fields.
  • Generated reports by using Crystal Reports and Excel spreadsheets.
  • Used VBA for Reporting services.
  • Experienced in developing Graphical and Tablix reports using SSRS.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
  • Participated in production support for code deployment.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Created monthly reports using reporting wizard with Visual Studio.
  • Experienced working on QA testing.
  • Performed analysis as per business requirements using SSAS
  • Deploy/Design OLAP cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Experienced in creating and scheduling ETL packages that update OLAP cubes in the Data Mart.
  • Assign Reports to Report Folders in SQL Reporting Services.
  • Optimized long running Stored Procedures & queries for effective data retrieval.
  • Performed and analyzed the calculations for various KPI of the company.
  • Actively participated in interacting with different departments regarding their access to the database system and creating views to facilitate the same.
  • Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Environment: SQL Server 2005/2008, Crystal Reporting Services, BO, Query Analyzer, Excel

Confidential, MISSISSIPPI, MS

SQL Server Developer/ ETL Developer

Responsibilities:

  • Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity for BI and OLTP operations.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
  • Experienced in loading data into relational database using ETL tool.
  • Performed migration of data from Oracle to SQL server using SSIS. In SSIS packages written PL SQL code to bring data to SQL server destination.
  • Worked with SSIS to design the packages for ETL Support.
  • Generated T-SQL scripts for application development.
  • Created Stored Procedures and User Defined functions.
  • Created Indexes to speed up the queries.
  • Design many tables for efficient performance of applications and data pull.
  • Create roles and permissions for the data warehouse applications.
  • Moving and promoting the data from development to production.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures.
  • Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Performed Migration of databases from SQL 2000 to SQL2005 using SSIS
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
  • Scheduling Jobs and Alerting using SQL Server Agent
  • Involved in ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005, Query Analyzer, Excel (pivot tables) SSIS, SSRS, T-SQL, Visual studio2005, Windows 2000/XP

Hire Now