We provide IT Staff Augmentation Services!

Application System Engineer Resume

Charlotte North, CarolinA

PROFESSIONAL SUMMARY:

  • 7 years of experience as a BI Developer working with Claims, SQL Server, SSIS, SSRS, SSAS, Tableau and C#.NET.
  • Experience in different phases of Software Development Life cycle (SDLC) including Planning, Design, Development and Testing during the development of software applications.
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS) .
  • Developed reports on SSRS on SQL Server 2012.
  • Created many Drill through and Drill down reports using SSRS.
  • Expert in creating Parameterized Reports .
  • Involved in trouble shooting of performance issues which were associated with Tableau reports.
  • Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
  • Programming experience in C, C++, Core Java, C#.NET, HTML, CSS and Web Services.
  • Excellent skills in creating and accessing various databases using SQL Queries, PL/SQL on various databases like Oracle, MySQL, and Microsoft SQL server.
  • Knowledge on EDI transactions: 270/271 / 7,276/277,835.
  • Knowledge on Claims Management and Benefit Management.
  • Knowledge of Healthcare Service Regulatory environment in compliance with HIPAA, ICD9/10 and EDI.
  • Experience in C#.NET, ASP.NET, and Client Side Scripting using JavaScript.
  • Experience on complete software development life cycle (SDLC) with software development models like JIRA, Agile Scrum Model, Prototype model & RUP, Waterfall model.
  • Experience in Software Development Life Cycle, developing Web centric and Object oriented business applications with .Net technologies.
  • Hands on experience on working with Qlikview while generating reports and creating dashboards.
  • Experienced in writing test strategy, test plans, test cases and execution of test cases.
  • Facilitated Joint Application Development (JAD) sessions, Workshops and requirement facilitation sessions with end - user/clients/stake holders and the IT group.
  • Proficiency in analyzing the Functional Specification Document (FSD) and converting it to Technical Specification Document.
  • Strong verbal and written communication skills.
  • Result oriented, motivated and an organized team player with a capability of working for a common goal.
  • Composed, professional and a well-balanced individual with strong understanding of business relationships and business requirements.

TECHNICAL SKILLS:

Programing: C#.NET, Core JAVA,C, C++ and UNIX

Web Technologies: ASP.NET, HTML, JavaScript and VB Script

Database: Microsoft SQL server 2012 and 2014, My SQL 5.1, Oracle 10g/11g, MS Access, DB2, MS Excel and TOAD

SQL Server Tools: SQL Server Reporting Services(SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services(SSAS)

SAP Tools: SAP Business Objects

Reporting Tools: SQL Server Reporting Services(SSRS), SAS, OBIEE and Tableau

Operating Systems: Windows XP/Vista/7/8/10, Linux

Methodologies: ASAP Implementation, Agile, and SDLC

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, North Carolina

Application System Engineer

Responsibilities:

  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
  • Worked on Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
  • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
  • Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
  • 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.
  • Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
  • Maintaining jobs for data messaging from development server to test server for generating daily reports.
  • Used data conversion tasks in SSIS to load the data from flat file to SQL Server database.
  • MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
  • Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services cubes& Reporting Services.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
  • Developed, monitored and deployed SSIS packages.
  • Created document for Self-Service Deployment and Execution process for SSIS packages.
  • Constructed OLTP and OLAP Databases.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server, SSIS, SSAS, SSRS, GIT, TFS, AUTOSYS, JENKINS, UDeploy and C#.NET

Confidential, Trinity, North Carolina

BI Developer

Responsibilities:

  • SQL Server Integration Services (SSIS) experience and ETL skills.
  • Exceptional understanding of and experience with relational datasets, data warehouses and ETL techniques.
  • Developing stored procedures.
  • Performance tuning SQL Server databases.
  • Stored procedures, views and functions using Microsoft SQL Server.
  • Light database administration (indexing, tuning, optimization etc.).
  • Writing efficient, complex queries against very large data sets.
  • Model, analyze and manage large volumes of data.
  • Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
  • Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
  • Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform to parse files in different formats by triggering .exe file and load data to database.
  • Created SSRS reports to create dashboards (with different report items) using shared data sources and Shared Data Sets using SQL Server 2012 for business users.
  • Creating jobs and schedules to automate ETL packages within SSIS
  • Working on different phases of Software Development Life cycle (SDLC)including Planning, Design, Development and Testing during the developmentof software applications.
  • Working on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
  • Analyzes, design, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.

Environment: SQL Server, Microsoft Dynamics AX, SSIS, SSAS, SSRS and C#.NET

Confidential, Southfield, Michigan

Application Developer

Responsibilities:

  • Worked on gathering business requirements and involved in documenting functional Specification document and technical specification document to business team.
  • Involved in creating database objects -- Tables, Views for different schemas in schema, developed stored procedures and functions.
  • Worked on creating .Net Console Applications to consume reports from SSRS report service and generate pdf files for further business continuity.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Create SQL script to automate database restore from shared location to SQL Server using Maintenance Plans and used operators to send email in case of failures or success.
  • Worked as a lead developer and implemented SSIS Packages for extracting the data from different data sources like Oracle, MySQL and legacy applications to transform that data and load it into OLAP.
  • Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
  • Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
  • Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform to parse files in different formats by triggering .exe file and load data to database.
  • Created SSRS reports to create dashboards (with different report items) using shared data sources and Shared Data Sets using SQL Server 2012 for business users.
  • Created dashboards in QlikView using different data sources and developed complex QlikView scripts to build model, to support various KPIs and time comparison.
  • Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS 2012.
  • Involved in optimizing SQL Queries based on Query execution plans, Performance monitor, SQL Profilers, Activity Monitor.

Environment: SQL Server, SSIS, SSAS, SSRS and C#.NET

Confidential, Brighton, Michigan

BI Engineer

Responsibilities:

  • Gathered system requirements and actively supported business users for change requests.
  • Participating in meetings and discussions to enhance the application features and to achieve the business requirements in an optimized manner.
  • T-SQL development in database object creation and data manipulation with Tables and Views, User
  • Defined functions, Indexes, Stored Procedures, CTE, Constraints and Triggers.
  • Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T-SQL statements.
  • Involved in writing Complex SQL queries, stored procedures and functions to extract the data and display in reporter for the applications users and business users.
  • Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
  • Experience in Marks, Publisher and Security concepts.
  • Experience with creating Worksheets and Dashboard.
  • Experience with Tableau for Data Acquisition and data visualizations.
  • Interactive with the other teams to get the requirements for the application.
  • Developing complex stored procedures for the application support.
  • Writing Triggers in the backend for the table and stored procedures.
  • Participating in the meetings and defects calls giving the update on the progress and closing the defects in timely manner bases on priorities.
  • Support current systems which are already in production. Monitor the issues raised by the users and fix them in a prioritized manner to ensure smooth operations of the applications to exceed the expectations of the users.
  • Using Import/Export Wizard to generate SSIS packages that migrate data from various sources to a Staging database.
  • Rationalizing the existing SSIS Packages and other ETL processes to improve performance and maintain data quality.
  • Preparing SSIS Package Models to extract data from the source systems and load it into new destinations.
  • Designing SSIS Packages with for Each Loop Containers, Script Tasks and Precedence Constraints for dynamic data load from various store Point of Sales Systems to a central Above-store Database.
  • Preparing SSRS Reports with Report subscriptions and Email Delivery mechanisms through SQL Scripts that run- n Report Server Databases.
  • Experienced in writing parameterized Queries for generating reports, formatting report, layout, sub reports using global variables, expressions and functions in SSRS.
  • Providing Production support to monitor SQL Agent Jobs, Report Deliveries, ETL issues and technical Change Requests.
  • Experience in creating Power BI Dashboards, Scorecards, views, pivot tables, charts, for further data analysis.

Environment: SharePoint, Active Directory, SQL Server, Tableau, SSIS, SSAS, SSRS and C#.NET

Confidential, Farmington Hills, Michigan

BI Developer

Responsibilities:

  • Responsible for Re-enveloping, Parsing theData.
  • Developed SQL Server/BI/Ad-hoc reports for top management, trend forecasting and bug reporting using SSRS.
  • Saved business four (4) man days a month by automating test scenarios using SQL and SSRS.
  • Generated several drill down and drill through reports using SSRS .
  • Successfully automated numerous reports which allowed the Financial Department to work more efficiently.
  • Assisted business users at all levels to find desired data query and reporting solutions using web access.
  • Performed data maintenance on an on-going basis to ensure data quality and accuracy.
  • Updated Business Requirements and other documentation pertaining to each release.
  • Involved in loading the data in Rules Engine and updating in the SQL Database.
  • Worked with the testing team to develop and test interfaces of the framework.
  • Based on companion document, enveloped the data, to meet client’s requirement.
  • Manipulated large, complex data sets in SQL to provide meaning full leads to other business teams.
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2012.
  • Extract Transform Load(ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS)
  • Expert in creating Star schema cubes using SSAS .
  • Extensively worked on OLAP cubes using SSAS.

Environment: SQL Server, SSIS, SSAS, SSRS and C#.NET

Confidential, Mt. Pleasant, Michigan

SQL Developer

Responsibilities:

  • Maintain student database and insert data into the tables using SQL queries.
  • Assisted students and helping them in learning SQL.
  • Worked closely with professors and helping in designing presentations and drafting material.
  • Extracted data from tables and provided information to the professors whenever required.
  • Hands on experience in working with Microsoft Office suites.
  • Updated existing reports and created new reports using SSRS.
  • Created SSRS reports for different teams and groups in the organization to fulfill their business needs.

Environment: SQL Server, SSIS and SSRS.

Confidential

Jr. SQL Developer

Responsibilities:

  • Participated in development phases of user modules.
  • Functioning on SQL Server Database for creating tables & store procedures.
  • Wrote SQL Statements to extract Data from Tables.
  • Written complex SQL queries, stored procedures, functions, and triggers in PL/SQL.
  • Created stored procedures and other utilities to manage relational and dimensional data.
  • Designed and implemented complex SSIS packages to migrate data from multiple data sources.
  • Created SSIS packages for extract, validate and load data into Data Warehouse.
  • Retrieved data from data warehouse and generated business reports using SSRS.
  • Validated and tested reports, then published the reports to the report server.

Environment: SQL Server, SSIS and SSRS

Hire Now