Sql Server Data

SRUSHTI PATEL

Phone: 609-***-****

PROFESSIONAL SUMMARY

Over 8 years of professional experience in design, development and maintenance of Database using tools of MS SQL Server [2014/2012/2008R2/2005] as a BI Developer and 8 years of IT experience in design, development & analysis along with SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS with expertise on ETL process.

Experience in Creating Databases based on Functional Requirements and System Design.

Working knowledge of Software Development Life Cycle (SDLC) and N-tier Application Architecture.

Good understanding of Normalization /De-normalization, Normal Form and database design methodology.

T-SQL coding for different objects like Function, Views, Triggers, Cursers, and Stored Procedures.

Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance. Hands on experience in Column stored indexes.

Excellent in Design of ETL SSIS Packages for integrating data using different connection managers from heterogeneous sources like (SQL SERVER, Oracle, Excel, CSV, XML, flat files) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.

Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.

Experience in Data warehouse created star schema and snowflakes schema data model and load data using ETL process using SQL server integration Service (SSIS).

Expert in designing different Report layout and have extensive experience in generating Drill down and Drill through as well as Slice and Dice reports with Drop down menu option, sorting the data, Sub reports defining subtotals in SSRS 2005/2008/2008R2/2012.

Proficiency in creating Ad-hoc Reports, Cascaded, Matrix, Pie Chart Reports and Tabular Reports for different business domains depending on the specifications and requests.

Experience in integrating the SSRS reports into web applications using report viewer control and URL methods and creating data driven subscriptions to different users using Report Manager.

Good knowledge of Data Marts, Data warehousing, and operational data store (ODS), data modeling such as Dimensional, star schema, snowflakes and good understanding of Facts and dimensions.

Experience with Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2012/ 2008.

Experience in Cube designing in BIDS (SSAS) and to edit various properties including the measure groups and measures, cube dimensions and dimension relationships.

Experience in calculating measures and dimension members using multi-dimensional expression (MDX), creating data source views, named queries, mathematical formulas and user-defined functions in SSAS, and deploying of analysis services projects.

Experience in software development life cycle in all phases

Excellent verbal and written communication skills combined with interpersonal, organizational and conflict resolution skills as well as strong analytical skills.

Technical Skills

Databases

MS SQL server 2000/2005/2008/2012, Oracle, Teradata, MS Access

Tools

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services.

Languages

Transact- SQL, SQL, C, C#,HTML

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS.

Reporting Tools

SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.

SQL Server Tools

SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Data Modeling Tools

Erwin tool, Microsoft Visio

Operating Systems

Windows server 2003, Windows 2000 advanced server/professional, Windows NT, Windows XP professional /standard, Windows 7 and UNIX.

Other Tools

Microsoft Visual Source Safe, Team foundation Server, Microsoft Office

Education

Gujrat technological University, Gujrat, India

Bachelor of computer engineering

Work experience

Goldman Sachs, Jersey City, NJ Aug 2014 – Till Date Sr. SQL Server SSRS/SSIS Developer

The Goldman Sachs Group, Inc. is an American multinational investment banking firm that engages in global investment banking, investment, securities and other financial services primarily with institutional clients. The project is to create different SSIS Packages and to generate the reports using SSRS for various Business Units. Worked on end to end creation of Reporting solutions using SSIS, T-SQL SSRS.

Responsibilities:

Worked on 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.

Used different transformation controls like Look up, Conditional split, data conversion, un-pivot, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments. Maintain existing ETL processes and trouble shoot issues as they arise.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files. Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).

Used various Transformations in SSIS Dataflow, Control Flow using for Loop Containers and Fuzzy Lookups, etc.

Created SSIS packages for data conversion using Data Conversion Transformation.

Created package configurations for dynamic connection strings to enhance the ease of package deployment. Implemented Event Handlers and Error Handling in SSIS packages.

Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.

Created SSRS report model projects and created, modified and managed various report models with multiple model objects, source fields and expressions.

Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

Experience in writing expressions in SSRS and Expert in fine tuning the reports.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.

Defined Key Performance Indicator in SSAS Cubes in order to define these in scorecards.

Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

Defined Calculated measures and SETS using multi-dimensional expression (MDX).

Optimized queries by using Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), C#, Microsoft Office SharePoint Server, XML, MS Visual Source Safe.

Bank Of America, Texas Mar 2013 – Jul 2014 SQL Server SSRS/SSIS Developer

Bank of America is an American multinational banking and financial services corporation. It has a retail banking footprint that serves approximately 50 million consumer and small business relationships at 5,151 banking centers and 16,259 automated teller machines (ATM). The aim of the project was to design and develop Enterprise Data warehouse and migrate the data from different sources into the databases using SSIS and generating customer profile reports and customer transaction reports using SSRS.

Responsibilities:

Analyzing business requirements and built logical data models that describe all the data and relationships between the data.

Developed Stored Procedures, Functions, Tables, Views, Triggers, Cursors, User Defined Functions, other T-SQL code and SQL joins for applications to handle large amount of data manipulation.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS 2008.

Used SQL server profiler and execution plans to enhance performance of stored procedures and views.

Created Dimension, Fact and Aggregated Tables and referential integrity (or) Relations between them using TSQL.

Developing reports using SQL Server Reporting Services and creating various types of reports like Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Writing expressions in SSRS and fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Used 2008 BIDS and 2012 Data tools for developing reports and deploying reports in SSRS.

Involved in legacy historical data conversion from existing ODS & DW tables to new ODS & DW tables. ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).

Designed and developed ETL processes using Data Stage designer to load data from Sources like MS SQL Server, Flat Files (Fixed Width) and XML files to Targets like Flat Files, MS SQL Server etc.

Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

Handled tasks of building, deploying and maintaining metadata inventories and data support tools.

Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards.

Extensively worked in OLTP systems and partially on OLAP systems. Within Snow flake and Star schemas.

Environment: SQL Server 2014/2012 Enterprise Edition, Team Foundation Server, SQL BI Suite (SSAS, SSIS, SSRS), XML, MS Access 2003 & Windows Server 2008, Visio, Erwin, Advanced Excel, Power Pivot, Power View, Tableau, Time Viewer.

PNC, Pittsburgh, PA Oct 2011 - Feb 2013

MS SQL Server Developer/SSIS/SSAS Developer

PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities. It also provides deposit, lending, cash management and investment services to more than 5 million consumer and small business customers. The project dealt with Analysis and design of the System that involved multiple databases which contained product, customer information, from which the investment growth of the customers was derived in the form of reports which were useful to track the progress, this report was send to the field managers through web application.

Responsibilities:

Involved in deploying SSIS packages for various environments.

Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components.

Worked with tabular reports, matrix reports, gauges & chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL server reporting services (SSRS).

Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.

Created projected income statements and other financial reports. Developed yearly, quarterly, monthly sales reports, bench marking reports and commission reports.

Created SSRS report model projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Created sub-reports to present more detailed information about the summary.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Created ad-hoc queries and reports for unit team lead as requested and provide on-going analytical support for these requests.

Environment: MS SQL Server 2008, SSIS2008, SSRS2008 with Microsoft Share point Integration 2007, SSAS 2008, Windows XP, MS EXCEL and MS Visio 2007.

T.G Mercer Dallas, TX Oct 2009 – Oct 2011 SQL Server /BI Developer

T.G Mercer is an expert in pipe unloading, pipe handling and pipeline logistics for oil and gas pipeline Industry. We used SQL for storing the data in data warehouse and extracting files from the database and making reports for it.

Responsibilities:

Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions

Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Used ASP.Net coding and C# to call the Stored Procedures created with T-SQL

Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.

Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.

Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports in BIDS. Deploying and scheduling Reports using SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including current status.

Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2008/2005, MS Access, Import & Export Data, Enterprise Manager,SSRS, SSIS, TFS, Power view.

Digital module Technologies Pvt ltd, V.V.Nagar, India Jul 2007 – Sep 2009

SQL Developer

Responsibilities:

Requirement gathering – Solution design

Involved in the migration from SQL server 2000 to 2005.

Actively involved in Normalization of database.

Designed DDL and DML for MS SQL Server 2005

Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.

Created Triggers to enforce data and referential integrity

Actively designed the database to fasten certain daily jobs, stored procedures.

Optimize query performance by creating indexes.

Involved in writing SQL batch scripts.

Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.

Involved in merging existing databases and designed new data models to meet the requirements.

Perform daily database backup & restoration and monitor the performance of Database Server.

Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Installed and Configured SQL Server 2005 on development server for designing and testing.

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports

Environment: MS SQL Server 2005, Windows NT platform, Visual Basic 6.0, Crystal Reports.

Visa: Green Card

Contact this candidate