We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

3.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY:

  • 8+ years of extensive Experience in the Business Requirements Analysis, Development, Testing, Implementation and maintenance of Business Intelligence, Data warehousing, Client Server applications, Web applications, Tableau Desktop and Tableau Server.
  • 6+ years of Experience in Tableau Desktop/Server 10.5,10.4,10.3,10.2,10.0,9.1,8.2,8.0, creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
  • Technically hands - on commercially experience mainly with full range of BI Skills with Tableau 10.5,10.4,10.3,10.2,10.0,9.1,8.2,8.0, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server (PPS 2007) and Informatica.
  • Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012, 2008, 2005 and 2000.
  • Created 1000+ worksheets and 200+ Dashboards in large BI environments using Tableau.
  • Extensive usage of Tableau 10.5 features like Viz in Tooltip, Power trendlines, Hyper & Nested Projects.
  • Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
  • Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public. Strong understanding of project life cycle and Software Development Life Cycle(SDLC) methodologies including RUP, RAD, Waterfall and Agile.
  • Used the API for the functionality enhancement on server for site users and sites on Tableau server.
  • Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services
  • Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
  • Used Sign in Method using the REST API for successful sign in operations
  • Used the REST API with Tableau server to manage and change Tableau server resources programmatically.
  • Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
  • Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
  • Experience in Developing, Designing and Support inter active Tableau dashboards. Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQL SERVER
  • Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Joins, Keys and Data Import/Export.
  • Experience in developing and debugging Stored Procedures and Triggers.
  • Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
  • Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
  • Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
  • Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
  • Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
  • Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
  • Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
  • Experienced in Data Analytics and Machine Learning with strong skills in analyzing large datasets using R, Weka and AWS.
  • Expert Knowledge of Integration Services (SSIS), Analysis Services (SSRS) and ProClarity.
  • Proficient with T-SQL, SSIS including developing and maintaining packages, developing connectivity to QlikView, SSRS, using SOAP, XML, etc., as well as having prior experience with DTS/SSIS and other ETL tools.
  • Creating and managing Data Warehouses Using SQL Server.
  • Excellent troubleshooting techniques and experience with Replication, Migration and DTS
  • Strong in PowerShell scripting and automating day to day maintenance tasks using PowerShell scripts, converting existing T-SQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2014/2012/2008 R2/2005/2000, MS Access, Oracle 11g/10g, PostgreSQL, MySQL, DB2, Mongo DB, Teradata, Cloud Computing/ Amazon Web Services - AWS, Amazon Red Shift, Netezza

BI Tools: Tableau Suite of Tools 10.5, 10.4, 10.3, 10.2, 10.1, 9.3, 8.2, 8.1, 8.0, 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server, Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports, Power BI, MicroStrategy and Cognos.

Reporting Tools: SQL Server Reporting Services, Power BI, MS Excel, Oracle Report Builder & Tableau

Programming Languages: T-SQL, PL/SQL, C, C++, Java, Unix, Python, XML

Web Scripting Languages: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling

Operating System: Windows XP/7/8/10, Linux/Unix, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Tableau Developer

Responsibilities:

  • Created Tableau Bread Crumbs, using Tableau filter actions for Tax reporting system Dashboard.
  • Developed POCs by building reports and dashboards using Tableau 10.4 to demonstrate quick wins.
  • Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Developed reports, dashboards using Tableau 10.4 for quick reviews to be presented to Business and IT users.
  • Developed Tableau Excel incremental refresh for year 2017 and up to Jan 2018 at vanguard for various financial dashboards.
  • Involved in analysis of Key Performance Indicators (KPI's)
  • Involved in the design and conversion of KPI's into Tableau Dashboard reports, using chart such as pie, bar, line, maps, stack bars, dual axis graphs, etc.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data. Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
  • Worked on Creating various plots and drill down analysis using Tableau desktop 10.4. Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences.
  • Worked on creating schemas and connecting tableau to AWS Redshift and Hive
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization and Financial dashboard
  • Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau 10.3.
  • Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
  • Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Worked with client and team members to understand and clarify visualization requirements and check performance tuning of dashboards.
  • Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
  • Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using Data blending.
  • Worked in Tableau 10.3 environment to create dashboards like weekly, monthly, daily reports using Tableau desktop 10.3 & publish them to server.
  • Tested reports and uploaded Tableau dashboards onto server and provided production support for Tableau users
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 10.3.
  • Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web.
  • Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
  • Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access. Successfully administered users, user groups, and scheduled instances for reports in Tableau 10.3.
  • Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server, Dashboards, Tableau Desktop, SQL Server 2016, Tableau 10, Business Intelligence, Teradata, Management Studio, JIRA.

Confidential, Columbus, OH

Sr. Tableau Developer

Responsibilities:

  • Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
  • Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to Tableau reports and Dashboards.
  • Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.
  • Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
  • Installed and Monitored of Tableau Server 9.1.4 (Dev and Prod) on AWS Environment.
  • Involved in managing the application's users, groups, and integration with Active Directory
  • In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
  • Evaluated database performance issues and executed database optimization.
  • Prepared backups using Tab admin and Tab cmd commands.
  • Promoted and supported the infrastructure of reporting and Power BI strategy, including standards and best practices.
  • Use various data source like SQL server, SQL Analysis server (cube), Amazon Redshift, Hadoop and Hive
  • Expertise in installing, configuring, Clustering, Load balancing and Multi-node installation of Qlik view and Qlik Sense Environment
  • Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.
  • Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS
  • Created SQL Server Reports and developed query for generating drill down and drill through reports using Power BI
  • Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
  • Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.
  • Created different hierarchical, interactive storage reports using C#.
  • Collaborated with a team of .NET developers in designing and developing enhancements to a large enterprise application developed in C#.
  • Wrote heavy Netezza SQL scripts to load the data between Netezza tables and implemented ELT process for SCD type 1 and SCD type 2 dimensions
  • Implementation of Physical modeling on Teradata such as creation of tables, indexes, views, normalization.
  • Strong experience in creating the extensions using Java script both in Qlik view and Qlik Sense.
  • Involved in designing Amazon Redshift DB Clusters, Schema, and tables.
  • Security implementation among Congo's applications using Access Manager Documenting API guides for development web portal.
  • Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
  • Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
  • Interacted with user groups for delivering 100+ enterprise Reports using SSRS/Crystal reports for various reporting needs.
  • Having good experience on Portal Administration in Congos Connection.
  • Connected to Amazon Redshift through Tableau to extract live data for real time analysis.

Environment: Tableau Server, Tableu Desktop, SQL Server, Query Analyzer, SSIS, T-SQL, Business Intelligence, Excel, Microsoft SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), SQL Server Management Studio

Confidential, New Orleans, LA

Sr. Tableau Develop

Responsibilities:

  • Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business.
  • Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
  • Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Log Axes, Groups, hierarchies, sets to create summary level and detailed Reports.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Tableau.
  • Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve the needs of a broad and diverse user base, including both internal and external users
  • Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports.
  • Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
  • Played critical role in establishing Best practices for Tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
  • Connected Tableau server with SharePoint portal and setup auto refresh. Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
  • Worked on understanding of relational database structures, theories, principles and practices.
  • Wrote Custom SQL scripts for creating aggregate tables and generating views.
  • Effectively used data blending feature in Tableau to integrate different database tables. Designed and developed various analytic reports /dashboards using Tableau.
  • Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
  • Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
  • Built Excel, Qlik View and Domo reports in Tableau.
  • Migrating all the reports from Tableau 9.3 to tableau 10.3 and publishing them on the server.
  • Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
  • Resolved various performance issues and analyzed the best process distribution for different projects. Assisted power users in Tableau dashboard development.

Environment: Tableau Desktop, Tableau server, SQL Server, Oracle 10g/9i, Microsoft Excel 2012, Microsoft office 2012.

Confidential, West Chester, MD

Tableau Developer/Admin

Responsibilities:

  • Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Designed and built statistical and machine-learning models and feature extraction systems in Python and R Programming
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
  • Studied various Statistical Data Mining Methods, Random Forests, Neural Nets and applied them on data to get insights using R Programming.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Have clear understanding of Data Warehousing concepts with emphasis on ETL, BI and Life Cycle Development including requirement analysis, design, development, testing and implementation
  • Expertise in installing ECC/BW on HANA, Administration of HANA systems, HANA studio, HANA migration, S/4 HANA migration using DMO option, HANA system backup/restore
  • Managed selection, architecture and implementation of a SaaS reporting and Data analytics platform for medical data collection using Tableau analytics server technology to provide dashboard reporting and client project health in real-time using the web or mobile devices.
  • Power BI developer with skills as well to help deliver a set of dashboards.
  • SAP Solution Manager implementation activities like Installation, Post installation activities, Technical Monitoring for different SAP components like ABAP, Java, HANA, MS SQL, R programming, EWA configuration, MOPZ, Maintenance Planner, etc.
  • Monitor and plan for Teradata disk space quotas. Promptly respond to warnings that disk space is running low.
  • Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database
  • Involved in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI
  • Good Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
  • Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Handling big data loads to Qlik view and Qlik Sense and implemented impactful solutions.
  • Creating users, groups, projects, Data connections, settings as a Tableau administrator.
  • Involved in creating dashboards and reports in Tableau 8.1.
  • Created report schedules on Tableau server.
  • Review new API development specification releases and update portal content.
  • Created rich dashboards using Power BI to deliver actionable insights for end client.
  • Used Python and R Programming to develop analytical and reporting solutions to visualize data and information using Microsoft Power BI
  • Designed schema in Amazon Redshift cluster to store EBS operational data optimally.
  • Experience in using Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards Score Cards using R Programming.
  • Designed Amazon Redshift based Power BI solution platform for optimized performance and usability.
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Worked on tab cmd to schedule the report's and setup email reports using command lines.
Confidential, Chicago, IL

SQL/BI Developer

Responsibilities:

  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
  • Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.
  • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
  • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
  • Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
  • Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
  • 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 packages.
  • Teradata development and OLAP operation with Teradata database
  • Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
  • Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
  • Created and modified various Stored Procedures used in the application using T-SQL.
  • Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
  • Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
  • Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
  • Created the required Metrics and KPI's using DAX formulas.
  • Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Environment: MS SQL Server 2012/2014, Visual Studio 2012/2013, SSIS, SSAS, SSRS, Agile Scrum, Web Services, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent, XML, VMware, MS Excel, Team Foundation Server (TFS) 2013.

Confidential

SQL/BI Developer

Responsibilities:

  • Developed dashboards and worksheets by blending multiple data sources such as Sql Server and excel data.
  • Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
  • Built dashboards for measures with forecast, trend line and reference lines.
  • Generated reports using SQL queries in Tableau & published them to users in online thru Tableau server.
  • Involved in most of phases (SDLC) of this project from requirement gathering, develop, unit test and implementation.
  • Created automated procedure to upload data in excel format and upload into the database.
  • Optimized and performance tuned existing reports to provide smooth user functionality.
  • Involved loading data application into the database and automated procedures to load them on weekly basis.
  • Generated context filters and data source filters while handling huge volume of data
  • Have used various Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.
  • Setup and configure new server and migrate existing data, SSIS packages, store procedures and automated tasks by creating partitions of tables, create views and store procedures for the surveillance systems.
  • Performed ETL operations using SQL packages load data from legacy systems and automated the process by scheduling jobs to run periodically.
  • Creating and maintaining databases, tables, views, users, logins, Indexes, check constraints, and business rules. Responsible for Performance tuning the queries, stored procedures and tables by creating indexes on the tables.
  • Wrote complex SQL Queries involving multiple tables with joins and generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Developed SQL Joins, SQL queries, tuned SQL, test tables, scripts in development environment
  • Writing complex SQL queries using Joins, Sub queries and Functions in PL/SQL to retrieve data from multiple tables and developed stored procedures for both backend and frontend applications.
  • Generated reports published them to users in online.
  • Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Modified different procedures, functions, views, and tables, related to the development work.

Environment: MS SQL Server 2012, Visual Studio 2012, SSIS, SSAS, SSRS, Agile Scrum, Web Services, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent, XML, VMware, MS Excel, Team Foundation Server (TFS)

Confidential

SQL Developer

Responsibilities:

  • Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
  • Designed and implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts. Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
  • Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
  • Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
  • Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
  • Extensively worked on VMware workstation.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Created and executed SQL Server Integration Service packages to populate data from various data sources, created packages for different data loading operations for many applications.
  • Interacted with people from various teams in the Project like Oracle/Teradata DBAs', Maestro Schedulers, Spec. Creators, Reporting, Unix etc. to aid in the smooth functioning of the Project flow.
  • Implemented fine tuning of database objects and server to ensure efficient data retrieval.
  • Used Enterprise Manager for job scheduling and batch queries.
  • Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Environment: MS SQL Server 2008, Windows XP, SSIS, SSRS, T-SQL, OLAP, OLTP, Data Mart, ETL, MS Office 2003

We'd love your feedback!