Business Analyst Resume
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 DeveloperResponsibilities:
- 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 DeveloperEnvironment: 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 DeveloperEnvironment: 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 DeveloperEnvironment: 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 DeveloperEnvironment: 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 DeveloperEnvironment: 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 DeveloperEnvironment: 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.