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/Solution
Architect/Functional Business Analyst, Project Management Professional (PMP),
Certificate Web Site Quality Assurance.
Total 1 0+ years of experience in Data Warehouse and data mart, database architecture,
ETL and development activities and document preparation (SRS, FRD, RTM), MS
Visio, MS Office, UML Modelling
Responsibility Areas: -
Responsible for developing and Implementing He she will also use share point for
reports/dashboard management including CMS requirements. He/she will be responsible for
designing, constructing, and testing of ETL processes and software coding that may
be necessary to extract data from the transactional and/or operational databases,
transforming the data according to analytical I reporting business needs, and loading the
data into a Data Warehouse or Data mart. He will also contribute in designing data
backup and archival policy and implement such policy. He/she will provide input for
data structures and incremental data needs for real-time DWH to OLTP team. The
person will develop user interface for OLTP/OLAP application for multilingual environment.
Prepare ETLIELT plan for import and export under data integration plan using SSIS
from/to different sources and reports using SSRS, .NET framework, MS Power pivot
and silver light. Develop and implement data integration testing policy.
Develop/manage share point portal. His/her important tasks include develop and deploy S
SAS based Cubes, partitioning, writing KP is, implement Drill through for designing and
development of repairing/dashboard and DSS modelling solutions using share point/ S
SRS on android and windows mobile/iPad and ensure remiss classification and
their delivery and monitoring of use for improving performance of system. The
person will perform analysis, development, and evaluation of data mining needs in a
data warehouse environment that includes database design, database architecture,
metadata, and repository creation. He/she will monitor use of data warehouse system
resources 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 problem
diagnostic, provide guidance to users and feedback to software development team for Change Management after testing. The person is responsible for development of a strong
solution 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 application
reports/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 and
BCP 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 and
organizing information for preparing news Letter and other manuals.
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/certificat
Looking for Mca graduates profile.
Looking for Mca graduates profile.