Sql Server Developer
Resume:
JAG WALIA
********@*****.*** 214-***-**** Dallas/Fort-Worth, Texas https://www.linkedin.com/in/jagwalia IT LEADER and APPLICATION/SQL DEVELOPER
IT Management Leader and Application Developer with over 20 years of experience in software development, leading and motivating others to maximize productivity while forming cohesive environments and building strong client relationships, automated solutions to improve processes and drive cost savings. SQL SERVER/AZURE SKILLS
• Highly motivated SQL Server developer with over 10 years of experience in SQL Server Performance Tuning, SQL Server configuration, best practices, Database, architecture and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2014-2000, SSIS/SSAS and SSRS.
• Expert in writing complex optimized SQL queries, stored procedures, functions, triggers, jobs, automation, troubleshooting issues.
• Experience in Physical, Logical design, development (using Erwin, Redgate, normalization/de-normalization and SSMS), Coding, Debugging, Testing, Deployment, Support and Maintenance, Replication.
• Experience in partitioning large table into multiple physical files to enhance performance.
• Database Full Backup, differential backup & Transaction log backup.
• Expert in optimizing the queries, clustered indexes, non-clustered indexes and indexed views, Query Plan, DMV, DMF, TRACEON, SQL Profiler/Active Monitor, Linked server, FTP transfer, understand data fragmentation and table on heap.
• Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), email notifications and alerts, SSIS for REST/SOAP service calls and emails.
• Experience in creating various type of reports such as Complex drill down, Sub reports, Charts using (SSRS).
• Knowledge and experience of software development life cycle, database design, RDBMS, data warehousing and data modelling.
• Experience building Azure Infrastructure as-a-Service (IaaS) virtual network for Active Directory VM Server with availability set, VM for Secured FTP Server connected to AD, VM Windows server 2012 for SQL Server 2016 Enterprise edition connected to AD, VM Web Server 2016 connected to AD.
• Experience building Azure Logical SQL Server, Elastic Pool, Elastic SQL Databases (PaaS), Availability set, data migrating on Premise SQL Database to Azure.
OTHER TECHNICAL SKILLS
• Project Management
• Database Architecture
• Team Management
• Software Engineering
• Project Design, Architecture
• Lead Cross-functional Teams
• Change Management
• Azure/Cloud Technology, IaaS/SaaS/PaaS
• IoT Technology
• Monolithic/Microservices Architecture
• Data Warehousing, Business Intelligence
• SQL Server Developer/Admin, SSIS, SSRS
• AJAX, REST/SOAP APIs, JavaScript, JSON
• C#, ASP.NET, Classic ASP, Java
• IBM Websphere eCommerce
• SOX Audit
• PCI Compliance
• Agile
• Quality Assurance
• TFS
• NoSQL (MongoDB)
PROFESSIONAL EXPERIENCE
PLAN2ACCOUNT INC. N.C. 2017 – 2017
Contractor
• Helped Plan2Account setting-up Azure Infrastructure as-a-Service (IaaS) virtual network for Active Directory VM Server with availability set, VM for Secured FTP Server connected to AD, VM Windows server 2012 for SQL Server 2016 Enterprise edition connected to AD with high availability, VM Web Server 2016 connected to AD.
• Set-up Azure Elastic Database Pool, Elastic SQL Databases (PaaS), Availability set, data migrating on Premise SQL Database to Azure. Saved Plan2Account about 40k year for paying for SCE/SA and SQL Server licenses for hosting database for each client on isolated server. BEAUTICONTROL INC. (Tupperware Brands), Carrollton, Texas 2011 – 2017 Application/SQL Developer Lead
• Resolved website and SQL Server performance issues with isolation level, indexes, and script optimization that was causing locks. This resolution fixed 95% of website issues, and freed-up Call Center, IT and Helpdesk’s time that was keeping them busy with the complaints and troubleshooting.
• Successfully supported SQL Administration and Web Developers by creating the database backup maintenance jobs, reviewing and optimizing other developer’s scripts, index rebuilds and index stats, test DR backups.
• Successfully implemented process automation for various projects/tasks and reduced IT involvement to save time and resources using REST APIs, SSIS for integrating application with third party (IBM Silverpop, LMS, ByDesign) for single sign-on, email processing, maintaining historical data and SSRS reporting. JAG WALIA
********@*****.*** 214-***-**** Page 2
BEAUTICONTROL INC. (Continued)
• Provided analytical reports to business by building Data Warehouse using star schema, and managed Data Warehouse Server, SSRS/SSAS, and ETL/SSIS solutions for multiple data sources like AS400, DB2 and SQL Server to gather data for fact and dimension tables.
• Introduced new templates, policies and standards for SQL Server stored procedures, functions, triggers, queries, web coding, and processes for batter SQL Performance to avoid locks and SQL injections.
• Managed SQL Server Database with over 400GB in size and over 400+ tables, and partitioned large table into multiple physical files to enhance performance.
• Responsible for software development, application maintenance, managing multiple concurrent projects using Agile, project prioritization, and process improvements, change management, process automation and mass email processing, managing eCommerce, database servers and websites to support about 100k salesforce across US/Canada with revenue over 5 to 8 million a month. GLOBAL CARE NETWORK INC. (Healthcare Services), Dallas, Texas 2008 – 2011 Development Lead/Manager
• Implemented and managed SQL Server databases, SQL processes, and web applications for large healthcare billing and collection system, EMR and healthcare clearing house that were being offered to clients as SaaS.
• Managed, collaborated and mentored overseas and domestic development teams.
• Reduced resource cost to 60% by setting up off shore development team, and call center team for insurance and patient follow-up.
AMERICAN CARESOURCE INC. (Healthcare Services), Dallas, Texas 2001 – 2008 Lead Developer
• Delivered and managed web applications with SQL Server (2000/2005) as a back-end that included 25k+ ancillary providers around United States with their fee schedule contracts and healthcare claims, automated claim repricing process as per provider and payer contracts.
• Reduced manual adjudication cost up to 70% with SQL process automation for claim processing.
• Responsible for software development, system analysis, and project design, including SQL Server DBA tasks, SSIS, and SSRS, EDI 837, 835, and 997 for multiple payers, ETL, DTS/SSIS processes and SSRS reports, data modeling, data warehouse.
PREVIOUS PROFESSIONAL EXPERIENCE
Sr. Developer, IDS-INFOTECH INDIA LIMITED
Designed, co-developed, and managed litigation document coding and imaging software for the filing, retrieval, and reporting of litigation documents. The project supported a multi-user environment with a workload of more than 100 concurrent users in a 24/7 shift.
Developer, INSYS SOFTWARE
Developed and implemented several projects for hotels and restaurants around India and integrated them with a financial accounting system. Additionally, developed and implemented a management system for Colgate distributors and manufacturing Industries.
Developer, EM PEE ELECTRONICS
Developed billing and storing inventory management software for the manufacturing Industry, comprised of inward/outward material, QC, production issues, jobs, purchase returns and orders, rejections, and stock registers. EDUCATION
Bachelor’s Degree, Government College, Chandigarh, India CERTIFICATES & CERTIFICATIONS
Post-Graduation, Computer Applications from I.C.T., India Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Developer (MCSD)
Websphere eCommerce development and admin course
Brainbench Certified
Contact this candidate