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 Training Curricula for Knowledge Transfer and for providing Proof of Concept.
• Experience in developing educational applications for iOS devices for training/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.
• 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 membership 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
• 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.
• 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.
• 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, Requirements Gatherer and Programmer Analyst

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 training 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