I'm a developer who specializes in SQL Server Database development involving ETL process (SSIS/Power BI) and Data visualization (SSRS & Power BI). Experienced in developing software solutions using current standards and technologies for various industries, including healthcare and finance. Proficient in database development (SQL Server/SSIS/SSRS/Power BI), .NET Web & Windows application development, as well as in the complete lifecycle of software products including analysis, design, code development, debug, enhancement, testing, troubleshooting, integration, implementation, documentation, and on-call support. Dedicated professional willing to do what it takes to get the job done, who enjoys learning new programs and techniques. Excellent problem solving and negotiating skills. TECHNICAL SKILLS & EXPERIENCE: • ETL tools (SSIS/Power Bi) and strategies: 9+ years • RDBMS (MS SQL Server) and data warehouse development: 10+ years. • SQL Stored Procedures: 9+ years. • MS SQL Reports (SSRS) & Power BI: 8+ years. • C/S Applications Development (VB.NET/C#, VBScript, Java, Object-oriented programming): 8+ years. • Web Development (ASP.NET, C#, ADO.NET, HTML CSS, JavaScript, XML, Web Services): 7+ years. • Automation of manual jobs; SQL Server Agent: 6 years • Familiar with Agile methodology. • Good knowledge of Visual Studio, Team Foundation Server (TFS), Visual SourceSafe, JIRA, StarTeam, etc. • Working knowledge of HIPAA regulations and Medical Software Applications.…

Sn4FrLn

I'm a developer who specializes in SQL Server Database development involving ETL process (SSIS/Power BI) and Data visualization (SSRS & Power BI). Experienced in developing software solutions using current standards and technologies for various industries, including healthcare and finance. Proficient in database development (SQL Server/SSIS/SSRS/Power BI), .NET Web & Windows application development, as well as in the complete lifecycle of software products including analysis, design, code development, debug, enhancement, testing, troubleshooting, integration, implementation, documentation, and on-call support. Dedicated professional willing to do what it takes to get the job done, who enjoys learning new programs and techniques. Excellent problem solving and negotiating skills. TECHNICAL SKILLS & EXPERIENCE: • ETL tools (SSIS/Power Bi) and strategies: 9+ years • RDBMS (MS SQL Server) and data warehouse development: 10+ years. • SQL Stored Procedures: 9+ years. • MS SQL Reports (SSRS) & Power BI: 8+ years. • C/S Applications Development (VB.NET/C#, VBScript, Java, Object-oriented programming): 8+ years. • Web Development (ASP.NET, C#, ADO.NET, HTML CSS, JavaScript, XML, Web Services): 7+ years. • Automation of manual jobs; SQL Server Agent: 6 years • Familiar with Agile methodology. • Good knowledge of Visual Studio, Team Foundation Server (TFS), Visual SourceSafe, JIRA, StarTeam, etc. • Working knowledge of HIPAA regulations and Medical Software Applications.…

Available to hire
credit-card $250 per day ($31.25 per hour)

I’m a developer who specializes in SQL Server Database development involving ETL process (SSIS/Power BI) and Data visualization (SSRS & Power BI).

Experienced in developing software solutions using current standards and technologies for various industries, including healthcare and finance. Proficient in database development (SQL Server/SSIS/SSRS/Power BI), .NET Web & Windows application development, as well as in the complete lifecycle of software products including analysis, design, code development, debug, enhancement, testing, troubleshooting, integration, implementation, documentation, and on-call support. Dedicated professional willing to do what it takes to get the job done, who enjoys learning new programs and techniques. Excellent problem solving and negotiating skills.

TECHNICAL SKILLS & EXPERIENCE:
• ETL tools (SSIS/Power Bi) and strategies: 9+ years
• RDBMS (MS SQL Server) and data warehouse development: 10+ years.
• SQL Stored Procedures: 9+ years.
• MS SQL Reports (SSRS) & Power BI: 8+ years.
• C/S Applications Development (VB.NET/C#, VBScript, Java, Object-oriented programming): 8+ years.
• Web Development (ASP.NET, C#, ADO.NET, HTML CSS, JavaScript, XML, Web Services): 7+ years.
• Automation of manual jobs; SQL Server Agent: 6 years
• Familiar with Agile methodology.
• Good knowledge of Visual Studio, Team Foundation Server (TFS), Visual SourceSafe, JIRA, StarTeam, etc.
• Working knowledge of HIPAA regulations and Medical Software Applications.

See more

Skills

Da
Data Visualization
ET
ETL
Mi
Microsoft Office
Mi
Microsoft SQL

Experience Level

Data Visualization
Expert
ETL
Expert
Microsoft Office
Expert
Microsoft SQL
Expert

Language

English
Fluent

Education

Ph. D. at PennState University, PA, USA
July 31, 1991
Science
Master of Science at Saurashtra University
November 23, 1980
Science

Qualifications

FREELANCE DEVELOPER
January 2, 2024 - April 15, 2024
• Developed, enhanced, modified, and deployed SSIS packages and SSRS reports. • The ETL process involved extracting data from CSV files using SSIS packages and loading to tables after validation; SSRS to generate Excel reports. SQL Server jobs were used for automating the program. • Created/altered and scheduled subscriptions; the reports were delivered by email or file Share, using Excel or PDF formats. • Used Power BI to connect to data sources, import/transform data; build data models; wrote DAX expressions for accurate data analysis and reporting. • Developed visual reports, KPI scorecards and dashboards in Power BI; created calculated columns and measures using DAX to enable meaningful analysis. • Using Power BI, created analytic tools to provide key business performance metrics, historical trends, or benchmarks.
SENIOR DEVELOPER / ETL Developer
January 1, 2008 - December 29, 2023
• Designed, developed, tested, and deployed new or modified ETL programs (SQL/SSIS) for EDI, to load inbound data files to our database and create outbound files for sending to clients. • Created and modified stored procedures, functions and other SQL database objects that assist in the implementation of business logic • Monitored and performed troubleshooting SQL jobs and related applications in a timely manner. • Improved performance of some ETL apps for high-risk clients - bringing down the total processing time from days to hours. • Developed Power BI dashboards, which provide leadership with actionable insights that drive critical business decisions. • Fulfilled various urgent ad-hoc, CMS Audit report requests, to ensure timely distribution to various the clients. • Developed and implemented complex SSIS/DTS packages for ETL work during applications interface integration. Coordinated tasks with DBAs and server administrators, for implementation and the smooth completion of the project. • Responsible for setting up automatic transmission of data from our SQL server to NSQIP database. Java/VB scripts, Stored Procedures, SSIS packages and SQL Server Jobs were used to facilitate the process. • Created/enhanced SQL reports (SSRS); participated in deploying them and resolving issues in Production environment. • Supported various .NET apps and data services in production, being a member of the 24/7 on-call support team. • Working with the BWH Surgery Apps group, designed, developed, and deployed .NET Web apps (SQL database) to collect H&P, Brief Op-Notes, and other patient information. Got the H&P up and running within 2-3 months I joined PHS. • Participated in migrating VB6 code to C#.NET for an Endoscopy scheduling project. • Assisted members in our team to move projects from VSS to TFS; gave them training and demo in TFS migration. • Excellent verbal/written communication, negotiation, and management skills, having abilities to prioritize multiple tasks.
SENIOR SOFTWARE CONSULTANT
June 1, 2006 - December 28, 2007
• Worked as a Consultant (Ciber, Inc). Helped to setup the SQL Server Job scheduling tool, ESP. It is an event-driven, cross platform Job Scheduling solution that gives a single point of control across environments, providing real-time automation. • Integrated the vendor app ESP with John Hancock’s workflow to process hundreds of SQL Server jobs seamlessly. • Developed Stored Procedures and DTS packages; prepared documents to support the SDLC process. • Developed and implemented Reports (Crystal Reports & SQL Reports) for various business requirements. • Build Window Services in .NET to automate ongoing business process. • Created Web apps using ASP.NET 2.0 (Visual Studio 2005, XML, JavaScript) for a file conversion program.

Industry Experience

Healthcare, Financial Services, Software & Internet, Computers & Electronics
    uniE613 Data visualization using Power BI
    Developed Power BI dashboards to provide leadership with actionable insights that drive critical business decisions.…
    uniE613 ETL-SSIS Data Transformation
    To ingest data from inbound files, transform and load it to a SQL Server Database.…