SUMMARY

• 8+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance, Health Care and Banking Services.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
• Experience in different phase of Software Development Life Cycle (SDLC) of development of applications.
• Experienced in upgrading SQL Server 20 /2012 and data migration among versions.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005/2008/2012 via SQL Server Integrated Services.
• Created ETL packages usingSSISto move data from various heterogeneous data sources.
• Implemented error handling and roll back process inETLload.
• ConfiguredSSISpackages usingPackageconfigurationwizard to allow packages run on different environments.
• Worked with Financial companies for application related pricing and security applications.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Proficient in buildingCubes,definingReferenced Relationshipsand creating Hierarchies in SSAS.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS).
• Good experience writing code in VB/C# in Visual Studio 2010/2013/2015 using.NET frameworkfor creating desktop(WinForms and WPF) and web applications(MVC) leveraging technologies that include EF6, ADO.NET, XML, AJAX, CSS, JavaScript, WCF and LINQ.
• Experienced working with different Source and Version Controlling Systems such as Visual SourceSafe (VSS),SVN and Team Foundation Server (TFS).
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Enterprise Manager, Data Transformation Services (DTS), Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts & SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Profiler

ETL: DTS, SQL Server Integration Services

Reporting Tools: SSRS, Crystal Reports, Business Objects

Programming/Web: T-SQL, PL/SQL, C, VB, C#, .Net, HTML, CSS, JavaScript, LINQ, EF6

Databases: SQL Server 2008/2008 R 2/2012/2014/2016 Oracle 9i/10g/11g, IBM DB2 & MS Access

Source Control Systems: Team Foundation Server, SVN, GitHub

Operating Systems: Windows XP/7/ 8/10, 2008 R2, 2012, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Business Intelligence Developer

Responsibilities:

• Worked with business analysis and product teams to create data mappings and rules
• Responsible for understanding requirements and designing/architecting data migration strategy/process
• Designed and developed multiple SSIS packages for migrating data from mainframe(VSAM) files, DB2 tables to an Oracle database handling numerous business rules and transformations
• Assisted in creation of Business Requirements and Technical Design documents
• Created numerous tables, views, stored procedures, functions in SQL Server and Oracle as needed based on design and drive re-usability
• Responsible for identifying and handling data anomalies prior to the migration of the data
• Fine-tuned queries and stored procedures as and when needed for faster data retrieval and data loading as needed achieving better performance
• Extensively used variables, configurations, conversions, Conditional Split, Lookup, Aggregator, Multicast, Derived Column and script components across SSIS packages
• Created unit test cases, validation scripts and involved in code reviews
• Created balancing reports using SSRS to support and validation of data migration process
• Worked through the project with multiple teams that include business, product, development, quality and implementation with a headcount of 60

Environment: SQL Server 2014, Oracle 11g, IBM DB2, Mainframe, T-SQL, SSIS, SSRS, Visual Studio 2013, Windows Server 2012, Team Foundation Server (TFS), C#.Net

Confidential, Dallas, TX

MSBI Developer

Responsibilities:

• Responsible for gathering project requirements from the users for designing and developing data warehouse as needed.
• Responsible for managing BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Performed backup/restore database objects such as tables, procedures, triggers, constraints, indexes and views.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, and charts and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2/2012.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Responsible for creating and executing Test cases, performing UAT and documenting the results.
• Integrating and managing SSRS reports in SharePoint environment.
• Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema inSSAS.
• Created calculated members, named sets for custom measures using MDX for OLAP Reporting as per end user requirements..
• Deployment and processingSSAS Cube, monitor Full and Incremental loads and support any issues.
• CreatedSSAS Tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirement.
• Performance tuning the existing reports.
• Worked on Team foundation server (TFS), created team projects and builds to deploy databases, ETL Packages, SQL jobs.
• Created script tasks and components with C# in SSIS as part of ETL load.
• Worked in an Agile Scrum model and collaborating with Scrum Master, QA, Product and Development Teams using Agile.

Environment: SQL Server 2008R2/2012/2014, SSIS, T-SQL, SSRS, SSAS, Team Foundation Server (TFS), Windows Server 2008R2/2012, C#.Net, SharePoint 2013, Crystal Reports 9.0.

Confidential, Downers Grove, Illinois

SQL BI Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008R2 /2012.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
• Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
• Involved in database designing using Normalization.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, Oracle to MS SQL Server and vice versa and schedule the jobs.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration whenever needed.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008R2/2012.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Developed many cubes for reporting based on the business requirements using SSAS 2008R2.
• Extensive Knowledge inSSAS storage and partition, and Aggregations, calculation of queries with MDX, Data Mining Models.
• Created ComplexSSAScubes with multiple Fact and Measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Used TFS (Team foundation server) for deployments of database changes, SSIS packages & SSRS reports.
• Created script tasks and components VB.Net in SSIS as part of ETL load.
• Responsible for unit testing and integration testing complex queries.

Environment: SQL Server 2000/2005/2008 R2/2012, SSIS, T-SQL, SSRS, PL/SQL, Windows Server, TFS, VB.Net, SharePoint 2010.

Confidential

MS SQL Server Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Designed the Entity Relationship(ER) models and logical data (LDM), physical data (PDM) models in Power Designer based upon the design documents.
• Modeling new fields/tables in Operational Data Store (ODS) as per new requirements.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2008.
• Designed, modified and troubleshoot SSIS packages.
• Used SSIS to load data from various sources into on SQL Server 2008 database and created packages.
• Involved in Debugging, tuning and configuration of SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Running and Scheduling SSIS Packages.
• Experience working with SVN to manage code development, tracking and deployment on servers.

Environment: SQL Server 2008, SQL Server Integration Services 2008, SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS (5.0), Power Designer, Visual Studio 2005,T-SQL, SVN.

Confidential

SQL Server Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2005.
• Build and maintain complex SQL queries using T SQL for data analysis, data mining and data manipulation. Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Created/designed reports using SQL Server Reporting Services per user requirements.
• Responsible for writing SQL queries, Procedures, Functions and Database triggers.
• Good Experience in Tuning and Optimization of T- SQL stored procedures.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Deployed and Scheduled the Reports in Report Manager.
• Extensively used the SSIS package to write the data from the flat files into tables.
• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Different database triggers were created and stored in the database and fired off when contents of database were changed.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related outages.
• Develop documentation of database architecture, system processes and procedures. Create, review and produce migration scripts of database objects from development to production environments.

Environment: MS SQL Server 2008/2005, T-SQL, PL/SQL, Windows 2003 Server