We provide IT Staff Augmentation Services!

Pl/sql Bi Developer Resume

NH

SUMMARY:

  • Having 8+ years of experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), Server Reporting Services (SSRS), Server Analytical Services (SSAS) and Data Transformation Services (DTS).
  • Experience in data analysis, design, and development of databases for business applications in a client/server and data warehouse environments in PL/SQL.
  • Expert in all areas of PL/SQL development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, PL/SQL, relational database models, data dictionaries, and data integrity.
  • Well versed in normalization/de - normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
  • Good Knowledge on QNXT, EDW, Essette Servers.
  • Expertise in Power BI, Power BI Pro, Power BI Mobile.
  • Expert in creating and developing Power BI Dashboards into rich look.
  • Experience in creating Power BI reports using PL/SQL server and Oracle Databases.
  • Experienced in creating admin reports and performance tuning for various reports using Power BI
  • Have a good experience on Different methodologies like Agile/Scrum/Sprint.
  • Good Knowledge on TFS (Team Foundation server) like mapping files and check them into servers.
  • Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
  • Expertise in MS PL/SQL Server databases with tools like Index Tuning Wizard, PL/SQL Profiler, and Windows Performance Monitor for optimal Performance.
  • Experience in Interacting with Business users to analyses the business process and transforming requirements into screens, performing ETL , documenting and rolling out the deliverables.
  • Expertise in Extract Transform Load ( ETL ) and Data Transformation Services ( DTS ).
  • Strong Experience in Creating, Configuring, Deploying and Testing Informatica Packages.
  • Expertise in Extraction, Transformation, Loading the data from Oracle, PL/SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Designed Web-based ASP.NET Internet applications linked to firm-wide PL/SQL databases.
  • Currently designing .NET system architecture for ASP migration project.
  • Knowledge of monitoring, logging and cost management tools that integrate with AWS.
  • Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for Informatica Packages.
  • Expertise in creating PL/SQL server Reports using SSRS 2008.
  • Expertise in creating Report Models for building Ad hoc reports using SSRS.
  • Proficiency in creating diverse types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them.
  • Knowledge and experience in designing, developing, and deploying Reports and Dashboards.
  • Good understanding and designing of Star and Snowflake data models Schema used in relational, dimensional, and multidimensional data modelling.
  • Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
  • Experience in managing Alerts, Operators and Scheduled Jobs through PL/SQL Server Agent.
  • Experience in using Performance Monitor/Profiler to solve Dead Locks.
  • Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.

TECHNICAL SKILLS:

Languages: C, C++, C#, .NET (4.5/4.0), PL/SQL, PL-PL/SQL, Oracle, Python, AWS, VBScript

Databases: MS PL/SQL Server 2000/2005/2008/2012/2014/2016/2017 , Oracle, MySQL.

Database Tools: PL/SQL Server Management Studio, Business Intelligence Development Studio, PL/SQL Profiler, T- SQL, PL/PL/SQL, OLAP, DBCC.

Reporting Tools: PL/SQL Server Reporting Services, MS Excel, and Oracle Report Builder

Application Packages: MS Front Page, Microsoft Suite, SSIS, SSAS, SSRS.

BI Tools: SSIS, SSRS, SSAS (DAX Language), Power BI, Tableau Reporting

Operating Systems: UNIX, Windows Server 2000/2003/2008.

PROFESSIONAL EXPERIENCE:

Confidential, NH

PL/SQL BI Developer

Responsibilities:

  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to customers.
  • Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
  • Imported data from PL/SQL Server DB, Azure PL/SQL DB to Power BI to generate reports.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Published reports and dashboards using Power BI.
  • Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
  • Extracted data from Oracle, DB2, AS400, PL/SQL Server, Flat Files, Excel, and XML using SSIS and cleanse the data.
  • Configured the Informatica Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
  • Developed enhancements to enterprise financial planning Web-based .NET application for leading insurance provider.
  • Troubleshot and resolved bugs in .NET applications to ensure optimal development environment.
  • Converted data types using Derived Column, Data Conversion Transformation.
  • Setup the client packages for Accounts, Transactions and Notes based on Templates.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Developed SSIS ETL Packages & also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
  • Created Informatica Packages for Incremental Loading and slowly changing dimensions.
  • Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
  • Designed SSAS Cubes, Named Calculations for Dimensions.
  • Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
  • Enhance Informatica Packages to perform dynamic functionalities from static configuration and changed many of the packages by using C# coding for generic usage within the organization.
  • Created & modified SSRS reports (2012 & 2016) depend on the requirement on the priority basis from the DW & BW bug tracker applications.
  • Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created usage-based aggregations in cube to minimize time for query retrieval from client tool Targit
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
  • Created Development and Production support documents.
  • Used Subversion for centralized storage within the Data Warehouse department.

Environment: SQL Server 2017/2016, SSIS, SSRS, SSAS, Power BI, Visual Studio 2015/2013, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio.

Confidential

Power BI Developer

Responsibilities:

  • Developed complex programs in PL/SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Rewrote PL/SQL queries to upgrade PL/SQL Server performance using PL/SQL Server.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.
  • Worked on all kind of Power BI reports such as Yearly, Quarterly, Monthly, and Daily.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.
  • Creating Row level security with power bi and integration with Power BI service portal.
  • Developed profit analysis Power BI reports and dashboards by products and customers
  • Worked on all types of transformations that are available in Power Bi query editor.
  • Scheduled Automatic refresh and scheduling refresh in Power Bi service.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
  • Utilized ASP.NET, VB.NET, AJAX, and Microsoft Visual Studio 2005 for development.
  • Designed Web-based ASP.NET Internet applications linked to firm-wide PL/SQL databases.
  • Used Try catch and @@error for exceptional handling.
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using PL/SQL Profiler, Data Engine Tuning Advisor, and index tuning wizard.
  • Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to PL/SQL server 2012.
  • Managed up gradation of DTS packages to Informatica Packages
  • Expertise in applying correct filters/slicers on the Power BI report based on business need.
  • Experience in consulting with IT, Business Users & Business Analysts for building reports and dashboards based their needs.
  • Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
  • Created ETL packages with different data sources (PL/SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing various kinds of transformations using SSIS
  • Used Team Foundation Server as Source Control to store Packages, Reports and PL/SQL Scripts and share it among team members.
  • Responsible for developing, monitoring, and deploying Informatica Packages.
  • Configured PL/SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
  • Generated periodic reports based on the statistical analysis of the data using Server Reporting Services (SSRS).
  • Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
  • Created queries for generating drill down reports in SSRS 2012. Formatted the reports using the Global variables, expressions, and Functions.
  • Created Linked Servers to connect OLE DB data sources and providers.
  • Deploying and troubleshooting the Informatica Packages.
  • Designing dashboard / reports to give them consistent and professional looks using TIBCO Spot fire professional .
  • Using SSRS for development of reports for Business users from various sources like tables, stored procedures, and development of several types of reports.

Environment: SQL server 2016/2012/2008 , DTS/SSIS, SSRS, SSAS, ERWIN, MS Access, Visual Studio 2015/2013

Confidential, Rancho Cordova, CA

PL/SQL BI Developer

Responsibilities:

  • Generated the reports (SSRS) depending upon the requirements.
  • Created subscriptions using SSRS report manager.
  • Created several types of SSRS reports like cascading reports, parameterized reports.
  • Worked on parameterized reports and Drilled down reports for newly created markets.
  • Worked on troubleshooting process, issues, and errors using PL/SQL Server.
  • Extract/Load/Transformation data from different Source System like BAS, BW, NEB, net FORUM, etc. into Data Warehouse for Daily, Weekly & Monthly incremental PL/SQL jobs.
  • Worked on complete SSIS life cycle in creating Informatica Packages, building, and executing the packages in both the environments (Development and QA)
  • Developed profit analysis Power BI reports and dashboards by products and customers
  • Worked on all types of transformations that are available in Power Bi query editor.
  • Worked on application integrations to manage the data using BI tools.
  • Extensively worked on claims processing data and created the reports using Informatica Packages and exported reports in excel.
  • Used the health care data warehousing for the provider data management system.
  • Used various transformations in SSIS Data flow, control flow using loop containers and fuzzy lookups etc.
  • Created Informatica Packages to migrate data from different data sources to data warehouse.
  • Worked on the claim’s reports and on different operational reports.
  • Created and scheduled jobs to run on a daily and weekly basis including maintenance of the jobs.
  • Used BIDS to create parameterized reports and exported reports in excel.
  • Involved in deployment process and subversion.
  • Worked on reports (SSRS) with respective to new reports.
  • Worked on production support and testing environment to ensure it's according to the business rules, developed reports and involved in testing and deployment.
  • Generated periodic reports based on the statistical analysis of the data from various time frames and division using Server Reporting Services (SSRS).
  • Worked on PL/SQL programming, stored procedures, and views in the processing of developing reports.
  • Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Designed and built PL/SQL dashboard for reporting to allow ad hoc reports for management & Intelligence.
  • Worked on PL/SQL Server 2008 R2 and 2012 for various parts of the project.
  • Involved in regression testing, and optimization of the query.

Environment: Environment: MS SQL Server 2012/2008R2, Server Integration Services (SSIS), PL/SQL, Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel 2013/2010, visual studio 2015/2013.

Confidential, Tulsa, Oklahoma

PL/SQL BI Developer

Responsibilities:

  • Designed Database Maintenance Planner for the Performance of PL/SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Involved in Creating Parameterized, Cascaded, Drill-down, Crosstab and Drill-through Reports using SSRS.
  • Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality, and reliability checks.
  • Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to customers.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Developed scripts to migrate data from multiple sources.
  • Designed SSAS Cubes, Named Calculations for Dimensions.
  • Communicated statuses with data warehouse and business intelligence teams and assisted in resolving data-related problems.
  • Master working in OLTP & OLAP environments using SSIS, SSRS and SSAS cubes that include QA, Production, and development, implemented, and maintained database schema and Entity relationship (ERD) diagrams (using ERWIN) from business requirements.
  • Configured packages to operate them on testing and production environments and scheduled jobs to run the packages and created configuration files to execute package in multiple environments.
  • Provide DTS, ETL capability between Excel, access, and MS PL/SQL Service.
  • Developed tableau reports to represent the trend of data that was loaded using Informatica Packages.
  • Created Dashboards using Power BI and deployed into Office 365.
  • Responsible for design, create and tune database objects (tables, views, indexes) to support Logical and dimensional models. Maintain the referential integrity of the database.
  • Developed ETL packages with different data sources (PL/SQL Server, Flat Files, Excel source files etc.) and loaded the data into target tables by performing various kinds of transformations using Server Integration Services (SSIS).
  • Deployed Informatica Packages from Dev/Staging/Production using Package Configurations.
  • Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
  • Worked in production support to optimize the stored procedures and scheduled many jobs.
  • Involved in Maintaining Database with Backup, Restore Strategies and scheduling those backups using Informatica Packages as a Developer.

Environment: SQL Server 2008 R2/2012 Enterprise Edition, SSIS, SSRS, SSAS, Tableau dashboard, SharePoint, PL/SQL, C#, .net, Visual Studio 2010 & 2013, MS Visio 2007, Team Foundation Server (TFS).

Confidential, Long Beach

PL/SQL BI Developer

Responsibilities:

  • Developed SSIS ETL Packages & also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
  • Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to customers
  • Worked on the claim’s reports and on different operational reports.
  • Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
  • 0Created Development and Production support documents.
  • Used Subversion for centralized storage within the Data Warehouse department.
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to customers.
  • Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client. created new SSRS Reports for Several DHCS Projects
  • Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
  • Extracted data from Oracle, DB2, AS400, PL/SQL Server, Flat Files, Excel, and XML using SSIS and cleanse the data.
  • Created and scheduled jobs to run on a daily and weekly basis including maintenance of the jobs.
  • Used BIDS to create parameterized reports and exported reports in excel.
  • Involved in deployment process and subversion.
  • Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality, and reliability checks.
  • Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).
  • Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
  • Enhance Informatica Packages to perform dynamic functionalities from static configuration and changed many of the packages by using C# coding for generic usage within the organization.

Environment: SQL Server 2008 R2/2012 Enterprise Edition, SSIS, SSRS, SSAS, Tableau dashboard, SharePoint, PL/SQL, C#, .net, Visual Studio 2010 & 2013, MS Visio 2007, Team Foundation Server (TFS).

Confidential

PL/SQL BI Developer

Responsibilities:

  • Interacted with end users to gather Requirements. Created technical, user documentation.
  • Studied and designed the system.
  • Install, Update, Configure and Maintain the MS PL/SQL Server.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
  • Analyzing and resolving all issues exists from long time.
  • Design and tune ETL process.
  • Data quality done by using the Data cleansing by using ETL development.
  • PL/SQL queries for the retrieval of the data.
  • Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
  • Created calculated Measures for dashboard KPI's using DAX and Direct Query, build custom attributes for dashboard slicers and other filters using DAX .
  • Developed, monitored, and deployed Informatica Packages.
  • Involved in extracting the data u0sing SSIS from OLTP to OLAP.
  • Designing new Informatica Packages on demand to provide report collected from various sources.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
  • Provided support for access, training, and usage of POWER BI dashboards / reports / visualizations.
  • Analyzing and providing fixes for all issues arises during business hours and have dataflow continue.
  • Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS .
  • Tuning front-end applications like Visual Basic, which query the PL/SQL Server databases.
  • Written Various ASP codes for user interactions.
  • Written Java Script for different validations
  • Used PL/SQL Statements to Present Query responses

Environment: SQL Server 2008 R2/2012, PL/SQL, UNIX, .NET, VB Script, JavaScript, ASP, Microsoft Excel.

Confidential

PL/SQL Developer

Responsibilities:

  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL/SQL in PL/SQL Server 2000.
  • Validated change requests and made appropriate recommendations. Standardized the implementation of data.
  • Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
  • Modified database structures as directed by developers for test/develop environments and assist with coding, design, and performance tuning.
  • Working on existing application enhancements and adding new functionalities.
  • Managed user access. Created and managed new security accounts.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Analyzing and providing fixes for all issues arises during business hours and have dataflow continue.
  • Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
  • Compared the target data with the source data.
  • Gathered the data and resolved various quality problems associated with the data.
  • Analyzed data by creating simple PL/SQL queries and identified fact and dimension tables.
  • Performed Data profiling using PL/SQL queries on various sources.
  • Restricted data for users using Row level security and User filters.
  • Performed Data Analysis and Data validation by writing complex PL/SQL queries using PL/SQL against the PL/SQL server database.
  • Backup and restore databases.
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
  • Updated the statistics info for both the old and new servers.
  • Assisted with various ad hoc query requests.
  • Provided back-end support for functional testing and performance testing

Environment: SQL Server 2005, PL/SQL, DTS Designer, MS-Office, MS-Excel, VSS

Hire Now