Sql Server Data
Resume:
Hiral Jariwala
*****.*********@*****.***
Summary
Highly experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions. Adept at working on multiple projects simultaneously.
Extensive working experience in Installing, Configuring, Managing, Monitoring and Troubleshooting with SQL server versions 2014/2012/2008 R2/2005/2000 along with Server Reporting Services (SSRS), Server Integration Services (SSIS) and Server Analysis Services (SSAS), Failover Scenarios, Backups, Restore and Recovery.
Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Clustering (Indexes), User Defined Functions, Relational Database models and Data integrity, and SQL Joins.
Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
Experience in developing applications using ASP.NET MVC, ASP.NET Web Forms, LINQ and Windows Communication Foundation (WCF).
Experienced in Logical and Physical Database design & development, Data Cleansing, Data Conversion, Normalization and Data modeling using SQL Server Enterprise manager.
Worked on Data Modeling, Data Mapping and Data Interfacing.
Expertise in ETL (SSIS) and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
Expertise in using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS in BIDS.
Used MS access 2007 to Create SSIS Packages to import and export data from Excel Spreadsheets, Text file, MS Access and CSV (Comma Separated Values) files.
Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
Deep understanding of Software lifecycle development disciplines - Project Management, Requirements Management, Analysis & Design, Quality Assurance (Testing), Implementation, Deployment, Configuration and Change Management.
Technical Skills
Databases: Microsoft SQL Server 2014,2012, 2008 R2, 2005, 2000, MS Access
Application Tools:
Microsoft SQL Server Management Studio,
Query Analyzer,
SQL server Profiler,
Export and Import Wizard,
DTS,
Microsoft SQL Reporting Services (SSRS),
Microsoft SQL Server Integration Services (SSIS),
Windows MS-Office,
SFTP,
Visual Studio 2013/2015,
Agile Scrum,
Waterfall design,
Team Foundation Server 2013
Scripting: T-SQL
Web Development: ASP.Net MVC, LINQ, WCF, Silverlight, ASP, XML Web Service, AJAX
Education
Master of Science in Information technology and computer application [ MSc (IT & CA)]
Master in Computer Science
Microsoft Certified Technology Specialist in SQL server 2008, Database Development
SCRUM ALLIANCE® Certified Scrum Master®
Professional Experience
State of Maine, Maine
Department of Education, EPiCDev Group Jan ’11 to till date
Sr. Programmer Analyst 4
Projects Summary:
EPS (Essential Programs and Services Funding) is the module which collects the School and staff data from all the schools in Maine and converting whole UNIX system into the .Net (MVC) and SQL Server with use of SSIS and SSRS. EPS is the Part of EPiCDEV team, in which there are several interrelated Projects. Demo of work: http://www.maine.gov/doe/eps/ . It’s a Public report for Schools and SAUs of Maine. (From nov’11 to till date)
Maine Health Data Organization (MHDO) collects data from variety of sources, aggregates the data, and provides statics and other information based on that Data. The Project is to Health Care Inpatient and Outpatient Service Data which comes from different Hospitals in Text file format. Health Care Data needs to convert from text file to SQL Server with specific Requirements. (Jan’11 to Nov’11)
Responsibilities:
Successfully migrated more than 6 projects from Waterfall to Scrum within 6 months.
Working with Business and Users to understand the requirements, their Procedural Coding and analysis the system.
Facilitate scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)
Subscribe SQL Server Azure Cloud Services, create and manage Database(s) on SQL AZURE.
Implemented ASP.NET MVC pattern mechanism to display product catalogs and categories.
Implemented LINQ for querying, sorting, filtering the complex objects.
Protect team from over-commitment, manage backlog, and prioritize resolution of defects/bugs as evidenced by the on-time delivery.
Communicate with other management, engineers, product managers and support specialists on product issues.
Track and communicate team velocity and sprint/release progress.
Proven leadership skills, specifically leading by example (servant leader).
Assist the product owner with keeping the backlog groomed.
Manage, design and Create SSIS Packages, Complex Reports, Queries, Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application.
Migrate data from different data sources to SQL server.
Schedule monthly/weekly/daily reports and SSIS Packages which run automatically.
Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
Based on the requirements designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Dynamic sorting, defining data source, Ad hoc and Sub-reports using Global Variables, Expressions and Functions in Report Designer and Report Builder.
Developed Unit test cases, performed Unit of assigned components and involved in Inpatient and Outpatient Testing.
Performed production support for application.
Made packages for Auto Detection Files, Monthly Processing, File Naming, Purge and Posting health care data from Stage Database to Master Database.
Worked on Patient Medical Record Number and implemented Encryption logic for Patient Medical Record Number
Work with DBAs, and systems support personnel in elevating and automating successful code to production.
Designed and created Report templates, bar graphs and pie charts based on the financial data.
Environment:
SQL Server Management Studio 2008 R2/ 2012 / 2014, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, Microsoft Visual Studio 2013/2015, .Net MVC, TFS (Team Foundation Services) 2013, JIRA, Visio.
American Family Insurance Company, Madison, WI Feb ’09 to Dec ’10
Sr. Database Developer
Project Summary: The project was to create one unified customer database that will eliminate the data redundancy and provide one common place to view, retrieve and update customer information.
Responsibilities:
Created Complex T-SQL (DDL, DML) queries to meet the requirements.
Developed, implemented and maintained various database objects such as Stored Procedures, Cursors, Triggers, Functions, Indexes and Views.
Used XML and environmental variables in the package configuration for Deploying SSIS packages.
Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multidimensional Expression (MDX) to access them.
Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
Perform ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries.
Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel, Oracle, DB2) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
Applied various data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column.
Involved in Developing, Monitoring and Deploying SSIS packages to import and export data from Excel Spreadsheets, Text file, MS Access and CSV (Comma-Separated Value) files.
Designed and created Report templates, bar graphs and pie charts based on the financial data.
Scheduled the monthly/weekly/daily reports to run automatically.
Developed and implemented procedures to ensure the quality, usability and accuracy of reports, also performed migration using Microsoft SQL Migration Assistant (MSMA).
Deployed, designed and maintained of various reports in MS SQL Server environment using MS SSRS-2008/2005 in Business Intelligence Development Studio (BIDS).
Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
Deployed developed reports on to the Server for the end users.
Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
Designed individual physical structure of the business using .NET Framework and OLAP.
Performed daily tasks including backup and restore by using MS SQL Server 2008/2005 tools like MS SQL Server Management Studio, MS SQL Server Agent, and Database Engine Tuning Advisor.
Wrote Parameterized Queries for generating Tabular reports and Sub reports using global variable, expressions, functions, sorting the data, defining the data sources and subtotals for the reports using SSRS 2008.
Environment:
MS SQL Server 2005/2008, Microsoft Visual Studio 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008,
VB.NET, ASP.NET, NETFramework2.0, C#, SQL Server Analysis Services 2008, VB Enterprise Manager, SQL Server Management Studio (SSMS), Configuration Manager, Windows XP, Windows Server 2003
SkillNet Inc, Sunnyvale, CA Aug’07 to – Jan ‘09
Programmer Analyst
Project Summary: SkillNet is a consulting and technology services company that delivers transformative customer centricity and engagement solutions to global retail, government, and telecom organizations.
Responsibilities:
Installed SQL server 2008 on windows 2003 advanced servers, applied service packs and security fixes.
Extracted data from different sources like flat files, excel sheets, SQL server into staging environment.
Worked with OLTP to provide services and streaming informational display within the video conferences.
Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
Have done migration of database SQL server 2005 to 2008 successfully.
Developing triggers, stored procedures and enforcing business rules via checks and constraints.
Involved in implementing data mapping from DSS (Decision Support Services) to Data Warehouse.
Written complex SQL statements using joins, sub queries and correlated sub queries.
Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
Implemented ETL by creating several SSIS packages to load the historical and operational data using full load, merge as well as incremental loading
Responsible for designing ETL process, SSIS package.
Designed OLAP cube over data warehouse and deployed cube on SSIS server.
Created reports for budget and forecasting with use of excel and SSRS and configure with VB macros to deploy on SSRS server.
Wrote and integrated Stored Procedures to generate the Reports.
Designed and developed the ER Diagrams for the logical Database Model in Erwin data modeler.
Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
Designed and created Report templates, bar graphs and pie charts for analyzing data.
Based on the requirements designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Dynamic sorting, Defining data source, Ad hoc and Sub-reports using Global Variables, Expressions and Functions in Report Designer and Report Builder.
Environment:
MS SQL Server 2005/2000, T-SQL,SSIS, DTS, SSRS, SSAS, SQL Profiler, Business Objects, MS Visual Studio,SQL Profiler,EXCEL,VB, Windows 2003 Server, Visual Studio 2005,Windows XP.
Ethos Pvt. Ltd, Ahmedabad, India Feb’o05 to Oct’05
SQL Developer
Project Summary: Ethos Provide the staffing services, Out Sourcing of Man Power & People Development solutions to the corporate of different nature and locations. The company has its remarkable presence in various industries like Information Technology, Pharmaceuticals, steel, Cement, FMCG, Finance, Banking, Textile, and Services etc.
Responsibilities:
Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
Created Non-Clustered indexes to improve query performance and query optimization.
Involved in the performance tuning and optimization of T-SQL queries.
Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
Created ER diagrams using Visio.
Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
Involved in Normalization of the database and bringing it to 3NF.
Created Views to enforce security and data customization.
Developed user requested reports using Crystal Reports and Excel.
Created Drill down and Drill through reports using Crystal Reports.
Environment:
SQL Server 2000, Windows XP/2000, Crystal Reports, Excel
System plus Solution, Ahmedabad, India Jan’04 to Feb’05
Jr. SQL Developer
Project Summary: An ISO 9001:2008 Certified Business Solution provider, Systems plus Solutions drive business improvement through innovative, affordable solutions. System Plus offers a wide range of customized solutions through three service divisions, namely Business Consulting, Solutions Group and Oracle Applications. These solutions are driven by an operating policy that focuses on customer experience and sustainability. The project involved building a data warehouse from the existing database system using various ETL methods.
Responsibilities:
Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
Performance monitoring of Servers and Tuning SQL Code.
Involved in job scheduling using MS SQL server Agent.
Testing of applications for performance, data integrity and validation issues.
Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
Import Data from MS-Access Database and XML to SQL Server Database.
Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.
Created Users and Roles, and managed security and permission of database.
Involved in analyzing SQL Server Storage Structure, Index and Security Architecture.
Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
Created Users and Roles, and managed security and permission of database.
Involved in managing Jobs and Error logs.
Developed source to target specifications for Data Transformation Services.
Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source.
Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.
Environment: MS SQL Server 7/6.5, MS SQL Server 2000, Windows NT, DTS
Contact this candidate