Summary:
Senior Analyst with 4 years of experience in Financial, Retail and Shopping domains. Extensive experience working with enterprise level data warehouses, ETL tools and writing advanced SQL queries including OLAP Cubes functionality across various RDBMS platforms (SQL Server, Teradata, Oracle & DB2).
Proficient with Data Analysis techniques like Data Profiling, Data Cleansing, Data Integrity, Data Mining, Data Reference and Security and etc. Strong knowledge and understanding of Data Lineage. Good knowledge of Dimensional Modeling and Normalization approaches and also Dimensional Modeling and Normalization approaches.
Adept at building innovative reports and interactive dashboards using Tableau. Publish reports in Tableau server
…show more content…
Data Analyst
Working as a Sr.Data Analyst in Brokerage Technology division of Wells Fargo Advisors. Primary responsibilities are extracting Detailed Data requirements, conducting Current system Analysis, Impact Analysis, preparing Deliverables such as FDR, SSA(Source System Analysis), Source- to-Target Mappings, indentyfying the Transformation logic to develop ETL scripts.
Analyzed Metadata using DMM tools(Wells Fargo Specific) and Informatica Metadata Manager(IMM) as part on Information security and Risk Assessment project to trace out the confidential data fields in the Data Warehouse and ODS.
• Involved in the entire project life cycle from evaluation, installation and development of end user reports.
• Gathered and Analyzed User requirements, finance data and designed hierarchy to meet the requirements.
• Worked closely with BAs to gather and provide specific and crucial information through data mining using advanced SQL queries, OLAP functions and PL/SQL Stored Procedures and functions.
• Discovered Data Lineage and read application material to understand workflows and complexity. Mined data from numerous source systems.
• Conducted Curent system analysis to find the
Worked in end to end automation of many system reports and created a report dashboard for data extraction.
Information Systems & Technology: This segment’s expertise lies in specialized data acquisition and processing, in advanced electronics, and in battle space information networks and management systems.
In Druk Green Power Corporation, I have been working as Assistant Manager (Finance) and Core Team Lead for Implementation of SAP ERP, FICO Module. My premier responsibility is to provide financial information to management and assess the SAP ERP system.
Specialist and Forecaster in the marketplace. I believe in taking a vision and executing a plan that will bring permanent longevity for any service or product. I understand the entertainment industry and enjoy finding research for future programming models like digital streaming. I know what is needed to create effective strategies and analysis for companies. For example, Fox doesn’t offer live online streaming for their Fox.com website; I can create a platform that will help transition Fox into using a live streaming service to boost
Proficient in investor programs, software, and internal systems: QCIQ, BOX, Prime Alliance, DNA, MS, Salesforce, Radar, Streamline, Onbase, DME/DMC, LPS, Clara, LIV, MetaStor, Fidelity, MSP, Fastrieve, Flight Path, Plant Computer DataTrace, Web Direct, Director, Planet Press, Process Mgmt., Guild, and DocNet, Data Trac, Orijin, EPF, Blitz Docs, MyKey, I5
All projects are working towards a Data Model that gets approved by engineering and business in the next few sprints. The goal is to provide self service reporting capabilities for the data relevant to respective business function.
In the past weeks, it felt like riding an emotional roller coaster when thinking about being an analytic professional. Professionally, knowing that the personal strengths are in research, planning, organizing and understanding concepts are great, however, the inability to connect what is learned into applicable actions is concerning. On a brighter note, it was surprising to have learned that being an analytics profession isn’t just about numbers and graphics and understanding statistical models, one has to also know (a) data protection, (b) data integrity and (c) data transformation. Next, the connection to project management where responsibilities of a project manager are actually applicable to a professional analytic is a personal bonus. Having an extensive background in project management and business analyst, being able to still practice the learned skills and techniques and apply it in the new found of analytics is a pleasant finding.
Following this step is the process of reviewing knowledge for the position by researching what the industry says the position should require and what other companies may have in place based on government statistics. The analyst can use this information to determine key job functions for the position. This will provide a basis for the analyst to begin to learn about the job in preparation for the analysis [ (Stewart & Brown, 2009) ].
Vivek described the elaborate stack Zones uses for data management and business intelligence, there are many components and tools they use to run this intricate ecosystem. The process begins each day around 10:00 PM with an ELT pull from their Oracle database, data marts, and partner databases to their data warehouse. Next, from that data cubes are computed and constructed. Next, the data is passed to repositories then to email to update dashboards in CRM and their next generation reporting framework.
Prior to graduating, future analysts will need to have knowledge of the profession and how they will be able to become an information security analyst. Graduates should expect to “plan and carry out security measures to protect an organization’s computer networks and systems” in this profession(United). Analysts also have duties such as monitoring the organization’s networks for security breaches, conduct investigations when breaches occur, install
The make-or-buy analysis is heavily depending on the accuracy of the company’s database. Therefore, I need to make sure that I have maintained the database and updated the information correctly. Moreover, I also need to perform several analysis from numerous files in the database and required the ability to analyze a huge amount of data effectively and in a timely manner.
Proficient in investor programs, software, and internal systems: QCIQ, BOX, Prime Alliance, DNA, MS, Salesforce, Radar, Streamline, Onbase, DME/DMC, LPS, Clara, LIV, MetaStor, Fidelity, MSP, Fastrieve, Flight Path, RBJ, ACaps, Plant Computer DataTrace, Web Direct, Director, Planet Press, Process Mgmt., Guild, and DocNet
Many corporations are experiencing significant business benefits of using data warehouse technology. Users report gains in market competitiveness through increased revenue and reduced costs through information management. Data warehousing is thus a major issue within most organizations, and thus the development of a data warehouse with a strong base is essential. This paper aims to present the important concepts of Data Warehousing such as Data Warehousing tools and the benefits of Data Warehousing, that a manager must understand in order to execute a successful Data Warehousing project in his/her company.
In the world of computer science large groups of data collected are referred to as databases. When there is a multitude of these databases, a way to manage all of the information is
For my role, i bring the delight for talking consistently with our clients – CIOs, CTOs, engineers, line of business holders – and additionally accomplices Also administration suppliers regarding their objectives What's more tests. Toward those same time, our identity or result directors Furthermore engineers, those practically encountered in the industry,