SUMMARY

• IT Professional with more than 8 years of experience working on designing and developing database applications with strong background in Database Architecture, Design, Development and Administration.
• Hands on experience using Microsoft SQL Server 2005/2008/2012/2014 and Microsoft Business Intelligence Suite (Microsoft SSAS, SSIS, SSRS).
• Gathering Requirements from diverse groups, assessing technical needs, creating prototypes.
• Experience and knowledge of working in various domains such as Health Care, Retail, Financial, Supply Chain, and Telecom
• Excellent TSQL Scripting Skills in developing Efficient Stored Procedures, functions, applying business logic.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance.
• Good Knowledge of various source systems, SAP, Hybris, Oracle, PostGre SQL, ODS, Flat files, Excel, XML, Salesforce, Web Service etc.
• Designing, Scheduling and Maintaining ETL Framework for different Processes.
• Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Proficient experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Designing and creating different SSIS packages using OLE DB connection sources from different sources by making use of multiple transformations provided in SSIS.
• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.
• Expert knowledge in developing multidimensional databases using SSAS.
• Experience in OLAP cubes using SSAS for data mining.
• Experience in Dimensional Modeling, Star/Snowflake Schemas, and performance optimization of SSAS cubes.
• Creating Partitions, Attribute Relations, Perspectives and KPIs using SSAS.
• Implemented best practice in structuring SQL queries, debugging unexpected SQL results etc.
• Well knowledge in Assurance, including System Integration Testing and Regression Testing by Load Testing Procedures, Coordinating with UAT and Validating Test Cases.
• Creating and deploying parameterized reports using power BI and Tableau.
• Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Created and maintained Database Views available to all BIand DW applications.
• Robust MS Access and excel skills with Powerpivot, PivotTable, PivotChart, Powerview, Vlookup functions and formulas.
• Good and Effective Communication with all levels of business partners with Business Analysts to ensure the requirements are completely analyzed and technical owners to minimize risks.

TECHNICAL SKILLS

• TSQL (2005/2008/2012 )
• SSIS (2005/2008/2012 )
• SSRS(2008/2012)
• SSAS (2005/2008/2012 )
• TFS, VSS,SVN
• PowerBI
• SQL Server (2005/20 )
• C,C#
• Tableau
• SSAS Tabular
• Redgate Tools
• Informatica
• Cognos
• Oracle
• Microsoft Access

PROFESSIONAL EXPERIENCE

Confidential, GEORGIA

BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Analyzed and designed software and database solutions.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on other packages of the SQL server 2012 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
• Created data mapping between two distinct models.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in Installation, Configuration of Share Point Form in Cluster Environment.
• Modified SSASTabular models with dimensions and fact tables from data sources.
• Scheduled SSAScube processing by designing and executing SSIS packages with SQL server agent job.
• Designed various cube objects such as KPIs, drill through actions, aggregations, and translations. Implemented key performance indicators, actions, hierarchies, and attribute relationships with added functionalities.
• Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Imported data from multiple data sources in to Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLookup and formulas, built PivotTables and pivotcharts using power pivot skills.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts. Worked with Excel Power Pivot Tables
• Used recently introduced Power BI to create self - service BI capabilities and use tabular models.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Designed various types of reports like Custom tabular reports, Parameterized reports, Sub reports using Crystal reports.
• Develop applications based on the Spectrum Construction Accounting database; create Views / Stored Procedures in SQL Server Management Studio; use data sources to create Crystal reports, Dashboard applications, and automated Excel spreadsheets.
• Design, Build and unit test Physical and Logical models, ETLs, OBIEE rpds, reports and dashboards.
• Defined design and operational standards for BI Developers, ranging from creating database views and defining security models for data mart using ETL framework.
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Built and Monitored Executive reports using SSRSfor executive team to track progress and other Audit KPI.
• Designed SSRSreports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
• Experienced in loading data into Oracle Database using Data Loader and SQL Loader Generated Tableau dashboards with quick/context/global filters, parameters and calculated fields on tableau reports.
• Created Tableau dashboards with interactive views, trends, and drill downs along with user security level.
• Experienced in SDLClife cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams.
• Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
• Experienced in loading data into Oracle Database using Data Loader.
• Create & modify database objects like tables, views, procedures, functions, triggers, packages, indexes, synonyms, materialized views using Oracle tools like TOAD and SQLNavigator.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Environment: MS SQL Server 2012, Tableau, SSAS, Power BI, SQL Server Reporting Services 2012, SSIS, Front Office 8.3 / 10.2 / 10.3, Windows 8/8.1, MS Office 2007/2010, Oracle 11g.

Confidential, DELAWARE

MS SQL Server Developer/SSIS/SSRS/SSAS

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.
• Involved in gathering user requirements and system specifications.
• Developed stored procedures, functions, and database triggers and maintained referential integrity and implemented complex business logic.
• Designed and created views for security purposes. Implemented rules, defaults, and user-defined data types. Tested queries to optimize procedures and triggers to be used in production.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used custom .NET assemblies for Script Task in SSIS.
• Analyzed the existing reports in Report.Net, Actuate and their data sources.
• Created Dimension types such as Standard dimension, Parent-Child dimension and Role Play Dimension in SSAS.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Worked on creating multiple SSRS reports in Drill-through mode and Cross Tab Reports.
• Used SSRSReport Manager to assign roles, permissions and to create report schedules.
• Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS) for the managers.
• Used SSRS to create customized reports, on-demand reports, ad-hoc reports and was also involved in analyzing multi-dimensional reports.
• Used SQLProfiler for troubleshooting, monitoring, and optimization of TSQL code.
• Performance tuning for existing queries in SQL ServerDatabases to reduce Production environment time cost.
• Improved the performance of many queries by reducing the usage of the cursors and other complex joins along with implementation of new indexes.
• Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
• Performed Data modeling for existing Databases using Toad Data Modeler and ER Studio.
• 24x7 support to meet the deadlines of tasks from customers.
• Creating documentation for all databases when they are in different stages.
• Be involved in the planning of system, development and deployment plans as well as responsible for meeting software compliance standards.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.
• Experienced in loading data into Oracle Database using Data Loader and SQL Loader
• Implemented named queries and created usage-based aggregations within SSAS Cubes to optimize performance.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
• Requirements gathering, technical analysis, impact analysis, design and Architect of BI systems.
• Created an efficient Ad-Hoc reporting architecture, so that the user could build reports for themselves from the existing reports
• Generated and implemented schema objects and application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and templates using ETL.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2012.
• Document the testing and maintenance of system corrections.
• Evaluate interface between hardware and software, operational requirements, and characteristics of overall system.

Environment: SQL Server2012, Microsoft SQL, MS SQL ServerIntegration Services(SSIS), SQL SERVERReporting Services(SSRS), .Net, Oracle, T-SQL, Red Gate SQLcomparator.

Confidential, NEW JERSY

MS SQL Server Developer /SSIS/SSRS

Responsibilities:

• Developed Queries for generating drill down and drill through reports in SSRS 2008 R2.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS2008 R2
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Created Linked servers to connect OLE DB data sources and providers.
• Administered the SQL Serverby creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency
• Designed and developed web user controls, master pages, validation controls, CSS files using C#.NET, VB.NET, XML, HTML and ASP.NET 2.0/3.5.
• Designing Logical and Physical Data Model with Erwin tools
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as requiredWorked with Installation/Management of MSTeam Foundation Serverand TFS Migration processes.
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed and deployed reports with Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
• Managing security roles in SQL Suite.
• Diagnosing and tuning the serveroptimal performance using SQL Server2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server2008 R2, SQL ServerIntegration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server2008, T-SQL, SQLProfiler, SQL ServerAgent, Oracle, MSExcel, XSLT, Visual Studio 2010, Asp.NET, VB.NET, C# .NET

Confidential

DWH Consultant

Responsibilities:

• Gathered functional and Business requirements and wrote technical specifications for building the Global Enterprise Data Warehouse.
• Involved in re-designing of database to create de-normalized reporting schema for better throughput.
• Used DTS, SSIS and Informatica 7.1 to extract the Data from Different Sources like DB2, SAP, and Oracle.
• Developed new mappings using transformations like Look Up, Aggregation, Derived Column, Data Conversion etc transformations to match the needs of the business case.
• Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Created DTSX Packages to import and export data from Excel, Access, SQL Server 2008 and Text files.
• Created SSIS Packages using Variables, Expressions and Environment Variables
• Created Production support packages.
• Migrated DTS 2005 packages to SSIS 2008 Packages.
• Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.
• Created MDX queries for different complex measurement and also included KPI for Graphical Analysis.
• Developed Store Procedures and User defined functions (UDF) to access data from Data Mart.

Environment: SQL Server 2005/2008 Enterprise Edition, Reporting Services, SQL Enterprise Manager, Informatica 7.1, Windows XP, Oracle, MS Access, MS Excel, Windows 7, HTML, Visual Source safe, Toad.

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQLServer.
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used SQLProfiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created Stored Procedures to transform the Data and worked extensively in T-SQLfor various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Responsible for Cleansing up database for Maintenance of the database.
• Responsible for unit testing, writing design documents and uploading it to share point server.

Environment: SQL Server 2005, T-SQL, MS.NET Framework, MSVisio, HTML, XML, VB.NET,SQLProfiler, Windows 2003 Server, Visual source safe(VSS).