Sql Server Data

Mike Weinstein

Mail Id: ****.***@*******.***

Visa: GC

SQL/SSIS/SSRS Developer - EFG Companies

Fort Worth, TX

● Over 10+ years of Business intelligence developer experience in Systems Analysis and Design, Testing and Maintenance, and Software/Database Development in Client/Server systems, Data warehousing and applications for Different domains.

● Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects. Developed a thorough knowledge and maturity in all the phases- understanding business processes, gathering requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).

● Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

● Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2008/12/14

● Experienced in relational database design, SQL queries, Stored procedures, Functions, clustered, non-clustered indexes and indexed, views, Performance tuning,

• Experienced in Importing/Exporting Data from various data sources like Excel, and Flat file using DTS utility and SSIS services.

• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP

• Experience in developing and monitoring SQL Server Integration Services (SSIS) Packages and Data Transformation Services (DTS)

● Expert in using the work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications.

● Experience in Converting DTS packages into SSIS packages.

● Expertise in creating Ad-hoc Reports, Drill-Down, Drill-Through Cascaded, Matrix and Tabular Reports for different business domains depending on the specifications and requests.

● Analyzed SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor. Hands on experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitoring.

• Experienced in Software configuration management using various SCM tools like (VSS) Visual Source Safe Team Foundation Server (TFS), Dimension Serena.

• Implemented logical and physical Data Modeling with STAR and SNOWFLAKE techniques using Erwin in Data Mart.

• Experienced in Reporting Services (SSRS)

• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.

● Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using Reporting services (SSRS).

● Strong conceptual analytical, and design skills with leadership qualities. Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

● Have knowledge on Hadoop Distributed File System (HDFS), Map Reduce, Apache Hive (Hive QL).

Work Experience

SQL/SSIS/SSRS Developer

EFG Companies -Dallas, TX

May 2015 to Present

Responsibilities:

● Analyzed and designed an ETL Architecture to create a SSIS Package to replace the Dot Net application using Microsoft Visio.

● Created SSIS Packages using Derived Columns, Conditional Split, Execute SQL Task, Data Flow Task, Script Task, File System Task, FTP Task, Send mail task, for each loop container and Sequence container etc to load the data from inbound Flat files to SQL Database.

● Used VB.Net and C# script task to download the flat files from FTP to Shared Folder and Tracked different Error scenarios and logging for SSIS.

● Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

● Designed, Created and Tested SSIS packages for data transformation, cleansing, caching, aggregation, staging, backup, update and transfer in support for the main Project.

● worked with Flat Files, OLE DB Source, and Excel Source loading.

● Worked on creating complex views, new stored procedures, functions, cross apply, triggers, constraints, etc.

● Involved in the creation and maintenance of index using database engine tuning advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.

● Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, Primary keys and queries.

● Monitored performance and optimized SQL queries for maximum efficiency.

● Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources.

● Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment

• Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.

• Involved in Deployment of SSIS Packages across various Production, QA environments.

• Extensively worked on reports using SQL Server Reporting Services (SSRS 2008, 2012) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart and Sub Reports.

Environment: T-SQL, MS SQL Server2008,2012, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS 8.0), Microsoft visual studio 2010 Shell, Microsoft Visio.

SQL/SSIS Developer

Anthem -St. Louis, MO

December 2013 to March 2015

Responsibilities:

● Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP with the help of SSIS Business Intelligence Development Studio.

● Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Script Task, File System Task, Send mail task, For loop container, For each loop container and Sequence container etc to generate underlying data for the reports and to export cleaned data heterogeneous source to data warehouse

● Worked on VB.Net and C# script task to manipulate server side data and Tracked different Error scenarios and logging for SSIS.

● Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

● Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer.

● worked with Flat Files, OLE DB Source, and Excel Source loading.

● Worked on creating complex views, new stored procedures, functions, triggers, constraints, etc.

● Involved in the creation and maintenance of index using database engine tuning advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.

● Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, Primary keys and queries.

● Monitored performance and optimized SQL queries for maximum efficiency.

● Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources

● Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment

• Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.

• Involved in Deployment of SSIS Packages across various Production, QA environments.

Environment: T-SQL, MS SQL Server2012, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS 8.0), Microsoft visual studio 2010 Shell.

SQL Developer/SSRS

Diplomat Pharmacy -Flint, MI

July 2012 to November 2013

Responsibilities:

● Wrote T-SQL code for creating cursor and handling the data validations.

● Involved in various stages like development, system Analysis and design.

● Suggested creating Clustered and Non-Clustered indexes on tables.

● Involved in project planning with project managers.

● maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

● Installed and maintained MS SQL Server 2005/2008.

● Created Ad-Hoc reports for business users using SSRS.

● Created Database Objects - Tables, Views, User defined functions, Triggers, Stored Procedure and Roles.

● Created DTS packages to get data from different sources, consolidate and merge into one single source.

● Implemented different types of constraints on tables.

● Monitored performance and optimized SQL queries for maximum efficiency.

● transformed the complex business logic and calculations into coding.

● designed a report on the monitoring of Server Performance using Task Manager and Performance monitor.

● Created levels of Data Flow Diagram using Microsoft Office Visio.

● Created and kept the Entity-relationship Diagram and Data Dictionary up-to-date after any alterations were made to the metadata and data in each table.

Environment: MS SQL Server2005/2008, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2005 Server, VB.NET.

SQL/BI Developer

Siemens Healthcare -Norwalk, CT

May 2010 to June 2012

Responsibilities:

● Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS Business Intelligence Development Studio.

● Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

● Scheduled SSIS packages by creating the corresponding job tasks.

● Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

● created complex ETL Strategies to populate the data warehouse/data-mart facts and dimensions.

● Created Ad-Hoc reports as per client requirement using stored procedure.

● Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to User on demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.

● Involved in handling parameterized reports and drilldown reports in SSRS 2005/2008

● worked with Flat Files, OLE DB Source, and Excel Source loading

● Developed reports using efficient data retrieval techniques.

● Involved in complex T-SQL programming.

● Evolved in the creation and maintenance of index using database engine tuning advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.

Environment: Microsoft SQL Server 2005/2008 R2 Enterprise edition, SSAS, SSIS, SSRS, BIDS, Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007

SQL Server BI Developer

PNC Bank -Hopewell, NJ

March 2009 to April 2010

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

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

• Involved in ETL architecture enhancements to increase the performance using query optimizer

• Implemented Event Handlers and Error Handling in SSIS packages.

• Created SSIS packages for Data Conversion using data conversion transformation.

• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.

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

• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

• Developed a High level dashboard using SSRS 2008.

• Designed and created Report templates, bar graphs and pie charts based on the financial data.

• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

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

• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

• Involved in creating report models and applying row level security filters for report model.

• Coordinated with front-end for implementing logic in stored procedures and functions.

• Experienced in writing complex SQL Queries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

SQL Developer

Millennium Pharmacy Systems -Pittsburgh, PA

January 2007 to February 2009

Responsibilities:

● Gathered user requirements, Analyzed and designed of software and database solutions.

● Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.

● Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc

● Defined Granularity with in a measure group and drill through actions.

● wrote the queries for the drill down reports, Identified and added the report parameters.

● formatted the reports using the Global variables and expressions, deployed the generated reports on to the server.

● transformed the complex business logic and calculations into coding.

● Gathered information about the system and assisted in the development of deliverables.Worked with the clients to gather system requirements.

● Established and created program evaluation and reviewing for the project lifecycle.

Environment: Microsoft SQL Server2005/2008 Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007

Additional Information

TECHNICAL SKILLS:

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration

Services (SSIS), SQL Server Analytical Services (SSAS).

Databases: Microsoft SQL Server […] MS- Access,

Oracle 8i/9i/10g

Languages: T-SQL, PL/SQL, Visual Basic 6.0, VB Script, C, C++, C#,

ASP .NET, XML, HTML, PHP

Operating System's: Windows 7/Windows XP/NT/2000, UNIX, DOS, Windows Server

[…] and Mac OS Systems

Tool: Microsoft Visual Studio Adobe Creative Suite, Word Press

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Version Control: Visual SourceSafe Team Foundation Server (TFS)

Contact this candidate