Sql Server Data
Resume:
Manohar Akula
SQL Server BI/ Tableau Developer
acvdbo@r.postjobfree.com
Mobile: 404-***-****
Professional Summary:
Professional Summary:
Over 8+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2012/2008 R2/2005 in Production, QA and Development Environments.
3+ Years of extensive experience in various versions of Tableau 8.x/9.x (Desktop, Server, Reader, Online, and Public) as a Developer and Analyst.
Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T-SQL Scripts in MS SQL 2012/2008 R2/2005.
Experience in Creating Tables, Views, Complex Stored Procedures, Triggers to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
Experience in optimizing the query by creating various Clustered, Non-clustered indexes.
Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
Experience in using the Dimensional Modeling techniques such as Kimball
Star Schema and Snow Flake Schema. Experience in developing SSAS Cubes, Dimensions and data source views and Deploying and Processing SSAS objects
Expertise in creating complex SSRS reports against OLTP, OLAP databases.
Experience in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports.
Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS )
Experience in using Expressions to customize SSRS reports dynamically.
Expertise in Report Caching and Subscriptions including Standard and Data-Driven Subscriptions.
Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
Hands on experience with performing various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server
Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.
TECHNICAL SKILLS:
Operating System
Databases
Programming Languages
Business Tools
Database Tools
Reporting Tools
ETL Tools
Other Utilities
Windows 2008 Enterprise/Datacenter Server, XP Professional and Windows 2000.
MS SQL Server 2012/2008 R2/2005, MS Access, My SQL
T-SQL, SQL, MDX.
Word, Excel, PowerPoint, Access, Visio, Outlook.
SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Query Analyzer, SQL Client Utility and TERA DATA
Reporting Service (SSRS) 2012/2008 R2/2005 and Tableau
ETL packages, SQL Server Integration Services
Management Studio, Visual Studio, Internet Information Server (IIS 5.0 / 6.0), power pivot and power view.
PROFESIONAL EXPERIENCE
Company: Paramount Software Solutions, GA
Client: Home Depot, Atlanta, GA April 2014 – Current
Sr. SQL/Tableau Developer (SSRS, SSAS, SSIS, Tableau)
Responsibilities:
Involved in development and implementation of SSIS,SSAS and SSRS application solutions for various business Projects across the organization
Created various complex reports, Dashboards and manage them using SQL Server Reporting Services (SSRS 2012/2008R2/2008)
Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as 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.
Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
Wrote and integrated stored procedures to generate the special reports according to client’s need.
Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
Created OLAP cubes using SSAS and created reports from the OLAP cubes using SSRS.
Deployed SSRS Reports with SharePoint integration mode
Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Sharepoint.
Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
Designed ETL structures for data imports from various sources such as Oracle, Teradata, Excel, Access and DB2.
Generated dashboards to provide trends of data using statistics and KPI’s for top management.
Created dashboards that displays key information for decision making purpose using Heat maps, Geo maps, Tree maps, Pie charts, Bar charts, Circle views, Line charts, Area charts, Scatter plots, and Bullet graphs.
Utilized Data story telling in Tableau to provide more dynamic and more effective stories from the hidden insights locked in the data.
Created action filters, hierarchies, groups, and calculated sets for preparing dashboards and worksheets using Tableau (Desktop).
Published the developed dashboards and reports on the Tableau Server so that the end-users having access to the server can view the data.
Scheduled frequency and time to refresh data when sources are published or extracted to server.
Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
Performance tuning of Queries and Stored Procedures.
Created SSIS process design architecting the flow of data from various sources to target.
Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
Performed unit and system testing, troubleshooting and bug fixing in development and QA environments
Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS),SQL server Data Tools(SSDT),Tableau, MS Excel, Windows XP, SQL Server Management Studio (SSMS), Tableau, Teradata,TFS and SharePoint 2013.
Company: I.T .Software Solutions, FL
Client: Home Depot, Atlanta, GA Nov 12 – April 14
SQL Server/BI Developer (SSRS, SSAS, SSIS)
Responsibilities:
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.
Worked independently on a Project Called Back Order Relief Process for IPR (Inventory Planning and Replenishment) to build ETL process by gathering the requirements and pull data from multiple sources (flat files and Access DB) to SQL to provide Useful SSRS reports and Dashboard to the Business users.
Worked on Operations Visibility reporting project that helps the SCD (Supply Chain and Distribution) team to effectively utilize the resources within the distribution center
Also worked on Order Age reporting project, which helps the business monitor the Order fulfillment process and use the calculated On-time percentage metrics to determine the performance within the distribution center
Worked on Onboarding the WMS (Warehouse Management System) Oracle data and landed the data tables on our production SQL Server with process indexing and considering other constraints
Then, worked on a project called Oversell for IPR (Inventory Planning and Replenishment) team to build them an ETL process where we upload the Skus (Storekeeping units) that are on sale in The Home Depot website and process and calculate sales related metrics using the sales data that pull periodically from a WCS (Warehouse Control System) that sits beneath the .COM to provide useful SSRS reports to business users who monitor the sales of individual Sku’s and add or remove them off The Home Depot website based on the Available quantity
Identified the dimension, fact tables and designed the data warehouse using star schema.
Created volatile tables and partitioning the tables and Responsible for supporting existing projects using Teradata SQL assistant tool.
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
Involved in Normalization of the database and bringing it to 3NF. Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
Developed and responsible for development of Dashboards in Tableau
Experience in creating reports and performing business analysis in Tableau
Developed various operational Drill-through and Drill-down custom reports using .Net framework 3.5 within SSRS.
Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
Production support, troubleshooting and debugging in a high volume transaction processing environment.
Support existing projects over the holiday season to ensure the business had all the data and reports available.
Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, MS Access, Windows XP, SQL Server Management Studio (SSMS), TFS, SharePoint, Tableau and Tera Data.
Company: Comlogic Professional IT Services, UK
Client: National Health Services, UK April 10 - April 12
Role: Business Intelligence Developer
Responsibilities:
Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently
Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables
Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS (Data Transformation Services) and also Bulk Insert for ETL purposes.
Created SSIS packages for the extracting, transforming and loading the data from MS Access into SQL Server 2005.
Created OLAP cubes using SSAS and created reports from the OLAP cubes using SSRS
Involved in Generating on-demand and Scheduled Reports for business analysis or management decision using SQL Server Reporting Services.
Created Excel based reporting tools using power pivot tables and SSAS cube driven data sources.
Worked for SSRS for report generation using Excel spreadsheet and also from MS Access.
Involved in creating cubes in Business Intelligence Development Studio (BIDS), deploying them on the server and processing the OLAP cubes to generate aggregate data for faster querying.
Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
ENVIRONMENT: MS SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Windows 2003 Server, XML, MS-Access, MS-Excel.
SVL InfoTech Private Ltd, Chennai, India Jan 06 - Feb 08
Role: BI Developer
Responsibilities
Created database objects like Tables, User Defined Functions, Triggers, Procedures, Functions, Indexes and Views, SQL joins and statements as per the team’s request through team tracks.
Involved in supporting database & BI (ETL, Analytics, and Reporting) activities for various applications and teams across all business units.
Designing, processing and deploying Cubes from the different fact and dimension tables based on the business requirement using SSAS
Developed reports from these OLAP cubes using SSRS.
Used Analysis Services (SSAS) processing task to update with the current data.
Involved in dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements.
Created Monthly portfolio reports using SQL Server Reporting Services (SSRS).
Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2005/2008.
Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format
Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management Studio (SSMS).
EDUCATION & CERTIFICATIONS
Master’s In Business Information systems Management from North Umbria University,UK (2008-2010)
Microsoft Certified IT Professional (MCITP) –April 2011
Contact this candidate