PROFESSIONAL SUMMARY:

• Over 7 years of experience in IT industry as a SQL Server BI Developer and SQL DBA with specialized skills in SSIS, SSRS and SSAS.
• Hands on experience with installing, configuring and deploying MS SQL Server suite of products that includes SSIS, SSRS, SSAS for 2014, 2012, 2008 R2, 2008, 2005.
• Experience working in Waterfall and Agile methodology environment depending on projects requirements
• Proficient in database modelling for OLTP, OLAP, Operational Data Store (ODS).
• Transformed data from one server to another server using Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in error and event handling, Precedence constraints, break points, check points and logging.
• Strong experience in Developing and Deploying SSIS packages, job scheduling, dataflow and control flow components, SQL mail Alerts using SQL Server Agent.
• Experience in implementing Slowly Changing Dimensions (SCD), to maintain historical data.
• Using SSIS, worked extensively on various data sources (Excel, XML, Flat file etc.) and different transformations like lookup, merge join, derived column, aggregate, conditional split etc.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Designing and Deployment of Reports for the End - User requests using Web Interface & SSRS.
• Experienced in creating different types of Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Hands on experience and knowledge of high availability SQL Server solutions including replication, log shipping, Database Mirroring.
• Better understanding of how to handle environmental related issues and to capture data related errors in custom logging process for SSIS/ETL Packages.
• Complete Knowledge of data modelling using various tools such as ERWIN, Oracle datamodeler.
• Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET), IIS Web Server.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Power BI, Tableau - Desktop/Server, Micro Strategy and SSRS.
• Monitoring and tuning performance SQL SERVER with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
• Scheduled backups for databases and Transaction logs. Performed restoration operations and suggested backup strategies.
• SQL Server RDBMS database development including T-SQL programming.
• Good experience in data warehouse concepts, Relational Database Management Systems (RDBMS), performance tuning, optimizing SQL queries, writing complex SQL Queries using functions, stored procedures in T-SQL.
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experienced in collaborative team environment working with other developers, business analysts, end-users and with project management teams.
• Knowledge of Principles of Data Warehouse like Fact Tables, Dimension Tables and Star/Snowflake schema modelling.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.

TECHNICAL SKILLS:

T: SQL, PL/SQL, Dynamic SQL, MDX, C, XML, HTML, HTTP, Shell Scripting Oracle, MS-Access, MS SQL Server, Teradata, MS SQL Server (2014, 2012, 2008R2, 2008, 2005), Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Power BI.

Design & Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques, FACT, Physical and logical data modeling.

Packages: MS Office Suite, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007.

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Power Pivot, Excel Data Explorer, Tableau, Power BI.

Operating Systems: Windows 10, 7, Vista/XP, NT, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. SQL SERVER BI Developer (SSIS, SSAS and SSRS)

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
• Debugged SSIS Packages using Data Viewers, Breakpoints.
• Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages .
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Preparing Dashboards using calculations, parameters in Power BI.
• Created drill down and drill up in worksheets in Power BI.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of reporting service architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting of performance issues which were associated with Power BI reports.
• Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Experienced in working with agile methodology.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server.

Environment: MS SQL Server 2014, 2005/ 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SVN (source control), Power BI, MS Visual Studio .NET, C#, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012 Server.

Confidential, Austin, TX

Sr. MS SQL BI Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2012 using SSAS, SSIS/DTS, SSRS.
• Extract Transform Load (ETL) development Using SQL server 2012, SQL Server 2008 Integration Services (SSIS).
• Worked on QNXT front end and back end to verify the provider’s information.
• Worked on RAM files to insert, update and modify provider’s data and load into QNXT.
• Developed and maintained MS Access database for the provider data management.
• Hands on experience on SSAS tabular model.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Involved in Migration of packages from SQL Server 2008 to SQL Server 2012.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008/2012 Analysis Services (SSAS) and Reporting service (SSRS).
• Involved in creation and processing of SSAS Cubes.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of System Configuration.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Developed mappings to load Fact and Dimension tables, Slowly Changing Dimensions, incremental loading and unit tested the mappings.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Converted existing BO reports to tableau dashboards.
• Utilized Tableau server to publish and share the reports with the business users.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Environment: SQL Server 2012, Oracle 11g/10g/ 9i, .Net Framework 4.0, Asp.Net2.0, VSS, Windows 2000, Windows 2003 Server, Visual studio 2013-(V.12), MS TFS, MS-Access, Tableau, T-SQL, SSRS, SSAS, SSIS Packages, ETL, C#, .Net, Excel, Business Objects Data Integrator 6.5, MDX.

Confidential

MS SQL BI Developer

Responsibilities:

• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loaded the data into targets using SSRS.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Used DDL and DML for writing triggers, functions, stored procedures and data manipulation.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Used datasets and ADO.Net to retrieve data from the databases.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2013 using SSIS.
• Created ETL process for Slowly Changing Dimensions (SCD).
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLE DB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2/ 2012.
• Configured and maintained Report Manager and Report Server for SSRS .
• Created Sub-Reports , Drilldown-Reports , Summary Reports, and Parameterized Reports in SSRS.
• Error checking and timely resolution.
• Published dashboards to Tableau server.
• Implemented backups (hot & cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
• Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Created logging, custom logging and error handling packages.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, Tableau, GEM Fusion, Visual Studio 2013, Toad, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003.

Confidential

Business Intelligence Developer

Responsibilities:

• Actively involved in all the phases of Software Development Life Cycle (SDLC).
• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into enterprise data waredatahouse (EDW).
• Dealt with a variety of data sources including OLEDB Oracle Source, XML sources and Flat File Sources.
• Implemented incremental loading into the destination.
• Created alerts for both success and failure of jobs.
• Designed ETL for implementing Slowly Changing Dimensions (SCD) to maintain historical data.
• Created configuration files to deploy SSIS packages across all environments.
• Used SSIS Script Task to write C# Code Snippets to generate error reports to be sent out.
• Created the complex stored procedures, user defined functions to encapsulate the business logic.
• Created views, indexes, and user defined data types and implemented the cursors, triggers as needed.
• Followed best practices in writing T-SQL queries as a regular daily routine.
• Responsible for creating the reports using the SQL server reporting services.
• Created various types of reports including drill-down, drill-through, cascaded, parameterized reports and sub-reports.
• Deployed the reports to the report server.
• Designed and implemented the database replication for reporting database.
• Knowledge Transferred to co-workers & prepared Technical Documentation.
• Used Visual Source Safe for version control.
• Worked extensively on the data changes as per the user specified improvements on each release of the application build.
• Created numerous test cases for testing the application.

Environment: SQL Server 2008, SSIS, SSRS, T-SQL, Visual studio 2008, VB.NET, ASP.NET, XML, VLDB, HTML, ER Studio, Visio, Microsoft Visual Source Safe.

Confidential

SQL Server Developer

Responsibilities:

• Created Database Diagrams using third party tool Erwin in beginning of the project. Identified database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi-formatted Flat files, Excel, XML files, etc.
• Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Designed and developed Data Transformation Process (Extraction, Transformation & Loading) using Heterogonous Sources to Destination (SQL Server).
• Used SQL Agent for job scheduling.
• Worked as a developer on databases like MS SQL Server 2005/2008, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Involved in gathering of all the requirements for the project and Implemented the SDLC concept.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Involved in installation and configuration of SQL server 2000 on Servers.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions .
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Responsible for Query Performance tuning and Optimization.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 2008 databases.

Environment: MS Office suite 2008, MS-SQL Server Management Studio 2000/2005/2008/ R2, T-SQL, DTS, Replication, Rational Rose, Windows NT, MS SQL Server Reporting Services 2008, MS SQL Server Analysis Services 2008, MS SQL Server Integration Services 2008, MS Access, Erwin, SQL Query Analyzer.