PROFESSIONAL SUMMARY:

• Highly skilled and motivated IT professional for more than 7 Years of experience in Health care, Retail, e - commerce & Trading sectors as SQL server Developer dat includes Database Design & Development, Implementation.
• Expertise in writing T-SQL Queries, DDL, DML, Dynamic-queries, CTE’s, subqueries and complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive experience in ETL design/development using SQL Server Integration Services (SSIS).
• Well Experienced in designing and developing parameterized reports, Drop down list, Cascaded, Linked, Drill-through and Drill-down reports using SQL Server Reporting Services (SSRS) & IBM Cognos Reports wif Prompts & Events.
• Experienced in Full SDLC requirements analysis, design, development, unit testing, deployment & support specifically waterfall and Agile Scrum Methodology.
• Basic Web development experience wif HTML5/CSS3, JavaScript, Visual Basic & Visual C#.

TECHNICAL SKILLS:

Programming Languages & Scripts: T-SQL, PL/SQL, PostgreSQL, Visual Basic, Visual C#, .NET, C, C++, HTML5/CSS3, JAVA, JavaScript

Database Tools: BIDS, SSMS, Visual Studio, SSDT, TFS, SQL Profiler.

RDBMS: MS SQL Server 2005/2008/2008R2/2012/2014/2016, DB2, Access, SQL Server Developer.

BI Tools: SSIS, SSRS, IBM Cognos Report 10 and Cognos Analytics, ADP Reporting (ADPR), Informatica.

Applications: Microsoft Office 2000/2003/2007/2010/2013/2016, Service now.

Operating systems: Windows Vista/7/8/8.1/10, macOS, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential - Virginia

PDM Analyst

Responsibilities:

• Designed and maintained application by using T-SQL & PL/SQL.
• Wrote Complex Stored Procedures, Functions, CTE’s and User-defined Functions.
• Performed database queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Constantly met deadlines and requirements for all production work orders.
• Responsible to load the Providers Data into Facets tool For Arkansas, Colorado, Texas, Florida & California.
• Formulated procedures for data extraction, transformation and Integration of health care data into GBD Facets.
• Used T-SQL Queries & SQL Server Management Studio to validate the data loaded after each load.
• Involved in creating & updating the Providers data upon the requests.
• Executed test cases using T-SQL for the regression testing and updated the status for each test case.

Environment: SQL Server Management Studio (SSMS) 2016, SQL Server data tools 2016 SSIS, SQL Developer 3.2.0 and Waterfall Methodology.

Confidential - Texas

HRIS SQL BI & Cognos Report Developer

Responsibilities:

• Created Scripts to Handle the Dual Maintenance for Migration of HR Systems.
• Produced data files from ADP and delivered to UltiPro via Parallel1, paralle2 & Parallel 3.
• Handled all the challenges faced while translating the data from ADP to Ultipro.
• Involved in validating the data between 2 HR systems using SSIS & Created Source to target mapping and ETL Design for integration of new/ modified data into the new HR System.
• Created SSRS and Cognos Reports & Events for Users & Employees.
• Supported ServiceNow Incidents, Requests & Tasks.
• Imported and exported data using BCP & Bulk Insert & Pivot Functionality.
• Used SSIS to import the data and validating the data.
• Involved in Bulk insert and BCP of data to and from SFTP to upload & download files from SFTP - WinSCP
• Created scripts for 3rd party client (Interfaces) called J.J. Keller, LPMS, Sedgwick, Dearborn and OC Tanner.
• Used TFS as source control.
• Created ADPR’s to Load the data from ADP HR Systems and Scheduled Reports, Jobs to run as per the requirement.
• Created Dynamic SQL Scripts to build SQL Statements Dynamically at runtime.
• Involved in solving User logging issues like SSO & User Administration to handled Activation of accounts.
• Created reports for HRIS, Payroll, Benefits, HRBP, Ethics & Compliance, and IT & Learning & Development Departments.
• Created New Job Codes & Job Groups as per the User’s Requirement.

Environment: SQL Server Management Studio (SSMS) 2012/2014/2016, ADP reporting, IBM Cognos Report Studio, SQL Server data tools 2014 SSIS, SQL Server Data Tools 2014 SSRS, Visual C# Scripting, SSDT 2014 TFS Source Control, Service Now and Windows 10, Agile Scrum Methodology.

Confidential Prairie-Minneapolis

SQL BI Report Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries wif best execution plan.
• Wrote T-SQL Queries and utilized best practices in designing complex reports in crystal reports and Microsoft Reporting Services.
• Wrote T-SQL queries and utilized best practices in designing complex reports in Crystal Reports and Microsoft Reporting Services.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Used TFS to save code and packages, also to move code to different environments like Test and Production
• Generated Business Reports and Customer/Shipping Invoices (MS SQL/Crystal Reports 11/Excel)
• Created and used Temp tables to load data from staging environments based on business requirements
• Performed unit tests and reviewed wif other team members to make sure work is rigorously designed, elegantly coded, and effectively tuned for performance.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Loaded data from various Sources to SQL Server database using SSIS Package and created data mappings to load the data from source to destination.
• Involved in updating the SSIS packages from 2008R2 to 2012. Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Environment: SQL Server Management Studio (SSMS) 2005/2008/2008R2/2012/2014/2016, Crystal Reports, Business Intelligence data tools 2005 for SSIS, Sql Server Data Tools 2008/2010 for SSRS, Visual C# Scripting, VB.Net, SSDT 2010 TFS Source Control and Windows 10, Agile Scrum Methodology.

Confidential - Missouri

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Formulated and Documented the physical ETL Process design on business requirements and system specifications wif strong ETL Design Skills including source to target mappings, transformations, lookups, aggregations, expressions.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Used C# & VB Scripting in Script task for an SSIS packages.
• Involved in updating the packages from 2005 to upgrade versions.
• Scheduled tasks to run every day to update changes in the base tables
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Designed and developed various complex reports & Performed Unit testing and bug Fixing.
• Used SQL dialect converts the query which we write any other object-oriented program to the specific database SQL.
• Coded PL/SQL Subprograms and modified the existing PL/SQL Program units for customer contact Employees (CCE’s) Relationships.

Environment: Microsoft SQL Server Management Studio (SSMS)2005/2008(R2), Windows 8, Windows XP, Microsoft Visio, SSIS, SSRS, C# & VB Scripting and SharePoint designer, Waterfall.

Confidential Plano-TX

SQL Server & BI Developer

Responsibilities:

• Designing the tables and their relationships according to the business needs.
• Creating SSIS packages to collect data from various sources like the Active Directory, SQL Server databases on different servers from all business units.
• Creating functions, complex stored procedures using dynamic SQL queries for the .net and SharePoint pages on the portal.
• Successfully implemented physical database on MS SQL Server 2005. Supported complex relationship using triggers.
• Wrote the queries for the drill down reports, Identified and added the report parameters.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Responsible for analyzing requirements, prototyping data analysis solutions, developing and unit testing solutions, and facilitating solution deployment and support
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs.

Environment: MS SQL Server Management Studio (SSMS) 2008, T-SQL, DTS, Windows 7, MS Visio, MS Projects, Waterfall Methodology.