We provide IT Staff Augmentation Services!

Sr. Msbi Developer/ Etl Developer Resume

4.00/5 (Submit Your Rating)

Andover, MA

SUMMARY:

  • Over 6+ Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL/Business Intelligence Developer with expertise in SQL Server Integration Services, Analytics, Reporting and Self Service BI
  • Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Experienced in writing complex T - SQL queries using Inner, Outer and Cross Joins.
  • Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
  • Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
  • Having strong experience in scheduling all the T-SQL jobs to run at particular times.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
  • Strong Experience in Interface programs to import data from legacy systems and excellent skills in writing PL/SQL stored procedures, functions, packages, triggers and cursors.
  • Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
  • Developed PL/SQL Packages, Procedures and Functions accordance with requirements for loading data into database tables.
  • Proficient in OLTP, OLAP and Data warehousing Design concepts.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
  • Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.
  • Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
  • Strong experience in creating complex reports that use cascaded parameters.
  • Very good experience in writing expressions in SSRS.
  • Review, validate and cleanse claims data towards preparation of the final data set for claims analysis
  • Good Knowledge in OLAP Storage modes likes Rolap/Molap/Holap
  • Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.
  • Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
  • Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
  • Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Developed reports using global variables, expressions and functions using SSRS.
  • Excellent communication, analytical and inter personal skills and ability to learn new concepts.
  • Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
  • Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

TECHNICAL SKILLS:

Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Confidential 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Confidential Connection, Transformer), Qlikview Self Service BI

ETL Tools: SSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP - Business Warehouse, Power Query

Database Systems: MS-SQL Server 2000/2005/2008/ R2/012, Oracle 10g/11g, DB2, MS Access

Database Management Tools: SQL Query Analyzer, SQL Profiler, DTA, SQL Server Activity Monitor, SQL Server Logs

Programming Languages: T-SQL, PL/SQL, .Net, MDX, DAX, HTML

Operating Systems: Windows 98/ME/2000/NT/XP/2003/7, MS DOS, Linux, IIS 5, 6

Project Management/ Database Design: Microsoft Project/Office 2003,2007, 2010, 2013, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Andover, MA

Sr. MSBI Developer/ ETL Developer

Responsibilities:

  • Analysis of the FAME current functionality module by module and prepare Requirements document.
  • Design new modules based on the requirement documents.
  • Develop technical specifications for constructing SQL based reports
  • Develop Data load modules using Camel/Fuse & Java/J2EE technologies.
  • Covert 4GL modules into Oracle/Sql procedure/functions.
  • Develop Perl script parsers for XML/CSV files loaders.
  • Developed a High level dashboard using SSRS 2008
  • Peer reviews and unit testing of the modules.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Designed ER diagrams and mapped the data into database objects.
  • Work with DBAs to create new dataset tables/views/functions/procedures.
  • Bi-weekly Sprint Planning, Product Backlog Review and Retrospective sessions.
  • Creating User Stories/Tasks based on the Backlog items using JIRA.
  • Conduct Daily standup meetings.
  • Assign tasks to the team members and co-ordinate to move from To-Do to DONE.
  • Extensive experience working in an agile development environment.
  • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
  • Conduct Sprint reviews with business user at the end of the sprint.

Environment: Apache Camel, FUSE, Java 1.8, J2EE, Spring, Perl, JMS, XML, JBoss 5.x, Oracle 12c, SQL, PL/SQL, Unix scripting, SVN version control tools, JBoss Developer studio, Autosys, SQL developer, Agile SCRUM, JIRA.

Confidential, Norfolk, VA

MSBI Developer/ FACETS SSIS

Responsibilities:

  • Develop technical specs for constructing Sql primarily based reports and growing analytical insights into claims information
  • Developed and executed manual plans to support applications
  • Participate in code reviews and QA to confirm and validate coded queries towards requirements
  • Optimize developed code for improved overall performance Developed a High level dashboard using SSRS 2008
  • Performed validation of facets application under the guidelines and instructions of senior staff
  • Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
  • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
  • Running test scripts for facets applications and modules
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Extensive experience working in an Agile development environment
  • Created Complex SQL Queries using Views, Indexes and User Defined Functions
  • Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
  • Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required

Environment: SQL Server 2008 R2, SSIS (2008), SSRS (2008), Visual Studio 2010/2013, MS Excel 2010.

Confidential, Atlanta, GA

SQL BI Developer\ MSBI Developer

Responsibilities:

  • Participate in requirements elicitation in developing analytical insights into claims data
  • Review, validate and cleanse claims data towards preparation of the final data set for claims analysis
  • Develop technical specifications for constructing SQL based reports
  • Develop complex and efficient queries to extract required insights from the claims data
  • Follow agile processes to meet project planning goals
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data so0urces using SSIS.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Extensive experience working in an Agile development environment
  • Designed ER diagrams and mapped the data into database objects
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
  • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
  • Participate in code reviews and QA to verify and validate coded queries against requirements
  • Optimize developed code for improved performance
  • Developed a High level dashboard using SSRS 2008
  • Relational Database Management Systems metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.
  • Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
  • Designed dimensions and using the MDX expressions for the various Optimizations like optimizing cube schema in SSAS
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
  • Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute Sql flow task, data flow task to extract data from different databases and flat files

Environment: SQL Server 2008 R2, SSIS (2008), SSRS (2008), Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Power Designer.

Confidential, Eden Prairie, MN

Sr. SQL Server/ BI Developer/SSIS/SSRS/SSAS

Responsibilities:

  • Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
  • Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
  • Used Framework Manager to build models, packages and publish packages to Confidential Connection.
  • Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Configured MUD for OBIEE Tool
  • Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes. Creating, Approving and Modifying PA in both Portal and QNXT.
  • Designed T-SQL scripts to identify long running queries and blocking sessions.
  • Extensive experience working in an Agile development environment
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Performed incremental data load packages in SSIS
  • Used Teradata utilities fast load, multi load, to load data
  • OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and connecting using Excel Power Pivot.
  • Created Complex dashboards and published to Confidential Connection portal. down menu option and Parameterized using Tableau
  • Wrote, tested and implemented Teradata Fast load, Multi load and Bteq scripts, DML and DDL.
  • Used TOAD,PL/SQLdevelopertoolsforfasterapplicationdesignanddevelopments
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Designed and coded a number of Shell Scripts to handle the EDI Gentran translator for different EDI transactions.
  • Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
  • Created Metadata Modeling by using multiple data sources in Confidential 8 BI Modeling.
  • Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
  • Development of .NET batch applications which processes high volume of data.
  • Extensively used Korn Shell Scripts for doing manipulations of the flat files, given by the share brokers.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
  • Bursting and scheduling the Reports using Confidential connection.
  • Involved with testing and exploring tools using Query Studio and Report Studio.
  • Developed modules of the application in ASP.NET, Silverlight and involved in writing C# classes.
  • Used UTL JOB to automate the PL/SQL procedures and packages
  • Identified and Defined Fact relationships in SSAS.
  • Worked with Ajax enabled WCF services using C# and ASP.Net.
  • Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, Milwaukee, WI

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC).
  • 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.
  • Involved in testing QNXT Member, Provider, Claims Processing (with proper ICD - 9 and ICD - 10 and HCPCS/CPT codes), and Utilization Management, Contracts, and Benefits modules.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Involved in upgrading from SQL Server 2005 to SQL Server 2008.
  • Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
  • End to end experience in designing and deploying data visualizations using Tableau
  • Wrote several Korn Shell Scripts for auditing TIMSS database.
  • Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
  • Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Developed PL/SQL Procedures, Functions, Packages using Oracle Utilities like PL/SQL, SQL*Loader and Handled Exceptions to handle key business logic.
  • Wrote Teradata Macros and used various Teradata analytic functions.
  • Build several Unix Shell wrappers for Pro*C programs to schedule them on Cron.
  • Used Teradata utilities Fastload, Multiload, Tpump to load data measures and dimension members using multi-dimensional expression (MDX).
  • Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Developed a High level dashboard using SSRS 2008.
  • Designed and coded a number of Shell Scripts to handle the EDI Gentran translator for different EDI transactions.
  • Developing web parts using C# and SharePoint object model.
  • Relational Database Management Systems metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.
  • Implementing Road Map, Defining and building best Practices for .NET Application Development.
  • Worked with Ajax enabled WCF services using C# and ASP.Net.
  • Extensive experience working in an Agile development environment
  • Extensive experience on Structuring Metadata and Confidential Models using Framework Manager.
  • Developing Finance reports in OBIEE 11g using NOETIX generated rpd file for FIN module.
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
  • Managed Security settings in OBIEE Administration Tool.
  • Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Oakland, CA

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
  • Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
  • Developed a .NET batch application responsible for processing Medicare enrollee information from Voyager into FACETS.
  • Extensive experience working in an waterfall development environment
  • Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
  • Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations
  • Analyzed and designed new .NET Web, Batch and WCF application from design to completion stage.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Granted permissions to logins, groups to particular database or to a server depending on the requirement.
  • Regularly monitored database sizes and disk space.
  • Arranged meetings with the developers and other DBA’s to discuss the current and new policies which can be established.
  • Developed web parts using C# and SharePoint object model.
  • Created indexes to speed the execution of data retrieval queries, rebuilding them if necessary and often checked for any outdated statistics
  • Scheduled the backups for Databases and performed restoration operations when needed.
  • Used log shipping for synchronization of databases and documented every change.
  • Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
  • Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
  • Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute Sql flow task, data flow task to extract data from different databases and flat files
  • Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts formerly in Confidential reports and SAP BO
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance
  • On the required reports, identified various data sources and established the connections using SSIS and constructed data source view

Environment: MS SQL Server 2008, DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, Team Foundation Server, MS Visio, ff Scrum Methodology, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS

We'd love your feedback!