Created and updated SSAS cubes and reporting models for several warehouse data marts. Developed SQL scripts to upgrade database and install new Oracle environment which utilized Windows Authentication for security. Used HBase for scalable storage and fast query. Developed in Perl, Sql, Unix, and Oracle. Used sequential file stage as the source for most of the source systems. Worked on Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling, and Fact and Dimension tables. Worked with database analysts and technical services to define system requirements. Created SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc. Worked on Data Serialization formats for converting Complex objects into sequence bits by using A JSON, XML formats. Designed & developed proof-of-concept solutions addressing business requirements. Developed several Server jobs using DataStage Designer. Optimized and instituted best practices standards to improve quality and reliability of data used for payments/credits to magazine publishers. Involved in creating deployment document, Work Order, Change Order for production with DBA team. Properly configuring a data warehouse to fit the needs of your business can bring some of the following challenges: 1. Involved in loading the created HFiles into HBase for faster access of large customer base without taking Performance hit. Worked in tier 3 Lights-on support, working on high priority and critical Incidents/Aborts in Edward. Used Oozie as an automation tool for running the jobs. Worked with QA teams (functional, performance and regression testing) for DB2 products. Configured XML Firewall loop back proxy to test all the configurations in multiple steps. Executed Hadoop/Spark jobs on AWS EMR using programs,data stored in S3 Buckets and AWS Redshift. Handled the real time streaming data from different sources using flume and set destination as HDFS. Installed Oozie workflow engine to run multiple Map Reduce, Hive HQL and Pig jobs. In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business … Designed Data Quality Architecture Framework for Source Systems Profiling in Mainframe, Oracle, Db2, SQL Server. Generated Dynamic reports from Cubes (SSAS) using SSRS 2005. Generated specifications for analysis reports by using SQL Server 2005 Reporting Services (SSRS). Communicated and extensively worked with Business groups like subject matter experts and business analysts to understand business requirements. Used SSAS to create cubes with various measures and dimensions for financial reports generation. Fine-tuned existing Informatica mappings for performance optimization. Designed and developed exception handling and data cleansing / standardization procedures. Performed data cleansing, data manipulations using various Informatica Transformations. Developed Awk, Sed, Perl and Korn Shell scripts to manipulate large data sets in a Unix environment. Created Drill down reports, Drill through reports, Matrix reports, Tabular Reports, and Charts using SQL Reporting Services. Offered by University of Colorado System. Used SQL Profiler, Windows Performance Monitor, Index Tuning Wizard and DB Artisan for troubleshooting, monitoring, performance. Prepared the design documents and solution specs for all the modules developed. Utilized PL/SQL, COGNOS, and TOAD for creating and maintaining ad-hoc reports. Data Warehouse Developers analyze, organize, store, retrieve, extract and load data as a means of staging, integrating, and accessing information. Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data. There are different and multiple types of Data Warehouse skills. Developed mappings to read different sources like mainframe files, flat file, SQL Server, Oracle db. Assisted with architecture and planning for SQL Server upgrades, maintenance, replication, and disaster recovery. Deployed the project on Amazon EMR with S3 connectivity for setting a backup storage. Merged all legacy ING-Direct bank data with Capital One and pushed to Hadoop. Analyzed all the existing source systems and the new data model of the target system. Designed various mappings (Source-to-Target) using Data Stage to link between different source systems and Destination Systems. Used ASCII, Delimited Files to load the data into ODS and EDW. Performed XML data Validations using customized and available source XSD Validation Frameworks. Created Business Requirement and High-level design documents. Generated reports using SQL Server Reporting Services 2008/2012 from OLTP and OLAP data sources. Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS. Designed jobs which perform data validation tasks on files in XML, CSV format. Configured Flume to extract the data from the web server output files to load into HDFS. Optimized MapReduce code, pig scripts and performance tuning and analysis. Documented user requests and created design documents. Computed various metrics using Java MapReduce to calculate metrics that define user experience, revenue etc. Created and documented Test plans using Test Director. Converted business requirements documents into technical solutions for users. Used SSIS Data Profiling Task to analyze data quality for the purpose of application improvement and Master Data Management. Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same. Extracted Keep The Change module, opt-in-opt-out modules accounting reporting process by utilizing COBOL/JCL/MVS/TIFO/DB2/SQL STORED PROCS technologies. Participated in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning. Coordinated with DBA's and Technology Development staff to manage source system changes. Developed and Deployed of Enterprise Datawarehouse (EDW) to support operational and strategic reporting. No spam, just information that will help you build a resume that makes you feel relevant and well represented. Created custom SSRS subscriptions on SharePoint that went beyond the limited SharePoint subscription functionality. Total of 20 employees. Developed various Mappings and Transformations using Informatica Designer. Involved in end-end implementation of etl process using OWB, PLSQL, Perl and UNIX. Proposed BI solutions for better performance of business by interacting with business stakeholders and created highly used and successful products. Developed stored procedures and modified triggers using PL/SQL to verify, cleanse, and scrub the data. Worked closely with the DBA to troubleshoot performance and tune complex SQL statements for optimal performance. Worked on Production Server's on Amazon Cloud (EC2, EBS, S3, Lambda and Route53). Used stored procedure transformation inInformatica to execute procedures before/after the target load. Participated in data warehouse life cycle including requirement analysis, modeling and design. Created requirements/tasks for creating a new Data Warehouse and designed and developed ETL templates with centralized metadata. Involved in design of dimensional database - Star schema and creation of physical tables in Oracle. Implemented changes in Cubes (SSAS) as per the requirement. Involved in integrating HBase with pyspark to import data into HBase and also performed some CRUD operations on Hbase. Worked on creating MapReduce programs to parse the data for claim report generation and running the Jars in Hadoop. Incorporated tuning suggestions provided by AbInitio Support to Graphs and developed test strategy to validate end results after performance tuning. Analyzed scope of application, defining relationship within & between groups of data, star schema etc. Worked along with Data Warehouse Architect and DBA's to design the ODS data model for reporting purposes. Mentored team members in query tuning, data design, and SSRS reporting. Prepared Detail design documents for the project as per the ETL standards, procedures and naming conventions. You must standardize business-related terms and common formats, such as currency and dates. Involved in translating business requirements to integrate into existing Data mart design. Created PL/SQL procedures, views to process the data from staging environment and load it into the production environment. Business intelligence is a technology-driven process, so people who work in BI need a number of hard skills, such as computer programming and database familiarity. Developed detailed analysis of Data warehouse DB2 for creating Database and DataMarts. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database. Worked on connecting Cassandra database to the Amazon EMR File System for storing the database in S3. Data Warehouse Concepts: Learn the in BI/Data Warehouse/BIG DATA Concepts from scratch and become an expert. Documented migration procedures, conducted on-site migrations, and provided customer technical support. Created data lineage documentation for staging data, mapping to star schema data model, and feeds for downstream systems. Created Data Dictionary, EDW Stage load to Target Load process documents. Worked with HBase for large volume transaction sales data, created daily snapshot of HBase table for downstream analytics. Tracked and identified the slowly changing dimensions (SCD), heterogeneous sources, and dimension hierarchies for the ETL process. Installed and configured Hadoop Ecosystem components. Developed documentation and procedures of refreshing slowly changing in house Data Warehouse dimensional tables. Developed data reconciliation SQL queries to validate the overall data migration. Used SCD type 2 to load Historical and present Data into EDW. Analyzed Java code to implement same logic in Business Objects Universe and reports. Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping. Developed error handling process to collect rejects for data analysis. Collaborated with BO team to design SSRS Reporting and reports for enterprise reporting applications. Configured OLAP dB level and cube level role based security. Developed T-SQL queries, triggers, functions, cursors, and stored procedures. Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups. Designed ETL for JD Edwards on Oracle and MS SQL Server source data. Ported the code for 4 US Insurance products from a VMS to a Linux platform Developer - Web-based product. Created test cases, test plans, test strategy based on the project scope documents. Worked with Enterprise Data Warehouse (EDW) team. Optimized the T-SQL queries to with the use of SQL Profiler, Indexes and Execution Plans for faster performance. Communication. Managed package configurations to efficiently deploy ETL packages from Development Environment to Production Environment. Implemented Surrogate key by using Key Management functionality for newly inserted rows in Data... 2. Developed user interface screens, master detail relations and Reporting screens. Involved in processing ingested raw data using MapReduce, Apache Pig and Hive. Extracted documents were stored in XML with content in Base64 Compression to reduce disk storage requirements. Performed transformations, cleaning and filtering on imported data using Hive & Map Reduce and loaded final data into HDFS. Preformed data integrity checks, created aggregation tables for OLAP tools and QA reports for data validation. You also need to restructure the schema in a way that makes sense to business users but still ensures accuracy of data aggregates and relationships. Created SSAS cube(s) populated from multiple sources for report building and general browsing. Worked on ad-hoc requests from Business to run data analysis, identify patterns and provide data support on daily basis. Created and facilitated presentations and demonstrations for Informatica. Worked with the DBA to generate Indexes and understand the Data Base Architecture to achieve performance tuning. Let's find out what skills a Data Warehouse Developer actually needs in order to be successful in the workplace. Worked with DBA s to consistently improve the overall performance of the data warehouse process and to debug the oracle errors. Participated in modifications of data models that were used in medical billing. Ensured data integrity, performance quality, and resolution of SSIS data load failures and SSRS reporting issues. Served as a contractor doing Datastage development and data analysis on various data warehouse projects. He applies his deep knowledge and experience to write about career change, development, and how to stand out in the job application process. Sophisticated cube, and OLAP reports have also been developed using Crystal Info. Provided technical direction to programmers on the IBM TSO Mainframe, Unix and Oracle 9i based system. Developed and modified stored procedures for sales force application. Analyzed the source systems to identify subject areas, fact and dimension entities. Ingested all formats of structured and semi-structured data including relational databases, JSON using NIFI & Kafka into HDFS. Scheduled batch jobs for processing flat files, XML files as source and target. Migrated survey data to the Sewer Engineering Repository. Understand the costs and … Based on an IBM DB2 data warehouse, the solution will enable business users to self-service their information requirements. Managed global and local repository permissions using repository manager in Oracle Database. Imported data from Oracle database to HDFS using UNIX based File Watcher tool. Decreased the impact of ETL / Data Conversion processes on implementation time lines by improving documentation and performance of T-SQL scripts. Maintained reliability and availability of existing Data Warehouse, cube, Reporting Server, Integration Service and Analysis Service Instance. Scheduled workflow using Linux Shell scripts. Secured and Configured ETL/SSIS packages for deployment to production using Package Configurations and Deployment Wizard. Created Reports utilizing Visual Studio 2005 SQL Reporting Services and deployed reports to the web server for Management to review online. Involved in the maintenance process by changing and updating of the existing EDW and ODS complex mappings, sessions and workflows. Developed UNIX shell scripts and Perl scripts to process flat files from various sources and load data in. Performed database administration for a SQL Server-based staging environment. Designed lookup strategies using Hash file stage for data extraction from the source systems. Developed and created logical and physical Database architecture utilizing ER-Win Data Modeler. Developed FTP and UNIX scripts to deliver and receive files to and from vendors. Implemented a Java program to resolve ingestion issues caused by default field delimiter. Updated web application pages in Perl to make them OWASP compliant. Worked of Technical design documents and presented to the Management for approvals. Used Cassandra CQL with Java API's to retrieve data from Cassandra table. Visit this link to see more resume skills examples for inspiration. Used Reverse Engineering to Connect to existing database and create graphical representation. Developed the reports for the research data warehouse dashboard and Investment rating site using SSRS. Below are the most commonly sought qualifications for a data warehouse analyst: Excellent research, analysis and problem-solving skills A bachelor’s degree in computer science or a related field … Used DataStage Director to execute, monitor execution status and log view, also used in scheduling jobs and batches. Interfaced with Engineering, Accounting, Marketing, QA, and IT teams for data reconciliation and validation. Involved in designing the logical and physical model of database objects using Toad. 2. Scheduled Reports through Cognos Event Studio to get the Daily output of reports. A Data warehouse is typically used to connect and analyze business data from heterogeneous sources. Created Repository using Repository Manager. Assisted other application developers with design and development recommendations. Used Apache Maven extensively while developing Mapreduce program. Installed and configured ODI from seven source systems to an Oracle 11g target. Configured Oozie workflow to run multiple Hive and Pig jobs which run independently with time and data availability. Automated data loading, balancing procedures and designed cross-reference procedures to link customers to their accounts. Used Visual Source Safe for documenting the Mapping specifications, IAD's and design documents. Tested reports in the QA environment and migrated reports using CMC Promotion Management as well as Import Wizard. Received professional training over Java programming and Big Data development skills. Most jobs involve interacting with employers, coworkers, and clients. Managed the development and execution of test plans, and effected corrective action on data quality issues. Designed dynamic data repository structure to accommodate a fluctuating data sources for external data. Developed message flows in Message broker to do XML to copy book transformation routing and Database retrieval using ESQL. Involved, Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements. Worked on Informatica Partitioning for Database Table Partitioning. Data warehouses are information driven. Ideally, the courses should be taken in sequence. Experienced in creating and scheduling ETL packages that update OLAP cubes in the Data Mart. Worked on designing OLTP staging areas, OLAP data marts using star schema and dimensional modeling. Truncated and reloaded tables in different databases using Data Integrator and Data Services Designer. Attended scrums and elicited feedback from teams to develop Staffing Pattern Reports. Design and implementation of data models are required for both the integration and presentation repositories. Monitored the execution of UNIX shell scripts to insure the successful completion of all our Business Intelligence processes. Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing. Developed SSIS 2012 against SQL Server 2012 database to implement type 1 and type 2 slowly changing dimension load. data validation testing. Administered BrioQuery repository and On Demand Server. Installed and Configured Client tier on Windows XP, Engine and Services Tiers on Red Hat Linux machines. Performed data analysis and wrote System Design Specification and Technical Design Specifications. Maintained ETL functional specifications, test plans and data for data conversions. Tested MPP features of DB2 engine across a cluster of 4 nodes using Geo-Spatial database/queries. Mastered the use of sub-queries, constraints, INNER/OUTER JOIN, PIVOT and other advanced T-SQL functions. Coordinated with QA team to build and deploy baselines using Rational Clear Case. Mentored the team in QA practices enabling them to develop and achieve goals. Identified source systems, their connectivity, related tables and fields and ensured data consistency for mapping. Designed the ETL process involving the analysis, interpretation and presentation of information from both internal and secondary data sources. Involved in Java, J2EE, Struts, Web Services and Hibernate in a fast paced development environment. Worked with various tasks like expression task, SMTP task, execute SQL task in control flow. Developed generic translation modules to convert OLTP data to be stored in the warehouse database. Assisted Supply chain analysts with automating reporting functionality using Power BI tools. Designed ETL/data Integration solutions from source systems and historical archives utilizing SSIS/SQL Queries and/or stored procedures. Explored Spark API over Cloudera Hadoop YARN to perform different data analysis tasks with the data in Hive. Partitioned SSAS cubes and assigned appropriate storage modes such as MOLAP and ROLAP as per business requirements. Practiced with a professional who pursued similar goals in order to improve Technology Related abilities. Supported data warehouses to resolve data integrity issues and refine existing processes. This is the second course in the Data Warehousing for Business Intelligence specialization. Worked on System Design documents, interface design documents and mapping of data elements. Worked and coordinated major releases to update and delete data from Edward tables on need basis. This initial design has … Maintained user groups, privileges/rights and passwords in BrioQuery repository. Used DB2 Stages to Read Data and Transformed into Target SQL tables using various Transformation Rules (Business Rules). Developed ETL procedures, translated business rules and functionality requirements into ETL procedures using DataStage. Designed, developed, and tested data warehouse prototypes to validate business requirements and outcomes. Provided documentation about database/data warehouse structures and updated functional specification and technical design documents. Provided full support on Smart Link application and responsible to update feedback mail box as well as issue log.

Hostess Coffee Cakes Cream Cheese, What Does A Sap Beetle Look Like, Can I Use Vinegar Instead Of Pickle Juice, Svs Sb-4000 Manual, Final E4000 Price, Pomegranate Root Type, Wall Ac Bracket, Best 4k Security Camera System 2020, Fallout New Vegas You'll Know It When It Happens, Ge Cafe Counter Depth Refrigerator, Chinese Character Practice Book Pdf, Coconut Peanut Butter Balls, Rescue Witt Lowry Lyrics,