Business Analyst Jobs in Noida - Quarbz Consultant

Business Analyst

Quarbz Consultant

3+ Years

60000 - 65000 Monthly

Expired

Posted: 05 Jan 19

Job Description

Business Analyst

Professional Qualification: -BTech/BE/ MCA/M. Tech/ME/PhD in Computer Science/Information Technology (IT)and related fields or equivalent with consistently good academic record
Preferred Professional Qualification/Certification: -Diploma/Certification in Business Analysis and System Design, Certificate in COBIT 5,Certification in TOGAF 9 and above/Zach man Framework, SAS Certification,ITIL Foundation or Above, Business Analysis/System Design Subject at Degree Level,Certificate in Business Accounting, Certified Business Analysis Professional,Certification of Competency in Business Analysis, Certification in Systems/SolutionArchitect/Functional Business Analyst, Project Management Professional (PMP),Certificate Web Site Quality Assurance.
Experience: -Total 1 0+ years of experience in Data Warehouse and data mart, database architecture,ETL and development activities and document preparation (SRS, FRD, RTM), MSVisio, MS Office, UML ModellingResponsibility Areas: -Responsible for developing and Implementing
He she will also use share point forreports/dashboard management including CMS requirements.
He/she will be responsible fordesigning, constructing, and testing of ETL processes and software coding that maybe necessary to extract data from the transactional and/or operational databases,transforming the data according to analytical I reporting business needs, and loading thedata into a Data Warehouse or Data mart.
He will also contribute in designing databackup and archival policy and implement such policy.
He/she will provide input fordata structures and incremental data needs for real-time DWH to OLTP team.
Theperson will develop user interface for OLTP/OLAP application for multilingual environment.
Prepare ETLIELT plan for import and export under data integration plan using SSISfrom/to different sources and reports using SSRS, .NET framework, MS Power pivotand silver light.
Develop and implement data integration testing policy.
Develop/manage share point portal.
His/her important tasks include develop and deploy SSAS based Cubes, partitioning, writing KP is, implement Drill through for designing anddevelopment of repairing/dashboard and DSS modelling solutions using share point/ SSRS on android and windows mobile/iPad and ensure remiss classification andtheir delivery and monitoring of use for improving performance of system.
Theperson will perform analysis, development, and evaluation of data mining needs in adata warehouse environment that includes database design, database architecture,metadata, and repository creation.
He/she will monitor use of data warehouse systemresources and plan enhancement of response time for frequently and most used reports.
He/she will test, troubleshoot, optimize, and tune MS-SQL processes and complex MS-SQL queries and use X-queries/J-queries for optimization.
He/she will continuously work for enhancing performance of existing database objects used in ETL Processes and work with BI Lead, Solution Architects and Business Analysts to define scope and estimations of project I service delivery and effectively use MS- SQL Server Business Intelligence Development Studio (MS - S QL Server Data Tools) and share point server to empower users with support to report builder. Effectively control data integration jobs and manage records in error and removing errors in controlled manner.
He/she will use data profiling and lineage tools for determining quality and impact on reports and confidence level of reports and will participate and contribute to requirements analysis, adhoc reporting, and user support
Plans and authors the user documentation set, acceptance criteria, and helps construct representative test data sets.
Provide first level support to users regarding application related issues by studying solution and mapping with problemdiagnostic, provide guidance to users and feedback to software development team for Change Management after testing.
The person is responsible for development of a strongsolution framework for some of the data intensive projects and troubleshooting failed batch jobs, correcting outstanding issues and resubmitting scheduled jobs to ensure completion.
Develop user friendly web/mobile application reports/dashboards using MSSQL Server under Microsoft SharePoint and customize Dynamics (CRM), performance point and power pivot resources and Microsoft Visual Studio and deploy applicationreports/dashboards.
The person will develop dashboards/reports compatible for mobile phones and iPad.
He/she may be required to design/develop, test and implement DR andBCP Policy for data warehouse and build risk management scenarios for the purpose.
He/she will ensure first-time-right delivery and migrate users to self- service their requirements on Report Builder facility to reduce developmental and maintenance work.
He will develop proper data quality parameters and managing information from data in error and follow 'optimization criterion for the reports and dashboard by proper de-normalised database design and assess performance of reports and dashboard for further optimisation.
He/she will design, create, maintain, and update technical documentationincluding online help, user guides, white papers, design specifications, and other documents.
He/she will produce technical software document deliverables, including technical guides, plans, specifications, policy document, procedures document, audit and other reports, brochures, user and system manuals.
Support Business Analysts and Tech Leads in the organization, development, and documenting of technical documentation, edit and maintain documentation prepared by other team members; recommend revisions or changes in scope, format or content.
Publish fact sheets and case studies, writing SOP on various subject areas related to project.
The job involves collecting andorganizing information for preparing news Letter and other manuals.