SUMMARY

• Technical & Management ownership of complexDatawarehouseand re - engineer existing ETL applications to improve cycle time.
• Around 8 years of IT experience in analysis, design & implementation of Business intelligence solutions with Microsoft SQL server 2016/2 /2000 in development, Testing & production environment. Well versed and Experienced in both OLTP and OLAP (Data warehousing) environments, Business Intelligence (BI) Project Development, Implementation and Administration from end to end by usingMicroStrategy9.x / 8.x Product Suites includingMicro StrategyDesktop, Web, Architect, Administrator, Intelligence Server. Network installation & Security and Computer Hardware Configurations respectively.
• Experience in creating workbooks and dashboards using Tableau Desktop, Server and Reader with various versions 7/8/10.
• Experience in Tableau Desktop/Server in creating highly interactive Data Visualization Reports and Dashboards using complex functionalities such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Experience in developing dashboards with different chart types like heatmaps, pie charts, geo maps, tree maps, symbol maps, gnats, scatter plots, line charts, area charts, and donut charts.
• Ability to build dashboards with techniques for analytics with interactive dashboard design with filtering, highlighting, ability to combine multiple data sources, fast creation by a user, easy sharing for visually best practices.
• Experience in designing Database Models using MS Visio and Erwin for both Relational and Dimensional modeling.
• Good knowledge of Data warehousing, Bottom-Up and Top-Down Design methodologies, Operational Data Store (ODS).
• Good experience in designing and developing web/windows applications, web services by using C#, ASP.NET, ADO.NET, WCF, AJAX, MVC, SQL server technologies.
• Used complex correlated subqueries, recursive queries, stored procedures to support the data mart.
• Manipulated large data sets and interpret results using data aggregation functions.
• Experience with Microsoft TEAM Foundation Server for Code Repository, Deployment and Version control.
• Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization. Proficient in using RDBMS Such as Oracle, SQL Server DB2 and Teradata.
• Proficient in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes.
• Developed Dashboard Reports usingSSRS, Report Model and Ad Hoc Reporting using Report Builder.
• Hands on experience in development ofSSRSreport from OLAP cubes using MDX script.
• Hands on experience in providingSSRSserver level, item level Security & Accessibility to various reports in multi-user environment.
• Experience in developing Teradata databases, manipulating data and making change to dimensions in databases using Teradata Utilities.
• Expertise in Teradata tools & Utilities like Fast Load, Multi Load, Fast Export, TPump and Teradata Parallel Transporter (TPT) & BTEQ
• Expertise in configuring report manager for creating report subscriptions, snapshots, and caching.
• Good Exposure toTeradataSQL and BTEQ Scripting
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Proficient inTeradataDatabase Design (Physical and Logical), Application Support, Performance Tuning, Optimization, User & Security Administration, Data Administration and setting up the Test Development environments.
• Expertise in Developing Reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
• Expert in implementing star and snowflake schema methodologies for design cubes and applying dimensional modeling using SSAS. Proficient in dimensional data modeling, and cube development, partition, aggregation and optimization using SSAS.
• Worked Extensively for Designing, Maintaining and deploying cubes in the data warehouse using SSAS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expert in creating Power pivots, Power Views andSSRSreports using Tabular Model (DAX), Cubes (MDX) and SQL queries.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Monitored and Tuned MSSQLServer databases with tools like Index Tuning Wizard,SQLProfiler, and Windows Performance Monitor for optimal Performance.
• Good understanding of programming languages, development tools.
• Excellent analytical/communication skills, Team Play and very much result Oriented.
• Having hands on experience inHadoop Big Dataprocessing.

TECHNICAL SKILLS

Tools: & Packages SQL Server Management studio, Enterprise Manager, SQL Profiler, SQL Server Business Intelligence studio (BIDS), SQL Server Data tools 2012, Microsoft TFS, Report Builder 9.0, Crystal Reports, SharePoint, Ad Hoc Reporting and Web Focus Reporting,Tableau 10.

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Power BI,Tableau 10

Databases: MS SQL Server 2016/2012/2008 R2/2008/2005, Oracle,Hadoop,Sybase,DB2

Language: SQL, T-SQL, PL/SQL, VBA, JAVA, MDX, HTML, CSS, XML, C, C++, C#, ASP.NET, VB.NET

Operating Systems: Windows 10, Windows 8, Windows 7, Windows vista/XP.

Application Packages: MS Office Suite, MS Outlook, MS Excel,Visual Studio, Windows SharePoint Services

Data Modeling Tools: MS Visio 2007/2010/2013 , Erwin 4.1

App & Web Servers: WebLogic, WebSphere, Tomcat, JBoss, Apache, Atlassian JIRA & Bamboo, IBM IHS, MS IIS

PROFESSIONAL EXPERIENCE:

Confidential, Culver City, CA

Business Intelligence / Data Warehouse Engineer

Responsibilities:

• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• BuildingSSAS cubesto expose detail level data in the data warehouse to the business users.
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
• BuildingSSRS Reportsand Dashboards pointing to the Data Warehouse for reporting summarized data.
• Developed SSIS Packages.
• Experienced in all phases ofUI/UX implementation of a Travel Search and Booking web application including Design, Prototyping, Development and Testing phases.
• Designed and documented the Metadata management for the AnalyticsData warehouse.
• Generated Parameterized/dropdownSSRSReports.
• Met with the project manager frequently for reviewing project goals and for creating proposals for future developments and researching their fields forUIdesign.
• TeradataSP/View/BTEQ development and involving in the code review meetings.
• Developed Unix shell scripts to triggerTeradataSP/BTEQ and worked withTeradataUtilities such as Multi Load, Fast Load, Fast Export, BTEQ.
• Optimized and enhanced the reporting dashboards using VBA programming
• Provided consultation to the Support group on Data modeling andDatawarehouseArchitecture
• Safeguarding data by instilling backup, managing user access and securing databases.
• Developed different account level and security level reports usingSSRS.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (10.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Wrote the queries for the drill down reports, parameterized reports.
• Implemented partitioning on several fact tables indatawarehouseusing Clustered Column Store indexes
• Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery.
• Designed and developed matrix and tabular reports for each serial number related data across different tables with drill down, drill through and drop-down menu option usingSSRS.
• Involved in a Waterfall based approach toUIDevelopment.
• Scheduled reports every week to Business analyst and customer representatives for various categories and regions for data analysis using SQL Server Reporting services (SSRS).
• Provides SharePoint support to end users.
• Designed and develop data marts on SQL server and its utilities such as Fast Load, Multi Load, Fast export, TPump and BTEQ
• Used All fusion ERWIN to deploy any changes to the database and objects from test to production.
• Developed Web services using C
• Used ASP.NET web form controls such as Grid View, List View, etc. for displaying data.
• Involved in developing WCF Web Service using SOAP/HTTP to communicate with legacy systems.
• Used front end web development tools like CSS, JavaScript, DHTML
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS packages.
• Created Different Graphs and Charts for analyzing related Information using Power BI Features. (Power Query, PowerPivot and Power view).
• Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.

Environment: AS400/DB2, Visual Studio 2013,Teradata v15, SQL Server Management Studio 2012, T-SQL, SSAS, SSIS, SSRS, Power BI,ASP.NET MVC4, C#, Entity Framework, Web API, SQL Server, Team Foundation Server (TFS),Tableau,Query Studio, CognosConnection),Web focus Reporting, Share point 2013,Tibco Spotfire Professional 3.2,3.3,4.0,5.0 Spotfire Web player,Tableau 10.3, Business Objects

Confidential, Berkeley Heights, NJ

ETL Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• As an ETL/Report Writer Tech lead, lead the Offshore Philippines team in designing and developing ETL structures, SSIS packages &SSRSreports for enhancements in Data warehouse.
• Involved in writingTeradataSQL bulk programs and in Performance tuning activities forTeradataSQL statements usingTeradataEXPLAIN
• Specialized in Tabular Models using SQL Server Analysis Services
• Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Built the ResponsiveUIscreen for creating new customer process, Create bill to and ship to screens, customer search results page, and customer dashboard page using Bootstrap.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Converted complex Oracle PL/SQL packages, functions, procedures to SQL Server 2012(T-SQL).
• Implemented partitioning on several fact tables indatawarehouseusing Clustered Column Store indexes
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.
• Experience with SSAS Tabular Model.
• Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters usingSSRS.
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions usingSSRS.
• Experienced in using Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models
• Master level information of creating SSIS, SSAS, SSRS arrangements and MDX and DAX inquiries.
• Experienced in composing MDX inquiries for multidimensional Analysis OLAP and Tabular Data Marts.
• Involved in creating calculated members, named set, for the SSAS cubes.
• Created Workflows using SharePoint Designer 2013.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Responsible for the migrating the reports from Development to Acceptance / Production Server.
• Design and develop Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Re-programming the existing web methods service modules in WEB API.
• Developed Reports using Power BI

Environment: MSSQL Server 2012/2008, TeradataV14, Visual Studio 2010/2008, Reporting Services (SSRS 2008), .NET 4.0/3.5, Business Intelligence Development Studio (BIDS), Tableau Desktop 7.0, 8.2, Power BI,MicroStrategy9.2.1 (Administrator, Architect, Desktop,MDX,Web, Object Manager, Integrity Manager), MS Office 2007, Office 365, PowerPivot, UNIX, MS Access, OLTP and OLAP (Data warehousing), SVN Tortoise, ETL, MS Excel, Oracle SQL developer.

Confidential, Dallas, TX

SQL Server/ Business Intelligence (BI) Developer

Responsibilities:

• Develop and modify stored procedures and T-SQL scripts in response to validation exceptions.
• Write and maintain stored procedures and functions using T-SQL and SSMS
• Create and maintain complex queries in Microsoft SQL Server using T-SQL
• Involved in creation of Dimensions using Star and Snowflake Schema.
• Developed OLAP Cubes, Dimensions, Data Source View, Partitions and Aggregations.
• Created and documented workflow for populating data from Staging database toDatawarehouse.
• Responsible for identifying and defining Data Source and Data Source Views.
• Defined attribute properties in a Parent Child Dimensions.
• Coding using BTEQ SQL ofTERADATA, write Unix scripts to validate, format and execute the SQL's on UNIX environment.
• Technical & Management ownership of complexDatawarehouseand re-engineer existing ETL applications to improve cycle time
• Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
• Improved performance, reliability, security and scalability by improving internal processes and make recommendations on new storage hardware.
• Responsible for creating complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in writing dimensions using DAX language based on the user requirement
• Experience in creating SSAS 2012 tabular model by adding tables to the model and creating relationships between tables,Knowledge in creating calculated fields with MDX code and DAX queries to meet additional measures needs that are calculated from existing measures.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Expertise in Tableau 7, 8, Business Objects 4.3 and SAP Business Intelligence 7.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Implemented cell level security in cubes using MDX expressions and DAX to restrict users of one region seeing data of another region using SSAS.
• Developed, Deployed and Monitored SSIS packages.
• Created packages using Integrated Services (SSIS) for data extraction from Flat files, Excel Files, OLE DB.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS,MDX, Power BI, T-SQL, Tableau,ASP.NET MVC4, C#, Entity Framework, Web API, SQL Server, Team Foundation Server (TFS),Windows Server 2008, Windows 7.

Confidential, Phoenix, AZ

SQL/BI Developer

Responsibilities:

• Understanding customer requirement via interaction and writing functional specification.
• Made SSAS forbidden model for Analytical detailing administrations.
• Used data modeling tool ERWIN to configure tables and define relationship.
• Knowledge in creating calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Provide 24/7 support as sole DBA
• Involved in daily SCRUM meetings to keep track of the ongoing project status and issues. Involved in Waterfall based approach toUIDevelopment.
• Involvement in making Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Converted existing BO reports to tableau dashboards
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Design SSIS packages to transfer data from Heterogeneous database and different files format to SQL Server.
• Migration of database from SQL Server 2000 to SQL Server 2005.
• Worked in Tabular Models utilizing SQL Server Analysis Services
• Great involvement in outlining and creating web/windows applications, web benefits by utilizing C#, ASP.NET, ADO.NET, WCF, AJAX, MVC, SQL server advances.
• Create and alter put away techniques and T-SQL contents because of approval exemptions.
• Compose and keep up put away techniques and capacities utilizing T-SQL and SSMS
• Developed additionalUIComponents using JSF and implemented an asynchronous, AJAX based rich client to improve customer experience.
• Used Bootstrap and Angular JSUIBootstrap for creating rich, ResponsiveUIScreens for varying screen sizes and devices.
• Make and keep up complex inquiries in Microsoft SQL Server utilizing T-SQL
• Used front-end web advancement devices like CSS, JavaScript, HTML and JQuery.
• Testing and Tuning SQL query for better performance.
• Involvement with the BI devices Tibco Spotfire Professional, Web player, Tableau and Business Objects.
• Created Indexes and proper re-indexing for intensive OLTP system to ensure best performance. Responsible for designing advanced SQL queries, procedure, cursor, triggers and scripts.

Environment: MS SQL Server 2005, Crystal Reports,Power BI, Tableau Desktop 7.0, 8.2,SSIS, SSRS, SSAS, Tableau, MDX,T-SQL, Windows XP Professional, MS Visio 2000.

Confidential, Irving, TX

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SSIS Packages according to the requirements.
• Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Created SSAS tabular model for Analytical reporting services.
• Design and setup of firewall systems, and DNS servers from scratch Stage (Extract) the source data from files, SQL server, Oracle, DB2 sources.
• Worked with Flat Files (Pipe Delimited) sources and implemented error handling routines.
• Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
• Taken a shot at creating preparing program, client control for Spotfire Professional and Spotfire web player as far as best creating and configuration hones.
• Created OLAP Dimensions, Measures and Cubes using SSAS.
• Expertise in Tableau 7, 8, Business Objects 4.0, 4.1, and SAP Business Intelligence 7.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Constructed OLTP and OLAP Databases.
• Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
• Wrote custom functions to produce the derived fields using the source table fields for each record from source.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
• Worked with Date/time manipulations in SQL Server 2005 built in functionalities as well as Data Integrator Date functions

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), SSAS 2005,Oracle 10g. Analysis Services (SSAS), DTS, T-SQL Tableau, MDX,Power BI, Windows 95/NT/2000/2003, XML, MS Excel, MS Access.

Confidential, Collegeville, PA

SQL Server Developer/ DBA, SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
• Used Try catch and @@error for exceptional handling.
• Experienced in utilizing Data Analysis Expressions DAX to make custom computations in PowerPivot for Microsoft Excel exercise manuals and Analysis Services forbidden model activities
• Used DAX (Data Analysis Expressions) capacities for the formation of counts and measures in the Tabular Models Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio
• Used Active Directory for Identity management designed to provide strong authentication and authorization for internal and external websites.
• Expertise in Tableau 7, 8, Business Objects 4.0, 4.1, and SAP Business Intelligence 7.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Created queries for generating drill down reports in SSRS 2008/2005.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2005 and Worked with users in and support and have experience in incremental data loading. Managed upgrade of DTS packages to SSIS packages

Environment: SQL Server 2008/2005/2000 Enterprise Edition, SSRS, SSIS, SSAS,Tableau, SQL Server 2005 Partitioning .NET Framework, C#, ASP.NET, ADO.NET, Oracle 9i/ 10g, Visio 2003, MS IIS,MDX, Windows 2000/2003 Advance Server, XML, MS Excel, Access and Visual source safe.

Confidential, San Jose,CA

SQL Developer/ DBA

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Responsible for MS SQL Server Installation and configuration, applied service packs and hot fix.
• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Involvement in working with SSAS in making blocks, information source sees, named questions, measurements and sending of investigation administrations ventures.
• Involvement in SSIS, SSAS and SSRS of MS SQL Server apparatuses.
• Wrote User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database.
• Created Triggers to enforce data and referential integrity.
• Created Constraints, Defaults, Views and Indexes.
• Developed Master/Detail Reports and Tabular reports using Crystal Reports

Environment: SQL Server 2000, Windows NT 4.0, Crystal Reports 9.0.

Confidential

SQL Developer

Responsibilities:

• Managed database objects like stored procedures, views, tables etc.
• Optimized queries that were taking long time to display desired result set.
• Created groups, roles, users and assigning access privileges to users.
• Created new stored procedures and modifying existing ones as per business requirements.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services(SSRS)
• Performed data analysis to generate various trend reports.
• Performed identification, analysis and resolved report defects within time scope and established development guidelines.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.

Environment: MS SQL Server 2000, T-SQL, DTS.