Sql Server Data
Resume:
Mausami Patel
SQL Developer / BI Developer
Contact: 973-***-**** ***********@*****.***
PROFESSIONAL SUMMARY
* ***** ** ** ********** in design, development and testing of business/commercial applications
•
using MS SQL Server 2008/2005/2000in financial, insurance, manufacturing and health care industries.
Working knowledge of Software Development life Cycle (SDLC) and N tier Application Architecture.
•
Extensively used SSIS, SSAS& SSRS for various BI requirements.
•
Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2005 to
•
SQL server 2008.
Very Good Experience in Data warehouse Created star schema and snow flake schema data model and fill
•
data using ETL process using SQL Server integration service.
Created summary and details reports on Enterprise data warehouse data using SQL server reporting
•
service.
Created error handing for each data flow task to quickly figure out what failed in complex ETL packages.
•
Good understanding of Normalization /De normalization, Normal Form and database design methodology.
•
Worked with fully software development cycle for Business process.
•
Extensively experience in development of T SQL scripts, MS Integration Services, Stored Procedures and
•
views for business logic implementation, different kind of join to fetch the data from different table.
Created joins and sub queries for complex queries involving multiple tables.
•
Excellent knowledge in RDBMS concepts and Data warehouse Concepts.
•
Extensively worked in Data Modeling using Erwin.
•
Experience in Feeding data On OLTP and OLAT system using SQL server integration service.
•
Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS),Data Modeling like
•
Dimensional Data Modeling, Star Schema Modeling, snowflake schema Modeling and good understanding
about Fact and Dimensions.
Experience in query optimization & performance tuning.
•
Created Database and Database Objects like Tables, Stored Procedures, Views, user defined data types,
•
different kind of join to fetch the data from different server table And functions using T SQL queries.
Created Clustered, Non Clustered Indexes, table partitions and Indexed Views to improve the query
•
performance.
Strong troubleshooting and organizational skill, independent, self managing and teamwork and ability to work
•
in groups as well as independently with minimal supervision.
TECHNICAL SKILLS
Databases MS SQL SERVER 2008/2005/2000, MS Access 2003
Data Modeling MS Office 2007, Microsoft Visio, Erwin
Development Tools DTS, SSIS, SSAS, SSRS
Operating Systems Windows XP/2003/2000/NT
1
Database Tools SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, SQL Alerts,,
SQL Mail
PROFESSIONAL EXPERIENCE
Wellington Management, MA July’ 12 – Current
MS SQL Developer / BI Developer
Project Description: Currently working with Wellington Management data warehousing project to design and develop
new email reporting platform. The scope of the project was to design and develop Data Warehouse for Reporting
purpose. The goal of the project was to create reports for each associate at different organization and associate level.
The project was data warehousing project for long term reporting solution.
Responsibilities:
Created Data warehouse using Ralph Kimball Data warehousing methodology for long term Email
•
Reporting Solution.
Used Erwin/Visio for data modeling. Responsible for logical and physical design of Data warehouse
•
and ETL process.
Created Database and Database Objects like Tables, Stored Procedures, Views, Defaults and user
•
defined functions for data mart.
Created SSIS packages to load data from different source system such as CSV files, SQL server
•
2005 and Oracle 10g.
Created SSIS packages to load the data from Oracle source to staging server and from staging server
•
to Data warehouse.
Implemented common functionality in SSIS package templates such as common Event handling,
•
Error handling, event logging and package configuration etc.
Designed ETL packages which loads Reference data, to staging environment on daily bases and
•
sends Email to notify business users with detail information such as file name, number of record, date and
process time.
Used various Control flow tasks such as Execute SQL task, Send Mail Task, File System Task and
•
Dataflow Task. Used different Sources, Destinations and Dataflow components within Dataflow Task.
Developed the Slowly Changing Transformation to maintain the Historical Data.
•
Responsible for the validation of the aggregate data from the source system to DW.
•
Worked on Performance tuning of ETL process as well as SQL code used in Stored Procedure.
•
Used Team Foundation Server (TFS) for Versioning and Source Code Control.
•
Responsible for the migration of DTS Packaged from SQL 2000 to SQL 2008.
•
Maintained good working relationships with internal support teams and business users.
•
As a production support, monitoring every day’s ETL Process, and fixed the data issues.
•
Environment: Windows XP, SQL Server 2005/2008, MS Visio, MS BI Tools, Oracle 10g, MS office 2007.
AAA, NJ Jan’ 11 – July’ 12
SQL/BI developer
2
Project Description: I worked at AAA to create new Relational Data Management system (RDMS) for the AAA mid
atlantic to keep road side assistance drivers data with day wise activities and this New RDMS system aims to provide
better user Interface and provisions to create multiple Entities as per users request in single instance. I have created
Data Warehouse to load data from different source system using ETL process to support business requirement.
Responsibilities:
Experience in Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet),
•
MS SQL and oracle to MS SQL Server database by using SSIS services, BCP utility.
SQL Server 2008/2005 RDBMS database development using T SQL programming queries, stored
•
procedures, views and ETL.
Experience in creating SSIS packages using different type of task, with Error Handling on control
•
flow task and dataflow task, use logging to log the events and worked on package configuration to run
package on different server.
Sound Experience in creating static Dimensions called look up tables and dynamic Dimensions.
•
Experience in Error handling on Control flow task by using Send email task to send particular
•
developer and Users and on data flow task putting default dimensions in measures and have them to load on
enterprise data warehouse.
Used different transformation like Look up, Conditional split, data conversion, Aggregation,
•
Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
Experience in Delta load for Data warehouse after finish initially process full load using ETL
•
process.
Designed data model for data warehouse (logical and physical model) using star schema and
•
snowflake schema.
Worked on deploying SSIS packages on Development to QA to UAT to Production by using
•
Manifest file.
Worked on Discover, Design, Development and Deploy for Data warehouse cycle.
•
Worked on schedules job using SQL Agent.
•
Understanding about execution plan and estimated execution plan for poor performance query .
•
Created summary and details reports using SSRS, deployed them on report server for Users.
•
Created matrix reports, tabular reports, parameterize reports, drill down and drill thought for various
•
applications.
Environment: Windows XP, MS SQL Server 2005/2008, MS Visio, MS Visual Studio 2005/2008, MS office 2007.
NCQA, Washington, DC Oct’09 – Dec’10
SQL Database Developer, ETL SSIS
Project Description: The National Committee for Quality Assurance is a private not for profit organization dedicated to
improving health care quality. NCQA has helped to build consensus around important health care quality issues by
working with large employers, policymakers, doctors, patients and health plans to decide what’s important, how to
3
measure it, and how to promote improvement. I worked at NCQA as an ETL Developer to migrate data from OLTP
system to Data warehouse.
Responsibilities:
Experience in Extracting, Transforming and Loading (ETL) data from multi CSV files, XML to MS
•
SQL Server database by using SSIS services.
Worked on for each loop container and sequence container in SSIS control flow task.
•
SQL Server 2005 RDBMS database development using T SQL programming queries, stored
•
procedures, views.
ETL implementation using SQL Server Integration Services ( SSIS), Applying some business logic
•
and data cleaning that way ETL process after staging more clear and efficient .
Used CTE to maintain parent and child relationship.
•
Used SSIS functionality and capture error log for each steps of job in transaction audit table and
•
created SP for balancing purpose to make sure counts are correctly loaded.
Use different transformation controls like Look up, Conditional split, data conversion, Pivot, un pivot,
•
Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc. for different
purpose in ETL
Experienced in full load and Delta load in Data warehouse.
•
Worked on slowly changing dimensions in ETL Process.
•
Developing reports on reporting service in SQL Server (2005) and deploy then on report server for
•
user to do more analysis on data coming out of EDW.
Using SSRS creating well formed reports and web based reports for financial applications and
•
transactions.
Worked on Data warehouse Design and Implementation.
•
Taking weekly database backup and schedules job using SQL Agent set up notification and log file
•
in Agent.
Created joins and sub queries for complex queries involving multiple tables.
•
Environment: MS SQL Server 2005, Windows Server 2003/2000, ProClarity/PPS, MS Visual Studio 2005.
Kennametal, PA Oct‘08 – Sept‘09
SQL Server Developer
Project Description: Kennametal is a tooling supply manufacturing industry supporting multiple industry such
as aerospace, earth work heavy duty machine, energy, transportation, general engineering and machine tool
industry. The scope of the project was to generate reports for business analysis and data migration from
different sources.
Responsibilities:
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to
SQL Server.
4
Created packages in SSIS with error handling. Worked with different methods of logging and package
•
configuration in SSIS.
Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
•
Reported all events and requirements through established reporting mechanisms in SSRS.
•
Involved in Import/Exporting of Data to/from SQL database by using wizard.
•
Created Indexes and involved in Performance tuning.
•
Use SSIS and T SQL stored procedures to transfer data from OLTP databases to staging area and finally
•
transfer into data marts and performed action in XML.
Worked as a developer in creating complex Stored Procedures, triggers, tables, views and other SQL joins
•
and statements for applications.
Configure the report server and generated the report models for user interactions.
•
Developing reports on SSRS on SQL Server (2005). Using SSRS creating well formed reports and
•
web based reports for financial applications and transactions .
Worked on the Reports module of the project as a developer on MS SQL Server 2005 using SSRS. Generated
•
Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering,
adding interactivity, deploying reports to report server using SSRS.
Environment: SQL Server 2005/2000, MS Access, DTS, Erwin 4.1, SQL Query Analyze, SSRS, Crystal Report, SSIS.
Virtual Splat, India Oct’06 – July‘08
SQL Server Developer
Project Description: Virtual Splat is a software development company for different type of inventory management like
batch inventory, code inventory, unique inventory etc. In Network Marketing / Company has developed MLM software
from startup to corporate. In 10 years, Virtual Splat has developed almost 1000 MLM software with different plans.
Responsibilities:
Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules,
•
Defaults, user defined data types and functions.
Defined relationship between tables and enforced the referential integrity constraints. Created
•
Clustered and Non Clustered Indexes.
Responsible for General Database Administration, Query Performance tuning.
•
Partly Involved in Performance tuning.
•
Developed various management reports using Crystal reports.
•
Maintain the application as per the user requirement. Installed SQL Server on Windows 2000 Server.
•
Worked with DTS packages to load the massaged data into Data warehousing system.
•
Tuned the SQL queries using SQL profiler. Involved in tuning the database.
•
Data Migration from legacy to master screen using VB Script.
•
Used MS Visual Source Safe 6.0 as a Version Control System.
•
Environment: SQL Server 2000, asp.net, VB Script, Crystal Reports, Access, Excel
E D U CAT I O N
5
Bachelor of Engineering, Information Technology
Hi Tech institute of Technology, Maharashtra, India
6
Contact this candidate