SUMMARY:

• Over 8+ years of experience as a SQL server Developer and BI Developer (SSRS/SSIS/SSAS). Worked in various business domains like Banking, e - commerce and Insurance.
• Hands on experience on T-SQL, PL SQL, SSIS, SSRS, MDX, DAX, Power Pivot and Power View reports.
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.
• Experience in Designing Business Intelligence Solutions with Microsoft SQL Server 2008 and 2012 using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Excellent skills in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, excel sheets, Flat Files and MS Access.
• Experience in developing custom reports and creating various types of reports like on demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Expert in planning, modeling, designing, developing, implementing, and maintaining Microsoft SQL Server … and Microsoft Access databases.
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Hands on experience in installing, configuring, managing, upgrading and migrating Backup/Restore, monitoring and troubleshooting SQL Server 2008
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.

PROFESSIONAL EXPERIENCE:

SQL Server/MSBI Developer

Confidential - Merced, CA

Responsibilities:

• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Involved in developing and designing Dashboards using Power BI to show KPI's in the project
• Created stored procedure and function to support efficient data storage and manipulation.
• Created VB.Net Script for Data Flow and Error Handling using Script component in MSBI (SSIS).
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging and Development.
• Worked on complex mappings & mapplets in Informatica to load the data using different transformations according to company Informatica standards
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using MSBI (SSRS).
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• Worked with Power BI gateway to schedule daily job to refresh data
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Maintained source definitions, transformation rules and targets definitions using Informatica repository Manager
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Proficient in creating different Package Configurations such as SQL Server, XML configuration and Parent package variable.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique with in the tableau workbook
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• 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 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.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Worked on advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Optimized and Aggregated cubes with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Worked on deploying and scheduling Reports using SSRS and Tableau as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, MS SQL Server 2012/2008/2005, Tableau 7.0/8.1 Server and Desktop, Eclipse, Tableau, Windows Server/professional, Oracle 12c, C#, VISIO, ERWIN.

Sr, SQL BI Developer

Confidential - Dallas, TX

Responsibilities:

• Understood existing business model and customer requirements.
• Prepared business and technical understanding documents for the existing applications.
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked on migration to SSIS packages across instance; also tuning of SSIS packages and T-SQL queries.
• Configuration and Administration of Informatica Servers
• Implemented various SSIS Transformations like Slowly Changing Dimension- SCDs type 2, DataConversion, Derived Column, Lookup, Fuzzy Group, Multicast, etc.
• Fields are updated on time basis like day, month, quarter, year using SSIS packages.
• Monitored performance and optimization of SSIS packages for maximum efficiency.
• Understood and modified the data according to the requirement using the Query Editor and Data view in Power BI desktop.
• Handled transformations on the data using Power Query in Power BI.
• Performed Analysis using Power Pivot in Excel and data taken from Power BI cloud.
• Created Role based Security levels to access data in Power BI and capable of using new features like Q & A.
• Experience with SQL Server Reporting Services (SSRS) and Power BI to author, manage and deliver paper-based, Web-based reports and Interactive Dashboards.
• Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members
• Migrated different kinds of records using Reporting Services Migration Tool by performing necessary steps to prevent loss of reports.
• Automated few of the daily routine tasks, thereby reduced few man hours of effort.
• Involved in the preparation of the unit test case documents and unit testing of the enhanced macro codes, T-SQL queries.
• Prepared detailed document of the know issues for future reference.
• Created Partitions in the cubes for incremental processing.
• Designed the Usage based Aggregation based on the query logs on Analysis Server.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Created Virtual Cubes using linked measure groups from multiple cubes.

Environment: Windows server 2012, SQL Server 2012, Microsoft BI Suite 2012, Microsoft Visio, Power BI.

SQL Server developer

Confidential

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process.
• Working closely with the Guide ware team on business aspects.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Environment: MS SQL Server 2008/2012, Red Gate tools, Power Pivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

SQL Programmer

Confidential

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, 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 ware house.
• Extracted data from XML to SQL server.
• Highly involved in creating, structuring, and formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate special reports according to client needs.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007 and SharePoint.
• Deployed designed PPS dashboards and reports in MOSS site using PPS Dashboard Viewer Web Part for web-based access for multiple end users.
• Designed and deployed various complex reports using MS Reporting Services.

Environment: SQL Server 2005/2008R2/2012 Enterprise Edition, .Net 3.5, SQL SQL Server Data tools (SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007.

SQL Server DBA/Developer

Confidential

Responsibilities:

• Created and managed stored procedures, indexed views, user-defined functions, triggers, and database constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Used DTS/SSIS for ETL processes, SSRS for reporting needs, for analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various data transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, fuzzy grouping, script components, and error handling.
• Generated custom ETL scripts using SSIS 2005 and unit tested load processes for performance check.
• Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
• Created various complex reports and managed them using SSRS 2008/2005 according to ERLC.
• Involved in migration and conversion of reports from SSRS .
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, .NET 3.5, SQL BI Suite 2008 (SSIS, SSRS), Enterprise Manager, PPS, XML, PowerPoint, Project, Access 2003, Windows Server 2003, Oracle, Crystal Reports, Cognos, Business Objects, SharePoint, MOSS 2007.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, DAX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting, Java, Oracle 12c, 11g, 10g

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor (DTA). MS SQL Server Denali, 2012, 2008R2 2008, 2005, 2000 RDBMS SQL Server 2005/ 2008/ 2012/ 2014, MS Visual Studio, SQL Server Management, MS-Office.

BI Tools: SSAS, SSIS, SSRS, BIDS, Informatica Power Center, OBIEE, Crystal Reports.: Design Tools and Data Modeling

MS Visio: ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies:Packages

MS Office, Microsoft Office Suit, 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, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power, ProClarity, Microsoft Office, Excel Power Pivot Excel Data Explorer, Tableau.

Operating Systems: Windows … NT & Windows 9x, Windows Server 2008, MS-DOS, LINUX, UNIX