Description
PROFESSIONAL SUMMARY: * Over 7 years of experience as a Business Analyst in requirement gathering, analysis and business processes management with adept knowledge of System Development Life Cycle (SDLC) using Waterfall, RUP, and Agile methodologies. * Experience in full Software Development Lifecycle (SDLC) from association with end-users for requirements determination, defining the system scope, system analysis, Business Case Development to Rollout, Production, testing, maintenance and documentation. * Extensive experience in creating and analyzing Business Requirements Document (BRD), Functional Specifications Document (FSD), Use Cases, User Stories, and Systems Requirements Specifications (SRS). * Extensive experience in conducting Joint Application Development (JAD) sessions for project definition involving analyzing requirements, creating prototypes, user interfaces, database schema and system design. * Strong experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS). * Solid experience with ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS. * Designed, developed and implemented various SSIS Packages and deployed using Deployment Wizard. Responsible for running SQL queries against SQL Server database to generate reports. * Proficient with all phases of database development from designing databases (relational and dimensional models) to the creation of reports. * Built, published customized interactive reports and dashboards, report scheduling using Cognos BI server. * Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Cognos.
Accomplishments
Highlights:
Keywords
