We provide IT Staff Augmentation Services!

Sr. Sql Bi Developer Resume

Dallas, TX

SUMMARY:

  • Over Eight (8+) years of extensive experience in database design, development and administration of Microsoft SQL Server versions 2008/2008R2/2012/2014 using SSIS, SSAS, SSRS.
  • Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Views, Functions, Triggers (DDL and DML), indexes, and functions.
  • Good understanding of Normalization and De - normalization, Normal Forms in creating Database Objects with Constraints like Primary key, Foreign Key, Unique and Default.
  • Good Experience in various packages of SSIS, SSAS and SSRS designing, constructing and deployment
  • Expertise in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures, dimension members using Microsoft Analysis Services (SSAS).
  • Experience in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for operational data.
  • Experience in providing Logging, Error handling using Event Handler and Custom Logging for SSIS Packages
  • Experience in design and implement processes for deploying, managing and extracting data using SQL Reporting Services SSRS and SSAS.
  • Good experience in data modeling and metadata services.
  • Knowledge on Tableau Reporting Tool.
  • Good understanding of TIBCO Spotfire platform.
  • Good experience in Spotfire for loading data from databases and creating visualizations.
  • Hands on experience in identifying and resolving performance issues in various levels like sources, mappings.
  • Hands on experience in optimizing SQL scripts and improving performance in loading warehouse.
  • Experience in creating tabular, matrix reports (crosstab or pivot), charts and graphs using SSRS and Power BI.
  • Expertise in executing workflow from COSMOS to SQL DB using MSFT Internal tools.
  • Proven experience in front end design and development using HTML, XML, JavaScript.
  • Strong knowledge development processes, Agile and scrum methodologies.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills also, strong analytical skills.

TECHNICAL SKILLS:

Languages & Web Technologies: T-SQL, SSRS, SSAS, SSIS, SQL-Server, Java, PHP, MySQL, C++, C#, HTML, CSS, Java Script, AJAX, XML, SOAP

SDLC: Agile, Waterfall

RDBMS: SQL Server (T-SQL), MySQL, Oracle

Reporting Tools: SQL Server Reporting Service (SSRS)

BI Tools: Power BI, Tableau, TIBCO Spotfire, Micro Strategy

ETL Tools: SQL Server Integration Services (SSIS), Import Export Data

OLAP Tools: SQL Server Analysis Services (SSAS), OLAP Cubes

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio, SQL Server Query Editor, SQL Profiler, Analysis Manager, Reporting Server

Data Modeling Tools: Erwin, MS Visio

Operating Systems: Windows 7/Windows server 2008 R2 / 2008, Linux, COSMOS

Applications: MS Word, Excel, PowerPoint, Outlook, Adobe Photoshop

Web Servers: Apache Tomcat

Design and Development: Visual Studio, SSMS, Eclipse, IBM Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. SQL BI Developer

Roles & Responsibilities:

  • Involved in gathering requirements and designing database workflow.
  • Developed scripts in OLTP environment to insert, update and delete data in SQL Server database tables.
  • Created complex queries with joins, correlated sub queries
  • Optimized queries using indexing and SQL profiler
  • Designed SSIS packages with Error handling and scheduled jobs for data migration from different sources into OLAP environment.
  • Actively monitored loggings, transactions, deployments and configurations.
  • Worked with different methods of logging in SSIS and advanced data mapping.
  • Implemented master-child package techniques to manage ETL projects efficiently.
  • Implemented event handlers, loggings, breakpoints, and data viewers to debug and repair errors.
  • Improvised analytical information by creating OLAP cubes.
  • Process the cubes (SSAS), partitions as and when required
  • Designed, implemented and optimized SSRS reports with snapshots, caches, embedded data sets, execution log views, expressions, and stored procedures.
  • Generated SSRS reports utilizing Excel spreadsheets with Power Pivots, deployed with SharePoint integrated mode
Confidential, Salon, OH

Data Analyst

Roles & Responsibilities:

  • Involved in designing of both logical and physical database.
  • Created complex SQL queries, derived tables, user defined functions, views both indexed and materialized.
  • Wrote complex stored procedures, cursors and database triggers.
  • Understanding and analysis of the requirements provided by the clients and the dependencies of external systems.
  • Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL.
  • Evaluated data modeling, database administration, and database backup and recovery tools and made recommendations.
  • Created efficient SSIS Packages using SSIS Control Flow Tasks and Transformations, also, SQL Jobs to run SSIS packages on scheduled basis.
  • Worked on crystal reports and Actuate reporting tools
  • Worked on generating layout view, managed data sets using the actuate reporting tool.
  • Involved in code and chart editing using Actuate Reporting tool.
  • Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
  • Participated in discussions about the status and bugs reported.
  • Participated in DATA migration testing.
Confidential, San Diego, CA

SQL BI SSIS/SSAS / SSRS Developer.

Roles & Responsibilities:

  • Developed database applications by collaborating with DBAs and business analysts to identify requirements.
  • Created SQL datasets for Power BI and Ad-hoc Reports.
  • Converted and loaded data from different databases and files.
  • Created SQL scripts to create objects such as views, tables, and functions.
  • Designed views as per the requirements to present data on web pages.
  • Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
  • Modified existing stored procedures to improve performance and implement business logic.
  • Documented functionalities of functions, stored procedures and dependencies of multiple objects.
  • Involved in sharing information through network using Java Web Services.
  • Generated various reports (SSRS) in Visual studio environment.
  • Performed troubleshooting of client's database related issues during implementation, maintenance and upgrading and migration process.
  • Followed Agile methodology in project delivery.
  • Created Tabular, Matrix reports, Charts and graphs as per customer requirements Using SSRS and Power BI.
  • Worked with SharePoint Server 2007 while deploying SSRS reports.
  • Used Team foundation server (TFS) as a source control.
  • Used Performance Point Server 2007.
  • Responsible for maintaining UAT (User Acceptance Testing) and Production environment.
Confidential, St. Louis, MO

SQL Developer

Roles & Responsibilities:

  • Involved in gathering requirements for the project.
  • Implemented the Waterfall SDLC concept.
  • Used Rational Rose for UML diagrams and ER diagrams.
  • Developed a web application using C#.net and ASP.net.
  • Involved in building an extensive OLAP data warehouse using SSAS.
  • Designed SSIS packages with Error handling and scheduled jobs for data migration from different sources into OLAP environment
  • Wrote complex queries, performance tuning and optimized SQL queries using T-SQL, SQL Profiler in SQL Server 2005.
  • Created user controls for login pages and used validation controls.
  • Provided authorization to control user access to application features.
  • Managed SQL Server logins, user accounts, passwords and database object permissions.
  • Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Created reports and designed graphical representation of analyzed data using reporting tools
Confidential

SQL Developer

Roles & Responsibilities:

  • Installed and configured SQL server 2005 on development server for designing and testing, applying service packs.
  • Provided User Access at different levels for both the network and the SQL Server databases.
  • Involved in creating Databases, tables with different constraints, Views, Stored Procedures, Triggers and Defaults.
  • Involved in merging existing databases and designed new data models to meet the requirements and perform daily for asset management.
  • Converted Data Transformation Services (DTS) applications to SQL Server Integrated Services (SSIS).
  • Involved in creating and storing Java web services in SSIS and query the Results.
  • Configured and audited SQL Server security.
  • Monitored the performance of Database Server.

Hire Now