We provide IT Staff Augmentation Services!

Ms Bi Developer Resume

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • Over 6+ years of IT Experience with SQL Development and Optimization using Microsoft SQL Server Management Studio, Designing ETL Processes and Application Development using Microsoft Visual Studio Business
  • Designing, testing and implementation of high availability solutions for databases for large, medium and small customers
  • Knowledge of BI Tools like Tableau Desktop 8.0/8.1, Tableau Server, SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services)
  • Knowledge of creating different types of Complex Reports using SSRS
  • Extensive experience in creating complex SSIS packages
  • Knowledge of migrating database and SSIS packages
  • Experience on data migration from SQL Server
  • Good experience in Developing and Extending OLAP Cubes, Dimensions and data source view and designing, creating, processing of cubes using SSAS
  • With SSIS, worked on multiple sources and destinations like SQL Server, MS Access, SharePoint 2010 lists, Excel 2008/10, Oracle 10g and text files
  • Expert in calculating measures and dimension members using multi - dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Experience in SQL Stored Procedures, Triggers, Indexes, Views
  • Coding of Database objects like Triggers, Procedures, Functions and Views
  • Exposure to T-SQL and PL/SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package
  • Experience in designing logical and physical data models using ERWIN
  • Knowledge of worked with Star schema & Snow-Flake Schema
  • Knowledge with all phases of software development life cycle (SDLC)
  • Excellent interpersonal and strong analytical, problem-solving skills with customer service-oriented attitude

TECHNICAL SKILLS:

RDBMS / Databases: MS SQL Server 2012/2008R2/2008, Oracle 9i

Languages: T-SQL, PL/SQL, Visual Basic 6.0, Microsoft Visual Studio Tools for Applications 2015, C#

Operating Systems: Windows Server 2008/2012

Modeling Tools: Microsoft Visio, Erwin Data Modeler

Reporting Tools: SQL Server Reporting Services (SSRS)

Integration Services: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Analysis Service: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, OLAP, ADO.NET

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

Other Tools: Microsoft Office 2016, Microsoft Visual Studio Tools for Applications 2015

PROFESSIONAL EXPERIENCE:

MS BI Developer

Confidential, Los Angeles, CA

Environment: MS SQL Server 2012, SSRS, SSIS, TFS(SharePoint), Microsoft Visual Studio Tools for Applications 2015, Tableau Desktop 8.0/8.1, Tableau Server

Responsibilities:

  • Involved in Modifying the IODS (Source) - MISIS (Target) Interface to add new fields and implement the business rules associated with special education services.
  • Designed Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
  • Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
  • Created drill through reports in dashboard.
  • Involved in creating data blending in case of merging different data sources.
  • Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
  • Developed and deployed SSIS packages for including the student demographics historical data to MISIS (Target) from Oracle source IODS using Lookup, Derived Columns, Condition Split, Merge, and Slowly Changing Dimension
  • Configured the package to send email messages if tasks in the package workflow succeed or fail, or send messages in response to an event that the package raises at run time
  • Handled the exceptions with the help of SSIS by transferring the data into separate flat file or error table and performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages
  • Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination
  • Responsible for development, support and maintenance of the logic for the Student Language Reclassification Process for all the Elementary Schools using stored procedures and SSIS Packages
  • Wrote and implemented the logic to process test scores for Student Reading Inventory skill and also implemented the delete logic to keep the source and target data in sync using SSIS and sub queries and correlated sub queries to retrieve data from the database
  • Implemented the process to create and deliver ETL Jobs Execution Summary Report and the Error Records Summary report for the ETL processes using SSIS and SSRS
  • Created SSIS packages to import data from Excel, flat files and other OLEDB sources for Student Meal Code and Student Transportation Data
  • Implemented the threshold logic for interfaces to process records from SAP systems like HRMEGA and Student Test Scores
  • Created an outbound interface from MISIS (Source) - IODS (Target) to include data for the Student Attendance and Student Section Enrollment Information
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build, responsible for routine DBA jobs like Backups and Restores
  • Wrote SQL Scripts to create data extracts for Adhoc request regarding Teacher Credential Information, Student Counselor Access, Los Angeles Public Library Data, Student Section Information.

MS SQL/ BI Developer

Confidential, San Francisco, CA

Environment: MS SQL Server 2012, T-SQL, SSIS, SSRS, ETL, Microsoft Visual Studio Tools for Applications 2015, Oracle 11g, Microsoft Excel, MS Access, Tableau Desktop 8.0/8.1, Tableau Server

Responsibilities:

  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis
  • Involved in creating data blending in case of merging different data sources.
  • Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Understanding of relational database structures, theories, principles, and practices.
  • Monitored Application Server and Tableau Data server activity to track performance and system availability.
  • Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, SQL Server 2012.
  • Involved in license management SLA's with Tableau support.
  • Developed dashboards using objects such as Chart Box (drill down, drill up & cyclic grouping), list, crosstab etc. using Tableau.
  • Created new data source and modified existing data source to optimize the process. Created Schedules and extracted the data into Tableau Data Engine.
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Data Tools
  • Optimized queries using Database Engine Tuning Advisor and SQL Profiler
  • Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks
  • Extensively used derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping transformations in SSIS packages
  • Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data warehouse
  • Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS
  • Responsible for scheduling SSIS jobs using SQL Server Agent, and created alerts for successful and unsuccessful completion of Scheduled Jobs
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity
  • Built packages and handled slowly changing dimensions to maintain the historic data
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS
  • Created 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 in SSRS
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting services (SSRS)

Developer, SSRS/SSAS/SSIS

Confidential, Santa Clara, CA

Environment: MS SQL Server 2012, T-SQL, SSIS, SSRS, ETL, Microsoft Visual Studio Tools for Applications 2015, Oracle 11g, Microsoft Excel, MS Access

Responsibilities:

  • This project involved building reports for various business units such as Claims, Billing, Provider and patient information
  • Used ETL to implement the slowly changing Transformation to maintain Historical Data in Data warehouse
  • Created packages in SSIS with error handling
  • Worked with different methods of logging in SSIS for various ETL packages
  • Implemented data views and control tools to the ETL packages for guaranteed data transformation using SSIS
  • Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination
  • Successfully deployed SSIS (ETL) packages with defined security
  • Developed logical database and converted into physical database using Erwin
  • Proficiently created Reports based on the requirements using SSRS 2008
  • Involved to write complex T-SQL queries and Stored Procedures for generating reports
  • Defined parameters for parameterized reports using SSRS
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008
  • Created Batch files to run the script in development and production environment
  • Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data
  • Extensively worked with OLAP cubes to generate drill through reports in SSRS
  • Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization
  • Responsible to monitor performance and optimize SQL queries for maximizing efficiency
  • Proficiently scheduled the Subscription Reports with the Subscription Report wizard
  • Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system
  • Used stored procedures, created new stored procedures and triggers, modified existing ones, and tuned them such that they perform well
  • Tuned SQL queries using execution plans for better performance
  • Optimized by assigning relative weights to the tables in the catalog and query performance

Hire Now