SUMMARY:

• Over 6+ years of IT experience in database design and development in Microsoft SQL Server Suite of Products.
• Expert in working with the BIDS and SSDT which includes SSIS, SSAS and SSRS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Expertise in scripting T - SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Control flow, Data flow, Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Experience with data warehouse concepts and implementation to provide reporting solutions for the organization. Including experience with slowly changing dimensions, star schemas, conformed dimensions.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling. FACT & Dimensions tables and Logical & Physical data modeling.
• Developed Linked, Drill Down, Drill Through and Sub Reports using SSRS.
• Design functional specs for BI front end applications including dashboards and reporting, considering appropriate data flow and capture .
• Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
• Designed Subscriptions and Security for Reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS .
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder .
• Experience in writing reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query, Power View.
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing .
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.

TECHNICAL SKILLS:

Languages: Transact SQL, PL/SQL, C, Visual Basic 6.0, VB.Net, C#, .NET ASP.NET, HTML5, CSS3,JavaScript,SOAP

Databases: SQL Server 2016/2014/2012/2008 R2/2008/2005, MS Access, Oracle 11g

Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Tableau 9.0,PowerBI

ETL Tools: DTS, SSIS, Informatica

Data Modeling Tools: Erwin, Visio

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2012 Query Editor, Solution Explorer, Analysis Manager, ReportingServer, MS office, JIRA,TFS.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

SQL/ETL/MSBI Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Involved in assisting Business analysts in developing, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and emailing them to director and analysts to be reviewed in Excel Sheet.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.
• Created SSIS packages to migrate data from DB2, Teradata to SQL Server 2016 .
• Data migration (Import & Export using BCP) from text to SQL Server 2016.
• Involved in database backup, recovery procedures.
• Planned back up strategy for disaster recovery.
• Responsible for log backups and restoration.

Environment: Windows2008 Advanced Server, Advanced SQL, MS SQL Server 2005/2008/2012/2014/2016, PL/SQL, Oracle, COBOL, Notes, SSRS, SSIS, SSAS, Power BI, Query Analyzer, DB2, Azure, Erwin.

Confidential, Omaha, NE

SSIS, SSRS, SSAS

Responsibilities:

• Designed and developed new SSIS Packages (ETL) for RElinx reporting
• Gathered business requirements and documented the changes for future reference.
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures
• Created ETL packages to validate, extract, transform and load data from various data warehouses to databases/data marts.
• Implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages.
• Designed DataMart’s for various new Analysis projects using Kimbal methodology.
• Optimizing and troubleshoot T-SQL queries, created functions, Store procedures and triggers according to the business needs.
• Worked for Data Architecture team for maintaining the integrity of the SQL Server Database most of the responsibilities were to monitor database activities and security audit, new Database Backup Scheduling and disaster recovery management.
• Monitoring the scheduled ETL Jobs of multiple internal team and address the failures for continuity.
• Responsible for creating subscriptions using data driven subscriptions on weekly and monthly basis.
• Created various reports like parameterized, drill through and cascading parameter reports
• Experience in ITIL Process and L2/L3 production support
• Working on new change requests on ssrs reports.
• Prepared weekly status reports
• Logging and addressing problems in the internal ticketing system regarding SQL Database.
• Making team in various meetings with the stack holder and documented the business use cases for future reference.

Environment: MS SQL Server 2016, MSBI, Visual studio, Oracle, Power BI, VB Script, XML, SQL Profiler, Agile Methodology, Team Foundation Server, JIRA.

Confidential, Woodlands, TX

SQL Server Developer

Responsibilities:

• ETL, data profiling, data quality and clean ups for SSIS packages.
• Designing Logical and Physical Data Model with Erwin tools.
• Worked with installing, designing and managing MS SQL Server 2012.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2012.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Work with project teams for upgrading SQL Server 2005 to SQL Server 2012.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.

Environment: MS SQL Server2005/2012, Team Foundation Server, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, Windows XP, T-SQL, VB.Net.

Confidential

SQL Developer

Responsibilities:

• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-Defined functions and Cursors for Application.
• Involved in the SQL Data Warehouse Design and Development.
• Created T-SQL Queries, Dynamic-Queries, Sub-Queries and Complex Joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Designed ETL Packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Done Mappings using SSIS Look Up/Aggregation Transformations to match the needs of the Business.
• Developed Drill Down Reports in SSRS and Generated daily, weekly and monthly Reports.
• Involved in Scheduling, Creating Snapshots and Subscriptions for the Reports using SSRS.
• Involved in Developing Numerous Ad-hoc Reports using SSRS.
• Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.
• Involved in Designing Logical and Physical Data Models using ERWIN.
• Worked with team in Designing Dimensional Modeling using SSAS packages for End-User.
• Extensively used and developed SQL scripts/queries in Backend Testing of Databases.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.

Environment: MS SQL Server 2012, Enterprise Edition, MS Analysis Services 2012, SSIS, T-SQL/ PL SQL Erwin 4.1, MS Access.

Confidential

SQL Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and also Generated Named calculations and named queries.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to analysis server from SSRS (2005/2008).
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined the datasets for generating the report.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Migrated Crystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2008, SQL Server Integration Services (SSIS ), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports.