Business Analyst Sql Server

NAMITHA VISWANATH

Princeton NJ • Phone: 732-***-**** • adx4sx@r.postjobfree.com

SME and Delivery Lead, QA Analyst, Business analyst

** *****' success in enterprise master data management, ETL, data quality and data governance.

Versatile and experienced Professional in architecture design, development and delivery of data management and data governance solutions to enable digital transformation. 10+ years of hands-on experience in architecting solutions for financial, banking, trading companies, supply chain and public sector application domains across leading technologies. Experience in handling projects at same time without having any conflicts. Adept at supporting clients in transforming their business processes and realizing their digital enterprise vision and managing high-performing project teams or working independently to enhance performance and increase profitability. Worked various part of the Project Development group and involved in different phases of Software Development Life Cycle, Requirement Analysis, Design, Development, Testing, and Implementation of large-scale projects. Experience in managing various complex projects with challenging timelines and pressure. Working closely with Product/Business Owners, Software Developers/Testers within the program to ensure integrity of the end-to-end solution. Experience in assisting Product Owner with Backlog grooming, User Story development and prioritization. Extensively experience in working on projects and application support involving ETL and Master Data Management(MDM), Data Analysis, Data Quality. Managing, administering, and providing Production Support for existing Workday Implementations. Strong organizational skills to manage diverse projects with different deadlines and competing priorities. Strong leadership skills and ability to lead cross functional teams. Self-starter and ability to work independently, quick learner, team player with drive for excellence.

Highlights of Expertise

Solution Architecture

ETL Architect

Data Analytics

Master Data Management(MDM)

Data Integration

Agile/Scrum Methodologies

Technical Project Management

Data Modeling

Data Warehousing

Process Improvement

Requirements Analysis

IT Service Management

Techno functional lead

Quality Assurance

TECHNOLOGY SKILLS

Developer Tools: C#, JavaScript, LINQ, XHTML, XML, HTML, Tableau Desktop, Tableau Server Power BI, Qlik

Databases: SQL Server, Oracle 9i,11g, MySQL, MS Access

ETL Tools: DTS, SSIS.

Reporting Tools: Crystal Reports, MS SQL Server Reporting Services (SSRS).

Modeling Tools: UML, Microsoft Visio, Office 365

Process Automation: SharePoint, Jira Automation, Confluence, Autosys

Tools: Expression Blend, VSS, TFS, SVN, Nunit

Methodology: Waterfall/Agile methodology, Business Analysis, Client Relationship Management, Microsoft Office, Business Process Improvement, Project Management, SQL, Jira, Wrike, UAT &QA management, SharePoint, SCRUM

PROFESSIONAL EXPERIENCE

Dept. of Treasury, State of New Jersey App Systems Analysis/Program Manager January 2017 – Present

Managing Delivery, right from Requirement Analysis to Production Deployment.

Developing project plans that identify key issues, potential problems, approaches, performance metrics and resources

Presenting status, issues, risks along with possible solution path to the senior management.

Performing data validation during the requirement analysis, System testing and pre-production stages using scripts.

Designed and developed ETL, DQ and master data management programs.

Ensuring successful and timely leadership of client projects, which includes gathering and documenting business requirements, translating customer requirements into specific technical requirements, assembling system documentation, coordination of software development life cycle, understanding client issues and communicating status, developing project plans, and tracking deliverables.

Coordinate and maintain interdepartmental relationships between technical staff, quality assurance, technical support analysts and sales staff to ensure on-time implementations and optimize project success.

Ensure client satisfaction in platform conversion projects to grow and maintain business while keeping within implementation timelines.

Facilitate incident troubleshooting using SQL server to query application logs and system configuration as well as issue replication to achieve a resolution in a timely manner

Developed crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications.

Document functional specifications, perform User Acceptance Testing and coordinates BAT/UAT testing with clients and Dev/QA team.

Created MS Visio on database to ensure approval from process owners

Redefined use cases, process flow and activity diagrams using MS Visio for a clear understanding of the requirements.

Use Jira to track bugs and the development of projects throughout the SDLC

Designed SSIS packages to populate the transactional system, flat files to staging and the to SQl server (data warehouse) by using multiple transformation such as Data conversion, Conditional Split, Merge Join, Lookup and Union all.

Migrated SSIS packages from visual studio from different versions.

Managed Package Configuration in xml files to efficiently promote unit tested package to live environment from Development Environment.

Implemented data transformation activities utilized SQL and scripts.

Gather and analyze the business requirement.

Setup analysis framework following industry best practices and knowledge

Advise and review the code and other delivery

Present analysis report and solutions to key business stakeholders

Interact with the client for system study, requirement gathering, analysis & scoping.

Experienced for problem solving using creativity and innovation to apply the right technology solution.

MarketAxess, New York City, Quantitative Analyst November 2015 – December2016

Formulated data standards and implemented master data conversion.

Participated in ad hoc analysis and generated reports.

Works well in an Agile environment.

Prepared and managed UAT test scripts and cases.

Prepared new master data files by checking duplicates.

Created, monitored, and reported project metrics.

Conducted business process reviews and implemented system testing activities.

Use Jira to track bugs and the development of projects throughout the SDLC.

Providing technical management for definition, estimation and delivery of data modeling, configuration, and integration

Lead internal deployment meetings with other team members to review project statuses, assess deployment risks and plan rollback strategies.

Break down barriers preventing development and infrastructure Dev teams from progress against sprints and deadlines.

Ensuring successful and timely leadership of client projects, which includes gathering and documenting business requirements, translating customer requirements into specific technical requirements, assembling system documentation, coordination of software development life cycle, understanding client issues and communicating status, developing project plans, and tracking deliverables.

Worked on formatting SSRS reports using the Global variables and expressions.

Developed custom controls for WinForms and generating reports.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Peer review (Mappings/Workflows), Defect tracking and control. Analysis of performance related issues.

Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services.

Fannie Mae, Reston, Virginia, Software Engineer December 2014 – October 2015

Evaluated technical requirements and designed test plans.

Experienced in answering ad hoc questions and provide clarification/direction to development and support teams regarding user stories and functions.

Coordinated and facilitated extensive user interviews and workshops to gather and analyze requirements.

Working closely with technical teams to validate designs based on the requirements.

Developed and implemented new ERP systems and upgraded existing ones depending on project needs.

Responsible for evaluating current state, gap analysis to future state, recommend Data Governance framework.

Knowledgeable about QC and JIRA testing tools.

Created UML diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER diagrams in MS Visio.

Suggested and executed modifications for MDR.

Reviewed MDM platform problems and conducted technical training session for software.

Provided technical assistance for development and maintenance of AutoSys and related scheduling solutions.

Used MS Visio to carry out the Business Use Case Modeling and Business Object Modeling effort to develop to the business architecture for rapid and controlled application development.

List Of Value standardization and approval from data governance council.

Provided technical support services for MDM mapping and gap analysis sessions.

Deliver Data Governance Framework and Account Master User Training Manual

Created rules, Rule functions in TIBCO Business studio.

Helped the client stake holders with Demand management.

Estimated efforts and costs for demand items.

Responsible for Resource Planning & Allocation and Agile environment.

Involved in Gap Analysis and review of business and functional requirements.

Supervised and involved in Release Management activities

Helped with Testing Schedule Planning (Unit, SV&T, SIT, UAT, Prod Dry Run).

Analyze Business Requirements and prepare and deliver Design documents.

Provide Future State Solutions

Fix bugs/defects arising from testing

CIT Bank, New Jersey, System Analyst February 2014 – November 2014

Played the role of liaison with the client IT management.

Worked in all areas of project management including multiple project integration, scope, time,

cost, quality, staffing, communications, risk, and procurement.

Developed project plans that identify key issues, potential problems, approaches, performance

metrics and resources.

Analyzed system processes and suggested system improvements.

Collaborate and provide business analysis support to the product owner, business sponsors, SMEs, and testers during development

Develop & maintain all reports, dashboards, workflows & sharing rules within Salesforce.com to improve visibility to activities, pipeline & forecast.

Experience with QC and JIRA testing tools

Presented status, issues, and risks to the senior management.

Analyzed results and documented findings for presentation at project team meetings.

Providing high–level shipment and purchasing support to the admin and purchasing team.

Fix bugs/defects arising from testing.

Kluster Techno Solutions, India Senior Software Engineer/System Analyst June 2007 – July 2008

Generated, consolidated, and customized reports for various functional modules for supply chain applications.

Designing the architecture of new requirement as well as database design and data load process design.

Leading all Informatica activities, coordination onsite.

Manage development check point sessions with offshore twice daily to review development issues and status.

Developed and tested the Crystal Reports on Crystal Enterprise 8.0 environment.

Attention to detail with the ability to analyze and solve complex problems as well as provide documentation, guidance, and instruction to users.

Strong problem solving and analytical skills with great business sense.

Ability to work in a dynamic, fast-paced environment and pick up new skill sets quickly.

Strong communications skills including the ability to facilitate meetings, prepare concise documentation, write business cases, prepare presentations, etc.

Strong analytical and troubleshooting capability

Used CSS for page styling and implemented AJAX to facilitate fast response and to reduce the server roundtrip delay.

Worked with Project Managers and Quality Assurance Engineers and make sure the user requirements and expectations are defined during Project kick off meetings

Kuwait Resource House, Kuwait Application Developer December 2005 – June 2007

Implemented automated processing of HR application; Business had manual process for handling passport and employee details using EXCEL. My application generates EXCEL reports.

Implemented the module for proper authentication levels for the reports to prevent unauthorized access of the business-critical reports, allowing only authorized users; the module also includes complete inventory management to accounts with much needed precision & accuracy.

Extensive experience in ASP programming.

Developed multi language reports were developed and used (Arabic and English).

EDUCATION

BS in Physics - University of Calicut, India

Postgraduate ‘A’ Level Advanced Diploma in Computer Applications – DOEACC, Ministry of Communications & Information Technology, Govt. of India

Contact this candidate