Msbi/t-sql Developer Resume
Mechanicsburg, PA
PROFESSIONAL SUMMARY
- 7 years of IT experience as SQL Server Developer, Teradata SQL and Oracle PL/SQL in Health, Financial, Educational, Food & Beverage, Public Sector Domains.
- Experienced in analysis, design, development and implementation of Data Warehouse & Business Intelligence systems.
- Exhibits interest to work on new projects, presents creative ideas towards success of teh project.
- TEMPHas been working as MS SQL Application/ Data Warehouse developer wif experience of 7 years in development, analysis, database migrations, reporting analysis and database maintenance.
- Expert in teh 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.
- Expert in using SQL Reporting tools wif SQL Server 2000, SQL Server 2005 and SQL Server 2008/2012/2014/2016.
- Strong Transact-SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTE’s, Cursors, Views, Indexes, Triggers and Functions.
- Experienced working on SAP BO Crystal Software for Data Warehouse applications.
- Possess good noledge on UNIX and Hadoop Echo Systems (Hive).
- Experienced working on migrating data from Oracle Premia to SQL Server.
- Experienced in writing C# code for Implementing ETL operations.
- Experienced in writing validation queries using Teradata SQL Assistant
- 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
- Experienced in writing UAT scripts for code deployment on Development, Staging, and Production environments.
- Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
- Worked wif plan administrators to research and resolve data issues and troubleshoot system problems/outages.
- 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 teh data from Text files to SQL Server and vice versa.
- 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.
- Involved in ER diagrams (Physical and Logical using ERWIN) and mapping teh data into database objects.
- Actively participated in interacting wif different departments regarding their access to teh database system and creating views to facilitate teh same.
- Worked under Agile Methodology and performed decisive role in developing and planning as well as coordinating wif assigned tasks.
- Good noledge of configuration management concepts, release management, changes management concepts, Industry standards and best practices.
- Expertise in developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of teh products to various developments.
- Experienced in writing validation queries using Teradata SQL Assistant.
TECHNICAL SKILLS
Language: SQL, PL/SQL, My SQL, Transact SQL (T-SQL), VB, Teradata SQL Assistant
Tools: SSMS, SSRS, SSAS, SSIS, SSDT, Visual studio, SSIS, SSRS, JIRA, SAP BO Crystal software, Toad, SharePoint, Redgate, SQL Profiler, Query Analyzer, TFS, Tortoise SVN Version Control, GitHub, ERWIN
Applications: Microsoft Office, Excel, Adobe Photoshop, Acrobat reader /writer, PUTTY
OS: Windows NT/95/98/2000/2003/2008R2/2012R2/2016/XP/7/8, Unix
PROFESSIONAL EXPERIENCE
Confidential, Mechanicsburg, PA
MSBI/T-SQL Developer
Responsibilities:
- Worked wif Data Analyst team and DBA to build T-SQL, SSRS and /or SSIS solutions.
- Generate data profiling reports to help facilitate wif data cleansing effort by conducting JAD sessions and analyze teh data for data integrity using a data-profiling tool.
- Define Data mappings to identify teh translation and mappings from teh source systems data elements to teh IE Worker Portal data elements.
- Design and development of ETL SSIS packages to load Legacy data into IE Worker Portal SQL tables to access Data from Integrated Eligibility Application Portal.
- Write SQL validation code to define rules at teh data-source level and table-column level to help ensure teh accuracy and integrity of teh data that will be loaded into teh Worker Portal.
- Create SSRS Reports to show data elements that do not pass teh defined validation rules for each legacy system per every clean-up execution cycle.
- Develop and direct database System Integration testing and validation procedures, programming, and documentation.
- Review and troubleshoot T-SQL issues using management studio for better performance.
- Used GitHub as a Repository for source code, Reports and ETL SSIS packages.
Environment: SQL Server 2016, SSRS 2016, SSIS 2016, Excel, T-SQL, Windows 7, SQL Server Data Tools, Visual Studio 2015
Confidential, White Plains, NY
MSBI/T-SQL Developer
Responsibilities:
- Interacted wif teh business users to gather information to design, develop, and migrate various SSRS reports from Confidential Environment to PayPal PDE environment for PayPal PDE data which involves Merchant Transactions and Merchant Actives.
- Designed ETL SSIS packages involving PayPal business logic to generate CSV files for Merchant Transactions and Merchant Actives PayPal PDE data and used WinSCP client to transfer CSV files to SFTP Server.
- Designed a data pattern such that teh data moves from PayPal PDE to Hadoop File System through SFTP Server by creating databases, tables, views on Hive to load Merchant Insights and MIS PayPal PDE data into Hadoop File System.
- Used PuTTY application to access UNIX terminal from Windows operating system and worked on creating process on Impala Hive that copies data between two clusters using distcp tool and used MSCK statements to populate Merchant Transaction tables on Hive.
- Scheduled and monitored data pull jobs via UC4 job scheduler by creating automation scripts using Unix Shell Scripting to move data into Hadoop File System.
- Experienced in writing Queries using Teradata SQL Assistant to load data into PayPal LookAhead Application and assisted Data Quality team to check whether teh PayPal data pulled from different sources TEMPhas teh expected values in a given domain.
- Used SVN Tortoise as teh Source Control Repository for PayPal PDE data
Environment: SQL Server 2016, SSRS 2016, SSIS 2016, 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:
- Developed cross functional systems to ensure consistency across claims during migration of loading large volume of raw claims data for various healthcare plans involving CPT (Current Procedural Terminology) codes, member, and provider data from Oracle 11g to SQL server 2014 staging tables.
- Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, Triggers, CTE’s, Views, Constraints wif best execution plan in SSMS to implement teh business logic for loading claims to HSP MediTrac system.
- Designed Crystal Reports using SAP BO Crystal Software for BI applications to present Claims data information that includes various metrics to teh client for Data Analysis and used Microsoft SQL Server 2014 as teh back end database for Crystal Reports.
- Designed ETL SSIS packages to generate CSV files for each header, details, and diagnosis files for various Healthcare plans.
- Worked on SSMA tool wif which teh raw data TEMPhas been pulled into SQL tables from Oracle tables.
- Experienced in using teh HSP Web Service to look for Claims data for Database applications.
- Used TFS (Team Foundation Server) as teh source control repository.
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
SQL Database Specialist/ Analyst
Confidential
Responsibilities:
- Worked wif Data Analyst team and business users to build RDBMS applications of CMS Obama Care project to implement teh business logic for Call Center Processing (CPC) tools to enroll customers for teh best health care insurance plan.
- 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.
- 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.
- 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 teh eligible customers by sending Notices.
- Experienced in loading data into CPC Training Environment using ETL packages, BCP, Bulk Insert to train ESW workers on how to use CPC tools and successfully implemented database connectivity from front end.
- Used Redgate SQL Compare to compare SQL Server Schemas.
- Experienced in writing UAT scripts for code deployment on Development, Staging, and Production environments.
- Involved in creating SharePoint list on SharePoint 2013 site from an Excel Spreadsheet. Used SharePoint as a Repository.
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:
- Worked wif business users to understand metric definitions, presentation, and usage needs for ETL Operations of VCU-Health System’s HRIS Payroll data.
- Experienced working on performance tuning of slow running queries that update teh HRIS system.
- Developed cross validation rules to ensure mapping accuracy and migrating database objects from SQL 2012 to 2014 environment.
- Used Ultipro BackOffice tool and SaaS environment for accessing data for BI applications.
- Used IBM Lotus Notes for file sharing, feeds, email for HRIS data applications.
- Provide regular project updates and communicated issues, risks, and concerns proactively to Information Analysts and management
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:
- Worked wif business users to gather requirements for analysis, design, development, deployment and user training for Pharmacy Prior Authorization data.
- Written SQL queries to generate Letter/Fax templates to members and providers wif teh fields that populate from teh internal database and uploaded these templates to Dev, QA & Prod using Pharmacy Prior Authorization tool by determining Source and Template keys.
- Experienced in loading/updating teh Pharmacy Prior Authorization data into Facets and used teh 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 using ETL SSIS 2012 packages and managed SSIS packages quality assurance.
- Monitor teh Tidal Scheduler Jobs and fix teh jobs on failure.
- Designed multiple stored procedures for teh report data sources and created numerous sub reports, drill down reports as part of teh project according to business requirements using Reporting Services (SSRS 2012).
- Experienced in writing UAT scripts for code deployment
- Used JIRA to capture, organize team’s issues and to follow team activity during QA and Prod Deployment. Used SVN Tortoise as teh Source Control Repository.
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:
- Interacted wif teh business users to gather information about teh Tax processing system for BI applications.
- Designed multiple stored procedures for teh report data sources and created numerous sub reports, drill down reports, custom reports as part of teh project according to business requirements using Reporting Services.
- Created Graphical and Tablix SSRS reports based on PowerPivot, PowerView and published onto SharePoint. Used VB Scripts and complex expressions to filter and parameterize, and format teh contents of a report.
- Used TFS as teh source control repository. Checked-in/checked out all teh report projects from TFS.
- 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.
- Reorganize database structures as needed, automate procedures at regular intervals.
- Used Redgate SQL Data Compare to deploy database changes.
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:
- Written T-SQL Stored Procedures for RDBMS applications.
- Used Performance Monitor & SQL Profiler to optimize queries and reviewed many T-SQL issues using SQL Server Management Studio (SSMS) for better performance.
- Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
- Written basic customized C# code for Implementing ETL operations.
- Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
- Generated numerous reports according to business requirements using Reporting Services (SSRS) and published onto SharePoint.
- Written My SQL code for Data warehousing applications to manipulate data in SQL Azure database.
- Created backups and restore of teh databases.
- Scheduling Jobs and Alerting using SQL Server Agent.
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 Data Warehouse Management System in controlling teh movement and storage of materials wifin a warehouse.
- Experienced in using Data Marts as a repository for BI applications to analyze teh calculations for various KPIs of teh company.
- Created stored procedures, triggers, indexes to generate various reports according to business requirements using Crystal Reports application.
- Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables for Reports.
- Experienced in loading data into relational database using ETL tool.
- Used Performance Monitor & SQL Profiler to optimize queries and reviewed many T-SQL issues using SQL Server Management Studio (SSMS) for better performance.
- Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
- Experienced in interacting wif offshore team and participated in teh production support for code deployment.
Environment: SQL Server 2005/2008, Crystal Reporting Services, BO,Query Analyzer, Excel