Sql Bi Analyst Resume
Oakbrook, IL
SUMMARY
- Over 7+ Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL/Business Intelligence Developer wif expertise in SQL Server Integration Services, Analytics, Reporting and Self Service BI
- Expert in working wif 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 MDX SVN, GitHub.
- Having strong experience in scheduling all the T-SQL jobs to run at particular times.
- Good noledge 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).
- 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.
- Experienced in Data Masking and security of PII data (IBM OPTIM), Testing, Debugging, Validation and Reporting
- Having strong experience in all Test Driven Development and Continuous Integration.
- Very good experience in writing expressions in SSRS.
- Review, validate and cleanse claims data towards preparation of the final data set for claims analysis
- Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.
- Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent noledge of DDL and DML in T-SQL.
- In-depth noledge on Tableau Desktop, Tableau Reader and Tableau Server.
- Excellent communication, analytical and inter personal skills and ability to learn new concepts.
- Developed reports using global variables, expressions and functions using SSRS.
- Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
- Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker wif excellent communication and interpersonal skills.
- Proven understanding of Hadoop SQL base tools such as Hive & Impala and Experienced in running query using Impala and used BI tools to run ad-hoc queries directly on Hadoop.
TECHNICAL SKILLS
Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos 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, IBM Data Studio
Database Management Tools: SQL Query Analyzer, SQL Profiler, DTA, SQL Server Activity Monitor, SQL Server Logs, Toad, Hue
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,IBM
Project Management: Microsoft Project/Office 2003,2007, 2010, 2013, Microsoft Visio, Erwin
PROFESSIONAL EXPERIENCE
Confidential, Oakbrook, IL
SQL BI Analyst
Responsibilities:
- Develop ad-hoc reports using MS SQL Server, SQL Reporting Services, SQL Server Integration Services and Power BI.
- Solid understanding of relational database, modeling concepts and Power BI Dashboard Reporting.
- Understands how to prioritize reports according to business need, regulatory requirements, urgency and / or other key business factors.
- Coordinates data and analyses from MHI and / or Health Plans as needed.
- Modifies reports in response to error identification and / or approved change requests; understand the balance between responsiveness to business requests for enhancements versus department needs to complete work efficiently and timely.
- Analyzing, requirements gathering, documentations, coding like stored procedures and packages, Query optimizing, testing, bug fixing, designing reports usingSSRS and SQL server 2005.
- Writing SQL server stored procedures and create / maintain SQL Server Development Database objects in the data warehousing environment
- Conduct data mapping, design, develop, and implement extract / transform / load processes using custom ETL based on SSIS technology.
- Help Optimization of queries and performance tuning to make the queries to run fast from tables wif millions of records using PL/SQL codes.
- Creating adhoc reports and automate reports as and when needed using SSRS and Power BI
- Participated in team meetings and got involved in technical design/ planning of middle ware database to combine data from various sources.
- Responsible for developing business centric reports, dashboards, data requests, metrics, and other tools using the Microsoft Business Intelligence framework. Represent the department in fostering and developing relationships wif other business units requesting business intelligence services. SSAS, SSIS and SSRS
- Develop data extraction, wrote SQL queries, stored procedures, and packages, and manage data integrity for the data used in the reporting projects.
- Working on migrating SQL code to Data Lake Impala. Creating dynamic SQL parameters in SSRS when using Data Lake as a source.
- Working on importing data into data lake sandbox and Queried both Managed and External tables created by Hive using Impala.
- Working experience in various kinds of data sources such as Teradata and Oracle. Successfully loaded files to HDFS from Teradata, and load files from hdfs to hive and impala.
Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server reporting services (SSRS), T-SQL and MDX, Power BI, Toad Workbook 5.2, Hue Editor.
Confidential, Chicago IL
SQL Server BI Developer
Responsibilities:
- Involved wif business analysts in creating/reviewing business requirement documents
- Involved in creation/review of functional requirement specifications and supporting documents for business systems.
- Created tables for loading Provider and claim data in SQL server 2016
- Developed high performance views/ stored procedures for generating extracts for Provider and Claim data.
- Developed new ETL architecture for loading data using SSIS instead of Data Stage
- Developed various SSIS packages for loading the Provider, Claims and Membership data into a data warehouse.
- Created complex Packages in SSIS 2016 as part of automating the extract Process.
- The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split and Data Conversion.
- Reviewed & Tested packages, fixing bugs (if any) using SSDT 2016.
- Generated different SSRS reports for different providers and provided subscriptions on daily, weekly, Bi-weekly, monthly, Quarterly and yearly basis
- Loading Data into different environments based upon the requests.
- Analyzed the data models to document the tables & their relationships.
- Worked on different data sources (xml source, excel, csv, flat file, web service) to pull, parse and load data into client servers.
- Optimized SQL queries and procedures for efficiency and to reduce time duration of data load.
- Created the store procedures and Data Modeling to back up the production data.
- Create database objects such as tables, views, stored procedures, Triggers, User Defined Functions, linked server queries for extracts from db2 and MySQL.
- Created the SSIS package to filter the physician data according to Vendors and Hospital Management requirement.
- Also created the SSRS package to generate the Reports for Financial team.
Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), T-SQL and MDX, SVN. Continuous Integration
Confidential, Memphis, TN
MS SQL Server (SSIS/SSRS) Developer
Responsibilities:
- Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
- Created SQL Server Reports based on the requirements using SSRS 2012,2014
- Involved in analysis of Report design requirements and actively participated and interacted wif Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
- Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
- Experience in creating XML files by designing the SSIS packages and SQL server.
- Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
- Troubleshooting performance issues and fine-tuning queries and stored procedures
- Worked on OLAP Data warehouse, Model, Design, and Implementation.
- Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
- Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
- Created multiple reports wif drop down menu option having complex groupings wifin the report.
- Designed, Build the Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS).
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
- Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
- Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
- Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)
- Scheduling the SSIS packages and Jobs.
- Worked very closely wif Business Customers, End Users and resolved any business process related issues.
- Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS.
- Developed SAS Macros for data cleaning, reporting and to support routine.
- Develop and Debug T-SQL scripts in a complex relational database system (RDBMS).
- Worked on Analyzing, designing, building &, testing of OLAP cubes wif SSAS 2012 by using MDX And generated the Reports using SSRS and Power BI tools for vendors.
- Built the whole new Data Base wif table’s, views, triggers, indexes and store procedures to avoid the use of Access Data Base. And created the SSIS package to send the data to vendors.
- Created the optimized SQL query’s to get the data from DWHS to avoid the use of Adhocs.
- Worked on the optimization and performance tuning of SQL Server using Profiler
Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, GitHub and SVN and Continuous Integration.
Confidential, Atlanta, GA
SQL Server/ BI Developer/SSIS/SSRS
Responsibilities:
- Interact wif 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 Cognos 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 wif different data sources (SQL Server, Flat Files, Excel source files, XML files) and tan loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
- Worked on IBM Data Masking tool - Optim, to ensure the state PII data is not exposed on the wire and security.
- Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes. Designed T-SQL scripts to identify long running queries and blocking sessions.
- Extensive experience working in an Agile development environment
- In-depth noledge 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 Cognos Connection portal.
- Wrote, tested and implemented Teradata Fast load, Multi load and Bteq scripts, DML and DDL.
- Used TOAD,PL/SQL developer tools for faster application design and developments
- Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Utilize Dynamic T-SQL wifin functions, stored procedures, views, and tables.
- Created Metadata Modeling by using multiple data sources in Cognos 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 Cognos connection.
- Involved wif 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.
- 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
Oracle PL/SQL Developer
Responsibilities:
- Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance wif company policies, company standards and industry best practices.
- Assisted in the conversion of existing PowerBuilder code to PL/SQL and Java to support a new Flex application.
- Tested coding modifications and assisted wif application and system testing to minimize errors and downtime.
- Written PL/SQL Procedures, Functions, Packages, and SQL ScriptsusingOracle SQL and PL/SQL.
- Developed data model,PL/SQL Queries, SQL Query tuning process,andSchemas.
- Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
- Formulated SQL queries, functions and processes as per requirement.
- Worked wif developers to repair and enhance current base ofPL/SQL packagesto fix testing issues.
- Created and maintained PL/SQL scripts and stored procedures.
- Huge experience in developing Oracle PL/SQL packages and object types
- Solid understanding of inheriting PL/SQL object types, casting PL/SQL object types into descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functions
- Built new functionality and improve processing time throughcode optimizations and indexes.
- Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
- UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages.
- Experience working wif Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index Organized Tables, Partitions, Objects/Collections, Execute Immediate etc.
- Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
- Written packages, triggers, stored procedure and functions for Solvency project which involved retrieving data using FTP, scheduling through AUTOSYS, extracting and loading using ETL (Data Stage) and PL/SQL.
- WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
- Worked onXMLalong wif PL/SQL to develop and modify web forms.
- Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
- Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
- Improved the performance of the application by rewriting theSQL queries.
- UsedSQL*Loaderas an ETL tool to load data into the staging tables.
- Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
- Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQL Collections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
- Used principals of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
- Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios wifOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
- UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformationandload packagesfordata ware housing.Extracted data from theXMLfile and loaded it into thedatabase.
- Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
- Defect tracking through JIRA and defect summary reporting.
- Proficiency wif SCCS and Clear case version control systems.
- Worked on agile and test driven environment, participated on daily scrum meeting, and discussions.
Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, SQL*Plus, PL/SQL, Oracle Designer 2000,Windows 2000, Toad.
Confidential
SQL Server/SSIS/SSRS 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 wif 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 wif 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 Cognos 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