We provide IT Staff Augmentation Services!

Business Systems Analyst/data Analyst Resume

0/5 (Submit Your Rating)

MD

SUMMARY

  • Over 7 years of experience in analysis, design, development and deployment of various client/server, Web Applications and Windows Applications that work on Text Analytics and Natural Language Processing.
  • Highly interested to be involved in fast - paced and high productivity settings where impact can be made both as a Business Analyst and as a Developer.
  • Developed Client Specific applications and provided proof of concept of Natural Language Processing (NLP) software and Information Retrieval application as a part of Research Initiative in Human Computer Interaction Lab to aid the Business requirements of the Clients.
  • Performed data mining analysis and NLP analysis for RDBMS
  • Highly experienced with data architecture, data modeling, business intelligence architecture (SAP BI), data-source analysis using SAP NW system.
  • Reviewed and analyzed qualitative (text data) and quantitative(statistical data) for data mining purposes.
  • Hands-on experience with Entity Relationship Diagram Modeling, Data Mapping, Data Modeling, Data Warehousing (ETL) and Data Normalization.
  • Strong skills in the database (RDBMS) designing and database programming using SQL.
  • Have developed standards for data definitions, data element naming conventions, and logical/physical database design for applications and data warehouse development.
  • Proficient in information retrieval skills, using search engines, databases, internet services.
  • Modeling: Creation and maintenance of BI objects (InfoObjects, InfoCubes, DSOs)
  • Development of Transformations, DTP, Data Sources (flat file source system), update and transfer rules.
  • Strong experience generating dynamic reports using SSRS (MS Reporting services).
  • Participated and generated Business Process re-engineering cycle.
  • Re-engineering experience for Business Process Improvement.
  • Highly skilled in designing the applications using UML diagrams such as Use case diagrams, Class diagrams, Structural and Interaction diagrams, Flowcharts etc.
  • Experience in developing Curricula for Knowledge Transfer and for providing Proof of Concept.
  • Experience in developing al applications for iOS devices for /learning purposes.
  • Strong Experience in Object Oriented Design and Analysis, Iterative Agile Programming Methodologies and Test-Driven Development and Maintenance.
  • Prepared and reviewed various artifacts such as Database Architecture, Test plans, Software specifications, Requirement documents and Design documents.
  • In depth knowledge of Microsoft .NET 3.5/3.0 with special emphasis on the areas of designing, developing, delivering high end e-Business/B2B/Web applications projects for various domain areas such as Retail, Banking, Finance and Insurance, Telecom and Airline.
  • Involved in all phases of Software Development Life Cycle (SDLC) including analysis, feasibility, design (specifically Data Flow Diagrams), coding, testing, implementation, maintenance and support.
  • Architected services to align with business objectives and fit into overall SOA driven program
  • Good experience in developing and consuming XML Web Services using WCF and SOAP
  • Self-motivated, good team member with excellent analytical, communication & problem solving skills with ability to work independently as well as in a team.

TECHNICAL SKILLS

Languages: C#, SQL, Python, C, C++, Java

Technologies: JavaScript, HTML, HTML5, CSS, XML, AJAX

Development Tools: Visual Studio .Net 2005/2008/2010

Data Mining Tools: Solr and Lucene

RDBMS: MS SQL Server 2008/2005/2000 (SSRS), MS Access, MongoDB, MySQL, PostgreSQL, Oracle 9i/10g/11g

Operating Systems: Windows Server 2008/2003/NT

Other Third Party Tools: MS Office

Methodologies: RUP, Agile, Waterfall

Requirements management tools: Borland CaliberRM, Rational DOORS

Business Modelling: Rational Rose, MS Visio

Mobile App development: iOS Dev Center, GameSalad

PROFESSIONAL EXPERIENCE

Confidential, MD

Business Systems Analyst/Data Analyst

Responsibilities:

  • Analyzes business requirements/processes and system integration considerations to determine appropriate technology solutions for internal and external customers.
  • Develop data architecture for Scientific Review Officers and train them on existing system implementation.
  • Analyzed the text data from search logs for reporting purposes.
  • Designs, evaluates, codes, configures, tests and documents applications based on system and user requirements.
  • Using current programming language and technologies, writes code, completes programming, and performs testing and debugging of applications.
  • Created a high-quality statistical-grade data set, optimized for Modeling & Analytics, emphasizing data validation, data mining, data cleansing & data reduction using ETL processes.
  • Involved in defining and documenting the vision and scope of the warehousing project.
  • Completes documentation (re-engineering) and procedures for installation and maintenance.
  • Worked with key stakeholders of the projects to identify and finalize the requirements targeting overall BPI.
  • Collaborated with clients, end users, and developers and ensured technical requirements are thorough using standard tools and modeling techniques.
  • Involved in backend validation for Oracle database using PL/SQL Developer(test SQL of Source and destination using latest data mapping)
  • Provide objective advice to clients (Scientific Review Officers) to automate their manual Grant Application screening processes by developing web based applications.
  • Apply defined practice/procedures to design, implement, test, deploy, and support software products.
  • Enhance the existing web based applications like SRDMS and INRO - https://inro.niaid.nih.gov
  • Generate dynamic reports using Microsoft reporting services (MS SQL Server Reporting Services - SSRS) for Scientific Review Officers.
  • Gathered and analyzed Reporting requirements and formulated Business Rules as part of the Data Warehouse Initiative with Business Objects as the front end reporting tool
  • Used Report Manager (SSRS) to modify Data Source Properties.
  • Create SQL stored procedures and reports using MS-SQL server.
  • Implemented MVC pattern.
  • Extensively worked on stored procedures, triggers, functions, views, temporary tables and table variables.
  • Worked with test team and fixed the issues as part of the bug life cycle.
  • Implemented Unit testing using NUnit.
  • Involved in writing complex SQL Statements and Stored Procedures, Indexes to validate data and ensure system integrity and security
  • Participate in design meetings and analyze the feasibility of software enhancement requests.
  • Consult and advice customer concerning application enhancements and maintenance of software applications.

Environment: C#.NET, Agile, Rational Rose, PL/SQL, Share Point, MS Visio, DOORS, MS SQL Server, SSRS, SQL

Confidential, NY

Business Process Analyst/Information Manager

Responsibilities:

  • Analyzed and participated in requirements gathering and document design.
  • Performed re-engineering by documenting the existing code.
  • Designed database architectures and normalized data tables for new database implementation.
  • Develped logical database design.
  • Actively Participated in Team Meetings, frequently communicated with Business Analysts to clarify the business requirements.
  • Trained key stakeholders on the incremental implementations by conducting workshops.
  • Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing agile methodology.
  • Designed ETL Process Models, Systems Diagram, Workflow, Activity Diagrams, Use Cases (UML) and Business Rules using MS Visio
  • Assembled & analyzed the modeling database using data mining techniques, including data reduction, data enhancement and data transformations.
  • Created mockups and prototypes for the JAD sessions
  • Responsible for creating the Business Requirements Specification Document (BRD) and the Functional Specifications Document (FSD)
  • Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Participated in Data Analysis and Design with the Data analyst in defining data sources and required data content for the data warehouse component.
  • Implemented management and role based security for managing the users (Create, Delete etc.).
  • Used JavaScript to implement the client side business logic and validations.
  • Updated data sources for report generation using SSRS.
  • Extensively worked on stored procedures, triggers, functions, views, temporary tables and table variables.
  • Used Team Foundation Server as version control and document management.

Environment: Visual Studio 2010, MVC, LINQ, C#.NET, PL/SQL, SOA, XML, DOORS, NUnit, and Agile Methodologies

Confidential, Omaha, NE

Business Systems Analyst

Responsibilities:

  • Participated in resourceplanningandbudgeting; tracked costs to ensure adherence to budgetary limitations.
  • Coordinated technical projects from start to finish that utilized a matrix organization ofdevelopers, programmers,quality engineers, and system engineers with a high degree of success.
  • SAP FI CO resource for Pre and Post Go live and stabilization phase
  • Preparing the config rationales for FI and CO and validating the configuration
  • Reconciliation of COPA,FI and PCA reports Wrotetest plansandtest casesbased on thebusiness requirementswhich involvedmarket risk analysisandrisk managementlike continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization.
  • Managedproject scopeaccording to project requirements.
  • Created Project kick off meeting presentation.
  • UsedMS Projectto createGantt and PERT chartsto pictorially represent the project timeframe.
  • DocumentedProject Charter,Project Plan, Time Lines, Deployment Plan, Supplier Management Plan, Issue Logs, and Risk logs etc.
  • Developed and maintain project analysis,project estimates, and evaluated projectmilestones/deliverables.
  • Created and managed team-level resource-loaded work plan on time, with quality, and following PMO guidelines.
  • Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards
  • Documented Network diagrams usingVisio.
  • Created project Schedules inMS Projects.
  • Responsible for assisting in thetracking of project expenses, managing costs, andmeeting budgeted hours.
  • Involved with development team to develop the user friendly interface to the organizations document management system that would monitor files stored with in system.
  • Was responsible fortracking issuesthat are detected and updating the status of existing issues based on the daily meetings with the off-shore team.
  • Performed server maintenance, software and hardware upgrades in regular intervals.
  • Identified and analyzed thedata requirementsfor the various site teams and made sure that the required data is available in the testing environment.
  • Proficient scheduling of work breakdown structure(WBS)and tracking of cost, scheduling and performance metrics.
  • Involved inSWIFTandBank Applicationadministration and maintenance.
  • Identified and incorporated milestones in project schedules.
  • Used the guidelines and artifacts of theRational Unified Process (RUP)to strategize the implementation of Rational Unified Process effort in different iterations and phases (Inception, Elaboration, Construction and Transition) of theSoftware Development Life Cycle.
  • Facilitated the closing of project issues by leadingweekly meetingsthroughMS-live meetings.
  • Participated in Risk, Issue andChange ManagementProcesses.
  • MaintainedSupplier ManagementReporting.
  • Conduct Tollgate meetings.
  • Developed QA Log to track defects to closure.

Environment: MS Project, Oracle, Windows NT, UML, Requisite Pro, Rational DOORS, MongoDB, MS-Visio.

Confidential, Ohio

.Net Developer

Responsibilities:

  • Conducted and facilitated many joint requirements, planning and brainstorming sessions with the business stakeholders to understand their needs for the future global expansion.
  • Defined frameworks for the application development and created Business Requirement Documents.
  • Conducted Gap Analysis to provide Impact Assessment on various departments across the enterprise.
  • Conducted root cause analysis and implemented new business processes by defining data flows.
  • Devised business processes to eliminate the manual effort and automate the claims settlement process.
  • Created Relational database architecture for data mining purposes.
  • Used Rational tools such as RequisitePro for managing the requirements, ClearQuest for defect tracking and Rational Rose for documenting use case Modeling.
  • Created UAT scripts and scenarios and facilitated the UAT.
  • Developed the material and Standard Operating Procedures (SOPs).
  • Created Data Access Layer for retrieving the data from the database.
  • Developed custom controls for Web Forms and generating reports.
  • Designed and created visual interface for administrative activities like filling in the information.
  • Used Team Foundation Server for Version Control

Environment: RUP, UML, Rational Requisite Pro, Enterprise Architect, SOA, MongoDB, MS Project, MS Office, SQL Oracle 8i.

Confidential

BA, Developer

Responsibilities:

  • Involved in total development life cycle (SDLC) of the application.
  • Involved in web form page life cycle, requirement gathering (SRS), analysis, design, development, source code management, build management, and testing of application.
  • Developed use case, sequence, activity diagrams for the application using MS Visio.
  • Used several AJAX (partial page load/asynchronous loading) controls and ASP.net file upload for GUI.
  • Responsible for developing business tier logic of the application in C#.
  • Implemented data mining and search API’s on existing databases.
  • Developed custom controls for Web Forms and generating reports.
  • Designed and created visual interface for administrative activities such as filling in the information.
  • Created SQL stored procedures to retrieve data from database (backend).
  • Involved in developing the Data Access Layer for the database access (MS Access, SQL server) and Performance tuning.
  • Performed unit testing, manual testing of the application, and UI testing.

Environment: Rational tools (Rose), RUP, MicroSoft.Net, MySQL, Oracle, Business Objects MS SQL Server

Confidential

Business Analyst

Responsibilities:

  • Involved in Design, Development, Testing and Maintenance of the project.
  • Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives (OTC and Exchange traded), Trading Strategies, Cash flows, financing structure, Portfolio Analysis, etc.
  • Involved in Developing a Web application to display products, check customer status, make a new customer registration, material management, order management etc.
  • Developed custom User Controls to reduce the complexity in UI coding and provide better look and feel.
  • Developed and performed analysis of web based, chat based and email based interface to the Business Applications.
  • Used Web Services for data transfer to store data in the Database.
  • Developed customizable interface for the clients-employees using XML and transformed to HTML using XSLT.
  • Used Master Pages, CSS & Themes for the consistent look of the application.
  • Involved in writing complex SQL Statements and Stored Procedures, Indexes to validate data and ensure system integrity and security
  • Created customized reports using SQL Server Reporting Services.
  • Used Team Foundation Server for Version Control and Source Control.

Environment: Agile, Rational Rose, Rational Requisite Pro, MongoDB, MS Visio, MS Project, Oracle, SQL

Confidential

Software Developer/Researcher

Responsibilities:

  • Devised business processes to eliminate the manual effort and automate the Books issue/reissue processes.
  • Logged in issues in Share Point and assigned them to the requisite individuals.
  • Used Rational tools such as RequisitePro for managing the requirements, ClearQuest for defect tracking and Rational Rose for documenting use case Modeling.
  • Created UAT scripts and scenarios and facilitated the UAT.
  • Developed various User Controls to use it across the application.
  • Used CSS to Design and create various templates to get a unified look and feel of the Web Forms.
  • JavaScript was used to do some client side validations.
  • Effectively created and consumed Web Services at various stages of the development. For example, insertion of data into database and fetching data from the database.
  • Involved in the project maintenance doing some bug fixing and doing knowledge transfer session under time constraints.
  • Developed and tested the test scripts for application products.
  • Worked on all phases of the Software Development Life Cycle (SDLC).
  • Implemented 3 tier architecture to develop business access and data access layers.
  • Developed Custom Controls, User Controls with ASP.NET, C# and reused in different modules.
  • Conducted Unit Testing of each module, integrated all modules, and tested the integrated system.
  • Designed and developed Triggers, Functions and stored procedures for SQL Server 2005 database.

Environment: Waterfall, Agile, Visual Studio 2005, .NET Framework 3.0, ASP.NET, C#, SQL Server 2005, and CSS

We'd love your feedback!