We provide IT Staff Augmentation Services!

Business Analyst Resume

3.00/5 (Submit Your Rating)

New York, NY

SUMMARY:

  • Above 12 years of experience in n tier client - server architecture, windows based, handheld, web based business application in Communications, Video Distribution, Energy Billing, Flavor and Fragrance Industry.
  • Experience in design and development of Web based Handheld and Client-server architecture.
  • Directly involved in design, development and maintenance of web based business application.
  • Understanding the client’s requirements and designing database model.
  • Implemented ADO.Net Data Access Techniques SQL Connection Objects, SQL Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List controls.
  • Experience in creating content rich Web-Forms, Win-Forms, and User Controls with Net Advantage Infragistics 2007.
  • SQL expertise in database design and database programming (Stored procedures, Triggers, Packages) using MS SQL Server 2008/2005/2000 , Oracle 9i/8i/7.x and MS Access 2000/97.
  • Experience with Source Control Management tool Visual Source Safe (VSS), Subversion.

TECHNICAL SKILLS:

Languages: VS.NET 2008 (.net 3.5/2.0/1.1), MVC 1.0,VB.NET, ADO.NET 3.5, ASP.NET, C#2008,LINQ, Visual Basic 6.0,Excel, VBA, Visual Interdev, Java Script, XML, ASP, Visual ASP (Tree View, List View, Tab Component),Ajax 2.0, Jquery,Toad for SQLServer 5.7

Software: Infragistics Net Advantage 2007, Visio 2003, Appforge, eVB, Erwin3.52, Query Analyzer, Sheridan Controls, True DB Grid Controls,SQL Navigator, PL/SQL Developer, Toad

Databases: MS Access, PL/SQL, T-SQL, Oracle 9.0i, SQL Server (2000/2005/2008 ), Idera Oracle Utilities, Import/Export, SQLServer Management Studio, SQL Loader, Sql Server DTS.

METHODLOGIES: Object Oriented Programming, MVC 1.0, UML, ETL.

REPORTING TOOLS: crystal Reports (6.5/8.0/10.0 ), SQLServer Reporting Services (2005/2008)

Servers: Small Business Server, Internet Information Server. 6.0.

Op. Systems: Windows (2000/2003/2008 ) Server, Win XP and Win CE 3.0, Windows Admin, Citrix Servers.

PROJECT MGT.:  (Agile Scrum), MDE Project Management Tools

EDI MAPPING TOOLS: Altova MapForce 8.0, Altova MapForce Server, EDI- HQ, TCPX Server,EDI Framework

PROFESSIONAL SUMMARY:

Confidential, New York, NY

Business Analyst

Environment: VS.NET 2010,C# .NET2010, SQLServer2008, SSRS, EDI Dev Framework EDI x64 .NET, Visio

Responsibilities:

  • Analysis for 811 EDI Datafile, Carrier 811 Guides, Populating the data in Invoice Header and Invoice Details and Staging Table and then Dashboard, Reports for Totals are balancing.
  • Class Library were developed Carrier: ATT Harland having BDF DataFile.
  • Class Library were developed Carrier: CentryLink with Pay Codes 0432,0E00,0W00,0C00 having Edi data files
  • SQL Scripts were written to load the data in Carrier: Sprint from Access database.
  • Class Library were developed for Carrier: Frontier, Granite, Verizon, Wind stream and Scantron having Edi data files.
  • Monthly Charges, Non Recurring Charges,Taxes,Fees data lines were loaded in the database
  • Generating Billing Account Number,Referenece Number for each Carriers
  • HL Loops having TX1 Lines SLN Datalines,IT1 Data lines were loaded in Invoice Header and Invoice Details Table
  • Build DataAccesLayer from InlineSql to Stored Procedure
  • Loading 2 months data and building Demo Server, Staging Server for Client: Harland Clarke on San Antonio Texas.
  • Carrier Status report was done on Weekly basis for each Carrier
  • Summary Grids was build for Dispute Tracker as per Status: Approved,Pending,Disputed and Total
  • Dashboards has filters for Carriers, Data Range month,year,quarter,YTD or a specific date range
  • Invoice Headers and Invoice Details can be viewed on left Panel
  • Grid Dispute Elements: Dispute#, Dispute Amount, SettleAmt, Savings Amt, Pay Amt Dispute Date.
  • Multiple Payments to an open invoice for payment.
  • SSRS Reports were developed as per business specifications and Subversion was used for Version Control

Confidential, Syosset, NY

Senior Program Analyst (Team Lead)

Environment: ASP.NET (WebForms), VS.NET2005, Vb.net, SQLServer2005, SSRS

Responsibilities:

  • Pricing Reports, CCTV,Data Communication,Hardware,IP Solutions Reports with Pricing Rate(832) Changes
  • Wrote Stored Procedures,Tables,View,CTE in SQLServer 2005 as per Business Specs
  • SSRS was used as Reporting Tool.
  • Tortoise was used as SVN Control.

Confidential

Environment: Tried VAN: Kleinschmidt Trading Partner VAN: Commerce Sterling

EDI Mapping Tools: Altova MapForce 8.0, Altova MapForce Server, TCPX Server

Database: SQLServer2005

Responsibilities:

  • Developing EDI mapping specifications and documentation to perform all EDI processes, Purchase Orders, transmission of ASN, invoices, orders (850,855,856,810) documents as required.
  • Testing, implementing and maintaining EDI transactions, developing and maintaining trading partner definitions including relevant translation objects utilizing EDI translation software tools.
  • Responsible for processing 850’s, SSRS, contacting purchasing with any EDI issues, and making corrections to orders for vendors.
  • Coordinate shipping in accordance with customer specific routing guides & requirements, so that all orders received are in the “Shipping Batch” and ready to ship.
  • Support clients and trading partners with their non-standard requests for ad hoc reports, testing analysis and other technical deliverables.

Confidential

Environment: Tried VAN: Kleinschmidt Trading Partner VAN: Eazy Link

EDI Mapping Tools: Altova MapForce 8.0, Altova MapForce Server, TCPX Server, Altova Scheduler

Database: SQLServer2005

Responsibilities:

  • Developing 832 Send, 850 Receive, 855 Send, 856 Send, 810 Send Mapping specifications and documentation to handle inbound and outbound transactions
  • Assist with EDI / Retail customer setup. Verify customer pricing and program terms on all orders received.
  • Monitor the production environment and proactively prioritize, communicate, and resolve any EDI process issues
  • Create SQL Server procedures,SSRS and optimize existing SQL code

Confidential, Uniondale, NY

Senior Software Developer (Team Lead)

Environment: ASP.NET (WebForms), Vb.net, SQLServer2008, SSRS, Visio

Responsibilities:

  • Responsible for developing for Inbound/Outbound Libraries for Confidential Transactions
  • 814 Enrollments Request, Change Request, Reinstate Request, Response Inbound Libraries were developed as per Utility Specific File Formats
  • 867 Historic Usage,810 Invoice,820 Payments Inbound/Outbound Libraries were developed
  • Developed Stored Procedures,Tables,Views,UDF Functions as per Business Specification
  • Define and capture metadata and rules associated with the ETL processes
  • Web Forms were used for Screens Design and SSRS as Reporting Tool
  • Responsible for Writing Software Requisition Specification for 248 and 568 (Contract Payments) Transactions for the State of OH,NY,MD as per file formats
  • Developed Database Diagrams, Functional Requirments,Screen Designs and Stored Procedures
  • Inbound Libraries were developed for processing 248 and 568 Transactions for OH,NY,MD
  • Billing, Payments,MeterReadings and Correspondence modules were populates as per business specification
  • Test plans were created and testing was done by QC Team

Confidential

Software Developer

Responsibilities:

  • Complete mapping and transformation documentation from Marketer to UtillBill Database
  • Scheduling the data from Excel files to SqlServer Staging Tables
  • ETL Meta Data documented (Customers,ServiceLocations,Meters,AccountBalancing,Tax Jurisdiction,Rate Classes)
  • Stored Procedure, Tables and UDF functions were written as per business specification
  • Jasime,UtiliBill has development team
  • UtiliBill Auto Bill register, Marketer Sync File, Rate Class Module were developed by India Team
  • UAT Testing was done onsite and then in production

Confidential, Watchung, NJ

Software Developer

Environment: ASP.NET, C#2005 (Web Forms), SQLServer2008, SSRS, Toad for SQLServer 5.7, JavaScript, Ajax 2.0

Responsibilities:

  • Executive Dashboard for Customer Order, Planned Order, Purchase Order, Purchase Order Line, Late Orders and Shipment details with C# WebForms
  • Ajax 2.0 Controls were used for developing WebForms.
  • Treeview, DataGrids, MultiView controls were used develop the Executive Dashboard.
  • Report Viewer Control was used to developed the SSRS Reports
  • Tables,Views,Stored Procedures were written as per business specification
  • Provide real time Formula capability to view: Accurate container-based lot inventory Current disposition in terms of status: Available, Allocated, Quarantined, Restricted, Rejected, And Expired
  • Automatic generation of Purchasing Requests. The automatic propagation through the QC, Purchasing and Scheduling forms that an item has been received.
  • Built database-driven tree menu using C#,ADO.Net objects to access data from SQL Server
  • Wrote complex stored procedures, triggers, Queries and fine-tuned the database indexes using SQL
  • Created reusable classes to format and validate data on Client Side
  • Visual Source Safe was used for Source Control

Confidential

Software Developer

Environment: C#2005 (Win Forms), SQLServer 2000, SSRS, Toad for SQLServer 5.7

Responsibilities:

  • Ingredient List, Formula List, Alcohol Drawback Claims Submitted Winforms were developed per specification.
  • Responsible for System Analysis, Designing Win Forms in C#, DAL, BO Layer providing and supports.
  • Microsoft Application Data Block was implemented for DAL.
  • Formula List, Alcohol Drawback Claims Maintenance, Formula Submitted Not Approved, Log Entries SSRS reports were generated.
  • Database Objects Tables, Views, Triggers, Stored Procedures (T-SQL) were developed as per business specification.
  • Click Once was used for deployment on Citrix Server and VSS was used for Source Control

Confidential, Avenel, NJ

Software Developer

Environment: Vb.net 2008, SqlServer2008

Responsibilities:

  • Integrating with Web services to periodic download breadcrums for Trip Details.
  • Bread Crums has vehiclename, latitude, longitude, eventdatetime, odometer details (ETL).
  • Data Mapping and Data Analysis was done with Erwin.
  • Stored Procedure was written to assign active route to bread crums.
  • Test cases were carried out for 10 Tractors/Trailers and then in production.

Confidential

Software Developer

Environment: Vb.net 2008, SqlServer 2008, C#2008

Responsibilities:

  • Periodic downloading of the csv file from Metro Fuels and Champlain Fuels.
  • Importing the data, cleansing, validation to SqlServer Database (ETL).
  • Creating a Metrofuels.dat files to import to Shopfax System.
  • Reports were generated to test the imports.

Confidential

Software Developer

Environment: Vb.net 2008, Sql Server 2008, SSRS, LINQ

Responsibilities:

  • Trips Tickets, Inbound Inspection, Outbound Inspection, Way Bills, Pay sheet were scanned as per the Act with bar codes implemented on each trip document for tracking.
  • Responsible for requirements gathering, preparing functional, technical design documents.
  • Defining, designing, and building database schema to address specific business needs.
  • Developed a Search engine (Win Forms).document as per Trip Ticket, Location, Trailer, Tractor, Driver and Workday.
  • Safety Compliance and Dispatch Operation reports were created with SSRS.
  • Email Utility was created to email documents within department with Email Objects.
  • SSIS packages were used for Alerts to monitor scanning operation with dispatch operators.
  • Stored Procedures, Tables, Views, Triggers and T-SQL were used to design back end.

Confidential

Software Developer

Environment: Vb.net 2008, SqlServer 2008, ASP.NET2008, SQLServer Reporting Services

Responsibilities:

  • Scan Operation Reports, Terminal wise, Dwell Reports, Kiosk Operation Reports
  • StoresTimeWindow Reports, Routing Reports were designed as per business needs.
  • Stored procedures were written as per business needs for reports.
  • Report Viewer was used as Reporting Services.
  • Various Views were created as per MVC design pattern.

Confidential

Software Developer

Environment: Vb.net 2008, SqlServer 2008,C#2008

Responsibilities:

  • Users, User Groups, Roles (Win Forms) were defined Security layer was designed.
  • Integrated with Active Directory of Windows 2003 Server.
  • Data Access Layer with ADO.NET 3.5 was designed
  • GeoFence Layer, Encryption, LoadAnalysis, ExporttoExcel, ZipCodeLookup, RegexBuilder class library were build.
  • Create Read Update Delete (CRUD), Image enhancements, Email Alerts base forms (Win Forms) were designed for master maintenance.
  • File System Access forms were designed.

Confidential, South Amboy, NJ

Software Developer

Environment: ASP.NET, VB.NET (VS.NET 2005), C#, SqlServer 2005, SqlServer Reporting Services

Responsibilities:

  • Responsible for designing the Report Engine from the daily data feed from ADP AIX system.
  • Responsible for requirements gathering, preparing functional, technical design documents.
  • Operational Reports, Comparative Reports were designed as per specification.
  • Created Database, Tables, Stored Procedure, Udf, Views with T- SQL.(ETL Project)
  • Reporting Screens, Admin Setup Screens were designed (Web Forms).
  • Ado.net, Dataset, Data Reader, Data Adapters were used to develop DAL.
  • System Codes, Batch Reports and Audit Reports were designed to monitor periodic feeds.
  • Coding Standards were implemented.

Confidential, Hasbrouck Heights, NJ

Sr. Developer

Environment: ASP.NET, VB.NET (VS.NET 2003), C#, Oracle 9.0, Crystal Report 10.0

Responsibilities:

  • Responsible for the design, development, rollout of new modules (Web Forms).Support, enhance existing systems.
  • Developed Web Services to update the Vendor Information, Customer Information.
  • Migrated Crystal Reports from Crystal Reports 8.5 to Crystal Reports 10.0.
  • Portfolio, Maturity reports and Quote History reports were designed as per requirements.
  • Asset Module was enhanced as per requirements.
  • Involved in Migration of Leaseworks Application from Visual Basic 6.0 to Visual Basic 2005.net.
  • Migration from ADO to ADO.NET. Experienced with Microsoft .Net technology (VB.Net) and with actual migration of VB applications to the .Net platform.
  • Infragistic Net Advantage 2007 controls are used to develop the Windows User Interface Layers (Win Forms).
  • Coordinating with DBA Team and QA team to carry out test transaction.
  • Stored Procedures, Views, Tables were created as per specification.
  • Communicating with offshore team to carry to migration of different modules.

Confidential, New York, NY

Sr. Software Programmer

Environment: ASP.NET, VB.NET, C#, SqlServer 2k

Responsibilities:

  • Responsible for gathering requirements, developing flowcharts, system navigation.
  • Involved in periodic releases of the different modules.
  • Admin module, Client Configuration, Billing and Reporting module were developed.
  • Coding Standards were implemented.
  • UAT testing and Application Development plans were carried out as per business needs.
  • Production support for the application was carried out as per business needs.

Confidential, Edison, NJ

Programmer Analyst

Environment: VB.NET, Oracle 9.0i and Crystal Report as reporting tool.

Responsibilities:

  • This Application carried out the Business process at their In Bound Call Centers and Out Bound Call centers for all Civic Customers.
  • Involved in development of WinUserInterface Layer (Win Forms), Data Access Layer, Exception Handler layer for the roles based Enterprise application.
  • Developed Queries Module, Inquiry Module, Action Module, Violation Module, Refunds Module, DNC Module, Letters Module, Playback module and Reports Module.
  • Created Refunds Email Alerts and Run Query Windows Services.
  • Developed Auto Updater Block to release the latest updates of the application.
  • Compliance Reports, Fundraiser, Campaign wise reports were created using Crystal report 9.0.
  • Production support to the application with Citrix Servers and enhanced the application as per new specs Wrote
  • PL/SQL procedures, functions, and packages as per business needs.
  • This Application was used by Compliance team to create State Fund raisers, Campaign, Call Centers, Recruiting of Operators Module, Campaign Faq., and Assignment of EIS List Modules.
  • Role level security was maintained.
  • Visual Source Safe was used for version control.

Confidential, Edison, NJ

ASP Web Application Developer

Environment: ASP, SqlServer 2K

Responsibilities:

  • Involved in migrating legacy system to Web based application to carry out the Production with ASP as front end and SQLServer2K as back end.
  • Responsible to write Software Requisition Specification, developing prototype and database model using Erwin.
  • Developed Production Module, Invoicing Module,FactoryOperations,Reporting Module as per business requirements.
  • Use Case and Test plans were written for stored procedure and ASP page.
  • UAT and Application deployment plans were carried out as per business needs.

Confidential, Melville, NY

Consultant

Environment: ASP and Oracle 8.0i

Responsibilities:

  • Designed, coded, tested and implements application systems using programming languages ASP as the front end and Oracle 8.0i at Back end as demanded by the project.
  • Enhanced Promotion Module, Seasonal Gift & Collateral Collections modules were developed with best program efficiency, performance, security and time completion.
  • Writing stored procedure, views packages to maintain business logic at the back end.
  • Riya Group of Companies is a conglomerate of business units, which manages entire customer/client for Riya Imports, Riya Consumer Services.
  • Entire application was developed using ASP and Sql Server 2000 as back end using ASP, JavaScript.
  • Communicated with the managers and prepared functional requirements. Participated in the entire full-life cycle development process including design, analysis, and requirements gathering technical development.
  • Created the database for the application in Sql Server 2k.
  • Developed all front ends to keep track of every functional operation with all validations.
  • Various reports were made which were send to El Paso and State of CT on daily basis.
  • Quality assurance module was made to keep the log of scanning function.
  • Reviewed, analyzed, and modified programming systems including encoding, testing, debugging programs. Analyzed software requirements to determine feasibility of design within time constraints.
  • Involved in creation of database, users, roles, tables, views, index, stored procedure, views and used Erwin for create database model.
  • Designs/codes layouts, graphical user interfaces, printed outputs & interface the systems.
  • Test transactions and runs tests to find errors and confirm program meets user specifications.
  • Backup, restore and maintain the SqlServer database, indexing the tables, maintaining database log, transaction log.
  • Migrated raw data from access to SqlServer 2000 in proper normalized format.
  • Operational Reports and Executive Reports were made as per requirement.
  • Periodic back up of data using Veritas Back-up Exec. For Sql Server.

We'd love your feedback!