PROJECTS

   HERE YOU WILL FIND SOME MSBI PROJECTS TO KEEP IN RESUME [SAMPLES]

   ATTEND PROJECT SESSIONS AT VINAYTECHHOUSE[FREE CLASSES].
   VINAYTECH OFFERS EXCLUSIVE PROJECT CLASSES IN VARIOUS DOMAINS [PAID PROJECTS].
   CONTACT AT RECEPTION FOR MORE DETAILS [04066638869 /9573168449]


   SSIS PROJECT [BANKING] DESCRIPTION, SSIS RESPONSIBILITIES ADDING IN RESUME. 

Project Title
ICDW (Integrated Customer Data Warehouse)
Application Title
BankBatchDetails Load
Client
E-Trade Financial, New York,NY
Role       
SSIS Developer
Team Size
5
Environment
Windows, MSBI Suite SSIS , SqlServer, Oracle, Files (Flat,Excel)
Description





















Responsibilities 
Bank E-Trade has a small benefits process that sells several niche products to other small business owners. They offer these products directly to the employees of the small businesses, but the employers are billed, rather than the employees. These payments are then submitted back to Company E-Trade in a lump sum, but because of timing issues and ever-changing worker populations, the payment doesn’t always match the billed amount. Customers have the option to pay invoices using one of the  payment methods a) PayPal or an e-mail payment service b)By Check c) BY Wire. Working with the low-quality payment data involves a significant amount of manual labor to match
payments to customers and invoices. Because Company E-Trade  is growing, the volume of payments is exceeding its capacity to continue to process payments manually. If the invoice number were always received with the payment, an automated process could easily identify the customer from the invoice
and make some decisions about the payment by comparing the paid and billed amounts. SSIS is used with various transforms to process the business data.
  • Understanding Business Information documents regarding Customer  payments and Invoice.
  • Working on High Level Design and Data Flow Designs to create package.
  •  Using various transforms such as Lookup, Derived, OLEDB Command, Sort, Conditional Split, script Component ,Character Map ,Import  column etc…
  • Using various tasks such as Script, Execute SQL ,Data Flow and File System and containers such as For each loop and Sequence containers.
  • Script task used to identify file size, assigning and reading values from variables.
  •  Execute sql is used to work with procedure and return values.
  • Using various precedence constraints’ between tasks to process correct records and wrong records.
  • Using File system task to move or create processed or error files and folders.
  • Implemented Optimization steps wherever applicable
  • Used parameters inside package for dynamically changing  requirements.
  • Tested thoroughly by writing Unit Test cases.

         


Project Title
MEDW (Merchandise Enterprise Data Warehouse)
Application Title
MaxMin Datamart
Client
Role       
Report Developer
Team Size
5
Environment
Windows,  SSRS, SqlServer, Oracle, Files
Description
·         A*M*S*I manufactures products to create outdoor landscape scenes for dollhouses, railroad displays, dioramas, world iconic and model crafting. Everything from ground cover to tree armatures in various raw materials. Business driven through three channels(Online, Retailer and Direct outlet).Company strategic analysis expecting a better decision making system across all these channels for effective growth and made a MEDW.SSRS used here to present different types of reports in various visualizations.



Responsibilities:

·    1. Working closely with customer to gather requirements and understand business                 analysis need.
      2.  Working on Design and Code documents before working on reports.
      3.  Created and manipulated simple, medium and complex reports with various       
            visualizations.
      4.  Implemented drill down, drill through  and sub reporting wherever applicable
      5.  Written many RDL expressions to implement business logics.
      6.  Followed company standards and optimization document during implementation
      7.  Worked on small dash boards with various regions
      8.  Tested report with appropriate test cases before delivering to QA.





No comments:

Post a Comment

Note: Only a member of this blog may post a comment.