MSBI SQl Developer
Resume:
Jaya Simha
*****@*********.***
MSBI SQL Developer
Professional Experience:
Over 7 years of experience as SQL Server/Business Intelligence Developer in database designing, modeling and reporting using SQL Server 2012/2008/2005, SSIS and SSRS.
Worked on each phase of data warehouse development life cycle- technical design and functional requirement documents, development, production deployment and support.
Experience with all phases of software development life cycle (SDLC) and project methodologies.
Expert in creating various SQL server objects like database, schemas, tables, indexes and indexed views, complex stored procedures, effective functions and appropriate triggers to facilitate efficient data manipulation and data consistency.
Well experienced in data extraction, transformation and loading (ETL) between homogeneous and heterogeneous systems such as Oracle, DB2, Sybase and MS Access using DTS,BCP,SSIS 2005/2008/2012 and creating complex work flows with different tasks, containers (for loop, for each loop, sequence) and different transformations.
Experience in developing custom reports and various Tabular Reports, Matrix Reports, Ad hoc Reports, Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
Experience in Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise manager.
Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
Expert in dashboards and visualizations using Xcelsius2008 and Tableau7.0/8.0/8.1.
Technical Skills:
Languages
C,C++,T-SQL, VB, .net, Java
Databases & Business Intelligence Tools
MS SQL Server 2012/2008/2005/2000, SQL Server Management Studio(SSMS), MS SQL Server Integration Services(SSIS)2012/2008/2005/2000, MS Access, Enterprise Manager, Tableau 8 Server/ Desktop
Web Technologies
XML Web Services, Microsoft Office SharePoint Server (MOSS) 2007
Reporting Tools
SQL Server Reporting services 2012/2008/2005/2000,Spotfire,Qlikview Logi XML, Crystal Reports
Web Server Technologies
Data Modeling Tool, ETL, Microsoft Visio, ERWIN, SharePoint
Operating System
Windows 2008, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX
Project Summary:
Client: Prudential Financial, Roseland, NJ Nov 15-Present
Role: MSBI Developer
Responsibilities
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 databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
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.
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.
Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
Created KPI Objects in line with Requirement Docs in SSAS.
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, Windows Server/professional, Oracle 12g, C#,VISIO, ERWIN.
Client: JB Hunt, Lowell-Arkansas Aug 2014 – Oct 2015
Role: SQL Server/MSBI Developer
Responsibilities:
Involved in installation of SQL Server 2008 with the latest service packs.
Created Views for specific columns on a table to maintain privacy of a customer data.
Worked on database capacity planning and space forecasting.
Migrated Database from SQL Server 2005 to 2008 by using side-by-side migration.
Created tables, indexes and designing constraints.
Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
Actively worked on SQL XML and X-path queries.
Wrote scripts to review object permissions in all databases.
Involved in Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
Involved in Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
Administered user, user groups, and scheduled instances for reports in Tableau.
Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
Migrated DTS packages from SQL Server 2005 to 2008 and scheduled their execution time.
Created SSIS packages using Active X scripts and with Error Handling.
Worked on enhancing and deploying the SSIS Packages from development server to production server.
Wrote stored procedures for report generation in SQL Server2008.
Successfully deployed reports in various sources like XML, Web browser and PDF.
Administered the created Reports by assigning permission to the valid user for executing the reports.
Created and Maintained Database Maintenance Plans.
Implemented Database Mirroring between Development and Test Server.
Involved in Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and deadlocks.
Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
Integrated SQL Server 2008 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
Reviewed Third Party tools so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
Environment: MS SQL Server 2005/2008, Tableau 8.0/8.1 server and desktop, SharePoint Portal, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, VSS, SQL Diagnostic Manager, Power Designer.
Client: Del Monte Foods BI-Rogers, Arkansas Jan 2013 – July 2014
Role: SQL Server/MSBI Developer
Responsibilities:
Dynamically supporting business users & Customers for given requirements and developed reports accordingly.
Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
Created various database objects such as tables, indexes and views based on the requirement.
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/DTS packages.
Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
Created database maintenance planner for the performance of SQL Server, which covers database integrity checks and re-indexing.
Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
Involved in creating and visualizing dashboards using Tableau Desktop.
Generated Tableau combination charts using Tableau visualization software.
Generated various reports with drilldowns, drill through, calculated members and dropdowns.
Created data sources, connection strings and defined the datasets for generating the report.
Using various report items like tables, sub report and charts to develop the reports in SSRS.
Deployed and generated reports on to the server using the Reporting Services Report Manager.
Built and deployed Report Models using Report Builder 2.0 to facilitate ad-hoc reporting for end users. Working with various Delivery mechanisms of Reports like Email /PDF/Schedules etc.
Created subscriptions to provide a daily basis reports.
Environment: T-SQL, PL/SQL, MS SQL Server 2012/2008/2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau 7.0, Logi XML, Spotfire, Qlikview, Business Intelligence Development Excel, Visual Source Safe (VSS), Windows XP, VB, Crystal Reports.
Client: Renaissance Soft labs, Hyderabad, India Feb 2009 – Nov 2012
Role: SQL Server Developer
Responsibilities:
Merged existing databases and to design new data models according to the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
Created joins and sub-queries for complex queries involving multiple tables.
Used DDL and DML for writing triggers, stored procedures, and data manipulation.
Install and Configure SQL Servers 2005 and 2008 on development server for designing and testing.
Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
Created complex Stored Procedures, Views, Triggers, Tables and other SQL joins.
Maintained data integrity by performing validation checks.
Provided research, design, and creation of a robust system ensuring effective processing of financial information from multiple external locations.
ENVIRONMENT: MSSQL Server 2005, Windows Server 2003/2000, Windows NT, Visual SourceSafe, DTS, MS Access, Enterprise Manager, Analysis services 2000,HP Helpdesk, MS office 2003,VB macros.
Contact this candidate