Job Description :
Hi, Greetings from KK Software Associates. This is Syed Fazulul from KK Software Associates. I have an urgent requirement of Sr IT Business Analyst, please go through the below requirement and forward me your updated resume with contact details ASAP. Position: Sr IT Business Analyst Location: Columbus, OH & Columbia, SC Duration: 12 Months Contract Must work Onsite (no Remote) Responsibilities Gather requirements from JAD sessions with business users. Design and develop Activity Diagrams, Sequence Diagrams, and OOD to represent the requirements to communicate the information effectively with users, developers and testers. Work closely with business users, subject matter experts to understand and document functional and non-functional requirements for various use cases. Identify/document data sources and transformation rules required to populate and maintain data warehouse content. Reverse engineer ETL jobs, Reports, SQL scripts to capture rules and build end-end mapping sheet. Review and analyze data and data models including reports to augment the requirement for use cases with technical information for facilitating development and data modeling activities. Partner with data modeler to facilitate design and build of conceptual, logical and physical data models for Data Marts and the Data Warehouse. Conduct meetings and presentations to share ideas and findings to stakeholders and team members. Effectively communicate insights and plans to cross-functional team members and management. Be involved in formatting data stores and generate UML diagrams of logical and physical data assets. Write data analysis SQL queries to profile and document metadata to analyze data and augment key inputs required for data modeling and ETL build activities. Perform extensive requirement analysis, develop use cases and workflows. Play key role in the planning, User Acceptance Testing, and Implementation of system enhancements and conversions. Develop strategic partnerships with the business units to develop a solid knowledge base of the business line including the business plan, products, process and revenue streams. Parsing high-level design specification to simple ETL coding and mapping standards. Develop business requirement specification documents as well as high-level project plan. Requirements Bachelor's Degree or master's degree in Computer Science, Mathematics, Statistics. 10+ years of experience working as Business Analysts. 6+ years of experience in T-SQL and multiple databases like SQL Server, Oracle. 3+ years of experience in Informatica and other ETL tools. 5+ years of experience in Reporting tool like MicroStrategy and Tableau. Experience Hadoop / Big Data Technologies and Cloud Azure. Excellent verbal and written communication skills. Conducted benchmarking activities to identify best practices. Candidate Details Candidate Full Name (As per Passport): Contact Number: Email ID: Skype ID: Date of Birth: Current Location: Work Authorization/Validity: Highest Education / University / Year of Passing: Year of Entry to USA & Visa: Total Years of Experience: Relevant Years of Experience: Total Years of US Experience: Willing to Relocate: Y/N Time Slot 1 (Skype/Phone) Time Slot 2 (Skype/ Phone) Notice Period: LinkedIn Profile: Pay Rate Regards Syed Fazul | IT Recruiter Direct Email: